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 "Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message news:tafriqsm7b4k05_at_beta-news.demon.nl...
>
> "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 Fri Mar 09 2001 - 07:11:41 CST