1.首先連接oracle10g數(shù)據(jù)庫：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

最好是把監(jiān)聽也重新啟動一下。