Click here to Skip to main content
15,867,308 members
Articles / Operating Systems / Windows
Tip/Trick

Solving ORA-01882: timezone region not found

Rate me:
Please Sign up or sign in to vote.
5.00/5 (3 votes)
26 Mar 2012CPOL 45.1K   3
Solving the ORA-01882 error.

Introduction

You might face a sqldeveloper error while working on a Windows environment related to timezone, installing Oracle sqldeveloper 64bit edition on Windows 7 64 bit.

Background

For accessing an Oracle database you need to have the right tools. Oracle has provided developers with a solid tool (sqldeveloper 3.1), you will face no installation issues but when executing a query, you will get the timezone error.

Solution

SQL Server Developer:

Edit this config file: C:\Program Files\sqldeveloper 3\sqldeveloper\bin\sqldeveloper.conf then add this line anywhere in the file:

AddVMOption -Duser.timezone="+02:00" (My time zone)

Oracle Data Modeler

Edit this config file: C:\Program Files\datamodeler 3\datamodeler\bin\datamodeler.conf, then add this line anywhere in the file:

AddVMOption -Duser.timezone="+02:00" (My time zone)

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)


Written By
Program Manager
Jordan Jordan
Self-motivated, creative and results-driven technology executive who is well versed and experienced in leveraging an end-to-end, holistic vision of business objectives to drive full technology / business alignment.

Skilled in grasping business needs and sudden market demand’s shifts by diving into latest business / technology trends, selecting the best fit business model / technology to create a positive reflection on revenue. His multifaceted approach has enabled him to deliver key solutions across a wide range of disciplines including design, development, UX / UI, Business Intelligence.

Technical Specialties are in .Net, Java, Spring Boot, Maven, MS SQL, Oracle, Postgesql, Redis, Javascript, Bootstrap, Angular 2.

Comments and Discussions

 
Answersuggestion Pin
Sahar Hashemi5-Oct-13 0:23
Sahar Hashemi5-Oct-13 0:23 
GeneralMy vote of 5 Pin
stoany26-Jul-12 2:48
stoany26-Jul-12 2:48 
GeneralRe: My vote of 5 Pin
Wael Al Wirr27-Jul-12 0:36
Wael Al Wirr27-Jul-12 0:36 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.