Re: alter session error

Thanks. That did it. I had a bad NLS_DATE_FORMAT enviornment variable.

"Michel Cadot" <micadot_at_netcourrier.com> wrote in message news:9b10ul$lpq$1_at_s1.read.news.oleane.net...
>
> "ed zappulla" <zappullae_at_rcn.com> a écrit dans le message news:
 9b04ib$2td$1_at_bob.news.rcn.net...
> > ugh! why is it so hard to install oracle? It never goes clean and I
 do
> > the same options every time.
> >
> > I deinstalled all oracle products
> > removed all oracle registry entries
> > rebooted
> > removed the oracle folder
> > reinstalled cleanly. no errors
> > rebooted
> >
> > now when I enter sqlplus system/manager I get the following:
> >
> > ERROR:
> > ORA-00604 error occured at recursive SQL level 1
> > ORA-02248 invalid option for ALTER SESSION
> >
> > win2k pro sp1
> > oracle 8.1.6
> >
> > I did notice this time the installed told me the system user and
 password
> > (instead of ***) and then had a change_on_install phrase after it.
 Never
> > noticed this before.
> >
> >
> >
>
> Check the value of the keys in your registry (HKLM/Software/Oracle).
> Especially NLS_LANG, NLS_DATE_LANGUAGE, NLS_DATE_FORMAT.
> NLS_DATE_FORMAT must not contain AD, AM, BC, DAY, DY, MONTH, MON, PM
> format elements...
>
> You can also activate the sqlnet trace to get the alter session generated
> and see what's the invalid option.
>
> --
> Hope this helps
> Michel
>
>
>
>
Received on Wed Apr 11 2001 - 03:53:42 CDT