Tuesday, October 18, 2011

Adding a RAC Database and Instance Using srvctl

For 11gR2. 

Command help can be generated as follows:

$ srvctl add database -h

and...

$ srvctl add instance -h

Add the database first

$ srvctl add database -d RAC -n rac01 -o $ORACLE_HOME

Now add the instances...

$ srvctl add instance -d RAC -i RAC1 -n rac01
$ srvctl add instance -d RAC -i RAC2 -n rac02

Tuesday, October 4, 2011

Crerating an OCM Response File for a GI Home Prior to Patching

Before applying any patches to the GI home, an ocm.rsp file should be created.  As the GI owner, set the GI environment:

$ export ORACLE_BASE=/opt/app
$ export ORACLE_HOME=$ORACLE_HOME/11.2.0/grid

Create the ocm.rsp file:

$ $ORACLE_HOME/OPatch/ocm/bin/emocmrsp

When prompted for an email address, either leave blank or provide an email address.  The file will be created in the directory from which the above command was executed.

For example, when applying a patch to GI and the patch files have been unzipped to a directory, the opatch command will be executed as follows:

# opatch auto <directory location of patch files> -oh <GI HOME>

When pompted:
OPatch is bundled with OCM, Enter the absolute OCM response file path:

Enter the patch of the ocm.rsp file e.g.
/home/oracle/ocm.rsp

and continue with the patch.