Skip to main content
Question

Oracle Database Connection

  • May 25, 2023
  • 1 reply
  • 66 views
pauldeq
Contributor
Forum|alt.badge.img+6

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

david_r
Celebrity
  • david_rCelebrity
  • May 26, 2023

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

Community Stats

32,757
Posts
124,226
Replies
41,278
Members
Terms & ConditionsAccessibility statement
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.