This content has been marked as final. Show 2 replies
Try to avoid NLS_LANGUAGE/NLS_TERRITORY false in NLS_DATABASE_PARAMETERS after install threads/posts in the future.
The issue was probably posted correct in the Install forum to begin with.
For learning about the different levels of nls settings, perhaps this doc section helps.
Actually, duplicating posts sometimes does make sense, because I monitor this forum but not the installation forum ;-)
You got the right answer concerning how to make sure that GERMAN/GERMANY is in NLS_DATABASE_PARAMETERS, i.e. you should not use the fast installation path with pre-created seed database.
The fact that NLS_DATABASE_PARAMETERS contains AMERICAN/AMERICA instead of GERMAN/GERMANY is usually not an issue. Those parameters are used very rarely, mainly to create an evaluation NLS context for CHECK constraints. My recommendation is to define CHECK constraints in NLS-independent way, so that NLS environment is not used at all. These makes the mentioned parameters pretty irrelevant.
I tried to check the RDBMS code to see if the parameters are used for any other task except evaluating CHECK constraints but I failed due to the number of code lines to analyze. I may try to repeat this exercise in the future.