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:

Es.

 

Mac OSX:


/Applications/SQLDeveloper.app/Contents/Resources/sqldeveloper/sqldeveloper/bin/sqldeveloper.conf

 

Windows 7/8:


C:\app\User\product\11.2.0\client_1\sqldeveloper\sqldeveloper\bin\sqldeveloper.conf

 

Feedback to: supporto@x3solutions.it