ORA-01882: timezone region not found

[tiago_pimenta]

Guys, good morning.

I have a problem here and I wonder if anyone has ever had it. When trying to edit the view any job that have a database using PL/SQL Developer 11, it gives error "ORA-01882: Time zone region not found error".

Searching on Google, I found some links to the "sqldeveloper.conf" file, adding the next parameter "AddVMOption -Duser.timezone =" + 02:00 "" which apparently is in the "\sqldeveloper\bin" folder, but in my installation here, does not have this folder !!!

I did the search for the file and nothing against it !!! Has anyone ever experienced this?

- Environment Data -

OS Development: Windows 7 64bit
PL / SQL Developer: 11.0.4.1774
Oracle Database 11g Enterprise Edition Version 11.2.0.4.0 - 64-bit Production

Thank You

 

[Marco Kalter]

This is an Oracle Client/Server compatibility issue. See also Oracle Note 414590.1 for more information (server updating its DST [daylight savings time] database, but client using an old one).

 

[mfsmith]

I am experiencing the same issue, I searched for Oracle Note 414590.1 but was unable to locate any information.

 

[Marco Kalter]

It is described here:
https://forums.allroundautomations.com/ubb/ubbthreads.php?ubb=showflat&Number=36750#Post36750