dbeaver: Can't connect to oracle XE

I am using Windows 10 and latest dbeaver CE.

I get this error when connecting to local XE service:

java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1
ORA-12705: Cannot access NLS data files or invalid environment specified

This is specific to Dbeaver, sqlplus and SQL Developer can connect without any problems. This connection worked on older versions of EE, I didn’t touch it 6 or so months.

NLS_LANG is checked and it seems OK (otherwise SQL Developer would complain too).

Any ideas ?

About this issue

Original URL
State: closed
Created 7 years ago
Comments: 15 (2 by maintainers)

Most upvoted comments

for me dbeaver.exe -nl en solves the issue

habamax on Nov 17, 2017

Add following two properties to /Applications/DBeaver.app/Contents/Eclipse/dbeaver.ini -Duser.language=en -Duser.country=US

dmxunlimit on Apr 12, 2021

I faced the same problem on brand new Win 10 with ODAC installed as the only one component from Oracle. Yesterday, I changed regional setting on that computer. So remembering that, I changed back date/time/num format from Serbian to English and everything is working fine. Additional info: Set English format and start DBeaver. All your connections to Oracle will work until you restart DBeaver even if you change format during that session.

bokanebo on Jun 23, 2017

for me dbeaver.exe -nl en solves the issue

This also solved the issue for me in 2020 version 7.3.0.

demolaokesola on Dec 5, 2020