My Oracle Support Banner

Not Able To Create A Database With Required NLS_LANGUAGE and NLS_TERRITORY With DBCA (Doc ID 2363201.1)

Last updated on JANUARY 05, 2023

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.3 and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Information in this document applies to any platform.

Symptoms

Can't create a new database with NLS_TERITORY=SWEDEN and NLS_LANGUAGE=SWEDISH at database level. (This note also applies for other TERITORY & LANGUAGE)

Below Options are used in DBCA when creating database:

Invoke DBCA >>>Create database >>Advanced mode(Radio button seleted)>> General purpose or Transaction processing (radio button selected)

In Step 10 (this number could be vary depending on the DB version) of DBCA under Character Sets tab

Use Unicode (AL32UTF8)

Default Language: Swedish (This is the intended requirement)

Deafult Territory: Sweden (This is the intended requirement)

Verified in the "All initialization parameters" tab: All looks correct as per the requirement - NLS_TERITORY=SWEDEN and NLS_LANGUAGE=SWEDISH

Once DBCA completed and database created, NLS_LANGUAGE and NLS_TERRITORY is going back to default values even we've selected NLS_TERITORY=SWEDEN and NLS_LANGUAGE=SWEDISH in DBCA while creating the database.

 

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.