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
|
