Fix RMAN-04005 ORA-01031: insufficient privileges RMAN-00554 in Oracle 10g 11g RAC

Error Description: 
RMAN target database connectivity is failing with ORA-01031

$ rman catalog rman/rman@rmancat target rmanbkup/rmanbkup@prod3

Recovery Manager: Release 11.2.0.2.0 - Production on Tue Nov 29 02:40:33 2011


Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

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

Solution Description:

Step 1:
          Create password file in target database using orapwd utility
          Orapwd file=orapw<sid_name> password=<password> entries=5

Step 2:
          Set remote_login_passwordfile parameter value to EXCLUSIVE in init.ora file
          Remote_login_passwordfile=EXCLUSIVE
Step 3:
          Login to each RAC instance and grant sysdba to the user which is taking the RMAN backups.
SQL>  select * from v$pwfile_users;

USERNAME                       SYSDB SYSOP SYSAS
------------------------------ ----- ----- -----
SYS                            TRUE  TRUE  FALSE

SQL> grant sysdba to rmanbkup ;

Grant succeeded.

SQL>  select * from v$pwfile_users;

USERNAME                       SYSDB SYSOP SYSAS
------------------------------ ----- ----- -----
SYS                            TRUE  TRUE  FALSE
RMANBKUP                       TRUE  FALSE FALSE
If you are running on non-RAC database execute the step#3 in the database level.

Now try to connect to RMAN target.It should work.
$ rman catalog rman/rman@rmancat target rmanbkup/rmanbkup@prod3

Recovery Manager: Release 11.2.0.2.0 - Production on Tue Nov 29 05:06:56 2011

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

connected to target database: PROD3 (DBID=2729672316)
connected to recovery catalog database

DBA Tips Data Pump Reference

0 comments:

Post a Comment

 

dba topics. Copyright 2011-16 All Rights Reserved | Site Map | Contact | Disclaimer | Google