Re: Question: RMAN frustration

"BD" <bobby_dread_at_hotmail.com> wrote in message news:1121799720.944377.48980_at_g47g2000cwa.googlegroups.com...
> 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.
>

what does sqlplus "rman/rman_at_target as sysdba" do for you? Received on Tue Jul 19 2005 - 14:30:09 CDT