Operating System - HP-UX
1748118 Members
3653 Online
108758 Solutions
New Discussion юеВ

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 6
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