ITPub博客

首页 > 数据库 > Oracle > Oracle 19C+13.4EMCC部署和配置

Oracle 19C+13.4EMCC部署和配置

原创 Oracle 作者:chenoracle 时间:2020-03-31 22:28:12 0 删除 编辑

Oracle 19C+13.4EMCC 部署和配置

一:Oracle EMCC13.4下载

二:Oracle 19C+13.4EMCC 部署

三:Oracle 19C+13.4EMCC 常见组件

四:Oracle 19C+13.4EMCC 常见命令


一:Oracle Enterprise Manager Cloud Control 13c Release 4下载

https://www.oracle.com/enterprise-manager/downloads/cloud-control-downloads.html

[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部署

参考: https://www.csdn.net/gather_26/MtTaQgzsMzUwOS1ibG9n.html

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

https://oracle-base.com/blog/2020/02/18/cloud-control-13-4-silent-installation-and-silent-upgrade/

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 ;

Use the following URL to access:

1. Enterprise Manager Cloud Control URL: https://cjcos:7803/em

2. Admin Server URL: https://cjcos:7102/console

3. BI Publisher URL: https://cjcos:9803/xmlpserver/servlet/home

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常见组件

https://192.168.2.222:7803/em

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: https://cjcos:7803/em

Upload URL: https://cjcos:4903/empbs/upload

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: https://cjcos:9851/xmlpserver/servlet/home

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              : https://cjcos:3872/emd/main/

Local Agent URL in NAT : https://cjcos:3872/emd/main/

Repository URL         : https://cjcos:4903/empbs/upload

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 

欢迎关注我的微信公众号"IT小Chen",共同学习,共同成长!!!

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/29785807/viewspace-2683708/,如需转载,请注明出处,否则将追究法律责任。

全部评论
Oracle 11g OCP、Oracle 11g OCM、OCMU 用户组成员,微信公众号"IT小Chen"

注册时间:2014-08-05

  • 博文量
    537
  • 访问量
    981594