ANBOB™

oracle推出了新一代的企业管理器Enterprise Manager Cloud Control 12c,目前在OTN已经可以下载到12c Release 2版本，下面记录一下安装过程，期间因为安装过程中关机重装带来了一些问题，总体安装很简单

EM 12c在安装时和11EM相似，只是增加了Plug-ins 的选择，Plug-ins 和 Connectors做为GRID CONTROLE的扩展并增加了一些非oracle的产品整合为”Cloud”云管理包含DATABASE,Middleware,VM server

目前包含的plug-ins包含 Oracle Database, Oracle Exadata, My Oracle Support, Oracle Fusion Middleware, Oracle Virtualisation  IBM DB2, Sybase ,ms-sqlserver, .net,apathe tomcat 等等

我是安装在OEL 5.8 X64平台上,Enterprise Manager Cloud Control 12c 也是r2版本在ORACLE官方网站都可下载到，em 12c总共目前5G（两个压缩包），包含了Weblogic server，只要一台内存在4G以上cpu2个以上的机器安装Small模式

其它硬件要求

Packages required:

• make-3.81
• binutils-2.17.50.0.6
• gcc -4.1.1
• libaio-0.3.106
• glibc-common-2.3.4
• libstdc++ -4.1.1
• setarch-1.6
• sysstat-5.0.5
• rng-utils-2.0
• libXtst-1.0.1-3.1(x86_64)
• glibc-2.5.12

Port Requirements

•Admin Server HTTP SSL Port = 7101 – 7200

•Enterprise Manager Upload HTTP Port = 4889 – 4898

•Enterprise Manager Upload HTTP SSL Port = 1159, 4899 – 4908

•Enterprise Manager Central Console HTTP Port = 7788 – 7798

•Enterprise Manager Central Console HTTP SSL Port = 7799 – 7809

•Oracle Management Agent Port = 3872, 1830 – 1849

Repository Database requirements
所需要数据库存放数据要先安装，推荐的版本是11202,11203,10205，如果是11201还要修复 bugs 10014178 、 8799099，我这里安装选用了10205

参数配置

open_cursors needs to be 300 to 400
processes should be greater than 300
session_cached_cursors between 200 and 500
job_queue_interval needs to be at least 20
shared pool size minimum 600 MB
Redo log file sizes minimum 300 MB and 3 groups or more
UNDO tablespace has a minimum space of 200 MB
pga_aggregate_target size minimum 1g
sga_target greater than 2g

停止 Gather Statistics job

For 10g use :
execute dbms_scheduler.disable(‘GATHER_STATS_JOB’,TRUE);
execute dbms_scheduler.stop_job(‘GATHER_STATS_JOB’,TRUE);

For 11g use :
execute dbms_auto_task_admin.disable(‘auto optimizer stats collection’,null,null);

下面开始安装，我是把数据库和oem装在了一台机器上，从装操作系统开始
1，install OEL5.8 X64 OS

2，install oracle-validated 为了简化安装，并帮配置内核参数

放入OS安装DVD盘，配置yum源
[root@oem u02]# vi /etc/yum.repos.d/public-yum-el5.repo
[oel5]
name = Enterprise Linux 5.8 DVD
baseurl=file:///media/disk/Server/
gpgcheck=0
enabled=1
[root@oem u02] yum install oracle-validated

3,install oracle database 10201

./runInstaller -ignoreSysPrereqs

4,install oracle database 10205 patch
如果选择了配置OEM最后会有异常不影响数据库，bug read node 1222603.1,如果dbca前后都可以通过应用8350262补丁解决，因为安装em12c是不允许配置db console和grid control的，所以忽略

5，修改db 参数，参照上面的需要
如
SQL> alter system set processes=350 scope=spfile;
SQL> alter system set session_cached_cursors=300 scope=spfile;
SQL> alter system set shared_pool_size=700M;
SQL> alter system set pga_aggregate_target=1100m;
SQL> alter system set job_queue_processes=25;
sql> alter system set shared_pool_size=700m;

6，netca 配置listener并启动

7, drop repository db for db console and grid control

[oracle@oem ~]$ emca -deconfig dbcontrol db -repos drop

8，增加em12c 专用os用户（不是必需）
[root@oem ~]# useradd -g oinstall – cloud
[root@oem ~]# passwd cloud

[root@oem ~]#vi /etc/security/limits.conf
##—append for em—-
cloud soft nofile 4096
cloud hard nofile 4096

9, 创建em 安装目录配置正确的权限，解压安装文件包

[root@oem u02]# hostname
oem

[root@oem u02]# cat /etc/hosts
# Do not remove the following line, or various programs
# that require network functionality will fail.
127.0.0.1 localhost
#::1 localhost6.localdomain6 localhost6
192.168.168.191 oem.anbob.com oem

10，用 Enterprise Manager Prerequisite Kit utility (emprereqkit)进行装前检查,注意修改为自己的数据库配置
su – cloud
unset ORACLE_HOME ORACLE_BASE ORACLE_SID
/u02/em12c是安装文件解压后目录
[cloud@oem bin]$ pwd
/u02/em12c/install/requisites/bin

[cloud@oem bin]$ ./emprereqkit -executionType install -prerequisiteXMLLoc /u02/em12c/install/requisites/list -dbHost oem -dbPort 1521 -dbSid oem12c -dbUser SYS -dbPassword syspassowrd -dbRole sysdba -showPrereqs

Checking Temp space: must be greater than 400 MB. Actual 3003 MB Passed
Checking swap space: must be greater than 150 MB. Actual 7952 MB Passed
Preparing to Bootstrap Please wait …
BootStrap To /tmp/emprereqkit_110212173439_BS Completed
Oracle Enterprise Manager Cloud Control 12c Release 12.1.0.2.0
Copyright (c) 1996, 2010 Oracle Corporation. All rights reserved.

Running EMPrereqKit …………

Result of prerequisite list, for scenario install :
省略

11，正式安装

[cloud@oem em12c]$./runInstaller

按照图形提示就可以，最后要用root执行一个allroot.sh
最后一页是成功的提示文件在/install/setupinfo.txt

访问https://192.168.168.191:7799/em

oem12c anbob 张维照

用户名sysman or system

相关命令

export OMS_HOME=/u01/app/oem12c/middleware/oms
export AGENT_HOME=/u01/app/oem12c/agent/core/12.1.0.2.0

$OMS_HOME/bin/emctl stop oms -all
$AGENT_HOME/bin/emctl stop agent
$OMS_HOME/bin/emctl start oms
$AGENT_HOME/bin/emctl start agent

重装方法
rm -rf 安装目录
drop user sysman cascade;
drop user sysman_mds cascade;
drop user sysman_opss cascade;
drop user sysman_apm cascade;
drop user sysman_ro cascade;
drop user mgmt_view cascade;

@?/rdbms/admin/catsnmp

drop 一些对象建立在上面schema上的public synonym
compile INVALID OBJECTS ON repos db for EM

打赏

微信扫一扫，打赏作者吧～