Simpler Navigation for Servers and Operating Systems - Please Update Your Bookmarks
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
If you have bookmarked forums or discussion boards in Servers and Operating Systems, we suggest you check and update them as needed.
General
cancel
Showing results for 
Search instead for 
Did you mean: 

How to startup database automatically

SOLVED
Go to solution
Simon Qu
Frequent Advisor

How to startup database automatically

We have oracle 8.1.7 running on hp-ux 11i. Every time when we restart the system, the database is automatically started. That is what we want.
Now, I made a copy of our production database and set up a TEST database. Then, if I restart the system, the TEST database is not started and I have to manully start it up. I think there is a file to put the entry for TEST database, but I do not know where the file is.
Does anyone know how to make this work?
Thanks advance.
6 REPLIES
harry d brown jr
Honored Contributor

Re: How to startup database automatically

on your production box look in /sbin/init.d and /etc/rc.config.d for oracle startup scripts:

find /sbin/init.d -type f -exec grep -il oracle {} \;

find /etc/rc.config.d -type f -exec grep -il oracle {} \;

live free or die
harry d brown jr
Live Free or Die
Slawomir Gora
Honored Contributor
Solution

Re: How to startup database automatically

Hi,

you have to add valid entry to /etc/oratab file

TEST:/u01/app/oracle/product/8.1.7:Y

replace my /u01/app/oracle/product with your ORACLE_HOME path.
Jean-Luc Oudart
Honored Contributor

Re: How to startup database automatically

Hi

check the config file /etc/oratab

Regards
Jean-Luc
fiat lux
Steven E. Protter
Exalted Contributor

Re: How to startup database automatically

copy /sbin/init.d/oracle or whatever you named it file to the new system.

Make adjustments for the instance name.

cd /etc/rc3.d

ln -s /sbin/init.d/oracle S88oracle

cd /etc/rc2.d

ln -s /sbin/init.d/oracle K110oracle

Done

Steven E Protter
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
Fred Ruffet
Honored Contributor

Re: How to startup database automatically

Have a look at /sbin/init.d directory. There must be script that start and stop oracle. It may be launch by links at different runlevel (look at rcX.d subdirectories).

As this script is likely to use dbstart/dbshut process, have a look at /etc/oratab file.

Regards,

Fred
--

"Reality is just a point of view." (P. K. D.)
Simon Qu
Frequent Advisor

Re: How to startup database automatically

I think you guys fixed the issue. I will have it a try for next restart.
Thank you all