Go to configure auto discovery option

Since we have already installed the agent on oel6-node01 hence it is showing under here.

Click on the host and it will enable discover now option. Click discover now




Ensure that dbsnmp account is open and password is set at database level.
SQL> select username,account_status from dba_users where username='DBSNMP';
USERNAME
--------------------------------------------------------------------------------
ACCOUNT_STATUS
--------------------------------
DBSNMP
EXPIRED & LOCKED
SQL> ALTER USER dbsnmp account unlock;
User altered.
SQL> select username,account_status from dba_users where username='DBSNMP';
USERNAME
--------------------------------------------------------------------------------
ACCOUNT_STATUS
--------------------------------
DBSNMP
EXPIRED
SQL> alter user dbsnmp identified by oracle;
User altered.
Click on the discovered target and promote which ever you want and ignore which you don’t want to be monitored.

You will be asked to set dbsnmp password. I am specifying common credential


Review and save


Now we are able to see the targets in OEM
