My Oracle Support Banner

'Error 1017 Received Logging On To The Standby' while Enabling log_archive_dest_state_<n>location to ZDLRA (Doc ID 2400768.1)

Last updated on NOVEMBER 03, 2019

Applies to:

Zero Data Loss Recovery Appliance X6 Hardware - Version All Versions to All Versions [Release All Releases]
Information in this document applies to any platform.

Symptoms

+ Trying to setup a protected database , enabling the log_archive_dest_state_<n> to ZDLRA fails with alert log showing:


******************************************************************
LGWR: Setting 'active' archival for destination LOG_ARCHIVE_DEST_2
******************************************************************
Tue Jan 09 09:21:39 2018
Error 1017 received logging on to the standby
------------------------------------------------------------
Check that the primary and standby are using a password file
and remote_login_passwordfile is set to SHARED or EXCLUSIVE,
and that the SYS password is same in the password files.
  returning error ORA-16191
------------------------------------------------------------
PING[ARC1]: Heartbeat failed to connect to standby 'xyzpbk-scan-zdlra.xyz.corp.com:1521/ZDLRA:dedicated'. Error is 16191.
Tue Jan 09 09:21:42 2018
Error 1017 received logging on to the standby
------------------------------------------------------------
Check that the primary and standby are using a password file
and remote_login_passwordfile is set to SHARED or EXCLUSIVE,
and that the SYS password is same in the password files.
  returning error ORA-16191
------------------------------------------------------------


+Connections were succeeding from protected database to ZDLRA database from

Sqlplus invoked from protected database home despite the error when enabling the location

sqlplus SYS/<pwd>\$@//xyzpbk-scan-zdlra.xyz.corp.com:1521/ZDLRA:1521/ZDLRA as sysdba

+ Customer was following documentation : https://docs.oracle.com/cd/E88198_01/AMPDB/config_pdb.htm#AMPDB815

Section: 'To enable real-time redo transport for a protected database:'

 

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.