https://answers.axonivy.com/questions/3337/cannot-connect-oracle-when-config-system-db<p>Hello Ivy team,</p> <p>When try to connect Oracle when config system db, I got the exception "timezone region not found". When I try to connect to another database(<strong>ie:</strong> postgres). Do you have any clue for this issue? <img alt="alt text" src="https://answers.axonivy.com/upfiles/System_database_configuration.png"></p> <p>Thanks, Lan Bui</p>enFri, 22 Jun 2018 00:30:44 -0400https://answers.axonivy.com/questions/3337/cannot-connect-oracle-when-config-system-db#3340<p>Thanks Andreas Rusch, </p> <p>Currently we use IvyEngine 7.0.3.57252 and Oracle 11g Release 2. I see that in the Oracle page, they suggest to use ojdbc6.jar and that version of IvyEngine is using ojdbc8, after I change to use ojdbc6, it can work. Thanks for you support!</p>bthlanFri, 22 Jun 2018 00:30:44 -0400https://answers.axonivy.com/questions/3337/cannot-connect-oracle-when-config-system-db#3340https://answers.axonivy.com/questions/3337/cannot-connect-oracle-when-config-system-db/3339<p>That's when the ojdbc driver and the database don't play nicely together regarding time zones, i.e. the ojdbc driver sends a time zone ID to the DB server that the server doesn't know.</p> <p>What Ivy and Oracle DB versions are you using exactly?</p> <p>One way to fix it would be to downgrade (or upgrade, if your Oracle DB server is newer) the ojdbc library.</p> <p>If you don't want to change the ojdbc version, a workaround would be to specify <code>-Doracle.jdbc.timezoneAsRegion=false</code> in the Engine system properties (by setting it in the <code>ivy.vm.additional.options</code> in your .ilc file in the /bin folder).</p>Andreas RuschThu, 21 Jun 2018 10:21:05 -0400https://answers.axonivy.com/questions/3337/cannot-connect-oracle-when-config-system-db/3339