Re: Error RMAN-06097, please help !

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  |
+-----------------+