Re: /etc/init.d/dbora stop hangs

On Jan 10, 2:39 am, ton de w <ton_de_win..._at_yahoo.co.uk> wrote:
> 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

Do you have any "intelligent" agents? Add a ps -ef|grep ora to the beginning of the script. Add a select from v$session script too. Maybe you need to change the dbshut to startup force/shutdown or shutdown immediate.

jg

--
@home.com is bogus.
http://www.nytimes.com/2008/01/10/technology/10cnd-chip.html?_r=2&ref=technology&oref=slogin&oref=slogin