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

On Jan 10, 9:24 am, 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?- Hide quoted text -
>
> - Show quoted text -

That is correct.

How long do you let this script run before killing the shutdown? What do you find in your alert log? You've provided very little, if anything, to base a determination upon.

David Fitzjarrell Received on Thu Jan 10 2008 - 09:36:57 CST