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?