Dataguard ORA-12514 error which is on X6 ODA

[Adhrushta]

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

[Adhrushta]

and i cant log in standby from primary database like that;

sqlplus sys/manager@PRODSBY as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Wed Sep 20 15:37:00 2017

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

ERROR:
ORA-12514: TNS:listener does not currently know of service requested in connect
descriptor

[Adhrushta]

Problem solved :)

[ErmanArslansOracleBlog]

This is clearly a TNS related problem.
Good for you:)

[ErmanArslansOracleBlog]

Even if you solve an issue yourself, please write down your solution here .. This is also a part of the information sharing, Abhyankari.