Hello I am using FME 2021.2 on an AWS machine and am connecting to an Oracle DB on-prem, but the connection is very slow. I currently have SQL Developer setup on the AWS machine and its connection to Oracle is as expected (fast).

Issue:

When I test the connection in FME it can take several minutes to recieve the pop-up saying 'successful connection'.

• I am using TNS and have setup the tnsnames.ora file
• I dont get any warnings or errors in the log
• When I use the same file for SQL Developer its response is very fast

Does anyone have any suggestions as to how to speed up that connection?