| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: To Autostart or not to Autostart
I'd rather the SA's didn't have to edit any files.
Doing it myself means getting paged at 03:00 AM.
Giving the SA's an easy opt out would be preferable. I've never setup an opt out for the DB startup scripts, but it sounds like a good idea,.
Using alarm() and wrapping the startup in a Perl script would do it:
$SIG{ALRM} = sub{die "starting up databases!"};
alarm 30; # wait 30 seconds
print "\nPress 'N' <ENTER> to prevent database startup: ";
my $input = <>;
chomp $input;
if ( $input =~ /^N/ ) { exit 1}
};
alarm 0;
call database startup script
I would try this with ksh or bash if I knew of a way to do alarm calls in a shell. Anyone here know how?
Jared
"Gene Sais" <Gsais_at_co.palm-beach.fl.us>
Sent by: root_at_fatcity.com
08/22/2002 01:13 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
cc:
Subject: RE: To Autostart or not to Autostart
Am I missing something here? Doesn't everyone use the Y or N flag in the oratab file? If set to Y, then shutdown/startup databases on reboot. If the SA's are going to bounce a lot, I shutdown all db's and set flag to N. I prefer to leave it set to Y for many reasons previously mentioned.
>>> Rich.Jesse_at_qtiworld.com 08/22/02 03:47PM >>>
On HP/UX, you can customize /etc/rc.config.d/oracle to include a symbol
setting for "ORACLE_START". Like using "ORACLE_STOP", this symbol could
be
used to tell the startup script whether or not to autostart the DBs. Of
course, the /sbin/init.d/oracle would have to be customized to actually
make
use of this new variable, but it's an easy clone of the ORACLE_STOP logic.
I just have ORACLE_START set to "0" for now. In my particular case, I'm
in
the same group as the SAs (actually, it's in my title, too), so if our
server goes down, I need to know, too.
Thanks all for the input, especially John Weatherman's about an unstable
system bouncing up and down. We had a similar situation when a memory
bank
blew chunks. Probably a good thing the DB didn't come back up.
Rich Jesse System/Database Administrator Rich.Jesse_at_qtiworld.com Quad/Tech International, Sussex, WIUSA
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: Rich.Jesse_at_qtiworld.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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gene Sais INET: Gsais_at_co.palm-beach.fl.us 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: Jared.Still_at_radisys.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).Received on Thu Aug 22 2002 - 17:34:36 CDT
 |
 |