How to Add RAC Databases to Enterprise Manager Cloud Control 12c

It’s been asked several times to me how to add RAC (Clustered Databases) to Enterprise Manager 12c. Finally I found time to get screenshots and prepare a step-by-step guide. The interesting point about adding Clustered Databases is, when you try to discover (and add) a cluster databases like you do a stand-alone database, EM12c does not show you an error but the process doesn’t complete. It makes users to feel like there’s a bug. In fact, it’s just because user miss a required step.

So how to add a RAC Database? First of all, we need to deploy agents to all nodes. you can find related document on my blog. After you deployed agents to all nodes, we’ll add “Oracle Cluster and High Avaliablity Service”.

Select one of the nodes which is part of the cluster. You don’t need to select all hosts (in fact it doesn’t let you do multiple-select, and one node is enough.

It’ll discover the other nodes, and show you the findings so you may edit them if required. Click “Next”, review and then save the cluster. Now we have the cluster information, so we can add our clustered (RAC) database.

Instead of picking one of nodes, now you need to select “cluster” (we previously discovered and added to EM12c). Click “Next”.

It’ll discover databases and ASM. Click the checkboxes of the discovered objects, enter the required passwords (of DBSNMP and ASMSNMP users) then click “Next”. You’ll be able to review the result and add the database to EM12c by clicking “Save”. So we successfully added our RAC Databases(s) to EM12c.

Is this the first time you tried to add that target? I mean if you have previously tried to add it but failed somehow, repository may still have the cluster information. You may try to remove/add the agent and then re-try to discover the target.