PDB QMON Process Reports ORA-41401: Define character set () does not match database character set () (Doc ID 2547439.1)

Last updated on JULY 20, 2024

Applies to:

Symptoms

On startup of a PDB in 12.2.0.1 multitenant database, QMON worker process reports the following in the alert log:

The CDB (CDB$ROOT) and PDB have different character sets.  

For example:

-- 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          WE8MSWIN1252

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.