Saturday, April 16, 2016

How to Recreate the DBSNMP User and OEM_MONITOR Role in a 10g/11g target database

How to Recreate the DBSNMP User and OEM_MONITOR Role in a 10g/11g target database

The DBSNMP user and OEM_MONITOR role be recreated in a 10g or higher database in order to configure it for monitoring.

Solution:

1.Connect to the database as SYS user.

2.Drop any orphaned data from the DBSNMP user:

SQL> @?/rdbms/admin/catnsnmp.sql

3.Create the DBSNMP user:
SQL> @?/rdbms/admin/catsnmp.sql

4. Set the DBSNMP password and unlock the account:
SQL> alter user dbsnmp identified by <password> account unlock;

Note: this applies to 10g, 11.1, 11.2 and 12c target databases. Also, the OEM_MONITOR role will get recreated with the catsnmp.sql script above and granted automatically to DBSNMP.

No comments:

Post a Comment