日期:2014-05-16  浏览次数:20578 次

修改oracle实例字符集

?

select value$ from props$ where name='NLS_CHARACTERSET'';

export NLS_LANG="SIMPLIFIED CHINESE_CHINA.ZHS16GBK"

?

source .bash_profile

?

sqlplus / as sysdba

?

shutdown immediate;

startup mount;

??

alter session set SQL_TRACE=TRUE;

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;

?