RE: db up script

From: Philip West <P.West_at_g-icap.com>
Date: Fri, 12 May 2000 10:03:10 +0100
Message-Id: <10495.105457@fatcity.com>

I see what you are trying to do. There might be more obvious ways but of the top of my head : you could have a script to look for db processes, etc and a separate script that does the connect check. The second script being exec'd from the first. You can then allow the second script so long to be successful (maybe looking for out put to a temp file) before you check for success from the first script.

script one>  look for db processes
script one>  at now< script two and sleep 30
script two>  attempt to connect and select 'success' from dual > output to

temp file
script one> ends sleep and looks for 'success' in script two's temp file

Phil West - Impex IT ltd
Unix Sys Admin and Oracle Financials DBA Services

all opinions, unless otherwise stated, are personal and subject to change without reason or warning

... -----Original Message-----
... From: Lisa_Koivu_at_gelco.com [mailto:Lisa_Koivu_at_gelco.com]
... Sent: Thursday, May 11, 2000 7:29 AM
... To: Multiple recipients of list ORACLE-L
... Subject: db up script
...
...
... Hello -
...
... Does anyone have a script that checks if a series of
... databases are up and
... available that they would be willing to share? I set out
... to write a ksh script
... to do this and found that I would have to write C to do
... what I needed to do,
... since trying to connect to a hung or down instance will
... result in a hung
... process. There wasn't an easy way to fire off the connect
... process, sleep, and
... kill it if it hadn't come back yet. I really don't want to
... spend my day writing
... C code, it will exacerbate the headache my job gave me today.
...
... Any suggestions / script snippets are appreciated
... Thanks
... Lisa
...
...
...
... --
... Author:
... INET: Lisa_Koivu_at_gelco.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).
...

The information in this Internet e-mail is confidential and may be legally privileged. It is intended solely for the addressee. Access to this Internet e-mail by anyone else is unauthorised and any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful. When addressed to our clients any opinions or advice contained in this Internet e-mail are subject to the terms and conditions expressed in any applicable documentation or market practices governing the relationship between Garban Intercapital plc and its clients.

Any views expressed in this message are those of the individual sender except where they are stated to be the views of Garban Intercapital plc.

Received on Fri May 12 2000 - 04:03:10 CDT