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.

7 Responses to “How to Add RAC Databases to Enterprise Manager Cloud Control 12c”

  1. Abb Umayr says:

    Can you please direct me, how I get the ONS Port?


  2. sachin says:

    I come across many thing that fixed my EM12c problem.

    Thank you very much.

  3. Hi,

    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 says:

      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.

  4. 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 says:

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

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


Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code class="" title="" data-url=""> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong> <pre class="" title="" data-url=""> <span class="" title="" data-url="">