linux oracle 修改字符集

sqlplus sys/sys 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 utf8 ;

shutdown immediate

startup

就结束了

查看字符集：

select userenv('language') from dual;