RMAN: CREATE CATALOG fails

Printable View

01-15-2002, 02:05 PM
marist89

I am trying to create an 8.1.7 RMAN catalog on a 9.0.1.2 database. I have done this without a problem on several 9.0.1.0 database, but this is my first time on the patched version.

I have a catalog owner, rman817. rman817 has been granted connect, resource, dba, and recovery_catalog_owner. When I try to create the catalog, I get an error message:

Code:

oracle8@oradev3 dev817$ rman catalog rman817/[email protected] Recovery Manager: Release 8.1.7.0.0 - Production RMAN-06008: connected to recovery catalog database RMAN-06428: recovery catalog is not installed RMAN> create catalog tablespace "RMAN817_DATA"; RMAN-06444: dbms_rcvman package body created with compilation errors RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-06433: error installing recovery catalog

When I go in to check the package in question, I get:

Code:

SQL> alter package dbms_rcvman compile body; Warning: Package Body altered with compilation errors. SQL> show errors package body dbms_rcvman; Errors for PACKAGE BODY DBMS_RCVMAN: LINE/COL ERROR -------- ----------------------------------------------------------------- 6624/4 PLS-00593: default value of parameter "AVAILABLE" in body must match that of spec 6625/4 PLS-00593: default value of parameter "UNAVAILABLE" in body must match that of spec 6626/4 PLS-00593: default value of parameter "EXPIRED" in body must match that of spec 6753/4 PLS-00593: default value of parameter "PIECECOUNT" in body must match that of spec

Anybody got any hints?
01-15-2002, 02:31 PM
marist89

Just heard from Oracle Support: Bug 1645903. The workaround is to:
alter system set events '10932 trace name context level 32768';
01-15-2002, 03:44 PM
sambavan

Jeff,

Just curious what is the DB 8.1.7 version and platform. I just heard from oracle that 8.1.7.3 patchset is out. But curious to know whether this was with this patchset? Did you try upgrade the catalog?

NOTE: AFAIK, you have to set the RMAN in backward compatibility mode and not forward. In your case the catalog seems to reside on the 8.1.7 where as the db is 9i. Did you try vice-versa. I'm sure that the vice-versa would work.

I'm interested in keeping track of the proceedings of this issue.

Thanx,
Sam

[Edited by sambavan on 01-15-2002 at 02:47 PM]
01-15-2002, 08:26 PM
marist89

Both the recovery catalog and the source database were on solaris. I tried the 8.1.7 database with 8.1.7.0 and 8.1.7.2.

The catalog was an 8.1.7 catalog on a 9.0.1.2 database. Since everything was owned by rman817, I shouldn't have a problem.

I have been looking for that 8.1.7.3 patchset, but haven't found it on the ftp site or metalink. I hope it comes out soon.
01-16-2002, 02:52 AM
julian

Quote:

I have been looking for that 8.1.7.3 patchset, but haven't found it on the ftp site or metalink. I hope it comes out soon.

Jeff, it will be available on January 18th.