RE: NLS parameters
- From: Jonathan Knight <knightjck_work@xxxxxxxxx>
- To: ineyman@xxxxxxxxxxxxxx, shrekdba@xxxxxxxxx
- Date: Thu, 27 Apr 2006 12:19:44 -0700 (PDT)
I tried completely removing the NLS parameters and
could not connect. I can again connect after
restoring the NLS_LANG entry.
I just tried addig NLS_DATE_FORMAT to the registry,
but it doesn't influence the session.
Thanks for the suggestion,
Jon
--- Igor Neyman <ineyman@xxxxxxxxxxxxxx> wrote:
> You could add NLS_DATE_FORMAT to the registry.
>
> -----Original Message-----
> From: oracle-l-bounce@xxxxxxxxxxxxx
> [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of
> Jonathan Knight
> Sent: Thursday, April 27, 2006 2:49 PM
> To: shrekdba@xxxxxxxxx
> Cc: oracle-l@xxxxxxxxxxxxx
> Subject: Re: NLS parameters
>
> Thanks Bill.
>
> In the Registry, I have reset
> NLS_LANG = 'AMERICAN_AMERICA.WE8ISO8859P1'
> but, I don't find NLS_DATE_FORMAT.
>
> The home selector just appears to change the PATH
> variable, but not any
> NLS settings.
>
> Jon Knight
>
> --- bill thater <shrekdba@xxxxxxxxx> wrote:
>
> > > Oddly, this has affected connections from either
> oracle home,
> > > including the original one. I am changing the
> oracle home by
> > > altering the PATH environment variable.
> > >
> > > Any ideas on defaulting NLS_DATE_FORMAT back
> like
> > it
> > > was?
> >
> > you may need to go into the registery and change
> the value in the
> > variable there. or use the home changer that
> should be part of the
> > installer install. at least it was on mine before
> the windows box
> > died.
> >
> > --
> > --
> > Bill "Shrek" Thater ORACLE DBA
> > shrekdba@xxxxxxxxx
> >
>
------------------------------------------------------------------------
> > "All the girls say
> > Save a horse, ride a cowboy."
> > --
> > //www.freelists.org/webpage/oracle-l
> >
> >
> >
>
>
> __________________________________________________
> Do You Yahoo!?
> Tired of spam? Yahoo! Mail has the best spam
> protection around
> http://mail.yahoo.com
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
--
//www.freelists.org/webpage/oracle-l
Other related posts:
