Oracle database

  1. On UNIX™, LD_LIBRARY_PATH (or equivalent) must hold the path to find the Oracle® client library. On Microsoft Windows, the PATH environment variable must contain the path to Oracle client library.
  2. In an Oracle Database Server context, make sure that ORACLE_HOME and ORACLE_SID environment variables are properly set.
  3. With an Oracle Instant Client environment, define the TNS_ADMIN variable to find the configutation files.
  4. The TNSNAMES.ORA file must define the database server identifiers for remote connections (the Oracle Listener must be started on the database server to allow remote connections).
  5. The SQLNET.ORA file must define network settings for remote connections.
  6. Make sure the database client locale is properly defined (NLS_LANG).
  7. Do a connection test with the Oracle sqlplus command line tool.