ORA-12712 errors caused by modifying the service-side character set in Oracle

Today, a test machine Oracle server, when the tester built the character set into the we8mswin1252 character sets, resulting in the inability to save Russian and other national languages.

So I suggest that the test change the character set to Al32utf8.

First look at the service-side character set

SELECT * from v$nls_parameters where parameter = ' Nls_characterset '

Nls_characterset we8mswin1252

And then modify it with the SYS user

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

>alter database character Set Al32utf8;

More Wonderful content: http://www.bianceng.cnhttp://www.bianceng.cn/database/Oracle/

Ora-12712:new Character set must is a superset of old character set

Rror at line 1:

The result is an error indicating that the new character set must be a superset of the old character set.

So cast

>alter DATABASE Character Set Internal_use Al32utf8;

>shutdown immediate;

>STARTUP;

Solve the problem.

Internal_use is a parameter that is not written in the document and is used to force character set conversion

ALTER DATABASE character Set Internal_use &charset;

ALTER DATABASE national character set Internal_use &ncharset;

This article is from "Richard's notes-accumulate micro Cheng" blog, please be sure to keep this source http://zxf261.blog.51cto.com/701797/818340