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

On Jan 10, 5:24 pm, ton de w <ton_de_win..._at_yahoo.co.uk> wrote:
> On 10 Jan, 13:29, vitalis..._at_gmail.com wrote:
>
> > On Jan 10, 12:39 pm, 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
>
> > dbshut reads /etc/oratab
> > Check in /etc/oratab whether your database is set up correctly.- Hide quoted text -
>
> > - Show quoted text -
>
> OK good point!
>
> [root_at_carbon]$ cat /etc/oratab
> ...
> #
> *:/u01/app/oracle/product/9.2.0:N
> HIST2:/u01/app/oracle/product/9.2.0:Y
>
> Looks good to me!
> Maybe if it was baad /etc/init.d/dbora start would not work?

Have you checked the alert_<SID>.log file?

If you run directly $ORACLE_HOME/bin/dbshut with your oracle user, does the same happen?
And if you execute manually "shutdown immediate" in sqlplus after connecting with sqlplus "/ as sysdba" ? Received on Thu Jan 10 2008 - 09:32:08 CST