oracle oem13.5安装配置详细文档
包含详细的安装配置，常见的错误和解决办法，已经oem添加集群和主机等可能遇到的问题和解决办法
一、数据库基础环境安装
版本：oracle database 19c enterprise edition release 19.3.0.0.0 - 64bit production
non-cdb
二、数据库软件安装
三、dbca建库
模板建库：
13.5不需要使用模板建库
四、oem安装
附：环境变量、listener信息
创建安装目录
mkdir –r /data/oracle/middleware
mkdir –r /data/oracle/middlewareagent
密码：oracle123
五．dbca建库
alter system set parallel_min_servers=0;
alter system set session_cached_cursors=400 scope=spfile;
alter system set log_buffer=8m scope=spfile;
alter system set open_cursors=600 scope=spfile;
alter system set processes=800 scope=spfile;
alter system set shared_pool_size=1g scope=spfile;
alter system set session_cached_cursors=400 scope=spfile;
redo log 设置300m
alter database add logfile group 4 ('/data/oemdb/redo04.log') size 400m;
alter database add logfile group 5 ('/data/oemdb/redo05.log') size 400m;
alter database add logfile group 6 ('/data/oemdb/redo06.log') size 400m;
alter database drop logfile group 1;
alter database drop logfile group 2;
alter database drop logfile group 3;
restart db
shutdown immediate
startup
alter system set "_allow_insert_with_update_check"=true scope=both;
this information is also available at:
/home/data/oracle/middleware/install/setupinfo.txt
see the following for information pertaining to your enterprise manager installation:
use the following url to access:
1. enterprise manager cloud control url: https://xwyyoem:7803/em
2. admin server url: https://xwyyoem:7102/console
the following details need to be provided while installing an additional oms:
1. admin server host name: xwyyoem
2. admin server port: 7102
you can find the details on ports used by this deployment at : /home/data/oracle/middleware/install/portlist.ini
oem 安装介质路径：/software
oem oms路径：/home/data/oracle/middleware
oem agent路径：/home/data/oracle/middlewareagent
his information is also available at:
/data/oracle/middleware/install/setupinfo.txt
see the following for information pertaining to your enterprise manager installation:
use the following url to access:
1. enterprise manager cloud control url: https://szsplorcoem01:7803/em
2. admin server url: https://szsplorcoem01:7102/console
the following details need to be provided while installing an additional oms:
1. admin server host name: szsplorcoem01
2. admin server port: 7102
you can find the details on ports used by this deployment at : /data/oracle/middleware/install/portlist.ini
note:
an encryption key has been generated to encrypt sensitive data in the management repository. if this key is lost, all encrypted data in the repository becomes unusable.
a backup of the oms configuration is available in /data/oracle/gc_inst/em/emgc_oms1/sysman/backup on host szsplorcoem01. see cloud control administrators guide for details on how to back up and recover an oms.
note: this backup is valid only for the initial oms configuration. for example, it will not reflect plug-ins installed later, topology changes like the addition of a load balancer, or changes to other properties made using emctl or emcli. backups should be created on a regular basis to ensure they capture the current oms configuration. use the following command to backup the oms configuration:
/data/oracle/middleware/bin/emctl exportconfig oms -dir
如果添加主机ssh不是默认22端口 需要修改如下文件
[oracle@szsplorcoem01 resources]$ pwd
/data/oracle/middleware/oui/prov/resources
[oracle@szsplorcoem01 resources]$
vi /data/oracle/middleware/oui/prov/resources/paths.properties
[oracle@csicn20db01 ~]$ /u01/app/oracle/agent/agent_inst/bin/emctl config agent addinternaltargets
oracle enterprise manager cloud control 13c release 5
米乐app官网下载 copyright (c) 1996, 2021 oracle corporation. all rights reserved.
[oracle@csicn20db01 ~]$ /u01/app/oracle/agent/agent_inst/bin/emctl start agent
oracle enterprise manager cloud control 13c release 5
米乐app官网下载 copyright (c) 1996, 2021 oracle corporation. all rights reserved.
starting agent ...... started.
[oracle@csicn20db01 ~]$
六．新加被监控集群
- 手动配置安装代理
- 确保oem主机和db主机host都配置ok
- 主机选择主机名，和平台 11g目前只支持linux x86-64
- 配置安装目录 --确保安装目录不存在，系统会自动创建
- 配置oracle用户名和密码
- 配置root 用户和密码
- 开始部署
- 初始化部署 可能会需要一些时间
cd /u01/app/oracle/agent/adatmp_2023-05-30_15-23-43-pm;
/u01/app/oracle/agent/adatmp_2023-05-30_15-23-43-pm/agentdeploy.sh -ignoreprereqs oracle_hostname=jxrac01 agent_base_dir=/u01/app/oracle/agent oms_host=szsplorcoem01 em_upload_port=4903 agent_instance_home=/u01/app/oracle/agent/agent_inst b_dodiscovery=false start_agent=false b_forceinstcheck=true -force agent_port=3872
报错处理：
如果遇到如下问题 请排查
- db端和oms端的hosts文件均配置好主机ip应对关系
- wget https://szsplorcoem01:4903/empbs/upload --no-check-certificate
异常
正常 此命令能够正常执行是是否能推送成功agent的前提
报错图片
添加rac集群
- 首先按上面的步骤将agent在主机上安装好
- 自动发现主机上的目标
点到新加主机，然后点立即搜索
- 添加集群数据库
依次添加两个实例 测试连接，下一步完成
异常处理 dbname重复问题
如果dbname重复可能无法加入会报错
以下目标已经存在于基于属性的资料档案库中:- jxmes : rac_database
解决办法如下
- 首先搜索主机上的目标，找到主机上的集群数据库的名字
如果已经集群的dbname重复了，则发现的集群数据库可能会是如下图
orcl_1 或者是大写的orcl等等 只要名字不通就可以添加成功