Archive Log Shipping From Primary to Standby Fails With ORA-12514 (Doc ID 563801.1)

Last updated on OCTOBER 31, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 9.0.1.4 to 11.2.0.4 [Release 9.0.1 to 11.2]
Oracle Net Services - Version 9.2.0.5.0 to 11.2.0.4 [Release 9.2 to 11.2]
Information in this document applies to any platform.
***Checked for relevance on 6-JULY-2016***

Symptoms

You are unable to ship the archive log from the primary database to the standby.  The following error is being consistently thrown:  ORA-12514 TNS:listener could not resolve SERVICE_NAME given in connect descriptor

In this example, there are 3 nodes in RAC setup on 9.2.0.8 database as Primary and 2 nodes in RAC setup as Standby.  While shipping logs from primary to standby the following error messages are thrown in the alert.log:

*** SESSION ID:(17.1) 2008-04-08 12:56:07.170
Error 12514 connecting to destination LOG_ARCHIVE_DEST_2 standby host '<tns_connect_string>'
Error 12514 attaching to destination LOG_ARCHIVE_DEST_2 standby host '<tns_connect_string>'

*** 2008-04-08 12:56:26.385
ARC0: Error 12514 Creating archive log file to '<tns_connect_string>' 
*** 2008-04-08 12:56:26.385
kcrrfail: dest:2 err:12514 force:0
ORA-12514: TNS:listener could not resolve SERVICE_NAME given in connect descriptor
*** 2008-04-08 13:02:07.235
Error 12514 connecting to destination LOG_ARCHIVE_DEST_2 standby host '<tns_connect_string>' 
Error 12514 attaching to destination LOG_ARCHIVE_DEST_2 standby host '<tns_connect_string>'
Heartbeat failed to connect to standby '<tns_connect_string>'. Error is 12514.

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