Not Able To Create A Database With Required NLS_LANGUAGE and NLS_TERRITORY With DBCA
Last updated on JUNE 22, 2018
Applies to:Oracle Database - Enterprise Edition - Version 220.127.116.11 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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms