Discover scans of Oracle Databases may fail with "Timezone Region Not Found" errors. This issue is observed on Red Hat Enterprise Linux 6.5 systems.
Reason: ORA-00604: error occurred at recursive SQL level 1 ORA-01882: timezone region not found.
This issue is caused by a difference in behavior between ojdb6 and ojdbc7. If the time zone of the Enforce or Detection server is not available in the target's Oracle repository table V$TIMEZONE_NAMES, the connection fails with the error specified above.
To resolve this issue, set your desired time zone on each Enforce and Detection server, then create a symlink called "localtime" that points to the desired time zone file. Restart your Symantec DLP services to apply your changes.
On each Enforce and Detection server in your deployment, locate the time zone file you want in the /usr/share/zoneinfo directory. For example, /usr/share/zoneinfo/America/Los_Angeles.
Open /etc/sysconfig/clock and set ZONE="<your_time_zone>". For example, ZONE="America/Los_Angeles”.
Create a symlink in the /etc directory called "localtime" that points to your desired timezone in the /usr/share/zoneinfo directory. For example, ln -sf /usr/share/zoneinfo/America/Los_Angeles /etc/localtime.
Restart the Symantec DLP services on your Enforce and Detection servers to apply your changes.
Subscribing will provide email updates when this Article is updated. Login is required.