| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Is the database up? script request
Hi Steve,
There is a sample script to do this on the Miscellaneous scripts page on the Ixora web site.
@ Regards,
@ Steve Adams
@ http://www.ixora.com.au/
@ http://www.christianity.net.au/
@
-----Original Message-----
From: Steven Monaghan [mailto:MonaghaS_at_mscdirect.com]
Sent: Saturday, 2 September 2000 7:53
To: Multiple recipients of list ORACLE-L
Subject: Is the database up? script request
My boss is looking for me to implement a process that will verify that the database and listener are up, and that users can connect to the database. I am a novice shell scripter (Just finished reading Teach Yourself UNIX Shell Programming in 14 Days two weeks ago :) I am developing ksh scripts to perform a bunch of other monitoring tasks as well (check alert log, check # users, next extent fail, etc). Basically, I need to make sure that the connection from the local machine uses the listener (otherwise not a valid test), that I select against a table and that my shell script traps and errors and mails them out.
I'm sure someone has done this already, and any ideas / on-line references / samples would be greatly appreciated,
TIA,
Steve Monaghan
-- Author: Steven Monaghan INET: MonaghaS_at_mscdirect.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Received on Fri Sep 01 2000 - 17:51:28 CDT
 |
 |