/etc/init.d/dbora stop hangs

From: ton de w <ton_de_winter_at_yahoo.co.uk>
Date: Thu, 10 Jan 2008 02:39:20 -0800 (PST)
Message-ID: <deaf4692-42f4-4251-a1e9-99e88f35dbfe@f47g2000hsd.googlegroups.com>


Hello,
Have 9i on RedHat 3.8 and if I carry out a dbors stop it hangs.

[root_at_carbon init.d]# ./dbora stop

SQL*Plus: Release 9.2.0.4.0 - Production on Thu Jan 10 11:29:34 2008

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

SQL> Connected.
SQL>
//hangs here
SQL> quit

ORA-01013: user requested cancel of current operation // hangs here
SQL> Disconnected from Oracle9i Release 9.2.0.4.0 - Production // but responds to a ctrl-c
JServer Release 9.2.0.4.0 - Production
Database "HIST2" shut down.

LSNRCTL for Linux: Version 9.2.0.4.0 - Production on 10-JAN-2008 11:35:04

Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost) (PORT=1521)))
The command completed successfully

SQL>
// so the db has shut down, but I am concerned that I dont get the root prompt back.

What can I do to investigate this?

dbora script below:

ORA_HOME=/u01/app/oracle/product/9.2.0
ORA_OWNER=oracle

if [ ! -f $ORA_HOME/bin/dbstart ]
then

    echo "Oracle startup: cannot start"
    exit
fi

case "$1" in

    'start')

# Start the Oracle databases:
# The following command assumes that the oracle login
# will not prompt the user for any values

        su - $ORA_OWNER -c "$ORA_HOME/bin/lsnrctl start"
        su - $ORA_OWNER -c $ORA_HOME/bin/dbstart
        ;;
    'stop')

# Stop the Oracle databases:
# The following command assumes that the oracle login
# will not prompt the user for any values
su - $ORA_OWNER -c $ORA_HOME/bin/dbshut su - $ORA_OWNER -c "$ORA_HOME/bin/lsnrctl stop" ;;

esac

TIA Ton Received on Thu Jan 10 2008 - 04:39:20 CST

Original text of this message