※上記の広告は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