Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I am attempting to create a downstream capture process for two Oracle 11 databases running on Linux servers. The replication will be one-way and asynchronous using archive logs as the transfer mechanism.

I set up a LOG_ARCHIVE_DEST_2 parameter in the NATSTAGE database as follows:

LOG_ARCHIVE_DEST_2='SERVICE=NATPROD.NVVV.COM ASYNC NOREGISTER VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) TEMPLATE=/usr/local/oracle/archivelogs/%t_%s_%r.dbf DB_UNIQUE_NAME=natprod'

I then enabled it.

LOG_ARCHIVE_DEST_STATE_2=ENABLE

On the NATPROD there is a directory /usr/local/oracle/archivelogs that is writable by oracle.

Here is the tnsnames.ora entry for the databases:

NATPROD =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST =  natprod.nvvv.com)(PORT=1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = natprod.nvvv.com)
    )
   )

I tested the new DEST with this command:

alter system switch logfile;

I then checked the directory on NATPROD and there was no archive file.

One thing I checked was a trace file. Here is its contents.

*** 2013-04-25 10:12:25.647
Redo shipping client performing standby login
OCIServerAttach failed -1
.. Detailed OCI error val is 12154 and errmsg is 'ORA-12154: TNS:could not resolve the connect identifier specified
'
OCIServerAttach failed -1
.. Detailed OCI error val is 12154 and errmsg is 'ORA-12154: TNS:could not resolve the connect identifier specified
'
OCIServerAttach failed -1
.. Detailed OCI error val is 12154 and errmsg is 'ORA-12154: TNS:could not resolve the connect identifier specified
'
*** 2013-04-25 10:12:25.690 4320 krsh.c
Error 12154 received logging on to the standby
*** 2013-04-25 10:12:25.690 915 krsu.c
Error 12154 connecting to destination LOG_ARCHIVE_DEST_2 standby host 'NATPROD.NNNV.COM'
Error 12154 attaching to destination LOG_ARCHIVE_DEST_2 standby host 'NATPROD.NNNV.COM'
*** 2013-04-25 10:12:25.690 4320 krsh.c
PING[ARC2]: Heartbeat failed to connect to standby 'NATPROD.NNNV.COM'. Error is 12154.
*** 2013-04-25 10:12:25.690 2932 krsi.c
krsi_dst_fail: dest:2 err:12154 force:0 blast:1
share|improve this question
add comment

migrated from stackoverflow.com Apr 26 '13 at 7:54

This question came from our site for professional and enthusiast programmers.

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.