RMAN : PLS-00201: identifier ‘DBMS_BACKUP_RESTORE.SET_CHARSET’ must be declared

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

or

dbtut
Author: dbtut

We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.

Leave a Reply

Your email address will not be published. Required fields are marked *