RE: Unix script to check database status

  • From: Peter.McLarty@xxxxxxxxxx
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Wed, 10 Mar 2004 13:16:38 +1000

I wouldn't mind a copy of that Program

Cheers


--
=================================================
Peter McLarty               E-mail: Peter.Mclarty@xxxxxxxxxx
Technical Consultant        WWW: http://www.mincom.com
APAC Technical Services     Phone: +61 (0)7 3303 3461
Brisbane,  Australia        Mobile: +61 (0)402 094 238
                            Facsimile: +61 (0)7 3303 3048
=================================================
"Whatever you can do or dream you can, begin it. 
Boldness has genius, power and magic in it, begin it now."
Goethe 1749 -1832 
=================================================
Mincom "The People, The Experience, The Vision"

=================================================

This transmission is for the intended addressee only and is confidential 
information. If you have received this transmission in error, please 
delete it and notify the sender. The contents of this e-mail are the 
opinion of the writer only and are not endorsed by the Mincom Group of 
companies unless expressly stated otherwise. 





"Goulet, Dick" <DGoulet@xxxxxxxx> 
Sent by: oracle-l-bounce@xxxxxxxxxxxxx
10/03/2004 05:27 AM
Please respond to
oracle-l@xxxxxxxxxxxxx


To
<oracle-l@xxxxxxxxxxxxx>
cc

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 transmission is for the intended addressee only and is confidential 
information. If you have received this transmission in error, please notify the 
sender and delete the transmission. The contents of this e-mail are the opinion 
of the writer only and are not endorsed by the Mincom Group of companies unless 
expressly stated otherwise.

JPEG image

Other related posts: