--View Oracle database Character set:
SQL code
Select Userenv (' language ') from dual;
Query results:
Simplified Chinese_china. Al32utf8
--Modifying the Oracle Database Character set: (In SQL Plus)
SQL code
Sql> Conn/as sysdba;
sql> shutdown immediate;
Database closed.
Database dismounted.
Oracle instance shut down.
sql> startup Mount;
Oracle instance started.
Total system global Area 135337420 bytes
Fixed size 452044 bytes
Variable size 109051904 bytes
Database buffers 25165824 bytes
Redo Buffers 667648 bytes
Database mounted.
Sql> alter system enable restricted session;
System altered.
Sql> alter system set job_queue_processes=0;
System altered.
Sql> alter system set aq_tm_processes=0;
System altered.
sql> ALTER DATABASE open;
Database altered.
Sql> ALTER DATABASE character set Internal_use Al32utf8;
sql> shutdown immediate;
Sql> startup;
Modify the Oracle user's Nls_lang
Edit/home/oracle/.bash_profile
Bash code
Export nls_lang= "simplified Chinese_china. Al32utf8 "