How to find error message from OMS repository
4133 ワード
OEMまたはOMS管理ツールは、データベース・メトリック・アラートとエラー情報に簡単にアクセスできるインタフェースを提供しています.手動でクエリーすることで、直接これらの情報を表示できますか?答えは肯定的で、OMS repositoryについて一定の理解が必要です.
SQL> desc sysman.MGMT_CURRENT_METRIC_ERRORS;
Name Null? Type
----------------------------------------- -------- ----------------------------
TARGET_GUID NOT NULL RAW(16)
METRIC_GUID NOT NULL RAW(16)
COLL_NAME NOT NULL VARCHAR2(64)
AGENT_GUID NOT NULL RAW(16)
COLLECTION_TIMESTAMP NOT NULL DATE
METRIC_ERROR_MESSAGE VARCHAR2(4000)
METRIC_ERROR_TYPE NUMBER(1)
/* MGMT_CURRENT_METRIC_ERRORS OMS console */
SQL> desc sysman.MGMT_METRIC_ERRORS;
Name Null? Type
----------------------------------------- -------- ----------------------------
TARGET_GUID NOT NULL RAW(16)
METRIC_GUID NOT NULL RAW(16)
COLL_NAME NOT NULL VARCHAR2(64)
AGENT_GUID NOT NULL RAW(16)
COLLECTION_TIMESTAMP NOT NULL DATE
METRIC_ERROR_MESSAGE VARCHAR2(4000)
METRIC_ERROR_TYPE NUMBER(1)
/* MGMT_METRIC_ERRORS */
SQL> SELECT METRIC_ERROR_MESSAGE,COLLECTION_TIMESTAMP,METRIC_ERROR_TYPE FROM MGMT_CURRENT_METRIC_ERRORS WHERE COLLECTION_TIMESTAMP<'20-Mar-11';
METRIC_ERROR_MESSAGE COLLECTIO METRIC_ERROR_TYPE
-------------------------------------------------- --------- -----------------
Missing Properties : [SQLINPARAM1] 03-MAR-11 0
Missing Properties : [SQLINPARAM1] 03-MAR-11 0
Missing Properties : [SQLINPARAM1] 03-MAR-11 0
Missing Properties : [SQLINPARAM1,SQLINPARAM4] 03-MAR-11 0
Missing Properties : [SQLINPARAM1] 03-MAR-11 0
Missing Properties : [SQLINPARAM1] 03-MAR-11 0
Missing Properties : [SQLINPARAM1] 03-MAR-11 0
Missing Properties : [SQLINPARAM1] 03-MAR-11 0
Missing Properties : [SQLINPARAM1] 03-MAR-11 0
Result has repeating key value : OCM_APPLY,apply 05-MAR-11 0
/* 3 20 console */
SQL> desc sysman.mgmt$alert_current;
Name Null? Type
----------------------------------------- -------- ----------------------------
TARGET_NAME NOT NULL VARCHAR2(256)
TARGET_TYPE NOT NULL VARCHAR2(64)
TARGET_GUID NOT NULL RAW(16)
VIOLATION_GUID RAW(16)
METRIC_NAME NOT NULL VARCHAR2(64)
METRIC_COLUMN NOT NULL VARCHAR2(64)
METRIC_GUID NOT NULL RAW(16)
METRIC_LABEL VARCHAR2(64)
COLUMN_LABEL VARCHAR2(256)
KEY_VALUE VARCHAR2(256)
KEY_VALUE2 VARCHAR2(256)
KEY_VALUE3 VARCHAR2(256)
KEY_VALUE4 VARCHAR2(256)
KEY_VALUE5 VARCHAR2(256)
COLLECTION_TIMESTAMP DATE
ALERT_STATE VARCHAR2(18)
VIOLATION_LEVEL NOT NULL NUMBER
VIOLATION_TYPE VARCHAR2(19)
MESSAGE VARCHAR2(4000)
MESSAGE_NLSID VARCHAR2(64)
MESSAGE_PARAMS VARCHAR2(4000)
ACTION_MESSAGE VARCHAR2(4000)
ACTION_MESSAGE_NLSID VARCHAR2(64)
ACTION_MESSAGE_PARAMS VARCHAR2(4000)
TYPE_DISPLAY_NAME VARCHAR2(128)
CURRENT_VALUE VARCHAR2(1024)
/* mgmt$alert_current Grid , mgmt$alert_history */
SQL> select target_name,message from SYSMAN.mgmt$alert_current;
TARGET_NAME MESSAGE
-------------------- ----------------------------------------------------------------------------------------------------
nas:3872 Difference between OMS system time and Agent system time is 7680 mins and has exceeded the critical
threshold 120 mins
rh3:3872 Agent Virtual Memory Growth is 1.53%
rh3:3872 Count of targets not uploading exceeded the critical threshold (0). Current value: 2
EMREP_rh3 User SYS logged on from rh3.oracle.com.
LSN1_rh3 The listener is down: TNS-12541: TNS:no listener .
rh6:3872 Difference between OMS system time and Agent system time is 7199 mins and has exceeded the critical
threshold 120 mins
Management Services Management Service Status for nas:4889_Management_Service exceeded the critical threshold (DOWN). Cu
and Repository rrent value: DOWN