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

• Configuring Mac OS to allow FME Form to locate Oracle client libraries