ERROR [08S01] -[Oracle]Network Operation Timed Out. - Liked Service Azure Synapse

Question

ERROR [08S01] -[Oracle]Network Operation Timed Out. - Liked Service Azure Synapse

João Felipe Barbosa Cerqueira Carvalho 40

While adding to an Oracle database from Azure Synapse using Integratio Runtime Self-hosted we received the following error when testing conection with database.

"Failed to connect to the database. Error message: ERROR [08S01] [Microsoft][ODBC Oracle Wire Protocol driver]Socket closed.

ERROR [08S01] [Microsoft][ODBC Oracle Wire Protocol driver][Oracle]Connection Dead.

ERROR [HYT00] [Microsoft][ODBC Oracle Wire Protocol driver]Timeout expired.

ERROR [08001] [Microsoft][ODBC Oracle Wire Protocol driver][Oracle]Network Operation Timed Out.

ERROR [08S01] [Microsoft][ODBC Oracle Wire Protocol driver]Socket closed.

ERROR [08S01] [Microsoft][ODBC Oracle Wire Protocol driver][Oracle]Connection Dead.

ERROR [HYT00] [Microsoft][ODBC Oracle Wire Protocol driver]Timeout expired.

ERROR [08001] [Microsoft][ODBC Oracle Wire Protocol driver][Oracle]Network Operation Timed Out."

We tried test through Azure Synapse and tool Test conection in folder Diagnostic in Integration Runtime Configuration Manager.

The version of our Integration Runtime is 5.32.8600.2.

OBS: We already have one conection with Oracle database and clone the conection for this second database, changing the credentials.

João Felipe Barbosa Cerqueira Carvalho 40 Reputation points

2023-11-24T16:13:10.9533333+00:00

Hi,

as previously said, we have a connection with Oracle Database in Integration Runtime, where the version is same at new Oracle data base. We tried connection with Oracle SQL Developer and we were successfull. Therefore, we would like to know if there any configuration in IR or other configuration in server for establish connection, as well as knowing where I can consult the IR logs.

Att,

João Felipe
João Felipe Barbosa Cerqueira Carvalho 40 Reputation points

2023-11-24T21:18:40.05+00:00

We fix the problem changing the rules of firewall in the database server. Thanks for helping.

Accepted answer

0 additional answers

Your answer

João Felipe Barbosa Cerqueira Carvalho 40 Reputation points

2023-11-24T16:13:10.9533333+00:00

Hi,

as previously said, we have a connection with Oracle Database in Integration Runtime, where the version is same at new Oracle data base. We tried connection with Oracle SQL Developer and we were successfull. Therefore, we would like to know if there any configuration in IR or other configuration in server for establish connection, as well as knowing where I can consult the IR logs.

Att,

João Felipe
João Felipe Barbosa Cerqueira Carvalho 40 Reputation points

2023-11-24T21:18:40.05+00:00

We fix the problem changing the rules of firewall in the database server. Thanks for helping.

Answer 1

Hi@João Felipe Barbosa Cerqueira Carvalho
Welcome to Microsoft Q&A platform and thanks for posting your question here.

The error message "ERROR [08001] [Microsoft][ODBC Oracle Wire Protocol driver][Oracle]Network Operation Timed Out" indicates that the connection between Azure Synapse and the Oracle database has timed out. This can be caused by a variety of factors, including network issues, firewall settings, or incorrect configuration of the self-hosted integration runtime.

To resolve this issue, please follow the steps below:

Check if the ODBC driver is installed on the machine where the Integration Runtime Self-hosted is running. If not, install the ODBC driver.
Check if the ODBC driver version is compatible with the Oracle client version. If not, install a compatible version of the ODBC driver.
Check the network connectivity between Azure Synapse and the Oracle database. Ensure that the database is accessible from the machine where the self-hosted integration runtime is installed.
Verify that the firewall settings on the machine hosting the Oracle database allow incoming connections from the machine where the self-hosted integration runtime is installed.
Check the configuration of the self-hosted integration runtime. Ensure that the runtime is configured with the correct credentials and connection details for the Oracle database.
Verify that the Oracle database is up and running and that there are no issues with the database itself.
Check the logs for the self-hosted integration runtime to see if there are any errors or warnings that could provide more information about the issue.
If the issue persists, try upgrading the self-hosted integration runtime to the latest version and test the connection again.

I hope this helps! Let me know if you have any further questions.

Harishga 6,005 Reputation points Microsoft External Staff

2023-11-27T11:36:23.13+00:00

Hi@João Felipe Barbosa Cerqueira Carvalho
Following up to see if the above answer was helpful. If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

Share via

ERROR [08S01] -[Oracle]Network Operation Timed Out. - Liked Service Azure Synapse

0 additional answers

Your answer