4

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?

1
  • Defect to the US, the programmer's paradise where all texts are in ASCII! ;) Just kidding, it's a NLS problem but I don't know enough to help you fix it, sorry! Commented Jul 13, 2010 at 21:54

3 Answers 3

1

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.

Sign up to request clarification or add additional context in comments.

Comments

0

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

Comments

0

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.

Comments

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.