Hi Diana,
That's a known issue. Pl Check Metalink. There is workaround posted for
this. And there are more than one way to address this. Oracle's solution
from Metalink works for all 8.1.x databases on the server, but it will not
start any other lower version databases on the same server.
Here is what I have in our dbstart. We run dbstart from the highest version
of oracle s/w on a server. This change is working for us against 7.3, 8.0
and 8.1 databases on the same server.
Hope this helps.
- Kirti
# Figure out if this is a V5, V6, or V7 database. Do we really need
V5?
if [ -f $ORACLE_HOME/bin/sqldba ] ; then
VERSION=`$ORACLE_HOME/bin/sqldba command=exit | awk '
/SQL\*DBA: (Release|Version)/ {split($3, V, ".") ;
print V[1]}'`
else
if test -f $ORACLE_HOME/bin/svrmgrl; then
#----------------------------------------------------------------
#-------- Modified by Kirti 7/18/2000
---------------------------
#-------- to get 8.x database VERSION info
correctly-------------
#----------------------------------------------------------------
VERSION=`$ORACLE_HOME/bin/svrmgrl command=exit |
grep 'Release' | tail -1 | awk '
{print substr($3,1,3)}'`
#--------- End of Modification by Kirti
else
VERSION="8.2"
fi
#----------------------------------------------------------------
#-------- Modified by Kirti 7/18/2000
---------------------------
#-------- To default to Version 7.3 if no 8.x found
#----------------------------------------------------------------
if [ ${VERSION} != "8.0" -a ${VERSION} != "8.1" -a
${VERSION} != "8.2" ]
then
VERSION="7.3"
fi
#--------- End of Modification by Kirti
fi
> -----Original Message-----
> From: Diana Duncan [SMTP:Diana_at_fileFRENZY.com]
> Sent: Friday, September 01, 2000 12:08 PM
> To: Multiple recipients of list ORACLE-L
> Subject: 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
> 919.833.1766 x 238
>
> --
> Author: Diana Duncan
> INET: Diana_at_fileFRENZY.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
Received on Fri Sep 01 2000 - 15:09:12 CDT
