oracle DBaaS 数据库云服务实践之一EM13C安装

最新推荐文章于 2023-04-17 16:42:55 发布

原创最新推荐文章于 2023-04-17 16:42:55 发布 · 2.9k 阅读

1 ·

CC 4.0 BY-SA版权

文章标签：

#数据库 #dbaas

数据库专栏收录该内容

29 篇文章

订阅专栏

本文介绍如何在Oracle Linux 6.x环境下安装配置Oracle Enterprise Manager Cloud Control 13c，包括用户和组的创建、安装路径设置、系统包及库的需求、内核参数调整等关键步骤。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

用户和组需求

# /usr/sbin/groupadd oinstall
#/usr/sbin/useradd -g oinstall oracle
# passwd oracle
 id oracle
uid=440(oracle) gid=200(oinstall) groups=201(dba),202(oper)

安装路径

<agent_base_directory>
|_____agent_13.2.0.0.0
|_____agent_inst

如果使用NFS安装，挂载目录时参数

cat /etc/fstab
nas.example.com:/export/share1 /u01/app/
share1 nfs
rw,bg,rsize=32768,wsize=32768,hard,nointr,tc
p,noacl,vers=3,timeo=600 0 0

Oracle Linux 6.x系统包需求

make-3.81
binutils-2.20
gcc-4.4.4
libaio-0.3.107
glibc-common-2.12-1
libstdc++-4.4.4
libXtst-1.0.99 (x86_64)
sysstat-9.0.4
glibc-devel-2.12-1.7 (i686) (This is a 32-bit package)
glibc-devel-2.12-1.7 (x86_64)(This is a 64-bit package)(Applicable only for Oracle Linux6.2, which includes RH6.2 and UEK 6.2) 
glibc-2.12-1.47.0.2

Package Requirements for Oracle Management Agent

make-3.81
binutils-2.20
gcc-4.4.4
libaio-0.3.107
glibc-common-2.12-1.7
libstdc++-4.4.4
sysstat-9.0.4
make-3.81
binutils-2.20
gcc-4.4.4
libaio-0.3.107
glibc-common-2.12-1.7
libstdc++-4.4.4
sysstat-9.0.4

Kernel Parameter Requirements for Oracle Management Service

$ cat /proc/sys/net/ipv4/ip_local_port_range
32768 61000
 echo 11000 65000 > /proc/sys/net/ipv4/ip_local_port_range

 kernel.shmmax= 4294967295
/sbin/chkconfig boot.sysctl on
/sbin/sysctl -p
 /sbin/sysctl -a to confirm that the values are set correctly

Library Requirements for Oracle Management Service

Oracle Linux 6.x
 glibc-2.12

Oracle强烈建议对EM档案资料库使用AL32UTF8字符集

系统参数修改

SQL> alter system set "_allow_insert_with_update_check"=true;
System altered.
SQL> alter system set processes=600 scope=spfile;
System altered.
SQL> alter system set session_cached_cursors=500 scope=spfile;
System altered.
SQL> alter system set shared_pool_size=800m;
System altered.
SQL> alter database add logfile group 4 '/u01/oradata/dbaas/redo04.log' size 600m;
Database altered.
SQL> alter database add logfile group 5  '/u01/oradata/dbaas/redo05.log' size 600m;
Database altered.
SQL> alter database add logfile group 6'/u01/oradata/dbaas/redo06.log' size 600m;
Database altered.
alter system set  optimizer_adaptive_features=false scope=both  sid='*';

不通过网络更新补丁

这里写图片描述

[root@dbaas oms]# ./allroot.sh
Starting to execute allroot.sh ......... 
Starting to execute /u02/em13c/oms/root.sh ......
/etc exist
Creating /etc/oragchomelist file...
/u02/em13c/oms
Finished product-specific root actions.
/etc exist
Finished execution of  /u02/em13c/oms/root.sh ......
Starting to execute /u02/em13c/agent/agent_13.2.0.0.0/root.sh ......
Finished product-specific root actions.
/etc exist
Finished execution of  /u02/em13c/agent/agent_13.2.0.0.0/root.sh ......
[root@dbaas oms]#

这里写图片描述

手动启动方法
[oracle@dbaas bin]$ ./emctl start oms
Oracle Enterprise Manager Cloud Control 13c Release 2  
Copyright (c) 1996, 2016 Oracle Corporation.  All rights reserved.
Starting Oracle Management Server...
WebTier Successfully Started
Oracle Management Server Already Started
Oracle Management Server is Up
JVMD Engine is Up
Starting BI Publisher Server ...
BI Publisher Server Already Started
BI Publisher Server is Up
[oracle@dbaas bin]$