My Oracle Support Banner

Wrong nls_language and nls_territory values in MGMT$DB_INIT_PARAMS_ALL view for databases with non-default values (Doc ID 2512895.1)

Last updated on MAY 21, 2019

Applies to:

Enterprise Manager for Oracle Database - Version 13.2.0.0.0 and later
Information in this document applies to any platform.

Symptoms

When checking the nls_language or nls_territory initialization parameters from "\Oracle Database\Configuration\Latest configuration" it is observed that they are not the same as in the \Administration\ Initialization Parameters menu.

Also, querying the MGMT$DB_INIT_PARAMS_ALL it is showing the same behavior.

For example, querying the parameter directly in the database will show:

 

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