Wednesday 22 July 2009

OEM : Add ability to run queries on target dbs for OEM report elements

  • Login as sys on the Grid Repository and execute :
    insert into sysman.mgmt_ip_report_elem_def values('target_user_table_from_sql','database_target_type',
    'target_user_table_from_sql',
    'oracle.sysman.db.util.reports.TableTargetRenderController',0,NULL,'EM',NULL,
    '10.2.0.1.0');

    Insert into SYSMAN.MGMT_IP_ELEM_PARAM_CLASSES
    (ELEMENT_NAME_NLSID, ELEMENT_TYPE_NLSID, ELEMENT_PARAM_CLASS, DISPLAY_ORDER)
    Values ('target_user_table_from_sql', 'database_target_type','oracle.sysman.eml.ip.render.elem.HeaderParamController',
    1);

    Insert into SYSMAN.MGMT_IP_ELEM_PARAM_CLASSES
    (ELEMENT_NAME_NLSID, ELEMENT_TYPE_NLSID, ELEMENT_PARAM_CLASS, DISPLAY_ORDER)
    Values ('target_user_table_from_sql', 'database_target_type', 'oracle.sysman.eml.ip.render.elem.SQLStatementParamController', 2);
    Commit;
  • In GC there is now an element type on the Report page called "target_user_table_from_sql" which allows scripts to run against a Target database.


0 comments: