[分享] Ubuntu 16 上安裝 cx_Oracle for Python3消失
因想嘗試在Linux上用Python解決一些工作上的問題，首先卻遇上
存取資料庫的問題，稍微筆記分享一下以 pip 安裝 cx_Oracle 的
步驟。
參考：
https://help.ubuntu.com/community/Oracle%20Instant%20Client
至Oracle官網下載、安裝以下套件
Instant Client Package - Basic:
oracle-instantclient12.2-basic-12.2.0.1.0-1.x86_64.rpm
與 Instant Client Package - SDK:
oracle-instantclient12.2-devel-12.2.0.1.0-1.x86_64.rpm
以及SQLPlus:
alien -i oracle-instantclient12.1-sqlplus-12.1.0.2.0-1.x86_64.rpm
根據，Ubuntu社群上之建議，以 alien 安裝:
alien -i oracle-instantclient12.1-basic-12.1.0.2.0-1.x86_64.rpm
alien -i oracle-instantclient12.1-sqlplus-12.1.0.2.0-1.x86_64.rpm
alien -i oracle-instantclient12.1-devel-12.1.0.2.0-1.x86_64.rpm
設定 ORACLE_HOME 等：
export ORACLE_HOME=/usr/lib/oracle/12.2/client64
export LD_LIBRARY_PATH=/usr/lib/oracle/12.2/client64/lib
export TNS_ADMIN=/usr/lib/oracle/12.2/client64/network/admin
export PATH=$PATH:$ORACLE_HOME/bin
執行：
cd /usr/lib/oracle/12.2/client64/lib/
ln -s libclntsh.so.12.1 libclntsh.so
ln -s libocci.so.12.1 libocci.so
sudo ldconfig
然後
pip3 install cx_Oracle;
確認:
# python3
Python 3.5.2 (default, Nov 17 2016, 17:05:23)
[GCC 5.4.0 20160609] on linux
Type "help", "copyright", "credits" or "license" for more information.
>>> import cx_Oracle
>>> quit
--
※ 發信站: 批踢踢實業坊(ptt.cc), 來自: 122.147.255.215
※ 文章網址: https://www.ptt.cc/bbs/Linux/M.1489374844.A.DDF.html
推
03/13 22:45, , 1F
03/13 22:45, 1F
※ 編輯: jack56 (36.231.53.40), 03/30/2017 16:22:02