Linux下安装oracleclient

Linux下安装oracleclient

参考https://www.cnblogs.com/txinmas/p/12748273.html

上传安装文件

oracle-instantclient18.5-basic-18.5.0.0.0-3.x86_64.rpm

oracle-instantclient18.5-sqlplus-18.5.0.0.0-3.x86_64.rpm

以上文件放在/home/oracle

安装oracle客户端

/home/oracle

sudo rpm -ivh oracle-instantclient18.5-basic-18.5.0.0.0-3.x86_64.rpm sudo rpm -ivh oracle-instantclient18.5-sqlplus-18.5.0.0.0-3.x86_64.rpm

若使用yum安装（未搜索到）

yum install oracle-instantclient18.5-basic.x86_64

yum install oracle-instantclient18.5-sqlplus.x86_64

 

创建文件夹network/admin

cd /usr/lib/oracle/18.5/client64

mkdir –p network/admin

vi tnsnames.ora

DRG=

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP)(HOST = 10.1.93.225)(PORT = 1521))

)

(CONNECT_DATA =

(SERVICE_NAME = orcl)

)

)

配置oracle环境变量

vi /etc/profile

export ORACLE_HOME=/usr/lib/oracle/18.5/client64

export TNS_ADMIN=$ORACLE_HOME/network/admin

##export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK

export NLS_LANG=AMERICAN_AMERICA.AL32UTF8

export LD_LIBRARY_PATH=/usr/lib/oracle/18.5/client64/lib

export PATH=$ORACLE_HOME:$PATH

 

错误信息libclntsh.so没有找到

vi /etc/ld.so.conf

#末尾追加

/usr/lib/oracle/18.5/client64/lib #根据你安装oracle版本驱动路径

生效新环境变量，输入下列命令

source /etc/profile

若还是找不到so文件创建链接

cd /usr/lib/oracle/18.5/client64/lib

ln -s libclntsh.so.18.1 libclntsh.so