zabbix_export:
  version: '5.4'
  date: '2021-11-21T21:26:55Z'
  groups:
    -
      uuid: 27ac506700814794a87868d9b6d01ef1
      name: Pyora
    -
      uuid: 7df96b18c230490a9a0a9e2307226338
      name: Templates
  templates:
    -
      uuid: 7eae89aae9d747498d89b12d7f25df33
      template: 'Pyora active send'
      name: 'Pyora active send'
      description: |
        ## Overview
        
        This is the fixed template for Zabbix PyOra to work on 3.0. I remove the unsupported tags and downgraded version. Note you will most likely have to update the triggers manually.
        
        
        
        
      groups:
        -
          name: Pyora
        -
          name: Templates
      items:
        -
          uuid: eee9d48665974377aedd54f02cc7638b
          name: 'Oracle/Active user count on {$DATABASE}'
          type: TRAP
          key: activeusercount
          delay: '0'
          history: 7d
          trends: 90d
          tags:
            -
              tag: Application
              value: Oracle
        -
          uuid: 4b41cdcb729848f498a36ce004afb95a
          name: 'Oracle/Buffer busy waits on {$DATABASE}'
          type: TRAP
          key: bufbusywaits
          delay: '0'
          history: 7d
          trends: 90d
          tags:
            -
              tag: Application
              value: Oracle
        -
          uuid: 99268a0aae02413398edd9c7bf0f1377
          name: 'Oracle/Instance is active and open on {$DATABASE}'
          type: TRAP
          key: check_active
          delay: '0'
          history: 7d
          trends: '0'
          value_type: CHAR
          tags:
            -
              tag: Application
              value: Oracle
          triggers:
            -
              uuid: 4a80f5acf59f466baff8ce517cef7ed6
              expression: 'find(/Pyora active send/check_active,,"regexp","ORA")=1'
              name: 'Database {$DATABASE} is down or ORA error found'
              priority: DISASTER
              description: 'Contact DBA.'
            -
              uuid: d66471dbc80c41438b91c68fab2798b5
              expression: 'nodata(/Pyora active send/check_active,800s)=1'
              name: 'Database {$DATABASE} is not responding'
              priority: HIGH
        -
          uuid: 1d020c383e134912b51ed9724547e4b7
          name: 'Oracle/Archive {$ARCHIVE} on {$DATABASE}'
          type: TRAP
          key: 'check_archive[{$ARCHIVE}]'
          delay: '0'
          history: 7d
          trends: 90d
          status: DISABLED
          units: '%'
          tags:
            -
              tag: Application
              value: Oracle
        -
          uuid: 674d36acd96142cf84f5bddbd8744348
          name: 'Oracle/User Commits on {$DATABASE}'
          type: TRAP
          key: commits
          delay: '0'
          history: 7d
          trends: 90d
          preprocessing:
            -
              type: CHANGE_PER_SECOND
              parameters:
                - ''
          tags:
            -
              tag: Application
              value: Oracle
        -
          uuid: 27ad0ada1df04db1954fcdc700bfa021
          name: 'Oracle/Size of all datafiles on {$DATABASE}'
          type: TRAP
          key: dbfilesize
          delay: '0'
          history: 7d
          trends: 90d
          units: B
          tags:
            -
              tag: Application
              value: Oracle
        -
          uuid: a6c04d13d6ac41b0936e6cf50f787f66
          name: 'Oracle/dbprllwrite on {$DATABASE}'
          type: TRAP
          key: dbprllwrite
          delay: '0'
          history: 7d
          trends: 90d
          preprocessing:
            -
              type: BOOL_TO_DECIMAL
              parameters:
                - ''
          tags:
            -
              tag: Application
              value: Oracle
        -
          uuid: 98fdd08fef714f37bdf7d1c53f4e815b
          name: 'Oracle/dbscattread on {$DATABASE}'
          type: TRAP
          key: dbscattread
          delay: '0'
          history: 7d
          trends: 90d
          tags:
            -
              tag: Application
              value: Oracle
        -
          uuid: 19f5c0b1ed4d43ef9c9c526e933273d3
          name: 'Oracle/dbseqread on {$DATABASE}'
          type: TRAP
          key: dbseqread
          delay: '0'
          history: 7d
          trends: 90d
          preprocessing:
            -
              type: BOOL_TO_DECIMAL
              parameters:
                - ''
          tags:
            -
              tag: Application
              value: Oracle
        -
          uuid: f9fa3d4c6a964f46a9e3e7182ed8373f
          name: 'Oracle/Size of user data (without temp) on {$DATABASE}'
          type: TRAP
          key: dbsize
          delay: '0'
          history: 7d
          trends: 90d
          units: B
          tags:
            -
              tag: Application
              value: Oracle
        -
          uuid: 41b3fd8460ec4d03ba87905459ecdd6d
          name: 'Oracle/dbsnglwrite {$DATABASE}'
          type: TRAP
          key: dbsnglwrite
          delay: '0'
          history: 7d
          trends: 90d
          tags:
            -
              tag: Application
              value: Oracle
        -
          uuid: 6e821678866f463187d77211ae5b6a0d
          name: 'Oracle/Deadlocks on {$DATABASE}'
          type: TRAP
          key: deadlocks
          delay: '0'
          history: 7d
          trends: 90d
          preprocessing:
            -
              type: CHANGE_PER_SECOND
              parameters:
                - ''
          tags:
            -
              tag: Application
              value: Oracle
        -
          uuid: 46125387f90349eda1d22b8402193f8e
          name: 'Oracle/Directread on {$DATABASE}'
          type: TRAP
          key: directread
          delay: '0'
          history: 7d
          trends: 90d
          tags:
            -
              tag: Application
              value: Oracle
        -
          uuid: 916b70db7dbf4146bc1712241759525e
          name: 'Oracle/Disk sorts ratio on {$DATABASE}'
          type: TRAP
          key: dsksortratio
          delay: '0'
          history: 7d
          trends: 90d
          value_type: FLOAT
          units: '%'
          tags:
            -
              tag: Application
              value: Oracle
        -
          uuid: 903c0fa3860f47778473f8fbe8b19858
          name: 'Oracle/Enqueue on {$DATABASE}'
          type: TRAP
          key: enqueue
          delay: '0'
          history: 7d
          trends: 90d
          status: DISABLED
          tags:
            -
              tag: Application
              value: Oracle
        -
          uuid: 69a75b0c5a6949a7ad5024e83e9bc9e3
          name: 'Zabbix failed checks on {$DATABASE}'
          type: TRAP
          key: failedchecks
          delay: '0'
          history: 7d
          trends: 90d
          triggers:
            -
              uuid: 179b7e788b5f4f788f572af5aa60a560
              expression: 'last(/Pyora active send/failedchecks)<>0'
              name: 'Zabbix sender failed checks count: {ITEM.LASTVALUE1}'
              priority: AVERAGE
        -
          uuid: 8268c51aba1b44d3a1a21811064bd69f
          name: 'Oracle/fra_use on {$DATABASE}'
          type: TRAP
          key: fra_use
          delay: '0'
          history: 7d
          trends: 90d
          status: DISABLED
          value_type: FLOAT
          tags:
            -
              tag: Application
              value: Oracle
          triggers:
            -
              uuid: 0c61714787f1463cbb3dad6fa181817d
              expression: 'last(/Pyora active send/fra_use)>90'
              name: 'fra_use used on {$DATABASE} > 90%'
              priority: HIGH
              description: 'Fast Recovery Area usage > 90%'
        -
          uuid: ada3aaac456d4bea8b47de96eab2a518
          name: 'Oracle/freebufwaits on {$DATABASE}'
          type: TRAP
          key: freebufwaits
          delay: '0'
          history: 7d
          trends: 90d
          status: DISABLED
          tags:
            -
              tag: Application
              value: Oracle
        -
          uuid: 23d73dd27ed04ac389a656c2720ed550
          name: 'Oracle/Hard parse ratio on {$DATABASE}'
          type: TRAP
          key: hparsratio
          delay: '0'
          history: 7d
          trends: 90d
          value_type: FLOAT
          units: '%'
          tags:
            -
              tag: Application
              value: Oracle
        -
          uuid: bc21037fe79f451786af8bb2b5025a9c
          name: 'Oracle/Index fast full scans (full) on {$DATABASE}'
          type: TRAP
          key: indexffs
          delay: '0'
          history: 7d
          trends: 90d
          preprocessing:
            -
              type: CHANGE_PER_SECOND
              parameters:
                - ''
          tags:
            -
              tag: Application
              value: Oracle
        -
          uuid: 309ab8989d8a4074acd0efd7c6d049f5
          name: 'Oracle/Lastapplarclog on {$DATABASE}'
          type: TRAP
          key: lastapplarclog
          delay: '0'
          history: 7d
          trends: 90d
          status: DISABLED
          tags:
            -
              tag: Application
              value: Oracle
        -
          uuid: cbf6afcf25e74484a4ae7019d852f2bc
          name: 'Oracle/Lastarclog on {$DATABASE}'
          type: TRAP
          key: lastarclog
          delay: '0'
          history: 7d
          trends: 90d
          preprocessing:
            -
              type: BOOL_TO_DECIMAL
              parameters:
                - ''
          tags:
            -
              tag: Application
              value: Oracle
        -
          uuid: e0fa855bf56d470d990111c2131f0822
          name: 'Oracle/Latchfree on {$DATABASE}'
          type: TRAP
          key: latchfree
          delay: '0'
          history: 7d
          trends: 90d
          tags:
            -
              tag: Application
              value: Oracle
        -
          uuid: 9f7a8056cf3d4b65b967b04f1006fcd4
          name: 'Oracle/Logfilesync on {$DATABASE}'
          type: TRAP
          key: logfilesync
          delay: '0'
          history: 7d
          trends: 90d
          tags:
            -
              tag: Application
              value: Oracle
        -
          uuid: 94bd7d1044454ae2b7210e32640aee2b
          name: 'Oracle/Logonscurrent on {$DATABASE}'
          type: TRAP
          key: logonscurrent
          delay: '0'
          history: 7d
          trends: 90d
          tags:
            -
              tag: Application
              value: Oracle
        -
          uuid: 018c452a21cd4f1c972010aa11b80653
          name: 'Oracle/Logprllwrite on {$DATABASE}'
          type: TRAP
          key: logprllwrite
          delay: '0'
          history: 7d
          trends: 90d
          tags:
            -
              tag: Application
              value: Oracle
        -
          uuid: 43d1a6fa776447e5ba7f5a83e77229ef
          name: 'Oracle/Logswcompletion on {$DATABASE}'
          type: TRAP
          key: logswcompletion
          delay: '0'
          history: 7d
          trends: 90d
          tags:
            -
              tag: Application
              value: Oracle
        -
          uuid: c2c7f34f0b5944318826a1fc31069d80
          name: 'Oracle/Netresv on {$DATABASE}'
          type: TRAP
          key: netresv
          delay: '0'
          history: 7d
          trends: 90d
          units: b
          preprocessing:
            -
              type: CHANGE_PER_SECOND
              parameters:
                - ''
          tags:
            -
              tag: Application
              value: Oracle
        -
          uuid: d094e68c5dce44a181227f3345be1d85
          name: 'Oracle/Netroundtrips on {$DATABASE}'
          type: TRAP
          key: netroundtrips
          delay: '0'
          history: 7d
          trends: 90d
          tags:
            -
              tag: Application
              value: Oracle
        -
          uuid: e0fd591a323647569ecad9af3356d10d
          name: 'Oracle/Netsent on {$DATABASE}'
          type: TRAP
          key: netsent
          delay: '0'
          history: 7d
          trends: 90d
          tags:
            -
              tag: Application
              value: Oracle
        -
          uuid: 57b90233ae5b457abb8557e43791ae13
          name: 'Zabbix items list'
          key: 'pyora-items-list[{$ZABBIXURL},{$ZABBIXUSER},{$ZABBIXPASSWORD},{HOST.HOST},{$ADDRESS},{$DATABASE}]'
          delay: '3600'
          history: 7d
          trends: '0'
          value_type: CHAR
          triggers:
            -
              uuid: 67ceea0d68bd4454bdb0723db853564f
              expression: 'find(/Pyora active send/pyora-items-list[{$ZABBIXURL},{$ZABBIXUSER},{$ZABBIXPASSWORD},{HOST.HOST},{$ADDRESS},{$DATABASE}],,"regexp","OK")=0'
              name: 'Can''t create items list'
              priority: AVERAGE
        -
          uuid: 0a64bcd3520c4dd49e5af808a7792844
          name: 'Oracle/Query Lock on {$DATABASE}'
          type: TRAP
          key: query_lock
          delay: '0'
          history: 7d
          trends: 90d
          tags:
            -
              tag: Application
              value: Oracle
          triggers:
            -
              uuid: 6b38eeba535a403abf52bdd4eea37d09
              expression: 'last(/Pyora active send/query_lock)>0'
              name: 'Query Lock on {$DATABASE} > 1'
              status: DISABLED
              priority: AVERAGE
        -
          uuid: b930a4a4b53b4d848f78a3ceab6fe40b
          name: 'Query Lock list on {$DATABASE}'
          type: TRAP
          key: query_lock_list2
          delay: '0'
          trends: '0'
          value_type: TEXT
          tags:
            -
              tag: Application
              value: Oracle
          triggers:
            -
              uuid: aa00c305eadd462d8580d6fed8d6fe68
              expression: 'length(last(/Pyora active send/query_lock_list2))>3'
              name: 'Query Lock list on {$DATABASE} not empty'
              priority: AVERAGE
        -
          uuid: 598db36acb7c4291bb7449b68c9da15b
          name: 'Oracle/Query Redologs on {$DATABASE}'
          type: TRAP
          key: query_redologs
          delay: '0'
          history: 7d
          trends: 90d
          tags:
            -
              tag: Application
              value: Oracle
        -
          uuid: b9115e9c26294984ac725022b0029491
          name: 'Oracle/Query Rollbacks on {$DATABASE}'
          type: TRAP
          key: query_rollbacks
          delay: '0'
          history: 7d
          trends: 90d
          tags:
            -
              tag: Application
              value: Oracle
        -
          uuid: 2f67bfc0accc4fb581c19d0d94182a8e
          name: 'Oracle/Query Sessions on {$DATABASE}'
          type: TRAP
          key: query_sessions
          delay: '0'
          history: 7d
          trends: 90d
          tags:
            -
              tag: Application
              value: Oracle
          triggers:
            -
              uuid: a91d19a43546422e94e907baa50b7328
              expression: 'last(/Pyora active send/query_sessions)>250'
              name: 'Query Sessions on {$DATABASE} > 250'
              priority: AVERAGE
        -
          uuid: 097e41e862d3497291cd157cbfae92cc
          name: 'Oracle/Database CPU Time Ratio on {$DATABASE}'
          type: TRAP
          key: 'query_sysmetrics[Database_CPU_Time_Ratio]'
          delay: '0'
          history: 7d
          trends: 90d
          value_type: FLOAT
          units: '%'
          tags:
            -
              tag: Application
              value: Oracle
        -
          uuid: 9d2c4278af3742d99c49ed10d71e6508
          name: 'Oracle/Database Wait Time Ratio on {$DATABASE}'
          type: TRAP
          key: 'query_sysmetrics[Database_Wait_Time_Ratio]'
          delay: '0'
          history: 7d
          trends: 90d
          value_type: FLOAT
          units: '%'
          tags:
            -
              tag: Application
              value: Oracle
        -
          uuid: 3b6ff17b47024a1299cfe90d23fbb4d0
          name: 'Oracle/User Transaction Per Sec on {$DATABASE}'
          type: TRAP
          key: 'query_sysmetrics[User_Transaction_Per_Sec]'
          delay: '0'
          history: 7d
          trends: 90d
          value_type: FLOAT
          tags:
            -
              tag: Application
              value: Oracle
        -
          uuid: e27107fb36ff47ecb1637e2e974b81a8
          name: 'Oracle/Read Cache hit ratio on {$DATABASE}'
          type: TRAP
          key: rcachehit
          delay: '0'
          history: 7d
          trends: 90d
          value_type: FLOAT
          units: '%'
          tags:
            -
              tag: Application
              value: Oracle
        -
          uuid: b9c106630f614629a0df185d48b0ba8a
          name: 'Oracle/Redo Writes on {$DATABASE}'
          type: TRAP
          key: redowrites
          delay: '0'
          history: 7d
          trends: 90d
          preprocessing:
            -
              type: CHANGE_PER_SECOND
              parameters:
                - ''
          tags:
            -
              tag: Application
              value: Oracle
        -
          uuid: dc869ec30cbf4546a2cd54b7e9553c4d
          name: 'Oracle/Table scan rows gotten on {$DATABASE}'
          type: TRAP
          key: tblrowsscans
          delay: '0'
          history: 7d
          trends: 90d
          preprocessing:
            -
              type: CHANGE_PER_SECOND
              parameters:
                - ''
          tags:
            -
              tag: Application
              value: Oracle
        -
          uuid: ba21157d8b1a4bfc96e4d89fd042ba13
          name: 'Oracle/Table scans (long tables) on {$DATABASE}'
          type: TRAP
          key: tblscans
          delay: '0'
          history: 7d
          trends: 90d
          preprocessing:
            -
              type: CHANGE_PER_SECOND
              parameters:
                - ''
          tags:
            -
              tag: Application
              value: Oracle
        -
          uuid: 2b71a79d812f4a7eaa8e19bfbcc46afc
          name: 'Oracle/Uptime on {$DATABASE}'
          type: TRAP
          key: uptime
          delay: '0'
          history: 7d
          trends: 90d
          units: s
          tags:
            -
              tag: Application
              value: Oracle
        -
          uuid: 9c9b640df049409183a56b52b310169e
          name: 'Oracle/Version on {$DATABASE}'
          type: TRAP
          key: version
          delay: '0'
          trends: '0'
          value_type: CHAR
          tags:
            -
              tag: Application
              value: Oracle
      discovery_rules:
        -
          uuid: 7066714d47fc4e58b3f837a736b800b8
          name: 'Discovery Oracle ASM volumes'
          key: 'pyora-discovery[{$ADDRESS},{$DATABASE},show_asm_volumes]'
          delay: '3600'
          filter:
            conditions:
              -
                macro: '{#ASMVOLUME}'
                formulaid: A
          item_prototypes:
            -
              uuid: d4c7481c540f4a6190885e8cb442b463
              name: 'ASM Volume Free on {#ASMVOLUME}'
              type: TRAP
              key: 'asm_volume_free[{#ASMVOLUME}]'
              delay: '0'
              history: 7d
              trends: 90d
              units: B
              preprocessing:
                -
                  type: MULTIPLIER
                  parameters:
                    - '1048576'
              tags:
                -
                  tag: Application
                  value: 'ASM Volumes'
            -
              uuid: c104e65ab1cb49fd9546d021122c5d48
              name: 'ASM Volume Size on {#ASMVOLUME}'
              type: TRAP
              key: 'asm_volume_size[{#ASMVOLUME}]'
              delay: '0'
              history: 7d
              trends: 90d
              units: B
              preprocessing:
                -
                  type: MULTIPLIER
                  parameters:
                    - '1048576'
              tags:
                -
                  tag: Application
                  value: 'ASM Volumes'
            -
              uuid: aa6794505ae843ad8f4be34581b67f74
              name: 'ASM Volume Use on {#ASMVOLUME}'
              type: TRAP
              key: 'asm_volume_use[{#ASMVOLUME}]'
              delay: '0'
              history: 7d
              trends: 90d
              value_type: FLOAT
              units: '%'
              tags:
                -
                  tag: Application
                  value: 'ASM Volumes'
          trigger_prototypes:
            -
              uuid: b061774f984d4839b3302e801b9953c8
              expression: '(last(/Pyora active send/asm_volume_size[{#ASMVOLUME}]) - last(/Pyora active send/asm_volume_free[{#ASMVOLUME}])) / last(/Pyora active send/asm_volume_size[{#ASMVOLUME}]) *100 > {$ASMHIGH}'
              name: 'ASM Volume {#ASMVOLUME} used > {$ASMHIGH}% ({ITEM.LASTVALUE2} / {ITEM.LASTVALUE1})'
              priority: AVERAGE
        -
          uuid: 08cf5354339e4abdb8250594858ea500
          name: 'Discovery Oracle tablespaces'
          key: 'pyora-discovery[{$ADDRESS},{$DATABASE},show_tablespaces]'
          delay: '3600'
          status: DISABLED
          filter:
            conditions:
              -
                macro: '{#TABLESPACE}'
                formulaid: A
          item_prototypes:
            -
              uuid: 95995efdad874e5a8e1df794451db2e3
              name: 'Tablespace percentual use on {#TABLESPACE}'
              type: TRAP
              key: 'tablespace[{#TABLESPACE}]'
              delay: '0'
              history: 7d
              trends: 90d
              value_type: FLOAT
              units: '%'
              tags:
                -
                  tag: Application
                  value: Tablespaces
              trigger_prototypes:
                -
                  uuid: 8dcdfe3ea0404c51959162a4fd9a5fe3
                  expression: 'last(/Pyora active send/tablespace[{#TABLESPACE}])>{$HIGH}'
                  name: 'Tablespace {#TABLESPACE} used on {$DATABASE} > {$HIGH} %'
                  priority: AVERAGE
            -
              uuid: cb6fb1bcb5a646faa3541a5acbab66f4
              name: 'Tablespace free on {#TABLESPACE}'
              type: TRAP
              key: 'tablespace_abs[{#TABLESPACE}]'
              delay: '0'
              history: 7d
              trends: 90d
              units: bytes
              tags:
                -
                  tag: Application
                  value: Tablespaces
        -
          uuid: 20e33aa2a4ff47598f666cbd0780fad1
          name: 'Discovery Oracle temp tablespaces'
          key: 'pyora-discovery[{$ADDRESS},{$DATABASE},show_tablespaces_temp]'
          delay: '3600'
          filter:
            conditions:
              -
                macro: '{#TABLESPACE_TEMP}'
                formulaid: A
          item_prototypes:
            -
              uuid: efafcee9dbac4d5194b82c5322bd786c
              name: 'Temp Tablespace Use on {#TABLESPACE_TEMP}'
              type: TRAP
              key: 'tablespace_temp[{#TABLESPACE_TEMP}]'
              delay: '0'
              value_type: FLOAT
              units: '%'
              tags:
                -
                  tag: Application
                  value: 'Temp Tablespaces'
        -
          uuid: bf1f0e58860243aa9dc12f1d1f033293
          name: 'Discovery Oracle users'
          key: 'pyora-discovery[{$ADDRESS},{$DATABASE},show_users]'
          delay: '3600'
          status: DISABLED
          filter:
            conditions:
              -
                macro: '{#DBUSER}'
                formulaid: A
          item_prototypes:
            -
              uuid: 66a7a5c372cb40ad91f91a0cc6631c9c
              name: '{#DBUSER} user status'
              type: TRAP
              key: 'user_status[{#DBUSER}]'
              delay: '0'
              trends: '0'
              status: DISABLED
              value_type: TEXT
              tags:
                -
                  tag: Application
                  value: 'Database Users'
      macros:
        -
          macro: '{$ASMHIGH}'
          value: '85'
        -
          macro: '{$DATABASE}'
        -
          macro: '{$HIGH}'
          value: '80'
        -
          macro: '{$ZABBIXPASSWORD}'
        -
          macro: '{$ZABBIXURL}'
        -
          macro: '{$ZABBIXUSER}'
  triggers:
    -
      uuid: d23e88d395b54013b3821224b5870374
      expression: 'last(/Pyora active send/query_lock)>0 and length(last(/Pyora active send/query_lock_list2))>3'
      name: 'Query Lock on {$DATABASE} > 1'
      priority: AVERAGE