Dataguard ORA-12514 error which is on X6 ODA

Posted by Adhrushta on Sep 20, 2017; 12:35pm
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/Dataguard-ORA-12514-error-which-is-on-X6-ODA-tp3528.html

Hi Erman,

We already set up standby database on x6 but in primary database alert log we are always seeing an error;

Fatal NI connect error 12514, connecting to:
 (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=darorax6.ibm.com)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=PRODSBY)(INSTANCE_NAME=ORAPROD)(CID=(PROGRAM=oracle)(HOST=daroravmsrv1)(USER=oracle))))

  VERSION INFORMATION:
        TNS for Linux: Version 11.2.0.4.0 - Production
        TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.4.0 - Production
  Time: 20-SEP-2017 15:33:24
  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
Error 12514 received logging on to the standby
PING[ARC1]: Heartbeat failed to connect to standby 'PRODSBY'. Error is 12514