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, user name, and password using SQL*Plus.
- Ensure that your ORACLE_HOME environment variable is correctly set: see Oracle documentation for details.
- If you have had older versions of the Oracle client software installed, make sure that your PATH variable has the current version’s Oracle folder first, before any other Oracle software, including the WebDB package.
- When running on UNIX, the following environment variables should be defined:
|
Variable |
Contents |
Sample Value |
|---|---|---|
|
ORACLE_BASE |
Top level of folder into which Oracle client software is installed. |
/opt2/oracle8i/app/oracle |
|
ORACLE_HOME |
The Oracle product folder. |
/opt2/oracle8i/app/oracle/ |
|
ORACLE_SID |
The system ID for the host’s database instance. |
FME |
|
LD_LIBRARY_PATH |
A list of folders which will be searched for shared objects. This list must include the FME_HOME path, as well as the lib subfolder of ORACLE_HOME. |
${LD_LIBRARY_PATH}: |