ORA-12170: TNS:Connect timeout occurred ON Oracle RAC 11g
Hi,
I have an Oracle Database 11g Release 11.1.0.6.0 in a Real Application Cluster enviroment.
When I try to connect from local machine to local instance I have not problem:
sqlplus *******/*****
SQL*Plus: Release 11.1.0.6.0 - Production on Fri Feb 13 09:38:58 2009
Copyright (c) 1982, 2007, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Release 11.1.0.6.0 - 64bit Production
With the Real Application Clusters option
SQL>
When I execute a tnsping to the other node, I have no problem:
tnsping EVODB2
TNS Ping Utility for Linux: Version 11.1.0.6.0 - Production on 13-FEB-2009 09:39:43
Copyright (c) 1997, 2007, Oracle. All rights reserved.
Used parameter files:
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = ********-vip.domain.net)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = EVODB) (INSTANCE_NAME = EVODB2)))
OK (0 msec)
Problem starts when I try to connect to second node or just using the SID in the sqlplus command:
sqlplus ******/*****@EVODB
SQL*Plus: Release 11.1.0.6.0 - Production on Fri Feb 13 09:13:37 2009
Copyright (c) 1982, 2007, Oracle. All rights reserved.
ERROR:
ORA-12170: TNS:Connect timeout occurred
I have the same situation while connecting from a remote client: tnsping responds immediatly, but sqlplus return e connection timeout.
This is the lsnrctl status command:
Listening Endpoints Summary...
+(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=********.domain.net)(PORT=1521)))+
Services Summary...
Service "EVODB" has 2 instance(s).
Instance "EVODB1", status READY, has 1 handler(s) for this service...
Instance "EVODB2", status READY, has 1 handler(s) for this service...
Service "EVODBXDB" has 2 instance(s).
Instance "EVODB1", status READY, has 1 handler(s) for this service...
Instance "EVODB2", status READY, has 1 handler(s) for this service...
Service "EVODB_XPT" has 2 instance(s).
Instance "EVODB1", status READY, has 1 handler(s) for this service...
Instance "EVODB2", status READY, has 1 handler(s) for this service...
The command completed successfully
And this is the lsrnctl service command:
lsnrctl service
LSNRCTL for Linux: Version 11.1.0.6.0 - Production on 13-FEB-2009 09:44:28
Copyright (c) 1991, 2007, Oracle. All rights reserved.
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
Services Summary...
Service "EVODB" has 2 instance(s).
Instance "EVODB1", status READY, has 1 handler(s) for this service...
Handler(s):
+"DEDICATED" established:2 refused:0 state:ready+
REMOTE SERVER
+(DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=))(ADDRESS=(PROTOCOL=TCP)(HOST=67.215.65.132)(PORT=1521)))+
Instance "EVODB2", status READY, has 1 handler(s) for this service...
Handler(s):
+"DEDICATED" established:2 refused:0 state:ready+
REMOTE SERVER
+(DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=))(ADDRESS=(PROTOCOL=TCP)(HOST=67.215.65.132)(PORT=1521)))+
Service "EVODBXDB" has 2 instance(s).
Instance "EVODB1", status READY, has 1 handler(s) for this service...
Handler(s):
+"D000" established:0 refused:0 current:0 max:1022 state:ready+
DISPATCHER <machine: dcsrv-evodb01, pid: 3799>
+(ADDRESS=(PROTOCOL=tcp)(HOST=********.domain.net)(PORT=12187))+
Instance "EVODB2", status READY, has 1 handler(s) for this service...
Handler(s):
+"D000" established:0 refused:0 current:0 max:1022 state:ready+
DISPATCHER <machine: dcsrv-evodb02, pid: 26543>
+(ADDRESS=(PROTOCOL=tcp)(HOST=********.domain.net)(PORT=10162))+
Service "EVODB_XPT" has 2 instance(s).
Instance "EVODB1", status READY, has 1 handler(s) for this service...
Handler(s):
+"DEDICATED" established:2 refused:0 state:ready+
REMOTE SERVER
+(DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=))(ADDRESS=(PROTOCOL=TCP)(HOST=67.215.65.132)(PORT=1521)))+
Instance "EVODB2", status READY, has 1 handler(s) for this service...
Handler(s):
+"DEDICATED" established:2 refused:0 state:ready+
REMOTE SERVER
+(DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=))(ADDRESS=(PROTOCOL=TCP)(HOST=67.215.65.132)(PORT=1521)))+
The command completed successfully
To tell the thruth, I noticed something strange in that last command:
the IP 67.215.65.132 is not one of my net... where lnsrctl service read that information?
Any suggestion?
Thanks in advance!
Samuel