advertisements
_____________________________________________________________________________________________________________________
Error Description:
RMAN target database connectivity is failing with ORA-01031
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
Please send your comments.
_____________________________________________________________________________________________________________________
0 comments:
Post a Comment