csscan: error while loading shared libraries: .11.1: cannot open shared object file: No

时间:2025-04-22 08:33:27
需要转换数据库的字符集,使用csscan检查,但是csscan总是无法启动,出现如下问题:


[oracle@RHELDB admin]$ csscan help=y

csscan: error while loading shared libraries: .11.1: cannot open shared object file: No such file or directory

度娘后,发现如下贴子:/red10057/article/details/8202255,按照此贴中的步骤,解决了该问题


检查which sysresv依赖关系
[oracle@RHELDB admin]$ ldd `which sysresv`
        .1 =>  (0x00007fff42291000)
        .11.1 => /app/u01/oracle/lib/.11.1 (0x00002b6a95b97000)
        => /app/u01/oracle/lib/ (0x00002b6a981c1000)
        .2 => /lib64/.2 (0x0000003f5ec00000)
        .6 => /lib64/.6 (0x0000003f5f000000)
        .0 => /lib64/.0 (0x0000003f5f400000)
        .1 => /lib64/.1 (0x0000003f62800000)
        .6 => /lib64/.6 (0x0000003f5e800000)
        .1 => /usr/lib64/.1 (0x00002b6a9859e000)
        /lib64/.2 (0x0000003f5e400000)

进入$ORACLE_HOME/lib文件夹,检查libclntsh是否存在

[oracle@RHELDB bin]$ cd $ORACLE_HOME/lib

[oracle@RHELDB lib]$ ll |grep libclntsh
lrwxrwxrwx 1 oracle oinstall        37 Aug 24 11:11 -> /app/u01/oracle/lib/.11.1
lrwxrwxrwx 1 oracle oinstall        32 Aug 24 11:09 .10.1 -> /app/u01/oracle/lib/
-rwxr-xr-x 1 oracle oinstall  48724657 Aug 24 11:11 .11.1
[oracle@RHELDB lib]$ pwd
/app/u01/oracle/lib

以root用户修改/etc/添加$ORACLE_HOME/lib路径

[root@RHELDB tmp]# vi /etc/,文件内容如下:

include /*.conf
/app/u01/oracle/lib #注:这里只能写绝对路径,不能写$ORACLE_HOME/lib
~                      

[root@RHELDB tmp]# ldconfig
ldconfig: File /app/u01/oracle/lib/.0 is empty, not checked.
好多内容,略。。。。。。
ldconfig: /app/u01/oracle/lib/.1 is not a symbolic link
[root@RHELDB tmp]# su - oracle

[oracle@RHELDB oracle]$ csscan help=y
Character Set Scanner v2.2 : Release 11.2.0.1.0 - Production on Sat Aug 30 19:35:18 2014
Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
You can let Scanner prompt you for parameters by entering the CSSCAN        
command followed by your username/password:                                                                                                           
  Example: CSSCAN \"SYSTEM/MANAGER AS SYSDBA\"                                                                                                  
Or, you can control how Scanner runs by entering the CSSCAN command         
followed by various parameters. To specify parameters, you use keywords:                                                                            
  Example:                                                                  
    CSSCAN \"SYSTEM/MANAGER AS SYSDBA\" FULL=y TOCHAR=utf8 ARRAY=1024000 PROCESS=3  

其他内容。。。。。。。。

另外,还有一贴子,也能解决该问题,但未验证,链接如下:

/4227/viewspace-706711/