1.安裝ORACLE-11g-R2
直接官網(wǎng)下載按照向?qū)О惭b。
2.修改數(shù)據(jù)庫默認(rèn)字符集為中文字符集(ZHS16GBK)
查詢當(dāng)前字符集:
- select userenv('language') from dual;
- USERENV('LANGUAGE')
- ----------------------------------------------------
- SIMPLIFIED CHINESE_CHINA.AL32UTF8
修改默認(rèn)字符集:
- sqlplus / 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
查詢結(jié)果:
- select userenv('language') from dual;
- USERENV('LANGUAGE')
-
- SIMPLIFIED CHINESE_CHINA.ZHS16GBK
3.修改ORACLE web 管理端口
ORACLE EX 默認(rèn)的WEB 管理端口為8080,與TOMCAT沖突,影響本機開發(fā)。
- begin
- dbms_xdb.sethttpport('8088');
- end;
- /