14 Discovering and Adding Database Targets

This chapter describes how you can discover and add database targets to be managed by Enterprise Manager Cloud Control. In particular, this chapters covers the following:

• Enabling Autodiscovery of Database Targets

• Discovering and Adding Container Database and Pluggable Database Targets

• Discovering and Adding Cluster Database Targets

• Discovering and Adding Single Instance Database Targets

• Discovering and Adding Cluster Targets

• Discovering and Adding Single Instance High Availability Service Targets

• Discovering and Adding Cluster Automatic Storage Management Targets

• Configuring a Target Database for Secure Monitoring

14.1 Enabling Autodiscovery of Database Targets

Autodiscovery of database targets is enabled by default. If autodiscovery has been disabled, you can enable it, by following these steps:

1. From the Setup menu, select Add Target, then select Configure Auto Discovery.
2. On the Configure Auto Discovery page, in the Agent-based Auto Discovery table, select Oracle Database, Listener, and Automatic Storage Management.
   
   

   

   
   
3. On the Configure Target Discovery page, click Add Host.
   
   

   

   
   
4. From the Search and Select Targets dialog box, select a target that you want to be configured, and click Select.
5. You can click Edit Parameters to edit the parameters of the target.

   Click OK.

14.2 Discovering and Adding Container Database and Pluggable Database Targets

This section describes the different methods in which you can discover, promote, and add container database (CDB) and pluggable database (PDB) targets in Cloud Control. In particular, this section covers the following:

• Discovering CDB and PDB Targets Using Autodiscovery

• Adding CDB and PDB Targets Using the Guided Discovery Process

• Adding CDB and PDB Targets By Using the Declarative Process

14.2.1 Discovering CDB and PDB Targets Using Autodiscovery

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

Note:

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.

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

Note:

By default, promoting a CDB target also promotes all its associated discovered PDB targets. Also, by default, Enterprise Manager runs a background job (every 24 hours) to automatically discover and promote newly created PDB targets present on managed hosts. Hence, to discover and promote PDB targets, you only need to discover and promote the associated CDB target, as described in this section.

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 must be dbsnmp; you cannot provide a different user name. However, if you specify SYSDBA for Role, then you can provide any SYSDBA user. Only SYSDBA users and the dbsnmp user have the privileges required for target monitoring.

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.

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

   
   

   

   
   

   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 must be dbsnmp; you cannot provide a different user name. However, if you specify SYSDBA for Role, then you can provide any SYSDBA user. Only SYSDBA users and the dbsnmp user have the privileges required for target monitoring.

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.

14.2.3 Adding CDB and PDB Targets By Using the Declarative Process

To add a CDB target and its associated PDB (and Application Root) targets by specifying target monitoring properties, follow these steps:

Note:

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 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, and the preferred string connection.

   
   

   

   
   

   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.

14.3 Discovering and Adding Cluster Database Targets

This section describes the different methods in which you can discover and add cluster database targets. In particular, this section cover the following:

• Discovering Cluster Database Targets Using Autodiscovery

• Adding Cluster Database Targets Using the Guided Discovery Process

• Adding Cluster Database Targets By Using the Declarative Process

14.3.1 Discovering Cluster Database Targets Using Autodiscovery

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

Note:

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.

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 must be dbsnmp; you cannot provide a different user name. However, if you specify SYSDBA for Role, then you can provide any SYSDBA user. Only SYSDBA users and the dbsnmp user have the privileges required for target monitoring.

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.

14.3.2 Adding Cluster Database Targets Using the Guided Discovery Process

To add cluster database targets using the guided process, follow these steps:

Note:

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. 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 must be dbsnmp; you cannot provide a different user name. However, if you specify SYSDBA for Role, then you can provide any SYSDBA user. Only SYSDBA users and the dbsnmp user have the privileges required for target monitoring.

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.

14.3.3 Adding Cluster Database Targets By Using the Declarative Process

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

Note:

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

6. Review the displayed information, then click Submit.

14.4 Discovering and Adding Single Instance Database Targets

This section describes the different methods in which you can discover and add single instance database targets. In particular, this section covers the following:

• Discovering Single Instance Database Targets Using Autodiscovery

• Adding Single Instance Database Targets Using Guided Discovery Process

• Adding Single Instance Database Targets By Using the Declarative Process

14.4.1 Discovering Single Instance Database Targets Using Autodiscovery

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

Note:

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.

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 must be dbsnmp; you cannot provide a different user name. However, if you specify SYSDBA for Role, then you can provide any SYSDBA user. Only SYSDBA users and the dbsnmp user have the privileges required for target monitoring.

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

