修改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;