RE: Perl script to verify DB is up.

We have unix/sqlplus scripts that check to see if pmon is running and the listener is running. But we have found that that isn't enough. We are in the process of adding a dummy user and table to each instance. The monitoring script will actually do an sql query to the instance as the dummy user to retreive a record from the table. If it works it means the server, instance and listener are all up and working. We have the scripts scheduled through cron to run every 15 minutes.

Ron Smith
Database Administration
rlsmith_at_kmg.com

-----Original Message-----
From: Mabry, Jennifer [mailto:jennifer.mabry_at_gwl.com] Sent: Wednesday, June 21, 2000 10:12 AM
To: Multiple recipients of list ORACLE-L Subject: Perl script to verify DB is up.

Hello all,

I and my group are pretty new DBA's and have a question for you all.

Do any of you have a UNIX Perl script that monitors each of your instances to verify the DB is up? If not, pages you?

Also, if you have any suggestions on better ways of handling this, I would really appreciate it.

Thanks! Jennifer :-)

Thanks :)

Jennifer Mabry
Information Access
jennifer.mabry_at_gwl.com
Phone: 303.737.6422 Received on Wed Jun 21 2000 - 10:18:40 CDT