系統環境：windows2008 R2
Error 1031 received logging on to the standby
Errors in file c:\app\administrator\diag\rdbms\orcl\orcl\trace\orcl_arc1_2068.trc:
ORA-01031: insufficient privileges
PING[ARC1]: Heartbeat failed to connect to standby 'DG_BK'. Error is 1031.
也創建了密碼檔案，并復制到備機上了，可是同步一直出錯。
Redo shipping client performing standby login
OCISessionBegin failed. Error -1
.. Detailed OCI error val is 1017 and errmsg is 'ORA-01017: invalid username/password; logon denied
'
OCISessionBegin failed. Error -1
.. Detailed OCI error val is 1031 and errmsg is 'ORA-01031: insufficient privileges
'
*** 2019-12-16 16:30:15.820
OCISessionBegin failed -1
.. Detailed OCI error val is 1031 and errmsg is 'ORA-01031: insufficient privileges
'
*** 2019-12-16 16:30:15.820 4132 krsh.c
Error 1031 received logging on to the standby
*** 2019-12-16 16:30:15.820 869 krsu.c
Error 1031 connecting to destination LOG_ARCHIVE_DEST_2 standby host 'DG_BK'
Error 1031 attaching to destination LOG_ARCHIVE_DEST_2 standby host 'DG_BK'
ORA-01031: insufficient privileges
*** 2019-12-16 16:30:15.835 4132 krsh.c
PING[ARC1]: Heartbeat failed to connect to standby 'DG_BK'. Error is 1031.
*** 2019-12-16 16:30:15.835 2747 krsi.c
krsi_dst_fail: dest:2 err:1031 force:0 blast:1
uj5u.com熱心網友回復：
oracle 版本： oracle 11g 1201uj5u.com熱心網友回復：
密碼檔案要從主庫拷貝過去，不要自己創建。參考檔案：《step by step install oracle10gR2 for windows dataguard》
uj5u.com熱心網友回復：
多謝多謝，大牛人物。轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/18028.html
標籤：高級技術
下一篇：如何查看資料庫有無長鏈接陳述句