Oracle字符集修改

Oracle字符集修改为UTF8
oracle@linux:~> sqlplus / as sysdba
SQL>update props$ set value$='UTF8' where name='NLS_CHARACTERSET';
SQL>exit;
SQL>sqlplus / as sysdba;
SQL>shutdown immediate;
SQL>startup mount;
SQL>alter system enable restricted session;
SQL>alter system set JOB_QUEUE_PROCESSES=0;
SQL>alter system set AQ_TM_PROCESSES=0;
SQL>alter database open;
SQL>alter database character set internal_use UTF8;
SQL>alter database national character set internal_use UTF8;
SQL>shutdown immediate;
SQL>startup;
查询字符集
SQL>select userenv('language') from dual;