Form 6i or sqlplus reports ora805.dll and access violation error and crash immediately. This is because of the character set of 10g is in
AL32UTF8, need to be changed to UTF8, do following in sqlplus ;
connect "AS SYSDBA" in sqlplus.
SHUTDOWN IMMEDIATE;
STARTUP MOUNT;
ALTER SYSTEM ENABLE RESTRICTED SESSION;
ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0;
ALTER SYSTEM SET AQ_TM_PROCESSES=0;
ALTER DATABASE OPEN;
ALTER DATABASE CHARACTER SET INTERNAL_USE UTF8;
SHUTDOWN;
STARTUP RESTRICT;
SHUTDOWN;
STARTUP;

本文介绍了解决Oracle数据库字符集问题的方法,通过一系列步骤将字符集从AL32UTF8更改为UTF8,以避免sqlplus、reports等工具中出现的崩溃及访问违规错误。
6573

被折叠的 条评论
为什么被折叠?



