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”.

Add Cluster Target

Go to “Add Targets Manually” page (setup>add target), select “Add Targets Using Guided Process” and select  “Oracle Cluster and High Avaliablity Service”.

Select Node

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.

Cluster Discovery

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.

Add RAC Database

Go to “Add Targets Manually” page again, select “Add Targets Using Guided Process” and select  “Oracle Database, Listener and Automatic Storage Manager”.

Select Cluster

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

RAC Discovery

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.

Please share

AWS Big Data Specialist. Oracle Certified Professional (OCP) for EBS R12, Oracle 10g and 11g. Co-author of "Expert Oracle Enterprise Manager 12c" book published by Apress. Awarded as Oracle ACE (in 2011) and Oracle ACE Director (in 2016) for the continuous contributions to the Oracle users community. Founding member, and vice president of Turkish Oracle User Group (TROUG). Presented at various international conferences including Oracle Open World.


  1. sachin

    I come across many thing that fixed my EM12c problem.

    Thank you very much.

  2. Bar


    I have a problem…

    When I want to “Add Targets Using Guided Process”  — > Cluster and Oracle High Availability Service –> select one of the nodes which is part of the cluster and click “Discover Target” I have error:

    Warning No cluster was found on the host XXXX

    please help, what can I do ? First I add agent to node of RAC

    • Gokhan Atil

      Hi Bar,

      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.

      If the problem persists, you may open a SR to oracle support.

  3. Hari

    What if I have two different users for Grid and RAC database.

    For eg :- grid ==> For Clusterware and ASM

    oracle ==> For RAC database.


    • Gokhan Atil

      You can use any user sharing same group with grid and oracle software (i.e. oinstall).

    • Hari

      Couple of new queries

      1. What about the activities that needs root access. Like restarting the cluster. How is that managed.

      2. While deploying agents. Do we need to deploy on all nodes or one node is sufficient and that will take care of all other nodes.

      I am asking this as I am adding a Qurater Rack Exadata machine to my OEM 12C.


  4. Mohsin


    When I want to “Add Targets Using Guided Process” — > Cluster and Oracle High Availability Service –> select one of the nodes which is part of the cluster and click “Discover Target” I have error:

    java.lang.NullPointerException javax.el.ELException: java.lang.NullPointerException

  5. jko

    Hi Gokhan ,

    With OEM 13 the issue with policy managed database when a database is relocated to another aper to be still there.

    Do you have any tips on that.



Leave Comment

Your email address will not be published.

This site uses Akismet to reduce spam. Learn how your comment data is processed.