Oracle database

  1. The ORACLE_HOME environment variable must define the Oracle software installation path.
  2. The ORACLE_SID environment variable can be used to define the name of the local database instance.
  3. The PATH environment variable must define the access path to database client programs.
  4. On UNIX™, LD_LIBRARY_PATH (or equivalent) must hold the path to $ORACLE_HOME/lib.
  5. The Oracle® client library 'ORACLE_HOME/lib/libclntsh*' must be available.
  6. 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).
  7. The SQLNET.ORA file must define network settings for remote connections.
  8. Make sure the database client locale is properly defined.
  9. You can make a connection test with the Oracle sqlplus command line tool.