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

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'; ·          select * from fnd_concurrent_queues where control_code='N'; ·          update fnd_concurrent_queues set control_code=null where control_code='N'; ·          update fnd_concurrent_queues set node_name=null,node_name2=null where concur
Read more

FRM-92101: Forms Server Not Starting Up

-
Forms Server Not Starting Up / Forms Server Start Up Issue Applies to:             Oracle Enterprise Linux – Version: 5             Oracle EBS R12 Description:             After cloning EBS R12 successfully on a new server machine, when I am going to access any form on EBS clone it did not open the page and show the following error: FRM-92101: Forms Server Java Exception: oracle.forms.net.ConnectionException: Forms session <1> failed during startup: no response from runtime process at oracle.forms.net.ConnectionException.createConnectionException(Unknown Source) at oracle.forms.net.HTTPNStream.getResponse(Unknown Source) I have restarted all the services of application and database but the problem is same. I have also restarted the whole machine/server but still the same issue. Cause and Solution: I found the following error: In $LOG_HOME/ora/10.1.3/j2ee/<oacore>/<oacore>_<default_group_1>/application.log $LOG_HOME/ora/1
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 ‘/u01/oracle/oradata/undotbs02.dbf’ size=1G; 3-       Alter system set undo_tablespace = UNDOTBS2; 4-       Shutdown immediate 5-       startup 6-       Drop tablespace UNDOTBS1 including contents and datafiles; Database is working fine now.
Read more