RE: Bug in dbstart Script?

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:jkstill_at_cybcon.com]
> 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: kirti.deshpande_at_verizon.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).