1.create password file
$orapwd file=<path>/orapwmonitor.ora password=test

2.create pfile
$vi $ORACLE_HOME/dbs/initmonitor.ora



3.create database
sqlplus /nolog
sql>conn / as sysdba
sql>startup nomount
sql>create database monitor
logfile group 1 ('/space/mm/monitor/dbsys/log1.ora') size 200k,
group 2 ('/space/mm/monitor/dbsys/log2.ora') size 200k
datafile '/space/mm/monitor/system.ora' size 500M 

4.run script
sql>@$ORACLE_HOME/rdbms/admin/catalog.sql
sql>@$ORACLE_HOME/rdbms/admin/catproc.sql
sql>conn system/manager
sql>@$ORACLE_HOME/sqlplus/admin/pupbld.sql

5.create user
create user monitoradm identified by adm;
grant connect,resourse to monitoradm;

6.create table
;豸
create table MS_sys_device (device_code char(10),device_type varchar2(32),
device_id varchar2(32),device_name varchar2(128),primary key (device_code))
;ϵͳĿ
create table MS_sys_item (item_code varchar2(32),item_id varchar2(64),
item_name varchar2(256),primary key (item_code))

;ϵͳĿ쳣״̬Ϣ
create table MS_sys_item_exception(exception_code varchar2(32),exception_id varchar2(32),
exception_description varchar2(256),primary key (exception_code));

;ϵͳϢ
create table MS_sys (creation_time date,device_code char(10),
item_code varchar2(32),current_value varchar2(256), foreign key (device_code) references MS_sys_device (device_code),foreign key (item_code) references MS_sys_item(item_code));

;ϵͳ쳣Ϣ
create table MS_sys_execption (creation_time date,device_code char(10),item_code varchar2(32),current_value varchar2(256), exception_code varchar2(32),foreign key (device_code) references MS_sys_device(device_code),foreign key (item_code) references MS_sys_item(item_code),foreign key (exception_code) references MS_sys_item_exception(exception_code));

;ϵͳֵ
create table MS_sys_threshold(item_code varchar2(32),threshold varchar2(16),alarm varchar2(16),foreign key (item_code) references MS_sys_item(item_code));



;Ӧô
create table MS_app_subsystem (subsystem_code varchar2(16),subsystem_id varchar2(32),subsystem_name varchar2(64), primary key (subsystem_code));

;ӦüĿ
create table MS_app_item (item_code varchar2(32),item_id varchar2(128),item_name varchar2(256),primary key (item_code));

;ӦüĿ쳣״̬Ϣ
create table MS_app_item_exception (exception_code varchar2(32),exception_id varchar2(32),exception_description varchar2(256),primary key (exception_code));


;ӦüϢ
create table MS_app_monitor (creation_time date,subsystem_code varchar2(16),item_code varchar2(32),current_value varchar2(256), foreign key (subsystem_code) references MS_app_subsystem(subsystem_code),foreign key (item_code) references MS_app_item(item_code));

;Ӧü쳣Ϣ
create table MS_app_exception (creation_time date,subsystem_code varchar2(16),item_code varchar2(32),current_value varchar2(256), exception_code varchar2(32),foreign key (subsystem_code) references MS_app_subsystem(subsystem_code),foreign key (item_code) references MS_app_item(item_code),foreign key (exception_code) references MS_app_item_exception(exception_code));



;Ӧֵ
create table MS_app_threshold(item_code varchar2(32),threshold varchar2(16),alarm varchar2(16),foreign key (item_code) references MS_app_item(item_code));
