Oracle Grid Control

有了Grid Control,数据库可以集中进行监控管理.Gird Control分三个组件或服务.
(1)Repository用来存放管理数据,一般使用单独的数据库进行管理,关键的2个tablespace为:MGMT_TABLESPACE,MGMT_ECM_DEPOT_TS
(2)Management Service用来协调repository和agent进行数据交互.
(3)Agent用来抽取客户主机上所有DB的信息.

1,一般是单独拿出一台机器oracle.sannet.net,进行安装数据库,并安装Grid Control,如果数据库已创建好,需要先设置:

(1)pfile参数

29-FEB-12 SYS @ RDPSDB>show parameter session_cached_cursors
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
session_cached_cursors               integer     201
29-FEB-12 SYS @ RDPSDB>show parameter job_queue_processes
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
job_queue_processes                  integer     11
29-FEB-12 SYS @ RDPSDB>show parameter open_cursors
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
open_cursors                         integer     301

(2)执行脚本
SQL>@?/rdbms/admin/dbmspool.sql

(3)解锁dbsnmp用户
SQL>alter user dbsnmp identified by oracle account unlock;

2,在oracle.sannet.net上安装grid control
(1),在oracle官网下载,所有版本的grid control安装包都在上面.
    http://www.oracle.com/technetwork/oem/grid-control/downloads/index.html
    http://www.oracle.com/technetwork/oem/grid-control/downloads/linuxsoft-099441.html
    这里下载gc_102011_linux.zip

(2),如果已建的DB已安装配置DB control,安装之前,会提示卸载并删除已有的DB Control.

(3),因为该机器已经安装好了oracle并创建了数据库,所以只需要在oracle账户下,直接安装grid control即可.
    安装时,安全密码和SYSMAN用户需要设置字母和数字组合,长度大于6的字串,如oracle001.

(4),最后的配置环节会耗时较长,尤其是OMS configuration.

(5),一旦grid control安装安装结束,oracle.sannet.net本机也会自动装上agent组件,本机上的数据库就可以进行自我监控.

 

3,在其他数据库上安装agent,完成对其他数据库的监控管理.

(1),注意配置oracle的.bash_profile文件中PATH里含有$ORACLE_HOME/jdk/bin路径

(2),将grid control上的安装目录下agentDownload.linux文件拷贝到装agent的主机,修改权限可以执行chmod 755 agentDownload.linux.
    文件路径/u01/app/oracle/OracleHomes/oms10g/sysman/agent_download/10.2.0.1.0/linux/agentDownload.linux
(3),在agent主机上,建立安装目录/u01/app/oracle/agent,并执行./agentDownload.linux -b /u01/app/oracle/agent,按提示安装完成.
(4),装完后,可以看见grid control上已经有安装了agent的主机,同时可以看见其上所有的DB都已经显示,最后完成配置即可.


关闭和启动grid control

(1)启动grid control(启动OMS和Agent服务,保证repository数据库RDPSDB已经启动)
   /etc/init.d/gcstartup,它在root下启动的是下面的oms和agent
  /u01/app/oracle/OracleHomes/oms10g/install/unix/scripts/omsstup start
  /u01/app/oracle/OracleHomes/agent10g/install/unix/scripts/agentstup start

(2)关闭grid control(关闭Agent和OMS,关闭repository数据库RDPSDB)
  /u01/app/oracle/OracleHomes/oms10g/install/unix/scripts/omsstup stop
  /u01/app/oracle/OracleHomes/agent10g/install/unix/scripts/agentstup stop

(3)启动Agent
  /etc/init.d/gcstartup,在root下启动,启动的是下面的agent
  /oracle/agent/agent10g/install/unix/scripts/agentstup start

(4)关闭Agent
  /oracle/agent/agent10g/install/unix/scripts/agentstup stop

(5)在grid control下查看oms状态
  /u01/app/oracle/OracleHomes/oms10g/opmn/bin/opmnctl status

(6)查看agent状态
  [oracle@rac1 ~]$ /oracle/agent/agent10g/bin/emctl status agent

(7)OMS的启动与关闭实际上是通过命令完成opmnctl,查看.
  [oracle@oracle oms10g]$ /u01/app/oracle/OracleHomes/oms10g/opmn/bin/opmnctl stopall
  opmnctl: stopping opmn and all managed processes...
  [oracle@oracle oms10g]$ /u01/app/oracle/OracleHomes/oms10g/opmn/bin/opmnctl status
  Unable to connect to opmn.
  Opmn may not be up.
  [oracle@oracle oms10g]$ /u01/app/oracle/OracleHomes/oms10g/opmn/bin/opmnctl startall
  opmnctl: starting opmn and all managed processes...
  [oracle@oracle oms10g]$ /u01/app/oracle/OracleHomes/oms10g/opmn/bin/opmnctl status

  Processes in Instance: EnterpriseManager0.oracle.sannet.net
  -------------------+--------------------+---------+---------
  ias-component      | process-type       |     pid | status  
  -------------------+--------------------+---------+---------
  DSA                | DSA                |     N/A | Down    
  HTTP_Server        | HTTP_Server        |   19390 | Alive   
  LogLoader          | logloaderd         |     N/A | Down    
  dcm-daemon         | dcm-daemon         |     N/A | Down    
  OC4J               | home               |   19391 | Alive   
  OC4J               | OC4J_EMPROV        |   19392 | Alive   
  OC4J               | OC4J_EM            |   19394 | Alive   
  WebCache           | WebCache           |   19405 | Alive   
  WebCache           | WebCacheAdmin      |   19401 | Alive

升级GC到10.2.0.5版本

GC服务器端升级安装包(升级服务器OMS和agent使用)
gc_10205_part1of2.zip
gc_10205_part2of2.zip

解压2个zip,得到p8202632_10205_LINUX.zip,接着解压,得到Disk1目录.

GC客户端安装包(升级客户端agent使用)
Linux_Grid_Control_agent_download_10_2_0_5_0.zip

注意:
(1),升级顺序:
先升级服务器OMS,再升级服务器Agent,安装升级之前需要export ORACLE_HOME=/u01/app/oracle/OracleHomes/oms10g/,exportORACLE_HOME=/u01/app/oracle/OracleHomes/agent10g,最后升级客户端Agent.

(2),ias_admin password设置与sysman密码一致

参考网友
http://wenku.baidu.com/view/2df1727202768e9951e738f8.html
http://candon123.blog.51cto.com/704299/347246
http://blog.itpub.net/post/42280/502406

常见问题调试
(1)当出现grid control主机的磁盘空间满,它将自动停止收集数据.