Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Error: Telnet to SCAN listener port 1521 Okay but cannot create JDBC connection pool

Cuong PhamJun 10 2015 — edited Jun 16 2015

Dear everyone.

I have strange situation with RAC SCAN listener connectivity like this:

RAC 2 node: nodeA, nodeB in db-zone vlan

WebLogic application server 2 node: nodeC, nodeD in app-zone vlan

I run RCU on remote workstation machine to create database repository okay with same SCAN listener and port. After that, I run Weblogic configuration wizard to create domain. When checking JDBC connectivity It said that:

JDBC> <kbtw-dvc-app1> <App1> <[ACTIVE] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'> <<WLS Kernel>> <> <6c8759103a0da0e2:26f07922:14ddcddfd74:-8000-0000000000000014> <1433930018062> <BEA-001156> <Stack trace associated with message 001129 follows: 

java.sql.SQLRecoverableException: IO Error: The Network Adapter could not establish the connection
    at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:489)
    at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:678)
    at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:234)
    at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:34)
    at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:567)
    at weblogic.jdbc.common.internal.ConnectionEnvFactory.makeConnection(ConnectionEnvFactory.java:357)
    at weblogic.jdbc.common.internal.ConnectionEnvFactory.createResource(ConnectionEnvFactory.java:239)
    at weblogic.common.resourcepool.ResourcePoolImpl.makeResources(ResourcePoolImpl.java:1310)
    at weblogic.common.resourcepool.ResourcePoolImpl.makeResources(ResourcePoolImpl.java:1227)
    at weblogic.common.resourcepool.ResourcePoolImpl.recreateDeadResources(ResourcePoolImpl.java:2154)
    at weblogic.common.resourcepool.ResourcePoolImpl.access$1700(ResourcePoolImpl.java:41)
    at weblogic.common.resourcepool.ResourcePoolImpl$ResourcePoolMaintanenceTask.timerExpired(ResourcePoolImpl.java:2778)
    at weblogic.timers.internal.TimerImpl.run(TimerImpl.java:273)
    at weblogic.work.SelfTuningWorkManagerImpl$WorkAdapterImpl.run(SelfTuningWorkManagerImpl.java:545)
    at weblogic.work.ExecuteThread.execute(ExecuteThread.java:256)
    at weblogic.work.ExecuteThread.run(ExecuteThread.java:221)
Caused By: oracle.net.ns.NetException: The Network Adapter could not establish the connection
    at oracle.net.nt.ConnStrategy.execute(ConnStrategy.java:398)
    at oracle.net.resolver.AddrResolution.resolveAndExecute(AddrResolution.java:438)
    at oracle.net.ns.NSProtocol.establishConnection(NSProtocol.java:711)
    at oracle.net.ns.NSProtocol.connect(NSProtocol.java:355)
    at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1229)
    at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:326)
    at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:678)
    at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:234)
    at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:34)
    at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:567)
    at weblogic.jdbc.common.internal.ConnectionEnvFactory.makeConnection(ConnectionEnvFactory.java:357)
    at weblogic.jdbc.common.internal.ConnectionEnvFactory.createResource(ConnectionEnvFactory.java:239)
    at weblogic.common.resourcepool.ResourcePoolImpl.makeResources(ResourcePoolImpl.java:1310)
    at weblogic.common.resourcepool.ResourcePoolImpl.makeResources(ResourcePoolImpl.java:1227)
    at weblogic.common.resourcepool.ResourcePoolImpl.recreateDeadResources(ResourcePoolImpl.java:2154)
    at weblogic.common.resourcepool.ResourcePoolImpl.access$1700(ResourcePoolImpl.java:41)
    at weblogic.common.resourcepool.ResourcePoolImpl$ResourcePoolMaintanenceTask.timerExpired(ResourcePoolImpl.java:2778)
    at weblogic.timers.internal.TimerImpl.run(TimerImpl.java:273)
    at weblogic.work.SelfTuningWorkManagerImpl$WorkAdapterImpl.run(SelfTuningWorkManagerImpl.java:545)
    at weblogic.work.ExecuteThread.execute(ExecuteThread.java:256)
    at weblogic.work.ExecuteThread.run(ExecuteThread.java:221)
Caused By: java.net.SocketTimeoutException: connect timed out
    at java.net.PlainSocketImpl.socketConnect(Native Method)
    at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:351)
    at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:213)
    at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:200)
    at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:366)
    at java.net.Socket.connect(Socket.java:529)
    at oracle.net.nt.MetricsEnabledSocket.connect(TcpNTAdapter.java:631)
    at oracle.net.nt.TcpNTAdapter.connect(TcpNTAdapter.java:164)
    at oracle.net.nt.ConnOption.connect(ConnOption.java:137)
    at oracle.net.nt.ConnStrategy.execute(ConnStrategy.java:374)
    at oracle.net.resolver.AddrResolution.resolveAndExecute(AddrResolution.java:438)
    at oracle.net.ns.NSProtocol.establishConnection(NSProtocol.java:711)
    at oracle.net.ns.NSProtocol.connect(NSProtocol.java:355)
    at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1229)
    at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:326)
    at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:678)
    at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:234)
    at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:34)
    at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:567)
    at weblogic.jdbc.common.internal.ConnectionEnvFactory.makeConnection(ConnectionEnvFactory.java:357)
    at weblogic.jdbc.common.internal.ConnectionEnvFactory.createResource(ConnectionEnvFactory.java:239)
    at weblogic.common.resourcepool.ResourcePoolImpl.makeResources(ResourcePoolImpl.java:1310)
    at weblogic.common.resourcepool.ResourcePoolImpl.makeResources(ResourcePoolImpl.java:1227)
    at weblogic.common.resourcepool.ResourcePoolImpl.recreateDeadResources(ResourcePoolImpl.java:2154)
    at weblogic.common.resourcepool.ResourcePoolImpl.access$1700(ResourcePoolImpl.java:41)
    at weblogic.common.resourcepool.ResourcePoolImpl$ResourcePoolMaintanenceTask.timerExpired(ResourcePoolImpl.java:2778)
    at weblogic.timers.internal.TimerImpl.run(TimerImpl.java:273)
    at weblogic.work.SelfTuningWorkManagerImpl$WorkAdapterImpl.run(SelfTuningWorkManagerImpl.java:545)
    at weblogic.work.ExecuteThread.execute(ExecuteThread.java:256)
    at weblogic.work.ExecuteThread.run(ExecuteThread.java:221)

On two application servers, I can ping, telnet to SCAN address okay. I do not know why the JDBC thin client cannot create connection to RAC listener ? Can you give me any suggestion ?

P/S: all of my machines is running with Solaris Sparc64 10 update 11.

Thank in advance.

Cuong Pham

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 14 2015

Added on Jun 10 2015

#heterogeneous-connectivity

2 comments

1,282 views