Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Need oracle Script

Re: Need oracle Script

From: puja rahul <>
Date: Fri, 16 Jun 2000 17:43:37 -0700
Message-Id: <>


I'm aware of the dbstart and dbshut scripts but I was wondering if there is any script within oracle to see if all the databases mentioned in the /etc/oratab file are up and running - and if for some reason the database is not up - bring it up and online. Instead for wrting a script taking the output of ps -ef to check ,which will be little complicated I was trying to figure out if someone has a script in place doing the same job.

I would highly appreciate the help.

THanks in advance.



On Fri, 16 Jun 2000 05:39:47  
 Chuck Hamilton wrote:

>You already have it. Check out $ORACLE_HOME/bin/dbstart.
>puja rahul
>Hi ,
>I'm a unix admin and not at all a DBA.So I need some help in ORACLE.
>I have 12 instances of ORACLE running on my production box -\
>( DIGITAL UNIX 4.0D is the OS on the box )
>For some reasons at times after the night backup few data bases are not coming up-
>I want to have a script that can run every morning after the backup is complete to check the status of all the databases and if Any of the them is not running do a clean startup of the databases which were not running and send a mail saying that all datbases are up and running.
>Thanks a lot all of you in advance.
>Send FREE Greetings for Father's Day--or any day!
>Click here:
>Author: puja rahul
>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: (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).
>Do You Yahoo!?
>Send instant messages with Yahoo! Messenger.
Send FREE Greetings for Father's Day--or any day! Click here:
Received on Fri Jun 16 2000 - 19:43:37 CDT

Original text of this message