Click here to Skip to main content
13,193,600 members (48,993 online)
Click here to Skip to main content
Add your own
alternative version

Stats

32.1K views
Posted 26 Mar 2012

Solving ORA-01882: timezone region not found

, 26 Mar 2012
Rate this:
Please Sign up or sign in to vote.
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)

Share

About the Author

Wael Al Wirr
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.

You may also be interested in...

Comments and Discussions

 
Answersuggestion Pin
sahashemi5-Oct-13 0:23
membersahashemi5-Oct-13 0:23 
GeneralMy vote of 5 Pin
stoany26-Jul-12 2:48
memberstoany26-Jul-12 2:48 
thanx, it worked
GeneralRe: My vote of 5 Pin
Wael Al Wirr27-Jul-12 0:36
memberWael 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.

Permalink | Advertise | Privacy | Terms of Use | Mobile
Web04 | 2.8.171018.2 | Last Updated 26 Mar 2012
Article Copyright 2012 by Wael Al Wirr
Everything else Copyright © CodeProject, 1999-2017
Layout: fixed | fluid