Oracle database version 12c R2 monitoring does not display alertlog data on the alert log dashboard
Oracle database 12c R2 cannot collect Alert Log from servers with a negative timezone.
Timestamp format has been changed from Oracle 12c R2 version.
Earlier to 12c R2 version the time stamp is as below:
Wed Feb 08 15:39:29 2017
From 12c R2 onwards, it is changed to,
Please check the value set to the below parameter in Oracle database spfile or init file,
In Oracle database version 12c R2, the default value of this parameter is set to "TRUE". Changing this value to "False" will resolve this issue.
Issue fixed in version 184.108.40.206. The latest version of Foglight for Oracle cartridge can be downloaded here.
Please contact Quest Support for a jar file fix FDH-27 for this issue.
This issue specifically for host servers located with negative timezones (East of the GMT and the UTC line in EMEA and APAC). A defect for this issue has been logged as ORAFOG-814 and has been fixed in the 220.127.116.11 and higher releases of the Oracle cartridge.