RMAN-00554 RMAN-04005 ORA-01031 Errors

Today a coworker ask about the next error when He was configuring a Rman backup;

 
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00554: initialization of internal recovery manager package failed
RMAN-04005: error from target database:
ORA-01031: insufficient privileges

The core problem is the ORA-01031: insufficient privileges to perform the backup. Check the next items, it must solve the problem in the majority of cases;

 

i) Verify the password file exits. You can query the password file contain by the next query;

 
   SELECT * FROM V$PWFILE_USERS;
   

 

ii) check if remote_login_passworfile is set to EXCLUSIVE if not you can set by the next command;

 alter system set remote_login_passwordfile = EXCLUSIVE scope=both;

 

HTH – Antonio NAVARRO

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s