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(41.6, 90%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVR%3C/text%3E%3C/svg%3E)
Hi ,
We are trying to create oracle 19c Database connection as a source in Azure Data Factory and getting below popup error message.
ERROR [08S01] [Microsoft][ODBC Oracle Wire Protocol driver]Socket closed.
ERROR [08001] [Microsoft][ODBC Oracle Wire Protocol driver][Oracle]ORA-12203: unable to connect to destination
Activity ID: 3cefa339-9457-48e2-89db-fac0eb3fd8fa.
Note: We were able to connect and work Oracle 12c db. But issue with 19c db only.
Thank You,
Venkat
Hi Venkata Ravikumar Chebrolu ,
Welcome to Microsoft Q&A platform and thanks for posting your question here.
As I understand your query you are facing an issue while trying to create an Oracle 19c database connection as a source in Azure Data Factory.
Socket closed error is usually observed in the Open Database Connectivity (ODBC) driver because the underlying Transmission Control Protocol (TCP) connection has been terminated by either party (client or server).
There can be a number of reasons for that, for example:
Check to see if database is SSL enabled or not, if database is SSL enabled make sure required SSL connection options are set.
Check the ODBC Trace and see where the issue lies.
Also, since you mentioned, connection got successfully established with ODBC 12c using ADF but not with ODBC 19c database, it means Oracle connector in ADF is not having issue, but the issue is with the source . Kindly check with the source team and look for guidance. Thankyou
![](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(99.2, 46%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EM%3C/text%3E%3C/svg%3E)
I have the same issue and was wondering if you found a solution to this problem?
Thank you for your reply!!
I have whitelisted Oracle server IP in IR network and upgraded IR to latest version. But still facing the same issue.
Thank You,
Venkat
Hi!
Try to enable EncryptionMethod=1 using a connection string in JSON Advanced configuration:
{
"properties": {
"type": "Oracle",
"typeProperties": {
"connectionString": "Host=<host>;Port=<port_number>;ServiceName=<service_name>;EncryptionMethod=1;User Id=<user>;Password=<password>;"
}
}
}
https://learn.microsoft.com/en-us/azure/data-factory/data-movement-security-considerations
Note
To enable encryption in transit while moving data from Oracle follow one of the below options:
When attempting to connect Azure Data Factory (ADF) to Oracle 19c and encountering an ORA-12203 error, you should check several key areas:
Start by confirming the compatibility of the ADF Oracle connector with Oracle 19c. Ensure Oracle 19c is network-accessible from ADF, which might require IP whitelisting in Oracle's firewall.
Then examine the Oracle listener configuration and the TNSNAMES.ORA file for accuracy. Verify that you're using an ODBC driver compatible with Oracle 19c and review the connection string details.
Finally, inspect configurations in both Oracle 19c (especially if there are deprecated features from 12c) and ADF's linked service, and consider consulting Azure Support if the issue persists.
Thank you for your reply!!
I have whitelisted Oracle server IP in IR network and upgraded IR to latest version. But still facing the same issue.
Thank You,
Venkat
Can you provide more details ?
Hi Amira,
We are trying to create a linked service using oracle connector.
When we created a connection with Oracle 12c Database, we were able to connect and now using that.
But while trying to create a new connection with Oracle connector for 19c Database, we were not able to create and it's giving following error.
Error code9603
DetailsERROR [08001] [Microsoft][ODBC Oracle Wire Protocol driver]Connection refused. Verify Host Name and Port Number. ERROR [08001] [Microsoft][ODBC Oracle Wire Protocol driver][Oracle]ORA-12203: unable to connect to destination Activity ID: 6f4d8e1c-5880-40a0-b168-914f417e99c5.
We have taken below actions but still no use.
White listed Oracle DB server IP at network level.
Updated IR servers to latest versions.
Please advice.
Thank You,
Venkat
Thank You,
Venkat