Streams Downstream Archive Logs Are Not Copied To The Target Environment When Using EbusinessSuite - Error ORA-12154 (Doc ID 564505.1)

Last updated on FEBRUARY 08, 2017

Applies to:

Oracle Server - Enterprise Edition - Version 10.2.0.3 to 11.2.0.2 [Release 10.2 to 11.2]
Information in this document applies to any platform.
***Checked for relevance on 11-Jan-2013***


Symptoms

When trying to configure a downstream architecture from eBusinessSuite to another environment the archiver is not able to connect to the remote environment and logs are not copied.

The error reported by the archive process in the archive trace file -

*** 2008-04-14 08:52:19.544 61287 kcrr.c
Error 12154 received logging on to the standby
Error 12154 connecting to destination LOG_ARCHIVE_DEST_2 standby host 'REMOTE_HOST'
Error 12154 attaching to destination LOG_ARCHIVE_DEST_2 standby host 'REMOTE_HOST' 
ORA-12154: TNS:could not resolve the connect identifier specified
*** 2008-04-14 08:52:19.544 61287 kcrr.c
PING[ARC1]: Heartbeat failed to connect to standby 'REMOTE_HOST' . Error is 12154.

Cause

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