GridControl環境構成再び・・・

※上記の広告は60日以上更新のないWIKIに表示されています。更新することで広告が下部へ移動します。

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




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

1.オブジェクトが既に出来ている??

/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';


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

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

最終更新:2012年10月26日 21:25