Adding Cluster Database Targets By Using the Declarative Process

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.

Prerequisites:

For Clusterware 23ai, to use REST based methods, using the command below in the root folder, set the password for the events user, which will be used to monitor the clusterware events using the clusterware REST API.

./srvctl modify cdp -passfile_events <location of password file>

To add a cluster database target declaratively by specifying target monitoring properties, follow these steps:

  1. From the Setup menu, select Add Target, then select Add Targets Manually.

  2. On the Add Targets Manually page, select Add Target Manually.

  3. In the Add Target Manually dialog box, select the search icon and select the host on which the target resides from the Select Host dialog box and click Select. Select Cluster from the Target Type list, and select Add....

  4. Specify the Cluster Target Properties: Target Name, Oracle Home, SCAN Name, SCAN Port, ONS Port.

  5. If the target cluster is using Oracle Database 23ai, a Clusterware REST API Properties tab will be available. Setting the REST API properties is optional, but recommended.

    • Specify the cdp port and password for the Clusterware events user. All other fields should be prepopulated. Select Save.

  6. By default, selecting a 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 Add or Remove.

  7. To specify global target properties for all the targets you have selected click Set Global Target Properties, specify the required properties, then click OK. Select Save.

  8. Select Discover Target.