Easysoft Data AccessWhy do I get the error "ORACLE_HOME environment variable not set"? |
|
There are two possible solutions for Easysoft servers (OOB Server, JOB Server, Easysoft XML-ODBC Server) running on Unix:
/usr/local/easysoft/server_product/server
ORACLE_HOME=/path/to/oracle_libraries
export ORACLE_HOME
/usr/local/easysoft/server_product/server if running the server under {x}inetd.Here is an additional solution if you are using the Easysoft XML-ODBC Server:
ORACLE_HOME=/path/to/oracle_libraries
<Request>
<Environment>
ORACLE_HOME=/path/to/oracle_libraries
</Environment>
.
.
</Request>
It is also possible to set environment variables such as ORACLE_HOME in the unixODBC odbc.ini file by using the DMEnvAttr attribute.
It would be unlikely for this issue to happen on a Microsoft Windows platform as the ORACLE_HOME environment is set as a system environment when installing the Oracle server software.
Note If you are using the Instant Client, you will need to set LD_LIBRARY_PATH instead of ORACLE_HOME. Use the appropriate method to set LD_LIBRARY_PATH to specify the location where the Instant Client is installed. For example:
LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/path/to/instant_client export LD_LIBRARY_PATH