Problem loading initial data in a Oracle Database

[dipcas]

Hi, I have just setted a Oracle Database 12.1 and I want to create a fresh install of Zabbix in that machine (not for monitoring purposes, only for database backend).

I have followed all instructions (UTF8, user permissions, .....) and I have executed schema.sql, images.sql into Oracle, but when I run data.sql I got this error:
ERROR at line 7:
ORA-22835: Buffer too small for CLOB to CHAR or BLOB to RAW conversion (actual:
7931, maximum: 4000)

I have googled, but nothing to do. Can anybody help me?

Regards,
Javier.

[beremour]

I have the same thing while running data.sql. My database is 19.11 and created as CHARACTER SET AL32UTF8, NATIONAL CHARACTER SET UTF8. It gives:

TO_NCLOB(' response = Ami.request(url, ''Logoff'');' || chr(10) || '}' || chr(10) || 'catch (e) {}' || chr(10) || '' || chr(10) || '')||
*
ERROR at line 9:
ORA-22835: Buffer too small for CLOB to CHAR or BLOB to RAW conversion (actual:
9376, maximum: 4000)

[Glencoe]

Please check if this one is similar? https://support.zabbix.com/browse/ZBX-19227 Please leave a note there if it is.

[beremour]

This link suggest to use 5.0.2 scripts. I can't find 5.0.2 tgz. I try git checkout tags/5.0.2. Data.sql remain the same. Not sure if I am doing right. I've created new issue https://support.zabbix.com/browse/ZBX-19717

[Glencoe]

This link suggest to use 5.0.2 scripts.

Scripts from 5.0 will not work in 5.4.

I hope someone will look into ZBX-19717