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

To promote a CDB target and its associated PDB targets using automatic discovery, follow these steps:

1. From the Setup menu, select Add Target, then select Auto discovery Results. Click Agent-based Targets.

2. Search for and select the Database Instance target that you want to promote, then click Promote.

   Note:

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

   

   
   

3. On the Promote Target: 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 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.

   
   

   

   
   

   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.

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

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

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

7. Click Next.

8. Review the displayed information, then click Submit.

To add a CDB target and its associated PDB (and Application Root PDB) targets using a guided discovery process, 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 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.

   
   

   

   
   

   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.

   
   

   

   
   

   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.

To add a CDB target and its associated PDB (and Application Root) targets 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 Declaratively.

3. In the Add Target Declaratively dialog box, select Pluggable Database, and click Add...

   For Monitoring Agent, specify the Management Agent present on the CDB host. Click Add Manually.

4. On the Add Pluggable Database: Specify Container Database page, specify the CDB or click the search icon to select the CDB to which the target will be added.

   Click Continue.

   
   

   

   
   

5. On the Add Pluggable Database: Properties page, specify a unique name for the target, the name, the default service name, the OMS preferred string connection, and the Agent preferred connect string.

   Note:

   In Enterprise Manager Release Update 12 and later, Service Name is now supported through Preferred Connection Strings. For more information, please view the following Preferred Connect Strings.

   
   

   

   
   

   Expand the Container Database section to verify the properties of the CDB.

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

   Click Continue.

6. Specify the required information on each page and then click Next, until you reach the Review page.

7. Review the displayed information, and then click Submit.

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

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 discovered cluster database target 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 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.

To add cluster database targets using the guided process, 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 Using Guided Process.

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

4. On the Database Discovery: Search Criteria page, specify the cluster database host, or click on the Specify Host or Cluster search icon to select the cluster.

   
   

   

   
   

   If the host you select is a member of a cluster, then use this page to also indicate whether the database 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 host target, click Select.

   You get an option to choose if you want to search for cluster 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 cluster database 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.

   Click Next.

5. On the Database Discovery: Results page, under the Databases section, in the Cluster Databases section, select the cluster database target that you want to add.

   
   

   

   
   

   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 Configure. Select the Instances tab, then click Add or Remove. Click Save.

   
   

   

   
   

6. Specify the monitoring credentials for the selected cluster database 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.

   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.

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

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

9. Click Next.

10. Review the displayed information, then click Submit.

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

3. In the Add Target Declaratively dialog box, select Cluster Database, and click Add...

4. On the Configure Cluster Database: Properties, specify a name and a database system name for the cluster database target. Next, specify all the properties of the target, that is, Oracle Home path, monitoring username and password, role, Listener machine name, port, database SID, and preferred connect string.

   
   

   

   
   

   Click Next.

5. Specify all the details required on the Install Packages, Credentials, and Parameters pages. Click Next after each page until you reach the Review page.

   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.

6. Review the displayed information, then click Submit.

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

To promote single instance database targets, 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 discovered database instance target that you want to add for monitoring, and click Promote.

   

2. The Promote Targets:Result page displays the databases Select the database instance.

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

   

3. Specify the monitoring credentials for the selected database instance 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 database instance 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. On the Configure Database Instance: Properties, specify a name and a database system name for the database instance target. Next, specify all the properties of the target.

   Note:

   In Enterprise Manager Release Update 12 and later, Service Name is now supported through Preferred Connection Strings. For more information, please view the following Preferred Connect Strings.

7. Click Next.

8. Review the displayed information, then click Submit.

To add single instance database targets, 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 Using Guided Process.

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

4. On the Database Discovery: Search Criteria page, specify the database instance host, or click on the Specify Host or Cluster search icon to select the host.

   

   If the host you select is a member of a cluster, then use this page to also indicate whether the databases 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 host, click Select.

   You get an option to choose if you want to search for 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 database 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.

   Click Next to proceed with the discovery process.

   Click Next.

5. The Database Discovery:Result page displays the databases discovered on the cluster. Select the database

   On the Database Discovery: Results page, under the Databases section, in the Single Instance Databases section, select the database instance target that you want to promote.

   

6. On the Configure Database Instance: Properties, specify a name and a database system name for the database instance target. Next, specify all the properties of the target.

   Note:

   In Enterprise Manager Release Update 12 and later, Service Name is now supported through Preferred Connection Strings. For more information, please view the following Preferred Connect Strings.

7. Click Test Connection to test the connection made to the database instance target using the specified monitoring credentials.

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

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

10. Click Next.

11. Review the displayed information, then click Submit.

To add a single instance 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 Declaratively.

3. In the Add Target Declaratively dialog box, select Database Instance.

4. In the Monitoring Agent field, select the Management Agent monitoring the database.

5. Click Add...

