Re: Error RMAN-06097, please help !

From: John Doe <jhon_at_doe.com>
Date: Fri, 9 Mar 2001 14:16:10 +0100
Message-ID: <98al83$nk2$1@news.btv.ibm.com>

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

"Howard J. Rogers" <howardjr_at_www.com> wrote in message news:3aa7df3f_at_news.iprimus.com.au...
> 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 Fri Mar 09 2001 - 07:16:10 CST