Re: ORA-12705: invalid or unknown NLS parameter value specified

On Thu, 26 Feb 1998 20:52:25 GMT, eross_at_serviceware#.ca (Elliot Ross) wrote: Hi,

are you sure that 'BINARY' is a valid value for NLS_SORT? With language set to 'GERMAN' you've as NLS_SORT values like 'GERMAN', 'GERMAN_DIN' which describe some sorting orders (concerning umlauts).

>Hi all, (I am not ORA experienced by the way)
>
>Getting this error trying to connect to any instance on an Oracle for NT
>ver 7.3 box.
>
>If I am physically at the server console, I can access the instance with
>server manager.
>
>running srvmgr from a workstation I get: ORA-12705: invalid or unknown
>NLS parameter value specified
>
>But from the console, v$nls_parameters shows: (& the Instance was
>installed as US English etc.)
>
>PARAMETER VALUE
>------------------------------------
>NLS_LANGUAGE AMERICAN
>NLS_TERRITORY AMERICA
>NLS_CURRENCY $
>NLS_ISO_CURRENCY AMERICA
>NLS_NUMERIC_CHARACTERS .,
>NLS_DATE_FORMAT DD-MON-YY
>NLS_DATE_LANGUAGE AMERICAN
>NLS_CHARACTERSET WE8ISO8859P1
>NLS_SORT BINARY
>NLS_CALENDAR GREGORIAN
>10 rows selected.
>
>What am I missing ??? there are no TRC error messages that I can
>understand, the services seem to be running OK.....
>
>Any help apreciated
>--
>My EMail address contains a # to try to
>thwart mail spamming.

--

Regards

Matthias Gresz    :-)

GreMa_at_T-online.de