Oracle OEM 13c 部署详解

Oracle OEM 13c 部署详解

适用版本:Oracle Enterprise Manager 13c Release 5 文档版本:v1.0 / 2026-07


1. 概述

Oracle Enterprise Manager 13c 是综合管理平台[1]:

组件

  • OMS(Oracle Management Service)
  • Repository(仓库数据库)
  • Agent(代理)

详细见:Oracle 监控告警配置


2. 架构

┌─────────────────────────────────────┐
│  EM Console(Web)                  │
└────────────────┬────────────────────┘

┌────────────────▼────────────────────┐
│  OMS(Oracle Management Service)   │
│  - WebLogic                        │
│  - Java                            │
└────────────────┬────────────────────┘

        ┌────────┴─────────┐
        │                  │
┌───────▼────────┐  ┌──────▼──────┐
│ Repository DB  │  │ Agent       │
│ (sysman)       │  │ (目标)      │
└────────────────┘  └─────────────┘

3. 部署规划

3.1 硬件

OMSRepositoryAgent
CPU8 核8 核1 核
内存16GB16GB1GB
磁盘100GB200GB5GB

3.2 端口

- OMS HTTPS:7803
- OMS HTTP:7788
- Repository:1521
- Agent:3872

4. Repository 数据库

4.1 创建

dbca -silent -createDatabase \
  -templateName General_Purpose.dbc \
  -gdbName emrep \
  -sid emrep \
  -createAsContainerDatabase false \
  -sysPassword Oracle123 \
  -systemPassword Oracle123 \
  -storageType FS \
  -datafileDestination /u01/app/oracle/oradata \
  -characterSet AL32UTF8 \
  -totalMemory 8192 \
  -databaseType OLTP

4.2 参数

ALTER SYSTEM SET processes=600 SCOPE=SPFILE;
ALTER SYSTEM SET session_cached_cursors=400 SCOPE=SPFILE;
ALTER SYSTEM SET shared_pool_size=1G SCOPE=SPFILE;
ALTER SYSTEM SET pga_aggregate_target=2G SCOPE=SPFILE;
ALTER SYSTEM SET sga_target=6G SCOPE=SPFILE;
ALTER SYSTEM SET open_cursors=400 SCOPE=SPFILE;
ALTER SYSTEM SET undo_retention=7200 SCOPE=SPFILE;
SHUTDOWN IMMEDIATE;
STARTUP;

5. OMS 安装

5.1 准备

# 用户
groupadd -g 54321 oinstall
useradd -u 54321 -g oinstall oracle

# 目录
mkdir -p ******
mkdir -p ******
chown -R oracle:oinstall /u01/app/oracle

5.2 安装

su - oracle
./em13400_linux64.bin

5.3 静默

./em13400_linux64.bin -silent -responseFile /tmp/em_install.rsp

5.4 响应文件

UNIX_GROUP_NAME=oinstall
INVENTORY_LOCATION=/u01/app/oraInventory
INSTALL_TYPE=Advanced
ORACLE_MIDDLEWARE_HOME_LOCATION=/u01/app/oracle/middleware
ORACLE_HOSTNAME=oem.example.com
AGENT_BASE_DIR=/u01/app/oracle/agent
WLS_ADMIN_SERVER_USERNAME=weblogic
WLS_ADMIN_SERVER_PASSWORD=******
NODE_MANAGER_USERNAME=nodemanager
NODE_MANAGER_PASSWORD=******
ORACLE_INSTANCE_HOME_LOCATION=/u01/app/oracle/gc_inst
CONFIGURE_ORACLE_SOFTWARE_LIBRARY=true
SOFTWARE_LIBRARY_LOCATION=/u01/app/oracle/swlib
DATABASE_HOSTNAME=db-host
LISTENER_PORT=1521
SERVICENAME_OR_SID=emrep
SYS_PASSWORD=******
SYSTEM_PASSWORD=******
SYSMAN_PASSWORD=******
AGENT_REGISTRATION_PASSWORD=******

5.5 root 脚本

/u01/app/oraInventory/orainstRoot.sh
/allroot.sh

6. 访问

6.1 URL

https://oem.example.com:7803/em

6.2 登录

- sysman / Oracle123

7. Agent 部署

7.1 Add Target

Setup → Add Target → Add Targets Manually → Install Agent on Host

7.2 静默

# agentDeploy.sh
./agentDeploy.sh AGENT_BASE_DIR=/u01/app/oracle/agent \
  OMS_HOST=oem.example.com \
  EM_UPLOAD_PORT=4903 \
  AGENT_INSTANCE_HOME=/u01/app/oracle/agent/agent_inst \
  b_forceInstallCheck=true \
  AGENT_PORT=3872 \
  ORACLE_HOSTNAME=target.example.com \
  AGENT_REGISTRATION_PASSWORD=******

7.3 验证

emctl status agent

8. 目标添加

8.1 数据库

Setup → Add Target → Add Targets Declaratively → Database

8.2 自动发现

Setup → Add Target → Configure Auto Discovery

8.3 命令行

emcli add_target -name="orcl" -type="oracle_database" \
  -host="oradb1" \
  -credentials="UserName:dbsnmp;password:****** \
  -properties="SID:orcl;Port:1521;OracleHome:/u01/app/oracle/product/19.0.0/dbhome_1;MachineName:oradb1"

9. 监控

9.1 监控模板

Enterprise → Monitoring → Monitoring Templates

9.2 告警

Enterprise → Monitoring → Incident Manager

9.3 指标

- CPU
- 内存
- 磁盘
- 数据库
- SQL

详细见:Oracle 监控告警配置


10. 报告

10.1 AWR

Performance → AWR

10.2 ASH

Performance → ASH

10.3 ADDM

Performance → ADDM

详细见:Oracle AWR 报告详解


11. 备份

11.1 OMS

emctl stop oms -all

# 备份
tar -czf /backup/oms.tar.gz /u01/app/oracle/middleware
tar -czf /backup/gc_inst.tar.gz /u01/app/oracle/gc_inst

11.2 Repository

RMAN> BACKUP DATABASE PLUS ARCHIVELOG;

11.3 恢复

emctl stop oms -all
# 还原文件
emctl start oms

详细见:Oracle 备份策略与最佳实践


12. 管理

12.1 OMS

emctl start oms
emctl stop oms
emctl status oms
emctl status oms -details

12.2 Agent

emctl start agent
emctl stop agent
emctl status agent
emctl pingOMS

12.3 WebLogic

$MW_HOME/oracle_common/common/bin/wlst.sh
$DOMAIN_HOME/bin/startWebLogic.sh
$DOMAIN_HOME/bin/stopWebLogic.sh

13. 升级

13.1 13.4 → 13.5

./em13500_linux64.bin

13.2 流程

1. 备份 OMS
2. 备份 Repository
3. 升级 Repository
4. 升级 OMS
5. 升级 Agent

详细见:Oracle Patch RU 详细操作


14. 常见坑与排错

14.1 Agent 无法连接

emctl pingOMS
# 防火墙 / 端口

14.2 OMS 启动失败

emctl status oms -details
# 日志 $GC_INST/user_projects/domains/GCDomain/servers/EMGC_OMS1/logs

14.3 Repository 满

SELECT file_name, bytes/1024/1024/1024 AS GB FROM dba_data_files;
-- 添加空间

15. 最佳实践

  1. 独立 Repository:性能
  2. Agent 全部署:监控
  3. 告警模板:标准
  4. Incident Manager:集中
  5. 报告:自动
  6. 备份:保护
  7. 升级:及时
  8. WebLogic:监控
  9. 资源充足:稳定
  10. 文档化:配置

16. 参考资料

[1] Oracle Enterprise Manager Cloud Control Basic Installation Guide 13c Release 5 https://docs.oracle.com/en/enterprise-manager/index.html