Oracle client software working on OS X Lion

Date: Monday 25th July 2011

By Mangrove Mike

Category: Linux Code

After upgrading to OS X Lion most of my software was working fine. But, alas, the first time I used Oracle sqlplus (for all my Oracle scripting goodies) it died with a segment fault.

I did have a full 10.2.0.4 client installed so I tried the 64 bit instantclient and got basically the same problem.

I then tried the 32 bit instantclient and after doing some mods to key Oracle environment variables in /etc/bashrc I got it finally to work.

The variables in bashrc were set by the Oracle client installation (as it does on almost all platforms) are the main Oracle ones: ORACLE_HOME, LD_LIBRARY_PATH, SQLPATH, DYTD_LIBRARY_PATH and TNS_ADMIN. All of these I set to the instantclient directory - you will need a tnsnames.ora and/or sqlnet.ora as well for the Oracle Network connection strings.

Hope this helps and good luck.

2 comments

I have the same problem. Using the 32 bits solved the segmentation fault but for those that need to use oci with php, this doesn't work. Have you any ideia?

Posted by rgodinho, 27/07/2011 12:00:10 am

I have heard that by installing the full 32 bit client software may also solve the problem. Give that a try.

Posted by Mangrove Mike, 28/07/2011 11:57:43 am