设为首页 加入收藏

TOP

Bug 29041775 : ORA-41401: Define character set () does not match database character set ()
2019-10-09 20:06:11 】 浏览:64
Tags:Bug 29041775 ORA-41401: Define character set does not match database

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.

】【打印繁体】【投稿】【收藏】 【推荐】【举报】【评论】 【关闭】 【返回顶部
上一篇LeetCode——Rank Scores 下一篇大数据量高并发的数据库优化,sql..

最新文章

热门文章

Hot 文章

Python

C 语言

C++基础

大数据基础

linux编程基础

C/C++面试题目