当前位置: 萬仟网 > IT编程>数据库>Oracle > Bug 29041775 : ORA-41401: Define character set () does not match database character set ()

Bug 29041775 : ORA-41401: Define character set () does not match database character set ()

2019年10月09日 17:50  | 萬仟网IT编程  | 我要评论

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.

如对本文有疑问,请在下面进行留言讨论,广大热心网友会与你互动!! 点击进行留言回复

相关文章:

◎已有 0 人评论

Copyright © 2019  萬仟网 保留所有权利. 粤ICP备17035492号-1
站长QQ:2386932994 | 联系邮箱:2386932994@qq.com