Oracle is not setting character set caused by the installation of Chinese garbled solution ____oracle

Installing oracle11g on Centos6.4 does not set the character set, using the operating system default character set: we8mswin1252, which modifies the character set to: Al32utf8.

Sql> Select Userenv (' language ') from dual;

Simplified Chinese_china. we8mswin1252
Sql> SELECT * from nls_database_parameters where parameter in (' Nls_charcterset ', ' nls_nchar_characterset ');
Sql> select* from V$nls_parameters where parameter= ' nls_characterset ';

The operation process is as follows:

sql> shutdown Immediate

Sql> Startup

Sql> alter session set Sql_trace=true;

Sql> alter system enable restricted session;
Sql> Show parameter job_queue_processes;

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

sql> Update props$ set value$= ' UTF8 ' where name= ' nls_nchar_characterset ';

After changing the character set, the existing data will not change, but the new data will be the newly created character set.

--Reference:

Http://www.2cto.com/database/201312/268486.html

http://blog.csdn.net/home_zhang/article/details/8073276