Re: Error RMAN-06097, please help !

Thanks a lot for all the answers to bad none of them could help me out. (I still get the same error)

I'm runing Oracle 8.1.6.1.0, and have already created the tablespace where my rman catalog is supposed to be.
I've also granted connect, resource and recovery_catalog_owner to the user rman and given him the above mentioned tablespace as default.

What does ORA-12571: TNS : packet writer failure means ??

Any hints ?
Please ask more questions if you need more info

"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 Fri Mar 09 2001 - 07:16:04 CST