Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

dbstart not working

Status
Not open for further replies.

bcre3306

MIS
May 7, 2002
45
US
I have to oracle installs on my AIX 4.3.3 box. One install is 8.0.5 and the database that runs on this version of oracle starts with the dbstart command. The other databases I have on the same box run on 8.1.6. When I run dbstart I get "database name warm started" when I run dbstart. I have all of the databases in the oratab with the correct version of oracle after the name. When I run dbstop they all stop successfully. Anybody have any suggestions?
Thanks
Brian
 
This is a documented bug. You need to copy dbstart to dbstart0 and then edit the code that looks 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)}'`
i
to look like this:

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); exit }'`
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)}'`
 
now my dbstop does not seem to work. It get's hung on the 8.0.5 database. Any ideas?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top