报错"sqlplus: error while loading shared libraries"

最新推荐文章于 2023-09-28 14:51:34 发布

原创最新推荐文章于 2023-09-28 14:51:34 发布 · 1.2k 阅读

0 ·

CC 4.0 BY-SA版权

ORACLE 专栏收录该内容

113 篇文章

订阅专栏

本文详细介绍了在Linux环境下安装Oracle 11g数据库后，使用SQLPLUS命令时遇到error while loading shared libraries错误的排查和解决过程。通过检查和调整SELinux策略，成功解决了该问题。

报错"sqlplus: error while loading shared libraries"

环境平台： linux as 5.5 + oracle 11g R2
故障描述：
一个11g的bug，在安装完数据库后，能正常创建库以及监听。但在启动sqlplus命令，会发现下面的错误：

[oracle@SANYFCBS ~]$ sqlplus "/as sysdba";
sqlplus: error while loading shared libraries: /opt/ora11/product/11.1/lib/libclntsh.so.11.1: cannot restore segment prot after reloc: Permission denied

解决方法：

检查:

[root@SANYFCBS selinux]#getenforce
Enforcing

1. [root@SANYFCBS selinux]#  /usr/sbin/setenforce 0


2. [root@SANYFCBS selinux]# cd /etc/selinux
   [root@SANYFCBS selinux]# vi  config

# This file controls the state of SELinux on the system.
# SELINUX= can take one of these three values:
#       enforcing - SELinux security policy is enforced.
#       permissive - SELinux prints warnings instead of enforcing.
#       disabled - SELinux is fully disabled.
SELINUX=disabled
# SELINUXTYPE= type of policy in use. Possible values are:
#       targeted - Only targeted network daemons are protected.
#       strict - Full SELinux protection.
SELINUXTYPE=targeted
~[/td][/tr][/table]