On OS X should my ORACLE_HOME env variable be...
/usr/local/oracle
or...
/usr/local/oracle/instantclient_10_2
On OS X should my ORACLE_HOME env variable be...
/usr/local/oracle
or...
/usr/local/oracle/instantclient_10_2
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.
If you follow the instructions here:
you won't need to set any environment variables. Its nice not to have to worry about it!