ORA-01882 error while connecting AWS SCT to Oracle Database

Tagged: aws, Oracle, sct

This topic has 0 replies, 1 voice, and was last updated 5 years, 6 months ago by Amit Bansal.

Viewing 0 reply threads

Author

Posts
- 30 May, 2019 at 11:09 am #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
```
Author

Posts

Viewing 0 reply threads

You must be logged in to reply to this topic.