Not Able To Create A Database With Required NLS_LANGUAGE and NLS_TERRITORY With DBCA
(Doc ID 2363201.1)
Last updated on FEBRUARY 03, 2019
Applies to:Oracle Database - Enterprise Edition - Version 188.8.131.52 and later
Information in this document applies to any platform.
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.
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