Mac OS X Capitan安装cx_Oracle

素颜马尾好姑娘i 2022-05-29 05:56 278阅读 0赞

转载地址： http://www.coin163.com/it/4634775696636752268/image-not-found-zsh-pipMac-OS-X-Capitancx\_Oracle

## Mac OS X Capitan安装cx\_Oracle ##

相关标签:  [cx\_oracle][cx_oracle]  [os][]  [image not found][]  [安装][Link 1]  [zsh][]  [pip][]  [mac os x capitan][]  [mac][]

前言

借用Joel Vasallo在其博客《Installing cx\_Oracle on a Mac》中所说：

So as previously mentioned, I got a Macbook Pro. More than four months later, I am loving it more and more. The only gripe I had was installing a specific package called cx\_Oracle; a Python Oracle DB connection package. After a lot of attempts, I finally got a working copy installed on my local machine. I noticed there are many tutorials around the web, but they are a bit outdated, I am on Mavericks, so I will create a nice article not only for you guys, but also for myself.

环境：

系统：OS X EI Capitan v10.11.3
    CPU：2.7 GHz Intel Core i5

需要下载的内容（请去oracle官网下，没有账号就先注册一个）：

instantclient-basic-macos.x64-11.2.0.4.0.zip
    instantclient-sdk-macos.x64-11.2.0.4.0.zip

解压和移动文件：

mkdir /Users/<username_here>/oracle
    mv /Users/<username_here>/Downloads/instantclient-* /Users/<username_here>/oracle
    cd /Users/<username_here>/oracle
    unzip instantclient-basic-macos.x64-11.2.0.4.0.zip
    unzip instantclient-sdk-macos.x64-11.2.0.4.0.zip
    cd instantclient_11_2/sdk
    unzip ottclasses.zip
    cd ..
    cp -R ./sdk/* .
    cp -R ./sdk/include/* .
    ln -s libclntsh.dylib.11.1 libclntsh.dylib
    ln -s libocci.dylib.11.1 libocci.dylib

配置环境变量：

vim ~/.bash_profile
    export ORACLE_HOME=/Users/<username_here>/oracle/instantclient_11_2
    export DYLD_LIBRARY_PATH=$ORACLE_HOME
    export LD_LIBRARY_PATH=$ORACLE_HOME
    export PATH=$PATH:$ORACLE_HOME
    source ~/.bash_profile

提示一下，如果使用的不是默认的BASH，而使用的的是ZSH，请确认：～/.zshrc是否加载了~/.bash\_profile，也就是～/.zshrc是否写了“source ~/.bash\_profile”，否则会找不到环境变量，因为ZSH启动默认不加载~/.bash\_profile。同时上诉脚本最后一句改为：

source ～/.zshrc

在目录下执行以下内容来更改安装信息：

curl -O https://raw.githubusercontent.com/kubo/fix_oralib_osx/master/fix_oralib.rb
    sudo ruby fix_oralib.rb --ic_dir /Users/<username_here>/oracle/instantclient_11_2

这是为了防止直接安装而造成的错误：

#执行包含以下python代码的文件：
    import cx_Oracle
    #错误信息如下：
    Traceback (most recent call last):
      File "ex1.py", line 1, in <module>
        import cx_Oracle
      File "build/bdist.macosx-10.11-intel/egg/cx_Oracle.py", line 7, in <module>
      File "build/bdist.macosx-10.11-intel/egg/cx_Oracle.py", line 6, in __bootstrap__
    ImportError: dlopen(/Users/watson/.python-eggs/cx_Oracle-5.2.1-py2.7-macosx-10.11-intel.egg-tmp/cx_Oracle.so, 2): Library not loaded: /ade/b/3071542110/oracle/rdbms/lib/libclntsh.dylib.11.1
      Referenced from: /Users/watson/.python-eggs/cx_Oracle-5.2.1-py2.7-macosx-10.11-intel.egg-tmp/cx_Oracle.so
      Reason: image not found

安装cx\_Oracle，当前版本为v5.2.1， 没有安装pip的请先安装pip：

sudo pip install --no-cache-dir --allow-external --allow-unverified cx_oracle

修改安装后的内容：

sudo ruby fix_oralib.rb --ic_dir /Users/<username_here>/oracle/instantclient_11_2 /Library/Python/2.7/site-packages/cx_Oracle.so

这是为了解决以下问题：

#执行包含以下python代码的文件：
    import cx_Oracle
    #错误信息如下：
    Traceback (most recent call last):
      File "ex1.py", line 1, in <module>
        import cx_Oracle
    ImportError: dlopen(/Library/Python/2.7/site-packages/cx_Oracle.so, 2): Library not loaded: @rpath/libclntsh.dylib.11.1
      Referenced from: /Library/Python/2.7/site-packages/cx_Oracle.so
      Reason: image not found

最后测试一下吧：

import cx_Oracle, string, getpass
    
    def main():
      # Get password
      pswd = getpass.getpass()
          
      # Build connection string
      user = "CS327_jdoe"
      host = "oracle.microlab.cs.utexas.edu"
      port = "1521"
      sid = "orcl"
      dsn = cx_Oracle.makedsn (host, port, sid)
    		    
      # Connect to Oracle and test
      con = cx_Oracle.connect (user, pswd, dsn)
      if (con):
        print "Connection successful"
        print con.version
      else:
        print "Connection not successful"
    
      con.close()
    
    main()

最后提示一下，当前版本需要建立$ORACLE\_HOME/log/diag/clients目录，以免~/目录下出现莫名的oradiag\_<user\_name>目录。

参考：

http://www.cs.utexas.edu/~mitra/csSpring2011/cs327/cx\_mac.html

http://stackoverflow.com/questions/33259671/how-to-install-cx-oracle-on-el-capitan

http://joelvasallo.com/?p=276

https://sourceforge.net/p/cx-oracle/mailman/message/34534872/

http://stackoverflow.com/questions/3520054/what-is-oradiag-user-folder

原文

>  前言       借用Joel Vasallo在其博客《Installing cx\_Oracle on a Mac》中所说：       So as previously mentioned, I got a Macbook Pro. More than four months later, I am loving it mor

[cx_oracle]: http://www.coin163.com/tag/cx_oracle
[os]: http://www.coin163.com/tag/os
[image not found]: http://www.coin163.com/tag/image%20not%20found
[Link 1]: http://www.coin163.com/tag/%E5%AE%89%E8%A3%85
[zsh]: http://www.coin163.com/tag/zsh
[pip]: http://www.coin163.com/tag/pip
[mac os x capitan]: http://www.coin163.com/tag/mac%20os%20x%20capitan
[mac]: http://www.coin163.com/tag/mac