RE: Checking that the instance is up

Mark, Raj -

Thank you both for coming back on that request of mine so promptly - I feel that I have a surfeit of riches!

peter
edinburgh

> -----Original Message-----
> From: Mark Leith [mailto:mark_at_cool-tools.co.uk]
> Sent: Thursday, December 18, 2003 2:54 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Checking that the instance is up
>
>
> Hi Peter,
>
> I remember the thread, but couldn't remember the subject line at all..
>
> Having had this discussion countless times in the past,
> here's what I would
> opt for:
>
> The best way to make sure that an instance is alive and
> running would be to
> do a full connection to that instance, and run a simple piece
> of sql - such
> as "select 'PING' from dual;". This makes sure that both the
> listener, and
> instance are both up and readily accepting connections.
>
> You can also monitor for the listener status separately, based upon a
> "TNSPING <SID>" command, that will alert simply to the status of the
> listener.
>
> We do both of these with our monitoring tool, and generate
> ENTITY_DOWN and
> NETWORK_DOWN alerts respectively. If you get both an ENTITY_DOWN and
> NETWORK_DOWN error message at the same time, then this helps
> to point you at
> the listener quicker than trying to diagnose why the instance
> is down. If
> you just get an ENTITY_DOWN message on it's own, then it points to a
> database based problem.
>
> You should also try and catch the error messages on a
> failure, and flag
> those in your warning messages.
>
> And of course, there is the point of monitoring the monitor.
> You should have
> some process in place that is making sure that the monitor is
> up and running
> correctly. Whether this be a date/timestamp placed in to a
> log file with
> every successful "ping", or making sure a cron/AT job is running etc.
> depends on how you do this..
>
> Of course, you could buy a tool that already does all of this.. ;)
>
> HTH
>
> Mark
>
>
>
>
> -----Original Message-----
> Robson, Peter
> Sent: 18 December 2003 13:59
> To: Multiple recipients of list ORACLE-L
>
>
> Folks -
>
> Some months ago there were exchanges on the optimum way to
> check that an
> instance was alive.
>
> I have searched, hunted and generally scavenged for these
> exchanges, but
> without luck.
>
> Can anyone give me the subject line, and I can turn again to
> the archive?
>
> thanks,
>
> peter
> edinburgh
>
>
> *********************************************************************
> This e-mail message, and any files transmitted with it, are
> confidential and intended solely for the use of the addressee. If
> this message was not addressed to you, you have received it in error
> and any copying, distribution or other use of any part of it is
> strictly prohibited. Any views or opinions presented are solely those
> of the sender and do not necessarily represent those of the British
> Geological Survey. The security of e-mail communication cannot be
> guaranteed and the BGS accepts no liability for claims arising as a
> result of the use of this medium to transmit messages from or to the
> BGS. . http://www.bgs.ac.uk
> *********************************************************************
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Robson, Peter
> INET: pgro_at_bgs.ac.uk
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
> ---
> Incoming mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.547 / Virus Database: 340 - Release Date: 02/12/2003
>
> ---
> Outgoing mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.547 / Virus Database: 340 - Release Date: 02/12/2003
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Mark Leith
> INET: mark_at_cool-tools.co.uk
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Robson, Peter
  INET: pgro_at_bgs.ac.uk

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).