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>

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 ignored

If 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-l

Received on Mon Dec 08 2008 - 08:37:54 CST