How to detect Oracle db is in process of shutting down

[Frank de Vries]

I would like to know if there is a nice
way to check if db is in process of shutting
down.

I know of one , that is just trying to
log in and receive the ORA error.

But I would like to find other ways as well
for example check an internal table to see what
the status is ?

Any other 'good' ideas of course welcome

[Bharat Katkar]

If that is under the MCSG package control you can always have a look at package log file.

# tail -f /etc/cmcluster/pkgxx/logfile

Regards,

[Luk Vandenbussche]

Hi Frank,

Check the alert.log of your instance.

Normaly it is in $ORACLE_BASE/admin/$instance/bdump

The name can also be alert_instance.log

[Frank de Vries]

Handy points
I found this in the log


Shutting down instance (immediate)
License high water mark = 17
Sun Feb 5 10:20:23 2006
SHUTDOWN: waiting for logins to complete.

I am puzzled because normally on sunday
there is no activity,
so why is it waiting for logins to complete ?

[TwoProc]

Frank,

Old, idle connections will do that to you, as well as "up" Apache servers with plsql components for example. Processes that sit around do queue management will regularly have to wake up every so often and see if there is new work process, etc. so that they will have to remain connected.

A full Oracle system with nothing going on rarely has absolutely nothing going on...

[Arunvijai_4]

Hi Frank,

Will this be helpful ?

http://forums.dbasupport.com/forums/showpost.php?p=223460&postcount=3

-Arun

[Simon Wickham_6]

Hi,

Simply tail your alert log.

Regards,
Simon

[rariasn]

Hi Frank,

more $ORACLE_LOG/$ORACLE_SID/alert*.log

CONECTS=$(ps -ef|grep -i oracle$ORACLE_SID|grep LOCAL=NO|grep -v grep|awk '{print $2}')
kill -9 $CONECTS

ran

[Jakes Louw]

I think that "select * from V$STATUS" might do the job (I think that's the view in question: I don't have a Data Dict listing with me).

[Eric Antunes · Accepted solution]

Hi Frank,

Yes there is:

SQL>select shutdown_pending from v$instance;

Best Regards,

Eric Antunes

[Arturo Galbiati]

hi,
I suggest:
alter system checkpoint
shutdown abort
startup restrict
shutdown immediate

In this way you will baort all teh sessions connected but making a sutdown immediate as wel you will clean all the momeries, falf, etc.

Of course you must ahve a user with restricted session privilege to perform this.

HTH,
Art

[Nguyen Anh Tien]

check by issuing command:
#ps -ef|grep ora
HTH
tienna

[Frank de Vries]

Thanks for input,
it helped me to build the complete picture,
and not to overlook the obvious.