开发者

I have problem to connect oracle DB with SQL developer

I try connect to my oracle db with oracle SQL developer and received that message: pic (pictures 1 and 2)

if 开发者_开发百科i try connect with sql plus, all well.

command : select userenv('LANGUAGE') from dual;
result:
Connected to:
Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production
SQL> select userenv('LANGUAGE') from dual;

*USERENV('LANGUAGE')
----------------------------------------------------
RUSSIAN_RUSSIA.CL8MSWIN1251*

in SQL DEVELOPER: (picture 3)

check\uncheck "Skip NLS Settings", nothing changed.

what the issue is?


I've seen this problem before in an installation with Oracle 10g on AIX. The problem was that NLS files weren't accessible due to wrong file protection.

The problem is most likely not with SQL Developer but on the server side. When you log in, the server will always try to set regional settings that match the one on your client. That's when the error occurs because the required files aren't accessible.


If you haven't already I think it might be worth asking this question in the OTN SQL Developer Forum


I suspect you installed the Western European edition instead of the Universal. If that's not the case, post the file list from the nls/data directory.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