Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Oracle11g: new install: sqlplus: 'error while loading shared libraries...' any ideas?

Posted on 2011-03-09
8
Medium Priority
?
896 Views
Last Modified: 2012-05-11
Hello Experts,

I just installed Oracle11g R2. Now, trying to connect via sqlplus to start instance of db. but I get error below, any ideas what the problem may be?

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

thanks for all of your help...

regards,
0
Comment
Question by:epifanio67
  • 4
  • 4
8 Comments
 
LVL 4

Expert Comment

by:Alex Matzinger
ID: 35089025
this may be a SELinux error if you are on Linux...try disabling it and see if that works.  If you aren't on linux...what operating system are you using?
0
 

Author Comment

by:epifanio67
ID: 35089448
thank you expert,

I just disable it; but still getting same results...
these are all variables set:
ORACLE_SID=orcl
ORACLE_BASE=/home/oracle/app/oracle
ORACLE_HOME=/oracle
TMPDIR=/oracle/tmp
TMP=/oracle/tmp
LD_LIBRARY_PATH=/oracle/bin:$PATH

any other ideas?

thanks so much....

regards,
0
 
LVL 4

Expert Comment

by:Alex Matzinger
ID: 35089481
Try running this command:(again if you already did it)

setenforce 0

Open in new window


and then typing
tnsping orcl

Open in new window


and post your results back here
0
Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

 

Author Comment

by:epifanio67
ID: 35089622
thank you experts,

same error:
./tnsping: error while loading shared libraries: /oracle/lib/libclntsh.so.11.1: cannot restore segment prot after reloc: Permission denied

odd... there was no issues with the install and/or creation of db
0
 
LVL 4

Expert Comment

by:Alex Matzinger
ID: 35089654
Ok, you need to log in as root and run this command

getenforce 

Open in new window


and post the results back here
0
 

Author Comment

by:epifanio67
ID: 35089688
thank you expert,

[root@oracle bin]# /usr/sbin/getenforce
Enforcing

don't understand... I update /etc/selinux/conf

0
 
LVL 4

Accepted Solution

by:
Alex Matzinger earned 2000 total points
ID: 35089708
ok, stay logged in as root(or re log in as root) and re run these two commands.
setenforce 0

getenforce
 

Open in new window


if getenforce reports Permissive or disabled at that time, then try logging into SQL plus again.  If gentforce still reports enforcing then post back here with your exact version of linux.
0
 

Author Closing Comment

by:epifanio67
ID: 35089787
thank you experts so much...
0

Featured Post

[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

How to Create User-Defined Aggregates in Oracle Before we begin creating these things, what are user-defined aggregates?  They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…
Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…
Suggested Courses

972 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question