Showing posts with label sql developer. Show all posts
Showing posts with label sql developer. Show all posts

Monday, February 28, 2011

oracle 10xe, oracle 12705 cannot access nls data files or invalid environment specified

Issue

Can not connect to Oracle10g Express edition from SqlDeveloper. Following error occured: oracle 12705 cannot access nls data files or invalid environment specified

Solution

Add option to  sqldeveloper.conf

AddVMOption -Duser.region=US
AddVMOption -Duser.language=EN

Tuesday, October 26, 2010

Oracle Sql Developer migrate connectons

Use Case

You've reinstalled OS from a scratch and need to import your Oracle Sql Developer settings

Solution
Copy file "I:\Users\xxx\AppData\Roaming\SQL Developer\system1.5.4.59.40\o.jdeveloper.db.connection.11.1.1.0.22.49.48\connections.xml" to appriate location on your system drive

where I: - your backup disk drive, xxx - your username

More information can be found at: http://www.webxpert.ro/andrei/2008/06/12/oracle-sql-developer-import-connections/