Shulou(Shulou.com)05/31 Report--

Editor to share with you what to do when there are PLS-00201 errors in rman duplicate. I believe most people don't know much about it, so share this article for your reference. I hope you will gain a lot after reading this article. Let's learn about it together.

The following error occurred in rman duplicate

APPLIES TO:Oracle Database-Enterprise Edition-Version 9.0.1.0 to 11.2.0.4 [Release 9.0.1 to 11.2]

SYMPTOMS

You are attempting to connect to the target database in RMAN and

Are receiving a "PLS-00201: identifier 'xxx...' must be declared"

Error:

Target database Password:

RMAN-00571: =

RMAN-00569: = ERROR MESSAGE STACK FOLLOWS =

RMAN-00571: =

RMAN-00554: initialization of internal recovery manager package failed

RMAN-04005: error from target database: ORA-06550: line 1, column 7:

PLS-00201: identifier 'DBMS_BACKUP_RESTORE.SET_CHARSET' must be declared

ORA-06550: line 1, column 7:

PL/SQL: Statement ignored

RMAN-04015: error setting target database character set to US7ASCII

Also, if you log into the target database as the user SYS and issue:

SQL > select *

From dba_objects

Where object_name like'% DBMS_BACKUP_RESTORE%'

You get 0 rows returned or the status is INVALID

CAUSE

The package identified in the PLS-00201 error was not successfully

Created when catproc.sql was originally run on this database. As

A general rule, for any RMAN "PLS-00201: identifier 'xxx...' must

Be declared "error, re-run catproc.sql.

Mainly because the package DBMS_BACKUP_RESTORE is missing.

SOLUTION

Re-run catproc.sql. This will in turn call the dbmsbkrs.sql script

Which creates the DBMS_BACKUP_RESTORE package.

NOTE: Keep inmind that running catproc.sql will invalidate all PL/SQL

And many other related objects.

Running catproc is recommended, as when the RMAN-packages are missing

There could be others missing aswell.

If the problem has been identified as RMAN-only, than run:

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

@? / rdbms/admin/prvtrmns.plb

@? / rdbms/admin/dbmsbkrs.sql

@? / rdbms/admin/prvtbkrs.plb

The above is all the contents of the article "what to do if there is a PLS-00201 error in rman duplicate". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.