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
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部落格 ” ,連結:http://blog.itpub.net/23135684/viewspace-732623/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- ORA-16009: remote archive log destination must be a STANDBY databaseREMHiveDatabase
- ASM Archive destination is full. [ID 351547.1]ASMHive
- OGG - No Valid Default Archive Destination Directory Found for Thread #Hivethread
- Oracle 10G Archive Destination 理解Oracle 10gHive
- Packet rejected remote IP proto TCP: Destination VIP disabledREMTCP
- Oracle ocp 1Z0 053 Q563(archive-log destination)OracleHive
- Android之Notification和RemoteviewAndroidREMView
- 如何在SAP Server Side JavaScript裡消費destinationServerIDEJavaScript
- Android RemoteViews 11問11答AndroidREMView
- WARNING: REMOTE HOST IDENTIFICATION HAS CHANGED!REMIDE
- Creating a physical standby from ASM primary [ID 787793.1]ASM
- Checking for Oracle archive log corruption [ID 1268590.1]OracleHive
- Remote Diagnostic Agent (RDA) - RAC Cluster Guide (Doc ID 359395.1)REMGUIIDE
- 使用bootstrapvalidator的remote驗證經驗bootREM
- ORA-16047: DGID mismatch between destination setting and target databaseDatabase
- sql primary key procedureSQL
- SSIS display null in destination fileNull
- 解決“The remote certificate is invalid according to the validation procedure”問題REM
- dataguard 搭建 oracle_sid不同 2節點 primary+standbyOracle
- dataguard 搭建 oracle_sid相同 2節點 primary+standbyOracle
- REMOTE HOST IDENTIFICATION HAS CHANGED 問題解決REMIDE
- Android Service 服務(三)—— bindService與remoteServiceAndroidREM
- Renaming a Datafile in the Primary DatabaseDatabase
- standby database to primary database.Database
- Swift iOS : ArchiveSwiftiOSHive
- 更改Archive ModeHive
- SSH登入:WARNING: REMOTE HOST IDENTIFICATION HAS CHANGED!REMIDE
- Linux - SSH: WARNING REMOTE HOST IDENTIFICATION HAS CHANGEDLinuxREMIDE
- WARNING: REMOTE HOST IDENTIFICATION HAS CHANGED解決方法REMIDE
- 建立快速重新整理物化檢視使用with rowid還是with primary key?
- Managing multiple archive log destinations with RMAN (Doc ID 443814.1)Hive
- standby_archive_dest和log_archive_dest_n區別Hive
- log_archive_dest與log_archive_dest_n區別Hive
- 11g feature: Flashback Data Archive Guide. (Doc ID 470199.1)HiveGUIIDE
- ITEM中的UNIT OF PRIMARY.
- ABAP和Java的destination和JNDIJava
- SSH登入警告(WARNING: REMOTE HOST IDENTIFICATION HAS CHANGED!)REMIDE
- ssh登陸 “remote host identification has changed!“ 解決方案REMIDE