linux服务器上修改oracle数据库的字符集

linux服务器上以dba身份进入:

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 utf8;

shutdown immediate;

startup;

查看数据库字符集，看是否已经修改过来：

select userenv('language') from dual;