Oracle Connectivity

Problems sometimes arise when attempting to connect to an Oracle database. This is almost always due to a misconfiguration in the user’s environment. The following suggestions can often help detect and overcome such problems.

  • Ensure you can connect to the database with the service name, user name, and password using SQL*Plus.
  • Ensure you have a version of the Oracle client software installed that is compatible with your Oracle database.
  • If you had older versions of the Oracle client software installed, make sure that your PATH variable has the current version’s Oracle folder first.
  • Ensure the Oracle Client is 64-bit, to match the bit architecture of FME.
  • If using tnsnames.ora with the Oracle Instant Clients, ensure the TNS_ADMIN environment variable is set and pointing to the folder containing the tnsnames.ora file.

See Also