Question

Oracle Database Connection

  • 25 May 2023
  • 1 reply
  • 5 views

Badge

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.


1 reply

Userlevel 4

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

Reply