I tried to create an Oracle DB connection under Tools>>FME Options>>Database Connections, but every time I test the connection, I get the following error that is attached. Please assist. Thank you. BTW this is using FME Desktop version 2022.2.
Page 1 / 1
Try using an easy connect string, where you can specify port numbers etc, .e.g.
//host>:port][/service_name]
See also: https://www.orafaq.com/wiki/EZCONNECT
Also make sure that the appropriate ports are open in the firewall(s).