Adding CDB and PDB Targets Using the Guided Discovery Process

To add a CDB target and its associated PDB (and Application Root PDB) targets using a guided discovery process, follow these steps:

Note:

  • You can also add Application Root PDBs. However, they are not explicitly shown as Application Root Pluggable Database, but just as Pluggable Database.

  • A database system is automatically created on discovery of an Oracle Database. The system is built on the new target and association model that can be used to monitor the database's storage, connectivity, and high availability. This also enables you to monitor and manage applications that are dependent on the database. Database System topology can be used to view relationship between various entities within the database system as well as external dependencies.

    A database system contains a primary database and related targets such as Listener and Automatic Storage Management. It also includes standby databases and their related targets if the database is in a Data Guard configuration. However, you cannot create database systems for standby databases.

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

  2. On the Add Targets Manually page, select Add Using Guided Process.

  3. In the Add Using Guided Process dialog box, select Oracle Database, Listener, and Automatic Storage Management. Click Add...

  4. Select Add Targets Using Guided Process (Also Adds Related Targets). For Target Types, select Oracle Database, Listener, and Automatic Storage Management. Click Add Using Guided Process.

  5. On the Database Discovery: Search Criteria page, for Specify Host or Cluster, specify the CDB host.


    Database discovery search criteria page

    If the host you select is a member of a cluster, then use this page to also indicate whether the PDB targets should be searched only on the selected host or on all hosts within the cluster.

    After you click the search icon, a Select Targets dialog box appears. Specify the target name or select a target from the target table. You can filter the search to search for all down targets or up targets, by clicking the filter arrows in the Status column.

    You can also configure your search by clicking the Configuration Search icon. After you select the CDB, click Select.

    You get an option to choose if you want to search for pluggable database targets only on the current host that you selected, or on all the hosts in the cluster that the host target is a member of.

    This option enables you to save time, if you want to search for PDB targets only on the current host selected.

    The Discovery Options section enables you to specify discovery hints. You can specify additional discovery options to change the default discovery behavior. Supported hints are db_name, db_target_prefix, db_target_suffix, discovery_timeout <in seconds per host>, and no_db_domain.

    For example,

    db_name=PRODUCTS, discovery timeout=15.

  6. Click Next.

  7. On the Database Discovery: Results page, under the Databases section, select the CDB target.

    By default, selecting a CDB target for promotion also selects all its associated and discovered PDB (and Application Root PDB) targets for promotion. If you want to add or remove a PDB target from the ones selected for promotion, select the CDB target, then click Configure. Select the Pluggable Databases tab, then click Add or Remove. Click Save.


    Configure pdb targets

    Enterprise Manager runs a background job (every 24 hours) to automatically discover and promote newly created PDB targets present on managed hosts. If you do not want Enterprise Manager to automatically promote the PDB targets associated with a particular CDB target, and instead want to promote them manually, select the CDB target on the Promote Target: Results page, then click Configure. Select the Pluggable Databases tab, then select Manual for Pluggable Database Discovery Mode. Click Save.

  8. Specify the monitoring credentials for the selected CDB target, that is, the user name, 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.

  9. Click Test Connection to test the connection made to the CDB target using the specified monitoring credentials.

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

    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.

  11. Click Next.

  12. Review the displayed information, then click Submit.