sqlplus: error while loading shared libraries: libclntsh.so.11.1

-

sqlplus: error while loading shared libraries: cannot restore segment prot after reloc: Permission denied

Applies to:

Oracle Enterprise Linux 5.5
Database 11gR1

Description:

I am using Oracle Enterprise Linux 5.5 and install Oracle Database 11gR1. After successfull installation of OS and Database when I try to login database it give me the following error:


sqlplus / as sysdba
sqlplus: error while loading shared libraries: /d01/app/oracle/product/11.2.0/dbhome_1/lib/libclntsh.so.11.1: cannot restore segment port after reloc: Permission denied



Solution:

Reason of the above error because of SELinux is running in ENFORCING mode, Oracle development has recommended the following workaround while they correct the problem. To check the mode execute the following command from root user:


root> getenforce
Enforcing

Switch SELinux from the default “Enforcing” mode that it is running in, to the “Permissive” mode.

root> setenforce 0

Now check again:

root> getenforce
Permissive

This allows SELinux to continue running, and logging denial messages, but SELinux will not actually deny any operations. Once Development has resolved this issue, you can (and should) return SELinux to the default “Enforcing” mode

Now successfully connect to SQL:

 sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Tue Oct 30 11:56:08 2012

Copyright (c) 1982, 2009, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> startup;
ORACLE instance started.

Total System Global Area 4275781632 bytes
Fixed Size                  2220200 bytes
Variable Size            1728057176 bytes
Database Buffers         2533359616 bytes
Redo Buffers               12144640 bytes
Database mounted.
Database opened.
SQL> 


Your comments, especially which will help us improve the functionality, will be greatly appreciated :)

Comments

  1. AhmedFebruary 15, 2013 at 12:03:00 PM GMT+5

    Thanks for sharing useful information. I've a question, does Oracle normally recommends to disable SELinux, I read it somewhere and did so on my server.

    ReplyDelete
    Replies
    1. Rana Abdul WahidFebruary 15, 2013 at 2:43:00 PM GMT+5

      Hello Ahmed,

      Kindly view Metalink Doc ID 454196.1, which provide workaround to fix it immediately or apply a patch.

      Thanks

      Delete
  2. UnknownFebruary 15, 2013 at 10:55:00 PM GMT+5

    Thanks for sharing.

    ReplyDelete
  3. UnknownFebruary 18, 2013 at 12:24:00 PM GMT+5

    There are four shared libraries in the distribution , have to compile using Intel ICC compiler ,and those libraries perform relocation
    so Oracle recommended SELINUX should be disable .
    you can find these libraries by setting SELINUX to "permissive" which will log errors but allow actions SELINUX would otherwise deny.Now use audit2allow command or leave
    leave SELINUX in "enforcing" mode use SELINUX troubleshooter to determine each error and troubleshooting report to fix.
    www.tcpak.com

    ReplyDelete

Post a Comment

Popular posts from this blog

REP-0501 ORA-01017 unable to connect to the specified database

-
REP-0501 ORA-01017 unable to connect to the specified database Applies to:             Enterprise Linux Version 5.7             Database 11gR2             Oracle Forms/Reports 6i Description:             We have an in-house developed application on Oracle Form/Reports 6i with Oracle Database 9.2 32bit on Windows Server 2008 32bit. Application is working fine. I have assigned a task from my manager to upgrade the database and also migrate the database server on Linux. I have done all the activities successfully. After that, Application is working fine except reports. When I run any report from application the report engine log give me the following error: REP-0501: Unable to connect to the specified database. ORA-01017: invalid username/password...
Read more

How to Rebuild/Recreate Concurrent Manager

-
How to Rebuild/Recreate Concurrent Manager Applies to:             Oracle Applications – Version: 11.5.10.2 and above Description:             After cloning, concurrent manager unable to start successfully at 0 status. Solution:             Check the following solution on test environment before implement on production environment, rebuild concurrent manager using following steps: ·          Stop concurrent manager and wait to clear all processes of FNDLIBR or kill the processes ·          select * from fnd_concurrent_processes where process_status_code='A'; ·          update fnd_concurrent_processes set process_status_code='K' where process_status_code='A'; ·  ...
Read more

ORA-10564 Tablespace UNDOTBS1 ORA-01110 ORA-10560

-
ORA-10564 Tablespace UNDOTBS1 ORA-01110 ORA-10560 Applies to:             Oracle Enterprise Linux – Version: 7             Oracle EBS R12 Description:             After abnormal shutdown of server we face the problem “ORA-10564 Tablespace UNDOTBS1 ORA-01110 data file 7 UNDOTBS01.DBF ORA-10560 block type KTU UNDO BLOCK”. I have restarted all the services of database but the problem is same. I have also restarted the whole machine/server but still the same issue. Solution:             After some research I found that recreate the undo tablespace to resolve the issue. Following the steps to resolve the above issue: 1-       Connect / as sysdba 2-       Create undo tablespace UNDOTBS2 datafile...
Read more