This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(80, 85%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESK%3C/text%3E%3C/svg%3E)
Our application is getting connected to oracle database through jdbc connection. But some times we are facing the below error ( Intermittent issues). Some times connection is going through and sometime its not.
We have checked listener and tnsname.ora file. all are looking good. Could you please help me what i'm missing here.
Error:
ERROR 2023-12-01 04:26:44,034 [WrapperStartStopAppMain] config.TenantConfigurationManager (none:none:none:none) Error retrieving a connection
java.sql.SQLRecoverableException: IO Error: The Network Adapter could not establish the connection
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:858)
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(220.8, 4%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESM%3C/text%3E%3C/svg%3E)
Welcome to Microsoft Q&A forum.
As I understand, you are getting error in retrieving a connection java.sql.SQLRecoverableException.
Could you please share more details about the scenario like from which Azure Service you ae trying to connect to Oracle, what connection string you are passing etc?
Thanks
Hi Shakti,
We are trying to connect from our application which is 3rd party build on Azure application VM to DB VM on oracle.
Below is the connection string:
<database id="XXXX" useURL="true" jndiDatabaseId="jdbc/XXXXXX" vendor="oracle" serviceName="XXXXXX" serviceId="XXXXXX" instanceName="" driver="oracle.jdbc.driver.OracleDriver" url="jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=XXXXXXXXX.az.3pc.att.com)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=XXXXXX)(SERVER=dedicated))(SECURITY=(ENCRYPTION_CLIENT=required)(ENCRYPTION_TYPES_CLIENT=(AES256,AES192,AES128)))(CLARITY_PARAMETERS=(oracle.net.crypto_checksum_client=required)))" host="XXXXXXX.az.3pc.att.com" username="XXXXX" password="XXXXXX" schemaName="XXXXXXX" upgradeStatus="upgradeNotNeeded"/>
Thanks, Shakti. I will raise Oracle SR and once I receive their suggestion. I will update here.
Hi SURESH KUMAR, SABESH,,
Thanks for sharing the details.
Since this involves VM and third-party app, I would recommend you to please file a support ticket for deeper investigation and in case if you don't have a support plan, do let us know here so that we can check on other options to unblock you. Thanks