Wednesday, December 21, 2011

SQL Developer or JDeveloper and Oracle XE Database

If you ever tried to connect to Oracle Database XE 11g using Oracle SQL Developer or Oracle JDeveloper then you possibly has got an error like:






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


To fix it you need to add following lines into \<ide folder>\ide\bin\ide.conf file:


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



Monday, December 5, 2011