Redo transport on Windows getting ORA-12523

(Doc ID 2370988.1)

Last updated on MAY 22, 2018

Applies to:

Oracle Database - Enterprise Edition - Version to [Release 11.2 to 12.2]
Microsoft Windows x64 (64-bit)


Alert log messages from the Physical standby database  on Windows
Error 12523 connecting to destination LOG_ARCHIVE_DEST_2 standby host 'PRD_DR'
sqlnet error stack also shows
TNS-12564: TNS:connection refused
for TNS error

Fatal NI connect error 12523, connecting to:

TNS for 64-bit Windows: Version - Production
Windows NT TCP/IP NT Protocol Adapter for 64-bit Windows: Version - Production
 Time: 06-MAR-2018 11:42:15
 Tracing not turned on.
 Tns error struct:
   ns main err code: 12564
TNS-12564: TNS:connection refused
   ns secondary err code: 0
   nt main err code: 0
   nt secondary err code: 0
   nt OS err code: 0

Tnsping to the standby PRD_DR successful
Connect to the primary from the standby  sqlplus sys/pwd@PRD as sysdba successful.
Connect to the standby from the standby server sqlplus sys/pwd@PRD_DR as sysdba successful.

Connect from the primary to the standby sqlplus sys/pwd@PRD_DR as sysdba

results in error
ORA-12523: TNS:listener could not find instance appropriate for the client


 Primary server was rebooted and this has not worked since. 


Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms