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)

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

• Part 1: http://www.youtube.com/watch?v=SWjZM1ugPDc
• Part 2: http://youtu.be/IhPtcq8nEP4

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         

Standby common sqls

select thread#, max(sequence#) as "Last_Applied_Log" from v$log_history group by thread#; select process, status, sequence# from v$managed_standby; alter database recover managed standby database disconnect from session; alter database register logfile '/u02/oracle/backup_arch/o1_mf_1_57518_93s5gop2_.arc'; alter database register logfile '/u02/oracle/backup_arch/o1_mf_1_57519_93s5v0pm_.arc'; ... or you can try to use rman to register a group of them e.g. RMAN> catalog start with '/u01/oracle/arch/arc'; Shutdown Standby select process, status, sequence# from v$managed_standby; alter database recover managed standby database cancel; shutdown immediate Restore archivelog from RMAN backup. restore archivelog from logseq 69124 until logseq 69134; -- or restore archivelog from logseq 69135;