Oracle 11g Change Character Set

To view the character set:

SELECT * from V$nls_parameters;
SELECT * from Nls_database_parameters;

To modify a character set:

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;
Sql> ALTER DATABASE Character set Internal_use ZHS16GBK; --Modify Character Set AL32UTF8->ZHS16GBK
sql> shutdown immediate; --Close the database again
Sql> Startup--Start the database
Sql> SELECT * from v$nls_parameters where parameter = ' nls_characterset ';
==============================
Client Side Character Set modification
In the. Bash_profile in the/home/oracle and/root user directories
Add or modify Export nls_lang= "American_america. UTF8 "statement
Close the current SSH window.

Oracle 11g Change Character Set