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

Errors when execute data.sql in Oracle

    XMLWordPrintable

    Details

    • Type: Incident report
    • Status: Closed
    • Priority: Blocker
    • Resolution: Fixed
    • Affects Version/s: 2.0.0
    • Fix Version/s: 2.0.1rc1, 2.1.0
    • Component/s: Installation (I)
    • Labels:
    • Environment:
      Oracle 11gR1

      Description

      I can not import initial data via data.sql in Oracle, there are some errors like:

      SP2-0734: unknown command beginning "{$SNMP_COM..." - rest of line ignored.
      ERROR:
      ORA-01756: quoted string not properly terminated

      • MySQL server is up','0','30')
        *
        ERROR at line 1:
        ORA-00900: invalid SQL statement

      It seems part of data.sql is in windows format, my workaround is converting it to unix with "dos2unix data.sql" and then removing all blank lines with "sed -i '/^$/d' data.sql".

        Attachments

          Activity

            People

            Assignee:
            Unassigned
            Reporter:
            mycigar Guoyu Li
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: