可以尝试一下下面的方法: 一、在SQL*PLUS 中,以DBA登录 conn 用户名 as sysdba
二、然后执行以下命令 >shutdown immediate; (把database停了) >startup mount; (把database重开去可更改情況) >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 CHINESE_CHINA.ZHS16GBK; >shutdown immediate; >startup; (重开正常oracle)
先停止服务,再修修改字符集SQL> alter session set sql_trace=true; Session altered.SQL> alter system enable restricted session; System altered.SQL> alter system set job_queue_processes=0; System altered.SQL> alter system set aq_tm_processes=0; System altered.SQL> alter database open; Database altered.SQL> alter database character set JA16SJIS; Database altered.
一、在SQL*PLUS 中,以DBA登录
conn 用户名 as sysdba
二、然后执行以下命令
>shutdown immediate; (把database停了)
>startup mount; (把database重开去可更改情況)
>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 CHINESE_CHINA.ZHS16GBK;
>shutdown immediate;
>startup; (重开正常oracle)
1、新建系统环境变量NLS_LANG,值为SIMPLIFIED CHINESE_CHINA.ZHS16GBK
2、修改注册表文件:HKEY_LOCAL_MACHINE->SOFTWARE->ORACLE->KYE_OraDB11g_home11修改NLS_LANG的值为SIMPLIFIED CHINESE_CHINA.ZHS16GBK
3、重启plsql如果成功,请给分谢谢。ps:如果未成功请也给分,谢谢
Database altered.