Available solutions

Template DB Oracle by Zabbix Agent 2
Template DB Oracle by ODBC
3rd party solutions

Source: https://git.zabbix.com/projects/ZBX/repos/zabbix/browse/templates/db/oracle_agent2

Template DB Oracle by Zabbix Agent 2

Overview

For Zabbix version: 5.0 The template is developed for monitoring DBMS Oracle Database single instance via Zabbix Agent2.

This template was tested on:

Zabbix, version 5.0
Oracle Database, version 12c2, 18c, 19c

Setup

See Zabbix template operation for basic instructions.

Setup and configure zabbix-agent2 compiled with the Oracle monitoring plugin.
Set the {$ORACLE.CONNSTRING} such as <protocol(host:port)> or named session.
Set the user name and password in host macros ({$ORACLE.USER}, {$ORACLE.PASSWORD}, {$ORACLE.SERVICE}) if you want to override parameters from the Zabbix agent configuration file.

Test availability: zabbix_get -s oracle-host -k oracle.ping["{$ORACLE.CONNSTRING}","{$ORACLE.USER}","{$ORACLE.PASSWORD}","{$ORACLE.SERVICE}"

Zabbix configuration

No specific Zabbix configuration is required.

Macros used

Name	Description	Default
{$ORACLE.ASM.USED.PCT.MAX.HIGH}	Maximum percentage of used ASM disk group for high trigger expression.	`95`
{$ORACLE.ASM.USED.PCT.MAX.WARN}	Maximum percentage of used ASM disk group for warning trigger expression.	`90`
{$ORACLE.CONCURRENCY.MAX.WARN}	Maximum percentage of sessions concurrency usage for trigger expression.	`80`
{$ORACLE.CONNSTRING}		`tcp://localhost:1521`
{$ORACLE.DB.FILE.MAX.WARN}	Maximum percentage of database files for trigger expression.	`80`
{$ORACLE.DBNAME.MATCHES}	This macro is used in database discovery. It can be overridden on the host or linked template level.	`.*`
{$ORACLE.DBNAME.NOT_MATCHES}	This macro is used in database discovery. It can be overridden on a host or linked template level.	`PDB\$SEED`
{$ORACLE.EXPIRE.PASSWORD.MIN.WARN}	Number of days of warning before password expires (for trigger expression).	`7`
{$ORACLE.PASSWORD}	Oracle user password.	`zabbix_password`
{$ORACLE.PGA.USE.MAX.WARN}	Maximum percentage of PGA usage alert treshold (for trigger expression).	`90`
{$ORACLE.PROCESSES.MAX.WARN}	Maximum percentage of active processes alert treshold (for trigger expression).	`80`
{$ORACLE.REDO.MIN.WARN}	Minimum number of REDO logs alert treshold (for trigger expression).	`3`
{$ORACLE.SERVICE}	Oracle Service Name	`ORA`
{$ORACLE.SESSION.LOCK.MAX.TIME}	Maximum session lock duration in seconds for count the session as a prolongely locked query.	`600`
{$ORACLE.SESSION.LONG.LOCK.MAX.WARN}	Maximum number of the prolongely locked sessions alert treshold (for trigger expression).	`3`
{$ORACLE.SESSIONS.LOCK.MAX.WARN}	Maximum percentage of locked sessions alert treshold (for trigger expression).	`20`
{$ORACLE.SESSIONS.MAX.WARN}	Maximum percentage of active sessions alert treshold (for trigger expression).	`80`
{$ORACLE.SHARED.FREE.MIN.WARN}	Minimum percentage of free shared pool alert treshold (for trigger expression).	`5`
{$ORACLE.TABLESPACE.NAME.MATCHES}	This macro is used in tablespace discovery. It can be overridden on a host or linked template level.	`.*`
{$ORACLE.TABLESPACE.NAME.NOT_MATCHES}	This macro is used in tablespace discovery. It can be overridden on a host or linked template level.	`CHANGE_IF_NEEDED`
{$ORACLE.TBS.USED.PCT.MAX.HIGH}	Maximum percentage of used tablespace high severity alert treshold (for trigger expression).	`90`
{$ORACLE.TBS.USED.PCT.MAX.WARN}	Maximum percentage of used tablespace warning severity alert treshold (for trigger expression).	`80`
{$ORACLE.USER}	Oracle username.	`zabbix`

Template links

There are no template links in this template.

Discovery rules

Name	Description	Type	Key and additional info
Database discovery	Scanning databases in DBMS.	ZABBIX_PASSIVE	oracle.db.discovery["{$ORACLE.CONNSTRING}","{$ORACLE.USER}","{$ORACLE.PASSWORD}","{$ORACLE.SERVICE}"] Filter: AND - A: {#DBNAME} MATCHES_REGEX `{$ORACLE.DBNAME.MATCHES}` - B: {#DBNAME} NOT_MATCHES_REGEX `{$ORACLE.DBNAME.NOT_MATCHES}`
PDB discovery	Scanning PDB in DBMS.	ZABBIX_PASSIVE	oracle.pdb.discovery["{$ORACLE.CONNSTRING}","{$ORACLE.USER}","{$ORACLE.PASSWORD}","{$ORACLE.SERVICE}"] Filter: AND - A: {#DBNAME} MATCHES_REGEX `{$ORACLE.DBNAME.MATCHES}` - B: {#DBNAME} NOT_MATCHES_REGEX `{$ORACLE.DBNAME.NOT_MATCHES}`
Tablespace discovery	Scanning tablespaces in DBMS.	ZABBIX_PASSIVE	oracle.ts.discovery["{$ORACLE.CONNSTRING}","{$ORACLE.USER}","{$ORACLE.PASSWORD}","{$ORACLE.SERVICE}"] Filter: AND - A: {#TABLESPACE} MATCHES_REGEX `{$ORACLE.TABLESPACE.NAME.MATCHES}` - B: {#TABLESPACE} NOT_MATCHES_REGEX `{$ORACLE.TABLESPACE.NAME.NOT_MATCHES}`
Archive log discovery	Log archive destinations.	ZABBIX_PASSIVE	oracle.archive.discovery["{$ORACLE.CONNSTRING}","{$ORACLE.USER}","{$ORACLE.PASSWORD}","{$ORACLE.SERVICE}"]
ASM disk groups discovery	ASM disk groups	ZABBIX_PASSIVE	oracle.diskgroups.discovery["{$ORACLE.CONNSTRING}","{$ORACLE.USER}","{$ORACLE.PASSWORD}","{$ORACLE.SERVICE}"]

Items collected

Group	Name	Description	Type	Key and additional info
Oracle	Oracle: Ping	Test the connection to Oracle Database state	ZABBIX_PASSIVE	oracle.ping["{$ORACLE.CONNSTRING}","{$ORACLE.USER}","{$ORACLE.PASSWORD}","{$ORACLE.SERVICE}"] Preprocessing: - DISCARD_UNCHANGED_HEARTBEAT: `10m`
Oracle	Oracle: Version	Oracle Server version.	DEPENDENT	oracle.version Preprocessing: - JSONPATH: `$.version` - DISCARD_UNCHANGED_HEARTBEAT: `1d`
Oracle	Oracle: Uptime	Oracle instance uptime in seconds.	DEPENDENT	oracle.uptime Preprocessing: - JSONPATH: `$.uptime`
Oracle	Oracle: Instance status	Status of the instance.	DEPENDENT	oracle.instance_status Preprocessing: - JSONPATH: `$.status`
Oracle	Oracle: Archiver state	Automatic archiving status.	DEPENDENT	oracle.archiver_state Preprocessing: - JSONPATH: `$..archiver.first()`
Oracle	Oracle: Instance name	Name of the instance.	DEPENDENT	oracle.instance_name Preprocessing: - JSONPATH: `$.instance`
Oracle	Oracle: Instance hostname	Name of the host machine.	DEPENDENT	oracle.instance_hostname Preprocessing: - JSONPATH: `$..hostname.first()`
Oracle	Oracle: Instance role	Indicates whether the instance is an active instance or an inactive secondary instance.	DEPENDENT	oracle.instance.role Preprocessing: - JSONPATH: `$.role`
Oracle	Oracle: Buffer cache hit ratio	Ratio of buffer cache hits. (LogRead - PhyRead)/LogRead	DEPENDENT	oracle.buffer_cache_hit_ratio Preprocessing: - JSONPATH: `$.['Buffer Cache Hit Ratio']`
Oracle	Oracle: Cursor cache hit ratio	Ratio of cursor cache hits. CursorCacheHit/SoftParse	DEPENDENT	oracle.cursor_cache_hit_ratio Preprocessing: - JSONPATH: `$.['Cursor Cache Hit Ratio']`
Oracle	Oracle: Library cache hit ratio	Ratio of library cache hits. Hits/Pins	DEPENDENT	oracle.library_cache_hit_ratio Preprocessing: - JSONPATH: `$.['Library Cache Hit Ratio']`
Oracle	Oracle: Shared pool free %	Shared pool free memory percent. Free/Total	DEPENDENT	oracle.shared_pool_free Preprocessing: - JSONPATH: `$.['Shared Pool Free %']`
Oracle	Oracle: Physical reads per second	Reads per second.	DEPENDENT	oracle.physical_reads_rate Preprocessing: - JSONPATH: `$.['Physical Reads Per Sec']`
Oracle	Oracle: Physical writes per second	Writes per second.	DEPENDENT	oracle.physical_writes_rate Preprocessing: - JSONPATH: `$.['Physical Writes Per Sec']`
Oracle	Oracle: Physical reads bytes per second	Read bytes per second.	DEPENDENT	oracle.physical_read_bytes_rate Preprocessing: - JSONPATH: `$.['Physical Read Bytes Per Sec']`
Oracle	Oracle: Physical writes bytes per second	Write bytes per second.	DEPENDENT	oracle.physical_write_bytes_rate Preprocessing: - JSONPATH: `$.['Physical Write Bytes Per Sec']`
Oracle	Oracle: Enqueue timeouts per second	Enqueue timeouts per second.	DEPENDENT	oracle.enqueue_timeouts_rate Preprocessing: - JSONPATH: `$.['Enqueue Timeouts Per Sec']`
Oracle	Oracle: GC CR block received per second	GC CR block received per second.	DEPENDENT	oracle.gc_cr_block_received_rate Preprocessing: - JSONPATH: `$.['GC CR Block Received Per Second']`
Oracle	Oracle: Global cache blocks corrupted	The number of blocks that encountered a corruption or checksum failure during interconnect.	DEPENDENT	oracle.cache_blocks_corrupt Preprocessing: - JSONPATH: `$.['Global Cache Blocks Corrupted']`
Oracle	Oracle: Global cache blocks lost	The number of global cache blocks lost	DEPENDENT	oracle.cache_blocks_lost Preprocessing: - JSONPATH: `$.['Global Cache Blocks Lost']`
Oracle	Oracle: Logons per second	The number of logon attempts.	DEPENDENT	oracle.logons_rate Preprocessing: - JSONPATH: `$.['Logons Per Sec']`
Oracle	Oracle: Average active sessions	The average active sessions at a point in time. It is the number of sessions that are either working or waiting.	DEPENDENT	oracle.active_sessions Preprocessing: - JSONPATH: `$.['Average Active Sessions']`
Oracle	Oracle: Active serial sessions	The number of active serial sessions.	DEPENDENT	oracle.active_serial_sessions Preprocessing: - JSONPATH: `$.['Active Serial Sessions']`
Oracle	Oracle: Active parallel sessions	The number of active parallel sessions.	DEPENDENT	oracle.active_parallel_sessions Preprocessing: - JSONPATH: `$.['Active Parallel Sessions']`
Oracle	Oracle: Long table scans per second	The number of long table scans per second. A table is considered 'long' if the table is not cached and if its high-water mark is greater than 5 blocks.	DEPENDENT	oracle.long_table_scans_rate Preprocessing: - JSONPATH: `$.['Long Table Scans Per Sec']`
Oracle	Oracle: SQL service response time	SQL service response time in seconds.	DEPENDENT	oracle.service_response_time Preprocessing: - JSONPATH: `$.['SQL Service Response Time']` - MULTIPLIER: `0.01`
Oracle	Oracle: User rollbacks per second	The number of times that users manually issue the ROLLBACK statement or an error occurred during a user's transactions.	DEPENDENT	oracle.user_rollbacks_rate Preprocessing: - JSONPATH: `$.['User Rollbacks Per Sec']`
Oracle	Oracle: Total sorts per user call	Total sorts per user call.	DEPENDENT	oracle.sorts_per_user_call Preprocessing: - JSONPATH: `$.['Total Sorts Per User Call']`
Oracle	Oracle: Rows per sort	The average number of rows per sort for all types of sorts performed.	DEPENDENT	oracle.rows_per_sort Preprocessing: - JSONPATH: `$.['Rows Per Sort']`
Oracle	Oracle: Disk sort per second	The number of sorts going to disk per second	DEPENDENT	oracle.disk_sorts Preprocessing: - JSONPATH: `$.['Disk Sort Per Sec']`
Oracle	Oracle: Memory sorts ratio	The percentage of sorts (from ORDER BY clauses or index building) that are done to disk vs in-memory.	DEPENDENT	oracle.memory_sorts_ratio Preprocessing: - JSONPATH: `$.['Memory Sorts Ratio']`
Oracle	Oracle: Database wait time ratio	Wait time: the time that the server process spends waiting for available shared resources (to be released by other server processes) such as latches, locks, data buffers, and so on	DEPENDENT	oracle.database_wait_time_ratio Preprocessing: - JSONPATH: `$.['Database Wait Time Ratio']`
Oracle	Oracle: Database CPU time ratio	Calculated by dividing the total CPU used by the database by the Oracle time model statistic DB time.	DEPENDENT	oracle.database_cpu_time_ratio Preprocessing: - JSONPATH: `$.['Database CPU Time Ratio']`
Oracle	Oracle: Temp space used	Temp space used.	DEPENDENT	oracle.temp_space_used Preprocessing: - JSONPATH: `$.['Temp Space Used']`
Oracle	Oracle: Sessions limit	User and system sessions.	DEPENDENT	oracle.session_limit Preprocessing: - JSONPATH: `$.sessions`
Oracle	Oracle: Datafiles limit	Max allowable number of datafile.	DEPENDENT	oracle.db_files_limit Preprocessing: - JSONPATH: `$.db_files`
Oracle	Oracle: Processes limit	Max user processes.	DEPENDENT	oracle.processes_limit Preprocessing: - JSONPATH: `$.processes`
Oracle	Oracle: Session count	Session count.	DEPENDENT	oracle.session_count Preprocessing: - JSONPATH: `$.total`
Oracle	Oracle: Active user sessions	The number of active user sessions.	DEPENDENT	oracle.session_active_user Preprocessing: - JSONPATH: `$.active_user` ⛔️ON_FAIL: `CUSTOM_VALUE -> 0`
Oracle	Oracle: Active background sessions	The number of active background sessions.	DEPENDENT	oracle.session_active_background Preprocessing: - JSONPATH: `$.active_background` ⛔️ON_FAIL: `CUSTOM_VALUE -> 0`
Oracle	Oracle: Inactive user sessions	The number of inactive user sessions.	DEPENDENT	oracle.session_inactive_user Preprocessing: - JSONPATH: `$.inactive_user` ⛔️ON_FAIL: `CUSTOM_VALUE -> 0`
Oracle	Oracle: Sessions lock rate	The percentage of locked sessions. Locks are mechanisms that prevent destructive interaction between transactions accessing the same resource—either user objects such as tables and rows or system objects not visible to users, such as shared data structures in memory and data dictionary rows.	DEPENDENT	oracle.session_lock_rate Preprocessing: - JSONPATH: `$.lock_rate`
Oracle	Oracle: Sessions locked over {$ORACLE.SESSION.LOCK.MAX.TIME}s	Count of the prolongely locked sessions. (You can change maximum session lock duration in seconds for query by {$ORACLE.SESSION.LOCK.MAX.TIME} macro. Default 600 sec)	DEPENDENT	oracle.session_long_time_locked Preprocessing: - JSONPATH: `$.long_time_locked`
Oracle	Oracle: Sessions concurrency	The percentage of concurrency. Concurrency is a DB behaviour when different transactions request to change the same resource - in case of modifying data transactions sequentially block temporarily the right to change data, the rest of the transactions are waiting for access. In the case when access for resource is locked for a long time, then the concurrency grows (like the transaction queue) and this often has an extremely negative impact on performance. A high contention value does not indicate the root cause of the problem, but is a signal to search for it.	DEPENDENT	oracle.session_concurrency_rate Preprocessing: - JSONPATH: `$.concurrency_rate`
Oracle	Oracle: PGA, Total inuse	Indicates how much PGA memory is currently consumed by work areas. This number can be used to determine how much memory is consumed by other consumers of the PGA memory (for example, PL/SQL or Java).	DEPENDENT	oracle.total_pga_used Preprocessing: - JSONPATH: `$.['total PGA inuse']`
Oracle	Oracle: PGA, Aggregate target parameter	Current value of the PGA_AGGREGATE_TARGET initialization parameter. If this parameter is not set, then its value is 0 and automatic management of PGA memory is disabled.	DEPENDENT	oracle.pga_target Preprocessing: - JSONPATH: `$.['aggregate PGA target parameter']`
Oracle	Oracle: PGA, Total allocated	Current amount of PGA memory allocated by the instance. The Oracle Database attempts to keep this number below the value of the PGA_AGGREGATE_TARGET initialization parameter. However, it is possible for the PGA allocated to exceed that value by a small percentage and for a short period of time when the work area workload is increasing very rapidly or when PGA_AGGREGATE_TARGET is set to a small value.	DEPENDENT	oracle.total_pga_allocated Preprocessing: - JSONPATH: `$.['total PGA allocated']`
Oracle	Oracle: PGA, Total freeable	Number of bytes of PGA memory in all processes that could be freed back to the operating system.	DEPENDENT	oracle.total_pga_freeable Preprocessing: - JSONPATH: `$.['total freeable PGA memory']`
Oracle	Oracle: PGA, Global memory bound	Maximum size of a work area executed in automatic mode.	DEPENDENT	oracle.pga_global_bound Preprocessing: - JSONPATH: `$.['global memory bound']`
Oracle	Oracle: FRA, Space limit	Maximum amount of disk space (in bytes) that the database can use for the fast recovery area.	DEPENDENT	oracle.fra_space_limit Preprocessing: - JSONPATH: `$.space_limit`
Oracle	Oracle: FRA, Used space	Amount of disk space (in bytes) used by fast recovery area files created in current and all previous fast recovery areas.	DEPENDENT	oracle.fra_space_used Preprocessing: - JSONPATH: `$.space_used`
Oracle	Oracle: FRA, Space reclaimable	Total amount of disk space (in bytes) that can be created by deleting obsolete, redundant, and other low priority files from the fast recovery area.	DEPENDENT	oracle.fra_space_reclaimable Preprocessing: - JSONPATH: `$.space_reclaimable`
Oracle	Oracle: FRA, Number of files	Number of files in the fast recovery area	DEPENDENT	oracle.fra_number_of_files Preprocessing: - JSONPATH: `$.number_of_files`
Oracle	Oracle: FRA, Used space in %		DEPENDENT	oracle.fra_usable_pct Preprocessing: - JSONPATH: `$.usable_pct`
Oracle	Oracle: FRA, Number of restore points		DEPENDENT	oracle.fra_restore_point Preprocessing: - JSONPATH: `$.restore_point`
Oracle	Oracle: SGA, java pool	Memory is allocated from the java pool.	DEPENDENT	oracle.sga_java_pool Preprocessing: - JSONPATH: `$.java_pool`
Oracle	Oracle: SGA, large pool	Memory is allocated from the large pool.	DEPENDENT	oracle.sga_large_pool Preprocessing: - JSONPATH: `$.large_pool`
Oracle	Oracle: SGA, shared pool	Memory is allocated from the shared pool.	DEPENDENT	oracle.sga_shared_pool Preprocessing: - JSONPATH: `$.shared_pool`
Oracle	Oracle: SGA, log buffer	The number of bytes allocated for the redo log buffer.	DEPENDENT	oracle.sga_log_buffer Preprocessing: - JSONPATH: `$.log_buffer`
Oracle	Oracle: SGA, fixed	The fixed SGA is an internal housekeeping area.	DEPENDENT	oracle.sga_fixed Preprocessing: - JSONPATH: `$.fixed_sga`
Oracle	Oracle: SGA, buffer cache	The size of the cache of standard blocks.	DEPENDENT	oracle.sga_buffer_cache Preprocessing: - JSONPATH: `$.buffer_cache`
Oracle	Oracle: User's expire password	The number of days before zabbix account password expired.	ZABBIX_PASSIVE	oracle.user.info["{$ORACLE.CONNSTRING}","{$ORACLE.USER}","{$ORACLE.PASSWORD}","{$ORACLE.SERVICE}"] Preprocessing: - JSONPATH: `$.exp_passwd_days_before`
Oracle	Oracle: Redo logs available to switch	Number of available for log switching inactive/unused REDO logs.	ZABBIX_PASSIVE	oracle.redolog.info["{$ORACLE.CONNSTRING}","{$ORACLE.USER}","{$ORACLE.PASSWORD}","{$ORACLE.SERVICE}"] Preprocessing: - JSONPATH: `$.available`
Oracle	Oracle: Number of processes		ZABBIX_PASSIVE	oracle.proc.stats["{$ORACLE.CONNSTRING}","{$ORACLE.USER}","{$ORACLE.PASSWORD}","{$ORACLE.SERVICE}"] Preprocessing: - JSONPATH: `$.proc_num`
Oracle	Oracle: Datafiles count	Current number of datafile.	ZABBIX_PASSIVE	oracle.datafiles.stats["{$ORACLE.CONNSTRING}","{$ORACLE.USER}","{$ORACLE.PASSWORD}","{$ORACLE.SERVICE}"] Preprocessing: - JSONPATH: `$.datafile_num`
Oracle	Oracle Database '{#DBNAME}': Open status	1 - 'MOUNTED', 2 - 'READ WRITE', 3 - 'READ ONLY', 4 - 'READ ONLY WITH APPLY' (A physical standby database is open in real-time query mode)	DEPENDENT	oracle.db_open_mode["{#DBNAME}"] Preprocessing: - JSONPATH: `$..{#DBNAME}.open_mode.first()` - DISCARD_UNCHANGED_HEARTBEAT: `15m`
Oracle	Oracle Database '{#DBNAME}': Role	Current role of the database, 1 - 'SNAPSHOT STANDBY', 2 - 'LOGICAL STANDBY', 3 - 'PHYSICAL STANDBY', 4 - 'PRIMARY ', 5 -'FAR SYNC'	DEPENDENT	oracle.db_role["{#DBNAME}"] Preprocessing: - JSONPATH: `$..{#DBNAME}.role.first()` - DISCARD_UNCHANGED_HEARTBEAT: `15m`
Oracle	Oracle Database '{#DBNAME}': Log mode	Archive log mode, 0 - 'NOARCHIVELOG', 1 - 'ARCHIVELOG', 2 - 'MANUAL'	DEPENDENT	oracle.db_log_mode["{#DBNAME}"] Preprocessing: - JSONPATH: `$..{#DBNAME}.log_mode.first()` - DISCARD_UNCHANGED_HEARTBEAT: `15m`
Oracle	Oracle Database '{#DBNAME}': Force logging	Indicates whether the database is under force logging mode (YES) or not (NO)	DEPENDENT	oracle.db_force_logging["{#DBNAME}"] Preprocessing: - JSONPATH: `$..{#DBNAME}.force_logging.first()` - DISCARD_UNCHANGED_HEARTBEAT: `15m`
Oracle	Oracle Database '{#DBNAME}': Open status	1 - 'MOUNTED', 2 - 'READ WRITE', 3 - 'READ ONLY', 4 - 'READ ONLY WITH APPLY' (A physical standby database is open in real-time query mode)	DEPENDENT	oracle.pdb_open_mode["{#DBNAME}"] Preprocessing: - JSONPATH: `$..{#DBNAME}.open_mode.first()` - DISCARD_UNCHANGED_HEARTBEAT: `15m`
Oracle	Oracle TBS '{#TABLESPACE}': Tablespace allocated, bytes	Currently allocated bytes for tablespace (sum of the current size of datafiles).	DEPENDENT	oracle.tbs_alloc_bytes["{#TABLESPACE}"] Preprocessing: - JSONPATH: `$..{#TABLESPACE}.used_bytes.first()`
Oracle	Oracle TBS '{#TABLESPACE}': Tablespace MAX size, bytes	Maximum size of tablespace.	DEPENDENT	oracle.tbs_max_bytes["{#TABLESPACE}"] Preprocessing: - JSONPATH: `$..{#TABLESPACE}.max_bytes.first()`
Oracle	Oracle TBS '{#TABLESPACE}': Tablespace free, bytes	Free bytes of allocated space.	DEPENDENT	oracle.tbs_free_bytes["{#TABLESPACE}"] Preprocessing: - JSONPATH: `$..{#TABLESPACE}.free_bytes.first()`
Oracle	Oracle TBS '{#TABLESPACE}': Tablespace usage percent	Allocated bytes/Max bytes*100	DEPENDENT	oracle.tbs_used_pct["{#TABLESPACE}"] Preprocessing: - JSONPATH: `$..{#TABLESPACE}.used_pct.first()`
Oracle	Oracle TBS '{#TABLESPACE}': Open status	Tablespace status. 1 - 'ONLINE' 2 - 'OFFLINE' 3- 'READ ONLY'	DEPENDENT	oracle.tbs_status["{#TABLESPACE}"] Preprocessing: - JSONPATH: `$..{#TABLESPACE}.status.first()`
Oracle	Archivelog '{#DEST_NAME}': Error	Displays the error text	DEPENDENT	oracle.archivelog_error["{#DEST_NAME}"] Preprocessing: - JSONPATH: `$..['{#DEST_NAME}'].log_sequence.first()`
Oracle	Archivelog '{#DEST_NAME}': Last sequence	Identifies the sequence number of the last archived redo log to be archived	DEPENDENT	oracle.archivelog_log_sequence["{#DEST_NAME}"] Preprocessing: - JSONPATH: `$..['{#DEST_NAME}'].log_sequence.first()`
Oracle	Archivelog '{#DEST_NAME}': Status	Identifies the current status of the destination: 1 - 'Valid', 2 - 'Dederred',3 - 'Error', 0 - 'Unknown'	DEPENDENT	oracle.archivelog_log_status["{#DEST_NAME}"] Preprocessing: - JSONPATH: `$..['{#DEST_NAME}'].log_sequence.first()`
Oracle	ASM '{#DG_NAME}': Total size	Total size of ASM disk group.	DEPENDENT	oracle.asm_total_size["{#DG_NAME}"] Preprocessing: - JSONPATH: `$..['{#DG_NAME}'].size_byte.first()`
Oracle	ASM '{#DG_NAME}': Free size	Free size of ASM disk group.	DEPENDENT	oracle.asm_free_size["{#DG_NAME}"] Preprocessing: - JSONPATH: `$..['{#DG_NAME}'].free_size_byte.first()`
Oracle	ASM '{#DG_NAME}': Free size	Usage percent of ASM disk group.	DEPENDENT	oracle.asm_used_pct["{#DG_NAME}"] Preprocessing: - JSONPATH: `$..['{#DG_NAME}'].used_percent.first()`
Zabbix_raw_items	Oracle: Get instance state	The item gets state of the current instance.	ZABBIX_PASSIVE	oracle.instance.info["{$ORACLE.CONNSTRING}","{$ORACLE.USER}","{$ORACLE.PASSWORD}","{$ORACLE.SERVICE}"]
Zabbix_raw_items	Oracle: Get system metrics	The item gets system metric values.	ZABBIX_PASSIVE	oracle.sys.metrics["{$ORACLE.CONNSTRING}","{$ORACLE.USER}","{$ORACLE.PASSWORD}","{$ORACLE.SERVICE}"]
Zabbix_raw_items	Oracle: Get system parameters	Get a set of system parameter values.	ZABBIX_PASSIVE	oracle.sys.params["{$ORACLE.CONNSTRING}","{$ORACLE.USER}","{$ORACLE.PASSWORD}","{$ORACLE.SERVICE}"]
Zabbix_raw_items	Oracle: Get sessions stats	Get sessions statistics. {$ORACLE.SESSION.LOCK.MAX.TIME} -- maximum seconds in the current wait condition for counting long time locked sessions. Default: 600 seconds.	ZABBIX_PASSIVE	oracle.sessions.stats["{$ORACLE.CONNSTRING}","{$ORACLE.USER}","{$ORACLE.PASSWORD}","{$ORACLE.SERVICE}","{$ORACLE.SESSION.LOCK.MAX.TIME}"]
Zabbix_raw_items	Oracle: Get PGA stats	Get PGA statistics.	ZABBIX_PASSIVE	oracle.pga.stats["{$ORACLE.CONNSTRING}","{$ORACLE.USER}","{$ORACLE.PASSWORD}","{$ORACLE.SERVICE}"]
Zabbix_raw_items	Oracle: Get FRA stats	Get FRA statistics.	ZABBIX_PASSIVE	oracle.fra.stats["{$ORACLE.CONNSTRING}","{$ORACLE.USER}","{$ORACLE.PASSWORD}","{$ORACLE.SERVICE}"]
Zabbix_raw_items	Oracle: Get SGA stats	Get SGA statistics.	ZABBIX_PASSIVE	oracle.sga.stats["{$ORACLE.CONNSTRING}","{$ORACLE.USER}","{$ORACLE.PASSWORD}","{$ORACLE.SERVICE}"]
Zabbix_raw_items	Oracle: Get tablespaces stats	Get tablespaces stats.	ZABBIX_PASSIVE	oracle.ts.stats["{$ORACLE.CONNSTRING}","{$ORACLE.USER}","{$ORACLE.PASSWORD}","{$ORACLE.SERVICE}"]
Zabbix_raw_items	Oracle: Get CDB and No-CDB info	Get info about CDB and No-CDB databases on instansce.	ZABBIX_PASSIVE	oracle.cdb.info["{$ORACLE.CONNSTRING}","{$ORACLE.USER}","{$ORACLE.PASSWORD}","{$ORACLE.SERVICE}"]
Zabbix_raw_items	Oracle: Get PDB info	Get info about PDB databases on instansce.	ZABBIX_PASSIVE	oracle.pdb.info["{$ORACLE.CONNSTRING}","{$ORACLE.USER}","{$ORACLE.PASSWORD}","{$ORACLE.SERVICE}"]
Zabbix_raw_items	Oracle: Get archive log info		ZABBIX_PASSIVE	oracle.archive.info["{$ORACLE.CONNSTRING}","{$ORACLE.USER}","{$ORACLE.PASSWORD}","{$ORACLE.SERVICE}"]
Zabbix_raw_items	Oracle: Get ASM stats	Get ASM disk groups stats.	ZABBIX_PASSIVE	oracle.diskgroups.stats["{$ORACLE.CONNSTRING}","{$ORACLE.USER}","{$ORACLE.PASSWORD}","{$ORACLE.SERVICE}"]

Triggers

Name	Description	Expression	Severity	Dependencies and additional info
Oracle: Connection to database is unavailable	Connection to Oracle Database is currently unavailable.	`{TEMPLATE_NAME:oracle.ping["{$ORACLE.CONNSTRING}","{$ORACLE.USER}","{$ORACLE.PASSWORD}","{$ORACLE.SERVICE}"].last()}=0`	DISASTER
Oracle: Version has changed (new version value received: {ITEM.VALUE})	Oracle DB version has changed. Ack to close.	`{TEMPLATE_NAME:oracle.version.diff()}=1 and {TEMPLATE_NAME:oracle.version.strlen()}>0`	INFO	Manual close: YES
Oracle: Failed to fetch info data (or no data for 30m)	Zabbix has not received data for items for the last 5 minutes. The database might be unavailable for connecting.	`{TEMPLATE_NAME:oracle.uptime.nodata(30m)}=1`	INFO
Oracle: has been restarted (uptime < 10m)	Uptime is less than 10 minutes	`{TEMPLATE_NAME:oracle.uptime.last()}<10m`	INFO	Manual close: YES
Oracle: Instance name has changed (new name received: {ITEM.VALUE})	Oracle DB Instance name has changed. Ack to close.	`{TEMPLATE_NAME:oracle.instance_name.diff()}=1 and {TEMPLATE_NAME:oracle.instance_name.strlen()}>0`	INFO	Manual close: YES
Oracle: Instance hostname has changed (new hostname received: {ITEM.VALUE})	Oracle DB Instance hostname has changed. Ack to close.	`{TEMPLATE_NAME:oracle.instance_hostname.diff()}=1 and {TEMPLATE_NAME:oracle.instance_hostname.strlen()}>0`	INFO	Manual close: YES
Oracle: Shared pool free is too low (less {$ORACLE.SHARED.FREE.MIN.WARN}% for 5m)	The shared pool free memory percent has been less than {$ORACLE.SHARED.FREE.MIN.WARN}% in the last 5 minutes.	`{TEMPLATE_NAME:oracle.shared_pool_free.max(5m)}<{$ORACLE.SHARED.FREE.MIN.WARN}`	WARNING
Oracle: Too many active sessions (over {$ORACLE.SESSIONS.MAX.WARN}% for 5 min)	Active sessions are using more than {$ORACLE.SESSIONS.MAX.WARN}% of the available sessions.	`{TEMPLATE_NAME:oracle.session_count.min(5m)} * 100 / {Template DB Oracle by Zabbix Agent 2:oracle.session_limit.last()} > {$ORACLE.SESSIONS.MAX.WARN}`	WARNING
Oracle: Too many locked sessions (over {$ORACLE.SESSIONS.LOCK.MAX.WARN}% for 5 min)	Number of locked sessions is over {$ORACLE.SESSIONS.LOCK.MAX.WARN}% of the running sessions.	`{TEMPLATE_NAME:oracle.session_lock_rate.min(5m)} > {$ORACLE.SESSIONS.LOCK.MAX.WARN}`	WARNING
Oracle: Too many sessions locked over {$ORACLE.SESSION.LOCK.MAX.TIME}s (over {$ORACLE.SESSION.LONG.LOCK.MAX.WARN} for 5 min)	Number of sessions locked over {$ORACLE.SESSION.LOCK.MAX.TIME} seconds is too high. Long-term locks can negatively affect database performance, therefore, if they are detected, you should first find the most difficult queries from the database point of view and analyze possible resource leaks.	`{TEMPLATE_NAME:oracle.session_long_time_locked.min(5m)} > {$ORACLE.SESSION.LONG.LOCK.MAX.WARN}`	WARNING
Oracle: Too hight database concurrency (over {$ORACLE.CONCURRENCY.MAX.WARN}% for 5 min)	Concurrency rate is over {$ORACLE.CONCURRENCY.MAX.WARN}%. A high contention value does not indicate the root cause of the problem, but is a signal to search for it. In the case of high competition, an analysis of resource consumption should be carried out, the most "heavy" queries made in the database, possibly - session tracing. All this will help determine the root cause and possible optimization points both in the database configuration and in the logic of building queries of the application itself.	`{TEMPLATE_NAME:oracle.session_concurrency_rate.min(5m)} > {$ORACLE.CONCURRENCY.MAX.WARN}`	WARNING
Oracle: Total PGA inuse is too high (over {$ORACLE.PGA.USE.MAX.WARN}% for 5 min)	Total PGA in use is more than {$ORACLE.PGA.USE.MAX.WARN}% of PGA_AGGREGATE_TARGET.	`{TEMPLATE_NAME:oracle.total_pga_used.min(5m)} * 100 / {Template DB Oracle by Zabbix Agent 2:oracle.pga_target.last()} > {$ORACLE.PGA.USE.MAX.WARN}`	WARNING
Oracle: Zabbix account will expire soon (under {$ORACLE.EXPIRE.PASSWORD.MIN.WARN} days)	Password for zabbix user in the database will expire soon.	`{TEMPLATE_NAME:oracle.user.info["{$ORACLE.CONNSTRING}","{$ORACLE.USER}","{$ORACLE.PASSWORD}","{$ORACLE.SERVICE}"].last()} < {$ORACLE.EXPIRE.PASSWORD.MIN.WARN}`	WARNING
Oracle: Number of REDO logs available for switching is too low (less {$ORACLE.REDO.MIN.WARN} for 5 min)	Number of available for log switching inactive/unused REDOs is low (Database down risk)	`{TEMPLATE_NAME:oracle.redolog.info["{$ORACLE.CONNSTRING}","{$ORACLE.USER}","{$ORACLE.PASSWORD}","{$ORACLE.SERVICE}"].max(5m)} < {$ORACLE.REDO.MIN.WARN}`	WARNING
Oracle: Too many active processes (over {$ORACLE.PROCESSES.MAX.WARN}% for 5 min)	Active processes are using more than {$ORACLE.PROCESSES.MAX.WARN}% of the available number of processes.	`{TEMPLATE_NAME:oracle.proc.stats["{$ORACLE.CONNSTRING}","{$ORACLE.USER}","{$ORACLE.PASSWORD}","{$ORACLE.SERVICE}"].min(5m)} * 100 / {Template DB Oracle by Zabbix Agent 2:oracle.processes_limit.last()} > {$ORACLE.PROCESSES.MAX.WARN}`	WARNING
Oracle: Too many database files (over {$ORACLE.DB.FILE.MAX.WARN}% for 5 min)	Number of datafiles is higher than {$ORACLE.DB.FILE.MAX.WARN}% of the available datafile files limit.	`{TEMPLATE_NAME:oracle.datafiles.stats["{$ORACLE.CONNSTRING}","{$ORACLE.USER}","{$ORACLE.PASSWORD}","{$ORACLE.SERVICE}"].min(5m)} * 100 / {Template DB Oracle by Zabbix Agent 2:oracle.db_files_limit.last()} > {$ORACLE.DB.FILE.MAX.WARN}`	WARNING
Oracle Database '{#DBNAME}': Open status in mount mode	The Oracle DB has a MOUNTED state.	`{TEMPLATE_NAME:oracle.db_open_mode["{#DBNAME}"].last()}=1`	WARNING
Oracle Database '{#DBNAME}': Open status has changed (new value received: {ITEM.VALUE})	Oracle DB open status has changed. Ack to close.	`{TEMPLATE_NAME:oracle.db_open_mode["{#DBNAME}"].diff()}=1`	INFO	Manual close: YES Depends on: - Oracle Database '{#DBNAME}': Open status in mount mode
Oracle Database '{#DBNAME}': Role has changed (new value received: {ITEM.VALUE})	Oracle DB role has changed. Ack to close.	`{TEMPLATE_NAME:oracle.db_role["{#DBNAME}"].diff()}=1`	INFO	Manual close: YES
Oracle Database '{#DBNAME}': Force logging is deactivated for DB with active Archivelog	Force Logging mode - it is very important metric for Databases in 'ARCHIVELOG'. This feature allows to forcibly write all transactions to the REDO.	`{TEMPLATE_NAME:oracle.db_force_logging["{#DBNAME}"].last()} = 0 and {Template DB Oracle by Zabbix Agent 2:oracle.db_log_mode["{#DBNAME}"].last()} = 1`	WARNING
Oracle Database '{#DBNAME}': Open status in mount mode	The Oracle DB has a MOUNTED state.	`{TEMPLATE_NAME:oracle.pdb_open_mode["{#DBNAME}"].last()}=1`	WARNING
Oracle Database '{#DBNAME}': Open status has changed (new value received: {ITEM.VALUE})	Oracle DB open status has changed. Ack to close.	`{TEMPLATE_NAME:oracle.pdb_open_mode["{#DBNAME}"].diff()}=1`	INFO	Manual close: YES
Oracle TBS '{#TABLESPACE}': Tablespace usage is too high (over {$ORACLE.TBS.USED.PCT.MAX.WARN}% for 5m).		`{TEMPLATE_NAME:oracle.tbs_used_pct["{#TABLESPACE}"].min(5m)}>{$ORACLE.TBS.USED.PCT.MAX.WARN}`	WARNING	Depends on: - Oracle TBS '{#TABLESPACE}': Tablespace Usage is too high (over {$ORACLE.TBS.USED.PCT.MAX.HIGH}% for 5m).
Oracle TBS '{#TABLESPACE}': Tablespace Usage is too high (over {$ORACLE.TBS.USED.PCT.MAX.HIGH}% for 5m).		`{TEMPLATE_NAME:oracle.tbs_used_pct["{#TABLESPACE}"].min(5m)}>{$ORACLE.TBS.USED.PCT.MAX.HIGH}`	HIGH
Oracle TBS '{#TABLESPACE}': Tablespase is OFFLINE	The tablespase is in the offline state.	`{TEMPLATE_NAME:oracle.tbs_status["{#TABLESPACE}"].last()}=2`	WARNING
Oracle TBS '{#TABLESPACE}': Tablespace status has changed (new value received: {ITEM.VALUE})	Oracle tablespace status has changed. Ack to close.	`{TEMPLATE_NAME:oracle.tbs_status["{#TABLESPACE}"].diff()}=1`	INFO	Manual close: YES Depends on: - Oracle TBS '{#TABLESPACE}': Tablespase is OFFLINE
Archivelog '{#DEST_NAME}': Log Archive is not valid	ARL destination not in 3 - Valid or 2 - Deferred.	`{TEMPLATE_NAME:oracle.archivelog_log_status["{#DEST_NAME}"].last()}<2`	HIGH
ASM '{#DG_NAME}': Disk group usage is too high (over {$ORACLE.ASM.USED.PCT.MAX.WARN}% for 5m)	Usage percent of ASM disk group is over {$ORACLE.ASM.USED.PCT.MAX.WARN}	`{TEMPLATE_NAME:oracle.asm_used_pct["{#DG_NAME}"].min(5m)}>{$ORACLE.ASM.USED.PCT.MAX.WARN}`	WARNING	Depends on: - ASM '{#DG_NAME}': Disk group usage is too high (over {$ORACLE.ASM.USED.PCT.MAX.HIGH}% for 5m)
ASM '{#DG_NAME}': Disk group usage is too high (over {$ORACLE.ASM.USED.PCT.MAX.HIGH}% for 5m)	Usage percent of ASM disk group is over {$ORACLE.ASM.USED.PCT.MAX.WARN}	`{TEMPLATE_NAME:oracle.asm_used_pct["{#DG_NAME}"].min(5m)}>{$ORACLE.ASM.USED.PCT.MAX.HIGH}`	HIGH

Feedback

Please report any issues with the template at https://support.zabbix.com

Source: https://git.zabbix.com/projects/ZBX/repos/zabbix/browse/templates/db/oracle_odbc

Template DB Oracle by ODBC

Overview

For Zabbix version: 5.0
The template is developed for monitoring DBMS Oracle Database single instance via ODBC.

This template was tested on:

Zabbix, version 5.0
Oracle Database, version 12c2, 18c, 19c

Setup

See Zabbix template operation for basic instructions.

Create an Oracle DB user for monitoring:

CREATE USER zabbix_mon IDENTIFIED BY <PASSWORD>;
-- Grant access to the zabbix_mon user.
GRANT CONNECT, CREATE SESSION TO zabbix_mon;
GRANT SELECT ON v$instance TO zabbix_mon;
GRANT SELECT ON v$database TO zabbix_mon;
GRANT SELECT ON v$sysmetric TO zabbix_mon;
GRANT SELECT ON v$system_parameter TO zabbix_mon;
GRANT SELECT ON v$session TO zabbix_mon;
GRANT SELECT ON v$recovery_file_dest TO zabbix_mon;
GRANT SELECT ON v$active_session_history TO zabbix_mon;
GRANT SELECT ON v$osstat TO zabbix_mon;
GRANT SELECT ON v$restore_point TO zabbix_mon;
GRANT SELECT ON v$process TO zabbix_mon;
GRANT SELECT ON v$datafile TO zabbix_mon;
GRANT SELECT ON v$pgastat TO zabbix_mon;
GRANT SELECT ON v$sgastat TO zabbix_mon;
GRANT SELECT ON v$log TO zabbix_mon;
GRANT SELECT ON v$archive_dest TO zabbix_mon;
GRANT SELECT ON v$asm_diskgroup TO zabbix_mon;
GRANT SELECT ON sys.dba_data_files TO zabbix_mon;
GRANT SELECT ON DBA_TABLESPACES TO zabbix_mon;
GRANT SELECT ON DBA_TABLESPACE_USAGE_METRICS TO zabbix_mon;
GRANT SELECT ON DBA_USERS TO zabbix_mon;

Note! Make sure that ODBC connects to Oracle with session parameter NLS_NUMERIC_CHARACTERS= '.,' It is important for displaying float numbers in Zabbix correctly.

Install the ODBC driver on the Zabbix server or the Zabbix proxy. See Oracle documentation for instructions: https://www.oracle.com/database/technologies/releasenote-odbc-ic.html.

Add a new record to odbc.ini:

[$ORACLE.DSN]
Driver = Oracle 19 ODBC driver
Servername =  $ORACLE.DSN
DSN = $ORACLE.DSN

Note! Credentials in the odbc.ini do not work for Oracle.

Check the connection via isql:
```
isql $TNS_NAME $DB_USER $DB_PASSWORD
```

Configure Zabbix server or Zabbix proxy for Oracle ENV Usage. Edit or add a new file:

Edit or add new file

/etc/sysconfig/zabbix-server # for server

/etc/sysconfig/zabbix-proxy # for proxy

Then, add:

export ORACLE_HOME=/usr/lib/oracle/19.6/client64
export PATH=$PATH:$ORACLE_HOME/bin
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/usr/lib64:/usr/lib:$ORACLE_HOME/bin
export TNS_ADMIN=$ORACLE_HOME/network/admin

Restart Zabbix server or Zabbix proxy.
Set the username and password in host macros ({$ORACLE.USER} and {$ORACLE.PASSWORD}).
Set the {$ORACLE.DSN} in host macros.

The "Service's TCP port state" item uses {HOST.CONN} and {$ORACLE.PORT} macros to check the availability of the listener.

Zabbix configuration

No specific Zabbix configuration is required.

Macros used

Name	Description	Default
{$ORACLE.ASM.USED.PCT.MAX.HIGH}	Maximum percentage of used ASM disk group for high trigger expression.	`95`
{$ORACLE.ASM.USED.PCT.MAX.WARN}	Maximum percentage of used ASM disk group for warning trigger expression.	`90`
{$ORACLE.CONCURRENCY.MAX.WARN}	Maximum percentage of sessions concurrency usage for trigger expression.	`80`
{$ORACLE.DB.FILE.MAX.WARN}	Maximum percentage of database files for trigger expression.	`80`
{$ORACLE.DBNAME.MATCHES}	This macro is used in database discovery. It can be overridden on a host or linked template level.	`.*`
{$ORACLE.DBNAME.NOT_MATCHES}	This macro is used in database discovery. It can be overridden on a host or linked template level.	`PDB\$SEED`
{$ORACLE.DSN}	System data source name	`<Put your DSN here>`
{$ORACLE.EXPIRE.PASSWORD.MIN.WARN}	Number of days of warning before password expires (for trigger expression).	`7`
{$ORACLE.PASSWORD}	Oracle user password.	`<Put your password here>`
{$ORACLE.PGA.USE.MAX.WARN}	Maximum percentage of PGA usage alert treshold (for trigger expression).	`90`
{$ORACLE.PORT}	Oracle DB TCP port.	`1521`
{$ORACLE.PROCESSES.MAX.WARN}	Maximum percentage of active processes alert treshold (for trigger expression).	`80`
{$ORACLE.REDO.MIN.WARN}	Minimum number of REDO logs alert treshold (for trigger expression).	`3`
{$ORACLE.SESSION.LOCK.MAX.TIME}	Maximum session lock duration in seconds for count the session as a prolongely locked query.	`600`
{$ORACLE.SESSION.LONG.LOCK.MAX.WARN}	Maximum number of the prolongely locked sessions alert treshold (for trigger expression).	`3`
{$ORACLE.SESSIONS.LOCK.MAX.WARN}	Maximum percentage of locked sessions alert treshold (for trigger expression).	`20`
{$ORACLE.SESSIONS.MAX.WARN}	Maximum percentage of active sessions alert treshold (for trigger expression).	`80`
{$ORACLE.SHARED.FREE.MIN.WARN}	Minimum percentage of free shared pool alert treshold (for trigger expression).	`5`
{$ORACLE.TABLESPACE.NAME.MATCHES}	This macro is used in tablespace discovery. It can be overridden on a host or linked template level.	`.*`
{$ORACLE.TABLESPACE.NAME.NOT_MATCHES}	This macro is used in tablespace discovery. It can be overridden on a host or linked template level.	`CHANGE_IF_NEEDED`
{$ORACLE.TBS.USED.PCT.MAX.HIGH}	Maximum percentage of used tablespace high severity alert treshold (for trigger expression).	`90`
{$ORACLE.TBS.USED.PCT.MAX.WARN}	Maximum percentage of used tablespace warning severity alert treshold (for trigger expression).	`80`
{$ORACLE.USER}	Oracle username.	`<Put your username here>`

Template links

There are no template links in this template.

Discovery rules

Name	Description	Type	Key and additional info
Database discovery	Scanning databases in DBMS.	ODBC	db.odbc.discovery[db_list,"{$ORACLE.DSN}"] Filter: AND - A: {#DBNAME} MATCHES_REGEX `{$ORACLE.DBNAME.MATCHES}` - B: {#DBNAME} NOT_MATCHES_REGEX `{$ORACLE.DBNAME.NOT_MATCHES}`
PDB discovery	Scanning PDB in DBMS.	ODBC	db.odbc.discovery[pdb_list,"{$ORACLE.DSN}"] Filter: AND - A: {#DBNAME} MATCHES_REGEX `{$ORACLE.DBNAME.MATCHES}` - B: {#DBNAME} NOT_MATCHES_REGEX `{$ORACLE.DBNAME.NOT_MATCHES}`
Tablespace discovery	Scanning tablespaces in DBMS.	ODBC	db.odbc.discovery[tbsname,"{$ORACLE.DSN}"] Filter: AND - A: {#TABLESPACE} MATCHES_REGEX `{$ORACLE.TABLESPACE.NAME.MATCHES}` - B: {#TABLESPACE} NOT_MATCHES_REGEX `{$ORACLE.TABLESPACE.NAME.NOT_MATCHES}`
Archive log discovery	Log archive destinations.	ODBC	db.odbc.discovery[archivelog,"{$ORACLE.DSN}"]
ASM disk groups discovery	ASM disk groups	ODBC	db.odbc.discovery[asm,"{$ORACLE.DSN}"]

Items collected

Group	Name	Description	Type	Key and additional info
Oracle	Oracle: Service's TCP port state	Test the availability of Oracle on TCP port.	ZABBIX_PASSIVE	net.tcp.service[tcp,{HOST.CONN},{$ORACLE.PORT}] Preprocessing: - DISCARD_UNCHANGED_HEARTBEAT: `10m`
Oracle	Oracle: Number of LISTENER processes	Number of LISTENER processes running	ZABBIX_PASSIVE	proc.num[,,,"tnslsnr LISTENER"] Preprocessing: - DISCARD_UNCHANGED_HEARTBEAT: `10m`
Oracle	Oracle: Version	Oracle Server version.	DEPENDENT	oracle.version Preprocessing: - JSONPATH: `$..VERSION.first()` - DISCARD_UNCHANGED_HEARTBEAT: `1d`
Oracle	Oracle: Uptime	Oracle instance uptime in seconds.	DEPENDENT	oracle.uptime Preprocessing: - JSONPATH: `$..UPTIME.first()`
Oracle	Oracle: Instance status	Status of the instance.	DEPENDENT	oracle.instance_status Preprocessing: - JSONPATH: `$..STATUS.first()`
Oracle	Oracle: Archiver state	Automatic archiving status.	DEPENDENT	oracle.archiver_state Preprocessing: - JSONPATH: `$..ARCHIVER.first()`
Oracle	Oracle: Instance name	Name of the instance.	DEPENDENT	oracle.instance_name Preprocessing: - JSONPATH: `$..INSTANCE_NAME.first()`
Oracle	Oracle: Instance hostname	Name of the host machine.	DEPENDENT	oracle.instance_hostname Preprocessing: - JSONPATH: `$..HOST_NAME.first()`
Oracle	Oracle: Instance role	Indicates whether the instance is an active instance or an inactive secondary instance.	DEPENDENT	oracle.instance.role Preprocessing: - JSONPATH: `$..INSTANCE_ROLE.first()`
Oracle	Oracle: Sessions limit	User and system sessions.	DEPENDENT	oracle.session_limit Preprocessing: - JSONPATH: `$[?(@.METRIC=='SYSPARAM::Sessions')].VALUE.first()`
Oracle	Oracle: Datafiles limit	Max allowable number of datafile.	DEPENDENT	oracle.db_files_limit Preprocessing: - JSONPATH: `$[?(@.METRIC=='SYSPARAM::Db_Files')].VALUE.first()`
Oracle	Oracle: Processes limit	Max user processes.	DEPENDENT	oracle.processes_limit Preprocessing: - JSONPATH: `$[?(@.METRIC=='SYSPARAM::Processes')].VALUE.first()`
Oracle	Oracle: Number of processes		DEPENDENT	oracle.processes_count Preprocessing: - JSONPATH: `$[?(@.METRIC=='PROC::Procnum')].VALUE.first()`
Oracle	Oracle: Datafiles count	Current number of datafile.	DEPENDENT	oracle.db_files_count Preprocessing: - JSONPATH: `$[?(@.METRIC=='DATAFILE::Count')].VALUE.first()`
Oracle	Oracle: Buffer cache hit ratio	Ratio of buffer cache hits. (LogRead - PhyRead)/LogRead	DEPENDENT	oracle.buffer_cache_hit_ratio Preprocessing: - JSONPATH: `$[?(@.METRIC=='SYS::Buffer Cache Hit Ratio')].VALUE.first()`
Oracle	Oracle: Cursor cache hit ratio	Ratio of cursor cache hits. CursorCacheHit/SoftParse	DEPENDENT	oracle.cursor_cache_hit_ratio Preprocessing: - JSONPATH: `$[?(@.METRIC=='SYS::Cursor Cache Hit Ratio')].VALUE.first()`
Oracle	Oracle: Library cache hit ratio	Ratio of library cache hits. Hits/Pins	DEPENDENT	oracle.library_cache_hit_ratio Preprocessing: - JSONPATH: `$[?(@.METRIC=='SYS::Library Cache Hit Ratio')].VALUE.first()`
Oracle	Oracle: Shared pool free %	Shared pool free memory percent. Free/Total	DEPENDENT	oracle.shared_pool_free Preprocessing: - JSONPATH: `$[?(@.METRIC=='SYS::Shared Pool Free %')].VALUE.first()`
Oracle	Oracle: Physical reads per second	Reads per second.	DEPENDENT	oracle.physical_reads_rate Preprocessing: - JSONPATH: `$[?(@.METRIC=='SYS::Physical Reads Per Sec')].VALUE.first()`
Oracle	Oracle: Physical writes per second	Writes per second.	DEPENDENT	oracle.physical_writes_rate Preprocessing: - JSONPATH: `$[?(@.METRIC=='SYS::Physical Writes Per Sec')].VALUE.first()`
Oracle	Oracle: Physical reads bytes per second	Read bytes per second.	DEPENDENT	oracle.physical_read_bytes_rate Preprocessing: - JSONPATH: `$[?(@.METRIC=='SYS::Physical Read Bytes Per Sec')].VALUE.first()`
Oracle	Oracle: Physical writes bytes per second	Write bytes per second.	DEPENDENT	oracle.physical_write_bytes_rate Preprocessing: - JSONPATH: `$[?(@.METRIC=='SYS::Physical Write Bytes Per Sec')].VALUE.first()`
Oracle	Oracle: Enqueue timeouts per second	Enqueue timeouts per second.	DEPENDENT	oracle.enqueue_timeouts_rate Preprocessing: - JSONPATH: `$[?(@.METRIC=='SYS::Enqueue Timeouts Per Sec')].VALUE.first()`
Oracle	Oracle: GC CR block received per second	GC CR block received per second.	DEPENDENT	oracle.gc_cr_block_received_rate Preprocessing: - JSONPATH: `$[?(@.METRIC=='SYS::GC CR Block Received Per Second')].VALUE.first()`
Oracle	Oracle: Global cache blocks corrupted	The number of blocks that encountered a corruption or checksum failure during interconnect.	DEPENDENT	oracle.cache_blocks_corrupt Preprocessing: - JSONPATH: `$[?(@.METRIC=='SYS::Global Cache Blocks Corrupted')].VALUE.first()`
Oracle	Oracle: Global cache blocks lost	The number of global cache blocks lost	DEPENDENT	oracle.cache_blocks_lost Preprocessing: - JSONPATH: `$[?(@.METRIC=='SYS::Global Cache Blocks Lost')].VALUE.first()`
Oracle	Oracle: Logons per second	The number of logon attempts.	DEPENDENT	oracle.logons_rate Preprocessing: - JSONPATH: `$[?(@.METRIC=='SYS::Logons Per Sec')].VALUE.first()`
Oracle	Oracle: Average active sessions	The average active sessions at a point in time. It is the number of sessions that are either working or waiting.	DEPENDENT	oracle.active_sessions Preprocessing: - JSONPATH: `$[?(@.METRIC=='SYS::Average Active Sessions')].VALUE.first()`
Oracle	Oracle: Session count	Session count.	DEPENDENT	oracle.session_count Preprocessing: - JSONPATH: `$[?(@.METRIC=='SESSION::Total')].VALUE.first()`
Oracle	Oracle: Active user sessions	The number of active user sessions.	DEPENDENT	oracle.session_active_user Preprocessing: - JSONPATH: `$[?(@.METRIC=='SESSION::Active User')].VALUE.first()` ⛔️ON_FAIL: `CUSTOM_VALUE -> 0`
Oracle	Oracle: Active background sessions	The number of active background sessions.	DEPENDENT	oracle.session_active_background Preprocessing: - JSONPATH: `$[?(@.METRIC=='SESSION::Active Background')].VALUE.first()` ⛔️ON_FAIL: `CUSTOM_VALUE -> 0`
Oracle	Oracle: Inactive user sessions	The number of inactive user sessions.	DEPENDENT	oracle.session_inactive_user Preprocessing: - JSONPATH: `$[?(@.METRIC=='SESSION::Inactive User')].VALUE.first()` ⛔️ON_FAIL: `CUSTOM_VALUE -> 0`
Oracle	Oracle: Sessions lock rate	The percentage of locked sessions. Locks are mechanisms that prevent destructive interaction between transactions accessing the same resource—either user objects such as tables and rows or system objects not visible to users, such as shared data structures in memory and data dictionary rows.	DEPENDENT	oracle.session_lock_rate Preprocessing: - JSONPATH: `$[?(@.METRIC=='SESSION::Lock rate')].VALUE.first()`
Oracle	Oracle: Sessions locked over {$ORACLE.SESSION.LOCK.MAX.TIME}s	Count of the prolongely locked sessions. (You can change maximum session lock duration in seconds for query by {$ORACLE.SESSION.LOCK.MAX.TIME} macro. Default 600 sec)	DEPENDENT	oracle.session_long_time_locked Preprocessing: - JSONPATH: `$[?(@.METRIC=='SESSION::Long time locked')].VALUE.first()`
Oracle	Oracle: Sessions concurrency	The percentage of concurrency. Concurrency is a DB behaviour when different transactions request to change the same resource - in case of modifying data transactions sequentially block temporarily the right to change data, the rest of the transactions are waiting for access. In the case when access for resource is locked for a long time, then the concurrency grows (like the transaction queue) and this often has an extremely negative impact on performance. A high contention value does not indicate the root cause of the problem, but is a signal to search for it.	DEPENDENT	oracle.session_concurrency_rate Preprocessing: - JSONPATH: `$[?(@.METRIC=='SESSION::Concurrency rate')].VALUE.first()`
Oracle	Oracle: User '{$ORACLE.USER}' expire password	The number of days before zabbix account password expired.	DEPENDENT	oracle.user_expire_password Preprocessing: - JSONPATH: `$[?(@.METRIC=='USER::Expire password')].VALUE.first()`
Oracle	Oracle: Active serial sessions	The number of active serial sessions.	DEPENDENT	oracle.active_serial_sessions Preprocessing: - JSONPATH: `$[?(@.METRIC=='SYS::Active Serial Sessions')].VALUE.first()`
Oracle	Oracle: Active parallel sessions	The number of active parallel sessions.	DEPENDENT	oracle.active_parallel_sessions Preprocessing: - JSONPATH: `$[?(@.METRIC=='SYS::Active Parallel Sessions')].VALUE.first()`
Oracle	Oracle: Long table scans per second	The number of long table scans per second. A table is considered 'long' if the table is not cached and if its high-water mark is greater than 5 blocks.	DEPENDENT	oracle.long_table_scans_rate Preprocessing: - JSONPATH: `$[?(@.METRIC=='SYS::Long Table Scans Per Sec')].VALUE.first()`
Oracle	Oracle: SQL service response time	SQL service response time in seconds.	DEPENDENT	oracle.service_response_time Preprocessing: - JSONPATH: `$[?(@.METRIC=='SYS::SQL Service Response Time')].VALUE.first()` - MULTIPLIER: `0.01`
Oracle	Oracle: User rollbacks per second	The number of times that users manually issue the ROLLBACK statement or an error occurred during a user's transactions.	DEPENDENT	oracle.user_rollbacks_rate Preprocessing: - JSONPATH: `$[?(@.METRIC=='SYS::User Rollbacks Per Sec')].VALUE.first()`
Oracle	Oracle: Total sorts per user call	Total sorts per user call.	DEPENDENT	oracle.sorts_per_user_call Preprocessing: - JSONPATH: `$[?(@.METRIC=='SYS::Total Sorts Per User Call')].VALUE.first()`
Oracle	Oracle: Rows per sort	The average number of rows per sort for all types of sorts performed.	DEPENDENT	oracle.rows_per_sort Preprocessing: - JSONPATH: `$[?(@.METRIC=='SYS::Rows Per Sort')].VALUE.first()`
Oracle	Oracle: Disk sort per second	The number of sorts going to disk per second	DEPENDENT	oracle.disk_sorts Preprocessing: - JSONPATH: `$[?(@.METRIC=='SYS::Disk Sort Per Sec')].VALUE.first()`
Oracle	Oracle: Memory sorts ratio	The percentage of sorts (from ORDER BY clauses or index building) that are done to disk vs in-memory.	DEPENDENT	oracle.memory_sorts_ratio Preprocessing: - JSONPATH: `$[?(@.METRIC=='SYS::Memory Sorts Ratio')].VALUE.first()`
Oracle	Oracle: Database wait time ratio	Wait time: the time that the server process spends waiting for available shared resources (to be released by other server processes) such as latches, locks, data buffers, and so on	DEPENDENT	oracle.database_wait_time_ratio Preprocessing: - JSONPATH: `$[?(@.METRIC=='SYS::Database Wait Time Ratio')].VALUE.first()`
Oracle	Oracle: Database CPU time ratio	Calculated by dividing the total CPU used by the database by the Oracle time model statistic DB time.	DEPENDENT	oracle.database_cpu_time_ratio Preprocessing: - JSONPATH: `$[?(@.METRIC=='SYS::Database CPU Time Ratio')].VALUE.first()`
Oracle	Oracle: Temp space used	Temp space used.	DEPENDENT	oracle.temp_space_used Preprocessing: - JSONPATH: `$[?(@.METRIC=='SYS::Temp Space Used')].VALUE.first()`
Oracle	Oracle: PGA, Total inuse	Indicates how much PGA memory is currently consumed by work areas. This number can be used to determine how much memory is consumed by other consumers of the PGA memory (for example, PL/SQL or Java).	DEPENDENT	oracle.total_pga_used Preprocessing: - JSONPATH: `$[?(@.METRIC=='PGA::Total Pga Inuse')].VALUE.first()`
Oracle	Oracle: PGA, Aggregate target parameter	Current value of the PGA_AGGREGATE_TARGET initialization parameter. If this parameter is not set, then its value is 0 and automatic management of PGA memory is disabled.	DEPENDENT	oracle.pga_target Preprocessing: - JSONPATH: `$[?(@.METRIC=='PGA::Aggregate Pga Target Parameter')].VALUE.first()`
Oracle	Oracle: PGA, Total allocated	Current amount of PGA memory allocated by the instance. The Oracle Database attempts to keep this number below the value of the PGA_AGGREGATE_TARGET initialization parameter. However, it is possible for the PGA allocated to exceed that value by a small percentage and for a short period of time when the work area workload is increasing very rapidly or when PGA_AGGREGATE_TARGET is set to a small value.	DEPENDENT	oracle.total_pga_allocated Preprocessing: - JSONPATH: `$[?(@.METRIC=='PGA::Total Pga Allocated')].VALUE.first()`
Oracle	Oracle: PGA, Total freeable	Number of bytes of PGA memory in all processes that could be freed back to the operating system.	DEPENDENT	oracle.total_pga_freeable Preprocessing: - JSONPATH: `$[?(@.METRIC=='PGA::Total Freeable Pga Memory')].VALUE.first()`
Oracle	Oracle: PGA, Global memory bound	Maximum size of a work area executed in automatic mode.	DEPENDENT	oracle.pga_global_bound Preprocessing: - JSONPATH: `$[?(@.METRIC=='PGA::Global Memory Bound')].VALUE.first()`
Oracle	Oracle: FRA, Space limit	Maximum amount of disk space (in bytes) that the database can use for the fast recovery area.	DEPENDENT	oracle.fra_space_limit Preprocessing: - JSONPATH: `$[?(@.METRIC=='FRA::Space Limit')].VALUE.first()` ⛔️ON_FAIL: `CUSTOM_VALUE -> 0`
Oracle	Oracle: FRA, Used space	Amount of disk space (in bytes) used by fast recovery area files created in current and all previous fast recovery areas.	DEPENDENT	oracle.fra_space_used Preprocessing: - JSONPATH: `$[?(@.METRIC=='FRA::Space Used')].VALUE.first()` ⛔️ON_FAIL: `CUSTOM_VALUE -> 0`
Oracle	Oracle: FRA, Space reclaimable	Total amount of disk space (in bytes) that can be created by deleting obsolete, redundant, and other low priority files from the fast recovery area.	DEPENDENT	oracle.fra_space_reclaimable Preprocessing: - JSONPATH: `$[?(@.METRIC=='FRA::Space Reclaimable')].VALUE.first()` ⛔️ON_FAIL: `CUSTOM_VALUE -> 0`
Oracle	Oracle: FRA, Number of files	Number of files in the fast recovery area	DEPENDENT	oracle.fra_number_of_files Preprocessing: - JSONPATH: `$[?(@.METRIC=='FRA::Number Of Files')].VALUE.first()` ⛔️ON_FAIL: `CUSTOM_VALUE -> 0`
Oracle	Oracle: FRA, Used space in %		DEPENDENT	oracle.fra_usable_pct Preprocessing: - JSONPATH: `$[?(@.METRIC=='FRA::Usable Pct')].VALUE.first()` ⛔️ON_FAIL: `CUSTOM_VALUE -> 0`
Oracle	Oracle: FRA, Number of restore points		DEPENDENT	oracle.fra_restore_point Preprocessing: - JSONPATH: `$[?(@.METRIC=='FRA::Restore Point')].VALUE.first()`
Oracle	Oracle: SGA, java pool	Memory is allocated from the java pool.	DEPENDENT	oracle.sga_java_pool Preprocessing: - JSONPATH: `$[?(@.METRIC=='SGA::Java Pool')].VALUE.first()` ⛔️ON_FAIL: `CUSTOM_VALUE -> 0`
Oracle	Oracle: SGA, large pool	Memory is allocated from the large pool.	DEPENDENT	oracle.sga_large_pool Preprocessing: - JSONPATH: `$[?(@.METRIC=='SGA::Large Pool')].VALUE.first()` ⛔️ON_FAIL: `CUSTOM_VALUE -> 0`
Oracle	Oracle: SGA, shared pool	Memory is allocated from the shared pool.	DEPENDENT	oracle.sga_shared_pool Preprocessing: - JSONPATH: `$[?(@.METRIC=='SGA::Shared Pool')].VALUE.first()` ⛔️ON_FAIL: `CUSTOM_VALUE -> 0`
Oracle	Oracle: SGA, log buffer	The number of bytes allocated for the redo log buffer.	DEPENDENT	oracle.sga_log_buffer Preprocessing: - JSONPATH: `$[?(@.METRIC=='SGA::Log_Buffer')].VALUE.first()` ⛔️ON_FAIL: `CUSTOM_VALUE -> 0`
Oracle	Oracle: SGA, fixed	The fixed SGA is an internal housekeeping area.	DEPENDENT	oracle.sga_fixed Preprocessing: - JSONPATH: `$[?(@.METRIC=='SGA::Fixed_Sga')].VALUE.first()` ⛔️ON_FAIL: `CUSTOM_VALUE -> 0`
Oracle	Oracle: SGA, buffer cache	The size of the cache of standard blocks.	DEPENDENT	oracle.sga_buffer_cache Preprocessing: - JSONPATH: `$[?(@.METRIC=='SGA::Buffer_Cache')].VALUE.first()` ⛔️ON_FAIL: `CUSTOM_VALUE -> 0`
Oracle	Oracle: Redo logs available to switch	Number of available for log switching inactive/unused REDO logs.	DEPENDENT	oracle.redo_logs_available Preprocessing: - JSONPATH: `$[?(@.METRIC=='REDO::Available')].VALUE.first()`
Oracle	Oracle Database '{#DBNAME}': Open status	1 - 'MOUNTED', 2 - 'READ WRITE', 3 - 'READ ONLY', 4 - 'READ ONLY WITH APPLY' (A physical standby database is open in real-time query mode)	DEPENDENT	oracle.db_open_mode["{#DBNAME}"] Preprocessing: - JSONPATH: `$[?(@.DBNAME=='{#DBNAME}')].OPEN_MODE.first()` - DISCARD_UNCHANGED_HEARTBEAT: `15m`
Oracle	Oracle Database '{#DBNAME}': Role	Current role of the database, 1 - 'SNAPSHOT STANDBY', 2 - 'LOGICAL STANDBY', 3 - 'PHYSICAL STANDBY', 4 - 'PRIMARY ', 5 -'FAR SYNC'	DEPENDENT	oracle.db_role["{#DBNAME}"] Preprocessing: - JSONPATH: `$[?(@.DBNAME=='{#DBNAME}')].ROLE.first()` - DISCARD_UNCHANGED_HEARTBEAT: `15m`
Oracle	Oracle Database '{#DBNAME}': Log mode	Archive log mode, 0 - 'NOARCHIVELOG', 1 - 'ARCHIVELOG', 2 - 'MANUAL'	DEPENDENT	oracle.db_log_mode["{#DBNAME}"] Preprocessing: - JSONPATH: `$[?(@.DBNAME=='{#DBNAME}')].LOG_MODE.first()` - DISCARD_UNCHANGED_HEARTBEAT: `15m`
Oracle	Oracle Database '{#DBNAME}': Force logging	Indicates whether the database is under force logging mode (YES) or not (NO)	DEPENDENT	oracle.db_force_logging["{#DBNAME}"] Preprocessing: - JSONPATH: `$[?(@.DBNAME=='{#DBNAME}')].FORCE_LOGGING.first()` - DISCARD_UNCHANGED_HEARTBEAT: `15m`
Oracle	Oracle Database '{#DBNAME}': Open status	1 - 'MOUNTED', 2 - 'READ WRITE', 3 - 'READ ONLY', 4 - 'READ ONLY WITH APPLY' (A physical standby database is open in real-time query mode)	DEPENDENT	oracle.pdb_open_mode["{#DBNAME}"] Preprocessing: - JSONPATH: `$[?(@.DBNAME=='{#DBNAME}')].OPEN_MODE.first()` - DISCARD_UNCHANGED_HEARTBEAT: `15m`
Oracle	Oracle TBS '{#TABLESPACE}': Tablespace allocated, bytes	Currently allocated bytes for tablespace (sum of the current size of datafiles).	DEPENDENT	oracle.tbs_alloc_bytes["{#TABLESPACE}"] Preprocessing: - JSONPATH: `$[?(@.TABLESPACE=='{#TABLESPACE}')].USED_BYTES.first()`
Oracle	Oracle TBS '{#TABLESPACE}': Tablespace MAX size, bytes	Maximum size of tablespace.	DEPENDENT	oracle.tbs_max_bytes["{#TABLESPACE}"] Preprocessing: - JSONPATH: `$[?(@.TABLESPACE=='{#TABLESPACE}')].MAX_BYTES.first()`
Oracle	Oracle TBS '{#TABLESPACE}': Tablespace free, bytes	Free bytes of allocated space.	DEPENDENT	oracle.tbs_free_bytes["{#TABLESPACE}"] Preprocessing: - JSONPATH: `$[?(@.TABLESPACE=='{#TABLESPACE}')].FREE_BYTES.first()`
Oracle	Oracle TBS '{#TABLESPACE}': Tablespace usage percent	Allocated bytes/Max bytes*100	DEPENDENT	oracle.tbs_used_pct["{#TABLESPACE}"] Preprocessing: - JSONPATH: `$[?(@.TABLESPACE=='{#TABLESPACE}')].USED_PCT.first()`
Oracle	Oracle TBS '{#TABLESPACE}': Open status	Tablespace status. 1 - 'ONLINE' 2 - 'OFFLINE' 3- 'READ ONLY'	DEPENDENT	oracle.tbs_status["{#TABLESPACE}"] Preprocessing: - JSONPATH: `$[?(@.TABLESPACE=='{#TABLESPACE}')].STATUS.first()`
Oracle	Archivelog '{#DEST_NAME}': Error	Displays the error text	DEPENDENT	oracle.archivelog_error["{#DEST_NAME}"] Preprocessing: - JSONPATH: `$[?(@.DEST_NAME=='{#DEST_NAME}')].ERROR.first()`
Oracle	Archivelog '{#DEST_NAME}': Last sequence	Identifies the sequence number of the last archived redo log to be archived	DEPENDENT	oracle.archivelog_log_sequence["{#DEST_NAME}"] Preprocessing: - JSONPATH: `$[?(@.DEST_NAME=='{#DEST_NAME}')].LOG_SEQUENCE.first()`
Oracle	Archivelog '{#DEST_NAME}': Status	Identifies the current status of the destination: 1 - 'Valid', 2 - 'Dederred',3 - 'Error', 0 - 'Unknown'	DEPENDENT	oracle.archivelog_log_status["{#DEST_NAME}"] Preprocessing: - JSONPATH: `$[?(@.DEST_NAME=='{#DEST_NAME}')].STATUS.first()`
Oracle	ASM '{#DG_NAME}': Total size	Total size of ASM disk group.	DEPENDENT	oracle.asm_total_size["{#DG_NAME}"] Preprocessing: - JSONPATH: `$[?(@.DG_NAME=='{#DG_NAME}')].SIZE_BYTE.first()`
Oracle	ASM '{#DG_NAME}': Free size	Free size of ASM disk group.	DEPENDENT	oracle.asm_free_size["{#DG_NAME}"] Preprocessing: - JSONPATH: `$[?(@.DG_NAME=='{#DG_NAME}')].FREE_SIZE_BYTE.first()`
Oracle	ASM '{#DG_NAME}': Free size	Usage percent of ASM disk group.	DEPENDENT	oracle.asm_used_pct["{#DG_NAME}"] Preprocessing: - JSONPATH: `$[?(@.DG_NAME=='{#DG_NAME}')].USED_PERCENT.first()`
Zabbix_raw_items	Oracle: Get instance state	The item gets state of the current instance.	ODBC	db.odbc.get[get_instance_state,"{$ORACLE.DSN}"] Expression: `SELECT INSTANCE_NAME, HOST_NAME, VERSION \|\| '-' \|\| EDITION AS VERSION, floor((SYSDATE - startup_time)6060*24) AS UPTIME, decode(status,'STARTED',1,'MOUNTED',2,'OPEN',3,'OPEN MIGRATE',4, 0) AS STATUS, decode(archiver,'STOPPED',1,'STARTED',2,'FAILED',3, 0) AS ARCHIVER, decode(instance_role,'PRIMARY_INSTANCE',1,'SECONDARY_INSTANCE',2, 0) AS INSTANCE_ROLE FROM v$instance;`
Zabbix_raw_items	Oracle: Get system metrics	The item gets system metric values.	ODBC	db.odbc.get[get_system_metrics,"{$ORACLE.DSN}"] Expression: SELECT 'SYS::' \|\| METRIC_NAME AS METRIC, ROUND(VALUE,3) as VALUE FROM V$SYSMETRIC WHERE GROUP_ID = 2 UNION SELECT 'SYSPARAM::' \|\| INITCAP(NAME) AS METRIC, to_number(VALUE) FROM V$SYSTEM_PARAMETER WHERE NAME IN ('sessions', 'processes', 'db_files') UNION SELECT 'SESSION::' \|\| INITCAP(STATUS)\|\| ' ' \|\| INITCAP(TYPE) AS METRIC, COUNT() AS VALUE FROM V$SESSION GROUP BY STATUS, TYPE UNION SELECT 'SESSION::Total', COUNT() AS VALUE FROM V$SESSION UNION SELECT 'SESSION::Long time locked' ,count() FROM V$SESSION s WHERE s.BLOCKING_SESSION IS NOT NULL AND s.BLOCKING_SESSION_STATUS='VALID' AND s.SECONDS_IN_WAIT > {$ORACLE.SESSION.LOCK.MAX.TIME} UNION SELECT 'SESSION::Lock rate' ,(cnt_block / cnt_all) 100 pct FROM ( SELECT COUNT() cnt_block FROM v$session WHERE blocking_session IS NOT NULL), ( SELECT COUNT() cnt_all FROM v$session) UNION SELECT 'SESSION::Concurrency rate', NVL(ROUND(SUM(duty_act.cnt100 / num_cores.val)), 0) FROM ( SELECT DECODE(session_state, 'ON CPU', 'CPU', wait_class) wait_class, ROUND(COUNT()/(60 * 15), 1) cnt FROM v$active_session_history sh WHERE sh.sample_time >= SYSDATE - 15 / 1440 AND DECODE(session_state, 'ON CPU', 'CPU', wait_class) IN('Concurrency') GROUP BY DECODE(session_state, 'ON CPU', 'CPU', wait_class)) duty_act, ( SELECT SUM(value) val FROM v$osstat WHERE stat_name = 'NUM_CPU_CORES') num_cores UNION SELECT 'PGA::' \|\| INITCAP(NAME), VALUE FROM V$PGASTAT UNION SELECT 'FRA::Space Limit' AS METRIC, space_limit AS VALUE FROM V$RECOVERY_FILE_DEST UNION SELECT 'FRA::Space Used', space_used AS VALUE FROM V$RECOVERY_FILE_DEST UNION SELECT 'FRA::Space Reclaimable', space_reclaimable AS VALUE FROM V$RECOVERY_FILE_DEST UNION SELECT 'FRA::Number Of Files', number_of_files AS VALUE FROM V$RECOVERY_FILE_DEST UNION SELECT 'FRA::Usable Pct', DECODE(space_limit, 0, 0,(100-(100 (space_used-space_reclaimable)/ space_limit))) AS VALUE FROM V$RECOVERY_FILE_DEST UNION SELECT 'FRA::Restore Point', COUNT() AS VALUE FROM V$RESTORE_POINT UNION SELECT 'PROC::Procnum', COUNT() FROM v$process UNION SELECT 'DATAFILE::Count', COUNT() FROM v$datafile UNION SELECT 'SGA::' \|\| INITCAP(pool), SUM(bytes) FROM V$SGASTAT WHERE pool IN ( 'java pool', 'large pool' ) GROUP BY pool UNION SELECT 'SGA::Shared Pool', SUM(bytes) FROM V$SGASTAT WHERE pool = 'shared pool' AND name NOT IN ('library cache', 'dictionary cache', 'free memory', 'sql area') UNION SELECT 'SGA::' \|\| INITCAP(name), bytes FROM V$SGASTAT WHERE pool IS NULL AND name IN ('log_buffer', 'fixed_sga') UNION SELECT 'SGA::Buffer_Cache', SUM(bytes) FROM V$SGASTAT WHERE pool IS NULL AND name IN ('buffer_cache', 'db_block_buffers') UNION SELECT 'REDO::Available', count(*) from v$log t where t.status in ('INACTIVE', 'UNUSED') UNION SELECT 'USER::Expire password', ROUND(DECODE(SIGN(NVL(u.expiry_date, SYSDATE + 999) - SYSDATE),-1, 0, NVL(u.expiry_date, SYSDATE + 999) - SYSDATE)) exp_passwd_days_before FROM dba_users u WHERE username = UPPER('{$ORACLE.USER}');
Zabbix_raw_items	Oracle: Get tablespaces stats	Get tablespaces stats.	ODBC	db.odbc.get[tablespace_stats,"{$ORACLE.DSN}"] Expression: SELECT df.tablespace_name AS tablespace, df.type AS TYPE, SUM(df.bytes) AS used_bytes, SUM(df.max_bytes) AS max_bytes, SUM(f.free) AS free_bytes, ROUND(SUM(df.bytes)/ SUM(df.max_bytes)* 100, 2) AS used_pct, DECODE(df.status, 'ONLINE', 1, 'OFFLINE', 2, 'READ ONLY', 3, 0) AS status FROM ( SELECT ddf.file_id, dt.contents AS TYPE, dt.STATUS , ddf.file_name, ddf.tablespace_name, TRUNC(ddf.bytes) AS bytes, TRUNC(GREATEST(ddf.bytes, ddf.maxbytes)) AS max_bytes FROM dba_data_files ddf, dba_tablespaces dt WHERE ddf.tablespace_name = dt.tablespace_name ) df, ( SELECT TRUNC(SUM(bytes)) AS FREE, file_id FROM dba_free_space GROUP BY file_id ) f WHERE df.file_id = f.file_id (+) GROUP BY df.tablespace_name, df.TYPE, df.status UNION ALL SELECT Y.name AS tablespace_name, Y.type AS TYPE, SUM(Y.bytes) AS bytes, SUM(Y.max_bytes) AS max_bytes, MAX(NVL(Y.free_bytes, 0)) AS FREE, ROUND(SUM(Y.bytes)/ SUM(Y.max_bytes)* 100, 2) AS used_pct, DECODE(Y.tbs_status, 'ONLINE', 1, 'OFFLINE', 2, 'READ ONLY', 3, 0) AS status FROM ( SELECT dtf.tablespace_name AS name, dt.contents AS TYPE, dt.STATUS AS tbs_status, dtf.status AS status, dtf.bytes AS bytes, (SELECT ((f.total_blocks - s.tot_used_blocks)* vp.value) FROM ( SELECT tablespace_name, SUM(used_blocks) tot_used_blocks FROM gv$sort_segment WHERE tablespace_name != 'DUMMY' GROUP BY tablespace_name) s, ( SELECT tablespace_name, SUM(blocks) total_blocks FROM dba_temp_files WHERE tablespace_name != 'DUMMY' GROUP BY tablespace_name) f, ( SELECT value FROM v$parameter WHERE name = 'db_block_size') vp WHERE f.tablespace_name = s.tablespace_name AND f.tablespace_name = dtf.tablespace_name ) AS free_bytes, CASE WHEN dtf.maxbytes = 0 THEN dtf.bytes ELSE dtf.maxbytes END AS max_bytes FROM sys.dba_temp_files dtf, sys.dba_tablespaces dt WHERE dtf.tablespace_name = dt.tablespace_name ) Y GROUP BY Y.name, Y.TYPE, Y.tbs_status ORDER BY tablespace;
Zabbix_raw_items	Oracle: Get CDB and No-CDB info	Get info about CDB and No-CDB databases on instansce.	ODBC	db.odbc.get[get_cdb_info,"{$ORACLE.DSN}"] Expression: `SELECT name as DBNAME, DECODE(open_mode, 'MOUNTED', 1, 'READ ONLY', 2, 'READ WRITE', 3, 'READ ONLY WITH APPLY', 4, 'MIGRATE', 5, 0) AS open_mode, DECODE(database_role, 'SNAPSHOT STANDBY', 1, 'LOGICAL STANDBY', 2, 'PHYSICAL STANDBY', 3, 'PRIMARY', 4, 'FAR SYNC', 5, 0) AS ROLE, DECODE(force_logging, 'YES',1,'NO',0,0) AS force_logging, DECODE(log_mode, 'MANUAL',2 ,'ARCHIVELOG',1,'NOARCHIVELOG',0,0) AS log_mode FROM v$database`
Zabbix_raw_items	Oracle: Get PDB info	Get info about PDB databases on instansce.	ODBC	db.odbc.get[get_pdb_info,"{$ORACLE.DSN}"] Expression: `SELECT name as DBNAME, DECODE(open_mode, 'MOUNTED', 1, 'READ ONLY', 2, 'READ WRITE', 3, 'READ ONLY WITH APPLY', 4, 'MIGRATE', 5, 0) AS open_mode FROM v$pdbs;`
Zabbix_raw_items	Oracle: Get archive log info		ODBC	db.odbc.get[get_archivelog_stat,"{$ORACLE.DSN}"] Expression: `SELECT d.dest_name, DECODE (d.status, 'VALID',3, 'DEFERRED', 2, 'ERROR', 1, 0) AS status, d.log_sequence, d.error FROM v$archive_dest d , v$database db WHERE d.status != 'INACTIVE' AND db.log_mode = 'ARCHIVELOG';`
Zabbix_raw_items	Oracle: Get ASM stats	Get ASM disk groups stats.	ODBC	db.odbc.get[get_asm_stat,"{$ORACLE.DSN}"] Expression: `SELECT name AS dg_name, ROUND(total_mb / DECODE(TYPE, 'NORMAL', 2, 'HIGH', 3, 'EXTERN', 1)10241024) AS size_byte, ROUND(usable_file_mb10241024 ) AS free_size_byte, ROUND(100-(usable_file_mb /(total_mb / DECODE(TYPE, 'NORMAL', 2, 'HIGH', 3, 'EXTERN', 1)))* 100, 2) AS used_percent FROM v$asm_diskgroup ;`

Triggers

Name	Description	Expression	Severity	Dependencies and additional info
Oracle: Port {$ORACLE.PORT} is unavailable	The TCP port of the Oracle Server service is currently unavailable.	`{TEMPLATE_NAME:net.tcp.service[tcp,{HOST.CONN},{$ORACLE.PORT}].max(#3)}=0 and {Template DB Oracle by ODBC:proc.num[,,,"tnslsnr LISTENER"].max(#3)}>0`	DISASTER
Oracle: LISTENER process is not running		`{TEMPLATE_NAME:proc.num[,,,"tnslsnr LISTENER"].max(#3)}=0`	DISASTER
Oracle: Version has changed (new version value received: {ITEM.VALUE})	Oracle DB version has changed. Ack to close.	`{TEMPLATE_NAME:oracle.version.diff()}=1 and {TEMPLATE_NAME:oracle.version.strlen()}>0`	INFO	Manual close: YES
Oracle: has been restarted (uptime < 10m)	Uptime is less than 10 minutes	`{TEMPLATE_NAME:oracle.uptime.last()}<10m`	INFO	Manual close: YES
Oracle: Failed to fetch info data (or no data for 5m)	Zabbix has not received data for items for the last 5 minutes. The database might be unavailable for connecting.	`{TEMPLATE_NAME:oracle.uptime.nodata(5m)}=1`	WARNING	Depends on: - Oracle: Port {$ORACLE.PORT} is unavailable
Oracle: Instance name has changed (new name received: {ITEM.VALUE})	Oracle DB Instance name has changed. Ack to close.	`{TEMPLATE_NAME:oracle.instance_name.diff()}=1 and {TEMPLATE_NAME:oracle.instance_name.strlen()}>0`	INFO	Manual close: YES
Oracle: Instance hostname has changed (new hostname received: {ITEM.VALUE})	Oracle DB Instance hostname has changed. Ack to close.	`{TEMPLATE_NAME:oracle.instance_hostname.diff()}=1 and {TEMPLATE_NAME:oracle.instance_hostname.strlen()}>0`	INFO	Manual close: YES
Oracle: Too many active processes (over {$ORACLE.PROCESSES.MAX.WARN}% for 5 min)	Active processes are using more than {$ORACLE.PROCESSES.MAX.WARN}% of the available number of processes.	`{TEMPLATE_NAME:oracle.processes_count.min(5m)} * 100 / {Template DB Oracle by ODBC:oracle.processes_limit.last()} > {$ORACLE.PROCESSES.MAX.WARN}`	WARNING
Oracle: Too many database files (over {$ORACLE.DB.FILE.MAX.WARN}% for 5 min)	Number of datafiles is higher than {$ORACLE.DB.FILE.MAX.WARN}% of the available datafile files limit.	`{TEMPLATE_NAME:oracle.db_files_count.min(5m)} * 100 / {Template DB Oracle by ODBC:oracle.db_files_limit.last()} > {$ORACLE.DB.FILE.MAX.WARN}`	WARNING
Oracle: Shared pool free is too low (less {$ORACLE.SHARED.FREE.MIN.WARN}% for 5m)	The shared pool free memory percent has been less than {$ORACLE.SHARED.FREE.MIN.WARN}% in the last 5 minutes.	`{TEMPLATE_NAME:oracle.shared_pool_free.max(5m)}<{$ORACLE.SHARED.FREE.MIN.WARN}`	WARNING
Oracle: Too many active sessions (over {$ORACLE.SESSIONS.MAX.WARN}% for 5 min)	Active sessions are using more than {$ORACLE.SESSIONS.MAX.WARN}% of the available sessions.	`{TEMPLATE_NAME:oracle.session_count.min(5m)} * 100 / {Template DB Oracle by ODBC:oracle.session_limit.last()} > {$ORACLE.SESSIONS.MAX.WARN}`	WARNING
Oracle: Too many locked sessions (over {$ORACLE.SESSIONS.LOCK.MAX.WARN}% for 5 min)	Number of locked sessions is over {$ORACLE.SESSIONS.LOCK.MAX.WARN}% of the running sessions.	`{TEMPLATE_NAME:oracle.session_lock_rate.min(5m)} > {$ORACLE.SESSIONS.LOCK.MAX.WARN}`	WARNING
Oracle: Too many sessions locked over {$ORACLE.SESSION.LOCK.MAX.TIME}s (over {$ORACLE.SESSION.LONG.LOCK.MAX.WARN} for 5 min)	Number of sessions locked over {$ORACLE.SESSION.LOCK.MAX.TIME} seconds is too high. Long-term locks can negatively affect database performance, therefore, if they are detected, you should first find the most difficult queries from the database point of view and analyze possible resource leaks.	`{TEMPLATE_NAME:oracle.session_long_time_locked.min(5m)} > {$ORACLE.SESSION.LONG.LOCK.MAX.WARN}`	WARNING
Oracle: Too hight database concurrency (over {$ORACLE.CONCURRENCY.MAX.WARN}% for 5 min)	Concurrency rate is over {$ORACLE.CONCURRENCY.MAX.WARN}%. A high contention value does not indicate the root cause of the problem, but is a signal to search for it. In the case of high competition, an analysis of resource consumption should be carried out, the most "heavy" queries made in the database, possibly - session tracing. All this will help determine the root cause and possible optimization points both in the database configuration and in the logic of building queries of the application itself.	`{TEMPLATE_NAME:oracle.session_concurrency_rate.min(5m)} > {$ORACLE.CONCURRENCY.MAX.WARN}`	WARNING
Oracle: Zabbix account will expire soon (under {$ORACLE.EXPIRE.PASSWORD.MIN.WARN} days)	Password for zabbix user in the database will expire soon.	`{TEMPLATE_NAME:oracle.user_expire_password.last()} < {$ORACLE.EXPIRE.PASSWORD.MIN.WARN}`	WARNING
Oracle: Total PGA inuse is too high (over {$ORACLE.PGA.USE.MAX.WARN}% for 5 min)	Total PGA in use is more than {$ORACLE.PGA.USE.MAX.WARN}% of PGA_AGGREGATE_TARGET.	`{TEMPLATE_NAME:oracle.total_pga_used.min(5m)} * 100 / {Template DB Oracle by ODBC:oracle.pga_target.last()} > {$ORACLE.PGA.USE.MAX.WARN}`	WARNING
Oracle: Number of REDO logs available for switching is too low (less {$ORACLE.REDO.MIN.WARN} for 5 min)	Number of available for log switching inactive/unused REDOs is low (Database down risk)	`{TEMPLATE_NAME:oracle.redo_logs_available.max(5m)} < {$ORACLE.REDO.MIN.WARN}`	WARNING
Oracle Database '{#DBNAME}': Open status in mount mode	The Oracle DB has a MOUNTED state.	`{TEMPLATE_NAME:oracle.db_open_mode["{#DBNAME}"].last()}=1`	WARNING
Oracle Database '{#DBNAME}': Open status has changed (new value received: {ITEM.VALUE})	Oracle DB open status has changed. Ack to close.	`{TEMPLATE_NAME:oracle.db_open_mode["{#DBNAME}"].diff()}=1`	INFO	Manual close: YES Depends on: - Oracle Database '{#DBNAME}': Open status in mount mode
Oracle Database '{#DBNAME}': Role has changed (new value received: {ITEM.VALUE})	Oracle DB role has changed. Ack to close.	`{TEMPLATE_NAME:oracle.db_role["{#DBNAME}"].diff()}=1`	INFO	Manual close: YES
Oracle Database '{#DBNAME}': Force logging is deactivated for DB with active Archivelog	Force Logging mode - it is very important metric for Databases in 'ARCHIVELOG'. This feature allows to forcibly write all transactions to the REDO.	`{TEMPLATE_NAME:oracle.db_force_logging["{#DBNAME}"].last()} = 0 and {Template DB Oracle by ODBC:oracle.db_log_mode["{#DBNAME}"].last()} = 1`	WARNING
Oracle Database '{#DBNAME}': Open status in mount mode	The Oracle DB has a MOUNTED state.	`{TEMPLATE_NAME:oracle.pdb_open_mode["{#DBNAME}"].last()}=1`	WARNING
Oracle Database '{#DBNAME}': Open status has changed (new value received: {ITEM.VALUE})	Oracle DB open status has changed. Ack to close.	`{TEMPLATE_NAME:oracle.pdb_open_mode["{#DBNAME}"].diff()}=1`	INFO	Manual close: YES
Oracle TBS '{#TABLESPACE}': Tablespace usage is too high (over {$ORACLE.TBS.USED.PCT.MAX.WARN}% for 5m).		`{TEMPLATE_NAME:oracle.tbs_used_pct["{#TABLESPACE}"].min(5m)}>{$ORACLE.TBS.USED.PCT.MAX.WARN}`	WARNING	Depends on: - Oracle TBS '{#TABLESPACE}': Tablespace Usage is too high (over {$ORACLE.TBS.USED.PCT.MAX.HIGH}% for 5m).
Oracle TBS '{#TABLESPACE}': Tablespace Usage is too high (over {$ORACLE.TBS.USED.PCT.MAX.HIGH}% for 5m).		`{TEMPLATE_NAME:oracle.tbs_used_pct["{#TABLESPACE}"].min(5m)}>{$ORACLE.TBS.USED.PCT.MAX.HIGH}`	HIGH
Oracle TBS '{#TABLESPACE}': Tablespase is OFFLINE	The tablespase is in the offline state.	`{TEMPLATE_NAME:oracle.tbs_status["{#TABLESPACE}"].last()}=2`	WARNING
Oracle TBS '{#TABLESPACE}': Tablespace status has changed (new value received: {ITEM.VALUE})	Oracle tablespace status has changed. Ack to close.	`{TEMPLATE_NAME:oracle.tbs_status["{#TABLESPACE}"].diff()}=1`	INFO	Manual close: YES Depends on: - Oracle TBS '{#TABLESPACE}': Tablespase is OFFLINE
Archivelog '{#DEST_NAME}': Log Archive is not valid	ARL destination not in 3 - Valid or 2 - Deferred.	`{TEMPLATE_NAME:oracle.archivelog_log_status["{#DEST_NAME}"].last()}<2`	HIGH
ASM '{#DG_NAME}': Disk group usage is too high (over {$ORACLE.ASM.USED.PCT.MAX.WARN}% for 5m)	Usage percent of ASM disk group is over {$ORACLE.ASM.USED.PCT.MAX.WARN}	`{TEMPLATE_NAME:oracle.asm_used_pct["{#DG_NAME}"].min(5m)}>{$ORACLE.ASM.USED.PCT.MAX.WARN}`	WARNING	Depends on: - ASM '{#DG_NAME}': Disk group usage is too high (over {$ORACLE.ASM.USED.PCT.MAX.HIGH}% for 5m)
ASM '{#DG_NAME}': Disk group usage is too high (over {$ORACLE.ASM.USED.PCT.MAX.HIGH}% for 5m)	Usage percent of ASM disk group is over {$ORACLE.ASM.USED.PCT.MAX.WARN}	`{TEMPLATE_NAME:oracle.asm_used_pct["{#DG_NAME}"].min(5m)}>{$ORACLE.ASM.USED.PCT.MAX.HIGH}`	HIGH

Feedback

Please report any issues with the template at https://support.zabbix.com

Link	Source	Compatibility	Type, Technology	Created Updated	Rating
Generic database plugin - zbxdb A very simple but advanced monitoring solution for <b>databases</b>. It runs on a client machine so no extra software is needed on the database server. Just configure a client connection with enough privileges to be able to run queries in the databases that you want to monitor. ✔ Low Level Discovery (LLD) ✔ Zabbix Agent Active ✔ Zabbix Trapper ✔ Database Monitor ✔ SSH ✔ Custom Script github.com/ikzelf/zbxdb share.zabbix.com/zbxdb-generic-database-plugin	share.zabbix.com GitHub 76		Module, Template python Python	2018-07-27 5 m	Popular
Oracle monitoring script and template ✔ Zabbix Agent github.com/sergiotocalini/zabora share.zabbix.com/zabora	share.zabbix.com GitHub 33		External script, Template bash Shell	2018-02-28 3 y	Popular
DB Replication status for Oracle This Script monitors the difference between the Master and the Standby Oracle DB, by checking on both servers the latest Archiving Log applied. ✔ Database Monitor ✔ Custom Script github.com/lpossamai/zabbix_check_oracle_replication share.zabbix.com/monitoring-oracle-db-replication-status	share.zabbix.com GitHub 4		Externalscript, Template bash Shell	2018-07-01 2 y
Generic database plugin A simple to use plugin and template that contains lot`s of zabbix features. Automatic discovery for databases, instances, tablespaces, filegroups, parameters etc. The default set is aiming for resource management and availability. ✔ Low Level Discovery (LLD) ✔ Zabbix Trapper ✔ Database Monitor ✔ Custom Script github.com/ikzelf/zbxdb share.zabbix.com/zbxdb-generic-database-plugin-very-similar-to-zbxora	share.zabbix.com GitHub 76		Externalscript, Template bash, python Python	2018-07-04 2021 y
OracleVM monitoring template This one uses CLI and SNMP to collect the data, and supports LLD. ✔ Low Level Discovery (LLD) ✔ SNMP Agent ✔ Custom Script www.linuxelite.com.br/monitoramento/monitorando-oraclevm-no-zabbix-via-cli-e-snmp/ share.zabbix.com/oraclevm [sp]	share.zabbix.com 1665	2.4	Externalscript, Template perl	2017-06-09 3 y
Zabbix plugin to monitor RDBMS ZabbixDBA is fast, flexible, and continuously developing plugin to monitor your RDBMS. ZabbixDBA uses threading of DBI connections which is good for monitoring of multiple database instances simultaneously. Just configure it, run daemon and it will do all the job github.com/netrusov/ZabbixDBA	GitHub 68		Module, Template perl	2015-06-29 25 d	Popular
Oracle database monitoring through Zabbix. Active check version of Pyora github.com/Lelik13a/Zabbix-PyOra-ActiveCheck	GitHub 30		Script, Template python	2017-03-23 3 m	Popular
Oracle Database Monitoring on Zabbix Oracle monitoring script, that supports RAC. Written in GoLang github.com/FarhadF/orazabbix	GitHub 18		Script, Template golang	2017-06-27 1 m
Zabbix template for Oracle databases monitoring via ODBC This template monitors Oracle database health, performance, security audit, etc. This is kinda fork of Orabbix probes. github.com/den-is/zbx_oracle_odbc	GitHub 9		Template	2014-11-24 1 y
github.com/crmall/oracle-zabbix [pt]	GitHub 4		Shell	2015-06-03 3 y
Zabbix Oracle ODBC Template Zabbix Oracle ODBC Template with Tablespace Autodiscovery github.com/rodrigoluissilva/Zabbix-Oracle-ODBC-Template	GitHub 4		Template, odbc odbc	2016-07-25 10 m
Oracle replication monitoring Everything done on the Database (Monitoring) was done via scripting, as on the Standard version the Standby server cannot have the listener running. Because of that, I had to develop a simple Bash script so I could monitor the replication delay between a Master and a Slave Oracle DB. github.com/lpossamai/zabbix_check_oracle_replication	GitHub 4		Externalscripts, Template bash	2018-06-26 9 m
Template Oracle VM (SNMP) for ZABBIX This template uses the SNMP to monitoring Oracle VM Server. github.com/sshutdownow/zabbix-oracle-vm	GitHub 1		Template	2017-03-15 5 m
Monitoring for ORACLE DB on HP-UX, SUSE, Windows Oracle DB: 11.2.x.x & 12.1.x.x github.com/alexpaknix/zabbix	GitHub		Oracle DB Oracle DB, Suse	2013-08-02 9 m
Loadable module for Oracle github.com/alexander-nesterov/zabbix_module_oracle	GitHub		Module, Template C	2017-09-28 3 y

+ Propose new solution

Zabbix + Oracle

Oracle

Available solutions

Template DB Oracle by Zabbix Agent 2

Overview

Setup

Zabbix configuration

Macros used

Template links

Discovery rules

Items collected

Triggers

Feedback

Template DB Oracle by ODBC

Overview

Setup

Zabbix configuration

Macros used

Template links

Discovery rules

Items collected

Triggers

Feedback

Articles and documentation