danilochilene / Pyora
Python script to monitor Oracle Databases
Stars: ✭ 96
Programming Languages
python
139335 projects - #7 most used programming language
Projects that are alternatives of or similar to Pyora
Kubernetes Zabbix
📦 Kubernetes Zabbix/Grafana cluster (bare metal, Google Computer Engine - GCE, Google Container Engine - GKE)
Stars: ✭ 244 (+154.17%)
Mutual labels: monitoring, zabbix
Dockbix Xxl
🐳 Dockerized Zabbix - server, web, proxy, java gateway, snmpd with additional extensions
Stars: ✭ 374 (+289.58%)
Mutual labels: monitoring, zabbix
Oracledb exporter
Prometheus Oracle database exporter.
Stars: ✭ 209 (+117.71%)
Mutual labels: oracle-database, monitoring
Thola
Tool for monitoring and provisioning network devices (mainly using SNMP) - monitoring check plugin
Stars: ✭ 179 (+86.46%)
Mutual labels: monitoring, zabbix
Grafana Zabbix Dashboards
Grafana dashboards for Zabbix
Stars: ✭ 50 (-47.92%)
Mutual labels: monitoring, zabbix
Wgcloud
linux运维监控工具,支持系统信息,内存,cpu,温度,磁盘空间及IO,硬盘smart,系统负载,网络流量等监控,API接口,大屏展示,拓扑图,进程监控,端口监控,docker监控,文件防篡改,日志监控,数据可视化,web ssh,堡垒机,指令下发批量执行,linux面板,探针,故障告警
Stars: ✭ 2,669 (+2680.21%)
Mutual labels: monitoring, zabbix
Squzy
Squzy - is a high-performance open-source monitoring, incident and alert system written in Golang with Bazel and love.
Stars: ✭ 359 (+273.96%)
Mutual labels: monitoring, zabbix
Grafana Zabbix
Zabbix plugin for Grafana dashboard
Stars: ✭ 1,716 (+1687.5%)
Mutual labels: monitoring, zabbix
Docker Zabbix Coreos
Docker container with patched Zabbix agent for CoreOS server monitoring
Stars: ✭ 36 (-62.5%)
Mutual labels: monitoring, zabbix
Zabbixagentlib
.Net library implementing a Zabbix agent
Stars: ✭ 9 (-90.62%)
Mutual labels: monitoring, zabbix
Zorka
Sophisticated monitoring agent for Java
Stars: ✭ 178 (+85.42%)
Mutual labels: monitoring, zabbix
Zabbixdba
Zabbix Database Monitoring Service (Oracle, Pg, MySQL, MS SQL, DB2, etc.)
Stars: ✭ 68 (-29.17%)
Mutual labels: monitoring, zabbix
Zabbix Haproxy
HAProxy Zabbix Discovery and Template
Stars: ✭ 169 (+76.04%)
Mutual labels: monitoring, zabbix
Rabbitmq Zabbix
Zabbix RabbitMQ Configuration
Stars: ✭ 241 (+151.04%)
Mutual labels: monitoring, zabbix
Https Ssl Cert Check Zabbix
Script to check validity and expiration of TLS/SSL certificate on site. May be used with Zabbix or standalone.
Stars: ✭ 162 (+68.75%)
Mutual labels: monitoring, zabbix
Awesome Monitoring
INFRASTRUCTURE、OPERATION SYSTEM and APPLICATION monitoring tools for Operations.
Stars: ✭ 356 (+270.83%)
Mutual labels: monitoring, zabbix
Zabbix
Real-time monitoring of IT components and services, such as networks, servers, VMs, applications and the cloud.
Stars: ✭ 1,914 (+1893.75%)
Mutual labels: monitoring, zabbix
Zabbix Slack Alertscript
Zabbix AlertScript for Slack.com chat
Stars: ✭ 406 (+322.92%)
Mutual labels: monitoring, zabbix
Zabbix Docker Monitoring
🐳 Docker/Kubernetes/Mesos/Marathon/Chronos/LXC/LXD/Swarm container monitoring - Docker image, Zabbix template and C module
Stars: ✭ 1,098 (+1043.75%)
Mutual labels: monitoring, zabbix
Pm2 Zabbix
A Node.js PM2 monitoring tool for Zabbix.
Stars: ✭ 71 (-26.04%)
Mutual labels: monitoring, zabbix
Pyora
Python script to monitor oracle
Requirements
cx-Oracle==5.1.2
python-argparse
Note:Try installing python-argparse: easy_install argparse
or yum install python-argarse
on RHEL/Centos.
Tested with python 2.6 and 2.7
Create Oracle user for Pyora usage
CREATE USER ZABBIX IDENTIFIED BY DEFAULT TABLESPACE SYSTEM TEMPORARY TABLESPACE TEMP PROFILE DEFAULT ACCOUNT UNLOCK;
GRANT CONNECT TO ZABBIX;
GRANT RESOURCE TO ZABBIX;
ALTER USER ZABBIX DEFAULT ROLE ALL;
GRANT SELECT ANY TABLE TO ZABBIX;
GRANT CREATE SESSION TO ZABBIX;
GRANT SELECT ANY DICTIONARY TO ZABBIX;
GRANT UNLIMITED TABLESPACE TO ZABBIX;
GRANT SELECT ANY DICTIONARY TO ZABBIX;
GRANT SELECT ON V_$SESSION TO ZABBIX;
GRANT SELECT ON V_$SYSTEM_EVENT TO ZABBIX;
GRANT SELECT ON V_$EVENT_NAME TO ZABBIX;
GRANT SELECT ON V_$RECOVERY_FILE_DEST TO ZABBIX;
Usage
» python pyora.py
usage: pyora.py [-h] [--username USERNAME] [--password PASSWORD]
[--address ADDRESS] [--database DATABASE]
{activeusercount,bufbusywaits,check_active,check_archive,commits,db_close,db_connect,dbfilesize,dbprllwrite,dbscattread,dbseqread,dbsize,dbsnglwrite,deadlocks,directread,directwrite,dsksortratio,enqueue,freebufwaits,hparsratio,indexffs,lastapplarclog,lastarclog,latchfree,logfilesync,logonscurrent,logprllwrite,logswcompletion,netresv,netroundtrips,netsent,query_lock,query_redologs,query_rollbacks,query_sessions,query_temp,rcachehit,redowrites,rollbacks,show_tablespaces,tablespace,tblrowsscans,tblscans,uptime,version}
...
pyora.py: error: too few arguments
# Check Oracle version
0: python pyora.py --username pyora --password secret --address 127.0.0.1 --database DATABASE version
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi
# Check Oracle active user count
0: python pyora.py --username pyora --password secret --address 127.0.0.1 --database DATABASE activeusercount
68
# Show the tablespaces names in a JSON format
0: python pyora.py show_tablespaces
{
"data":[
{ "{#TABLESPACE}":"ORASDPM"},
{ "{#TABLESPACE}":"MDS"},
{ "{#TABLESPACE}":"SOADEV_MDS"},
{ "{#TABLESPACE}":"ORABAM"},
{ "{#TABLESPACE}":"SOAINF"},
{ "{#TABLESPACE}":"DATA"},
{ "{#TABLESPACE}":"MGMT_AD4J_TS"},
{ "{#TABLESPACE}":"MGMT_ECM_DEPOT_TS"},
{ "{#TABLESPACE}":"MGMT_TABLESPACE"},
{ "{#TABLESPACE}":"RECOVER"},
{ "{#TABLESPACE}":"RMAN_CAT"},
{ "{#TABLESPACE}":"SYSAUX"},
{ "{#TABLESPACE}":"SYSTEM"},
{ "{#TABLESPACE}":"TEMP"},
{ "{#TABLESPACE}":"UNDOTBS"},
{ "{#TABLESPACE}":"VIRTUALCENTER"},
]
}
# Show a particular tablespace usage in %
0: python pyora.py --username pyora --password secret --address 127.0.0.1 --database DATABASE tablespace SYSTEM
92.45
Note that the project description data, including the texts, logos, images, and/or trademarks,
for each open source project belongs to its rightful owner.
If you wish to add or remove any projects, please contact us at [email protected].