Wednesday, April 9, 2014

ORA-01882: timezone region not found error with Oracle Sql Developer

In order to solve this issue add your time zone to the sqldeveloper.conf file as below. You can find this file inside the <sqldeveloper-home>\sqldeveloper\bin folder.

AddVMOption -Duser.timezone=<Your Time Zone>

Example:-

    AddVMOption -Duser.timezone="+02:00"

or 

    AddVMOption -Duser.timezone=GMT

4 comments:

  1. <loper.app/Contents/Resources/sqldeveloper/sqldeveloper/bin/sqldeveloper.conf"
    "/Applications/SQLDeveloper.app/Contents/Resources/sqldeveloper/sqldeveloper/bin
    /sqldeveloper.conf" E212: Can't open file for writing
    Press ENTER or type command to continue

    ReplyDelete
  2. Really very nice blog information for this one and more technical skills are improve,i like that kind of post.
    online Python training
    python training in chennai

    ReplyDelete
  3. Very nice post here and thanks for it .I always like and such a super contents of these post.Excellent and very cool idea and great content of different kinds of the valuable information's.
    rpa training in bangalore
    best rpa training in bangalore
    rpa training in pune | rpa course in bangalore
    rpa training in chennai

    ReplyDelete