Hello @Pattar, Mounesh SOMIBM-IBM
The error message ORA-50000: Connection request timed out
indicates that the connection request to the database has timed out. This could be due to a number of reasons such as network issues, firewall settings, or incorrect connection string parameters.
Here are a 5-steps you can try to troubleshoot the issue:
- Check the network connectivity between the Azure Function and the on-premises Oracle database. Ensure that there are no network issues or firewall settings that are blocking the connection.
- Verify that the connection string parameters are correct. Ensure that the hostname, port number, and service name are correct and match the values in the
tnsnames.ora
file on the machine where the Oracle database is installed. - Try increasing the connection timeout value in the connection string. You can do this by adding the
Connection Timeout
parameter to the connection string and setting its value to a higher value (in seconds). - Check the Oracle database logs for any errors or warnings related to the connection request.
- Try connecting to the Oracle database using a different tool or client to verify that the connection works.
I hope that this response has addressed your query and helped you overcome your challenges. If so, please mark this response as Answered. This will not only acknowledge our efforts, but also assist other community members who may be looking for similar solutions.