fix for dbstart Oracle 8.1.6 Solais

From: <jk2112_at_my-deja.com>
Date: 2000/04/01
Message-ID: <8c5imc$4qt$1@nnrp1.deja.com>#1/1

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 Sat Apr 01 2000 - 00:00:00 CST