1.安装ORACLE-11g-R2
直接官网下载按照向导安装。
2.修改数据库默认字符集为中文字符集(ZHS16GBK)
查询当前字符集:
select userenv('language') from dual;
USERENV('LANGUAGE')
----------------------------------------------------
SIMPLIFIED CHINESE_CHINA.AL32UTF8
修改默认字符集:
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
查询结果:
select userenv('language') from dual;
USERENV('LANGUAGE')
----------------------------------------------------
SIMPLIFIED CHINESE_CHINA.ZHS16GBK
3.修改ORACLE web 管理端口
ORACLE EX 默认的WEB 管理端口为8080,与TOMCAT冲突,影响本机开发。
begin
dbms_xdb.sethttpport('8088');
end;
/