Link to home
Start Free TrialLog in
Avatar of dknispel
dknispelFlag for United States of America

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)(sid = QA.world)))
or
QA.WORLD = (DESCRIPTION = (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = ###.###.125.148)(PORT = 1521)))
    (CONNECT_DATA = (SERVICE_NAME=qa.world)(sid = 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?
Avatar of Rich Olu
Rich Olu
Flag of United Kingdom of Great Britain and Northern Ireland image

Try and keep things simple for a start.

Try the following:

QA.world =
  (DESCRIPTION =
    (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)
    )
  )

Open in new window

Avatar of dknispel

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>
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.
Avatar of schwertner
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 ....
ASKER CERTIFIED SOLUTION
Avatar of dknispel
dknispel
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial