1、添加oracle用户
# groupadd oinstall
# useradd -m -g oinstall oracle
mkdir /11gclient
chown -R oracle:oinstall /11gclient
chmod -R 775 /11gclient
create tablespace zabbix
logging
datafile '/11gR2/oracle/oradata/ehrdb/zabbix.dbf'
size 128m
autoextend on
next 50m maxsize 20480m
extent management local;
sqlplus zabbix/密码@ZABBIXDB
cd /Ware/zabbix/zabbix-4.0.5/database/oracle
sed -i 's/2048/2000/g' schema.sql
导入3个文件
调整字段的长度: SQL> alter table items add(new_description nvarchar2(2000)); Table altered. SQL> update items set new_description = DESCRIPTION; 5106 rows updated. SQL> alter table items drop column DESCRIPTION; Table altered. SQL> alter table items rename column new_description to