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.

    Auto Discovery Results page

  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.

    Promote Target page

  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.