\u5728\u4e00\u4e2a11.2.0.2 for Linux X86-64\u73af\u5883\u4e2d\uff0c\u8fd0\u884ccsscan\u5de5\u5177\u62a5\u9519\u3002
\n\u9519\u8bef\u4fe1\u606f\u4e3a\uff1a<\/p>\n
[oracle@dbserver2 ~]$ cd $ORACLE_HOME\/bin\r\n[oracle@dbserver2 bin]$ csscan help=y\r\ncsscan: error while loading shared libraries: libclntsh.so.11.1: cannot open shared object file: No such file or directory<\/pre>\n\u68c0\u67e5metalink\uff0c\u5728\u6587\u6863ID 742070.1\u4e2d\u63d0\u5230\uff0c\u5bfc\u81f4\u8fd9\u4e2a\u95ee\u9898\u7684\u539f\u56e0\u662f\u6ca1\u6709\u6b63\u786e\u7684\u8bbe\u7f6eLD_LIBRARY_PATH\u73af\u5883\u53d8\u91cf\uff0c\u5c06$ORACLE_HOME\/lib\u6dfb\u52a0\u5230\u8fd9\u4e2a\u73af\u5883\u53d8\u91cf\u4e2d\u53ef\u4ee5\u907f\u514d\u9519\u8bef\u7684\u4ea7\u751f\uff1a<\/p>\n
[oracle@dbserver2 bin]$ env|grep LD_LIB\r\nLD_LIBRARY_PATH=\/etc\/emc\/rsa\/cst\/lib\r\n[oracle@dbserver2 bin]$ export LD_LIBRARY_PATH=$ORACLE_HOME\/lib:$LD_LIBRARY_PATH\r\n[oracle@dbserver2 bin]$ csscan help=y\r\nCharacter Set Scanner v2.2 : Release 11.2.0.2.0 - Production on Mon Jun 6 17:46:04 2011\r\nCopyright (c) 1982, 2009, Oracle and\/or its affiliates. All rights reserved.\r\nYou can let Scanner prompt you for parameters by entering the CSSCAN \r\ncommand followed by your username\/password: \r\n Example: CSSCAN \\\"SYSTEM\/MANAGER AS SYSDBA\\\" \r\nOr, you can control how Scanner runs by entering the CSSCAN command \r\nfollowed by various parameters. To specify parameters, you use keywords: \r\n Example: \r\n CSSCAN \\\"SYSTEM\/MANAGER AS SYSDBA\\\" FULL=y TOCHAR=utf8 ARRAY=1024000 PROCESS=3 \r\nKeyword Default Prompt Description \r\n---------- ------- ------ ------------------------------------------------- \r\nUSERID yes username\/password \r\nFULL N yes scan entire database \r\nUSER yes owner of tables to be scanned \r\nTABLE yes list of tables to scan \r\nCOLUMN yes list of columns to scan \r\nEXCLUDE list of tables to exclude from scan \r\nTOCHAR yes new database character set name \r\nFROMCHAR current database character set name \r\nTONCHAR new national character set name \r\nFROMNCHAR current national character set name \r\nARRAY 1024000 yes size of array fetch buffer \r\nPROCESS 1 yes number of concurrent scan process \r\nMAXBLOCKS split table if block size exceed MAXBLOCKS \r\nCAPTURE N capture convertible data \r\nSUPPRESS maximum number of exceptions logged for each table\r\nFEEDBACK report progress every N rows \r\nBOUNDARIES list of column size boundaries for summary report \r\nLASTRPT N generate report of the last database scan \r\nLOG scan base file name of report files \r\nPARFILE parameter file name \r\nPRESERVE N preserve existing scan results \r\nLCSD N no enable language and character set detection \r\nLCSDDATA LOSSY no define the scope of the detection \r\nHELP N show help screen (this screen) \r\nQUERY N select clause to scan subset of tables or columns \r\n---------- ------- ------ ------------------------------------------------- \r\nScanner terminated successfully.<\/pre>\n\u91c7\u7528\u8fd9\u4e2a\u65b9\u6cd5\u786e\u5b9e\u89e3\u51b3\u4e86\u95ee\u9898\u3002\u4e0d\u8fc7\u5947\u602a\u7684\u95ee\u9898\u662f\uff0c\u53e6\u5916\u4e00\u53f0\u670d\u52a1\u5668\u91c7\u7528\u76f8\u540c\u65b9\u5f0f\u5b89\u88c5\u7684\u6570\u636e\u5e93\uff0c\u5e76\u4e0d\u5b58\u5728\u8fd9\u4e2a\u95ee\u9898\uff0c\u800c\u4e14\u8fd9\u53f0\u670d\u52a1\u5668\u4e0a\u7684LD_LIBRARY_PATH\u7684\u8bbe\u7f6e\u4e0e\u51fa\u73b0\u95ee\u9898\u7684\u670d\u52a1\u5668\u5b8c\u5168\u4e00\u81f4\uff1a<\/p>\n
[oracle@dbserver1 ~]$ cd $ORACLE_HOME\/bin\r\n[oracle@dbserver1 bin]$ csscan help=y\r\nCharacter Set Scanner v2.2 : Release 11.2.0.2.0 - Production on Mon Sep 5 17:47:18 2011\r\nCopyright (c) 1982, 2009, Oracle and\/or its affiliates. All rights reserved.\r\nYou can let Scanner prompt you for parameters by entering the CSSCAN \r\ncommand followed by your username\/password: \r\n Example: CSSCAN \\\"SYSTEM\/MANAGER AS SYSDBA\\\" \r\nOr, you can control how Scanner runs by entering the CSSCAN command \r\nfollowed by various parameters. To specify parameters, you use keywords: \r\n Example: \r\n CSSCAN \\\"SYSTEM\/MANAGER AS SYSDBA\\\" FULL=y TOCHAR=utf8 ARRAY=1024000 PROCESS=3 \r\nKeyword Default Prompt Description \r\n---------- ------- ------ ------------------------------------------------- \r\nUSERID yes username\/password \r\nFULL N yes scan entire database \r\nUSER yes owner of tables to be scanned \r\nTABLE yes list of tables to scan \r\nCOLUMN yes list of columns to scan \r\nEXCLUDE list of tables to exclude from scan \r\nTOCHAR yes new database character set name \r\nFROMCHAR current database character set name \r\nTONCHAR new national character set name \r\nFROMNCHAR current national character set name \r\nARRAY 1024000 yes size of array fetch buffer \r\nPROCESS 1 yes number of concurrent scan process \r\nMAXBLOCKS split table if block size exceed MAXBLOCKS \r\nCAPTURE N capture convertible data \r\nSUPPRESS maximum number of exceptions logged for each table\r\nFEEDBACK report progress every N rows \r\nBOUNDARIES list of column size boundaries for summary report \r\nLASTRPT N generate report of the last database scan \r\nLOG scan base file name of report files \r\nPARFILE parameter file name \r\nPRESERVE N preserve existing scan results \r\nLCSD N no enable language and character set detection \r\nLCSDDATA LOSSY no define the scope of the detection \r\nHELP N show help screen (this screen) \r\nQUERY N select clause to scan subset of tables or columns \r\n---------- ------- ------ ------------------------------------------------- \r\nScanner terminated successfully.\r\n[oracle@dbserver1 bin]$ env|grep LD_LIB\r\nLD_LIBRARY_PATH=\/etc\/emc\/rsa\/cst\/lib<\/pre>\n\u867d\u7136metalink\u7ed9\u51fa\u7684\u89e3\u51b3\u65b9\u6cd5\u786e\u5b9e\u6709\u6548\uff0c\u4f46\u662f\u5bfc\u81f4\u8fd9\u4e2a\u95ee\u9898\u7684\u539f\u56e0\u548c\u53ef\u80fd\u662f\u591a\u4e2a\u65b9\u9762\u7684\uff0c\u81f3\u5c11\u6587\u6863\u6ca1\u6709\u7ed9\u51fa\u4e3a\u4ec0\u4e48\u540c\u6837\u914d\u7f6e\u540c\u6837\u7248\u672c\u7684\u4e24\u4e2a\u6570\u636e\u5e93\uff0c\u5728\u4e00\u4e2a\u4e0a\u6ca1\u6709\u95ee\u9898\uff0c\u800c\u53e6\u4e00\u4e2a\u4e0a\u8fd0\u884c\u5c31\u51fa\u73b0\u9519\u8bef\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"
\u5728\u4e00\u4e2a11.2.0.2 for Linux X86-64\u73af\u5883\u4e2d\uff0c\u8fd0\u884ccsscan\u5de5\u5177\u62a5\u9519\u3002 \u9519\u8bef\u4fe1\u606f\u4e3a\uff1a [oracle@dbserver2 ~]$ cd $ORACLE_HOME\/bin [oracle@dbserver2 bin]$ csscan help=y csscan: error while loading shared libraries: libclntsh.so.11.1: cannot open shared object file: No such file or directory \u68c0\u67e5metalink\uff0c\u5728\u6587\u6863ID 742070.1\u4e2d\u63d0\u5230\uff0c\u5bfc\u81f4\u8fd9\u4e2a\u95ee\u9898\u7684\u539f\u56e0\u662f\u6ca1\u6709\u6b63\u786e\u7684\u8bbe\u7f6eLD_LIBRARY_PATH\u73af\u5883\u53d8\u91cf\uff0c\u5c06$ORACLE_HOME\/lib\u6dfb\u52a0\u5230\u8fd9\u4e2a\u73af\u5883\u53d8\u91cf\u4e2d\u53ef\u4ee5\u907f\u514d\u9519\u8bef\u7684\u4ea7\u751f\uff1a [oracle@dbserver2 bin]$ env|grep LD_LIB LD_LIBRARY_PATH=\/etc\/emc\/rsa\/cst\/lib [oracle@dbserver2 bin]$ export … Continue reading