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 this post Share on Facebook5Share on Google+0Share on LinkedIn17Share on Reddit0Tweet about this on Twitter

Gokhan Atil is a database administrator who has hands-on experience with both RDBMS and noSQL databases (Oracle, PostgreSQL, Microsoft SQL Server, Sybase IQ, MySQL, Cassandra, MongoDB and ElasticSearch), and strong background on software development. He is certified as Oracle Certified Professional (OCP) and is awarded as Oracle ACE (in 2011) and Oracle ACE Director (in 2016) for his continuous contributions to the Oracle users community.


  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. Required fields are marked *