Databases
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