oracle.net.ns.NetException: SO Exception was generated When Configuring 19c Datasource (Doc ID 2796254.1)

Last updated on MARCH 14, 2023

Applies to:

Symptoms

When configuring a 19c datasource in WebLogic 12.2.1.3.0 with the connection string:

jdbc:oracle:thin:@(DESCRIPTION_LIST=(LOAD_BALANCE=OFF)(FAILOVER=ON)(CONNECT_TIMEOUT=5)(TRANSPORT_CONNECT_TIMEOUT=3)(RETRY_COUNT=3)(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=<HOST1>)(PORT=<PORT>))(CONNECT_DATA=(SERVER=dedicated)(SERVICE_NAME=)))(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=<HOST 2>)(PORT=<PORT>))(CONNECT_DATA=(SERVER=dedicated)(SERVICE_NAME=<SERVICE NAME>))))

the following error is received:

Caused By: oracle.net.ns.NetException: SO Exception was generated
at oracle.net.resolver.AddrResolution.resolveAddrTree(AddrResolution.java:809)
at oracle.net.resolver.AddrResolution.resolveAndExecute(AddrResolution.java:538)
at oracle.net.ns.NSProtocol.establishConnection(NSProtocol.java:682)
at oracle.net.ns.NSProtocol.connect(NSProtocol.java:309)



ERROR
-----------------------
oracle.net.ns.NetException: SO Exception was generated


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Add connection string in datasource
2. Attempt the connection.

Changes

Cause

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