Home > database >  Under Windows data guard transmission failure ORA - 01017: invalid username/password. ORA - 01031.
Under Windows data guard transmission failure ORA - 01017: invalid username/password. ORA - 01031.

Time:10-12

System environment: windows2008 R2

Error 1031 received logging on to the standby
The Errors in the file c: \ apps \ wouldn \ \ administrator \ diag \ an RDBMS wouldn \ trace \ orcl_arc1_2068 TRC:
ORA - 01031: insufficient privileges
PING [ARC1] : Heartbeat failed to connect to the standby 'DG_BK'. The Error is 1031.

Also create the password file, and copy to prepare the on board, but the synchronization error,

Redo shipping client performing standby login
OCISessionBegin failed. The Error - 1
. The Detailed OCI error val is 1017 and errmsg is' ORA - 01017: invalid username/password. Logon denied
'
OCISessionBegin failed. The Error - 1
. The Detailed OCI error val is 1031 and errmsg is' ORA - 01031: insufficient privileges
'

* * * 2019-12-16 16:30:15. 820
OCISessionBegin failed - 1
. The 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 the standby 'DG_BK'. The Error is 1031.
* * * 2019-12-16 16:30:15. 835 2747 krsi. C
Krsi_dst_fail: dest: err: 1031 force: 0 blast: 1

CodePudding user response:

Oracle version: oracle 11 g 1201

CodePudding user response:

Password file to copy from the main library in the past, not to create your own,
Reference: "step by step the install oracle10gR2 for Windows dataguard"

CodePudding user response:

Thanks, Daniel,
  • Related