I am wokring 188.8.131.52.0 on AIX.
We need to create a database with nls_language=icelandic and nls_territory=iceland and nls_characterset=we8mswin1252.
While creating database we choose same ,but after creation when we checked nls_database_parameters it is showing
nls_language=american and nls_territory=america ....
we tried to change in pfile and spfile but it is showing changes in nls_session_parameters and nls_instance_parameters but not in database level..
Is that we can not create database with characterset=we8mswin1252 and choose language=celandic and territory=iceland..?
becasue we checked multiple times settings while creating database...but database was created with american language..
You must use "Custom database" template to create a database like that IMHO. I guess you used dbca and another template based db creation...
DBCA shows you where it puts its logs. Or you can save scripts and create the database using those and you can see logs there as well.
Do you really need nls_language=icelandic and nls_territory=iceland in the database settings? These settings are used when evaluating check constraints or virtual column expressions but you should write these expressions in an NLS-independent way anyway.
If you insist on having these parameters set to non-US values, you need to make sure that DBCA creates the database from scratch and not by using one of the predefined databases. If you set nls_language=icelandic and nls_territory=iceland among initialization parameters in DBCA and the database is created from scratch, then these parameters will make it into NLS_DATABASE_PARAMETERS. Otherwise, the parameters from the Oracle-provided DB files (seed database) will be used. Language and territory parameters in NLS_DATABASE_PARAMETERS cannot be changed after the database is created. This is on purpose.