6. On the Configure Database Instance: Properties, specify a name and a database system name for the database instance target. Next, specify all the properties of the target.

   Note:

   In Enterprise Manager Release Update 12 and later, Service Name is now supported through Preferred Connection Strings. For more information, please view the following Preferred Connect Strings.

   

   Click Next.

7. Specify all the details required on the Install Packages, Credentials, and Parameters pages. Click Next after each page until you reach the Review page.

   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.

8. Review the displayed information, then click Submit.

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

To promote cluster targets, 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 discovered cluster target that you want to add for monitoring, and click Promote.

   

2. The Promote Targets:Result page displays the hosts discovered on the cluster. Select the host that you want to promote.

   Note:

   A host can belong to only one cluster. If a particular host is not displayed, it can mean that the host belongs to another cluster.

   On the Promote Target: Results page, in the Clusters section, select the cluster target that you want to promote.

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

3. In the Clusters section, specify the monitoring credentials for the selected cluster 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.

4. Click Test Connection to test the connection made to the cluster 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.

To add cluster targets using the guided process, 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 Using Guided Process.

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

4. On the Cluster Discovery: Specify Host page, specify the cluster host, or click on the Specify Host or Cluster search icon to select the cluster.

   
   

   

   
   

   If the host you select is a member of a cluster, then use this page to also indicate whether the clusters 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 cluster 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 cluster 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.

   Click Next to proceed with the discovery process.

   Click Next.

5. The Cluster Discovery:Result page displays the hosts discovered on the cluster. Select the host that you want to add.

   Note:

   A host can belong to only one cluster. If a particular host is not displayed, it can mean that the host belongs to another cluster.

   On the Cluster Discovery: Result page, in the Clusters Target Properties section, verify the properties of the cluster.

   
   

   

   
   

   If you want to add or remove a host, select a host from the Cluster Host and High Availability Service Targets section. Click Add or Remove.

6. Click Next.

7. Review the displayed information, then click Submit.

To add a cluster 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 Declaratively.

3. In the Add Target Declaratively dialog box, select Cluster.

4. In the Monitoring Agent field, select the Management Agent monitoring the database.

5. Click Add...

6. On the Cluster Discovery:Result page, specify the target name, Oracle Home, SCAN name, SCAN port, and ONS port.

   
   

   

   
   

   Note:

   The SCAN name, SCAN port, and ONS port properties are applicable only for Clusterware versions 11.2 and higher.

7. You can add more hosts and high availability service targets to the cluster. If a particular host is not displayed when you click Add, it is possible that the host already belongs to another cluster.

   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.

   Click Next.

8. Review the displayed information, then click Submit.

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

To promote single instance high availability targets, follow these steps:

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

   Note:

   If you do not see any results, then autodiscovery of targets has been disabled. To enable autodiscovery refer to Enabling Autodiscovery of Database Targets.

   From the results table, from the Agent-based targets tab, select the discovered High Availability instance target that you want to add for monitoring, and click Promote.

   
   

   

   
   

2. The Promote Targets:Result page displays the High Availability instances discovered. Select the database

   On the Promote Target: Results page, under the High Availability Services section, select the SIHA target that you want to promote.

3. Specify the monitoring credentials for the selected SIHA 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.

4. Click Test Connection to test the connection made to the SIHA 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.

To add single instance high availability service targets using the guided process, 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 Using Guided Process.

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

4. On the Cluster Discovery: Specify Host page, specify the single instance high availability service host, or click on the Specify Host or Cluster search icon to select the cluster.

   
   

   

   
   

   Click Next.

5. The Cluster Discovery:Result page displays the high availability service instances discovered.

   On the Cluster Discovery: Result page, under the High Availability Services section, select the high availability service instance target that you want to promote.

   
   

   

   
   

6. Click Next.

7. Review the displayed information, then click Submit.

To add a single instance High Availability Service 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 Declaratively.

3. In the Add Target Declaratively dialog box, select Oracle High Availability Service.

4. In the Monitoring Agent field, select the Management Agent monitoring the database.

5. Click Add...

6. On the High Availability Service: Result page, specify a name for the target, the Oracle home, and the ONS port.

   
   

   

   
   

   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.

   Click Next.

7. Review the displayed information, and then click Submit.

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

To promote Cluster Automatic Storage Management targets using autodiscovery, follow these steps:

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

   Note:

   If you do not see any results, then autodiscovery of targets has been disabled. To enable autodiscovery refer to Enabling Autodiscovery of Database Targets.

   From the results table, from the Agent-based targets tab, select the discovered cluster ASM target that you want to add for monitoring, and click Promote.

   
   

   

   
   

2. The Promote Targets:Result page displays the targets discovered on the cluster ASM.

   On the Promote Target: Results page, in the Cluster ASM section, select the target that you want to promote.

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

