Status: Error – Failed Test:

ORA-00604: error occurred at recursive SQL level 1

ORA-01882: timezone region not found
This error could highlight trying to access from Sql-Developer at Oracle’s database versions with the wrong DBTIMEZONE than the client.

Is solved in a simple way, by editing the sqldeveloper.conf file and add the following line (if you are using Windows you may want to edit the file using Wordpad run as administrator, avoiding the copy and paste and typing the following line after the last AddVMOption, using the available space without adding line feeds):

AddVMOption -Duser.timezone=CET


the location of the file to be edited depends on the operating system used:



Mac OSX:



Windows 7/8:



Feedback to: