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