Skip to Content
0
Former Member
Jan 19, 2011 at 06:45 AM

Unable to ship Redo logs to standby DB (Oracle Data Gaurd)

5409 Views

Hi all,

We have configured Oracle Data Gaurd between our Production (NPP) & Standby (NPP_DR).

The configuration is complete however, the production is unable to ship redo logs to standby DB.

We keep getting the error "PING[ARC0]: Heartbeat failed to connect to standby 'NPP_DR'. Error is 12154." in Primary DB

Primary & DR are on different boxes.

Please see the logs below in the production alert log file & npp_arc0_18944.trc trace files:

npp_arc0_18944.trc :*

  • 2011-01-19 09:17:38.007 62692 kcrr.c

Error 12154 received logging on to the standby

Error 12154 connecting to destination LOG_ARCHIVE_DEST_2 standby host 'NPP_DR'

Error 12154 attaching to destination LOG_ARCHIVE_DEST_2 standby host 'NPP_DR'

  • 2011-01-19 09:17:38.007 62692 kcrr.c

PING[ARC0]: Heartbeat failed to connect to standby 'NPP_DR'. Error is 12154.

  • 2011-01-19 09:17:38.007 60970 kcrr.c

kcrrfail: dest:2 err:12154 force:0 blast:1

  • 2011-01-19 09:22:38.863

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

alert log file on Primary*

Error 12154 received logging on to the standby

Wed Jan 19 09:02:35 2011

Error 12154 received logging on to the standby

Wed Jan 19 09:07:36 2011

Error 12154 received logging on to the standby

Wed Jan 19 09:12:37 2011

Error 12154 received logging on to the standby

Wed Jan 19 09:13:10 2011

Incremental checkpoint up to RBA [0x2cc.2fe0.0], current log tail at RBA [0x2cc.2fe9.0]

Wed Jan 19 09:17:38 2011

Error 12154 received logging on to the standby

Wed Jan 19 09:22:38 2011

Error 12154 received logging on to the standby

Wed Jan 19 09:27:39 2011

Error 12154 received logging on to the standby

However, we are able to tnsping from primary to DR

Tnsping Results

From Primary:

juemdbp1:oranpp 19> tnsping NPP_DR

TNS Ping Utility for HPUX: Version 10.2.0.4.0 - Production on 19-JAN-2011 09:32:50

Copyright (c) 1997, 2007, Oracle. All rights reserved.

Used parameter files:

/oracle/NPP/102_64/network/admin/sqlnet.ora

Used TNSNAMES adapter to resolve the alias

Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (COMMUNITY = SAP.WORLD) (PROTOCOL = TCP) (HOST = 10.80.51.101) (PORT = 49160))) (CONNECT_DATA = (SID = NPP) (SERVER = DEDICATED)))

OK (60 msec)

Tnsnames.ora in Primary:

################

  1. Filename......: tnsnames.ora

  2. Created.......: created by SAP AG, R/3 Rel. >= 6.10

  3. Name..........:

  4. Date..........:

  5. @(#) $Id: //bc/700-1_REL/src/ins/SAPINST/impl/tpls/ora/ind/TNSNAMES.ORA#4 $

################

NPP.WORLD=

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS =

(COMMUNITY = SAP.WORLD)

(PROTOCOL = TCP)

(HOST = nppjorp)

(PORT = 49160)

)

)

(CONNECT_DATA =

(SID = NPP)

(GLOBAL_NAME = NPP.WORLD)

)

)

NPP_HQ.WORLD=

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS =

(COMMUNITY = SAP.WORLD)

(PROTOCOL = TCP)

(HOST = nppjorp)

(PORT = 49160)

)

)

(CONNECT_DATA =

(SID = NPP)

(SERVER = DEDICATED)

)

)

NPP_DR.WORLD=

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS =

(COMMUNITY = SAP.WORLD)

(PROTOCOL = TCP)

(HOST = 10.80.51.101)

(PORT = 49160)

)

)

(CONNECT_DATA =

(SID = NPP)

(SERVER = DEDICATED)

)

)

NPPLISTENER.WORLD=

(DESCRIPTION =

(ADDRESS =

(PROTOCOL = TCP)

(HOST = nppjorp)

(PORT = 49160)

)

)

Listener.ora in Primary

################

  1. Filename......: listener.ora

  2. Created.......: created by SAP AG, R/3 Rel. >= 6.10

  3. Name..........:

  4. Date..........:

  5. @(#) $Id: //bc/700-1_REL/src/ins/SAPINST/impl/tpls/ora/ind/LISTENER.ORA#4 $

################

ADMIN_RESTRICTIONS_LISTENER = on

LISTENER =

(ADDRESS_LIST =

(ADDRESS =

(PROTOCOL = IPC)

(KEY = NPP.WORLD)

)

(ADDRESS=

(PROTOCOL = IPC)

(KEY = NPP)

)

(ADDRESS =

(COMMUNITY = SAP.WORLD)

(PROTOCOL = TCP)

(HOST = nppjorp)

(PORT = 49160)

)

)

STARTUP_WAIT_TIME_LISTENER = 0

CONNECT_TIMEOUT_LISTENER = 10

TRACE_LEVEL_LISTENER = OFF

SID_LIST_LISTENER =

(SID_LIST =

(SID_DESC =

(SID_NAME = NPP)

(ORACLE_HOME = /oracle/NPP/102_64)

)

)

Thank You,

Salman Qayyum

Edited by: Salman M.A. Qayyum on Jan 19, 2011 8:12 AM