I got the error below in my alert log file while trouble shooting my DG setup. Has anyone seen this before? I saw the error after troubleshooting.
OCIServerAttach failed -1
.. Detailed OCI error val is 12504 and errmsg is 'ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA
'
*** 2016-09-24 14:46:42.499 4132 krsh.c
Error 12504 received logging on to the standby
*** 2016-09-24 14:46:42.499 869 krsu.c
Error 12504 connecting to destination LOG_ARCHIVE_DEST_2 standby host 'ocmdg'
Error 12504 attaching to destination LOG_ARCHIVE_DEST_2 standby host 'ocmdg'
ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA
*** 2016-09-24 14:46:42.499 4132 krsh.c
PING[ARC2]: Heartbeat failed to connect to standby 'ocmdg'. Error is 12504.
*** 2016-09-24 14:46:42.499 2747 krsi.c
krsi_dst_fail: dest:2 err:12504 force:0 blast:1
Redo shipping client performing standby login
________
*** 2016-09-24 14:52:42.566
OCIServerAttach failed -1
.. Detailed OCI error val is 12504 and errmsg is 'ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA
'
OCIServerAttach failed -1
.. Detailed OCI error val is 12504 and errmsg is 'ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA
'
OCIServerAttach failed -1
.. Detailed OCI error val is 12504 and errmsg is 'ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA
'
*** 2016-09-24 14:52:42.570 4132 krsh.c
Error 12504 received logging on to the standby
*** 2016-09-24 14:52:42.570 869 krsu.c
Error 12504 connecting to destination LOG_ARCHIVE_DEST_2 standby host 'ocmdg'
Error 12504 attaching to destination LOG_ARCHIVE_DEST_2 standby host 'ocmdg'
ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA
*** 2016-09-24 14:52:42.571 4132 krsh.c
PING[ARC2]: Heartbeat failed to connect to standby 'ocmdg'. Error is 12504.
*** 2016-09-24 14:52:42.571 2747 krsi.c
krsi_dst_fail: dest:2 err:12504 force:0 blast:1