This content has been marked as final. Show 4 replies
Could you show us your createdb logfile..
where we can find it ...?
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.