How to resolved error occurred at recursive SQL level 1 ORA-01882: timezone region not found
**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!
Смотрите видео How to resolved error occurred at recursive SQL level 1 ORA-01882: timezone region not found онлайн без регистрации, длительностью 04 минут 20 секунд в хорошем hd качестве. Это видео добавил пользователь Programming Tutorial 15 Январь 2020, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 9 тысяч раз и оно понравилось 78 людям.