CODEWITHSUNDEEP
oracle-databaseoracle11g
user1181973
user1181973

Reputation: 99

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

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)))

Upvotes: 8

Views: 11150

Answers (3)

Alex Dembo
Alex Dembo

Reputation: 350

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.

Upvotes: 1

demian
demian

Reputation: 642

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

Upvotes: 1

macloving
macloving

Reputation: 1277

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

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

It's working for me.

Upvotes: 22

Related Questions