My Oracle Support Banner

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

Last updated on JUNE 06, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 12.2.0.1 and later
Information in this document applies to any platform.

Symptoms

On startup of a PDB in 12.2.0.1 multitenant database, QMON slave 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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


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