ORA-1031 for Remote Archive Destination on Primary [ID 733793.1]

尛樣兒發表於2012-06-13
ORA-1031 for Remote Archive Destination on Primary [ID 733793.1]

 修改時間 15-FEB-2012     型別 PROBLEM     狀態 PUBLISHED 

In this Document
  
  
  


Applies to:

Oracle Server - Enterprise Edition - Version: 10.1.0.2 to 11.2.0.3 - Release: 10.1 to 11.2
Information in this document applies to any platform.
***Checked for relevance on 22-Aug-2011***

Symptoms

ORA-1031 for remote archive destination on primary

alert.log
===== 
ORA-01031: insufficient privileges 
PING[ARC1]: Heartbeat failed to connect to standby 'mmsp_stby'. Error is 1031. 

Cause

Password file is missing in standby database

OR

Password file mismatch between primary and standby site. 

OR

Format of name of password file on standby is different than primary. 

Solution

1. Make sure parameter REMOTE_LOGIN_PASSWORDFILE is set to EXCLUSIVE or SHARED in both databases. 

2. Copy the password file again from primary : 

a. Defer the log_archive_dest_2 on primary: 

SQL> ALTER SYSTEM SET LOG_ARCHIVE_DEST_STATE_2 = DEFER; 

b. Copy/ftp the password file from primary to standby and rename it accordingly on the standby database. Creating the password file on standby with orapwd-utility is not supported for 11g anymore.
Make sure that name of password file on both primary and standby is : orapw. Name of the password file is case sensitive. If SID of database on standby is prod then name of the password file should be orapwprod, orapwPROD will not work. 

c. Enable the log_archive_dest_2 on primary: 

SQL> ALTER SYSTEM SET LOG_ARCHIVE_DEST_STATE_2 = ENABLE;

d. Switch 2-3 log files on primary : 

SQL> ALTER SYSTEM SWITCH LOGFILE;

e. Check the status of log_archive_dest_2 on primary. 

SQL> SELECT STATUS,ERROR FROM V$ARCHIVE_DEST WHERE DEST_ID =2; 

STATUS    ERROR 
--------- ----------------------------------------------------------------- 
VALID

Note: In this note log_archive_dest_2 is used for remote archive destination. 


來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/23135684/viewspace-732623/,如需轉載,請註明出處,否則將追究法律責任。

相關文章