GridControl環境構成再び・・・ - honu @ ウィキ

グリッドコントロール環境構成で参考にしたサイトは以下

http://www.oracle.com/technetwork/articles/revitt-oem-096363.html#l

---

躓いたところをまとめてみます。

１．オブジェクトが既に出来ている？？

/u01/app/oracle/product/10.2.0/oms10g/perl/bin/perl /u01/app/oracle/product/10.2.0/oms10g/sysman/install/ConfigureGC.pl /u01/app/oracle/product/10.2.0

のコマンドを実行したところ、オブジェクトが既にあるとのエラーが出力された。

この時の回避策は以下

　1.以下のdropコマンドを実行する
　 drop user sysman cascade;

　drop user mgmt_view;
　drop role mgmt_user;
　drop public synonym mgmt_availability;
　drop public synonym mgmt_target_blackouts;
　drop public synonym mgmt_current_availability;
　drop public synonym mgmt_severity_obj;
　drop public synonym mgmt_severity_array;
　drop public synonym MGMT_GUID_OBJ;
　drop public synonym MGMT_GUID_ARRAY;
　drop public synonym SMP_EMD_AVAIL_OBJ;
　drop public synonym SMP_EMD_TARGET_OBJ;
　drop public synonym SMP_EMD_TARGET_OBJ_ARRAY;
　drop public synonym SMP_EMD_DELETE_REC_ARRAY;
　drop public synonym MGMT_METRICS;
　drop public synonym MGMT_TARGETS;
　drop public synonym MGMT_TYPE_PROPERTIES;
　drop public synonym MGMT_TARGET_PROPERTIES;
　drop public synonym MGMT_METRICS_RAW;
　drop public synonym MGMT_CURRENT_METRICS;

　 drop public synonym MGMT_STRING_METRIC_HISTORY;

　drop public synonym MGMT_LONG_TEXT;
　drop public synonym MGMT_LONG_TEXT;
　drop public synonym MGMT_METRICS_COMPOSITE_KEYS;
　drop public synonym MGMT_METRICS_1HOUR;

　 drop public synonym MGMT_METRICS_1DAY;
　 drop public synonym MGMT_METRIC_ERRORS;
　 drop public synonym MGMT_CURRENT_METRIC_ERRORS;
　 drop public synonym EMD_MNTR;
　 drop public synonym MGMT_METRIC_COLLECTIONS;

　drop public synonym MGMT_COLLECTION_PROPERTIES;

　 drop public synonym MGMT_METRIC_THRESHOLDS;
　 drop public synonym SMP_EMD_NVPAIR;
　 drop public synonym SMP_EMD_NVPAIR_ARRAY;
　 drop public synonym SMP_EMD_STRING_ARRAY;
　 drop public synonym SMP_EMD_STRING_ARRAY_ARRAY;
　 drop public synonym SMP_EMD_INTEGER_ARRAY;
　 drop public synonym SMP_EMD_INTEGER_ARRAY_ARRAY;
　 drop public synonym MGMT_DELTA_IDS;
　 drop public synonym MGMT_DELTA_ID_VALUES;
　 drop public synonym MGMT_DELTA_ENTRY;
　 drop public synonym MGMT_DELTA_ENTRY_VALUES;
　 drop public synonym MGMT_DELTA_VALUE;
　 drop public synonym MGMT_DELTA_VALUES;
　 drop public synonym MGMT_NAME_VALUE;
　 drop public synonym MGMT_NAME_VALUES;
　 drop public synonym ECM_UTIL;

　2.以下のセレクト文によって生成されたDROP文を実行する

　select 'drop public synonym '||object_name||';'
　from dba_objects
　where object_type='SYNONYM' and
　object_name like 'MGMT_%' and
　status='INVALID';

２．GridContorolにsysmanユーザでログインしようとしたところ、はじかれる

　以下のサイトに書かれている手順でsysmanユーザのパスワードを変更する

　http://www.anbob.com/?p=1286