DumbMonit
用 DumbMonit 监控 Oracle Database
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.
产品说明为英文，与产品内一致。页面标签使用您的语言。
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.