All such mess in dbstart (and dbshut) is because Oracle prefers to keep
patching these scripts for current releases rather than writing them afresh
in a clean concise manner. Just look at these scripts in 8i and 9i. Code
still exists to check if there is 'sqldba' and all that. When delivered
scripts do not work, patches are issued to complicate them further.
Hope 10i will come out with newly written dbstart/dbshut scripts :)
- Kirti Deshpande
Verizon Information Services
http://www.superpages.com
> -----Original Message-----
> From: Jared Still [SMTP:[EMAIL PROTECTED]]
> Sent: Friday, July 13, 2001 12:50 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: Bug in dbstart Script?
>
>
> Yeah, you should see the one on AIX, it's
> a real mess.
>
> Jared
>
> On Thursday 12 July 2001 10:47, mohammed bhatti wrote:
> > Folks,
> >
> > I'm not sure if this applies to any of you, but the
> > $ORACLE_HOME/bin/dbstart script 8.1.6 for Solaris 2.6
> > appears to have a slight bug in it. Whenever we
> > re-booted, during the system startup, the dbstart
> > script is called but none of our databases ever come
> > up. I finally tracked it down to this offending piece
> > of code in dbstart:
> >
> > if test -f $ORACLE_HOME/bin/svrmgrl; then
> > VERSION=`$ORACLE_HOME/bin/svrmgrl command=exit | awk
> > '
> > /PL\/SQL (Release|Version)/ {substr($3,1,3) ;
> > print substr($3,1,3)}'`
> > ...
> > ...
> > ...
> >
> > which I've replaced with this:
> >
> > if test -f $ORACLE_HOME/bin/svrmgrl; then
> > VERSION=`$ORACLE_HOME/bin/svrmgrl command=exit | awk
> > '
> > /Oracle8i Enterprise Edition (Release|Version)/
> > {substr($5,1,3) ;
> > print substr($5,1,3)}'`
> > ...
> > ...
> > ...
> >
> > Our databases come up automatically after a re-boot.
> >
> > hth someone.
> >
> > mkb
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Deshpande, Kirti
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
