upgrade RMAN catalog problem
From: Joe Smith <joe_dba_at_hotmail.com>
Date: Mon, 8 Dec 2008 08:37:54 -0600
Message-ID: <BLU108-W50EDE2879F85E9A4DA56B997FD0@phx.gbl>
Send e-mail faster without improving your typing skills. http://windowslive.com/Explore/hotmail?ocid=TXT_TAGLM_WL_hotmail_acq_speed_122008
Date: Mon, 8 Dec 2008 08:37:54 -0600
Message-ID: <BLU108-W50EDE2879F85E9A4DA56B997FD0@phx.gbl>
I have run into a problem with the patchset going from 11.1.0.6.0 to 11.1.0.7.0 on Red Hat 32bit x86 Linux.
The two databases I upgraded worked fine.
I can't upgrade my recovery catalog without getting the below error:
connected to recovery catalog databasePL/SQL package RMAN.DBMS_RCVCAT version 11.01.00.06 in RCVCAT database is not current
DBGSQL: RCVCAT> begin :upgrade_completed := dbms_rcvcat.UPGRADE_COMPLETED;end; [11:02:40.057]DBGSQL: sqlcode = 6550 [11:02:40.057]DBGSQL: B :upgrade_completed = 0RMAN-00571: ===========================================================RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============RMAN-00571: ===========================================================RMAN-00554: initialization of internal recovery manager package failedRMAN-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 declaredORA-06550: line 1, column 10:PL/SQL: Statement ignoredIf I run the below sql
>select * from rcver;
VERSION------------11.01.00.06
Every time I try to connect and run UPGRADE CATALOG I get the error.
Has anybody seen this before?
Send e-mail faster without improving your typing skills. http://windowslive.com/Explore/hotmail?ocid=TXT_TAGLM_WL_hotmail_acq_speed_122008
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Dec 08 2008 - 08:37:54 CST