Re: How to know Oracle Down ?

the only way to make sure oracle is up/down is to connect to the database.

the listener could be up but that doesnt prove anything at the dblevel.

joe
Peter McLarty wrote:
>
> Other than using some third party tool you might like to use either a
> windows or Perl script to poll the listener and see if it can connect to
> the instance. and that would send you an alert of some kind
> I thought someone had posted one in the past but I don't seem to have a
> copy in my stored email
>
> HTH
> Peter
>
> At 04:55 PM 31/07/2001, you wrote:
> >Hi Xperts,
> >
> >Platform is Windows NT Server SP-6 , Oracle Enterprise Edition 8.1.6
> >
> >Question:
> >
> >1. How do I know before someone tells me that Oracle is down ( e.g. in Unix
> >we check dbw process )
> >
> >2. If Oracle is Down , Why ? means which file should be looked for the
> >possible causes.
> >
> >
> >Thanks,
> >Harsh
> >--
> >Please see the official ORACLE-L FAQ: http://www.orafaq.com
> >--
> >Author: Harsh Agrawal
> > INET: HARSHA_at_Amdocs.com
> >
> >Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> >San Diego, California -- Public Internet access / Mailing Lists
> >--------------------------------------------------------------------
> >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.com
> --
> Author: Peter McLarty
> INET: peter.mclarty_at_incts.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> 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)

-- 
Joe Testa  
Performing Remote DBA Services, need some backup DBA support?
For Sale: Oracle-dba.com domain, its not going cheap but feel free to
ask :)
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Joe Testa
  INET: teci_at_the-testas.net

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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).