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

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? Received on Thu Jan 10 2008 - 09:24:35 CST