Oracle Configuration Manager OCM installation administration

May 9, 2014 by Leave a comment 

OCM Proactive database monitoring with MOS

OCM proactive database monitoring with MOS

The Oracle Configuration Manager (OCM) is a tool to proactively monitor your Oracle environment (your Oracle database in particular) with combination to My Oracle Support (MOS) website. OCM uploads this configuration information to Oracle Customer Configuration Repository on a regular basis and replicates this to My Oracle Support so that you and MOS engineers can view your Oracle database configuration, see alerts, and perform health-checks against your Oracle database. OCM also simplifies and speeds up a creation and handling of MOS Service Requests.

How to download latest OCM

All Oracle customers are enabled for Configuration Manager by default and they obtain the latest version of Configuration Manager (OCM) with different ways. Note, if you are on Oracle database 10.2.0.4+ it’s already deployed with your Oracle database installation (not the latest version probably) . In case you have internet connection to MOS you do not need to download the latest version manually since it will be done during OCM installation.

a) Try this link as the fastest way:
https://support.oracle.com/epmos/faces/CollectorHome

b) Tab My Oracle Support -> tab More -> Collector, section “Downloading …”
Here accept the license agreement and choose your operating system.

c) The now preferred way as patch -> Tab Patches & Updates -> Simple Search
-> patch number 5567658 for all configuration manager collector versions.

Oracle Configuration Manager (OCM) installation

I must admit there are a few ways and some strange guidelines of OCM installation. Below I share my way which always worked on Unix starting from Oracle database 10.2.0.4+.
This is installation on a Unix host that can ping My Oracle support website. If there is no Internet connection available from the database host, I do not see a reason of installing OCM.

– Logon as oracle database owner (usually oracle user) on the database Unix host
– Check connection to MOS:

$ nslookup ccr.oracle.com
Server:         …
Address:        …
Non-authoritative answer:
ccr.oracle.com  canonical name = lb-ccr.oracle.com.
Name:   lb-ccr.oracle.com
Address: 141.146.54.49

– cd $ORACLE_HOME/ccr/bin

– ./setupCCR

– Provide your MOS email and password

– You do NOT need to run emCCR collect as it’s already setup with Patch Set 3 10.2.0.4.

After this point the latest version of OCM will be downloaded and installed in your $ORACLE_HOME/ccr directory, first configuration collection completed and the next collections scheduled.

Oracle Configuration Manager (OCM) components

– installation directory : $ORACLE_HOME/ccr (If ccr folder does not exist, OCM has not been included with your Oracle release)

– Main OCM utility: $ORACLE_HOME/ccr/emCCR  (If emCCR exists, OCM has been configured)

– Oracle database user: ORACLE_OCM (also created after 10.2.0.4 upgrade)

– Oracle database jobs: MGMT_CONFIG_JOB – configuration collection job; MGMT_STATS_CONFIG_JOB – Statistics collection job

– MOS user: $ORACLE_HOME/ccr/hosts/<host name>/config/ccr.properties

– $ORACLE_HOME/ccr/hosts/[hostname]/state/review/targetMap.xml will show what was collected and uploaded

– Useful scripts to administer and troubleshoot OCM: $ORACLE_HOME/ccr/admin/scripts

– Unix process: $ORACLE_HOME/ccr/bin/nmz

Oracle Configuration Manager (OCM) administration

OCM database Systems Inventory Overview

OCM database Systems Inventory Overview on MOS

As I mentioned already, OCM will upload Oracle configuration information once a day to MOS server.
Every OCM configuration can be identified as a MOS System under MOS->Dashboard or -> Systems Tabs. There you can accomplish following tasks:
– Review individual OCM Configurations
– Review OCM Summary Inventory
– Review OCM Systems Health checks
– Create an Oracle Service Request based on your OCM System configuration which works quicker.
– Having OCM System configuration information, Oracle support usually asks fewer questions that saves valuable time during issue resolutions.

OCM System Service Requests on MOS

OCM System Details and Service Requests on MOS

OCM useful Unix commands:

emCCR -help

$ORACLE_HOME/ccr/bin/emCCR status  # OCM status

$ORACLE_HOME/ccr/bin/emCCR collect # Manually Configuration Collection

$ORACLE_HOME/ccr/bin/emCCR test

$ORACLE_HOME/ccr/bin/emCCR stop

$ORACLE_HOME/ccr/bin/emCCR stop

$ORACLE_HOME/ccr/bin/emCCR/emCCR set collection_interval # to change the collection time (see -help)

$ ps -ef | grep -i nmz

Oracle Configuration Manager (OCM) logs

ll $ORACLE_HOME/ccr/hosts/<host_name>/log/
ll $ORACLE_HOME /ccr/hosts/<hostname>/state/upload
ll $ORACLE_HOME /ccr/hosts/hostname/state/

cat $ORACLE_HOME /ccr/hosts/<host_name>/log/collector.log

Oracle Configuration Manager (OCM) notes and tips

– There are some issues and specialities for OCM cluster setup depends on the particular cluster configuration
– Luck of access rights mechanism to Systems’ configurations on MOS. In other worlds, MOS users assigned to an Oracle Customer Support Identifier (CSI) have access to the all OCM Systems’ configurations assigned to the same CSI.
– Several CSIs are supported, but you have to associate a new created OCM System with the specific CSI on MOS Website (Use Settings Tab).
– Note, that OCM a different product from OEM or Oracle Enterprise Manager Agent. However some functionality is redundant with OEM and OEM Grid/Cloud Control.

So that was high level description of installation and administration of Oracle Configuration Manager (OCM) and its usage benefits with combination to My Oracle Support (MOS).

Enjoyed this article? Please share it with others using the social site of your choice:

Add a Comment

We welcome thoughtful and constructive comments from readers.
If you want your own picture to show with your comment?
Go get a Globally Recognized Avatar!

DBMS Blog Updates : Subscribe RSS RSS: Subscribe to Articles · Subscribe to Comments Subscribe RSS Receive site updates via email