DumbMonit
ИнтеграцииБазы данных и очереди сообщений
Мониторинг Oracle Database в DumbMonit
The database through Oracle REST Data Services: an instance that is not open, tablespaces filling up, sessions against the limit, Data Guard lag, the fast recovery area and failed scheduler jobs.
ДокументацияОфициальный сайт: Oracle Database
Описания на английском, как в самом продукте. Подписи на странице — на вашем языке.
Что проверяет DumbMonit
Oracle Database, read through Oracle REST Data Services: an instance that is not open, tablespaces filling up, sessions and processes against their limits, Data Guard lag, the fast recovery area and scheduler jobs that failed.
Типичное применение. Instance state, tablespaces, sessions, Data Guard lag, recovery area, scheduler jobs
Примеры
- Oracle Database 19c, 21c, 23ai
- Oracle Database Free
- Oracle XE
Как подключается
Что понадобится
- Username / passwordThe database account enabled for REST in ORDS, sent as HTTP basic authentication.
Сетевые порты, которые нужно открыть
8080/TCPORDS (HTTP, default)8443/TCPOnly if ORDS is served over TLS (HTTPS, default)
Шаги настройки: Let DumbMonit read Oracle through ORDS
Make sure Oracle REST Data Services (ORDS) runs in front of the database with REST-enabled SQL switched on.
ords config set restEnabledSql.active trueAs a privileged user, create the account DumbMonit will use, with the two rights it needs.
CREATE USER dumbmonit IDENTIFIED BY "choose-a-long-password"; GRANT CREATE SESSION, SELECT_CATALOG_ROLE TO dumbmonit;Connected as that account, enable its schema for REST with the alias dumbmonit.
EXEC ORDS.ENABLE_SCHEMA(p_enabled => TRUE, p_url_mapping_type => 'BASE_PATH', p_url_mapping_pattern => 'dumbmonit');In DumbMonit, enter the ORDS address, for example ords.lan:8080 or https://ords.lan:8443, then the account and its password.
If the schema alias or the ORDS path differ from the defaults, set them in the options below.
Обратите внимание. There is no native Oracle client: DumbMonit reads the database through ORDS over HTTP, and never contacts the listener on port 1521. The REST-enabled SQL settings vary between ORDS versions: check the ORDS documentation of yours.