How to startup database automatically

[Simon Qu]

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.

[harry d brown jr]

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

[Slawomir Gora · Accepted solution]

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]

Hi

check the config file /etc/oratab

Regards
Jean-Luc

[Steven E. Protter]

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

[Fred Ruffet]

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

[Simon Qu]

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