Oracle 10g,修改可以采用下面的方法
sql>connect system as sysdba ;
sql>shutdown immediate ;
sql>startup mount ;
sql>alter system enable restricted session ;
sql>alter system set JOB_QUEUE_PROCESSES=0;
sql>alter system set AQ_TM_PROCESSES=0;
sql>alter database open ;
sql>alter database character set internal_use ZHS16GBK ;
sql>shutdown immediate ;
sql>startup ;
sql>connect system as sysdba ;
sql>shutdown immediate ;
sql>startup mount ;
sql>alter system enable restricted session ;
sql>alter system set JOB_QUEUE_PROCESSES=0;
sql>alter system set AQ_TM_PROCESSES=0;
sql>alter database open ;
sql>alter database character set internal_use ZHS16GBK ;
sql>shutdown immediate ;
sql>startup ;