DocBook installation on OS X The Window
Feb 08

Installing cx_Oracle on Mac OS X

Technology, Tips, Work, experience, informatics, informatics, macosx, macosx Add comments

steps

Oracle InstantClient installation
$ unzip instantclient-basic-macosx-10.1.0.3.zip
$ unzip instantclient-sqlplus-macosx-10.1.0.3.zip
$ cd instantclient10_1
$ ln -s libclntsh.dylib.10.1 libclntsh.dylib
$ ln -s libocci.dylib.10.1 libocci.dylib
$ cd..
$ sudo mkdir /usr/local/oracle
$ sudo mv instantclient10_1 /usr/local/oracle/instantclient10_1
$ sudo pico /etc/profile
(add)

#Oracle settings
ORACLE_HOME=”/usr/local/oracle”
export ORACLE_HOME

DYLD_LIBRARY_PATH=”/usr/local/oracle/instantclient10_1″
export DYLD_LIBRARY_PATH

SQLPATH=”/usr/local/oracle/instantclient10_1″
export SQLPATH

export PATH=”$PATH:/usr/local/oracle/instantclient10_1″

$ source /etc/profile
$ sqlplus
$ sudo mkdir -p /b/729/rdbms/lib/
$ sudo ln -s /usr/local/oracle/instantclient10_1/libclntsh.dylib.10.1 /b/729/rdbms/lib/libclntsh.dylib.10.1

cx_Oracle installation

$ cd cx_Oracle-4.2/
$ sudo python setup.py build
$ sudo python setup.py install

links

5 Responses to “Installing cx_Oracle on Mac OS X”

  1. pedro.emanuel.salgado Says:
    February 9th, 2007 at 11:24

    Just updated this post.
    I missed the setup of ORACLE_HOME environment variable and fix an error on the instructions.

  2. pedro.emanuel.salgado Says:
    August 31st, 2007 at 14:26

    I tried other cx_Oracle versions (4.2.1, 4.3.*) and it doesn’t work… checking how to fix this…

  3. pedro.emanuel.salgado Says:
    August 31st, 2007 at 15:46

    I got some extra info from here:

    http://sourceforge.net/mailarchive/message.php?msg_id=AC2B79C2-9896-4001-A501-9E9DA0D1A199@camptocamp.com

    it seems this will only work for PPC (Oracle hasn’t provided a universal binary?).

    anyway, I downloaded ship_mac_client.cpio.gz into tmp from
    http://www.oracle.com/technology/software/products/database/oracle10g/htdocs/macsoft.html

    read the documentation
    http://www.oracle.com/technology/documentation/database10g.html

    I followed all instructions:
    http://download.oracle.com/docs/html/B13955_01/ch2_mac.htm#CCHCDHHI

    I installed the OCI, instant_client and sqlplus.
    I have downloaded cx_Oracle-4.3.1, compiled and installed it successfully.

    I will publish the complete instructions… but I need to clean them up first. :s

  4. Pedro Salgado Says:
    February 7th, 2008 at 13:11

    I have updated the installation steps in a different post.

  5. Build and install cx_Oracle on MacOS X Leopard Intel « Coding Naked Says:
    May 7th, 2008 at 21:35

    [...] in order to build and install it successfully, which I will describe here. I used the advice on Pedro’s Blog as a starting point and adapted it so that it worked for [...]

Leave a Reply

You must be logged in to post a comment.