[关闭]
@clisdodo 2019-11-17T22:51:41.000000Z 字数 8172 阅读 3252

Oracle Enterprise Manager Cloud Control 13c Release 3 (13.3.0.0) 安装

OEL7.7 EMCC13 Oracle19c


AskScuti :搭建类 2级-EM EMCC 13.3 在 OEL 7.7 上的安装

你需要知道的

环境 服务端 客户端
主机名 emcc askscuti
IP 192.168.1.113 192.168.1.10
OS OEL 7.7 CentOS 8
数据库 19.3.0.0.0 19.3.0.0.0
Container Non-CDB CDB
PDB_NAME / ORDERS
ORACLE_SID emcc13 CDB19c
磁盘分区 大小 挂载目录 作用
/dev/sdb1 50G /u01 安装文档资料数据库
/dev/sdc1 100G /cloud 安装EMCC
/dev/sdd1 50G /soft 单独存放软件
/dev/sde1 20G /tmp At least 12289 MB of free space

1 操作系统安装

2 环境配置

2.1 主机名及IP

编辑 /etc/hosts 文件,添加 IP 及对应主机名

  1. echo "192.168.1.113 emcc" >> /etc/hosts

2.2 用户和组

  1. /usr/sbin/groupadd -g 54321 oinstall
  2. /usr/sbin/groupadd -g 54322 dba
  3. /usr/sbin/groupadd -g 54323 oper
  4. /usr/sbin/groupadd -g 54324 backupdba
  5. /usr/sbin/groupadd -g 54325 dgdba
  6. /usr/sbin/groupadd -g 54327 asmdba
  7. /usr/sbin/groupadd -g 54328 asmoper
  8. /usr/sbin/groupadd -g 54329 asmadmin
  9. /usr/sbin/useradd -u 54330 -g oinstall -G dba,oper,backupdba,dgdba,asmadmin oracle
  10. # passwd oracle

2.3 文件夹及权限

  1. mkdir -p /u01/app/oracle/product/19.3.0/dbhome_1
  2. mkdir -p /u01/app/oraInventory
  3. chown -R oracle:oinstall /u01
  4. chmod -R 775 /u01
  5. mkdir -p /cloud/app/oracle/product/13c/db
  6. mkdir -p /cloud/app/oracle/middleware
  7. mkdir -p /cloud/app/oracle/agent
  8. chown -R oracle:oinstall /cloud/app
  9. chmod -R 755 /cloud/app

