前言
借用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
相关推荐
Mac_OS_X_10.11-EI_Capitan懒人版制作及安装 Mac_OS_X_10.11-EI_Capitan懒人版制作及安装
os_x_el_capitan_v0.3b.zip
mac系统 OS X 10.11 El Capitan GM Candidate by TechReviews 附件有迅雷BT链接,支持迅雷下载
OS X EI Capitan 10.11.5 百度盘下载
Customizing OS X El Capitan Edition 英文mobi 本资源转载自网络,如有侵权,请联系上传者或csdn删除 本资源转载自网络,如有侵权,请联系上传者或csdn删除
OS X 10.11 操作系统ISO种子下载
装了OS X EI Capitan发现之前的USB无线网卡驱动4in1_Wlan_11n_USB_MacOS10.10_MacOS10.9_Driver_83.29.12.03_UI_2.3.1 装不了。用pacifist看了一下,原来这驱动有系统限制,只能装在10.10.9以下的系统,对于10.11,...
Mac OS X 编辑 讨论 macOS是苹果公司为Mac系列产品开发的专属操作系统。macOS是苹果Mac系列产品的预装系统,处处体现着简洁的宗旨。 macOS是全世界第一个基于FreeBSD系统采用“面向对象操作系统”的全面的操作系统。...
For Mac OS X El Capitan (version 10.11) For Mac OS X Yosemite (version 10.10) For Mac OS X Mavericks (version 10.9) For PL2303 H/HX/HXD/EA/RA/SA/TA/TB chip versions For Prolific USB VID_067B&PID;_...
opencv均值迭代阈值法是在Mac OS X EI Capitan系统上,运行平台是Clion,用OpenCV2.4.11版本,cmake编译,这是一个图像处理中均值迭代阈值法对图像进行区域分割的实现,基本的步骤为: 1)选择一个初始化阈值T,通常...
opencv均值迭代阈值法是在Mac OS X EI Capitan系统上,运行平台是Clion,用OpenCV2.4.11版本,cmake编译,这是一个图像处理中均值迭代阈值法对图像进行区域分割的实现,基本的步骤为: 1)选择一个初始化阈值T,通常...
For Mac OS X El Capitan (version 10.11) For Mac OS X Yosemite (version 10.10) For Mac OS X Mavericks (version 10.9) For PL2303 H/HX/HXD/EA/RA/SA/TA/TB chip versions For Prolific USB VID_067B&PID_2303 ...
Cupertino-Catalina.tar.xz、El_Capitan_CursorsMOD_1.1.0.zip、Gnome-OSC-HS--2-themes.tar.xz、grub_Vimix-1080p.tar.xz、Mojave-light.tar.xz
OS X 10.11 El Capitan VMware虚拟机镜像,下载大小8.4G+。解压密码是:xBytez。亲测可用(Win10 x64企业版 + VMWare 12.0 Pro)。
OS X-KVM:在KVM和QEMU之上运行Mac OS X El Capitan主机系统详细信息 Ubuntu 15.10 在 i5-6500 CPU 上运行。 Fedora 24 在 i5-6500 + i7-6600U CPU 上运行。 使用 QEMU 2.4.1 和 QEMU 2.5 进行测试。 已知 AMD CPU ...
Customizing OS X El Capitan Edition 英文epub 本资源转载自网络,如有侵权,请联系上传者或csdn删除 本资源转载自网络,如有侵权,请联系上传者或csdn删除
如何在OS X El Capitan中开启三指拖拽手势?.docx
EI X CAPITAN 鼠标指针 mac 版本,相当漂亮,本人无意间偶得,分享给大家。
苹果OS X El Capitan开启第三方SSD TRIM支持更简单!.docx
os x10.11el capitan beta2下载地址.docx