Sunday 9 February 2014

OEM 12c How to Drop Cluster Database Target

OEM 12c How to Drop Cluster Database Target and how to drop the Cluster.

Below steps can be used to do many other similar tasks, relate to oem Agents.

  1. Click Setup > Manage Cloud Control > Agents
  2. Select the number in column "Monitored Targets" for the 1st node
  3. There you can select the Cluster and Cluster Database
  4. Once selected, click Cluster (on top left)
  5. Click Target Setup > Remove Target
  6. Click Yes to confirm
  7. (Do similar with other nodes)

Thursday 6 February 2014

New to Enterprise Manger Cloud Control 12c (oem 12c)

Some Useful links and topics of Oracle Enterprise Manager 12c (OEM 12c):

oem 12c User administration

  • Login as SYSMAN user or other super admin user
  • Click Setup (top left) > Select Security > Click Administration 
  • Here you can add / edit or delete oem 12c users


oem 12c: Administer Monitoring Templates
http://www.youtube.com/watch?v=xk9y5299dX0

How to add RAC Databases to Enterprise Manager Cloud Control 12c http://www.gokhanatil.com/2014/01/how-to-add-rac-databases-to-enterprise-manager-cloud-control-12c.html 

  1. Click "Configure Auto Discovery"
  2. Click "Oracle Database, Listener and Automatic Storage Management"
  3. Add Clusterwaer Home e.g. /u01/app/11.2.0.3/grid


  1. Add Targets Manually
  2. Add Targets Using Guided Process (Also Adds Related Targets)
  3. Select "Oracle Cluster and HA Service"
  4. Click "Add Using Guided Process"
  5. Select 1st node click "Select"
  6. Click Continue

  1. Add Targets Manually
  2. Select "Add Targets Declaratively by Specifying Target Monitoring Properties"
  3. Target Type: Cluster Database
  4. Select 1st node
  5. Click Manullay

Tips to get some of the info:

  • cemutlo -n (Cluster name)
  • srvctl config scan
  • srvctl status SCAN_LISTENER

oem 12c: Incident Management: Use Incident Rule Sets




Oracle 12c clusterware ONS port

$ cat /u01/app/11.2.0.3/grid/opmn/conf/ons.config

(05 Jan 2014) I used the value remoteport value 6200, and it worked