I can try connecting to database and check if it fails. But honestly, I
do not like this idea... but I am afraid there may not be other
options.
>>> "Patterson Joel "
<oracledba-ezmlmshield-x72864637.[Email address protected] 08/31/05 10:03
AM >>>
Log in select 'DATABASE UP' from dual;
From unix then, grep for DATABASE UP in your spool file.
This tests DB and listener -- after all if either is down, users are
jumpy.
(or windows --- (user OEM))
-----Original Message-----
From: Declan Heerey
[mailto:oracledba-ezmlmshield-x86963097.[Email address protected]
Sent: Wednesday, August 31, 2005 12:43 PM
To: LazyDBA Discussion
Subject: RE: Is it possible to check database status from a remote
host?
Are you using Unix ?
-----Original Message-----
From: Anand Prakash
[mailto:oracledba-ezmlmshield-x30784051.[Email address protected]
Sent: 31 August 2005 17:39
To: LazyDBA Discussion
Subject: Is it possible to check database status from a remote host?
Is it possible to check database status from a remote host? I thought
of
tnsping as an option but it would return me "success" if listener is
up
but database is down.
Any ideas?
Anand Prakash
"MMS <firsthealth.com>" made the following annotations.
------------------------------------------------------------------------
------
This message, including any attachments, is intended solely for the
use
of the named recipient(s) and may contain confidential and/or
privileged
information. Any unauthorized review, use, disclosure or distribution
of this communication(s) is expressly prohibited. If you are not the
intended recipient, please contact the sender by
reply e-mail and destroy any and all copies of the original message.
========================================================================
======
--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
_____________________________________________________________________
This e-mail has been scanned for viruses by MCI's Internet Managed
Scanning Services - powered by MessageLabs. For further information
visit http://www.mci.com
_____________________________________________________________________
This e-mail has been scanned for viruses by MCI's Internet Managed
Scanning Services - powered by MessageLabs. For further information
visit http://www.mci.com
--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
"MMS <firsthealth.com>" made the following annotations.
------------------------------------------------------------------------------
This message, including any attachments, is intended solely for the use of the named recipient(s) and may contain confidential and/or privileged information. Any unauthorized review, use, disclosure or distribution of this communication(s) is expressly prohibited. If you are not the intended recipient, please contact the sender by
reply e-mail and destroy any and all copies of the original message.
==============================================================================
Oracle LazyDBA home page