Configuring OCM (Configuration Manager) on an E-Business R12

Installation Steps

Database Tier

1.      Download OCM Patch 5567658 from metalink and extract to it Oracle database tier home (unzip -d $ORACLE_HOME ocm.zip)

2.      Run SetupCCR script

a.       cd $ORACLE_HOME/ccr/bin

b.       Run setupCCR -s <CSI ID> <METALINK ID> US

While running setupCCR it will ask for proxy details. Please find the below screen shot and enter the values as per this.

          It will prompt for Proxy Password: Press Enter

3.      Execute $ORACLE_HOME/ccr/admin/scripts/installCCRSQL.sh collectconfig

4.      Execute $ORACLE_HOME/ccr/admin/scripts/installCCRSQL.sh ebs_collectconfig –u apps

To Change the OCM Collection interval

Cd $ORACLE_HOME/ccr/bin

Execute below command (set the interval according to the reuirment)

 emCCR set collection_interval="FREQ=WEEKLY;BYDAY=SUN; BYHOUR=22;BYMINUTE=0"

Application Tier

1.       Download OCM Patch 5567658 from metalink and extract to it Oracle  home (Application Tier) (10.1.2 or 10.1.3) (unzip -d $ORACLE_HOME ocm.zip) 

2.       Run SetupCCR script

a.       cd $ORACLE_HOME/ccr/bin

b.       Run setupCCR -s <CSI ID> <METALINK ID> US

Uninstalling OCM

1.       Stop the Configuration manager

$ORACLE_HOME/ccr/bin/emCCR status

$ORACLE_HOME/ccr/bin/emCCR stop

2.       Connect as SYSDBA and run the below sql

$ORACLE_HOME/ccr/admin/scripts/dropocm.sql

 

3.       Connect as SYSDBA and run the below sql

               $ORACLE_HOME/ccr/admin/scripts/ebs_dropccr.sql APPS

4.       cd $ORACLE_HOME , remove the ccr directory.