Shulou(Shulou.com)06/01 Report--

Oracle manually built the library after rman can not be enabled how to do, many novices are not very clear about this, in order to help you solve this problem, the following editor will explain in detail for you, people with this need can come to learn, I hope you can gain something.

Rman cannot be enabled after oracle manually builds the database. RMAN-04015 error is reported.

The solution is as follows:

SQL > shutdown immediate

SQL > startup upgrade

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

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

SQL > shutdown immediate

SQL > startup

Where:

The function of utlirp.sql is to compile all the relevant content under the 32bit platform.

The function of utlrp.sql is to compile all invalid objects.

And then re-

RMAN TARGET /

[oracle@ydkfdb21 test_bk] $rman target /

Recovery Manager: Release 10.2.0.4.0-Production on Wed Jun 20 13:19:34 2012

Copyright (c) 1982, 2007, Oracle. All rights reserved.

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

[oracle@ydkfdb21 test_bk] $

And then

8. Follow the catalog steps to create a data dictionary

SQL > start D:\ oracle\ product\ 10.1.0\ db_1\ rdbms\ admin\ catalog.sql

9. Execute catproc to create package package

SQL > start D:\ oracle\ product\ 10.1.0\ db_1\ rdbms\ admin\ catproc.sql

10. Execute pupbld

Before executing pupbld, convert the current user (sys) to system, that is, connect to the database with a system account. Because this database is newly built, the password of system is the default password of the system, namely manager. You can reset the password for this account after the database has been built.

SQL > connect system/manager

SQL > start D:\ oracle\ product\ 10.1.0\ db_1\ sqlplus\ admin\ pupbld.sql

Re-RMAN connection, problem resolved.

Is it helpful for you to read the above content? If you want to know more about the relevant knowledge or read more related articles, please follow the industry information channel, thank you for your support.

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.