1.保证与oracle服务器版本统一
2.python3 ,oracle服务器,oracle client统一使用64位或者32位
2.先解压缩instantclient-basic-linux.x64-11.2.0.4.0.zip,后解压缩instantclient-sdk-linux.x64-11.2.0.4.0.zip
3.进入目录instantclient_11_2,创建软链接
ln -s libclntsh.so.11.1 libclntsh.so
4.在刚刚解压得到的instantclient_11_2文件夹下新建network/admin
5.在刚刚创建的目录下创建network/admin创建文件tnsnames.ora,模板如下(SERVICE_NAME请填写服务器SID)
ORCL =(DESCRIPTION=(ADDRESS= (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
(CONNECT_DATA=(SERVER=DEDICATED)
(SERVICE_NAME=orcl)
)
)
6.修改环境变量(自行更改oracle client解压的路径)
vim /etc/profile
export ORACLE_HOME=/usr/local/instantclient_11_2
export LD_LIBRARY_PATH=$ORACLE_HOME:$LD_LIBRARY_PATH
export NLS_LANG=‘AMERICAN_AMERICA.AL32UTF8‘export TNS_ADMIN=$ORACLE_HOME/network/admin