1.首先连接oracle10g数据库：sqlplus /nolog

2.connect /as sysdba

3.shutdown immediate

4.startup mount

5.alter system enable restricted session ;

6.alter system set JOB_QUEUE_PROCESSES=0;

7.alter system set AQ_TM_PROCESSES=0;

8.alter database open ;

9.alter database character set internal_use ZHS16GBK ; (注：还可以更改为UTF8)

10.shutdown immediate

11.startup

最好是把监听也重新启动一下。