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

"Steve Blomeley" <steveblomeley_at_yahooDOTco.uk> wrote in message news:3AA82B10.F84488E0_at_yahooDOTco.uk...
> "Howard J. Rogers" wrote:
> >
> > 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.
>
> [ The non-existent 'create catalog tablespace ...' command is certainly
> well-documented : Both the 8.1.5 Backup and Recovery Guide and the 8.1.7
> Recovery Manager Users Guide and Reference suggest the use of this
> command to create a recovery catalog in the specified tablespace. The
> documentation helpfully explains that 'If you do not specify a
> tablespace, RMAN stores the recovery catalog in the SYSTEM tablespace'.
> In fact if you *don't* specify a tablespace, the catalog is created in
> the users default tablespace (as you'd expect). In my experience (8.1.5
> / 8.1.6 on Linux), if you *do* supply a tablespace the create catalog
> command returns an error, and no catalog is created. ]
>
> I assume the original poster has already created a user with all the
> required roles/privileges and with the desired default tablespace, so
> all he need do now is:
>
> RMAN> create catalog ;
>
> ...hopefully with result...
> RMAN-06431: recovery catalog created
>
> BFN
> SB
Received on Fri Mar 09 2001 - 07:16:14 CST