问题现象: 在服务器上安装oracle-instantclient11.2后,结果使用sqlplus命令时遇到“sqlplus: error while loading shared libraries: libnsl.so.1: cannot open shared object file: No such file or directory“错误
问题排查: - #安装oracle客户端
- rpm -ivh oracle-instantclient11.2-basic-11.2.0.4.0-1.x86_64.rpm
- rpm -ivh oracle-instantclient11.2-devel-11.2.0.4.0-1.x86_64.rpm
- rpm -ivh oracle-instantclient11.2-sqlplus-11.2.0.4.0-1.x86_64.rpm
复制代码
配置环境变量 - # vi /etc/profile 增加下面配置
- export ORACLE_HOME=/usr/lib/oracle/11.2/client64
- export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH
- export PATH=$PATH:$ORACLE_HOME/bin
复制代码执行sqlplus报错 - ./sqlplus
- sqlplus: error while loading shared libraries: libnsl.so.1: cannot open shared object file: No such file or directory
复制代码
根据下面命令判断依赖的libnsl包没有安装,安装依赖包,可以正常登录 - # yum list installed | grep libnsl
- # yum list | grep libnsl
- libnsl2.x86_64 1.2.0-2.20180605git4a062cf.el8 @anaconda
- libnsl.i686 2.28-101.el8 BaseOS
- libnsl.x86_64 2.28-101.el8 BaseOS
- libnsl2.i686 1.2.0-2.20180605git4a062cf.el8 BaseOS
- # yum install libnsl.x86_64
复制代码
问题原因: 缺少libnsl依赖包,安装依赖包即可。
|