topic Re: root su - oracle prompts for password ?? in Operating System - Linux

root su - oracle prompts for password ??

MikeL_4 — Thu, 14 May 2009 17:49:23 GMT

I have the Oracle startup/shudown script in /etc/init.d: -rwxr-x--- 1 oracle dba 930 May 14 12:57 /etc/init.d/dbora

But when the server is rebooted, it prompts for a password when trying to start up oracle:

ORACLE_HOME=/opt/oracle/product/10.2.0.4
ORA_OWNER=oracle
#
case "$1" in
'start')
# Start the Oracle databases:
# The following command assumes that the oracle login
# will not prompt the user for any values
touch /var/lock/subsys/dbora
sleep 120
su - $ORA_OWNER -c "$ORACLE_HOME/bin/dbstart $ORACLE_HOME"
;;

when I try to su - oracle from command line I get right in as expected....

Re: root su - oracle prompts for password ??

Ivan Ferreira — Thu, 14 May 2009 18:52:54 GMT

I would try setting root:root as the owner of the script.

I don't know why you have a "sleep 120" after a touch command.

Please add the following command:

id > /tmp/dbora.$$

To check the user credentials that is running the init script.

Re: root su - oracle prompts for password ??

Steven E. Protter — Fri, 15 May 2009 02:09:45 GMT

Shalom,

Could be the pam configuration is preventing su - logins.

SEP

Re: root su - oracle prompts for password ??

MikeL_4 — Sat, 16 May 2009 23:03:24 GMT

Thanks for input, but in testing this was a false alarm.... DBA wasn't giving the entire store, and actually the su is working correctly..