14.4.2 Adding Single Instance Database Targets Using Guided Discovery Process

To add single instance database targets, follow these steps:

Note:

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. 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. 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 must be dbsnmp; you cannot provide a different user name. However, if you specify SYSDBA for Role, then you can provide any SYSDBA user. Only SYSDBA users and the dbsnmp user have the privileges required for target monitoring.

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.

14.4.3 Adding Single Instance Database Targets By Using the Declarative Process

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

Note:

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 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, that is, Oracle Home path, monitoring username and password, role, Listener machine name, port, database SID, and preferred connect string.

   

   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.

8. Review the displayed information, then click Submit.

14.5 Discovering and Adding Cluster Targets

This section describes the different methods in which you can discover and add cluster targets. In particular, this section covers the following:

• Discovering Cluster Targets Using Autodiscovery

• Adding Cluster Targets Using the Guided Discovery Process

• Adding Cluster Targets By Using the Declarative Process

14.5.1 Discovering Cluster Targets Using Autodiscovery

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

Note:

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.

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 must be dbsnmp; you cannot provide a different user name. However, if you specify SYSDBA for Role, then you can provide any SYSDBA user. Only SYSDBA users and the dbsnmp user have the privileges required for target monitoring.

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.

14.5.2 Adding Cluster Targets Using the Guided Discovery Process

To add cluster targets using the guided process, follow these steps:

Note:

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

14.5.3 Adding Cluster Targets By Using the Declarative Process

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

Note:

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

14.6 Discovering and Adding Single Instance High Availability Service Targets

This section describes the different methods in which you can discover and add single instance high availability service targets. In particular, this section covers the following:

• Discovering Single Instance High Availability Service Targets Using Autodiscovery

• Adding Single Instance High Availability Service Targets Using the Guided Discovery Process

• Adding Single Instance High Availability Service Targets By Using the Declarative Process

14.6.1 Discovering Single Instance High Availability Service Targets Using Autodiscovery

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

Note:

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.

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 must be dbsnmp; you cannot provide a different user name. However, if you specify SYSDBA for Role, then you can provide any SYSDBA user. Only SYSDBA users and the dbsnmp user have the privileges required for target monitoring.

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.

14.6.2 Adding Single Instance High Availability Service Targets Using the Guided Discovery Process

To add single instance high availability service targets using the guided process, follow these steps:

Note:

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

14.6.3 Adding Single Instance High Availability Service Targets By Using the Declarative Process

To add a single instance High Availability Service target declaratively by specifying target monitoring properties, follow these steps:

Note:

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

14.7 Discovering and Adding Cluster Automatic Storage Management Targets

This section describes the different methods in which you can discover and add ASM cluster targets. In particular, this section covers the following:

• Discovering Cluster ASM Targets Using Autodiscovery

• Adding Cluster ASM Targets Using the Guided Discovery Process

• Adding Cluster ASM Targets By Using the Declarative Process

14.7.1 Discovering Cluster ASM Targets Using Autodiscovery

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

Note:

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.

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 must be dbsnmp; you cannot provide a different user name. However, if you specify SYSDBA for Role, then you can provide any SYSDBA user. Only SYSDBA users and the dbsnmp user have the privileges required for target monitoring.

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.

14.7.2 Adding Cluster ASM Targets Using the Guided Discovery Process

To add cluster ASM targets using the guided process, follow these steps:

Note:

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. 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 must be dbsnmp; you cannot provide a different user name. However, if you specify SYSDBA for Role, then you can provide any SYSDBA user. Only SYSDBA users and the dbsnmp user have the privileges required for target monitoring.

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.

14.7.3 Adding Cluster ASM Targets By Using the Declarative Process

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

Note:

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

14.8 Configuring a Target Database for Secure Monitoring

This section covers the following:

• About Secure Monitoring of Databases

• Configuring a Target Database for Secure Monitoring

14.8.1 About Secure Monitoring of Databases

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.

14.8.2 Configuring a Target Database for Secure Monitoring

You can enable secure monitoring either while discovering a target database, or by changing the secure monitoring settings for a selected target database after discovery. Follow these steps to change the settings of a discovered database target:

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.

14.9 Adding Connection Manager Targets By Using the Declarative Process

To add a Connection Manager 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, enter the host and select Connection Manager as the target type.

4. Click Add.

5. On the Add: Connection Manager page, specify a name and the credentials.

6. Specify all the properties of the target, that is, Connection Manager Name, Connection Protocol, Machine Name, Oracle Home, Port Number, and cman.ora Directory.

7. Click OK.

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