2.4 RPM包

  1. # 本地 YUM 源配置
  2. mount /dev/cdrom /mnt
  3. mv /etc/yum.repos.d/* /tmp
  4. echo "[local_yum]" >> /etc/yum.repos.d/scuti.repo
  5. echo "name = scuti" >> /etc/yum.repos.d/scuti.repo
  6. echo "baseurl = file:///mnt/" >> /etc/yum.repos.d/scuti.repo
  7. echo "enabled = 1" >> /etc/yum.repos.d/scuti.repo
  8. echo "gpgcheck = 0" >> /etc/yum.repos.d/scuti.repo
  9. yum repolist all
  10. # 相关包
  11. yum -y install autoconf
  12. yum -y install automake
  13. yum -y install binutils
  14. yum -y install binutils-devel
  15. yum -y install bison
  16. yum -y install cpp
  17. yum -y install dos2unix
  18. yum -y install ftp
  19. yum -y install gcc
  20. yum -y install gcc-c++
  21. yum -y install lrzsz
  22. yum -y install python-devel
  23. yum -y install compat-libcap1
  24. yum -y install compat-libstdc++-33
  25. yum -y install compat-libstdc++-33.i686
  26. yum -y install glibc-*
  27. yum -y install glibc-*.i686
  28. yum -y install libXpm-*.i686
  29. yum -y install libXext
  30. yum -y install libXext.i686
  31. yum -y install libXtst
  32. yum -y install libXtst.i686
  33. yum -y install libX11
  34. yum -y install libX11.i686
  35. yum -y install libXau
  36. yum -y install libXau.i686
  37. yum -y install libxcb
  38. yum -y install libxcb.i686
  39. yum -y install libXi
  40. yum -y install libXi.i686
  41. yum -y install libstdc++.i686
  42. yum -y install libstdc++-devel
  43. yum -y install libstdc++-devel.i686
  44. yum -y install libaio
  45. yum -y install libaio.i686
  46. yum -y install libaio-devel
  47. yum -y install libaio-devel.i686
  48. yum -y install ksh
  49. yum -y install libXp
  50. yum -y install libaio-devel
  51. yum -y install numactl
  52. yum -y install numactl-devel
  53. yum -y install make -y
  54. yum -y install sysstat -y
  55. yum -y install unixODBC
  56. yum -y install unixODBC-devel
  57. yum -y install elfutils-libelf-devel
  58. yum -y install redhat-lsb-core
  59. yum -y install unzip
  60. yum install -y libXrender
  61. yum install -y libXrender-devel
  62. yum install -y nfs-utils
  63. yum install -y smartmontools

2.5 资源限制

编辑 /etc/security/limits.conf 文件,添加以下内容,内存大于8G需配置大内存页,当前内存环境大小 16G

  1. oracle soft nproc 16384
  2. oracle hard nproc 16384
  3. oracle soft nofile 16384
  4. oracle hard nofile 65536
  5. oracle soft stack 10240
  6. oracle hard stack 32768
  7. oracle hard memlock 8192000
  8. oracle soft memlock 8192000

2.6 SHELL限制

  1. echo "session required pam_limits.so" >> /etc/pam.d/login

2.7 内核参数

编辑 /etc/sysctl.conf 文件,注意 shmmaxshmall 参数,修改建议请参考阿里云12cR2内核参数章节。

  1. fs.aio-max-nr = 1048576
  2. fs.file-max = 6815744
  3. kernel.shmmax = 15461882265
  4. kernel.shmall = 3774873
  5. kernel.shmmni = 4096
  6. kernel.sem = 250 32000 100 128
  7. net.ipv4.ip_local_port_range = 9000 65500
  8. net.core.rmem_default = 262144
  9. net.core.rmem_max = 4194304
  10. net.core.wmem_default = 262144
  11. net.core.wmem_max = 1048586
  12. kernel.panic_on_oops = 1

使之生效

  1. sysctl -p

2.8 关闭防火墙

  1. systemctl status firewalld.service
  2. systemctl stop firewalld.service
  3. systemctl disable firewalld.service

2.9 关闭SELINUX

编辑 /etc/selinux/config 文件

  1. SELINUX=disabled

2.10 用户变量

  1. # 切换 oracle 用户
  2. # 编辑 .bash_profile 添加以下行
  3. PS1="[`whoami`@`hostname`:"'$PWD]$'
  4. export PS1
  5. export TMP=/tmp
  6. export LANG=en_US
  7. export TMPDIR=$TMP
  8. export ORACLE_UNQNAME=emcc13
  9. ORACLE_SID=emcc13; export ORACLE_SID
  10. ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE
  11. ORACLE_HOME=$ORACLE_BASE/product/19.3.0/dbhome_1; export ORACLE_HOME
  12. ORACLE_TERM=xterm; export ORACLE_TERM
  13. NLS_DATE_FORMAT="yyyy-mm-dd HH24:MI:SS"; export NLS_DATE_FORMAT
  14. NLS_LANG=AMERICAN_AMERICA.ZHS16GBK;export NLS_LANG
  15. PATH=.:$PATH:$HOME/.local/bin:$HOME/bin:$ORACLE_HOME/bin; export PATH
  16. THREADS_FLAG=native; export THREADS_FLAG
  17. umask=022
  18. if [ $USER = "oracle" ]; then
  19. if [ $SHELL = "/bin/ksh" ]; then
  20. ulimit -p 16384
  21. ulimit -n 65536
  22. else
  23. ulimit -u 16384 -n 65536
  24. fi
  25. umask 022
  26. fi

3 数据库安装

3.1 数据库软件安装

注意:从 oracle 18c 开始,必须把压缩文件解压到 $ORACLE_HOME 里面,点我查看官方文档

  1. su - root
  2. chown -R oracle:oinstall /soft
  3. chmod -R 775 /soft
  4. su - oracle
  5. cd $ORACLE_HOME
  6. unzip -q /soft/19c-V982063-01.zip

3.1.1 静默安装

  1. ./runInstaller -ignorePrereq -waitforcompletion -silent \
  2. -responseFile /u01/app/oracle/product/19.3.0/dbhome_1/install/response/db_install.rsp \
  3. oracle.install.option=INSTALL_DB_SWONLY \
  4. UNIX_GROUP_NAME=oinstall \
  5. INVENTORY_LOCATION=/u01/app/oraInventory \
  6. SELECTED_LANGUAGES=en,en_GB \
  7. ORACLE_HOME=/u01/app/oracle/product/19.3.0/dbhome_1 \
  8. ORACLE_BASE=/u01/app/oracle \
  9. oracle.install.db.InstallEdition=EE \
  10. oracle.install.db.OSDBA_GROUP=dba \
  11. oracle.install.db.OSOPER_GROUP=oper \
  12. oracle.install.db.OSBACKUPDBA_GROUP=backupdba \
  13. oracle.install.db.OSDGDBA_GROUP=dgdba \
  14. oracle.install.db.OSKMDBA_GROUP=dba \
  15. oracle.install.db.OSRACDBA_GROUP=dba \
  16. SECURITY_UPDATES_VIA_MYORACLESUPPORT=false \
  17. DECLINE_SECURITY_UPDATES=true
  18. # 切换 root 用户执行脚本
  19. As a root user, execute the following script(s):
  20. 1. /u01/app/oraInventory/orainstRoot.sh
  21. 2. /u01/app/oracle/product/19.3.0/dbhome_1/root.sh

3.1.2 图形化安装

image_1dp4hsj2j2019vlru54mr6mq9.png-283.6kB

image_1dp4hsu3jnvevdp1v2fr7mmotm.png-268.4kB

image_1dp4htjgj158e8hj4qq1tgk102o13.png-280.3kB

image_1dp4httut1bj24r01gpp1h1v29l1g.png-282.9kB

image_1dp4hucumou3r3f39416qc1j5i1t.png-285.3kB

image_1dp4hul3j1t6f60n1ppr1ij71a2d2a.png-297.5kB

image_1dp4hv4041tt6cecseabju1kv037.png-288.9kB

image_1dp4hveed15p5171ug1pmbq1o0m3k.png-271.1kB

image_1dp4iae4m29gi351evc18dvd1j41.png-293kB

image_1dp4ib2e61t0v1ja0eon1pip19nd4e.png-284.3kB

image_1dp4qpkg2v0pfgi2e11kopb59.png-265.6kB

image_1dp4qtkeka1a1kfm1j9d1ts6vjkm.png-313.6kB

image_1dp4r08251acv1hcn19fp1ou71fcp26.png-266.3kB

3.2 创建监听

3.2.1 静默创建

  1. netca -silent -responseFile /u01/app/oracle/product/19.3.0/dbhome_1/assistants/netca/netca.rsp

3.2.2 图形化创建

执行命令 netca

image_1dp4r8v2t13pke4j1rntd5j7oo2j.png-378.2kB

image_1dp4rai2dned18k21g0nho45nv3g.png-369.9kB

image_1dp4rauolmgm1eu81fp51efsjac3t.png-366.1kB

image_1dp4rb6jp7tr1mkcvqf1k3v1eg64a.png-370.5kB

image_1dp4rc3k7t97j4s1udg1h901vmu4n.png-359.1kB

image_1dp4rcjim1fb01ah21o92veno6054.png-360.7kB

image_1dp4rcqo1f2dskk1h1ehdnd4q5h.png-363kB

image_1dp4rd1pb1sk1juk13cqsu7k3m5u.png-379.4kB

3.3 创建数据库

3.3.1 静默创建

  1. dbca -silent -createDatabase -templateName General_Purpose.dbc \
  2. -gdbname emcc13 \
  3. -sid emcc13 \
  4. -databaseConfigType SI \
  5. -sysPassword oracle \
  6. -systemPassword oracle \
  7. -characterSet AL32UTF8 \
  8. -memoryPercentage 30

3.3.2 图形化创建

执行命令 dbca

image_1dp4rg2s112s4mjr1a9re5c143n6b.png-257.7kB

image_1dp4rgb59pls14ir1oatr1pl3u6o.png-272.3kB

image_1dp4rghe719ki1nko1acg1fsaviv75.png-283.4kB

image_1dp4rhp3a1lam1cfs1or649peoe7i.png-277.2kB

image_1dp4rhv5a14be14kb8ds3opn067v.png-280.3kB

image_1dp4ri4i21qlm2al108pkaf1bbl8c.png-266.5kB

image_1dp4rianv12g68u61a8derd11ao8p.png-269.2kB

image_1dp4rifvq1b9a30qvmgo5k1q1q96.png-267.1kB

image_1dp4riv1ifjfg401i1coojgda9j.png-286.7kB

image_1dp4rkpgrf8h4kuh5g1rpc9hra0.png-288kB

image_1dp4rl65d1cp487shch14r01r6had.png-265.8kB

image_1dp4rlfnr11e61a5j14tm1c8afataq.png-271.4kB

image_1dp4rllqks40u5asvu1cm41211b7.png-285.1kB

image_1dp4rlul366o1m90m83j861l8gbk.png-285.8kB

image_1dp4rmgvv50c682rk190e16snc1.png-292.6kB

image_1dp4rmq4s6nt1s883q940s161tce.png-274.1kB

image.png-262.2kB

4 EMCC 安装

4.1 数据库设置

  1. # 文档资料数据库参数设置
  2. alter user dbsnmp identified by oracle account unlock;
  3. alter system set shared_pool_size=800m;
  4. alter system set "_allow_insert_with_update_check"=true;
  5. alter system set session_cached_cursors=300 scope=spfile;
  6. alter system set open_cursors=350 scope=spfile;
  7. alter system set job_queue_processes=22 scope=spfile;
  8. # 更改日志组大小:添加 4/5/6
  9. select a.group#,a.status,b.member from v$log a,v$logfile b where a.group#=b.group#;
  10. alter database add logfile group 4('/u01/app/oracle/oradata/EMCC13/redo04a.log','/u01/app/oracle/oradata/EMCC13/redo04b.log') size 500M;
  11. alter database add logfile group 5('/u01/app/oracle/oradata/EMCC13/redo05a.log','/u01/app/oracle/oradata/EMCC13/redo05b.log') size 500M;
  12. alter database add logfile group 6('/u01/app/oracle/oradata/EMCC13/redo06a.log','/u01/app/oracle/oradata/EMCC13/redo06b.log') size 500M;
  13. # 将 CURRENT 切换至新日志组
  14. alter system switch logfile;
  15. # 执行完全检查点,刷缓存数据变更日志组状态为 INACTIVE
  16. alter system checkpoint;
  17. # 删除 1/2/3 日志组
  18. alter database drop logfile group 1;
  19. alter database drop logfile group 2;
  20. alter database drop logfile group 3;
  21. !rm -rf /u01/app/oracle/oradata/EMCC13/redo01.log
  22. !rm -rf /u01/app/oracle/oradata/EMCC13/redo02.log
  23. !rm -rf /u01/app/oracle/oradata/EMCC13/redo03.log

4.2 执行安装

  1. su - root
  2. chown -R oracle:oinstall /soft
  3. chmod -R 775 /soft
  4. su - oracle
  5. cd /soft
  6. ./em13300_linux64.bin

image_1dp89u8i91b6k181v12occpt7n51t.png-341.4kB

image_1dp8a36n71p621mrv13vfrok184u2a.png-281.9kB

image_1dp8a3ep21i631q381iip121ejrf2n.png-295.3kB

image_1dp8a3nt71469155u1bp167a1cgc34.png-279.2kB

image_1dp8a4f8ige616rk1n2t13p71buf3h.png-316kB

image_1dp8a53co1dgsr1nha11ui1i6j3u.png-283.8kB

image_1dp8a6bgb6fg1s2m5k41mn1g4j4b.png-283.8kB

image_1dp8a6p6067s1nd0i0c1g4e1qq34o.png-279.1kB

image_1dp8a9igtrrmlpermr1ok312pm55.png-326.5kB

image_1dp8aanai7sf1bfqr47ida7i5i.png-291.7kB

image_1dp8abubg1mi2l2ks147lb3ik5v.png-282.5kB

image_1dp8acdo8158l1po6m05rtl15ft6c.png-277.4kB

image_1dp8ai0qa1q2c31v1f7q1m9n1mgc6p.png-308kB

image_1dp8amfsv10cdom1m4h5f71asv76.png-293.8kB

image_1dp8aoqujq76e8b18cl10h4diq7j.png-320.1kB

image_1dp8aqieu1qj51bvg1g09s5i14tu80.png-322.1kB

image_1dp8ar69n1pal86s11cvcua18cf8d.png-315.8kB

image_1dp96osps1bq319bdmbrgit2kk8q.png-298.3kB

image_1dp96rap51iml1f2koij9bp14bp9k.png-321.4kB

image_1dp96seq168l16rpcai1i0112jca1.png-315.2kB

5 EMCC 配置

5.1 环境配置

5.2 服务端添加主机及推送代理

image_1dpspsvci6q811tiftbga1iq5m.png-60.1kB

image_1dpsptsrnsd6kg6eo1sb0fhf13.png-64.8kB

image_1dpspuoat1vqiq9d1hcjuk61his1g.png-97.1kB

image_1dpsq6kvu1vqod1h6aegf0159m2d.png-232.1kB

image_1dpsqj1nlh4oa4tt2lhdi1fjs2q.png-85.1kB

image_1dpsqmme61hcr10gt36jm3lihr37.png-97.7kB

image_1dpsqo1c1d07jj91eur1tgp3mq3k.png-94kB

image_1dpsqq1ltrg3unmvj5ld81o7l41.png-98.3kB

image_1dpsqtu27kd9o3rbah1eao1ll4e.png-90.9kB

image_1dpsr1ju51ksq1353105fiv31k7g58.png-88.9kB

image_1dpsr54a513tk1jg12t8ej3jnl5l.png-115kB

image_1dpsr7kgu10amnpc43tnf51une62.png-89.3kB

image_1dpsr8j3f1dkt1nkul4f1b5g1cah6f.png-99.1kB

image_1dpsrpka6v151jor10e01fv72b26s.png-112.6kB

image_1dpsrrqjc1lvm65141jeq47879.png-106.4kB

image_1dpss64vc1mjpt05t201meo49p7m.png-90.3kB

image_1dpss9tkk1ed51qtr1pep18451n6f83.png-65.3kB

image_1dpsshlot1kir13dr1256125vq0o8g.png-115.1kB

5.3 添加数据库

image_1dpssjrp91vu1dkedkihu1qk38t.png-85kB

image_1dpssl9804iq1h301r5p1ifhcos9a.png-117.2kB

image_1dpssmlaes6p1q8hc6617t11ako9n.png-80.9kB

image_1dpssnhvlu3ahi5tpl1igqmj5a4.png-109kB

image_1dpsso5namno1s3613q810oj1askah.png-79.2kB

image_1dpsst5bh1hbm17m61melpk1l25bb.png-89.6kB

image_1dpssvmr91aef2q71dt71na9112ic5.png-89.5kB

image_1dpst0pejl8u1t0bf4hdevtnaci.png-90.5kB

image_1dpst2id91g653d6titjdm13phcv.png-74.7kB

image_1dpst5acafcp10p1rp018uid9sdc.png-86.8kB

image_1dpste4smu21psdl0c196s5d7dp.png-103.6kB

image_1dpsthfpcvkv3gjo7v1ceu10k0e6.png-113kB

查看官方文档,去探索 EMCC 的强大之处 [End]

添加新批注
在作者公开此批注前,只有你和作者可见。
回复批注