| How do I Mount a Database on Startup? [message #367106] |
Mon, 04 December 2000 10:55  |
ron
Messages: 50
Registered: July 1999
|
Member |
|
|
|
I have set up Oracle 8.1.6 on a Linux Machine RedHat 6.2, and I have a script that will start the listener and run dbstart. This starts the db's marked Y in oratab. But I need to find a way to Mount the db also. How can I accomplish this?
|
|
|
|
|
|
| Re: How do I Mount a Database on Startup? [message #367109 is a reply to message #367107] |
Mon, 04 December 2000 17:14  |
ron
Messages: 50
Registered: July 1999
|
Member |
|
|
|
I am unable to connect to the db remotely after a boot. But if I logon on to sqlplus and do a startup open pfile=... I am then able to access the db remotely. This is the issue I am trying to remedy. I may have missed a setting as I am new to Oracle and the books my company have could be better.
|
|
|
|
|
|
|
|
| Re: How do I Mount a Database on Startup? [message #367112 is a reply to message #367111] |
Tue, 05 December 2000 13:40 |
Melissa
Messages: 65
Registered: January 2000
|
Member |
|
|
I can't believe I missed this. You're using 8.1.6. dbstart does not work with this version. You need to make the following changes:
Edit the dbstart script and change the 'awk' lines
from:
VERSION=`$ORACLE_HOME/bin/svrmgrl command=exit | awk '
/PL\/SQL (Release|Version)/ {substr($3,1,3) ;
print substr($3,1,3)}'`
to:
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 }'`
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
