tags:

views:

175

answers:

3

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

/usr/local/oracle

or...

/usr/local/oracle/instantclient_10_2
+3  A: 

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.

sgreeve
A: 

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

Ethan
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.
sgreeve
A: 

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!

Mark Harrison