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

用户和组需求

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

安装路径

<agent_base_directory>|_____agent_13.2.0.0.0|_____agent_inst

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

cat /etc/fstabnas.example.com:/export/share1 /u01/app/share1 nfsrw,bg,rsize=32768,wsize=32768,hard,nointr,tcp,noacl,vers=3,timeo=600 0 0

Oracle Linux 6.x系统包需求

make-3.81binutils-2.20gcc-4.4.4libaio-0.3.107glibc-common-2.12-1libstdc++-4.4.4libXtst-1.0.99 (x86_64)sysstat-9.0.4glibc-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.81binutils-2.20gcc-4.4.4libaio-0.3.107glibc-common-2.12-1.7libstdc++-4.4.4sysstat-9.0.4make-3.81binutils-2.20gcc-4.4.4libaio-0.3.107glibc-common-2.12-1.7libstdc++-4.4.4sysstat-9.0.4

Kernel Parameter Requirements for Oracle Management Service

$ cat /proc/sys/net/ipv4/ip_local_port_range32768 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.shStarting to execute allroot.sh ......... Starting to execute /u02/em13c/oms/root.sh ....../etc existCreating /etc/oragchomelist file.../u02/em13c/omsFinished product-specific root actions./etc existFinished 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 existFinished execution of  /u02/em13c/agent/agent_13.2.0.0.0/root.sh ......[root@dbaas oms]# 

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