I need to set up the automatic startup of the database instance and listener on GRIDCTRL.

Automatic Startup of Services

I need to append the network names of the services from 11G OCM Listener on GRIDCTRL to the current value of the SERVICE_NAMES initialisation parameter.

SQL> show parameter service

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
service_names                        string      repos.gridctrl.yaocm.id.au
SQL> alter system set service_names='repos.gridctrl.yaocm.id.au,dba.repos.yaocm.id.au,rman.yaocm.id.au,oem.yaocm.id.au' scope=spfile;

System altered.

Automatic Startup of Oracle Listener and Database Instances

I had to manually add the following lines to the /etc/rc.local file by using root access:

cat >>/etc/rc.local <<EOF
# Oracle 11G Startup
su oracle -c "/opt/oracle/app/product/11.1.0/db_1/bin/dbstart /opt/oracle/app/product/11.1.0/db_1"

The parameter to the dbstart command is the ORACLE_HOME of the Oracle Listener.

This command needs to run as the oracle user in order to use SYSDBA access for starting the database instances.

Automatic Startup of REPOS Database Instance

DBCA had set the auto-start parameter in /etc/oratab to N. I just used vi to change it to Y.


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s