Sqlplus libclntsh. so.11.1 permission denied Solution

Source: Internet
Author: User

Or disable SELinux.

Setenforce 0

[Root @ BT bin] #./sqlplus

./Sqlplus: Error while loading shared libraries:/home/mnum/APP/mnum/product/11.2.0/dbhome_1/lib/libclntsh. so.11.1: cannot restore segment prot after reloc: Permission denied

Solve the Problem of libclntsh. So first:

[Root @ BT bin] # semanage fcontext-a-t textrel_shlib_t/home/mnum/APP/mnum/product/11.2.0/dbhome_1/lib/libclntsh. so.11.1

Csvn homedir/opt/collabnet_subversion or its parent directory conflicts with a defined context in/etc/SELinux/targeted/contexts/files/file_contexts, /usr/sbin/genhomedircon will not create a new context. this usually indicates an incorrectly defined system account. if it is a system account please make sure its login shell is/sbin/nologin.

[Root @ BT bin] # restorecon-r-V/home/mnum/APP/mnum/product/11.2.0/dbhome_1/lib/libclntsh. so.11.1

Restorecon reset/home/mnum/APP/mnum/product/11.2.0/dbhome_1/lib/libclntsh. so.11.1 context user_u: object_r: user_home_t: S0-> system_u: object_r: Weight: S0

[Root @ BT bin] #./sqlplus

Error 6 initializing SQL * Plus

SP2-0667: Message file sp1.msb not found

SP2-0750: you may need to set ORACLE_HOME to your Oracle Software Directory

To solve the problem above, add the environment variable:

[Root @ BT bin] # vi/etc/profile

ORACLE_HOME =/home/mnum/APP/mnum/product/11.2.0/dbhome_1

Oracle_sid = orcl

Path =: $ ORACLE_HOME/bin

[Root @ BT bin] # source/etc/profile (make the variable take effect)

[Root @ bt ~] # Sqlplus

SQL * Plus: Release 11.2.0.1.0 production on Fri Jul 16 13:34:08 2010

Copyright (c) 1982,200 9, Oracle. All rights reserved.

Enter user-Name: System
Enter password:
Error:
ORA-12546: TNS: Permission denied

To specify the username/password @ Sid:

[Root @ bt ~] # Sqlplus system/oracle11 @ orcl

SQL * Plus: Release 11.2.0.1.0 production on Fri Jul 16 13:35:29 2010

Copyright (c) 1982,200 9, Oracle. All rights reserved.

Connected:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0-64bit Production
With the partitioning, OLAP, data mining and real application testing options

SQL>

OK !!

[Supplement]

Connect sqlplus to a remote database

[Root @ bt ~] # Sqlplus system/oracle11 @ IP: Port/orcl

 

This article from the csdn blog, reproduced please indicate the source: http://blog.csdn.net/chxd99/archive/2010/07/16/5739543.aspx

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.