Older Entries »

Grid Control OMS Agent代理工作原理图

作者: Maclean Liu, post on January 4th, 2012
grid_control_agent

我们在使用Grid Control集中化管理OS、Oracle数据库时要求在host上安装Agent代理程序，以便Agent定期收集OS、Oracle信息传输给Oracle Grid Control Management Server(OMS)，并执行OMS下达的一系列指令。

大多数人对于Agent的了解仅限于如何安装和启动agent，下图展示了OMS Agent的架构:

 

 

Agent主要由2个组件(component)部分组成，分别是Collector 收集器和 Metric Engine 度量引擎。

 

Collector收集器是agent的重要子系统。它负责收集并上传metric data度量数据到OMS(oms最终将这些数据存入数据库中)。Collector 利用collection file中的信息判定针对哪些target目标需要收集metric data以及多久收集一次。 为了获取数据，Collector将查询投递给Metric Engine，而Metric Engine负责实际的metric data的收集。 Metric Engine 通过Fetchlets 、Metadata原信息文件(Metadata files defined in OH/sysman/admin/metadata)和 已发现的target 信息文件(Targets defined in OH/sysman/emd/targets.xml)来获得每一个目标的metrics监控信息。 同时 metadata原信息文件也提供了实际如何去计算metrics度量的算法。

 

基于以上这些信息，Metric Engine 将使用恰当的fetchlets从监控目标获取数据， 这里的 Fetchlets指的是指定数据的访问方式， 例如访问数据库性能数据会采用SQL Fetchlets，而访问OS数据则使用OS Fetchlets。

 

一旦Collector 收集到metric data，它会将这些度量数据和已定义的阀值做对比，检查是否发送警告(alert waring)， . . . → Read More: Grid Control OMS Agent代理工作原理图

8 comments   EM, Oracle   , , , , ,  

Gain Total Cloud Control with Oracle Enterprise Manager 12c

作者: Maclean Liu, post on October 5th, 2011

Agenda

Introduction Infrastructure as a Service (IaaS) and Database as a Service (DBaaS) Demo Environment Topology Use Cases Key Features Overview Summary

 

Oracle Enterprise Manager 12c is the only complete cloud management solution that offers total cloud control for your enterprise cloud.

There are three key aspects of Oracle Enterprise Manager 12c that help . . . → Read More: Gain Total Cloud Control with Oracle Enterprise Manager 12c

Leave a comment   EM, Oracle, Oracle 12c新特性

Enterprise Manager Cloud Control 12c DSS Demos

作者: Maclean Liu, post on October 5th, 2011

Agenda

Introduction “Grand Tour” Overview WebLogic Server Management Overview Fusion Applications Management Overview Coming Soon DSS Contacts Q & A

 

 

First Releases: EM Cloud Control 12c Overview Demo Environment EM Cloud Control 12c “Grand Tour” Demo EM Cloud Control 12c WLS Management Overview Demo EM Cloud Control 12c Fusion Apps Mgmt Overview Demo . . . → Read More: Enterprise Manager Cloud Control 12c DSS Demos

Leave a comment   EM, Oracle, Oracle 12c新特性

Script:List Grid Control Jobs

作者: Maclean Liu, post on August 29th, 2011

以下脚本可以用于列出Grid Control中的定式作业:

SET verify OFF SET linesize 255 SET pagesize 128 SET trimout ON SET trimspool ON SPOOL jobdump.log ALTER SESSION SET nls_date_format=’MON-DD-YYYY hh:mi:ss pm’; COLUMN status format a15 COLUMN job_name FORMAT a64 COLUMN job_type FORMAT a32 COLUMN job_owner FORMAT a32 COLUMN job_status format 99 COLUMN target_type format a64 COLUMN frequency_code format a20 COLUMN interval . . . → Read More: Script:List Grid Control Jobs

One comment   EM, Oracle, Oracle脚本script   , , , ,  

Script:GridControl Repository Health Check

作者: Maclean Liu, post on August 29th, 2011

以下脚本可以用于检查Grid Control(OMS) Repository的健康程度:

set linesize 130 set pagesize 50000 Set feedback off set heading off SPOOL RepositoryHealth.log PROMPT ********* Report to capture the Health of the EM Grid Control Repository ****** Prompt Prompt *** EM Vital Statistics *** Prompt ——————————– — Total number of targets monitored by EM select ‘Total Targets=’, TO_CHAR(count(*)) from mgmt_targets; — . . . → Read More: Script:GridControl Repository Health Check

Leave a comment   EM, Oracle, Oracle脚本script   , , ,  

Next Generation Database Management with Oracle Enterprise Manager 11g

作者: Maclean Liu, post on August 3rd, 2011

Oracle surveyed our installed base and we found that regardless of company size or number of databases managed, the tasks that a DBA needs to perform fall into one of three main categories.

Delivering sustained, optimal performance and uptime is critical to the business users of your databases.

Even while performance management is going on, . . . → Read More: Next Generation Database Management with Oracle Enterprise Manager 11g

Leave a comment   EM, Oracle, Oracle 11g新特性   ,  

Enterprise Manager show database status is unavailable

作者: Maclean Liu, post on August 3rd, 2011

客户的一套11.2.0.1 RAC数据库部署了 Enterprise Manager 11g以方便管理，但系统运行一段时间后EM就变得无法正常使用了，页面显示”the database status is currently unavailable…….”，但实际上数据库和监听都处于正常可用的状态。

作为乙方来说对Enterprise Manager并不太熟悉，虽然EM是一个十分强大的图形化监控工具，但是我们很少有机会在生产环境中用到它，这一点可能和甲方的DBA不同。

针对该EM不可用的问题首先想到了尝试重启dbconsole，以验证该问题是否可重现。

emctl stop dbconsole emctl start dbconsole

重启dbconsole后问题依旧,查MOS发现引发该EM不可用问题的可能性有多种，通过$ORACLE_HOME/_/sysman/log/emoms.log的EM相关日志可以进一步定位该问题:

tail -500 emoms.log at com.evermind.server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:871) at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:453) at com.evermind.server.http.HttpRequestHandler.serveOneRequest(HttpRequestHandler.java:221) at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:122) at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:111) at oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260) at oracle.oc4j.network.ServerSocketAcceptHandler.procClientSocket(ServerSocketAcceptHandler.java:234) at oracle.oc4j.network.ServerSocketAcceptHandler.access$700(ServerSocketAcceptHandler.java:29) at oracle.oc4j.network.ServerSocketAcceptHandler$AcceptHandlerHorse.run(ServerSocketAcceptHandler.java:879) at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303) at java.lang.Thread.run(Thread.java:595) 2011-08-02 14:39:46,131 [EMUI_14_39_46_/console/aboutApplication] ERROR em.console doGet.363 – java.lang.IllegalStateException: Response . . . → Read More: Enterprise Manager show database status is unavailable

One comment   EM, Oracle, Oracle 11g新特性   , ,  

Enterprise Manager 11g Technical Preview: Application Testing Suite 9.1

作者: Maclean Liu, post on November 11th, 2010

I would like to start with a quick review of Oracle Enterprise Manager. For all of you here in this room, applications are key IT and enterprise assets. If you are on the business side, they provide productivity and automation for your business processes. If you are on the IT side, well, you are constantly . . . → Read More: Enterprise Manager 11g Technical Preview: Application Testing Suite 9.1

Leave a comment   EM, Oracle   , , ,  
 
  Older Entries »