Re: su - oracle -c "script"

From: stephen booth <stephenbooth.uk_at_gmail.com>
Date: Thu, 11 Aug 2005 21:41:00 +0100
Message-ID: <687bf9c4050811134117c579d@mail.gmail.com>

On 11/08/05, Joe Smith <joe_dba_at_hotmail.com> 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.
--
http://www.freelists.org/webpage/oracle-l

Received on Thu Aug 11 2005 - 15:43:15 CDT