The patch located: in upgrades/dbpatches/1.8/oracle/patch.sql is broken:

Please change the following

1) Using ampersand in the sql script will interpret it as a variable, you can add the following to the top of the script to prevent this:
SET DEFINE OFF

2) any line with nvarchar needs to be changed from 2048 characters to 2000. "Double byte character max when using UTF-8"

-alter table alerts modify message nvarchar2(2048) DEFAULT '';
+alter table alerts modify message nvarchar2(2000) DEFAULT '';

regex to fix this: :%s/nvarchar2(2048)/nvarchar2(2000)/g

3) Some lines have NOT NULL and then a null default setting... GRR!

-alter table hosts add ipmi_error nvarchar2(128) DEFAULT '' NOT NULL;
-alter table hosts add snmp_error nvarchar2(128) DEFAULT '' NOT NULL;
+alter table hosts add ipmi_error nvarchar2(128) DEFAULT '';
+alter table hosts add snmp_error nvarchar2(128) DEFAULT '';

-alter table httptest add http_user nvarchar2(64) DEFAULT '' NOT NULL;
-alter table httptest add http_password nvarchar2(64) DEFAULT '' NOT NULL;
+alter table httptest add http_user nvarchar2(64) DEFAULT '';
+alter table httptest add http_password nvarchar2(64) DEFAULT '';

-alter table items add username nvarchar2(64) DEFAULT '' NOT NULL;
-alter table items add password nvarchar2(64) DEFAULT '' NOT NULL;
-alter table items add publickey nvarchar2(64) DEFAULT '' NOT NULL;
-alter table items add privatekey nvarchar2(64) DEFAULT '' NOT NULL;
+alter table items add username nvarchar2(64) DEFAULT '';
+alter table items add password nvarchar2(64) DEFAULT '';
+alter table items add publickey nvarchar2(64) DEFAULT '';
+alter table items add privatekey nvarchar2(64) DEFAULT '';

-CREATE TABLE proxy_autoreg_host (

• id number(20) NOT NULL,
• clock number(10) DEFAULT '0' NOT NULL,
• host nvarchar2(64) DEFAULT '' ,
• PRIMARY KEY (id)
  -);
  +CREATE TABLE proxy_autoreg_host (
  + id number(20) DEFAULT '0' NOT NULL,
  + clock number(10) DEFAULT '0' NOT NULL,
  + host nvarchar2(64) DEFAULT '' ,
  + PRIMARY KEY (id)
  +);

-alter table proxy_dhistory modify key_ nvarchar2(255) DEFAULT '' NOT NULL;
-alter table proxy_dhistory modify value nvarchar2(255) DEFAULT '' NOT NULL;
alter table proxy_dhistory modify key_ nvarchar2(255) DEFAULT '';
alter table proxy_dhistory modify value nvarchar2(255) DEFAULT '';

-alter table proxy_dhistory modify ip nvarchar2(39) DEFAULT '' NOT NULL;
+alter table proxy_dhistory modify ip nvarchar2(39) DEFAULT '';

-alter table sysmaps_elements modify label nvarchar2(255) DEFAULT '' NOT NULL;
+alter table sysmaps_elements modify label nvarchar2(255) DEFAULT '';

-alter table sysmaps_links add label nvarchar2(255) DEFAULT '' NOT NULL;
+alter table sysmaps_links add label nvarchar2(255) DEFAULT '';