tried to install Oracle but DBCA aborted. I then tried
to open SQL*plus it showing this 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
3 - Set your LD_LIBRARY_PATH environmental variable
to include $ORACLE_HOME/lib and PATH should include
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
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
Oracle Training from Don Burleson
The best on site
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
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
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
Oracle technology is changing and we
strive to update our BC Oracle support information. If you find an error
or have a suggestion for improving our content, we would appreciate your
and include the URL for the page.
Copyright © 1996 - 2020
All rights reserved by
is the registered trademark of Oracle Corporation.