Not Able To Create A Database With Required NLS_LANGUAGE and NLS_TERRITORY With DBCA

(Doc ID 2363201.1)

Last updated on JUNE 22, 2018

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.3 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

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms