Re: Enterprise manager nls problem

From: <perivoj_at_net.hr>
Date: 23 May 2007 07:38:17 -0700
Message-ID: <1179931097.381090.317720@p77g2000hsh.googlegroups.com>

Thank you for replying.

>We need your NLS_SESSION_PARAMETERS and your NLS_DATABASE_PARAMETERS,
>especially the env var or registry string value NLS_LANG.

SQL> select * from NLS_SESSION_PARAMETERS;

PARAMETER                      VALUE
------------------------------
----------------------------------------
NLS_LANGUAGE                   CROATIAN
NLS_TERRITORY                  CROATIA
NLS_CURRENCY                   kn
NLS_ISO_CURRENCY               CROATIA
NLS_NUMERIC_CHARACTERS         .,
NLS_CALENDAR                   GREGORIAN
NLS_DATE_FORMAT                DD.MM.RR
NLS_DATE_LANGUAGE              CROATIAN
NLS_SORT                       CROATIAN
NLS_TIME_FORMAT                HH24:MI:SSXFF
NLS_TIMESTAMP_FORMAT           DD.MM.RR HH24:MI:SSXFF
NLS_TIME_TZ_FORMAT             HH24:MI:SSXFF TZR
NLS_TIMESTAMP_TZ_FORMAT        DD.MM.RR HH24:MI:SSXFF TZR
NLS_DUAL_CURRENCY              kn
NLS_COMP                       BINARY
NLS_LENGTH_SEMANTICS           BYTE
NLS_NCHAR_CONV_EXCP            FALSE

--

SQL> select * from NLS_DATABASE_PARAMETERS;

PARAMETER                      VALUE
------------------------------
----------------------------------------
NLS_LANGUAGE                   CROATIAN
NLS_TERRITORY                  CROATIA
NLS_CURRENCY                   kn
NLS_ISO_CURRENCY               CROATIA
NLS_NUMERIC_CHARACTERS         .,
NLS_CHARACTERSET               EE8MSWIN1250
NLS_CALENDAR                   GREGORIAN
NLS_DATE_FORMAT                DD.MM.RR
NLS_DATE_LANGUAGE              CROATIAN
NLS_SORT                       CROATIAN
NLS_TIME_FORMAT                HH24:MI:SSXFF
NLS_TIMESTAMP_FORMAT           DD.MM.RR HH24:MI:SSXFF
NLS_TIME_TZ_FORMAT             HH24:MI:SSXFF TZR
NLS_TIMESTAMP_TZ_FORMAT        DD.MM.RR HH24:MI:SSXFF TZR
NLS_DUAL_CURRENCY              kn
NLS_COMP                       BINARY
NLS_LENGTH_SEMANTICS           BYTE
NLS_NCHAR_CONV_EXCP            FALSE
NLS_NCHAR_CHARACTERSET         AL16UTF16
NLS_RDBMS_VERSION              10.2.0.2.0


--

Key Name:          HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE
\KEY_OraDb10g_home1
Class Name:        Application Global Data
Last Write Time:   16.5.2007 - 14:23

....

Value 3
  Name:            NLS_LANG
  Type:            REG_SZ
  Data:            CROATIAN_CROATIA.EE8MSWIN1250

....





>Also one would need to know whether you connect directly to the database, or using the management console.


I connect using: Oracle Enterprise Manager Database Control 10.2.0.1
and only there I have this problem.

Received on Wed May 23 2007 - 09:38:17 CDT