Saturday, March 7, 2009

CSSCAN fails with error while loading shared libraries: libclntsh.so.10.1

Problem Description
While running csscan in order to check all character data in the database and tests for the effects and problems of changing the character set, it fails with error while loading shared libraries: libclntsh.so.10.1: cannot open shared object file as below.

[oracle@dbsoft ~]$ csscan sys/a as sysdba full=y tochar=WE8MSWIN1252 ARRAY=1024000 process=4
csscan: error while loading shared libraries: libclntsh.so.10.1: cannot open shared object file: No such file or directory

Cause and solution of the Problem
The problem happens due to missing entry of LD_LIBRARY_PATH environmental variable. Proper setting of the parameter will solve the problem. On my 32 bit Red hat linux system setting,
$export LD_LIBRARY_PATH=$ORACLE_HOME/lib
will solve the problem.
Details about this problem is discussed on,

http://arjudba.blogspot.com/2008/09/on-solaris-64-bit-rman-fails-with.html

No comments:

Post a Comment