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.