linux Oracle Instant Client

On By 去哪儿

1、下载客户端

https://cx-oracle.readthedocs.io/en/latest/user_guide/installation.html

2、解压安装包

mkdir -p /opt/oracle
cd /opt/oracle
unzip instantclient-basic-linux.x64-21.1.0.0.0.zip

3、安装libaio

sudo yum install libaio

4、添加运行路径

sudo sh -c "echo /opt/oracle/instantclient_21_1 > /etc/ld.so.conf.d/oracle-instantclient.conf"
sudo ldconfig
或将环境变量配置为如下
export LD_LIBRARY_PATH=/opt/oracle/instantclient_21_1:$LD_LIBRARY_PATH
export TNS_ADMIN=/opt/oracle/product/19c/dbhome_1/network/admin/listener.ora

RPM包安装方式

sudo yum install libaio
rpm -ivh oracle-instantclient-basic-21.11.0.0.0-1.el8.x86_64.rpm 
sudo sh -c "echo /usr/lib/oracle/18.5/client64/lib > /etc/ld.so.conf.d/oracle-instantclient.conf"
sudo ldconfig
export LD_LIBRARY_PATH=/usr/lib/oracle/18.5/client64/lib:$LD_LIBRARY_PATH
export TNS_ADMIN=/home/app/19c/grid/network/admin
export TNS_ADMIN=/home/app/19c/grid/network/admin/listener.ora

如果在使用过程中出现

sqlalchemy.exc.DatabaseError: (cx_Oracle.DatabaseError) DPI-1047: Cannot locate a 64-bit Oracle Client library: "libclntsh.so: cannot open shared object file: No such file or directory".

1、如是新安装的系统则执行安装客户端

https://www.oracle.com/database/technologies/instant-client/linux-x86-64-downloads.html

rpm -ivh oracle-instantclient19.20-basic-19.20.0.0.0-1.x86_64.rpm

2、如是采用脚本安装客户端的则执行，/opt/oracle/instantclient_21_1替换为自己的路径名称

sudo sh -c "echo /opt/oracle/instantclient_21_1 > /etc/ld.so.conf.d/oracle-instantclient.conf"
sudo ldconfig