meoww-bot · November 14, 2022 07:54 · Apr 12, 2014 · Apr 7, 2014 · Apr 7, 2014 · Apr 7, 2014
diff --git a/cx_oracle.md b/cx_oracle.md
@@ -1,5 +1,7 @@
 First of all, it just seems like doing anything with Oracle is obnoxiously painful for no good reason. It's the nature of the beast I suppose. cx_oracle is a python module that allows you to connect to an Oracle Database and issue queries, inserts, updates..usual jazz.
 
+# Linux
+
 Step 1:  
 ```bash
 sudo apt-get install build-essential unzip python-dev libaio-dev
@@ -34,13 +36,54 @@ export ORACLE_HOME=/location/of/your/files/instantclient_11_2
 export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME
 ```
 
-Step 4:  Edit /etc/ld.so.conf.d/oracle.conf
+Step 5:  Edit /etc/ld.so.conf.d/oracle.conf
 
 This is a new file, simple add the location of your .so files here, then update the ldpath using
 ```
 sudo ldconfig
 ```
 
+Step 6. Finaly just install cx_oracle module:
+```
+pip install cx_oracle
+```
+
+# Mac OS X
+
+Step 1:  
+install [Homebower](http://brew.sh/) for the compilation tools
+
+Step 2.  Click [here](http://www.oracle.com/technetwork/topics/intel-macsoft-096467.html) to download the appropriate zip files required for this.  You'll need:
+
+* instantclient-basic-macosx
+* instantclient-sdk-macosx
+
+Get the appropriate version for your system.. x32 vs x64 etc.
+*Make sure you don't get version 12, since it's not supported by the cx_Oracle moduel yet.*
+
+Unzip the content in the same location, so you'll end up with a folder named:  instantclient_11_2 (in my case) which will contain a bunch of .so and jar files.
+
+just for ease of use I'll use $ORACLE_HOME which will basically point to the location where you unzipped your installclient folders.
+
+```
+export ORACLE_HOME=$(pwd)/instantclient_11_2
+```
+
+Step 3.   create a symlink to your SO file.
+
+```
+cd $ORACLE_HOME
+ln -s libclntsh.dylib.11.2 libclntsh.dylib  #the version number on your .so file might be different
+ln -s libocci.dylib.11.2 libocci.dylib
+```
+
+Step 4.  Update your /etc/profile or your ~/.bashrc
+```
+export ORACLE_HOME=/location/of/your/files/instantclient_11_2
+export DYLD_LIBRARY_PATH=$DYLD_LIBRARY_PATH:$ORACLE_HOME
+export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME
+```
+
 Step 5. Finaly just install cx_oracle module:
 ```
 pip install cx_oracle

diff --git a/cx_Oracle.md → cx_oracle.md b/cx_Oracle.md → cx_oracle.md
@@ -41,3 +41,7 @@ This is a new file, simple add the location of your .so files here, then update
 sudo ldconfig
 ```
 
+Step 5. Finaly just install cx_oracle module:
+```
+pip install cx_oracle
+```
diff --git a/cx_Oracle.md b/cx_Oracle.md
@@ -5,7 +5,7 @@ Step 1:
 sudo apt-get install build-essential unzip python-dev libaio-dev
 ```
 
-Step 2.  Click [http://www.oracle.com/technetwork/topics/linuxx86-64soft-092277.html:here] to download the appropriate zip files required for this.  You'll need:
+Step 2.  Click [here](http://www.oracle.com/technetwork/topics/linuxx86-64soft-092277.html) to download the appropriate zip files required for this.  You'll need:
 
 * instantclient-basic-linux
 * instantclient-sdk-linux
@@ -41,5 +41,3 @@ This is a new file, simple add the location of your .so files here, then update
 sudo ldconfig
 ```
 
-- See more at: http://csgeek-random.blogspot.pt/2013/04/installing-python-cxoracle-on-ubuntu.html#sthash.koZMgg7i.dpuf
-
diff --git a/cx_Oracle.md b/cx_Oracle.md
@@ -1,7 +1,7 @@
 First of all, it just seems like doing anything with Oracle is obnoxiously painful for no good reason. It's the nature of the beast I suppose. cx_oracle is a python module that allows you to connect to an Oracle Database and issue queries, inserts, updates..usual jazz.
 
 Step 1:  
-```
+```bash
 sudo apt-get install build-essential unzip python-dev libaio-dev
 ```
 

diff --git a/gistfile1.txt → cx_Oracle.md b/gistfile1.txt → cx_Oracle.md
diff --git a/gistfile1.txt b/gistfile1.txt
@@ -0,0 +1,45 @@
+First of all, it just seems like doing anything with Oracle is obnoxiously painful for no good reason. It's the nature of the beast I suppose. cx_oracle is a python module that allows you to connect to an Oracle Database and issue queries, inserts, updates..usual jazz.
+
+Step 1:  
+```
+sudo apt-get install build-essential unzip python-dev libaio-dev
+```
+
+Step 2.  Click [http://www.oracle.com/technetwork/topics/linuxx86-64soft-092277.html:here] to download the appropriate zip files required for this.  You'll need:
+
+* instantclient-basic-linux
+* instantclient-sdk-linux
+
+Get the appropriate version for your system.. x86 vs 64 etc.
+*Make sure you don't get version 12, since it's not supported by the cx_Oracle moduel yet.*
+
+Unzip the content in the same location, so you'll end up with a folder named:  instantclient_11_2 (in my case) which will contain a bunch of .so and jar files.
+
+just for ease of use I'll use $ORACLE_HOME which will basically point to the location where you unzipped your installclient folders.
+
+```
+export ORACLE_HOME=$(pwd)/instantclient_11_2
+```
+
+Step 3.   create a symlink to your SO file.
+
+```
+cd $ORACLE_HOME
+ln -s libclntsh.so.11.1   libclntsh.so  #the version number on your .so file might be different
+```
+
+Step 4.  Update your /etc/profile or your ~/.bashrc
+```
+export ORACLE_HOME=/location/of/your/files/instantclient_11_2
+export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME
+```
+
+Step 4:  Edit /etc/ld.so.conf.d/oracle.conf
+
+This is a new file, simple add the location of your .so files here, then update the ldpath using
+```
+sudo ldconfig
+```
+
+- See more at: http://csgeek-random.blogspot.pt/2013/04/installing-python-cxoracle-on-ubuntu.html#sthash.koZMgg7i.dpuf
+