Oracle10G可以采用下面的方法
connect system as sysdba ;
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 ZHS16GBK ;
shutdown immediate ;
startup ;
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 ZHS16GBK ;
shutdown immediate ;
startup ;
老版本可以参考
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 ZHS16GBK;
ALTER DATABASE national CHARACTER SET ZHS16GBK;
SHUTDOWN IMMEDIATE;
STARTUP;
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 ZHS16GBK;
ALTER DATABASE national CHARACTER SET ZHS16GBK;
SHUTDOWN IMMEDIATE;
STARTUP;
之所以改字符集是因为我昨天装了Cognos但是服务死活起不来，在网上查了一下，说是Oracle字符集的事，用UTF-8就没问题，改成UTF8了还是报错，发现一个能够起来的服务是用AL32UTF8这个字符集就能起来，我把本地的oracle字符集又改成了AL32UTF8可是还是起不来，后来同事说通过修改字符集不行，必须是创建数据库的时候就指定字符集！晕死。
