1. 查看oracle服務(wù)器字符集

select userenv ('language') from dual;

2. 關(guān)閉數(shù)據(jù)庫

shutdown immediate;

3.啟動數(shù)據(jù)庫mount模式

startup mount;

4.?oracle 處于restricted模式

alter system enable restricted session;

5. 設(shè)置job_queue_processes參數(shù)=0

alter system set job_queue_processes=0;

6.?修改數(shù)據(jù)庫的狀態(tài)為打開

alter database open;

7. 修改字符集為AL32UTF8

alter database character set internal_use AL32UTF8

8. 關(guān)閉數(shù)據(jù)庫

shutdown immediate;

9. 啟動數(shù)據(jù)庫

startup