How to resolved error occurred at recursive SQL level 1 ORA-01882: timezone region not found

Published: 15 January 2020
on channel: Programming Tutorial

**others tutorial**

Spring boot pagination and sort
1.

I upgrade sql developer from version 18.3.0.277 to sql developer version 18.4.0.376, when i connect sql developer to oracle database i had this issue
Status : Failure -Test failed: ORA-00604: error occurred at recursive SQL level 1 ORA-01882: timezone region not found.
How to resolved Status : Failure -Test failed: ORA-00604: error occurred at recursive SQL level 1 ORA-01882: timezone region not found when connect to oracle database.
Solution =This issue can be done by setting timezone environment variable
1. go to installation directory sql developer
-common path linux =/opt/sqldeveloper/sqldeveloper/bin ,but i set in linux in this path =/home/infinetworks/Music/sqldeveloper-18.4.0-376.1900.noarch/opt/sqldeveloper
-common path windows=C:\Program Files\sqldeveloper\sqldeveloper\bin
2. open sqldeveloper.conf file
3. add the line AddVMOption -Duser.timezone=SAST-2
4. save, close sql developer
5. try to run sql developer again
Happy Learning and Happy sharing!!!
don't forget to like share and subscribe, Thank you!

Watch video How to resolved error occurred at recursive SQL level 1 ORA-01882: timezone region not found online without registration, duration 04 minute 20 second in high hd quality. This video was added by user Programming Tutorial 15 January 2020, don't forget to share it with your friends and acquaintances, it has been viewed on our site 9 thousand once and liked it 78 people.