NLS_LANG is the environmental variable. So it needs to
be set up at o/s level. Since it is not a database variable,
you cannot set it up in init.ora. For example, in unix, you
can use export NLS_LANG=....
Chandan Dutta
hilmarcher_at_yahoo.com (Caroline) wrote in message news:<8f934c98.0204230212.20d542fd_at_posting.google.com>...
> OK I think it is my NLS_LANG parameter which was incorrect.
> So I have written in my initSID.ora file :
>
> #date format parameter
> NLS_DATE_FORMAT='Mon DD YYYY HH24:MI:SS'
> NLS_LANG=American_America.WE8ISO8859P1
> (it is the charset answer from the request :
> select * from v$nls_parameters where parameter='NLS_CHARACTERSET';)
>
> But when I try now to startup my instance, I have this error :
>
> SVRMGR> startup
> LRM-00101: unknown parameter name 'NLS_LANG'
> ORA-01078: failure in processing system parameters
> SVRMGR>
>
> Oracle version : 8.1.7
> Sever : Tru64 Alpha server Compaq
Received on Tue Apr 23 2002 - 11:59:12 CDT
