Oracle viewing character sets and modifying character sets

Oracle View character set and modify character set:

To view the character set of the database server:

Select userenv ('language' from dual;

Login with DBA:

To stop the database:

Shutdown

To start the database into the Mount state:

STARTUP MOUNT;

ALTER SET Sql_trace=alteralterSET job_queue_processes=  0ALTERSET aq_tm_processes=0;

Start the database:

Alter Database Open

Set the character set:

ALTER DATABASE CHARACTER SET

First of all the database in the Chinese garbled empty. And then in execution. It is possible for an error to execute this skip character set check:

ALTER DATABASE character Set

To close the database:

Shutdown Immediate

Restart:

It should be modified to look at the next character set.

Oracle viewing character sets and modifying character sets