Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> dbstart and Oracle 8.1.6
I encountered something today that may affect others who migrate to 8.1.6
(Solaris 2.7), which I did a few weeks ago:
Our development server went down due to a power outage, and when it came back up the databases did not. I tried to run dbstart (which is called from the /etc/rc2.d) and it claimed that all the databases were warm started without running anything. There is a line in dbstart which checks for the version, and it looked like this:
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)}'` else VERSION="8.2" fi I ran svrmgrl command=exit, and received the following: Oracle Server Manager Release 3.1.6.0.0 - Production Copyright (c) 1997, 1999, Oracle Corporation. All Rights Reserved. Oracle8i Enterprise Edition Release 8.1.6.0.0 - Production With the Partitioning option JServer Release 8.1.6.0.0 - Production Server Manager complete.
Notice no line with PL/SQL in it? I had to change the dbstart text to read the following, which I doubt will translate to other versions, but at least will work with the ones I have here. Does anyone have a fix that is more generic?
if test -f $ORACLE_HOME/bin/svrmgrl; then VERSION=`$ORACLE_HOME/bin/svrmgrl command=exit | awk '
/Oracle.* Edition (Release|Version)/ {substr($5,1,3)
; print substr($5,1,3)}'` else VERSION="8.2" fi
Diana Duncan
Database Architect
fileFrenzy.com
diana_at_filefrenzy.com
Received on Fri Sep 01 2000 - 10:29:53 CDT
![]() |
![]() |