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 bit version of the software being used matches the Oracle Client bit version. For example, FME 32-bit requires the Oracle 32-bit Client in the path.
- 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
SourceSansPro-ExtraLightItalic.ttf