My Oracle Support Banner

Redo transport on Windows getting ORA-12523 (Doc ID 2370988.1)

Last updated on AUGUST 04, 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. 


To view full details, 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 a vibrant support community of peers and Oracle experts.