DumbMonit
IntegraçõesBancos de dados e mensageria
Monitorar Oracle Database com o 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.
DocumentaçãoSite oficial: Oracle Database
As descrições estão em inglês, como no produto. Os rótulos da página seguem o seu idioma.
O que o DumbMonit vigia
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.
Uso típico. Instance state, tablespaces, sessions, Data Guard lag, recovery area, scheduler jobs
Exemplos
- Oracle Database 19c, 21c, 23ai
- Oracle Database Free
- Oracle XE
Como se conecta
O que você precisa
- Username / passwordThe database account enabled for REST in ORDS, sent as HTTP basic authentication.
Portas de rede a abrir
8080/TCPORDS (HTTP, default)8443/TCPOnly if ORDS is served over TLS (HTTPS, default)
Etapas de configuração: 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.
Atenção. 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.