Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
RedHat EL 5.3 x64

If you do a fresh install in trunk when viewing Items you won't get any output at all (even in debug mode). Same goes for triggers. In order to be able to see the error:

• delete default host "Zabbix server"
• add host "Zabbix server"
• view it's items

I propose it's another blocker for 2.0 .

any update on this issue, is it possilbe to simply change from NCLOB to NVARCHAR2?

after i changed this field from NCLOB to NVARCHAR2(255) everything works fine

the max of NVARCHAR2 is 4000, i think this should be enough.

Who knows what was the reason for choosing NCLOB in the first place?

dev branch: svn://svn.zabbix.com/branches/dev/ZBX-4188

I just downloaded trunk 1.9.8 23295 (17Nov2011) and this error is still there.
I am new so maybe I am not aware of that if you fix error 15th Nov it is not yet present in trunk 17th Nov?

it has only been fixed in a development branch (as noted above). when the fix will be tested & reviewed it will be merged to trunk

svn://svn.zabbix.com/trunk 23354

Please tell me why this fix is not in 1.9.8 (beta) and even not in 1.9.9 (trunk)?

this fix was merged to trunk in revision 23354. what do you mean by "not in 1.9.8" ?

In official Zabbix 1.9.8 (Third Beta Release of 2.0) released 25 November, 2011 in file ChangeLog is info:
---------
(...)
Bug Fixes:
(...)

• ZBX-4188 fixed nclob problem for Oracle (Vedmak)
  ----------

but after upgrade to 1.9.8, I still have errors on Configuration (ITEMS and TRIGGERS lists) and Monitoring (Latest data) in Frontend.

I tried also most recent Pre-1.9.9.x (alpha) 23577 29 Nov, 2011 with the same result:

• ociexecute(): ORA-00932: inconsistent datatypes: expected - got NCLOB [include/db.inc.php:439]
• SQL error [ORA-00932: inconsistent datatypes: expected - got NCLOB] in [SELECT DISTINCT i.*,f.triggerid FROM items i,functions f WHERE i.itemid BETWEEN 000000000000000 AND 099999999999999 AND 1=0 AND i.itemid=f.itemid]
• ocifetchinto(): ORA-24374: define not done before fetch or execute and fetch [include/db.inc.php:570]

It is working properly but I had to manually modify items.description.

patch.sql didn't work for this line:
ALTER TABLE items RENAME COLUMN description to name;
because there was already column name in table items.

I removed manually empty column name from table items and rerun patch.sql - now it works perfectly

Reopening based on previous comment.

Please recreate a database with a new database schema and retest again.

The problem resolution consisted in change of types of fields from 'nclob' to 'nvarchar'

I got a similar error when login with another user(not admin, created myself), it was thrown when entering dashboard, by "Last 20 issues". The error disappeared after changing table SCRIPTS->DESCRIPTION from NCLOB to NVARCHAR.

Please see the screenshot for details.

Thanks.

As Alexander Vladishev have already said, database schema was fixed. If you create new database or upgrade from 1.8, everything should work.
If you have 2.0 schema created before this fix, you should manually change nclob fields to nvarcvhar2.

Please reopen issue if you have any problems with creation of new database or upgrading from 1.8.

Yes. Everything related to these errors work fine after manual modification of types from NCLOB to NVARCHAR2 in database.
Thank you.