ORA-1031 for Remote Archive Destination on Primary [ID 733793.1]
| ORA-1031 for Remote Archive Destination on Primary [ID 733793.1] | |||||
| 修改时间 15-FEB-2012 类型 PROBLEM 状态 PUBLISHED | |||||
In this Document
Symptoms
Cause
Solution
Applies to:
Oracle Server - Enterprise Edition - Version: 10.1.0.2 to 11.2.0.3 - Release: 10.1 to 11.2Information 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
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
STATUS ERROR
--------- -----------------------------------------------------------------
VALID
Note: In this note log_archive_dest_2 is used for remote archive destination.
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/23135684/viewspace-732623/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
