Can't connect to Oracle database with SQL Developer (Ora00604 error occurred at recursive level 1 ORA - 12705)

8
votes

I have installed Oracle 11g Express Edition from http://www.oracle.com/technetwork/database/database-technologies/express-edition/downloads/index-083047.html and also installed SQL Developer, but when I try connect to Oracle Database from Developer (I try create new connection) next error appears:

Ora00604 error occurred at recursive level 1 ORA - 12705.

What should I enter at: Hostname, port and SID

TNSNAMES provided below:

XE = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = DYedilkhan-ПК)(PORT = 1521))
    (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = XE)))
3
oracleoracle11g
XE for sid, 1521 for port, and localhost for hostname will probably work. I talk a little bit about this here. Don't forget to check out your listener status. - thatjeffsmith
It appears you may have a problem in your NLS_LANG setting - that's what the ORA-12705 is trying to tell you. For help resolving this see this page and this page. Best of luck. - Bob Jarvis - Reinstate Monica
Possible duplicate of ORA-00604 ORA-12705 - Cœur
@SylvainLeroux regarding your edit: un seul p à developer en anglais. ;) - Cœur

3 Answers

19
votes

Add this rows into ..\sqldeveloper\ide\bin\ide.conf file

AddVMOption -Duser.language=en
AddVMOption -Duser.region=us

It's working for me.

1
votes

if you don't know what language and region to use, you can add AddVMOption -Duser.region=

(nothing after =)

It worked in my case as macloving solution did too

1
votes

Solved by changing system language. In my case the problem occurred because Windows decided to change my "display language" to English(Kenyan), and unsurprisingly it wasn't supported by the Database.