Running oracle script as oracle user from a shell script that runs as root

Question

I have a shell script that runs as root. I want the script to switch to oracle user, run sqlplus and run some .sql files. I am trying to followung :

su - oracle << -EOF1  2>&1
        sqlplus $user/$password << -EOF2
                @oracle.sql;
                @quartz.sql;
        EOF2
EOF1

first of all i get stty: standard input: Inappropriate ioctl for device what does it mean ?

second, can someone explain to me how the redirect (should) work in this case ?

Thanks

fge · Accepted Answer · 2011-12-21 10:09:32Z

2

Use:

if [ "$(id -un)" -eq "root" ]; then
    exec su - oracle -c $0
fi

sqlplus <<EOF
blablabla
EOF

If your script potentially takes arguments, the solution will differ.

What this does it checking whether the user running is currently root. If so, it re-executes the script ($0) as user oracle instead.

But BTW, why does the script run as root in the first place?

edited Dec 21, 2011 at 10:09

answered Dec 21, 2011 at 9:40

fge

122k35 gold badges266 silver badges340 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

Michael Over a year ago

i agree running the script as root is a very bad practice, but i have no choice since the infrastructure that runs the script is running as root. Changing it is not my call

Michael Over a year ago

so what does your solution do exactly ?

Michael Over a year ago

I see. nice trick, unfortunately, there are some parts of the script that i need to be running as root (this is not the whole script, there are other parts). therefore i have to use the EOF block structure. my scrip could also have arguments as well

fge Over a year ago

Make the Oracle specific parts run in another script which you invoke like the above?

fge Over a year ago

Also, please note that heredoc markers MUST be at the beginning of line

user3073309 · Accepted Answer · 2014-02-28 08:55:34Z

0

su - oracle -c " echo 'select 1 from dual; select 2 from dual;'| sqlpus / as sysdba "

if contain ' using following su - oracle -c " echo \"select 1 from dual; select 2 from dual;\" | sqlpus / as sysdba "

answered Feb 28, 2014 at 8:55

user3073309

1862 silver badges5 bronze badges

Collectives™ on Stack Overflow

Running oracle script as oracle user from a shell script that runs as root

2 Answers 2

5 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

5 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related