Hey,
I just installed a new database on 11.2.0.4
I used dbca and during Setup I entered the advanced initialization Parameters.
I created a pfile from spfile
and all nls Settings seems to bo correct.
But when I enter.
Show Parameter nls
there are wrong:
So which Settings are correct now ?
SQL> show parameter nls
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
nls_calendar string GREGORIAN
nls_comp string BINARY
nls_currency string Ç
nls_date_format string DD.MM.RR
nls_date_language string GERMAN
nls_dual_currency string Ç
nls_iso_currency string GERMANY
nls_language string GERMAN
nls_length_semantics string BYTE
nls_nchar_conv_excp string FALSE
nls_numeric_characters string ,.
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
nls_sort string GERMAN
nls_territory string GERMANY
nls_time_format string HH24:MI:SSXFF
nls_timestamp_format string DD.MM.RR HH24:MI:SSXFF
nls_timestamp_tz_format string DD.MM.RR HH24:MI:SSXFF TZR
nls_time_tz_format string HH24:MI:SSXFF TZR
SQL>
pfile.ora
*.nls_calendar='GREGORIAN'
*.nls_comp='BINARY'
*.nls_currency='$'
*.nls_date_format='DD-MON-RR'
*.nls_date_language='AMERICAN'
*.nls_dual_currency='AMERICA'
*.nls_iso_currency='AMERICA'
*.nls_language='AMERICAN'
*.nls_numeric_characters='.,'
*.nls_sort='BINARY'
*.nls_territory='AMERICA'
*.nls_time_format='HH.MI.SSXFF','AM'
*.nls_time_tz_format='HH.MI.SSXFF','AM','TZR'
*.nls_timestamp_format='DD-MON-RR HH.MI.SSXFF AM'
*.nls_timestamp_tz_format='DD-MON-RR HH.MI.SSXFF AM TZR'