Oracle Error While Loading Shared Libraries Libsqlplus.so
communities company blog Stack Exchange Inbox Reputation and Badges sign up log in tour help Tour Start here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Ask Ubuntu Questions Tags Users Badges Unanswered Ask Question _ Ask Ubuntu is a question and answer site for Ubuntu users and developers. Join them; it only takes a minute: Sign up Here's how it works: Anybody can ask a question Anybody can answer The best answers are voted up and rise to the top sqlplus: error while loading shared libraries: libsqlplus.so: cannot open shared object file: No such file or directory up vote 7 down vote favorite echo $PATH gives me below result : /home/mayank/bin:/usr/lib/lightdm/lightdm:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/usr/games:/usr/lib/jvm/java-7-oracle/bin:/usr/lib/jvm/java-7-oracle/db/bin:/usr/lib/jvm/java-7-oracle/jre/bin:/usr/lib/oracle/12.1/client/bin echo $ORACLE_HOME fetches : /usr/lib/oracle/12.1/client echo LD_LIBRARY_PATH gives (set through /etc/bash.bashrc earlier, but now its showing as below) LD_LIBRARY_PATH doing vim for .bash_profile shows below things set : [[ -s "$HOME/.rvm/scripts/rvm" ]] && source "$HOME/.rvm/scripts/rvm" # Load RVM into a shell session *as a function* LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/usr/local/lib export LD_LIBRARY_PATH PATH=$PATH:/usr/local/bin export PATH Despite setting the ld_library_path in above file I'm still not getting the correct path in env despite running sudo ldconfig and then rebooting my machine!! what help I'm looking for : set env vars correctly run sqlplus Same question exists superuser, but no solution is given there. software-installation environment-variables oracle share|improve this question edited Feb 13 '14 at 17:10 Olli 5,09812439 asked Feb 13 '14 at 14:28 user246631 156228 and there is the libsqlplus.so file located? try to find it with "sudo updatedb && locate libsqlplus.so" - then please tell us if you found it! –mail-nv Feb 13 '14 at 14:37 @WolfgangVogl : hi...thankx for ur response, on executing ur command i got this : /usr/lib/oracle/12.1/client/lib/libsqlplus.so –user246631 Feb 13 '14 at 14:40 @WolfgangVogl : here is permission chekc result on so file => ls -l /usr/lib/oracle/12.1/client/lib/libsqlplus.so -
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 6.2 million programmers, just like you, helping http://askubuntu.com/questions/420395/sqlplus-error-while-loading-shared-libraries-libsqlplus-so-cannot-open-shared each other. Join them; it only takes a minute: Sign up sqlplus: error while loading shared libraries: libsqlplus.so: cannot open shared object file: No such file or directory up vote 1 down vote favorite 1 Please suggest a solution for solving this issue?? While giving the command sqlplus /nolog the error occurred is sqlplus: error while loading http://stackoverflow.com/questions/27717312/sqlplus-error-while-loading-shared-libraries-libsqlplus-so-cannot-open-shared shared libraries: libsqlplus.so: cannot open shared object file: No such file or directory.. linux oracle installation sqlplus oracleclient share|improve this question edited Dec 31 '14 at 8:37 Lalit Kumar B 27k82547 asked Dec 31 '14 at 6:46 Priyanka U 13115 How do you source your environment ? Show us. –tvCa Dec 31 '14 at 14:42 Check out this link for detailed steps with screenshot. –Aniket Thakur Sep 3 '15 at 18:47 add a comment| 7 Answers 7 active oldest votes up vote 2 down vote The minimum configuration to properly run sqlplus from the shell is to set ORACLE_HOME and LD_LIBRARY_PATH. For ease of use, you might want to set the PATH accordingly too. Assuming you have unzipped the required archives in /opt/oracle/instantclient_11_1: sh$ export ORACLE_HOME=/opt/oracle/instantclient_11_1 sh$ export LD_LIBRARY_PATH="$ORACLE_HOME" sh$ export PATH="$ORACLE_HOME:$PATH" sh$ sqlplus SQL*Plus: Release 11.1.0.7.0 - Production on Wed Dec 31 14:06:06 2014 ... share|improve this answer edited Jan 21 '15 at 14:52 answered Dec 31 '14 at 13:09 Sylvain Leroux 24.9k42957
I had to install SQL*Plus on a https://www.krenger.ch/blog/libsqlplus-so-cannot-open-shared-object-file-no-such-file-or-directory/ Linux host. In order to do so, http://www.dba-oracle.com/t_sqlplus_error_while_loading_shared_libraries.htm I downloaded the appropriate Oracle Instant Client packages from the Oracle site. For my installation, I chose the ZIP files. After I unzipped the client and tried to run sqlplus, I oracle error go the following error: simon@pandora instantclient_11_2$ ./sqlplus ./sqlplus: error while loading shared libraries: libsqlplus.so: cannot open shared object file: No such file or directory Hmm. When I checked the directory with the sqlplus binary, the file libsqlplus.so was oracle error while clearly there. To fix this error, you have to set the LD_LIBRARY_PATH environment variable to the folder where the "libsqlplus.so" file resides. So for example, if you put the Instant Client into /opt/oracle/instantclient_11_2, set the variable like this: simon@pandora:instantclient_11_2$ export LD_LIBRARY_PATH=/opt/oracle/instantclient_11_2 Then, your SQL*Plus client should work as expected: simon@pandora:instantclient_11_2$ ./sqlplus /nolog SQL*Plus: Release 11.2.0.4.0 Production on Thu May 8 15:05:20 2014 Copyright (c) 1982, 2013, Oracle. All rights reserved. SQL> Tags: installation, Instant Client, Linux, Oracle Database, SQL*Plus Comments Sorry, because of spam and legal reasons, comments are disabled. If you want to get in touch with me, please do so via e -mail: No comments. krenger.ch - rockin' since 2011
SQL TuningSecurityOracle UNIXOracle LinuxMonitoringRemote supportRemote plansRemote servicesApplication Server ApplicationsOracle FormsOracle PortalApp UpgradesSQL ServerOracle ConceptsSoftware SupportRemote Support Development Implementation Consulting StaffConsulting PricesHelp Wanted! Oracle PostersOracle Books Oracle Scripts Ion Excel-DB Don Burleson Blog
sqlplus: error while loading shared libraries tips Oracle Database Tips by Burleson Consulting April 26, 2015 Question: I tried to install Oracle but DBCA aborted. I then tried to open SQL*plus it showing this error: sqlplus: error while loading shared libraries: libclntsh.so.11.1: cannot open shared object file: No such file or directory How do I fix this sqlplus: error while loading shared libraries error? Answer: Your problem was that you did not carefully following the pre-install checklist. The installer will very rarely fail, if you follow the directions. Start by reviewing the installer logs and see why it aborted. 1 - See MOSC Note 1073332.1 titled "*/usr/bin/ld: Cannot Find -lxml11, Genclntsh: Failed To Link libclntsh.so.11.1" 2 - Modify your .bash profile to include the CLASSPATH variable 3 - Set your LD_LIBRARY_PATH environmental variable to include $ORACLE_HOME/lib and PATH should include $ORACLE_HOME/bin: export LD_LIBRARY_PATH=$ORACLE_HOME/lib export PATH = $PATH:$ORACLE_HOME/bin 4 - The "sqlplus: error while loading shared libraries" error can happen because DBCA failed during the link phase and a re-link will remedy this error: oracle> $ORACLE_HOME/bin/relink all If the above steps do not solve the problem, you may be better off to start-over and re-install the Oracle software. This time, DO NOT ignore errors and carefully follow the pre-installation checklist. Oracle Training from Don Burleson The best on site "Oracle training classes" are just a phone call away! You can get personalized Oracle training by Donald Burleson, right at your shop! Burleson is the American Team Note: This Oracle documentation was created as a support and Oracle training reference for use by our DBA performance tuning consulting professionals. Feel free to ask questions on our Oracle forum. Verify experience! Anyone considering using the services of an Oracle support expert should independently investigate their credentials and experience, and not rely on advertisements and self-proclaimed expertise. All legitimate Oracle experts publish their Oracle qualifications. Errata? Oracle technology is changing and we strive to update our BC Oracle support information.