RE: Unix script to check database status

  • From: Michael Milligan <Michael.Milligan@xxxxxxxxxxx>
  • To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
  • Date: Tue, 9 Mar 2004 15:32:32 -0600

Dick,

I would love to look at it if you would send it to me.

Thanks,

Mike

michael.milligan@xxxxxxxxxxx

-----Original Message-----
From: Goulet, Dick [mailto:DGoulet@xxxxxxxx]
Sent: Tuesday, March 09, 2004 2:27 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: RE: Unix script to check database status


Michael,

        Well, I don't have a script to do that, I wrote a Pro*C program that
does that & a ton more, in less than a minute per db, normally.  Your
welcome to that if it would meet your needs.  BTW: It e-mails & pages with
all kinds of stuff too.  Currently it runs on Windows so that it acts like a
real client.

Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA

-----Original Message-----
From: Michael Milligan [mailto:Michael.Milligan@xxxxxxxxxxx]
Sent: Tuesday, March 09, 2004 3:30 PM
To: 'oracle-l@xxxxxxxxxxxxx'
Subject: Unix script to check database status


Hi,

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?

Thanks,

Mike


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