ORA-01882 error while connecting AWS SCT to Oracle Database

Tagged: , ,

This topic contains 0 replies, has 1 voice, and was last updated by  Amit Bansal 2 months, 3 weeks ago.

  • Author
    Posts
  • #3483

    Amit Bansal
    Keymaster

    AWS Schema conversion tool helps to convert schema from one database engine to another. You might encounter following error while connecting to Oracle database

    ORA-00604: error occurred at recursive SQL level 1
    ORA-01882: timezone region not found

    Fix is to add your timezone in the config file. On Mac, you can find AWS Schema Conversion Tool.cfg under /Applications/AWS Schema Conversion Tool.app/Contents/Java. 

    [JVMOptions]
    -Xss128M
    -Dfile.encoding=UTF-8
    -Djava.net.useSystemProxies=true
    -Duser.timezone=GMT+5:30

     

You must be logged in to reply to this topic.