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.
- 8392 replies
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).