Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: start oracle while solaris reboot

Re: start oracle while solaris reboot

From: Luterin <luterin_at_netscape.net>
Date: Wed, 19 Sep 2001 16:37:13 -0400
Message-ID: <9oavlq$hnv$1@atlas.net.metrotor.on.ca>


In addition to the rc2.d files, also consider the following:

In the dbstart script, the following entry may have to be changed:
---

            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
                    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
            fi

---

to look like:
---
            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
                    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)}'`
                else
                        VERSION="8.2"
                fi
            fi

---

in order to detect the correct version.

And, make sure that the last field is set to Y for the database in question's entry in /.../oratab file.

-Lute. Received on Wed Sep 19 2001 - 15:37:13 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US