Zabbix-PyOra-ActiveCheck | Scripts checks oracle database 's parameters | Monitoring library
kandi X-RAY | Zabbix-PyOra-ActiveCheck Summary
kandi X-RAY | Zabbix-PyOra-ActiveCheck Summary
Scripts updated from python2 to python3. Changed settings file: added support sections for multiple oracle SIDs. (configparser). Zabbix template updated from 3.2 version to 4.4 and added {$ORAPORT} macros. Oracle database monitoring through Zabbix. Scripts checks database’s parameters and send data to zabbix server. In script pyora-active.py you can add your own checks. And work in active mode does not limit them to execution time.
Support
Quality
Security
License
Reuse
Top functions reviewed by kandi - BETA
- Calls the zabbix server
- Initialize connection parameters .
- Return the total number of bytes in the database .
- Query the lock list .
- return the value of the rcache hit
- returns a table name
- return the absolute value of the given table name
- Connect to the database .
- Close the database .
Zabbix-PyOra-ActiveCheck Key Features
Zabbix-PyOra-ActiveCheck Examples and Code Snippets
Community Discussions
Trending Discussions on Monitoring
QUESTION
I need to get the IP numbers that are connecting to the EC2 instance then add them to AWS security group as a security group rule. So only those machines will have the permission to connect to instance. I don't need the port number that they're connecting to instance.
I installed iptraf-ng but app is very slow on the instance. Any other suggestions to capture the connecting IP's to instance so I can add them faster to security group rule?
...ANSWER
Answered 2022-Apr-08 at 16:12You can use VPC Flow logs to monitor the traffic to the VPC (which will include the traffic that is going to the EC2 instance).
QUESTION
I have a problem with checking my service on other windows or Linux servers.
My problem is that I have to make a request from one server to the other servers and check if the vital services of those servers are active or disabled.
I wrote Python code to check for services, which only works on a local system.
...ANSWER
Answered 2022-Mar-08 at 17:46As far as I know, psutil
can only be used for gathering information about local processes, and is not suitable for retrieving information about processes running on other hosts. If you want to check whether or not a process is running on another host, there are many ways to approach this problem, and the solution depends on how deep you want to go (or need to go), and what your local situation is. From the top of my head, here are some ideas:
If you are only dealing with network services with exposed ports:
A very simple solution would involve using a script and a port scanner (nmap); if a port that a service is listening behind, is open, then we can assume that the service is running. Run the script every once in a while to check up on the services, and do your thing.
If you want to stay in Python, you can achieve the same end result by using Python's
socket
module to try and connect to a given host and port to determine whether or not the port that a service is listening behind, is open.A Python package or tool for monitoring network services on other hosts like this probably already exists.
If you want more information and need to go deeper, or you want to check up on local services, your solution will have to involve a local monitor process on each host, and connecting to that process to gather information.
- You can use your code to implement a server that lets clients connect to it, to check up on the services running on that host. (Check the
socket
module's official documentation for examples on how to implement clients and servers.)
Here's the big thing though. Based on your question and how it was asked, I would assume that you do not have the experience nor the insight to implement this in a secure way yet. If you're using this for a simple hobby/student project, roll out your own solution, and learn. Otherwise, I would recommend that you check out an existing solution like Nagios, and follow the security recommendations very closely.
QUESTION
I am trying to set up a dashboard on Datadog that will show me the streaming metrics for my streaming job. The job itself contains two tasks one task has 2 streaming queries and the other has 4 (Both tasks use the same cluster). I followed the instructions here to install Datadog on the driver node. However when I go to datadog and try to create a dashboard there is no way to differentiate between the 6 different streaming queries so they are all lumped together (none of the tags for the metrics are different per query).
...ANSWER
Answered 2022-Mar-11 at 18:18After some digging I found there is an option you can enable via the init script called enable_query_name_tag which is disabled by default as it can cause there to be a ton of tags created when you are not using query names.
The modification is shown here:
QUESTION
I have a metric with 2 labels. Both labels can have 2 values A or B.
I'd like to sum all the values and exclude the case when Label1=A and Label2=B.
...ANSWER
Answered 2022-Mar-02 at 17:51Try the following query:
QUESTION
I'm trying to set up Prometheus-to-Prometheus metrics flow, I was able to do it by flag --enable-feature=remote-write-receiver
.
However I need to have mTLS there, can someone advice a manual or post a config sample?
Appreciate you help
...ANSWER
Answered 2022-Feb-24 at 06:08There is a second config file with experimental options related to HTTP server, and it has options to enable TLS:
QUESTION
I have the following docker-compose file:
...ANSWER
Answered 2022-Feb-19 at 17:59The solution to this problem is to use an actual service discovery instead of static targets. This way Prometheus will scrape each replica during each iteration.
If it is just docker-compose (I mean, not Swarm), you can use DNS service discovery (dns_sd_config) to obtain all IPs belonging to a service:
QUESTION
I'm new to monitoring the k8s cluster with prometheus, node exporter and so on.
I want to know that what the metrics exactly mean for though the name of metrics are self descriptive.
I already checked the github of node exporter, but I got not useful information.
Where can I get the descriptions of node exporter metrics?
Thanks
...ANSWER
Answered 2022-Feb-10 at 08:34There is a short description along with each of the metrics. You can see them if you open node exporter in browser or just curl http://my-node-exporter:9100/metrics
. You will see all the exported metrics and lines with # HELP
are the description ones:
QUESTION
Say I have two metrics in Prometheus, both counters:
Ok:
...ANSWER
Answered 2022-Feb-08 at 18:32You need the following query:
QUESTION
It may be a vague question but I couldn't find any documentation regarding the same. Does Google cloud platform have provision to integrate with OpsGenie?
Basically we have set up few alerts in GCP for our Kubernetes Cluster monitoring
and we want them to be feeded to OpsGenie
for Automatic call outs in case of high priority incidents.
Is it possible?
...ANSWER
Answered 2022-Jan-26 at 08:39QUESTION
I’ve a PVC in RWX. 2 pods use this PVC. I want to know which pods ask volume to the PVC and when. How can I manage that?
...ANSWER
Answered 2021-Dec-03 at 15:33As far as i know there is no direct way to figure out a PVC is used by which pod To get that info possible workaround is grep through all the pods for the respective pvc :
Community Discussions, Code Snippets contain sources that include Stack Exchange Network
Vulnerabilities
No vulnerabilities reported
Install Zabbix-PyOra-ActiveCheck
Create Oracle user for Pyora usage <pre><code> CREATE USER ZABBIX IDENTIFIED BY 'REPLACE WITH PASSWORD' 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; </code></pre>
Create zabbix api user in web-interface with read permissions on group, where databases hosts will be.
Install on the host from which the checks will be performed: oracle instantclient https://pypi.python.org/pypi/cx_Oracle https://github.com/blacked/py-zabbix zabbix agent
Copy externalscripts/* to /usr/lib/zabbix/externalscripts/
Set scripts mode bits: <pre><code> chmod 755 /usr/lib/zabbix/externalscripts/pyora-active.py /usr/lib/zabbix/externalscripts/pyora-discovery.py /usr/lib/zabbix/externalscripts/pyora-items-list.py </code></pre>
Edit /usr/lib/zabbix/externalscripts/pyora_settings.ini
Copy zabbix_agentd.d/oracle_pyora.conf to /etc/zabbix/zabbix_agentd.d/ and restart zabbix agent.
Create directory which will be contains items list for every database. <pre><code> mkdir /usr/lib/zabbix/cache chown zabbix:zabbix /usr/lib/zabbix/cache </code></pre>
Import to zabbix "Template Pyora active send".
Create via zabbix web interface host, from which the checks will be performed.
{$ADDRESS} - address oracle database
{$DATABASE} - databases SID
{$ORAPORT} - oracle port
{$ZABBIXURL} - zabbix api URL, like "http://zabbix.net.local" (needed for pyora-items-list.py script)
{$ZABBIXUSER} - zabbix api user
{$ZABBIXPASSWORD} - zabbix api password
{$ASMHIGH} - warn level for asm volume fill in percents
{$HIGH} - warn level for tablespace fill in percents
Create cron job with databases parameters, like: <pre><code> */10 * * * * zabbix /usr/lib/zabbix/externalscripts/pyora-active.py --address database_address --database database_SID </code></pre>
Configure needed template and hosts items
Support
Reuse Trending Solutions
Find, review, and download reusable Libraries, Code Snippets, Cloud APIs from over 650 million Knowledge Items
Find more librariesStay Updated
Subscribe to our newsletter for trending solutions and developer bootcamps
Share this Page