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

Oracle Database schema creation change request

XMLWordPrintable

    • Icon: Problem report Problem report
    • Resolution: Unresolved
    • Icon: Trivial Trivial
    • None
    • None
    • Server (S)

      Steps to reproduce:

      The official documentation on Oracle Database schema creation (https://www.zabbix.com/documentation/current/manual/appendix/install/db_scripts) has two issues:

      1. There are a few long lines (more than 4999 characters) in data.sql file which cause "SP2-0027: Input is too long (> 4999 characters) - line ignored" Oracle error. It's usually ignored by sqlplus (and the data don't go into the database of course) unless one issues "whenever sqlerror exit sql.sqlcode;" before submitting data.sql file.
      2. The official documentation implies having a direct access to Oracle database host to upload images.sql and a number of Zabbix images. One doesn't need to have a direct access to remote database host to upload images to BLOB though.

      Changes suggested:

      1. data.sql should be re-formatted to avoid too long lines (4999+ characters since Oracle 12).
      2. The file set (images.sql file + zabbix_images) should be converted into SQL*Loader format instead. The documentation will need to be rewritten regarding this change, of course.

      I have implemented the above said changes in my exercise project at https://github.com/eg15/oracle-cloud-zabbix which is running Zabbix in Oracle Cloud on an Oracle Database.

      Please find attached the oracle.tgz file with the replacements for data.sql and images.sql files.

      With this file, images can be uploaded simply by running sqlldr $USER/$PASSWORD@SERVICE_NAME control=IMAGES_DATA_TABLE.ctl command.

            zabbix.dev Zabbix Development Team
            eg15 Eugene Gladchenko
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

              Created:
              Updated: