Home » Server Options » Data Guard » primary database not able to connect to standby (10.2.0.4)
primary database not able to connect to standby [message #433009] Sat, 28 November 2009 13:16 Go to next message
ankush_chawla
Messages: 136
Registered: November 2006
Senior Member
hi

we are receving following error in the Alert log of the primary Database, not sure why primary database not able to connect to standby database

PING[ARCi]: Heartbeat failed to connect to standby 'orclstand1'. Error is 12154.
Sat Nov 28 22:15:06 2009
Error 12154 received logging on to the standby
Sat Nov 28 22:15:06 2009
Errors in file \oracle\product\10.2.0\admin\orcl\bdump\orcl_arci_424.trc:
ORA-12154: TNS:could not resolve the connect identifier specified

1. TNSPING for the standby database server gives the positive result
2. We are able to log on to the standby database from primary database server
3. Log files are shipped to the standby database server

Please help

Regards

Re: primary database not able to connect to standby [message #433010 is a reply to message #433009] Sat, 28 November 2009 13:23 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
Ora-12154 = "I can not find the entry in the TNSNAMES.ORA file that I am using (regardless of the one YOU THINK I am using)!"

>1. TNSPING for the standby database server gives the positive result
Above only means you can get to listener, but in this case you are not even getting to the listener.

listener records into listener.log every connection request along with the appropriate status code STATUS=0 means success.

[Updated on: Sat, 28 November 2009 13:26]

Report message to a moderator

Re: primary database not able to connect to standby [message #433011 is a reply to message #433010] Sat, 28 November 2009 13:43 Go to previous messageGo to next message
ankush_chawla
Messages: 136
Registered: November 2006
Senior Member
thanks for the response

Not understanding where the issue is exactly
Listener is up and running on both the servers.
Listener log
28-NOV-2009 22:29:24 * (CONNECT_DATA=(SID=orcl)(CID=(PROGRAM=\oracle\product\10.2.0\db_2\bin\emagent.exe)(HOST=EQ-W00300109765)(USER=OraUser))) * (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=2920)) * establish * orcl * 12518
TNS-12518: TNS:listener could not hand off client connection
TNS-12560: TNS:protocol adapter error
TNS-00530: Protocol adapter error
Re: primary database not able to connect to standby [message #433012 is a reply to message #433011] Sat, 28 November 2009 13:53 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>28-NOV-2009 22:29:24 * (CONNECT_DATA=(SID=orcl)(CID=(PROGRAM=\oracle\product\10.2.0\db_2\bin\emagent.exe)(HOST=EQ-W00300109765)(USER=OraUser))) * (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=2920)) * establish * orcl * 12518
>TNS-12518: TNS:listener could not hand off client connection
>TNS-12560: TNS:protocol adapter error
>TNS-00530: Protocol adapter error
>
Please note that latest error is different from one in original post.

12518, 00000, "TNS:listener could not hand off client connection"
// *Cause: The process of handing off a client connection to another process
// failed.
// *Action: Turn on listener tracing and re-execute the operation. Verify
// that the listener and database instance are properly configured for
// direct handoff.  If problem persists, call Oracle Support.
// *Comment: The problem can be worked around by configuring dispatcher(s)
// to specifically handle the desired presentation(s), and connecting
// directly to the dispatcher, bypassing the listener.

Networking configuration is WRONG!
127.0.0.1 is "localhost"; the s/w is talking to itself on originating host.
(HOST=<ip_standby>) is what is required
Re: primary database not able to connect to standby [message #433890 is a reply to message #433009] Fri, 04 December 2009 20:45 Go to previous messageGo to next message
ankush_chawla
Messages: 136
Registered: November 2006
Senior Member
Indeed the server is on the same machine.
I was just creating a test setup to move into the production later.
But i am not understanding being on the same machine , why the primary is not able to connect to standby.
Kindly help ?
Re: primary database not able to connect to standby [message #433891 is a reply to message #433890] Fri, 04 December 2009 21:04 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
What are SID for all the instances running on this system?

Is any type of Operating System virtualization running on this system?

Is there one ORACLE_HOME tree or two?
How many oracle listener processes are running?

post results from following commands

SET
lsnrctl status
lsnrctl service
Re: primary database not able to connect to standby [message #433892 is a reply to message #433891] Fri, 04 December 2009 21:31 Go to previous messageGo to next message
ankush_chawla
Messages: 136
Registered: November 2006
Senior Member
Primary Oracle SID - ORCL
Standby Oracle SID - ORCLSTAND1

C:\>echo %ORACLE_HOME%
E:\oracle\product\10.2.0\db_1

lsnrctl services

LSNRCTL for 32-bit Windows: Version 10.2.0.1.0 - Production on 05-DEC-2009 08:55:51

Copyright (c) 1991, 2005, Oracle. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC0)))
Services Summary...
Service "ORCL.REGRESS.RDBMS.DEV.US.ORACLE.COM" has 2 instance(s).
Instance "ORCL", status UNKNOWN, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0
LOCAL SERVER
Instance "ORCLSTAND1", status UNKNOWN, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0
LOCAL SERVER
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:0 refused:0
LOCAL SERVER
Service "orcl" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:26 refused:0 state:ready
LOCAL SERVER
Service "orclXDB" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
Handler(s):
"D000" established:0 refused:0 current:0 max:1002 state:ready
DISPATCHER <machine: EQ-W00300109765, pid: 2044>
(ADDRESS=(PROTOCOL=tcp)(HOST=EQ-W00300109765.ad.francetelecom.fr)(PORT=4451))
Service "orcl_DGB" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:26 refused:0 state:ready
LOCAL SERVER
Service "orcl_XPT" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
Handler(s):
"DEDICATED" established:26 refused:0 state:ready
LOCAL SERVER
The command completed successfully

lsnrctl status

LSNRCTL for 32-bit Windows: Version 10.2.0.1.0 - Production on 05-DEC-2009 08:56:17

Copyright (c) 1991, 2005, Oracle. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC0)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 32-bit Windows: Version 10.2.0.1.0 - Production
Start Date 05-DEC-2009 08:24:44
Uptime 0 days 0 hr. 31 min. 35 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File e:\oracle\product\10.2.0\db_1\network\admin\listener.ora
Listener Log File e:\oracle\product\10.2.0\db_1\network\log\listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC0ipc)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=EQ-W00300109765.ad.francetelecom.fr)(PORT=1521)))
Services Summary...
Service "ORCL.REGRESS.RDBMS.DEV.US.ORACLE.COM" has 2 instance(s).
Instance "ORCL", status UNKNOWN, has 1 handler(s) for this service...
Instance "ORCLSTAND1", status UNKNOWN, has 1 handler(s) for this service...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "orcl" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
Service "orclXDB" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
Service "orcl_DGB" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
Service "orcl_XPT" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
The command completed successfully
Re: primary database not able to connect to standby [message #433898 is a reply to message #433892] Fri, 04 December 2009 22:21 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
post content of listener.ora & tnsnames.ora

>PING[ARCi]: Heartbeat failed to connect to standby 'orclstand1'. Error is 12154.
Above is a problem involving Primary not able to connect to standby

Below is a problem involving Enterprise manager not connecting to primary
>28-NOV-2009 22:29:24 * (CONNECT_DATA=(SID=orcl)(CID=(PROGRAM=\oracle\product\10.2.0\db_2\bin\emagent.exe)(HOST=EQ-W00300109765)(USER=OraUser))) * (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=2920)) * establish * orcl * 12518

