RE: dbstart and Oracle 8.1.6

Diana,
  I just modified the awk statement to look for either the PL/SQL line or the JServer line:

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

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

I haven't seen both used yet so it has been working fine for me...

Jeffery Stevenson
Chief Database Geek
Medical Present Value, Inc.
Austin, TX

-----Original Message-----
From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of Diana Duncan
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