My Oracle Support Banner

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

Last updated on JANUARY 30, 2022

Applies to:

Oracle Database - Enterprise Edition - Version to [Release 10.2 to 11.2]
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Information in this document applies to any platform.


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.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.