Re: Help - dbstart script does not work!

kal121_at_my-deja.com wrote:
>
> I installed Oracle 8.1.6 v2 for Solaris (32 bit)
>
> The "dbstart" script does not work. When I run it, I get a message that
> says ' "dev1" warm started ', but in fact, the instance is not started
> at all. (The dbshut script is working ok)
>
> Has anyone else had this problem and how did you resolve it? Is it a
> bug?
>

Yep, and found this on technet
Change the dbstart script from
# 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
                    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 this

# 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
                    VERSION=`$ORACLE_HOME/bin/svrmgrl command=exit |
awk '
                        /Edition Release/ {substr($5,1,3) ;
                        print substr($5,1,3)}'`
                else
                        VERSION="8.2"
                fi
            fi

Notice the slight difference in the first else clause. Received on Fri Jul 14 2000 - 00:00:00 CDT