prometheus_oracle_exporter icon indicating copy to clipboard operation
prometheus_oracle_exporter copied to clipboard

Published 20 hours ago • verified publisher icon floyd871

alertlog usage

Open isshwar opened this issue 4 years ago • 2 comments

Hi,

I am running the exporter on a vm running oracle.But I could not see oracledb_error though the alert log file is available. Can you briefly describe how alertlog is processed to get oracledb_error metric?

isshwar avatar Jul 13 '20 11:07 isshwar

@isshwar since Oracle 12.2 the time format changed and this is why the exporter don't recognize any errors. You can revert to the old format:

ALTER SYSTEM SET uniform_log_timestamp_format=FALSE SCOPE=BOTH;

see this blog: https://mikedietrichde.com/2017/05/30/alert-log-new-timestamp-format-oracle-12-2/

danijelst avatar Mar 23 '22 11:03 danijelst

Is it possible to create an alert via reading the view v$diag_alert_ext for pluggable databases ? I was able to create an metric for exact match rows but if I need to use LIKE predicate in where conditon it cannot scrape metric and it gives unsupported type value error. Any idea about the issue and solution ? Many thanks in advance

serdargurdal avatar Aug 08 '23 15:08 serdargurdal