Re: su - oracle -c "script"

  • From: "Joe Smith" <joe_dba@xxxxxxxxxxx>
  • To: stephenbooth.uk@xxxxxxxxx
  • Date: Thu, 11 Aug 2005 16:13:21 -0500

This is logging in now, but not running the sql script:


ROOT@host# more test.ksh
#!/bin/ksh
su - oracle -c '/apps/oracle/product/9.2/bin/sqlplus "/ as sysdba"' @/apps/oracle/select_users.sql

ROOT@host# ./test.ksh
SQL*Plus: Release 9.2.0.6.0 - Production on Thu Aug 11 21:11:41 2005

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.


Connected to:
Oracle9i Enterprise Edition Release 9.2.0.6.0 - 64bit Production
With the Partitioning and OLAP options
JServer Release 9.2.0.6.0 - Production

SQL>


I have used ' ' and " " around the script, but it is still not running the script, its logging in though!

thanks.

On 11/08/05, Joe Smith <joe_dba@xxxxxxxxxxx> wrote:
> I am trying to run this cmd as root from a shell script:
>
> su - oracle -c /apps/oracle/product/9.2/bin/sqlplus /nolog
> @/apps/oracle/select_user.sql
>
> output:
>
> SQL*Plus: Release 9.2.0.6.0 - Production on Thu Aug 11 20:06:45 2005
>
> Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.
>
> Enter user-name:
>

I do something similar but the call to SQL*Plus is in a script, i.e.

su - oracle -c ./myscript.sh

where, in this case, myscript.sh would be

-------------------------------------------
#!/usr/bin/ksh

sqlplus /nolog <<EOF
@/apps/oracle/select_user.sql
EOF
--------------------------------------------

Have you tried doing that.  I'd guess that what's happening is that
the su command is interpreting the /nolog as a separate attribute.  If
you really don't want to encapsulate the call to SQL*Plus in a script
then try putting it in quotes:

su - oracle -c '/apps/oracle/product/9.2/bin/sqlplus /nolog'

Stephen

--
It's better to ask a silly question than to make a silly assumption.

_________________________________________________________________
Don?t just search. Find. Check out the new MSN Search! http://search.msn.click-url.com/go/onm00200636ave/direct/01/

--
//www.freelists.org/webpage/oracle-l

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 08-2005