Autodiscovery of cluster databases is enabled by default. If autodiscovery has been disabled, follow the steps described in Enabling Autodiscovery of Database Targets.

Oracle Clusterware is a high availability framework that provides the infrastructure necessary to run the cluster systems called Oracle Real Application Clusters (RAC). It manages RAC resources, such as virtual IP (VIP) addresses, databases, listeners, and storage, and it enables them to communicate with each other, so that they appear to function as a single system (cluster).

Enterprise Manager discovers a cluster as a Cluster Database target. A database system and Oracle High Availability Services are automatically associated with a Cluster Database. A database system contains a primary database and related targets such as listeners, Automatic Storage Management (ASM) and Oracle Homes. The Database System topology can be used to view relationship between various entities within the database system as well as external dependencies.

Starting with Oracle Clusterware 23ai, you can use the REST APIs to gather clusterware events information. Events are critical for monitoring and managing RAC, as they indicate changes in cluster state and resource health.

To promote cluster database targets using autodiscovery, follow these steps:

1. From the Setup menu, select Add Target, and then select Auto Discovery Results.

   From the results table, from the Agent-based targets tab, select the Cluster Database and Oracle High Availability Service that you want to add for monitoring, and click Promote.

2. The Promote Targets: Result page displays the databases discovered on the cluster. Select the cluster database

   On the Promote Target: Results page, under the Databases section, in the Cluster Databases section, select the cluster database target that you want to promote.

   By default, selecting the cluster database target for promotion also selects all its associated discovered database instance targets for promotion. If you want to add or remove a database instance target from the ones selected for promotion, select the cluster database target, then click Configure. Select the Instances tab, then click Add or Remove. Click Save.

3. In the Cluster Databases section, specify the monitoring credentials for the selected cluster database target, that is, the Monitor user name, Monitor password, and role. Also, if you want the selected target to be added to a group, specify a value for Group.

   If you specify Normal for Role, then the user name can be dbsnmp or a DB monitoring user. If you specify SYSDBA for Role, then you can provide any SYSDBA user.

   Note:

   Enterprise Manager lets you use the job system to automate database password change for the monitoring user. See Automate Monitoring and Non-monitoring User Password Management for more information.

4. Click Test Connection to test the connection made to the cluster database target using the specified monitoring credentials.

5. To specify global target properties for all the targets you have selected on the Promote Target: Results page, click Set Global Target Properties, specify the required properties, then click OK.

   To specify a common group for all the targets you have selected on the Promote Target: Results page, click Specify Group for Targets, select a group, then click Select.

6. If you have selected multiple databases and you want to set the same monitoring properties for all of them, select Specify Common Monitoring Credentials. Enter the monitoring credentials, monitoring password, and role. Click Apply.

7. Click Next.

8. Review the displayed information, then click Submit.