My Oracle Support Banner

For SOA Configuration, the JDBC Connection Test Fails With "IO Error: The Network Adapter could not establish the connection CFGFWK-60850: Test Failed!" (Doc ID 1925172.1)

Last updated on JULY 29, 2017

Applies to:

Oracle Fusion Middleware - Version 11.1.1.7.0 and later
Generic UNIX

Symptoms

When running configuration for SOA, the JDBC Connection test for BAM, User Messaging Service, OWSM MDS Schema, and SOA MDS Schema fails with the following error:

IO Error: The Network Adapter could not establish the connection
CFGFWK-60850: Test Failed!

The screen shows the following for the Status for JDBC Connection test for Bam, User Messaging Service, OWSM MDS Schema, and SOA MDS Schema in the green box:

 

Changes

The "java utils.dbping" utility was used to test the connectivity from the machine where SOA is hosted to ensure that the machine is able to connect to the database properly.  Reference the dbping utility documentation at URL:  http://docs.oracle.com/cd/E13222_01/wls/docs81/admin_ref/utils11.html   The utils.dbping returns this error:

$ java -classpath $MW_HOME/wlserver_10.3/server/lib/weblogic.jar utils.dbping ORACLE_THIN DbHost:DbPort/ServiceName

Error encountered:
java.sql.SQLRecoverableException: IO Error: The Network Adapter could not establish the connection
  at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:458)
  at oracle.jdbc.driver.PhysicalConnection.(PhysicalConnection.java:546)
  at oracle.jdbc.driver.T4CConnection.(T4CConnection.java:236)
  at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)
  at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:521)
  at java.sql.DriverManager.getConnection(DriverManager.java:582)
  at java.sql.DriverManager.getConnection(DriverManager.java:154)
  at utils.dbping.main(dbping.java:204)
Caused by: oracle.net.ns.NetException: The Network Adapter could not establish the connection
  at oracle.net.nt.ConnStrategy.execute(ConnStrategy.java:392)
  at oracle.net.resolver.AddrResolution.resolveAndExecute(AddrResolution.java:434)
  at oracle.net.ns.NSProtocol.establishConnection(NSProtocol.java:687)
  at oracle.net.ns.NSProtocol.connect(NSProtocol.java:247)
  at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1102)
  at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:320)
  ... 7 more
Caused by: java.net.ConnectException: No such file or directory
  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.TcpNTAdapter.connect(TcpNTAdapter.java:150)
  at oracle.net.nt.ConnOption.connect(ConnOption.java:133)
  at oracle.net.nt.ConnStrategy.execute(ConnStrategy.java:370)

The expected results of the java -classpath $MW_HOME/wlserver_10.3/server/lib/weblogic.jar utils.dbping ORACLE_THIN DbHost:DbPort/ServiceName  is as follows:

**** Success!!! ****

You can connect to the database in your app using:

java.util.Properties props = new java.util.Properties();
props.put("user", "XXXXX");
props.put("password", "XXXX");
java.sql.Driver d =
Class.forName("oracle.jdbc.OracleDriver").newInstance();
java.sql.Connection conn =
Driver.connect("jdbc:oracle:thin:@localhost:1521/XXXXXXXX", props);

An strace of the utils.dbping command was done:

/usr/bin/strace -ff -tt -o /tmp/strace/strace.out java -classpath $MW_HOME/wlserver_10.3/server/lib/weblogic.jar utils.dbping ORACLE_THIN java utils.dbping ORACLE_THIN DbHost:DbPort/ServiceName

The /tmp/strace/strace.out.xxxx shows the following:

15:21:47.288894 connect(251, {sa_family=AF_INET6, sin6_port=htons(DBPort), inet_pton(AF_INET6, "::ffff:IPaddress", &sin6_addr), sin6_flowinfo=0, sin6_scope_id=0}, 28) = -1 EINPROGRESS (Operation now in progress)
15:21:47.289280 open("/proc/ssstm", O_RDONLY) = -1 ENOENT (No such file or directory)
15:21:47.289457 open("/proc/ssstm", O_RDONLY) = -1 ENOENT (No such file or directory)
...
15:21:47.290394 fcntl(251, F_GETFL) = 0x802 (flags O_RDWR|O_NONBLOCK)
15:21:47.290472 fcntl(251, F_SETFL, O_RDWR) = 0
15:21:47.292434 dup2(252, 251) = 251
15:21:47.292768 close(251) = 0
15:21:47.293756 pread(225, "PK\3\4\n\0\0\0\10\0\330@d?\21\313\37\332G\16\0\0001 \0\0\35\0\0\0or"..., 59, 2228078) = 59
...
15:21:47.298626 open("/proc/ssstm", O_RDONLY) = -1 ENOENT (No such file or directory)
15:21:47.298796 open("/proc/ssstm", O_RDONLY) = -1 ENOENT (No such file or directory)
...
15:21:47.320182 write(1, "\nError encountered:\n", 20) = 20

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.