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.
需要了解更多数据库技术:Bug 29041775 : ORA-41401: Define character set () does not match database character set (),都可以关注数据库技术分享栏目—计算机技术网(www.ctvol.com)!
本文来自网络收集,不代表计算机技术网立场,如涉及侵权请联系管理员删除。
ctvol管理联系方式QQ:251552304
本文章地址:https://www.ctvol.com/dtteaching/797168.html