Saturday, April 30, 2011

Proper way to set ORACLE_HOME?

On OS X should my ORACLE_HOME env variable be...

/usr/local/oracle

or...

/usr/local/oracle/instantclient_10_2
From stackoverflow
  • It should be set to the value of the directory that contains your \bin directory, which in your case I believe would be /usr/local/oracle/instantclient_10_2.

  • Set it to /usr/local/oracle and everything is working now. Don't know if that means /usr/local/oracle is necessarily correct.

    sgreeve : Do you have more than one Oracle installation? i.e. your ORACLE_HOME may be pointing at some other installation other than the instantclient. Just a thought - hard to say without further info on what's in these directories.
  • If you follow the instructions here:

    http://stackoverflow.com/questions/684352/installing-oracle-instantclient-on-mac-os-x-without-setting-environment-variables

    you won't need to set any environment variables. Its nice not to have to worry about it!

0 comments:

Post a Comment