Error:
When connecting to rman, “PLS-00201: identifier ‘DBMS_BACKUP_RESTORE.SET_CHARSET’ must be declared” error and connection could not be established.
Reason:
Problematic DBMS_BACKUP_RESTORE package or invalid sys objects or database logon triggers may change the current firmware.
Solution:
First check the logon triggers. If all the connections have a trigger that changes the current thread, delete it.
or
If there are invalid objects in the SYS diagram, recompile them to make them valid.
or
Either open your database with startup upgrade and run the utlrp.sql after catupgrd.sql or run dbmsbkrs.sql and prvtbkrs.plb scripts
1 2 3 |
SQL> startup upgrade SQL> @?/rdbms/admin/catupgrd.sql SQL> @?/rdbms/admin/utlrp.sql |
or
1 2 |
SQL> @?/rdbms/admin/dbmsbkrs.sql SQL? @?/rdbms/admin/prvtbkrs.plb |