This content has been marked as final. Show 17 replies
This means the file is corrupted. you have to reinstall. i have experienced this error once and the source of the corruption could be the file which you used for installation.
thank you for your reply, but i think i remember that oracle is suppose to check if you passed its prereqs prior to installation of the software, and my installation encountered no problem/s.
Please check you are connecting to the correct OS user who has the privilege/permissions on the directory (Oracle Home).
Issue 'ldd sqlplus' to see the shared library dependencies, libclntsh.so.11.1 is an Oracle,but not a system library. So the pre-check does not apply here.
It seems like you missed to install one or more library files (glib+) at O/S level.
Check if SELinux is running - if so change it to permissive and try.
Edited by: user11925761 on Nov 5, 2009 7:45 AM
the problem seems to be in the .bash_profile, when i included the classpath in the .bash_profile the problem of connecting sqlplus became solved. Thanks for your reply guys.
Regards to all
I was having a similar error: ld.so.1: sqlplus: fatal: libclntsh.so.11.1: open failed: No such file or directory
I racked my brain about it a bit, but the solution was simple. ...Before you go reinstalling Oracle or thinking about corruption, just be sure that your environment variable $LD_LIBRARY_PATH is set correctly.
In this case, the server had both 10g and 11g installs, and though . oraenv would correctly set the $ORACLE_HOME and $ORACLE_SID for our 11g databases, the $LD_LIBRARY_PATH was still set to look at only the 10g binaries.
SO- the BEST practice is probably to set the $LD_LIBRARY_PATH as +"$ORACLE_HOME/lib"+, and then just re-load your profile when you need to change it.
Obviously, this can be easily accomplished by putting the setting in the Oracle user's .profile, .bash_profile, or system environment variables, depending on what flavor of OS you are tasting.
SO- the BEST practice is to set the $LD_LIBRARY_PATH as "$ORACLE_HOME/bin".WRONG!
better/actual solution is below
This file is corrupted.
I resolved this issue after copy the main file from Oracle Server to my Client machine.
This helped me. Thanks.
you go to root accout
$su - root
and you typing this on
$sqlplus / as sysdba
and you will use the sqlplus
"I've just installed 10g ver 10.2.0.1 and patch it to 10.2.0.4 in RHEL5 and created a DB, everything's fine in the installation when trying to connect to the DB using sqlplus an error appear in the CLI.
here is the error:
sqlplus: error while loading shared libraries: libclntsh.so.11.1"
now why would a patch in a 10.2 environment require a release 11 client library for sqlplus?
because you are doing it from a mixed (which means wrong) Oracle environment context.
as suggested, it may be your LD_LIBRRY_PATH. or your PATH.
"This means the file is corrupted."
The facts provided do not lead to this conclusion.