zabbix_export:
  version: '6.0'
  date: '2021-11-21T21:48:52Z'
  groups:
    -
      uuid: b1bb31f111064c9bb4da5f6b9f7bddd5
      name: 'DB: Oracle'
    -
      uuid: 7df96b18c230490a9a0a9e2307226338
      name: Templates
  templates:
    -
      uuid: ed6eb83866e64ffbaee5c90c0aca207b
      template: OCI_Dbaas
      name: OCI_Dbaas
      description: |
        ## Overview
        
        This is a template to monitor OCI Dbaas with Zabbix.
        
        
        If you want to monitor Dbaas, OCI Monitoring function is not enough (or there is not Dbaas metrics?)
        
        
        So, It is Necessary to use other monitoring tools.
        
        
        This Zabbix template has been verified to run on zabbix3 or 4series.
        
        
         
        
        
        ■ Source
        
        
        <https://github.com/y-araki-git/zabbix-oci-dbaas>
        
        
         
        
        
        ■ The link is described below for the setting procedure.
        
        
        ・Setup
        
        
         <https://qiita.com/y-araki-qiita/items/f25e02182c7f279c0199>
        
        
        ・How to add monitoring
        
        
         <https://qiita.com/y-araki-qiita/items/0ec80adbb022458cab20>
        
        
         
        
        
        ■ Structure of download file
        
        
        zabbix-oci-dbaas
        
        
        ├deploy\_zabbix-oci-dbaas.sh (Dbaas monitoring setup script executed on zabbix agent)
        
        
        ├README.md
        
        
        ├template\_oci\_dbaas.xml (Template to import in zabbix console)
        
        
        └zabbix-oci-dbaas (Stores files placed under / etc / zabbix / scripts / agentd / zabbix-oci-dbaas /)
        
        
         ├zabbix\_agentd.conf (Setting of UserParameter)
        
        
         ├zabbix-oci-dbaas.conf.org (User description for OracleDB monitoring)
        
        
         ├zabbix-oci-dbaas.oraenv.org (Environment variable settings)
        
        
         ├zabbix-oci-dbaas.sh (Monitor acquisition script)
        
        
         └sql(Store sql to get monitored items)
        
        
          ├xxx.sql
        
        
          …
        
        
         
        
        
        
        ## Author
        
        yu araki
        
        
      groups:
        -
          name: 'DB: Oracle'
        -
          name: Templates
      items:
        -
          uuid: ef1cce1503e44137bfd4473c906a952b
          name: '[Oracle] Database is active and open'
          key: 'zabbix-oci-dbaas[{$ORACLE_SID},db_active,1]'
          delay: '3600'
          history: 7d
          trends: 15d
          tags:
            -
              tag: Application
              value: Oracle
          triggers:
            -
              uuid: c4c253b7657a484b94cdc6a4b682705a
              expression: 'last(/OCI_Dbaas/zabbix-oci-dbaas[{$ORACLE_SID},db_active,1])=0'
              name: '[{$ORACLE_SID}] Oracle: The database is inactive or closed'
              priority: HIGH
        -
          uuid: b5e7f45e869c4ef88c5c808b892f1506
          name: '[Oracle] ASM Data Area percentage used'
          key: 'zabbix-oci-dbaas[{$ORACLE_SID},db_asmdata,1]'
          delay: '600'
          history: 7d
          trends: 15d
          units: '%'
          tags:
            -
              tag: Application
              value: Oracle
          triggers:
            -
              uuid: 7cc19465366b4fa2a55acac1e669a112
              expression: 'last(/OCI_Dbaas/zabbix-oci-dbaas[{$ORACLE_SID},db_asmdata,1])>90'
              name: '[{$ORACLE_SID}] ASM: High percentage used data space'
              priority: HIGH
        -
          uuid: 049aba77168741dc9297860d58088ed0
          name: '[Oracle] ASM Recovery Area percentage used'
          key: 'zabbix-oci-dbaas[{$ORACLE_SID},db_asmreco,1]'
          delay: '600'
          history: 7d
          trends: 15d
          units: '%'
          tags:
            -
              tag: Application
              value: Oracle
          triggers:
            -
              uuid: 07fa60016bc04c39b88acb91b521e963
              expression: 'last(/OCI_Dbaas/zabbix-oci-dbaas[{$ORACLE_SID},db_asmreco,1])>90'
              name: '[{$ORACLE_SID}] ASM: High percentage used recovery space'
              priority: HIGH
        -
          uuid: 9255caab269644a287e3984542972d3e
          name: '[Oracle] Sessions blocks'
          key: 'zabbix-oci-dbaas[{$ORACLE_SID},db_block,1]'
          delay: '60'
          history: 1d
          trends: 5d
          tags:
            -
              tag: Application
              value: Oracle
          triggers:
            -
              uuid: 4fd275ccd6a94a5eac42df277af9035c
              expression: 'change(/OCI_Dbaas/zabbix-oci-dbaas[{$ORACLE_SID},db_block,1])>0'
              name: '[{$ORACLE_SID}] Oracle: Session blocks are increasing'
              priority: HIGH
        -
          uuid: 71e542ae3afd494db8b054f9be43714a
          name: '[Oracle] Connections available'
          key: 'zabbix-oci-dbaas[{$ORACLE_SID},db_connection,1]'
          delay: '300'
          history: 7d
          trends: 15d
          tags:
            -
              tag: Application
              value: Oracle
        -
          uuid: 38b7e3a5931f47b3b2253d1dd28ded34
          name: '[Oracle] Flash Recovery Area percentage used'
          key: 'zabbix-oci-dbaas[{$ORACLE_SID},db_fra,1]'
          delay: '600'
          history: 7d
          trends: 15d
          units: '%'
          tags:
            -
              tag: Application
              value: Oracle
          triggers:
            -
              uuid: 9a9892796bc54c1398c873d7a601bfe4
              expression: 'last(/OCI_Dbaas/zabbix-oci-dbaas[{$ORACLE_SID},db_fra,1])>90'
              name: '[{$ORACLE_SID}] FRA: High percentage used space'
              priority: HIGH
            -
              uuid: 19f3fb6a839848569c3b5b6854d2a78b
              expression: 'last(/OCI_Dbaas/zabbix-oci-dbaas[{$ORACLE_SID},db_fra,1])>80'
              name: '[{$ORACLE_SID}] FRA: Warning percentage used space'
              priority: WARNING
              dependencies:
                -
                  name: '[{$ORACLE_SID}] FRA: High percentage used space'
                  expression: 'last(/OCI_Dbaas/zabbix-oci-dbaas[{$ORACLE_SID},db_fra,1])>90'
        -
          uuid: ba1fcc3e4c8f43c4bef576cdd8244592
          name: '[Oracle] Invalid objects'
          key: 'zabbix-oci-dbaas[{$ORACLE_SID},db_invalid,1]'
          delay: '3600'
          history: 7d
          trends: 15d
          tags:
            -
              tag: Application
              value: Oracle
          triggers:
            -
              uuid: 6842ffd8275f43ccaddbacdc7596b144
              expression: 'change(/OCI_Dbaas/zabbix-oci-dbaas[{$ORACLE_SID},db_invalid,1])>0'
              name: '[{$ORACLE_SID}] Oracle: Invalid objects are increasing'
              priority: HIGH
        -
          uuid: 8273cb24a01c424880355e2406653c05
          name: '[Oracle] Locks count'
          key: 'zabbix-oci-dbaas[{$ORACLE_SID},db_lock,1]'
          delay: '60'
          history: 1d
          trends: 5d
          tags:
            -
              tag: Application
              value: Oracle
          triggers:
            -
              uuid: f18cf09608454dada8175665bf883874
              expression: 'change(/OCI_Dbaas/zabbix-oci-dbaas[{$ORACLE_SID},db_lock,1])>0'
              name: '[{$ORACLE_SID}] Oracle: Locks count are increasing'
              priority: HIGH
        -
          uuid: 95d5a233712b4f9ea851e45d8d680bab
          name: '[Oracle] Response Time Per Txn'
          key: 'zabbix-oci-dbaas[{$ORACLE_SID},db_metric,''Response Time Per Txn'']'
          delay: '60'
          history: 30d
          trends: 30d
          value_type: FLOAT
          tags:
            -
              tag: Application
              value: Oracle
        -
          uuid: cd12cf3b285e40d38cde33f18bd2b9df
          name: '[Oracle] Redo Logs count'
          key: 'zabbix-oci-dbaas[{$ORACLE_SID},db_redo,1]'
          delay: '600'
          history: 7d
          trends: 15d
          tags:
            -
              tag: Application
              value: Oracle
        -
          uuid: fab2cf6aacae424c9a80a38f41a5fd32
          name: '[Oracle] RMAN problems counter'
          key: 'zabbix-oci-dbaas[{$ORACLE_SID},db_rman,1]'
          delay: '86400'
          history: 7d
          trends: 15d
          tags:
            -
              tag: Application
              value: Oracle
          triggers:
            -
              uuid: 26c977c45b174884a07b06c86ccd2477
              expression: 'last(/OCI_Dbaas/zabbix-oci-dbaas[{$ORACLE_SID},db_rman,1])>0'
              name: '[{$ORACLE_SID}] Oracle: RMAN has problems'
              priority: HIGH
        -
          uuid: daf8e2d0422142e3aa4373f23daf703b
          name: '[Oracle] Database size'
          key: 'zabbix-oci-dbaas[{$ORACLE_SID},db_size,1]'
          delay: '86400'
          history: 7d
          trends: 15d
          tags:
            -
              tag: Application
              value: Oracle
        -
          uuid: 27cd940025894d528f2d537898a79506
          name: '[Oracle] Database uptime'
          key: 'zabbix-oci-dbaas[{$ORACLE_SID},db_uptime,1]'
          delay: '600'
          history: 7d
          trends: 30d
          units: s
          tags:
            -
              tag: Application
              value: Oracle
          triggers:
            -
              uuid: 7b44b24ceb0148ad9630989fedb28a93
              expression: 'last(/OCI_Dbaas/zabbix-oci-dbaas[{$ORACLE_SID},db_uptime,1])<600'
              name: '[{$ORACLE_SID}] Oracle: The database has just been restarted'
              status: DISABLED
              priority: INFO
              dependencies:
                -
                  name: '[{$ORACLE_SID}] Oracle: The database is inactive or closed'
                  expression: 'last(/OCI_Dbaas/zabbix-oci-dbaas[{$ORACLE_SID},db_active,1])=0'
        -
          uuid: 4e4482c8cf724b20869128fd3ad32816
          name: '[Oracle] Database version'
          key: 'zabbix-oci-dbaas[{$ORACLE_SID},db_version,1]'
          delay: '86400'
          history: 5d
          trends: '0'
          value_type: CHAR
          tags:
            -
              tag: Application
              value: Oracle
      discovery_rules:
        -
          uuid: 3d6c1680a21f43dc9a8f9d261e09fa0e
          name: '[Oracle] Tablespaces'
          key: 'zabbix-oci-dbaas.discovery[{$ORACLE_SID},tb_list,1,ORACLE_TBS]'
          delay: '86400'
          lifetime: 1d
          item_prototypes:
            -
              uuid: 3a2cc790a0cd4ebe91e579508d561c26
              name: '[Oracle] Tablespace $3 percentage used'
              key: 'zabbix-oci-dbaas[{$ORACLE_SID},tb_size,{#ORACLE_TBS}]'
              delay: '600'
              history: 7d
              trends: 30d
              value_type: FLOAT
              units: '%'
              tags:
                -
                  tag: Application
                  value: Oracle
              trigger_prototypes:
                -
                  uuid: ef30e8da1ef94ba4a20cb98344611152
                  expression: 'last(/OCI_Dbaas/zabbix-oci-dbaas[{$ORACLE_SID},tb_size,{#ORACLE_TBS}])>95'
                  name: '[{$ORACLE_SID}] Tablespace: High used space on {#ORACLE_TBS}'
                  priority: HIGH
                -
                  uuid: cb834f7d71cd40aca51559debbc9552d
                  expression: 'last(/OCI_Dbaas/zabbix-oci-dbaas[{$ORACLE_SID},tb_size,{#ORACLE_TBS}])>90 and last(/OCI_Dbaas/zabbix-oci-dbaas[{$ORACLE_SID},tb_size,{#ORACLE_TBS}])<95'
                  name: '[{$ORACLE_SID}] Tablespace: Warning used space on {#ORACLE_TBS}'
                  priority: WARNING
          graph_prototypes:
            -
              uuid: 8682c111e1964689add80cb6b0321317
              name: '[Oracle][{$ORACLE_SID}]Tablespace used: {#ORACLE_TBS}'
              type: STACKED
              ymin_type_1: FIXED
              ymax_type_1: FIXED
              graph_items:
                -
                  color: C80000
                  yaxisside: RIGHT
                  item:
                    host: OCI_Dbaas
                    key: 'zabbix-oci-dbaas[{$ORACLE_SID},tb_size,{#ORACLE_TBS}]'