Oracle 8.1.6 bug prevents automated db startup

Not sure if someone reported this already, but here it goes...

    $ORACLE_HOME/bin/dbstart

has a bug that prevents it from automatically starting the databases listed in /etc/oratab. You will get no warnings, but the default detabases will not startup. sqlplus will report:

    ORA-01034: ORACLE not available

The 'broken piece' is on lines 62 to 64. To get the correct oracle version number from $ORACLE_HOME/bin/svrmgrl replace:

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)}'`

with:

if test -f $ORACLE_HOME/bin/svrmgrl; then   VERSION=`$ORACLE_HOME/bin/svrmgrl command=exit | awk '
/Oracle8i Enterprise Edition Release/ {print substr($5,1,3)}'`

BTW: This 'fix' probably breaks 8.1.5. I did not check as I don't have any left.

Best regards,

EdHoo Received on Wed May 31 2000 - 00:00:00 CEST