Bug 29041775 : ORA-41401: Define character set () does not match database character set ()，characterset
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.