Return-Path: Received: from ensim.rackshack.net (root@localhost) by orafaq.net (8.11.6/8.11.6) with ESMTP id h16LlFZ16229 for ; Thu, 6 Feb 2003 15:47:15 -0600 X-ClientAddr: 209.68.248.164 Received: from newsfeed.cts.com (newsfeed.cts.com [209.68.248.164]) by ensim.rackshack.net (8.11.6/8.11.6) with ESMTP id h16LlEQ16222 for ; Thu, 6 Feb 2003 15:47:14 -0600 Received: from fatcity.UUCP (uucp@localhost) by newsfeed.cts.com (8.9.3/8.9.3) with UUCP id KAA32158; Thu, 6 Feb 2003 10:30:22 -0800 (PST) Received: by fatcity.com (26-Feb-2001/v1.0g-b72/bab) via UUCP id 00546158; Thu, 06 Feb 2003 09:39:54 -0800 Message-ID: Date: Thu, 06 Feb 2003 09:39:54 -0800 To: Multiple recipients of list ORACLE-L X-Comment: Oracle RDBMS Community Forum X-Sender: "Koivu, Lisa" Sender: root@fatcity.com Reply-To: ORACLE-L@fatcity.com Errors-To: ML-ERRORS@fatcity.com From: "Koivu, Lisa" Subject: RE: Looking for simple monitor script dbup.bat Organization: Fat City Network Services, San Diego, California X-ListServer: v1.0g, build 72; ListGuru (c) 1996-2001 Bruce A. Bergman Precedence: bulk Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C2CE05.FE83BD00" ------_=_NextPart_001_01C2CE05.FE83BD00 Content-Type: text/plain; charset="iso-8859-1" Hi Bob, Check out Steve Adams' script (www.ixora.com.au). It's written in ksh and will need a little modification to send emails, but it's bulletproof. Also others on the list have mentioned Cygwin (?) the Windows-ksh to allow this to run on your hosts. Lisa Koivu Oracle Dingbat Administrator Fairfield Resorts, Inc. 5259 Coconut Creek Parkway Ft. Lauderdale, FL, USA 33063 Office: 954-935-4117 Fax: 954-935-3639 Cell: 954-683-4459 -----Original Message----- Sent: Thursday, February 06, 2003 11:00 AM To: Multiple recipients of list ORACLE-L Good morning everyone Win2k pro, oracle 8.17 Ive been investigating a simple monitor script which will email me if the database is not available. I need this to be as simple as possible (ideally a batch file) Ive come across this on orafaq http://www.orafaq.net/scripts/win/isdbup.txt But dosnt seem to work. If you pass an incorrect sid, or file parameters the script just hangs I have a modified version ############################################## Rem dbup.bat @echo off set ORACLE_SID=locdb sqlplus internal/pw@%ORACLE_SID% @C:\conn.sql if {%ERRORLEVEL%} == {0} ( echo Database %ORACLE_SID% is available ) else ( echo Database %ORACLE_SID% is NOT available ) ############################################## [conn.sql] set echo off feed off pages 0 -- whenever sqlerror exit sql.sqlcode WHENEVER SQLERROR EXIT 1 select * from global_name; exit ; ############################################## Although this works (gets into the error level) AFTER you hit enter to walk throough the errors The script gets stuck on Errors Such as If the db is down ERROR: ORA-01034: ORACLE not available Enter user-name: ERROR: ORA-01017: invalid username/password; logon denied Or if I pass and invalid sid, (I can live with only passing valid sids) but how can I get sql+ to exit out of the error if in fact the db is not up I think Ive tried all variations of SQLERROR http://lina.cli.di.unipi.it:8000/WG73-doc/sqlplus/sp33/ch646.html Any ideas for the gurus??? Many thanks bob -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky INET: bmetelsky@cps92.com Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru@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). ------_=_NextPart_001_01C2CE05.FE83BD00 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable RE: Looking for simple monitor script dbup.bat

Hi Bob,

Check out Steve Adams' script = (www.ixora.com.au).  It's written in ksh and will need a little = modification to send emails, but it's bulletproof.  Also others on = the list have mentioned Cygwin (?) the Windows-ksh to allow this to run = on your hosts.

Lisa Koivu
Oracle Dingbat Administrator
Fairfield Resorts, Inc.
5259 Coconut Creek Parkway
Ft. Lauderdale, FL, USA  33063
Office: 954-935-4117 
Fax:    954-935-3639
Cell:    954-683-4459


-----Original Message-----
From: Bob Metelsky [mailto:bmetelsky@cps92.com]
Sent: Thursday, February 06, 2003 11:00 AM
To: Multiple recipients of list ORACLE-L
Subject: Looking for simple monitor script = dbup.bat


Good morning everyone Win2k pro, oracle 8.17

Ive been investigating a simple monitor script which = will email me if
the database is not available. I need this to be as = simple as possible
(ideally a batch file)

Ive come across this on orafaq
http://www.orafaq.net/scripts/win/isdbup.txt

But dosnt seem to work. If you pass an incorrect sid, = or file parameters
the script just hangs

I have a modified version
##############################################
Rem dbup.bat
@echo off
set ORACLE_SID=3Dlocdb
sqlplus internal/pw@%ORACLE_SID% @C:\conn.sql =

if {%ERRORLEVEL%} =3D=3D {0} (
   echo Database %ORACLE_SID% is = available
) else (
   echo Database %ORACLE_SID% is NOT = available
)
##############################################

[conn.sql]
set echo off feed off pages 0 
-- whenever sqlerror exit sql.sqlcode
WHENEVER SQLERROR EXIT 1
select * from = global_name;      
exit ;
##############################################

Although this works (gets into the error level) AFTER = you hit enter to
walk throough the errors
The script gets stuck on Errors Such as
If the db is down
ERROR:
ORA-01034: ORACLE not available
Enter user-name:
ERROR:
ORA-01017: invalid username/password; logon = denied

Or if I pass and invalid sid, (I can live with only = passing valid sids)
but how can I get sql+ to exit out of the error if = in fact the db is not
up
I think Ive tried all variations of SQLERROR

http://lina.cli.di.unipi.it:8000/WG73-doc/sqlplus/sp33= /ch646.html

Any ideas for the gurus???

Many thanks
bob
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Bob Metelsky
  INET: bmetelsky@cps92.com

Fat City Network Services    -- = 858-538-5051 http://www.fatcity.com
San Diego, = California        -- Mailing list = and web hosting services
---------------------------------------------------------------= ------
To REMOVE yourself from this mailing list, send an = E-Mail message
to: ListGuru@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).

------_=_NextPart_001_01C2CE05.FE83BD00-- -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Koivu, Lisa INET: Lisa.Koivu@efairfield.com Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru@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).