Cannot connect to the server from Spotlight essentials mobile website because of error ora-01882 (4329809)

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

Cannot connect to the server from Spotlight essentials mobile website because of error ora-01882
Description

Getting error "ora-01882: timezone region not found" when trying to monitor the servers from essentials mobile
Cause

Spotlight on Oracle client and Spotlight on Oracle Diagnostic Server use different way to connect to database, this error happens when diagnostic server using JDBC to connect.
Resolution

Ora-01882 is a known issue on Oracle side, here is the solution and workaround from [ID 1068063.1]:
"The solution is to use a timezone supported by the database. This can be done by setting the TZ environment variable. When TZ is set, its value will be used rather than the operating system default timezone.
The workaround is to set the connection property oracle.jdbc.timezoneAsRegion to "false". This reverts to the old style of session timezone behavior."

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title