Uploaded image for project: 'ZABBIX BUGS AND ISSUES'
  1. ZABBIX BUGS AND ISSUES
  2. ZBX-19980

DATA.SQL Oracle build scripts fails with: ORA-12899: value too large for column "ZABBIX"."ITEM_PREPROC"."PARAMS" (actual: 9376, maximum: 2048)

    XMLWordPrintable

Details

    • Problem report
    • Status: Closed
    • Trivial
    • Resolution: Duplicate
    • 5.4.4
    • None
    • None
    • None
    • Oracle linux 8.4 x86_64, Oracle Database 12.2.0.1.210720 (Jul 2021)

    Description

      Steps to reproduce:

      1. Install Oracle Database 12.2.0.1.210720 (Jul 2021) on DB server
      2. Create Oracle Database with: CHARACTER SET AL32UTF8 and NATIONAL CHARACTER SET UTF8
      3. Create user "zabbix" wiith DBA privs
      4. Use recommendations from ZBX-19717 to increasing max_string_size (alter system set max_string_size=extended)
      5. download sources "https://cdn.zabbix.com/zabbix/sources/stable/5.4/zabbix-5.4.4.tar.gz" and extract
      6. use sqlplus 12.2 on DB server machine or sqlplus 19.12 from instant client on clent machine
      7. execute database/oracle/schema.sql
      8. execute database/oracle/images.sql
      9. execute database/oracle/data.sql

      Result:
      See screenshot
      See log file...

      Expected:
      Database schema create on Oracle

      Attachments

        1. data.log.7z
          695 kB
        2. images.log
          1.28 MB
        3. schema.log
          142 kB
        4. Screenshot 2021-09-18 at 22.15.47.png
          Screenshot 2021-09-18 at 22.15.47.png
          3.70 MB

        Issue Links

          Activity

            People

              zabbix.support Zabbix Support Team
              beremour Sergey Yudin
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: