Re: Need oracle Script

 Hi,

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.

cheers.

--

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


>

>You already have it. Check out $ORACLE_HOME/bin/dbstart.

>

> 

>puja rahul 

>wrote: 

>

>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.

>

>Cheers

>

>

>

>Send FREE Greetings for Father's Day--or any day!

>Click here: http://www.whowhere.lycos.com/redirects/fathers_day.rdct

>-- 

>Author: puja rahul

>INET: puja-r_at_mailcity.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). 

>

>

>

>

>---------------------------------

>Do You Yahoo!?

>Send instant messages with Yahoo! Messenger.



Send FREE Greetings for Father's Day--or any day!
Click here: http://www.whowhere.lycos.com/redirects/fathers_day.rdct