如何使用Oracle提供的字符扫描工具csscan

[oracle@localhost ~]$ csscan system/oracle full=y tochar=GBK

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

查找缺少的shared libraries

[oracle@localhost ~]$ locate libclntsh.so.10.1
/opt/ora10g/product/10201/lib/libclntsh.so.10.1

[oracle@localhost ~]$cat /etc/ld.so.conf

include ld.so.conf.d/*.conf

发现/etc/ld.so.conf读的都是/etc/ld.so.conf目录下的文件

[oracle@localhost ~]$cd  /etc/ld.so.conf.d/

[oracle@localhost ~]$touch  /etc/ld.so.conf.d/oracle10.2.0.conf

在新建的oracle10.2.0.conf输入获取的路径

/opt/ora10g/product/10201/lib

[oracle@localhost ~]$ csscan system/oracle full=y tochar=GBK

Character Set Scanner v2.1 : Release 10.2.0.0.0 - Production on Tue Jan 1 14:12:25 2013

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
CSS-00107: Character set migration utility schema not installed

Scanner terminated unsuccessfully.

上面的红字说字符集迁移功能的schema没有安装。需要执行一个脚本

[oracle@localhost ~]$ cd $ORACLE_HOME/rdbms/admin

[oracle@localhost ~]$ sqlplus / as sysdba

SQL> @csminst.sql