3. In the cluster ASM section, specify the monitoring credentials for the selected cluster ASM 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.

4. Click Test Connection to test the connection made to the cluster ASM 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 targets 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.

To add cluster ASM targets using the guided process, 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 Using Guided Process.

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

4. On the Database Discovery: Search Criteria page, specify the cluster ASM host, or click on the Specify Host or Cluster search icon to select the cluster.

   
   

   

   
   

   If the host you select is a member of a cluster, then use this page to also indicate whether the Automated Storage Managers 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 ASM 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 ASM 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.

   Click Next to proceed with the discovery process.

   Click Next.

5. The Database Discovery:Result page displays the targets discovered on the cluster ASM target.

   On the Database Discovery: Results page, in the Cluster ASM section, select the target that you want to promote.

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

6. In the cluster ASM section, specify the monitoring credentials for the selected cluster ASM 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.

7. Click Test Connection to test the connection made to the cluster ASM target using the specified monitoring credentials.

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

9. If you have selected multiple targets 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.

10. Click Next.

11. Review the displayed information, then click Submit.

To add a cluster ASM 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 Declaratively.

3. In the Add Target Declaratively dialog box, select Cluster ASM.

4. In the Monitoring Agent field, select the Management Agent monitoring the database.

5. Click Add...

6. On the Configure Cluster ASM: Properties page, specify a name for the Cluster ASM, the Oracle home path, username and password, role, cluster name, and service name.

   Note:

   The Service Name is used to establish the cluster ASM connection. It should be one of the service names the cluster ASM registers with the listeners.

7. You can add instances, ASM IO server instances, and ASM proxy instances by clicking Add in the respective sections.

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

   OK.

The Oracle Database uses various encryption algorithms to secure the information moving across the network between the Oracle Database Server and a client. The Enterprise Manager agent communicates with the Database target over a TCP protocol to get real-time monitoring data. The Oracle Management Server (OMS) also communicates with the Database target in clear text over the network to manage the target. As TCP transfers data in clear text format over the network, anyone can access and modify the data. To secure the data exchanges between the OMS and managed target, Enterprise Manager can use the TCPS protocol to encrypt and protect the data.

The Secure Monitoring feature in Enterprise Manager allows you to monitor Oracle Database targets on secure channels using a TCP/IP with SSL (Secure Socket Layer) protocol. You can also discover and monitor the Listener processes running on TCPS ports using the Enterprise Manager console.

You can choose from the following options available for target monitoring:

• Target Monitoring over TCP

  In this case, Enterprise Manager connects to the target database for target monitoring using the TCP protocol. The data communication between the target database and the Enterprise Manager OMS happens in clear text form over the network.

• Target Monitoring over TCPS with Server Authentication using Trusted Certificate

  Enterprise Manager connects to the target database TCP over a secure socket layer (SSL) for target monitoring. In this case, the client authenticates the database server using a trusted certificate of the server. The data communicates over the network between Enterprise Manager and the target database in encrypted form.

• Target Monitoring over TCPS with Server Authentication using Kerberos

  Enterprise Manager connects to the target database TCP over a secure socket layer (SSL) for target monitoring. In this case, the client authenticates the database server using the Kerberos authentication protocol. The data communicates over the network between Enterprise Manager and the target database in encrypted form.

You can enable secure monitoring while discovering the target database, or you can change the secure monitoring settings for a target database on the Monitoring Configuration page.

1. From the Enterprise Manager page, choose Databases from the Targets menu.

   Enterprise Manager displays the Databases page.

2. Choose the database for which you want to configure monitoring.

   The Database Home page for that database appears.

3. From the Oracle Database menu, select Monitoring Configuration from the Target Setup menu.

   Enterprise Manager displays the Configure Database Instance: Properties page.

4. On the Configure Database Instance: Properties page, scroll down to the Connection Protocol field and select from one of the following drop-down menu choices:

   • TCP -- Enterprise Manager connects to the target database for target monitoring using the TCP protocol. The data communication between the target database and the Enterprise Manager OMS happens in clear text form over the network.

   • TCPS -- Enterprise Manager connects to the target database TCP over a secure socket layer (SSL) for target monitoring. In this case, the client authenticates the database server using a trusted certificate of the server. The data communicates over the network between Enterprise Manager and the target database in encrypted form.

   • TCPS with Server Authentication using Kerberos -- Enterprise Manager connects to the target database TCP over a secure socket layer (SSL) for target monitoring. In this case, the client authenticates the database server using the Kerberos authentication protocol. The data communicates over the network between Enterprise Manager and the target database in encrypted form.

5. Optionally you can test the connection by clicking Test Connection to determine whether the change in Connection Protocol has impacted the connection to the database.
6. Click Next to move to the Configure Database Instance: Review Page.
7. Click Submit to apply your changes.

   The database target now connects using the protocol you selected.