Which problem is highest priority to be solved?

I'm ask again, is any type of Operating System virtualization involved.
Re: primary database not able to connect to standby [message #433902 is a reply to message #433898] Fri, 04 December 2009 22:36 Go to previous messageGo to next message
ankush_chawla
Messages: 136
Registered: November 2006
Senior Member
Thanks for the response
NO OS Virtualization involved
Priority is for standby database
# LISTENER.ORA Network Configuration File: e:\oracle9i\network\admin\listener.ora
# Generated by Oracle configuration tools.

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = EQ-W00300109765)(PORT = 1521))
)
)
)

Listener.ora
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = E:\oracle\product\10.2.0\db_1)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = ORCL.REGRESS.RDBMS.DEV.US.ORACLE.COM)
(ORACLE_HOME = E:\oracle\product\10.2.0\db_1)
(SID_NAME = ORCL)
)
(SID_DESC =
(GLOBAL_DBNAME = ORCL.REGRESS.RDBMS.DEV.US.ORACLE.COM)
(ORACLE_HOME = E:\oracle\product\10.2.0\db_1)
(SID_NAME = ORCLSTAND1)
)
)

# TNSNAMES.ORA Network Configuration File: e:\oracle\product\10.2.0\db_1\\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.


ORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = EQ-W00300109765)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ORCL)
(SERVER = DEDICATED)
)
)

