Re: Error RMAN-06097, please help !

Oh lord...

NO HE DOESN'T. Well, not necessarily.

It all depends on his version. CATRMAN.SQL was a script that was included in 8.0 to allow the creation of the catalog tables. You ran it manually in whatever database was selected to be the database.

CATRMAN does not exist in 8.1.x. They got rid of it. You now create your catalog by connecting via RMAN to the catalog database, and issuing the 'create catalog' command. Hunt for as long as you like, but you will not find CATRMAN.SQL distributed with 8.1.5 or above.

And you'll excuse the earlier exasperation, I hope, but this one keeps cropping up again, and again, and again.

As for the original poster's problem, given that no mention is made of version, it's difficult to advise. But I can say that I am totally unaware of a 'create catalog tablespace' command, and trying to issue commands which don't exist is liable to provoke RMAN into issuing it's usual flurry of highly intuitive error messages.

What you are supposed to do is manually connect to the catalog database as per usual in SQLPLUS or whatever other tool takes your fancy (but not RMAN!), create the RMAN tablespace, create an RMAN User with a default tablespace of that RMAN tablespace just created, and grant a couple of privileges to the new User (recovery_catalog_owner I think may be one). *THEN* you switch to RMAN, and issue the 'create catalog' command (and again, I'm assuming 8i is in use at this point).

And all of that is extremely well-documented.

Regards
HJR "Juhan Kundla" <juhan_at_ensib.NICHT-SPAM.ee> wrote in message news:3AA7C098.AEEF1DE9_at_ensib.NICHT-SPAM.ee...
> You have to execute a sql script ($ORACLE_HOME/rdbms/admin/catrman.sql
> ???) on recovery catalog database as catalog schema owner to create
> necessary tables/packages.
>
> HTH,
> Juhan
>
> John Doe wrote:
> >
> > Hi there,
> >
> > I'm having serious problems creating the RMAN catalog can somebody
 please
> > help !
> >
> > This is the error messages I get :
> >
> > CREATION :
> >
> > RMAN> create catalog tablespace CATTBSP;
> >
> > RMAN-06099: error occurred in source file: krmk.pc, line: 6549
> > RMAN-06097: text of failing SQL statement: create or replace package
> > dbms_rcvman is
> > -- DE-HEAD <- tell SED
> > RMAN-06004: ORACLE error from recovery catalog database: ORA-12571:
> > TNS:packet writer failure
> >
> > RMAN-00571: ===========================================================
> > RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
> > RMAN-00571: ===========================================================
> > RMAN-06433: error installing recovery catalog
> >
> > RECONNECTION :
> >
> > C:\>rman
> >
> > Recovery Manager: Release 8.1.6.1.0 - Production
> >
> > RMAN> connect catalog rman/rman_at_live
> >
> > RMAN-06008: connected to recovery catalog database
> > RMAN-06099: error occurred in source file: krmk.pc, line: 19958
> > RMAN-06097: text of failing SQL statement: declare vsn varchar2 ( 20 ) ;
> > begin vsn := dbms_rcvcat . getPackageVersion ; :pkg_vsn:pkg_vsn_i := vsn
 ;
> > if vsn is not null then :pkg_vsnub4 := to_number ( substr ( vsn , 1 ,
 2 ) ||
> > substr ( vsn , 4 , 2 ) || substr ( vsn , 7 , 2 ) ) ; end if ; end ;
> > RMAN-06004: ORACLE error from recovery catalog database: ORA-04068:
 existing
> > state of packages has been discarded
> > ORA-04067: not executed, package body "RMAN.DBMS_RCVCAT" does not exist
> > ORA-06508: PL/SQL: could not find program unit being called
> > ORA-06512: at line 1
> >
> > I don't know how to create or replace this packet dbms_rcvman which I
 think
> > is the problem !!
> > - I've tried to run the scripts catalog.sql and catproc.sql again after
 the
> > databse was create with no luck at all - please help !
>
> --
> +-----------------+
> |NB! Please remove|
> | .NICHT-SPAM |
> | when replying |
> | to get my |
> | *REAL* |
> | e-mail address! |
> | |
> | Cheers, Juhan |
> +-----------------+
Received on Thu Mar 08 2001 - 13:37:17 CST