欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识!
您现在的位置是: 首页

Mac OS X Capitan安装cx_Oracle

程序员文章站 2022-05-25 23:17:58
...

 前言

      借用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://*.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://*.com/questions/3520054/what-is-oradiag-user-folder