Re: Error RMAN-06097, please help !

"John Doe" <jhon_at_doe.com> wrote in message news:987u38$n7g$1_at_news.btv.ibm.com...
> 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 !
>
>
>

You seem not to have the required pl/sql packages installed Rerun %ORACLE_HOME%\rdbms\admin\dbmsrman under sys and see what happens. Their might be an associated plb, which I couldn't find.

Hth,

Sybrand Bakker, Oracle DBA Received on Thu Mar 08 2001 - 06:45:29 CST