Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-01031: insufficient privileges when using RMAN

829677Apr 3 2011 — edited Apr 3 2011

OS: Linux 5

Db: Oracle 11.1.0.6

Hi I'm trying to take a full backup of the database using RMAN. For this, I have created Catalog database on another machine (i.e. my target db is on one box and this catalog db is on another machine), created catalog tablespace, rman user and granted him unlimited quota on this tablespace. I granted resource, connect and recovery_catalog_owner privileges to him.

I created the catalog tablespace by loggin on to RMAN utility. I now want to register the database. For this I'm giving below on the box having my catalog Db:
rman catalog=rman/rman@catalogDB target=sys/syspasswd@targetserverIPaddress/targetDdOracleSID

It's giving me the following errors:
RMAN-00554: initialization of internal recovery manager package failed
RMAN-04005: error from target database:
ORA-01031: insufficient privileges

I gave the rman user sysdba privileges, added remote_login_passwordfile=exclusive in the init parameter file of target database, but still getting the above errors. Can somebody please kindly help. Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on May 1 2011

Added on Apr 3 2011

#general-database-discussions

4 comments

7,327 views