Re: Re: ORA-12075 Invalid/Unknown NLS parameter

Morning Jason,

> Thanks guys. I've tried your suggestions but not sure if they help much...
>
> NLS_LANG is currently set to
> ENGLISH_UNITED KINGDOM.US7ASCII
This is most probably wrong! Remember NLS_LANG must represent the 
territory and language on the client (Morning Mark!) not some arbitrary 
value chosen to potentially match the database.

Look in Control Panel -> Regional Settings and report back your settings 
for the following (on the General) tab:

Your locale: Mine is "English (United Kingdom)".
Your Language Settings: Mine is "Western Europe and United States" and 
is set to be the default, but I have no others ticked.

This gives me the following for my NLS_LANG settings for all my client 
installs:

9.2.0.8: ENGLISH_UNITED KINGDOM.WE8MSWIN1252
10.2: ENGLISH_UNITED KINGDOM.WE8MSWIN1252
11.1: ENGLISH_UNITED KINGDOM.WE8MSWIN1252

All my client installs have defaulted the settings as above, based on 
what was in my Regional Settings at the time of the install - I assume!

Can you check the Regional Settings on your desktops which work and 
compare them to  the one which doesn't work.

in addition, someone (Peter I think) asked about using SQL*Plus (from 
the same Oracle Home) to connect - does that work? If so, try selecting 
from V$NLS_PARAMETERS as follows:

set lines 100
set pages 1000
col parameter format a30 wrap
col value format a30 wrap
select * from v$nls_parameters;

Thanks.


> Logon attempt failed. username: 'TAROT'; database: 'TARPRDM.WORLD'
> Runtime error occurred: 12705 (ORA-12705: invalid or unknown NLS parameter
> value specified)
>
> -which is no news :-(
Interesting that the monitor didn't pick up on anything NLS being sent 
to the database at logon time. (For certain values of "interesting"!)

> We're using Oracle client 9.2, which I know is out of date (it's a 10g
> database) but it works fine on all our other installations here.
Well, I'm mostly using 9.2.0.8 client to talk to 10g and 11g databases 
and unless I try something funny like selecting from dba_scheduler_% 
views where timestamp with  timezones live, it just works. 9.2 client 
doesn't seem to like those pesky TS+TZ data types!


-- 
Cheers,
Norm. [TeamT]


------------------------------------

Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/toad/

<*> Your email settings:
    Individual Email | Traditional

<*> To change settings online go to:
    http://groups.yahoo.com/group/toad/join
    (Yahoo! ID required)

<*> To change settings via email:
    [email protected] 
    [email protected]

<*> To unsubscribe from this group, send an email to:
    [email protected]

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/