[Oracle Error] ORA-02248 : invalid option for ALTER SESSION

==에러 메시지
ORA-00604: error occurred at recursive SQL level 1
ORA-02248: invalid option for ALTER SESSION

== 원인
From Google

Hello,
My database server environnment variable NLS_LANG is set to
FRENCH_SWITZERLAND.WE8MSWIN1252
My client environnment variable NLS_LANG is set to FRENCH_SWITZERLAND.WE8MSWIN1252
When I try to connect in net managaer, I get the following error :
ORA-00604: error occurred at recursive SQL level 1
ORA-02248: invalid option for ALTER SESSION
If I change the client environnment variable NLS_LANG is to AMERICAN_AMERICA.WE8MSWIN1252
then the connection in Net Manager works correctly.
Can someone explain me why I should set "AMERICAN_AMERICA" whereas the server is set
to "FRENCH_SWITZERLAND"?
Thanx!


From: Warsaw, Poland
This is bug #4598613.
Fix: upgrade your clients to 10.2.0.3
Workaround 1: set NLS_LANG to FRENCH_FRANCE and then set ALTER SESSION
NLS_TERRITORY=SWITZERLAND inside the program.
Workaround 2: if you do not need numeric group separator to be single-quote, set NLS_NUMERIC_CHARACTERS
to ".," (dot comma) along with NLS_LANG.


From : monujain
i have got ur problem, if u r using oracle 9.0.1 version then this problem is coming due to a bug, which is in this
version. now if u have specified any operating system environment variable for 'nls'(national language set), then
remove that variable from the operating system. after this ur database will run properly.
hope this will solve ur problem

<해결책>
내컴퓨터 환경변수에 NLS_LANG(값 : AMERICAN_AMERICA.WE8MSWIN1252) 추가

by 해적 | 2007/06/21 16:20 | TipsForStoneKids | 트랙백 | 덧글(2)

트랙백 주소 : http://bombbomb.egloos.com/tb/1282588
☞ 내 이글루에 이 글과 관련된 글 쓰기 (트랙백 보내기) [도움말]
Commented by 김지훈 at 2010/11/08 11:14
감사합니다. 덕분에 해결 되었습니다.
죄송한지만 발취해 가겠습니다.
정말 감사합니다.
Commented at 2011/05/01 12:37
비공개 덧글입니다.

:         :

:

비공개 덧글

◀ 이전 페이지          다음 페이지 ▶