本文档详细介绍了Oracle19C数据库与EnterpriseManagerCloudControl13.5(EMCC)的部署和配置过程，包括下载、安装、常见组件及常用命令。涉及步骤包括创建目录、权限设置、安装操作，以及数据库启动和参数修改。此外，还提供了OMS、WebLogic控制台、BIPublisher等组件的访问地址和一些关键命令，如查看版本、状态、属性以及启动/停止操作。
Oracle 19C+13.5EMCC 部署和配置
一：Oracle 13.5EMCC下载
二：Oracle 19C+13.5EMCC部署
三：Oracle 19C+13.5EMCC常见组件
四：Oracle 19C+13.5EMCC常见命令
一：Oracle Enterprise Manager Cloud Control 13c Release 4下载
[root@cjcos emcc]# pwd
/package/emcc
[root@cjcos emcc]# ll -rth
total 12G
-rw-r--r-- 1 root root 1.6G Mar 28 21:17 em13400_linux64.bin
-rw-r--r-- 1 root root 1.8G Mar 28 21:19 em13400_linux64-7.zip
-rw-r--r-- 1 root root 771M Mar 28 21:25 em13400_linux64-5.zip
-rw-r--r-- 1 root root 2.0G Mar 28 21:32 em13400_linux64-6.zip
-rw-r--r-- 1 root root 2.0G Mar 28 21:39 em13400_linux64-4.zip
-rw-r--r-- 1 root root 2.0G Mar 28 21:46 em13400_linux64-3.zip
-rw-r--r-- 1 root root 2.0G Mar 28 21:49 em13400_linux64-2.zip
二：Oracle 19C+13.4EMCC部署
参考：
2.1 创建目录
[root@cjcos ~]# mkdir /u02/{middleware,agent} -p
[root@cjcos ~]# chown oracle.oinstall /u02 -R
[root@cjcos ~]# chown -R 775 /u02
[root@cjcos ~]# ls /u02
agent middleware
2.2 安装
[root@cjcos emcc]# chown oracle.oinstall /package/emcc -R
[root@cjcos emcc]# chmod a+x /package/emcc -R
[root@cjcos emcc]# ll -rth
total 12G
-rwxr-xr-x 1 oracle oinstall 1.6G Mar 28 21:17 em13400_linux64.bin
-rwxr-xr-x 1 oracle oinstall 1.8G Mar 28 21:19 em13400_linux64-7.zip
-rwxr-xr-x 1 oracle oinstall 771M Mar 28 21:25 em13400_linux64-5.zip
-rwxr-xr-x 1 oracle oinstall 2.0G Mar 28 21:32 em13400_linux64-6.zip
-rwxr-xr-x 1 oracle oinstall 2.0G Mar 28 21:39 em13400_linux64-4.zip
-rwxr-xr-x 1 oracle oinstall 2.0G Mar 28 21:46 em13400_linux64-3.zip
-rwxr-xr-x 1 oracle oinstall 2.0G Mar 28 21:49 em13400_linux64-2.zip
[oracle@cjcos ~]$ cd /package/emcc/
[oracle@cjcos emcc]$ ./em13400_linux64.bin
正在上传…重新上传取消
必须PDB
启动PDB 数据库
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 CJCPDB01 MOUNTED
4 CJCPDB02 MOUNTED
5 CJCPDB03 MOUNTED
6 CJCPDB04 MOUNTED
7 CJCPDB05 MOUNTED
8 CJCPDB06 MOUNTED
SQL> alter session set container=cjcpdb01;
SQL> startup
根据提示修改参数
SQL> alter system set "_allow_insert_with_update_check"=TRUE;
--- check if all adaptive features parameters are unset
Cloud Control 13.4 : Silent Installation and Silent Upgrade | The ORACLE-BASE Blog
alter system set "_optimizer_nlj_hj_adaptive_join"= FALSE scope=both ;
alter system set "_optimizer_strans_adaptive_pruning" = FALSE scope=both ;
alter system set "_px_adaptive_dist_method" = OFF scope=both ;
alter system set "_sql_plan_directive_mgmt_control" = 0 scope=both ;
alter system set "_optimizer_dsdir_usage_control" = 0 scope=both ;
alter system set "_optimizer_use_feedback" = FALSE scope=both ;
alter system set "_optimizer_gather_feedback" = FALSE scope=both ;
alter system set "_optimizer_performance_feedback" = OFF scope=both ;
Cloud Control 13.5
alter system reset "_optimizer_nlj_hj_adaptive_join" scope=both sid='*';
alter system reset "_optimizer_strans_adaptive_pruning" scope=both sid='*';
alter system reset "_px_adaptive_dist_method" scope=both sid='*';
alter system reset "_sql_plan_directive_mgmt_control" scope=both sid='*';
alter system reset "_optimizer_dsdir_usage_control" scope=both sid='*';
alter system reset "_optimizer_use_feedback" scope=both sid='*';
alter system reset "_optimizer_gather_feedback" scope=both sid='*';
alter system reset "_optimizer_performance_feedback" scope=both sid='*';
Use the following URL to access:
1. Enterprise Manager Cloud Control URL:
2. Admin Server URL:
3. BI Publisher URL:
The following details need to be provided while installing an additional OMS:
1. Admin Server Host Name: cjcos
2. Admin Server Port: 7102
三：Oracle 19C+13.4EMCC常见组件
sysman/Oracle123
weblogic 控制台地址 :
https://192.168.2.222:7102/console
weblogic/Oracle123
BI Publisher 地址 :
https://192.168.2.222:9803/xmlpserver/servlet/home
https://192.168.2.222:9851/xmlpserver/servlet/home
sysman/Oracle123
https://192.168.2.222:9851/xmlpserver/servlet/home
四：Oracle 19C+13.4EMCC常见命令
[oracle@cjcos ~]$ cd /u02/middleware/bin/
--- 查看版本
[oracle@cjcos bin]$ ./emctl getversion oms
Oracle Enterprise Manager Cloud Control 13c Release 4
Copyright (c) 1996, 2020 Oracle Corporation. All rights reserved.
Oracle Enterprise Manager Cloud Control OMS 13c Release 4
--- 查看 OMS 状态
[oracle@cjcos bin]$ ./emctl status oms
Oracle Enterprise Manager Cloud Control 13c Release 4
Copyright (c) 1996, 2020 Oracle Corporation. All rights reserved.
WebTier is Up
Oracle Management Server is Up
JVMD Engine is Up
BI Publisher Server is Up
--- 查看 OMS 详细信息
[oracle@cjcos bin]$ ./emctl status oms -details
Oracle Enterprise Manager Cloud Control 13c Release 4
Copyright (c) 1996, 2020 Oracle Corporation. All rights reserved.
Enter Enterprise Manager Root (SYSMAN) Password :
Console Server Host : cjcos
HTTP Console Port : 7788
HTTPS Console Port : 7803
HTTP Upload Port : 4889
HTTPS Upload Port : 4903
EM Instance Home : /u02/gc_inst/em/EMGC_OMS1
OMS Log Directory Location : /u02/gc_inst/em/EMGC_OMS1/sysman/log
OMS is not configured with SLB or virtual hostname
Agent Upload is locked.
OMS Console is locked.
Active CA ID: 1
Console URL:
Upload URL:
WLS Domain Information
Domain Name : GCDomain
Admin Server Host : cjcos
Admin Server HTTPS Port: 7102
Admin Server is RUNNING
Oracle Management Server Information
Managed Server Instance Name: EMGC_OMS1
Oracle Management Server Instance Host: cjcos
WebTier is Up
Oracle Management Server is Up
JVMD Engine is Up
BI Publisher Server Information
BI Publisher Managed Server Name: BIP
BI Publisher Server is Up
BI Publisher HTTP Managed Server Port : 9701
BI Publisher HTTPS Managed Server Port : 9803
BI Publisher HTTP OHS Port : 9788
BI Publisher HTTPS OHS Port : 9851
BI Publisher is locked.
BI Publisher Server named 'BIP' running at URL:
BI Publisher Server Logs: /u02/gc_inst/user_projects/domains/GCDomain/servers/BIP/logs/
BI Publisher Log : /u02/gc_inst/user_projects/domains/GCDomain/servers/BIP/logs/bipublisher/bipublisher.log
--- 查看属性
[oracle@cjcos bin]$ ./emctl list properties
Oracle Enterprise Manager Cloud Control 13c Release 4
Copyright (c) 1996, 2020 Oracle Corporation. All rights reserved.
SYSMAN password:
Property Details
Management Server : cjcos:4889_Management_Service
Module = EMOMS
JAVA_EM_ARGS=<Not Set>
JAVA_EM_MEM_ARGS=<Not Set>
JBO_LAZY_LOAD=true
......
---OMS 停启
./emctl stop oms
./emctl start oms
--- 配置文件：
[oracle@cjcos bin]$ cat /u02/gc_inst/em/EMGC_OMS1/emgc.properties
……
--- 查看agent 版本
[oracle@cjcos bin]$ cd /u02/agent/agent_13.4.0.0.0/bin/
[oracle@cjcos bin]$ ./emctl getversion agent
Oracle Enterprise Manager Cloud Control 13c Release 4
Copyright (c) 1996, 2020 Oracle Corporation. All rights reserved.
Oracle Enterprise Manager Cloud Control Agent 13c Release 4
--- 查看agent 状态
[oracle@cjcos bin]$ ./emctl status agent
Oracle Enterprise Manager Cloud Control 13c Release 4
Copyright (c) 1996, 2020 Oracle Corporation. All rights reserved.
---------------------------------------------------------------
Agent Version : 13.4.0.0.0
OMS Version : 13.4.0.0.0
Protocol Version : 12.1.0.1.0
Agent Home : /u02/agent/agent_inst
Agent Log Directory : /u02/agent/agent_inst/sysman/log
Agent Binaries : /u02/agent/agent_13.4.0.0.0
Core JAR Location : /u02/agent/agent_13.4.0.0.0/jlib
Agent Process ID : 30994
Parent Process ID : 30919
Agent URL :
Local Agent URL in NAT :
Repository URL :
Started at : 2020-03-31 05:51:48
Started by user : oracle
Operating System : Linux version 4.1.12-112.16.4.el7uek.x86_64 (amd64)
Number of Targets : 53
Last Reload : (none)
Last successful upload : 2020-03-31 08:34:22
Last attempted upload : 2020-03-31 08:34:22
Total Megabytes of XML files uploaded so far : 2.48
Number of XML files pending upload : 0
Size of XML files pending upload(MB) : 0
Available disk space on upload filesystem : 60.51%
Collection Status : Collections enabled
Heartbeat Status : Ok
Last attempted heartbeat to OMS : 2020-03-31 08:35:11
Last successful heartbeat to OMS : 2020-03-31 08:35:11
Next scheduled heartbeat to OMS : 2020-03-31 08:36:11
---------------------------------------------------------------
Agent is Running and Ready
--- 停启 agent
./emctl stop agent
./emctl start agent
--- 测试agent 和 OMS 连通性
[oracle@cjcos bin]$ ./emctl pingOMS
Oracle Enterprise Manager Cloud Control 13c Release 4
Copyright (c) 1996, 2020 Oracle Corporation. All rights reserved.
---------------------------------------------------------------
EMD pingOMS completed successfully
--- 上传agent 到服务端
[oracle@cjcos bin]$ ./emctl upload agent
Oracle Enterprise Manager Cloud Control 13c Release 4
Copyright (c) 1996, 2020 Oracle Corporation. All rights reserved.
---------------------------------------------------------------
EMD upload completed successfully
--- 停止云控制及其所有组件
执行路径：cd /u02/middleware/bin/
./emctl stop oms -all
扫一扫
1583
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
