sqlplus: error while loading shared libraries未公布的b
今天远程帮助同事安装数据库11gR2，软件安装完毕后sqlplus 等命令调用不了 [oracle@oracle1 ~]$ sqlplus /nolog sqlplus: error while loading shared libraries: /opt/oracle/app/oracle/product/11.2.0/dbhome_1/lib/libclntsh.so.11.1: cannot restore se
今天远程帮助同事安装数据库11gR2，软件安装完毕后sqlplus 等命令调用不了<br>
[oracle@oracle1 ~]$ sqlplus /nolog<br>
sqlplus: error while loading shared libraries: /opt/oracle/app/oracle/product/11.2.0/dbhome_1/lib/libclntsh.so.11.1: cannot restore segment prot after reloc: Permission denied
这个错误看起来好像和linux的LD_LIBRARY_PATH相关
Export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib
指定LD_LIBRARY_PATH后还是报错，找到mos上有篇文章
./sqlplus: error on libnnz11.so: cannot restore segment prot after reloc (文档 ID 454196.1)
Changes：
ELinux is running in "enforcing" mode.
You are encountering unpublished
Bug 6140224 SQLPLUS FAILS TO LOAD LIBNNZ11.SO WITH SELINUX ENABLED ON EL5/RHEL5
Oracle Developement is actively working on this compiler version compatibility issue (ICC compilers that are used for several libraries, such as LIBNNZ10.SO and LIBNNZ11.SO) in the RHEL 5 and OEL 5 environments.
and is included within RHEL5.5
Oracle's resolution to this for 11.2.0.1 (both x86 and x86_64 ) is patch 9215184
Oracle's resolution to this is included within 11.2.0.2
这个是启用selinux的原因，我们只要关闭掉selinux即可，刚好os版本是linux 5.5的，这个bug在11.2.0.2已经得到了解决，而小鱼安装的正是11.2.0.1版本
相应的办法是我们直接禁掉selinux即可
[root@ oracle1 ~]# /usr/sbin/setenforce 0
修改/etc/sysconfig/selinux
[root @ oracle1 ~]$ less /etc/sysconfig/selinux
# 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=enforcing -- 修改enforcing为disabled
# SELINUXTYPE= type of policy in use. Possible values are:
# targeted - Only targeted network daemons are protected.
# strict - Full SELinux protection.
SELINUXTYPE=targeted
再次sqlplus使用已经正常。
原文地址：sqlplus: error while loading shared libraries未公布的b, 感谢原作者分享。
Hot AI Tools
Undresser.AI Undress
AI-powered app for creating realistic nude photos
AI Clothes Remover
Online AI tool for removing clothes from photos.
Undress AI Tool
Undress images for free
Clothoff.io
AI clothes remover
AI Hentai Generator
Generate AI Hentai for free.
Hot Article
Hot Tools
Notepad++7.3.1
Easy-to-use and free code editor
SublimeText3 Chinese version
Chinese version, very easy to use
Zend Studio 13.0.1
Powerful PHP integrated development environment
Dreamweaver CS6
Visual web development tools
SublimeText3 Mac version
God-level code editing software (SublimeText3)
Hot Topics
1385
52
Solution to PHP Fatal error: Call to undefined method PDO::prepare() in
Jun 22, 2023 pm 06:40 PM
PHP is a popular web development language that has been used for a long time. The PDO (PHP Data Object) class integrated in PHP is a common way for us to interact with the database during the development of web applications. However, a problem that some PHP developers often encounter is that when using the PDO class to interact with the database, they receive an error like this: PHPFatalerror:CalltoundefinedmethodPDO::prep
How to connect sqlplus to database
Nov 15, 2023 pm 05:50 PM
How to connect sqlplus to the database: 1. Open a terminal or command line window and enter the "sqlplus" command to start SQL*Plus; 2. If the Oracle database is not on the local host, you also need to specify the connection information of the database; 3. Press the Enter key After executing the command, SQL*Plus will prompt for a password. Enter the correct password and press Enter; 4. If the username and password are verified successfully, SQLPlus will successfully connect to the database and display the SQLPlus command prompt.
In C language, what is the difference between while(1) and while(0)?
Aug 31, 2023 am 10:45 AM
We know that in C language, 'while' keyword is used to define a loop that works based on the condition passed to the loop. Now, since the condition can have two values, true or false, the code inside the while block will be executed repeatedly if the condition is true and will not be executed if the condition is false. Now, by passing parameters to the while loop, we can differentiate between while(1) and while(0) because while(1) is a loop where the condition is always considered true and hence the code inside the block will start executing repeatedly. Furthermore, we can state that it is not 1 that is passed to the loop that makes the condition true, but if any non-zero integer is passed to the while loop, then it will be considered as the true condition, so
What should I do if 'Uncaught (in promise) Error: Request failed with status code 500' occurs when using axios in a Vue application?
Jun 24, 2023 pm 05:33 PM
It is very common to use axios in Vue applications. axios is a Promise-based HTTP client that can be used in browsers and Node.js. During the development process, the error message "Uncaught(inpromise)Error: Requestfailedwithstatuscode500" sometimes appears. For developers, this error message may be difficult to understand and solve. This article will explore this
Solve the problem of 'error: incomplete type is not allowed' in C++ code
Aug 26, 2023 pm 08:54 PM
Solve the "error:incompletetypeisnotallowed" problem in C++ code. During the C++ programming process, you sometimes encounter some compilation errors. One of the common errors is "error:incompletetypeisnotallowed". This error is usually caused by operating on an incomplete type. This article will explain the cause of this error and provide several solutions. firstly, I
Solve the 'error: expected initializer before 'datatype'' problem in C++ code
Aug 25, 2023 pm 01:24 PM
Solve the "error:expectedinitializerbefore'datatype'" problem in C++ code. In C++ programming, sometimes we encounter some compilation errors when writing code. One of the common errors is "error:expectedinitializerbefore'datatype'". This error usually occurs in a variable declaration or function definition and may cause the program to fail to compile correctly or
0271: What should I do if the computer cannot be turned on due to real time clock error?
Mar 13, 2023 am 11:30 AM
Solution to "0271: real time clock error" that cannot boot: 1. Press F1, and in the interface that appears, move the option bar to the third item "Date/Time"; 2. Manually change the system time to the current one time; 3. Press F10 and select yes in the pop-up dialog box; 4. Re-open the notebook to boot normally.
How to solve PHP Warning: fopen(): failed to open stream: No such file or directory
Aug 19, 2023 am 10:44 AM
How to solve PHPWarning:fopen():failedtoopenstream:Nosuchfileordirectory In the process of using PHP development, we often encounter some file operation problems, one of which is "PHPWarning:fopen():failedtoopenstream:Nosuchfileordirectory"
