ERROR UPGRADING RMAN CATALOG SCHEMA TO 11.1.0.7 (Doc ID 741913.1)

Last updated on SEPTEMBER 12, 2010

Applies to:

Oracle Server - Enterprise Edition - Version: 11.1.0.6 and later   [Release: 11.1 and later ]
Information in this document applies to any platform.

Symptoms

#rman catalog rman11g@RMANPRD

Recovery Manager: Release 11.1.0.7.0 - Production on Tue Oct 7 12:56:43 2008

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

recovery catalog database Password:
connected to recovery catalog database
PL/SQL package RMAN11G.DBMS_RCVCAT version 11.01.00.06 in RCVCAT database is not current

DBGSQL: RCVCAT> begin :upgrade_completed := dbms_rcvcat.UPGRADE_COMPLETED;end;
[12:56:50.942]
DBGSQL: sqlcode = 6550 [12:56:50.942]
DBGSQL: B :upgrade_completed = 0
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00554: initialization of internal recovery manager package failed
RMAN-00600: internal error, arguments [9302] [6550] [begin :upgrade_completed :=
dbms_rcvcat.UPGRADE_COMPLETED;end; ] [] []
RMAN-06004: ORACLE error from recovery catalog database: ORA-06550: line 1, column 44:
PLS-00302: component 'UPGRADE_COMPLETED' must be declared
ORA-06550: line 1, column 10:
PL/SQL: Statement ignored

No RMAN operations are allowed as the RMAN prompt does not occur. So cannot use "Upgrade Catalog" command to finish the upgrade to 11.1.0.7.0.

Changes

Upgraded Target Database to 11.1.0.7.0.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms