Database Install/Upgrade/Opatch (MOSC)

MOSC Banner

NLS_LANGUAGE issue at database installation

edited Feb 5, 2014 6:47AM in Database Install/Upgrade/Opatch (MOSC) 2 commentsAnswered
Hello,
I'm installing Oracle database software 11.2.0.4 on an AIX 6.1 box

Then i'm creating an instance with the following character sets:
  • Database character set: WE8ISO8859P15 - Western Europe
  • National character set: AL16UTF16
  • Default language: French
  • Date format: France

But when i query NLS_DATABASE_PARAMETERS, the American language appears:

SQL> select * from nls_database_parameters;

PARAMETER                      VALUE
------------------------------ ----------------------------------------
NLS_LANGUAGE                   AMERICAN
NLS_TERRITORY                  AMERICA
NLS_CURRENCY                   $
NLS_ISO_CURRENCY               AMERICA
NLS_NUMERIC_CHARACTERS         .,
NLS_CHARACTERSET               WE8ISO8859P15
NLS_CALENDAR                   GREGORIAN
NLS_DATE_FORMAT                DD-MON-RR
NLS_DATE_LANGUAGE              AMERICAN
NLS_SORT                       BINARY
NLS_TIME_FORMAT                HH.MI.SSXFF AM

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center