Not Able To Create A Database With Required NLS_LANGUAGE and NLS_TERRITORY Wi...

刘泽宇

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.

SQL> select * from NLS_DATABASE_PARAMETERS;

PARAMETER VALUE
------------------------------ ----------------------------------------
NLS_LANGUAGE AMERICAN
NLS_TERRITORY AMERICA


CAUSE
When creating a database like above steps, the new database always inherits the NLS setting from the seed database (of the template), since this is actually a clone operation of a existing database (who is using AMERICAN AMERICA), that's why the NLS_TERITORY=SWEDEN and NLS_LANGUAGE=SWEDISH didn't take effect.


SOLUTION

To define the NLS_DATABASE_PARAMETERS using DBCA, choose a template that has "includes datafiles" set to NO in page 2 (step number could be vary in different db version) of the DBCA; and in step 9 (step number could be vary in different db version) click on "all initialization parameters" and then "show advanced parameters", then you can set NLS_LANGUAGE etc etc for the NLS DATABASE PARAMETERS

登录/注册后可看大图