oracle client mac os X El Capitan

use this link at tomeuwork.wordpress.com

$ cd instantclient_11_2

$ mv ojdbc* /Applications/oracle/product/instantclient_64/11.2.0.4.0/jdbc/lib/
$ mv x*.jar /Applications/oracle/product/instantclient_64/11.2.0.4.0/rdbms/jlib/
$ mv glogin.sql /Applications/oracle/product/instantclient_64/11.2.0.4.0/sqlplus/admin/
$ mv *dylib* /Applications/oracle/product/instantclient_64/11.2.0.4.0/lib/
$ mv *README /Applications/oracle/product/instantclient_64/11.2.0.4.0/
$ mv * /Applications/oracle/product/instantclient_64/11.2.0.4.0/bin/


CORRECTION for cx_Oracle to work in el-capitan
BIG HEADACHES in El Capitan OS X Mac.  If you get the bloody “ges/cx_Oracle.so, 2): Library not loaded: /ade/b/3071542110…..”, then :

Make flash execute virtualenv python flask script as:

The WSGI script

When we’re running our application on a browser, we’ll need a “run script” that tells the server how to setup your application. In other words, the webserver doesn’t run your application directly like we did from the terminal, but uses WSGI to load the application into a separate process. In this WSGI script we can tell the server to use virtualenv to load our setup.

Create a new file called application.wsgi with the following contents:

import os, sys

PROJECT_DIR = '/www/helloflask.enigmeta.com/helloflask'

activate_this = os.path.join(PROJECT_DIR, 'bin', 'activate_this.py')
execfile(activate_this, dict(__file__=activate_this))
sys.path.append(PROJECT_DIR)

from helloflask import app as application

Note that this file refers to a (non-existent) /www/helloflask.enigmeta.com directory. We’ll create this directory on the server in a minute.

Use virtualenv for cx_Oracle.  Use virtualenv’s  pip command to load cx_Oracle or other  packages.

http://docs.python-guide.org/en/latest/dev/virtualenvs/
https://virtualenv.pypa.io/en/latest/installation.html

DO NOT follow this post.  See the $ORACLE_HOME folder below:

BASIC_README
JDBC_README
SQLPLUS_README
admin -> network/admin/
adrci
genezi
glogin.sql
libclntsh.dylib -> libclntsh.dylib.11.1
libclntsh.dylib.11.1
libheteroxa11.dylib
libnnz11.dylib
libocci.dylib -> libocci.dylib.11.1
libocci.dylib.11.1
libociei.dylib
libocijdbc11.dylib
libsqlplus.dylib
libsqlplusic.dylib
network
ojdbc5.jar
ojdbc6.jar
orai18n-mapping.jar
orai18n.jar
sdk
sqlplus
uidrvci
xstreams.jar


export ORACLE_HOME=”/Applications/oracle/product/instantclient_64/11.2.0.4.0″
export PATH=$ORACLE_HOME/bin:$PATH
export DYLD_LIBRARY_PATH=$ORACLE_HOME/lib

You MAY use LD_LIBRARY_PATH as well

To load this profile, run the following command:

$ source ~/.bash_profile

install cx_Oracle ?? with PIP , there is an issue on linking….

You have not got a clntsh library to link against

To fix this you need in /usr/lib to link libclntsh.dylib.10.1 to libclntsh.dylib and libocci.dylib.10.1 to libocci.dylib

Wrong… Don’t mess with /usr/lib… link at $ORACLE_HOME/lib itself

lrwxr-xr-x   1 root      wheel         20 Nov  6 21:35 libclntsh.dylib -> libclntsh.dylib.11.1
-r-xr-xr-x@  1 tperiasa  staff   66167420 Feb  7  2014 libclntsh.dylib.11.1
lrwxr-xr-x   1 root      wheel         18 Nov  6 21:36 libocci.dylib -> libocci.dylib.11.1
-r-xr-xr-x@  1 tperiasa  staff    1897664 Feb  7  2014 libocci.dylib.11.1

Advertisements
oracle client mac os X El Capitan

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s