topic How to detect Oracle db is in process of shutting down in Operating System - HP-UX

How to detect Oracle db is in process of shutting down

Frank de Vries — Tue, 07 Feb 2006 09:54:53 GMT

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

Re: How to detect Oracle db is in process of shutting down

Bharat Katkar — Tue, 07 Feb 2006 09:57:04 GMT

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,

Re: How to detect Oracle db is in process of shutting down

Luk Vandenbussche — Tue, 07 Feb 2006 10:01:39 GMT

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

Re: How to detect Oracle db is in process of shutting down

Frank de Vries — Tue, 07 Feb 2006 10:19:31 GMT

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 ?

Re: How to detect Oracle db is in process of shutting down

TwoProc — Tue, 07 Feb 2006 10:39:41 GMT

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...

Re: How to detect Oracle db is in process of shutting down

Arunvijai_4 — Tue, 07 Feb 2006 11:04:27 GMT

Hi Frank,

Will this be helpful ?

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

-Arun

Re: How to detect Oracle db is in process of shutting down

Simon Wickham_6 — Tue, 07 Feb 2006 11:37:18 GMT

Hi,

Simply tail your alert log.

Regards,
Simon

Re: How to detect Oracle db is in process of shutting down

rariasn — Wed, 08 Feb 2006 02:29:23 GMT

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

Re: How to detect Oracle db is in process of shutting down

Jakes Louw — Wed, 08 Feb 2006 04:26:06 GMT

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).

Re: How to detect Oracle db is in process of shutting down

Eric Antunes — Wed, 08 Feb 2006 04:27:23 GMT

Hi Frank,

Yes there is:

SQL>select shutdown_pending from v$instance;

Best Regards,

Eric Antunes

Re: How to detect Oracle db is in process of shutting down

Arturo Galbiati — Wed, 08 Feb 2006 04:38:00 GMT

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

Re: How to detect Oracle db is in process of shutting down

Nguyen Anh Tien — Wed, 08 Feb 2006 04:39:21 GMT

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

Re: How to detect Oracle db is in process of shutting down

Frank de Vries — Wed, 08 Feb 2006 04:40:02 GMT

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