Error 12514

Error 12514 attaching to destination LOG_ARCHIVE_DEST_X standby host

Example


Alert log shows the following when trying ship archive logs to Physical Standby Site:

    Error 12514 received logging on to the standby
    Fri Jul 31 09:33:44 2009
    Errors in file i:\admin\semdb\bdump\databasedb2_lns3_154572.trc:
    ORA-12514: Message 12514 not found; No message file for product=RDBMS, facility=
    LGWR: Error 12514 creating archivelog file 'databasedr'
    LNS: Failed to archive log 22 thread 2 sequence 47481 (12514)
    Fri Jul 31 09:33:46 2009
    Error 12514 received logging on to the standby

Details

Trace file from primary database server is unable to connect to physical standby database:

FAL[server]: Selected inactive destination; resetting temporarily
Redo shipping client performing standby login
OCIServerAttach failed -1
.. Detailed OCI error val is 12514 and errmsg is 'ORA-12514: Message 12514 not found; No message file for product=RDBMS, facility=ORA
*** 2009-07-31 09:33:49.490 61080 kcrr.c
Error 12514 received logging on to the standby
Error 12514 connecting to destination LOG_ARCHIVE_DEST_4 standby host 'databasedr'
Error 12514 attaching to destination LOG_ARCHIVE_DEST_4 standby host 'databasedr'
ORA-12514: Message 12514 not found; No message file for product=RDBMS, facility=ORA
*** 2009-07-31 09:33:49.505 59323 kcrr.c
kcrrfail: dest:4 err:12514 force:0 blast:1
kcrrwkx: unknown error:12514

Solution

On standby server check what services are registered by the listener

    > lsnrctl status

Check the SERVICE_NAME in the CONNECT data for the tnsnames.ora file on standby database server.