Oracle Spatial Relational Troubleshooting

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/
product.8.1.5

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}:
${FME_HOME}:
${ORACLE_HOME}/lib