G Configuring Database and ASM Targets for Monitoring

In the Enterprise Manager Grid Control console, when you view the Home page for an Oracle Database target for the first time, the Database Home page may not display any monitoring data, and the status of the database may indicate that there is a metric collection error. This is because the DBSNMP credentials have not been configured, or have been locked due to unsuccessful login attempts.

Similarly, when you view the Home page of an Oracle Automatic Storage Management (Oracle ASM) target for the first time, the status of the Oracle ASM instance may be unknown or unavailable, and the Home page may indicate that the Management Agent is unavailable (down). Again, this is because you have not specified the ASM SYS credentials.

To fix this problem for an Oracle Database target, follow these steps:

1. If your DBSNMP user account is locked, then unlock it. To do so, follow these steps:

   1. In Grid Control, click Targets and then Databases.

   2. On the Databases page, from the table that lists all databases, click a database name.

   3. On the Database Home page, click the Server tab.

   4. On the Server page, from the Security section, click Users. If you are prompted to log in to the database, make sure to use a database user account with DBA privileges such as SYSTEM.

   5. On the Users page, find and select the DBSNMP user account. From the Actions list, select Unlock User, and click Go. If you are asked to confirm whether you want to unlock the DBSNMP user account, click Yes.

2. Set the monitoring credentials for a standalone Oracle Database or Oracle RAC database. To do so, follow these steps:

   1. In Grid Control, click Targets and then Databases.

   2. On the Databases page, find and select the database target and click Monitoring Configuration.

   3. On the Properties page, specify the password for the DBSNMP user in the Monitor Password field. To verify the monitoring credentials, click Test Connection.

   4. If the connection is successful, click Next, then click Submit.

3. Set the monitoring credentials for Oracle ASM. To do so, follow these steps:

   1. In Grid Control, click Targets and then Databases.

   2. On the Databases page, find and select the Oracle ASM target and click Monitoring Configuration.

   3. On the Properties page, specify the password for the ASMSYS user in the Password field. To verify the monitoring credentials, click Test Connection.

   4. If the connection is successful, click Next, then click Submit.