dknispel
asked on
Oracle RAC connectivity problems. Works on either IP but not on both
I'm having problems connecting from my Oracle Application server into my Oracle 10g RAC database.
It works when I use the TNSNAMES definition of either:
QA.WORLD = (DESCRIPTION = (ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = ###.###.125.147)(PORT = 1521)))
(CONNECT_DATA = (SERVICE_NAME=qa.world)(si d = QA.world)))
or
QA.WORLD = (DESCRIPTION = (ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = ###.###.125.148)(PORT = 1521)))
(CONNECT_DATA = (SERVICE_NAME=qa.world)(si d = QA.world)))
It only works half of the time when I use the following entry. I get an "ORA-12170:TNS:Connect Timeout Occurred" error.
QA.world =
(DESCRIPTION =
(LOAD_BALANCE=on)
(FAILOVER=on)
(ADDRESS = (PROTOCOL = TCP)(HOST = ###.###.125.147)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = ###.###.125.148)(PORT = 1521))
(LOAD_BALANCE = yes)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = qa.world)
(FAILOVER_MODE=
(TYPE=select)
(METHOD=basic))))
And a TNSPING works for all 3 different TNSNAMES entries without fail.
Any thoughts?
It works when I use the TNSNAMES definition of either:
QA.WORLD = (DESCRIPTION = (ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = ###.###.125.147)(PORT = 1521)))
(CONNECT_DATA = (SERVICE_NAME=qa.world)(si
or
QA.WORLD = (DESCRIPTION = (ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = ###.###.125.148)(PORT = 1521)))
(CONNECT_DATA = (SERVICE_NAME=qa.world)(si
It only works half of the time when I use the following entry. I get an "ORA-12170:TNS:Connect Timeout Occurred" error.
QA.world =
(DESCRIPTION =
(LOAD_BALANCE=on)
(FAILOVER=on)
(ADDRESS = (PROTOCOL = TCP)(HOST = ###.###.125.147)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = ###.###.125.148)(PORT = 1521))
(LOAD_BALANCE = yes)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = qa.world)
(FAILOVER_MODE=
(TYPE=select)
(METHOD=basic))))
And a TNSPING works for all 3 different TNSNAMES entries without fail.
Any thoughts?
ASKER
No luck. With the change recommended by rolutola. What would recommended next steps be? Start a trace on the client side? Below is the SQLNET.LOG from the attempted connection.
************************** ********** ********** ********** ********** *****
Fatal NI connect error 12170.
VERSION INFORMATION:
TNS for 32-bit Windows: Version 10.1.0.4.0 - Production
Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 10.1.0.4.0 - Production
Time: 29-JUN-2008 12:17:27
Tracing to file: d:\oracle\trace\cli_4216_1 .trc
Tns error struct:
ns main err code: 12535
TNS-12535: TNS:operation timed out
ns secondary err code: 12560
nt main err code: 505
TNS-00505: Operation timed out
nt secondary err code: 60
nt OS err code: 0
Client address: <unknown>
**************************
Fatal NI connect error 12170.
VERSION INFORMATION:
TNS for 32-bit Windows: Version 10.1.0.4.0 - Production
Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 10.1.0.4.0 - Production
Time: 29-JUN-2008 12:17:27
Tracing to file: d:\oracle\trace\cli_4216_1
Tns error struct:
ns main err code: 12535
TNS-12535: TNS:operation timed out
ns secondary err code: 12560
nt main err code: 505
TNS-00505: Operation timed out
nt secondary err code: 60
nt OS err code: 0
Client address: <unknown>
OK
Have you tried disabling firewall on the database server? This could be a port redirection problem. The server may be responding on a different port rather than on the listening port. The reason tnsping works is because that simply tests if the listener is up on the listening port.
Try either of these 2 threads:
http://forums.oracle.com/forums/thread.jspa?threadID=318356
http://forums.devshed.com/oracle-development-96/ora-12535-tns-operation-timed-out-236667.html
HTH
R.
Have you tried disabling firewall on the database server? This could be a port redirection problem. The server may be responding on a different port rather than on the listening port. The reason tnsping works is because that simply tests if the listener is up on the listening port.
Try either of these 2 threads:
http://forums.oracle.com/forums/thread.jspa?threadID=318356
http://forums.devshed.com/oracle-development-96/ora-12535-tns-operation-timed-out-236667.html
HTH
R.
On both servers you have to ensure registration of the services:
% lsnrctl services
TNSPING only shows that the listener is alive, but this is not enough.
If the services are not registered, then look 'static registration"
in EE using the search tool - we have posted it hundreds time ....
% lsnrctl services
TNSPING only shows that the listener is alive, but this is not enough.
If the services are not registered, then look 'static registration"
in EE using the search tool - we have posted it hundreds time ....
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Try the following:
Open in new window