[cx-oracle-users] cx_Oracle on OSX

[Dwayne K. <dw...@kr...>]

I promise....I really have looked online and in forums for clues here, but
I'm out of ideas.

I'm an Oracle DBA and I'm also familiar with python, having used it with
cx_Oracle on Windows for years.  I've never had a problem getting things
set up until now.

I'm setting up my new mac (OSX Maverick), and I have the Oracle instant
client installed and working:

Dwaynes-iMac:instantclient_11_2 dwayne$ sqlplus sys/oracle@ora11 as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Fri Dec 13 21:39:02 2013

Copyright (c) 1982, 2012, Oracle.  All rights reserved.

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - Production

With the Partitioning, OLAP, Data Mining and Real Application Testing
options

SQL>

I have both python 2.7 installed (came with OSX) and 3.2

Since I couldn't find an OSX specific port of cx_Oracle on sourceforge to
download, I downloaded the source, and tried to build, but I keep running
into this:

Dwaynes-iMac:cx_Oracle-5.1.2 dwayne$ python setup.py build

running build

running build_ext

building 'cx_Oracle' extension

cc -fno-strict-aliasing -fno-common -dynamic -arch x86_64 -arch i386 -g -Os
-pipe -fno-common -fno-strict-aliasing -fwrapv -mno-fused-madd
-DENABLE_DTRACE -DMACOSX -DNDEBUG -Wall -Wstrict-prototypes
-Wshorten-64-to-32 -DNDEBUG -g -fwrapv -Os -Wall -Wstrict-prototypes
-DENABLE_DTRACE -arch x86_64 -arch i386 -pipe
-I/Users/dwayne/dev/instantclient_11_2
-I/System/Library/Frameworks/Python.framework/Versions/2.7/include/python2.7
-c cx_Oracle.c -o build/temp.macosx-10.9-intel-2.7-11g/cx_Oracle.o
-DBUILD_VERSION=5.1.2

clang: warning: argument unused during compilation: '-mno-fused-madd'

*cx_Oracle.c:10:10: **fatal error: **'oci.h' file not found*

#include <oci.h>

*         ^*

1 error generated.

My profile has the following variables set (which I think must be fine
since SQL*Plus works)

LD_LIBRARY_PATH=:/Users/dwayne/dev/instantclient_11_2

PATH=/Library/Frameworks/Python.framework/Versions/3.3/bin:/usr/bin:/bin:/usr/sbin:/sbin:/usr/local/bin:/Applications/Server.app/Contents/ServerRoot/usr/bin:/Applications/Server.app/Contents/ServerRoot/usr/sbin:/Users/dwayne/dev/instantclient_11_2

DYLD_LIBRARY_PATH=:/Users/dwayne/dev/instantclient_11_2

Is there something else required for the build process to work?  From the
error, it looks like it's looking for a full set of header files, which
wouldn't only exist in a full server install wouldn't they?

Any help appreciated.

Dwayne