topic Re: Asking for user password while running a script in Operating System - Linux

Asking for user password while running a script

Mohd Azril Dollah — Thu, 08 Mar 2007 00:38:58 GMT

I'm creating a script to auto start my oracle listener and open a startup the database automatically. Below is the script

#!/bin/sh
su -oracle
export ORACLE_HOME=/cramerapps/oracleAS
echo $ORACLE_HOME
export ORACLE_SID=asdb
lsnrctl start
sqlplus "sys/syspassword @ asdb as sysdba" <startup
exit
EOF
~

But after executing, the script will prompt for oracle password. How to skip the password prompt? How can i put the password into the script??

Re: Asking for user password while running a script

Steven E. Protter — Thu, 08 Mar 2007 00:47:21 GMT

Shalom,

http://www.orafaq.com/forum/t/37241/0/

http://www.adp-gmbh.ch/ora/misc/read_sql_from_shell_script.html

http://www.dbasupport.com/forums/archive/index.php/t-8424.html

http://www.unix.com/showthread.php?t=17437

SEP

Re: Asking for user password while running a script

Sundar_7 — Thu, 08 Mar 2007 11:53:27 GMT

Why do you even need to su ? Are you not executing the script as user "oracle" ?

Re: Asking for user password while running a script

linuxfan — Thu, 08 Mar 2007 12:44:59 GMT

Hi,

Who will be executing this script?

If root is running it then you don't need a password. If a non-root user is running the script then one of the option is to to setup sudo.

Re: Asking for user password while running a script

Mohd Azril Dollah — Thu, 08 Mar 2007 20:23:37 GMT

the script run by user root. but the command is only applicable for user oracle. How to use sudo?

Re: Asking for user password while running a script

SANTOSH S. MHASKAR — Fri, 09 Mar 2007 02:38:31 GMT

Hi,

Firstly OS password cannot be embedded in scripts,
Also if oracle user is (which I assume as oracle software owner and oracle db release >= 9i) script owner, then no
need to provide sys/syspasswd

U can do like this,

login as oracle

create ur script say Start_db_lsnr.sh as

!# /usr/bin/ksh

export ORACLE_HOME=/cramerapps/oracleAS
export ORACLE_SID=asdb
$ORACLE_HOME/bin/lsnrctl start
$ORACLE_HOME/bin/sqlplus "/as sysdba" <startup
exit
EOF

if root is invoking this script then use

# su - oracle -c

for any other user use sudo to give access for this script to
other users

http://hpux.connect.org.uk/hppd/hpux/Sysadmin/sudo-1.6.8p12/

for this u have to configure /etc/sudoers using visudo command as root

# visudo

..

...

= (oracle) NOPASSWD:
..
..

save and exit

now login as and execute as

sudo

- Santosh