Can't register a database in RMAN catalog (PL/SQL package not current)
657941Jul 23 2009 — edited Jul 31 2009Hi RMAN experts. I'm trying to register a *10.2.0.1.0* database into a *10.2.0.4.0* RMAN catalog but I get the following error (Note: following was done on the rman server machine, ORACLE_SID=rman, target database is remote)
$ rman catalog rman/rman target rman/rman@SW
Recovery Manager: Release 10.2.0.4.0 - Production on Fri Jul 17 15:14:57 2009
Copyright (c) 1982, 2007, Oracle. All rights reserved.
PL/SQL package SYS.DBMS_BACKUP_RESTORE version 10.02.00.00 in TARGET database is not current
PL/SQL package SYS.DBMS_RCVMAN version 10.02.00.00 in TARGET database is not current
connected to target database: SW (DBID=1716922184)
connected to recovery catalog database
RMAN> register database;
database registered in recovery catalog
starting full resync of recovery catalog
RMAN-00571: ===============
RMAN-00569: =========ERROR MESSAGE STACK FOLLOWS
RMAN-00571: =================
RMAN-03008: error while performing automatic resync of recovery catalog
ORA-00904: : invalid identifier
Basically the error says that there are two packages in the TARGET database (SYS.DBMS_BACKUP_RESTORE and SYS.DBMS_RCVMAN) which are not compatible with the RMAN catalog. I have searched over the web and found the suggestion that instead of running the RMAN client from the RMAN machine, I should run it from the server where the TARGET database is running. I have not tested this suggestion but I think it wouldn't be acceptable for security reasons.
I cannot register the target database into the RMAN catalog.
I highly appretiate if you give me an advice on this.
Regards