Ad Widget

Collapse

Zabbix with Oracle upgrade

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • vulzscht
    Junior Member
    • Jun 2015
    • 3

    #1

    Zabbix with Oracle upgrade

    Hello

    Haven't found similar questions on the forum.

    I was using zabbix 2.4.5
    Tried to upgrade to 3.0.1 today, but have failure
    25086:20160420:164410.136 [Z3005] query failed: [-1] ORA-00910: specified length too long for its datatype [alter table hosts modify error nvarchar2(2048)]
    SQL> alter table hosts modify error nvarchar2(2048);
    alter table hosts modify error nvarchar2(2048)
    *
    ERROR at line 1:
    ORA-00910: specified length too long for its datatype
    is there any way to avoid this?
    nvarchar2 is limited with 2000 symbols in Oracle.
  • oitss
    Member
    • Dec 2013
    • 62

    #2
    Please, read:

    https://community.oracle.com/message/3166727#3166727

    Comment

    • vulzscht
      Junior Member
      • Jun 2015
      • 3

      #3
      Thanks
      already found, that it is always useful to read whole documentation.
      related part was clearly stated in appendixes section of zabbix docs - https://www.zabbix.com/documentation...all/db_scripts

      shame on me

      Comment

      Working...