Oracle Redirected Restore is failing with error: ORA-01991: invalid password file

Article:TECH68466  |  Created: 2009-01-05  |  Updated: 2014-05-12  |  Article URL http://www.symantec.com/docs/TECH68466
Article Type
Technical Solution


Subject

Issue



While performing Oracle Control file redirected restore to another server it fails with error: ORA-01991: invalid password file


Error



The above error message can occur when performing an Oracle Control file redirected restore to another server. The actual control files will be restored but then the restore operation will fail when restoring the data files.
 
The Job Log will report below error (Figure 1)
 

 
Figure 1.
 

 
 
 
 
 

 
Example of the RMAN Section within the Job Log.
 
Starting restore at 29-APR-09
 
starting up daemon
 
starting up daemon
 
channel ch0: restoring controlfile
 
starting up daemon
 
channel ch0: restore complete
 
replicating controlfile
 
input filename=/u01/InstanceName/sbtproddata/cntrl01.dbf
 
output filename=/u01/InstanceName/sbtproddata/cntrl02.dbf
 
output filename=/u01/InstanceName/sbtproddata/cntrl03.dbf
 
Finished restore at 29-APR-09
 
released channel: ch0
 
RMAN-00571: ===========================================================
 
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
 
RMAN-00571: ===========================================================
 
RMAN-03002: failure of alter db command at 04/29/2009 11:10:25
 
ORA-01991: invalid password file '/u01/InstanceName/sbtproddb/9.2.0/dbs/orapwInstanceName'
 

Cause



This issue is due to the parameter "Remote_Login_Password_File" set to 'Exclusive ' in Init<SID>.ora file
 

Solution



Recreate password file using ORAPWD utility and set the parameter "Remote_Login_Password_File to value 'Shared' by editing Init<SID>.ora file
 

Supplemental Materials

SourceError Code
Value0xe0000340
Description

The Database script returned an error. Refer to the Database script output section in job logs for more details



Legacy ID



320631


Article URL http://www.symantec.com/docs/TECH68466


Terms of use for this information are found in Legal Notices