Bug 29041775 : ORA-41401: Define character set () does not match database character set ()
oracle版本12.2.0.1
Errors in file /u01/app/oracle/diag/rdbms/sibcyb1/CYB111/trace/CYB111_q003_166752.trc:
ORA-41401: Define character set () does not match database character set ()
ORA-41401: Define character set (ORA-41401: Define character set (873) does not match database character set (852)
) does not match database character set ()
MOS文档 ID 2547439.1
-- CDB
conn / as sysdba
SQL> select * from nls_database_parameters where parameter like '%CHARACTERSET';
PARAMETER VALUE
------------------------- --------------------
NLS_NCHAR_CHARACTERSET AL16UTF16
NLS_CHARACTERSET AL32UTF8
SQL> alter session set container=PDB1;
Session altered.
-- PDB
SQL> select * from nls_database_parameters where parameter like '%CHARACTERSET';
PARAMETER VALUE
------------------------- --------------------
NLS_NCHAR_CHARACTERSET AL16UTF16
NLS_CHARACTERSET AL32UTF8
解决方法：
1. Apply the fix for Bug 29041775.
Patches
with the fix for Bug 29041775 are available for some 12.2 and 18.x
version/platform combinations. Please check patch availability in My
Oracle Support (MOS); for a list of available patches, please do the
following:
- In MOS, select the Patches & Updates tab
- In Search tab, for Number/Name or Bug Number (Simple), select Bug Number
- For Bug Number, enter 29041775
- For Platform, select desired platform
- Click Search button.
- The search will return a list of available patches with the fix for Bug 29041775.
or
2. Upgrade to Oracle Server 20.1 when available. Bug 29041775 is fixed in 20.1.
最新文章
- Play Framework 完整实现一个APP（十四）
- dpkg: 处理归档 /var/cache/apt/archives/软件名 (--unpack)时出错：由于已经达到 MaxReports 限制，没有写入 apport 报告。
- ListView下拉刷新
- POJ 2785 4 Values whose Sum is 0
- SQL实现分组查询取前几条记录
- html meta标签之http-equiv
- Apache Commons 工具类
- WebStorm 的使用（一）
- NGINX结合SHELL统计用户的UV及IP汇总
- Terminating app due to uncaught exception 'NSInvalidArgumentException', reason: '-[NSInvocation setArgument:atIndex:]: index (3) out of bounds [-1, 2]'
- PHPStorm+PHPStudy配置XDebug
- 敏捷冲刺每日报告——Day4
- java虚拟机的类加载器
- SO\PR\MO\排产回写的数据如下
- 第十一章 串 (b1)串匹配
- mysql-unsha1：在未知密码情况下，登录任意MYSQL数据库
- sell 项目 类目表 设计 及 创建
- Linux下用C获取当前时间
- 学习python，第三篇：.pyc是个什么鬼？
- 数据库面试题之PL/SQL面试题