Re: fix for dbstart Oracle 8.1.6 Solais

I may be wrong, but I thought the Oracle supplied dbstart was mainly for use as an example. I wrote my own shell scripts for starting and stopping because I wanted users to be able to select which databases to start on any given server or which to stop. If you write your own you can also add SQL+ statements to do useful things. And it's easy to write them. I'd never done any UNIX shell scripts before and using dbstart as an example (along with what I could dig out of various books) I had startup and shutdown scripts installed on the various Solaris servers within a day.

Van

DNP <High.Flight_at_btinternet.com> wrote in message news:38E6673E.3A95_at_btinternet.com...
> Thanks for the info - just one question - have you found the same
> problem with the dbstart script for 8.1.5 or has anyone else?
> If so what was the relevant platform?
>
>
>
> David P.
>
> Oracle Certified DBA.
>
>
>
> ============================================================
>
>
>
>
> jk2112_at_my-deja.com wrote:
> >
> > After I installed 8.1.6 on Solaris I found that the dbstart command does
> > not actually start the database due to an error in the script.
> >
> > All I get from a dbstart is:
> >
> > Database "delta" warm started.
> >
> > But no database or the usual messages about sga size etc.
> >
> > I found that the $ORACLE_HOME/bin/dbstart script was the problem. It was
> > unable to determine the database version and so does nothing.
> >
> > I made the following modification to dbstart:
> >
> > remove:
> > VERSION=`$ORACLE_HOME/bin/svrmgrl command=exit | awk '
> > /PL\/SQL (Release|Version)/ {substr($3,1,3) ;
> > print substr($3,1,3)}'`
> >
> > replace with:
> > VERSION=`$ORACLE_HOME/bin/svrmgrl command=exit | awk
> > '/Oracle8i/ {print substr($5,1,3)}'`
> >
> > Hope this helps someone...
> >
> > Jeff Kadonoff
> >
> > jeffk_at_NOSPAMMOeuropa.bc.ca (remove the NOSPAMMO to mail)
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
Received on Sun Apr 02 2000 - 00:00:00 CST