Setting up Oracle linked service using version 2.0 in ADF using SHIR

Hi Deshmukh Aditya

Thanks for reaching on Microsoft Q&A! Welcome

Can you please check the below things carefully:

1. Integration Runtime:
   • Ensure that your SHIR is properly set up and has access to the required network routes to reach your Oracle database.
   • If you have multiple nodes for SHIR, make sure all are configured the same and functioning.
2. Encryption Settings:
   • Since you mentioned changing the additional properties "Encryption client" and "Crypto checksum client" from "accepted" to "rejected," temporarily revert those changes. If your Oracle database requires secure connections, it may be dropping the connection due to mismatched security settings.
   • Make sure the Oracle server settings also have encryption properly configured.
3. Timeout and Retry Settings:
   • Increase the connection timeout and adjust any retry counts in your linked service settings. Especially for connections over a network that may experience latency.
4. Check Firewall and Security Groups:
   • Verify that there are no firewall restrictions on the Oracle server that might prevent SHIR from establishing a connection. Ensure that the necessary ports are open.

Can you try using the below configuration for server name replace with your server details

{ 
    "name": "OracleLinkedService", 
    "properties": { 
        "type": "Oracle", 
        "version": "2.0", 
        "typeProperties": { 
            "server": "(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST= oraclesample.com)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=<<yours>>)))",  
            "username": "<user name>",  
            "password": "<password>",  
            "authenticationType": "Basic" 
        }, 
        "connectVia": { 
            "referenceName": "<name of Integration Runtime>", 
            "type": "IntegrationRuntimeReference" 
        } 
    } 
}

Please refer the below Microsoft document for details:

https://free.blessedness.top/en-us/azure/data-factory/connector-oracle?tabs=data-factory

If you still stuck, can you please provide us the linked service configuration and what type of datasets and files you are using.

Kindly consider upvoting the comment if the information provided is helpful. This can assist other community members in resolving similar issues.

Thanks!

Kalyani