ORCLSTAND1 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = EQ-W00300109765)(PORT = 1521)))

(CONNECT_DATA =
(SERVICE_NAME = ORCLSTAND1)
(SERVER = SHARED)
)
)


CLRODS_QA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.237.93.22)(PORT = 1521))
)
(CONNECT_DATA =
(SID = CLRODS)
(SERVER = SHARED)
)
)

PROD=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.239.231.176)(PORT = 1521))
)
(CONNECT_DATA =
(SID = CLARIFY)
(SERVER = DEDICATED)
)
)




CLRODS_PROD =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.239.233.142)(PORT = 1521))
)
(CONNECT_DATA =
(SID = CLRODS)
(SERVER = DEDICATED)
)
)




Re: primary database not able to connect to standby [message #433903 is a reply to message #433902] Fri, 04 December 2009 22:43 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
I contend
ORACLE_SID=orclstand1
is not the same as
ORACLE_SID=ORCLSTAND1
Re: primary database not able to connect to standby [message #433904 is a reply to message #433903] Fri, 04 December 2009 22:51 Go to previous messageGo to next message
ankush_chawla
Messages: 136
Registered: November 2006
Senior Member
but i think windows OS is not case sensitive
orclstand1 and ORCLSTAND1 is same in windows os.
please let me know if i am wrong
Re: primary database not able to connect to standby [message #433905 is a reply to message #433904] Fri, 04 December 2009 22:58 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>please let me know if i am wrong
Test for yourself & see how Oracle responds
It does not matter if I am right or I am wrong.
It matters what works for you & what does not work for you.
Re: primary database not able to connect to standby [message #433906 is a reply to message #433905] Fri, 04 December 2009 23:08 Go to previous messageGo to next message
ankush_chawla
Messages: 136
Registered: November 2006
Senior Member
Thanks for the response
i m sure that windows is not case sensitive.
i have tried it many times before .

please let me know if there issue in the configuration that is causing it
Re: primary database not able to connect to standby [message #433908 is a reply to message #433906] Fri, 04 December 2009 23:17 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>i m sure that windows is not case sensitive.
I agree with the statement above.
I thought we were discussing Oracle's behaviour not Windoze.
I am not going to argue.

Enjoy your problem!
Re: primary database not able to connect to standby [message #434193 is a reply to message #433908] Mon, 07 December 2009 11:39 Go to previous message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member


Okay. Let me try to fix this issue.

Looks TNSPING working fine. Could you please post your init. ora from primary & standby database.

- Babu
Previous Topic: Configure multiple physical standby
Next Topic: ORA-01157 error on STANDBY after adding a datafile on primary
Goto Forum:
  


Current Time: Thu Mar 28 15:56:24 CDT 2024