Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Automatic Startup on Linux

DBeltJul 28 2009 — edited Jun 18 2010
This is not a question but to share an experience.

We are running 11g on a linux system. We went through the instructions given in Chapter 2 "Stopping and Starting Oracle Software" of the "Oracle Database Administrator's Reference 11g Release 1 (11.1) for Linux and Unix-Based Operating Systems" for automating database startup and shutdown (section 2.2.1).

Step 4 of this procedure says to create a "dbora" script file by copying some given text into the file and making some minor modifications to that listing. We did this, as well as the other steps in the procedure. When the script was run we were getting "Connection refused" errors. It was determined that the problem was with the line:
rsh $HOST -l $ORACLE $0 $1 ORA_DBA
which causes the host to try to reconnect to itself (or something like that as I understand it as explained to me by the person who fixed the problem).

We fixed the problem in the following way:

Add step 4a

Create a file named "dbora_oracle" (or something similar) which consists of the following line:
su - -c "/etc/init.d/dbora $1 ORA_DB" oracle
where oracle is the owner of the database installation.

Add step 5a

Execute the following commands
# chgrp dba dbora_oracle
# chmod 750 dbora_oracle
Replace step 6 with the following symbolic links:
# ln -s /etc/init.d/dbora_oracle /etc/rc.d/rc0.d/K01dbora_oracle
# ln -s /etc/init.d/dbora_oracle /etc/rc.d/rc3.d/S99dbora_oracle
# ln -s /etc/init.d/dbora_oracle /etc/rc.d/rc5.d/S99dbora_oracle
Has anyone else encountered this problem? If so, how have you fixed it?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 16 2010
Added on Jul 28 2009
6 comments
3,399 views