Re: Always have to do startup force to get db started

From: rob <rob_at_dsdelft.nl>
Date: Fri, 9 Aug 2002 08:41:41 +0200
Message-ID: <aivo75$3f2$1@news.tudelft.nl>

There is a bug in the dbstart script for version 8.1.6 on UNIX. For detailed info see note 98418.1 on metalink.
Save the original and change:

VERSION=`$ORACLE_HOME/bin/svrmgrl command=exit | awk '

          /PL\/SQL (Release|Version)/ {substr($3,1,3) ;
          print substr($3,1,3)}'`

to:

VERSION=`$ORACLE_HOME/bin/svrmgrl command=exit | awk '
/PL\/SQL (Release|Version)/ { print substr($3,1,3); exit }
/Oracle7 Server (Release|Version)/ { print substr($4,1,3); exit }
/Oracle8i Enterprise Edition (Release|Version)/ { print substr($5,1,3);
exit }
/Oracle8i (Release|Version)/ { print substr($3,1,3); exit }'`

This will do the trick.

Rob Received on Fri Aug 09 2002 - 01:41:41 CDT