Re: Auto start DB on linux

JMNpst wrote:
>
> I am trying to automatically start the Oracle Data Base and listener upon
> booting up our linux server, but it doesn't seem to work. In the instructions,
> it says to modify the /etc/oratab file and change the N to Y, and verify that
> the SID and HOME is correct - it is. Then it tells me to set up the dbora file
> in /etc/rc.d/init.d directory and gave me a default script to create, and then
> the link to /etc/rc.d/rc0.d AND /etc/rc.d/rc2.d. All this is done. I can run
> the dbora script manually with start and stop parms and the db starts and stops
> OK, but when I re-boot the server, it doen't seem to execute the dbora script.
> I can verify this by executing the dbora script manually and it will start the
> db, or I can also use sqlplus to try to log on, and it tells me oracle is not
> available. All this tells me that the dbora script is not being run at re-boot
> time. If i login as root or oracle8i - neither one starts the db. Oracle
> support says that it is an operating system problem.
> When the servers boots up, is it supposed to run the links in the rc* folders?
> Am I supposed to do anything with my bash profile? Can anyone help?
> I am running RH 6.2 and Oracle 8.1.5 EE with all patches applied.

Assuming your links are correct and your script is correct, (when you enter the normal operation run level the link should run your script). To run all the command in the start script root must be able to log in as oracle. Do you use 'rsh in your script? If so you need to check .rhosts in the oracle user's home directory (not $ORACLE_HOME). Check the bootup messages - look for permission denied when starting oracle - failing that look in /var/adm for the system startup log. If you've followed the install guide correctly then your problem will be permissions.

HTH Received on Thu Aug 31 2000 - 07:46:03 CDT