Re: Need oracle Script

--0-1804289383-961158334=:3796
Content-Type: text/plain; charset=us-ascii

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 upI  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.
--0-1804289383-961158334=:3796
Content-Type: text/html; charset=us-ascii



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

<P> <BR><B><I>puja rahul <PUJA-R_at_MAILCITY.COM></I></B>wrote: <BR>

<BLOCKQUOTE style="BORDER-LEFT: #1010ff 2px solid; MARGIN-LEFT: 5px; PADDING-LEFT: 5px"><BR>Hi ,<BR><BR>I'm a unix admin and not at all a DBA.So I need some help in ORACLE.<BR>I have 12 instances of ORACLE running on my production box -\<BR>( DIGITAL UNIX 4.0D is the OS on the box )<BR>For some reasons at times after the night backup few data bases are not coming up-<BR>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.<BR><BR>Thanks a lot all of you in advance.<BR><BR>Cheers<BR><BR><BR><BR>Send FREE Greetings for Father's Day--or any day!<BR>Click here: http://www.whowhere.lycos.com/redirects/fathers_day.rdct<BR>-- <BR>Author: puja rahul<BR>INET: puja-r@mailcity.com<BR><BR>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051<BR>San Diego, Ca!

lifornia -- Public Internet access / Mailing Lists<BR>--------------------------------------------------------------------<BR>To REMOVE yourself from this mailing list, send an E-Mail message<BR>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in<BR>the message BODY, include a line containing: UNSUB ORACLE-L<BR>(or the name of mailing list you want to be removed from). You may<BR>also send the HELP command for other information (like subscribing). <BR></BLOCKQUOTE><BR><p><br><hr size=1><b>Do You Yahoo!?</b><br>
Send instant messages with Yahoo! Messenger.