Re: su - oracle -c "script"

From: Joe Smith <joe_dba_at_hotmail.com>
Date: Thu, 11 Aug 2005 16:24:59 -0500
Message-ID: <BAY107-F26ABA9715B3C6DC5AD82C597BD0@phx.gbl>

This works:

ROOT_at_host# vi test.ksh
"test.ksh" 3 lines, 120 characters
#!/bin/ksh
su - oracle -c '/apps/oracle/product/9.2/bin/sqlplus "/ as sysdba"' < /apps/oracle/select_users.sql

USE OF THIS SYSTEM CONSTITUTES CONSENT TO MONITORING FOR THESE PURPOSES. You have new mail.

stty: : Inappropriate ioctl for device
stty: : Inappropriate ioctl for device
stty: : Inappropriate ioctl for device

SQL*Plus: Release 9.2.0.6.0 - Production on Thu Aug 11 21:23:23 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> Connected.
SQL> SQL> 2

USERNAME                       DEFAULT_TABLESPACE
------------------------------ ------------------------------
SYS                            SYSTEM
SYSTEM                         SYSTEM

18 rows selected.

SQL> Disconnected from 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
ROOT_at_host# id
uid=0(root) gid=0(root)
ROOT_at_host#

When I direct the sql script in with < the sql script runs. What does "stty: : Inappropriate ioctl for device" mean? Do I need to worry about it?

thanks.

>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

---

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

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

Received on Thu Aug 11 2005 - 16:27:26 CDT