文档解释
ORA-12714: invalid national character set specified
Cause: Only UTF8 and AL16UTF16 are allowed to be used as the national character set
Action: Ensure that the specified national character set is valid
ORA-12714: invalid national character set specified错误,是在使用创建数据库(Create Database)或者变更字符集(Alter Database Character Set)语句时,出现的错误。
官方解释
ORA-12714: invalid national character set specified
Cause: An invalid national character set was specified.
Action: Specify a valid national character set.
常见案例
情况1:
在另一个数据库中使用 ALTER DATABASE CHANGE CHARACTER SET 命令,但是指定了无效的字符编码(invalid national character set)。执行时会报出ORA-12714: invalid national character set specified错误。
正常处理方法及步骤
1. 首先确认Dialect的定义是正确的,是支持的编码;
2. 如果确认Dialect的定义是正确的,但仍报此错误,建议提供确认支持的National Character Set和Dialect 编码的清单,如下:
(1)MULTINATIONAL:
AL32UTF8
AR8ISO8859P6
EE8MSWIN1250
EL8ISO8859P7
JA16SJIS
KO16MSWIN949
TH8TIS620
(2)AL16UTF16:
AL16UTF16
AR16ARABIC
AZ16ISO8859P9E
BG16MSWIN
CY16ISO8859P10
EE16MSWIN949
EL16ISO8859P13
HU16MSWIN1250
INTL16INTL
JA16EUC
KO16KSC5601
NEE16ISO8859P4
RU16MSWIN1251
TH16TIS620
TR16MSWIN1254
VN16MSWIN1258
ZA16ISO8859P15
3. 再确认操作系统支持字符集编码;
4. 可以尝试重新建库或修改系统字符集;
5. 也可以找Oracle数据库专家帮助分析问题,并找正确的解决方案。