Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Is the database up? script request

RE: Is the database up? script request

From: Steven Monaghan <MonaghaS_at_mscdirect.com>
Date: Tue, 5 Sep 2000 08:46:32 -0400
Message-Id: <10610.116199@fatcity.com>


Awesome. Thanks again for coming through for a list member! I should have thought to check your site first. Your script is actually much more comprehensive than I would have made.

Now, the test of my scripting knowledge will be to see if I can follow everything in this script.

Thanks again.
Steve Monaghan

> -----Original Message-----
> From: Steve Adams [mailto:steve.adams_at_ixora.com.au]
> Sent: Friday, September 01, 2000 7:54 PM
> To: Multiple recipients of list ORACLE-L
> Subject: 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/
> @
> @ Going to OpenWorld?
> @ Catch the Ixora performance tuning seminar too!
> @ See http://www.ixora.com.au/seminars/ for details.
>
>
> -----Original Message-----
> Sent: Saturday, 2 September 2000 7:53
> To: Multiple recipients of list ORACLE-L
>
>
> 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
>
> -------------------------------------
> Steven Monaghan
> Oracle DBA
> MSC Industrial Direct Co., Inc.
> Melville, NY
> MonaghaS_at_mscdirect.com
> -------------------------------------
> --
> 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).
>
> --
> Author: Steve Adams
> INET: steve.adams_at_ixora.com.au
>
> 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
Received on Tue Sep 05 2000 - 07:46:32 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US