Re: alter session error

"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