Home » Infrastructure » Unix » How do I Mount a Database on Startup?
How do I Mount a Database on Startup? [message #367106] Mon, 04 December 2000 10:55 Go to next message
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 #367107 is a reply to message #367106] Mon, 04 December 2000 12:49 Go to previous messageGo to next message
Melissa
Messages: 65
Registered: January 2000
Member
When you issue the startup command, the database is mounted and opened.
Re: How do I Mount a Database on Startup? [message #367109 is a reply to message #367107] Mon, 04 December 2000 17:14 Go to previous messageGo to next message
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 #367110 is a reply to message #367109] Tue, 05 December 2000 09:41 Go to previous messageGo to next message
Melissa
Messages: 65
Registered: January 2000
Member
Have you looked at $ORACLE_HOME/bin/dbstart and $ORACLE_HOME/bin/dbshut?
Re: How do I Mount a Database on Startup? [message #367111 is a reply to message #367110] Tue, 05 December 2000 10:28 Go to previous messageGo to next message
ron
Messages: 50
Registered: July 1999
Member
Yes, the when executed it says the database name started "Warm".
Re: How do I Mount a Database on Startup? [message #367112 is a reply to message #367111] Tue, 05 December 2000 13:40 Go to previous message
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 }'`
Previous Topic: Oracle 8i on Linux text mode or Linux upgrade to GUI mode......
Next Topic: Mput with the Directory Structure
Goto Forum:
  


Current Time: Fri Mar 29 10:46:27 CDT 2024