RE: Unix script to check database status
- From: Michael Milligan <Michael.Milligan@xxxxxxxxxxx>
- To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 11 Mar 2004 17:14:01 -0600
I thought of that, too, but if the database can not get at least to a
startup nomount state, this would fail. If the initsid.ora file got deleted,
for example. Good idea though.
Thanks,
Mike
-----Original Message-----
From: Kevin Lange [mailto:klange@xxxxxxxxxx]
Sent: Thursday, March 11, 2004 3:05 PM
To: 'oracle-l@xxxxxxxxxxxxx'
Subject: RE: Unix script to check database status
Why not simply write a query that gets ran by OS that selects the status and
logins from v$instance. You should be able to parse that simple enough.
-----Original Message-----
From: Jacques Kilchoer [mailto:Jacques.Kilchoer@xxxxxxxxx]
Sent: Thursday, March 11, 2004 2:29 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: RE: Unix script to check database status
If you try a bogus userid/password and use the ORA-1017 as "proof" that the
database is up, you wouldn't know if the database is in restricted session
mode. (Something that has burned me before.) I personally think the best way
for verifying that the database is up is to create a session (create a
userid that only has "create session" privilege and use that for
verification.
> -----Original Message-----
> testa@xxxxxxxxxx
>
> Mike, make your script attempt to login into the database(even with a
> bogus userid/password),
>
> you get a ORA-1017 invalid userid/password, you know the
> database is up
> and you got a connection to it.
>
> Joe
>
>
> > I have to write an HP-UX Korn shell script to check the status of 20
> > databases - up or down - and send an email if any are down. I'm a
> > relative newbie at Unix. I'm not asking anyone to "do it
> for me", but
> > does anyone know of any scripts to check database status by
> greping or
> > otherwise looking at the oratab or other file and checking
> the status?
> >
> > Mike
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
This e-mail, including attachments, may include confidential and/or
proprietary information, and may be used only by the person or entity to
which it is addressed. If the reader of this e-mail is not the intended
recipient or his or her authorized agent, the reader is hereby notified that
any dissemination, distribution or copying of this e-mail is prohibited. If
you have received this e-mail in error, please notify the sender by replying
to this message and delete this e-mail immediately.
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
