Easysoft Data Access

Why do I get the error "ORACLE_HOME environment variable not set"?

There are two possible solutions for an Easysoft server (Easysoft ODBC-ODBC Bridge Server, Easysoft JDBC-ODBC Bridge Server, Easysoft XML-ODBC Server) running on Unix:

• Set and export ORACLE_HOME before starting the Easysoft Server in standalone mode. The server can be found in installation_dir/easysoft/server_product/server. (The default location for installation_dir is /usr/local.)

  ORACLE_HOME=oracle_libraries_dir
  export ORACLE_HOME

• Set and export ORACLE_HOME in the server script in installation_dir/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:

• Add an Environment element to the request sent from your client to the server. The Environment element data should be ORACLE_HOME=oracle_libraries_dir

  <Request>
    <Environment>
        ORACLE_HOME=oracle_libraries_dir
    </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 by the Oracle installer.

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:instant_client_dir
export LD_LIBRARY_PATH

Applies To

• Products
  • Easysoft XML-ODBC Server
  • Easysoft ODBC-ODBC Bridge
  • Easysoft JDBC-ODBC Bridge

Knowledge Base Feedback

* Did this content help you?

Yes No Maybe

* Please select one option based on your first choice:

I'm very satisfied I think it will help, but I haven't tried it yet It is helpful, but I need more information It is helpful, but hard to understand Seemed relevant in search results, but didn't help me The information is incorrect The page contains one or more broken links

Suggest new content or let us know how we can improve this content:

(* Required Fields)

• About Easysoft

• Contact Us
• About Us
• Clients
• Upgrade Offer
• Blog
• Careers

• Products

• ODBC Drivers
• JDBC Drivers
• Bridges and Gateways
• In Development

• Services

• Consultancy
• Training
• Custom Development

• Licensing

• Product Licenses
• Prices

• Support

• Support Home
• Solution Wizard
• Getting Started Guides
• User Guides
• Knowledge Base

• Search

• Easysoft.com
• Documentation
• Knowledge Base

• Popular Resources

• Developer Area
• Client Applications

• Legal

• Privacy Statement

© 1993 - 2024 Easysoft Limited. All rights reserved. Oracle® is a registered trademark of Oracle® Corporation and/or its affiliates. Other trademarks and registered trademarks appearing on easysoft.com are the property of their respective owners.

• 
• 
• 
•