Question: RMAN frustration

Hi, all.

I'm trying to get rman working for the first time, and am coming to the end of my rope.

Background: My catalog is on 9.2.0.4. I want to connect to an 8.1.7.4 target. The target is a separate database, on the same physical server.

I am consistently getting 'insufficient priveleges' when I connect to the target. I have done everything I have been able to find in the group, regarding checking the password file, the init.ora setting, and the grants to the rman ID.

My process:

-Catalog db:

Created tablespace
Created rman user
Granted create session, resource, sysdba to rman user Created catalog
Registered current db
Set remote_login_passwordfile to exclusive checked password file with select * from v$pwfile_users; looked okay

-Target db

Created rman user
Set remote_login_passwordfile to exclusive created new password file
Granted create session, resource, sysdba to rman user checked password file with select * from v$pwfile_users; looked okay

connected with 'rman catalog rman/rman_at_catdb' **Works - confirms connectivity to catalog

tried to connect with 'rman catalog rman/rman_at_catdb target rman/rman_at_target', and 'rman target rman/rman_at_target'

**Fails:
RMAN-04005: error from target database:
ORA-01031: insufficient privileges

Can someone suggest how I might narrow this down?

Many thanks!

DW. Received on Tue Jul 19 2005 - 14:02:01 CDT