Disk /dev/sdc: 53.7 GB, bytes, sectors Units = sectors of 1 * 512 = 512 bytes Sector size (logical/physical): 512 bytes / 512 by

Size: px

Start display at page:

Download "Disk /dev/sdc: 53.7 GB, bytes, sectors Units = sectors of 1 * 512 = 512 bytes Sector size (logical/physical): 512 bytes / 512 by"

夫九孟
5 years ago
Views:

1 Redhat 7.5 安装 Oracle 18c 集群前两天刚刚发布了 for linux 平台的 oracle 18c, 今天闲来无事在最新的 redhat 7.5 的平台上安装了两节点 RAC 测试环境说明两台虚拟机 (rac18c1/rac18c2) 操作系统版本 ~]$ more /etc/redhat-release Red Hat Enterprise Linux Server release 7.5 (Maipo) ~]$ uname -a Linux rac18c el7.x86_64 #1 SMP Wed Mar 21 18:14:51 EDT 2018 x86_64 x86_64 x86_64 GNU/Linux 网络信息每个机器四个网卡 ens34-37, 其中 ens34/35 绑定为 bond0 作为 public 网络, ens36/37 直接作为 private& asm 网络 bond0 ens36 ens37 rac18c / / /10 rac18c / / / rac18c rac18c rac18c1-vip rac18c2-vip rac18c-scan rac18c1-priv rac18c2-priv rac18c1-priv rac18c2-priv2 共享磁盘 Disk /dev/sdb: 21.5 GB, bytes, sectors Units = sectors of 1 * 512 = 512 bytes Sector size (logical/physical): 512 bytes / 512 bytes I/O size (minimum/optimal): 512 bytes / 512 bytes 1 / 14

2 Disk /dev/sdc: 53.7 GB, bytes, sectors Units = sectors of 1 * 512 = 512 bytes Sector size (logical/physical): 512 bytes / 512 bytes I/O size (minimum/optimal): 512 bytes / 512 bytes 分别使用存放 vote 和 mgmt/data 两个磁盘组配置信息 [root@rac18c2 system]# lscpu Architecture: x86_64 CPU op-mode(s): 32-bit, 64-bit Byte Order: Little Endian CPU(s): 4 On-line CPU(s) list: 0-3 Thread(s) per core: 1 Core(s) per socket: 2 Socket(s): 2 NUMA node(s): 1 Vendor ID: GenuineIntel CPU family: 6 Model: 94 Model name: Intel(R) Core(TM) i7-6700k 4.00GHz Stepping: 3 CPU MHz: CPU max MHz: CPU min MHz: BogoMIPS: Hypervisor vendor: VMware Virtualization type: full L1d cache: 32K L1i cache: 32K L2 cache: 256K L3 cache: 8192K NUMA node0 CPU(s): 0-3 [root@rac18c2 system]# free -m total used free shared buff/cache available Mem: Swap: / 14

3 配置主机不绑定网卡 ip 地址 vi /etc/sysconfig/network-script/ifcfg-ens34 修改 BOOTPROTO=static ONBOOT=yes 增加 IPADDR= /182 PREFIX=24 重启服务 systemctl restart network 配置网卡 bond fail_mac_over=1 ( 在虚拟机里面, 不然可能导致无法访问 ) modprobe --first-time bonding modinfo bonding [root@localhost network-scripts]# more ifcfg-bond0 DEVICE=bond0 TYPE=Bond BONDING_MASTER=yes BOOTPROTO=none DEFROUTE=yes IPV4_FAILURE_FATAL=no IPV6INIT=yes IPV6_AUTOCONF=yes IPV6_DEFROUTE=yes IPV6_FAILURE_FATAL=no NAME="bond0" IPADDR= PREFIX=24 ONBOOT=yes BONDING_OPTS="resend_igmp=1 updelay=0 use_carrier=1 miimon=100 downdelay=0 xmit_hash_policy=0 primary_reselect=0 fail_over_mac=0 arp_validate=0 mode=1 arp_interval=0 ad_select=0" PEERDNS=yes PEERROUTES=yes 3 / 14

4 IPV6_PEERDNS=yes IPV6_PEERROUTES=yes network-scripts]# more ifcfg-ens34 TYPE=Ethernet PROXY_METHOD=none BROWSER_ONLY=no BOOTPROTO=none DEFROUTE=yes IPV4_FAILURE_FATAL=no IPV6INIT=yes IPV6_AUTOCONF=yes IPV6_DEFROUTE=yes IPV6_FAILURE_FATAL=no IPV6_ADDR_GEN_MODE=stable-privacy NAME=ens34 UUID=6a06a4bd f00-a268-3ab433aad0d5 DEVICE=ens34 ONBOOT=yes MASTER=bond0 SLAVE=yes network-scripts]# more ifcfg-ens35 TYPE=Ethernet PROXY_METHOD=none BROWSER_ONLY=no BOOTPROTO=none DEFROUTE=yes IPV4_FAILURE_FATAL=no IPV6INIT=yes IPV6_AUTOCONF=yes IPV6_DEFROUTE=yes IPV6_FAILURE_FATAL=no IPV6_ADDR_GEN_MODE=stable-privacy NAME=ens35 UUID=d6d eaa-4f44-96bb-4e98ab9b3230 DEVICE=ens35 ONBOOT=yes MASTER=bond0 SLAVE=yes 4 / 14

5 修改主机名 hostnamectl --static set-hostname rac18c1 hostnamectl --static set-hostname rac18c2 本地 yum 配置 mount /dev/cdrom /media/ vi /etc/yum.repos.d/rhel7.repo [rhel-yum] name=rhel7 baseurl=file:///media enabled=1 gpgcheck=0 yum clean all yum makecache 安装包 yum install bc binutils-2*.x86_64 compat-libcap1-*.x86_64 compat-libstdc++-33*.i686 compat-libstdc++-33*.x86_64 glibc-2.*.i686 glibc-2.*.x86_64 glibc-devel-2.*.i686 glibc-devel-2.*.x86_64 ksh libaio-0.*.i686 libaio-0.*.x86_64 libaio-devel-0.*.i686 libaio-devel-0.*.x86_64 libx11-1.*.i686 libx11-1.*.x86_64 libxau-1.*.i686 libxau-1.*.x86_64 libxi-1.*.i686 libxi-1.*.x86_64 libxtst-1.*.i686 libxtst-1.*.x86_64 libgcc-4.*.i686 libgcc-4.*.x86_64 libstdc++-4.*.i686 libstdc++-4.*.x86_64 libstdc++-devel-4.*.i686 libstdc++-devel-4.*.x86_64 libxcb-1.*.i686 libxcb-1.*.x86_64 make-3.*.x86_64 nfs-utils-1.*.x86_64 net-tools-2.*.x86_64 python-2.*x86_64 python-configshell-*.noarch python-rtslib-*.noarch python-six-*.noarch smartmontools-*.x86_64 sysstat-*.x86_64 targetcli-2.*.noarch yum install tigervnc-server.x86_64 cd /u01/app/18.0.0/grid/cv/rpm CVUQDISK_GRP=oinstall; export CVUQDISK_GRP rpm -iv cvuqdisk rpm 5 / 14

yum install gcc-c++* 关于 gcc-c++ 在安装文档中说到不需要, 但是实际中 oui 检查中依旧需要, 所以建议安装防火墙 systemctl stop firewalld systemctl disable firewalld 安装图形化界面 yum group list yum -y groupinstall "Server with GUI" 创建用户和组

6 yum install gcc-c++* 关于 gcc-c++ 在安装文档中说到不需要, 但是实际中 oui 检查中依旧需要, 所以建议安装防火墙 systemctl stop firewalld systemctl disable firewalld 安装图形化界面 yum group list yum -y groupinstall "Server with GUI" 创建用户和组 groupadd -g oinstall groupadd -g dba useradd -u g oinstall -G dba oracle useradd -u g oinstall -G dba grid 创建目录 mkdir -p /u01/app/18.0.0/grid mkdir -p /u01/app/grid mkdir -p /u01/app/oracle chown -R grid:oinstall /u01 chown oracle:oinstall /u01/app/oracle chmod -R 775 /u01/ 6 / 14

7 udev 配置 vi /etc/udev/rules.d/99-oracle-asmdevices.rules KERNEL=="sd*", ENV{DEVTYPE}=="disk", SUBSYSTEM=="block", PROGRAM=="/usr/lib/udev/scsi_id -g -u -d $devnode", RESULT=="36000c29b1caa025749c9dae57ba00558", RUN+="/bin/sh -c 'mknod /dev/xifenfei-sdc b $major $minor; chown grid:dba /dev/xifenfei-sdc; chmod 0660 /dev/xifenfei-sdc'" KERNEL=="sd*", ENV{DEVTYPE}=="disk", SUBSYSTEM=="block", PROGRAM=="/usr/lib/udev/scsi_id -g -u -d $devnode", RESULT=="36000c29e0130ab405f4cfc2b3e77030c", RUN+="/bin/sh -c 'mknod /dev/xifenfei-sdb b $major $minor; chown grid:dba /dev/xifenfei-sdc; chmod 0660 /dev/xifenfei-sdb'" udevadm trigger 内核参数调整 vi /etc/sysctl.d/ 99-oracle-database-server.conf fs.file-max = kernel.sem = kernel.shmmni = 4096 kernel.shmall = kernel.shmmax = kernel.panic_on_oops = 1 net.core.rmem_default = net.core.rmem_max = net.core.wmem_default = net.core.wmem_max = net.ipv4.conf.all.rp_filter = 2 fs.aio-max-nr = net.ipv4.ip_local_port_range = sysctl -p limit 配置 oracle soft nofile oracle hard nofile / 14

8 oracle soft nproc oracle hard nproc oracle soft core unlimited oracle hard core unlimited oracle soft memlock unlimited oracle hard memlock unlimited oracle soft stack grid soft nofile grid hard nofile grid soft nproc grid hard nproc grid soft core unlimited grid hard core unlimited grid soft memlock unlimited grid hard memlock unlimited grid soft stack NOZEROCONF=yes vi /etc/sysconfig/network 增加 NOZEROCONF=yes RemoveIPC vi /etc/systemd/logind.conf RemoveIPC=no Chronyd/ntp 服务 systemctl stop chronyd systemctl disable chronyd mv /etc/chrony.conf /etc/chrony.conf_bak # /sbin/service ntpd stop # chkconfig ntpd off # mv /etc/ntp.conf /etc/ntp.conf.org # rm /var/run/ntpd.pid 8 / 14

9 停掉进程 systemctl stop avahi-daemon systemctl disable avahi-daemon 环境变量 Grid 用户 ORACLE_BASE=/u01/app/grid ORACLE_HOME=/u01/app/18.0.0/grid ORACLE_SID=+ASM1 export ORACLE_BASE export ORACLE_HOME export ORACLE_SID Oracle 用户 ORACLE_BASE=/u01/app/oracle ORACLE_HOME=/u01/app/oracle/18c/db_1 ORACLE_SID=ora18c1 export ORACLE_BASE export ORACLE_HOME export ORACLE_SID export PATH=$ORACLE_HOME/bin:PATH check 截图 grid 安装截图 1. Checks 中的两个可以忽略, 因为 oui 没有重启, 不能检测出来 9 / 14

= "8192"]" ( 文档 ID 2287806.1) 2. Packages 中关于 compat-libstdc++-33-3.2.3, 如果不使用 Oracle Text 忽略该包 (Redhat 7 的安装包中不含该包 ) Missing or Ignored package compat-libstdc++-33-3.

10 Oracle Installation Fails With "PRVG-0449 : Proper soft limit for maximum stack size was not found on node "node1" [Expected >= "10240" ; Found = "8192"]" ( 文档 ID ) 2. Packages 中关于 compat-libstdc , 如果不使用 Oracle Text 忽略该包 (Redhat 7 的安装包中不含该包 ) Missing or Ignored package compat-libstdc causes Text Issues ( 文档 ID ) 3. /dev/shm 这个是 redhat 7 启动自动挂载, 不在 /etc/fstab 中, 可以忽略或者人工编辑 fstab 文件 Linux OL7/RHEL7: PRVE-0421 : No entry exists in /etc/fstab for mounting /dev/shm ( 文档 ID ) Db 安装截图 Dbca 安装截图 10 / 14

安装完成结果有少量服务被停止 [root@rac18c2 system]# crsctl status res -t --------------------------------------------------------------------------- ----- Name Target State Server State details

11 安装完成结果有少量服务被停止 system]# crsctl status res -t Name Target State Server State details Local Resources ora.asmnet1lsnr_asm.lsnr ONLINE ONLINE rac18c1 STABLE ONLINE ONLINE rac18c2 STABLE ora.data.dg ONLINE ONLINE rac18c1 STABLE ONLINE ONLINE rac18c2 STABLE ora.listener.lsnr ONLINE ONLINE rac18c1 STABLE ONLINE ONLINE rac18c2 STABLE ora.mgmt.ghchkpt.advm OFFLINE OFFLINE rac18c1 STABLE OFFLINE OFFLINE rac18c2 STABLE ora.mgmt.dg ONLINE ONLINE rac18c1 STABLE ONLINE ONLINE rac18c2 STABLE ora.helper OFFLINE OFFLINE rac18c1 IDLE,STABLE OFFLINE OFFLINE rac18c2 IDLE,STABLE ora.mgmt.ghchkpt.acfs OFFLINE OFFLINE rac18c1 STABLE 11 / 14

12 OFFLINE OFFLINE rac18c2 STABLE ora.net1.network ONLINE ONLINE rac18c1 STABLE ONLINE ONLINE rac18c2 STABLE ora.ons ONLINE ONLINE rac18c1 STABLE ONLINE ONLINE rac18c2 STABLE ora.proxy_advm ONLINE ONLINE rac18c1 STABLE ONLINE ONLINE rac18c2 STABLE Cluster Resources ora.listener_scan1.lsnr 1 ONLINE ONLINE rac18c1 STABLE ora.mgmtlsnr 1 ONLINE ONLINE rac18c ,STABLE ora.asm 1 ONLINE ONLINE rac18c1 Started,STABLE 2 ONLINE ONLINE rac18c2 Started,STABLE 3 OFFLINE OFFLINE STABLE ora.cvu 1 ONLINE ONLINE rac18c1 STABLE ora.mgmtdb 1 ONLINE ONLINE rac18c2 Open,STABLE ora.ora18c.db 1 ONLINE ONLINE rac18c1 Open,HOME=/u01/app/o racle/18c/db_1,stabl E 2 ONLINE ONLINE rac18c2 Open,HOME=/u01/app/o racle/18c/db_1,stabl E ora.qosmserver 1 ONLINE ONLINE rac18c1 STABLE 12 / 14

13 ora.rac18c1.vip 1 ONLINE ONLINE rac18c1 STABLE ora.rac18c2.vip 1 ONLINE ONLINE rac18c2 STABLE ora.rhpserver 1 OFFLINE OFFLINE STABLE ora.scan1.vip 1 ONLINE ONLINE rac18c1 STABLE [oracle@rac18c2 ~]$ sqlplus / as sysdba SQL*Plus: Release Production on Thu Jul 26 09:03: Version Copyright (c) 1982, 2018, Oracle. All rights reserved. Connected to: Oracle Database 18c Enterprise Edition Release Production Version SQL> select banner from v$version; BANNER Oracle Database 18c Enterprise Edition Release Production 已经安装最新 psu [oracle@rac18c2 ~]$ $ORACLE_HOME/OPatch/opatch lspatches ;UPDATE 18.3 DATABASE CLIENT JDK IN ORACLE HOME TO JDK8U ;OJVM RELEASE UPDATE: ( ) ;OCW RELEASE UPDATE ( ) ;Database Release Update : ( ) [grid@rac18c2 ~]$ $ORACLE_HOME/OPatch/opatch lspatches ;UPDATE 18.3 DATABASE CLIENT JDK IN ORACLE HOME TO JDK8U ;OJVM RELEASE UPDATE: ( ) ;TOMCAT RELEASE UPDATE ( ) ;DBWLM RELEASE UPDATE ( ) ;ACFS RELEASE UPDATE ( ) 13 / 14

14 ;OCW RELEASE UPDATE ( ) ;Database Release Update : ( ) 免责申明本文的安装, 不涉及性能调整和稳定性调整, 只是基础的在最新的操作系统 (redhat 7.5) 上安装最新的 Oracle 集群和数据库 (18.3), 在实际生产中, 根据实际情况进行调整关于惜分飞网名惜分飞, 真实姓名程飞先就职过国内著名的数据库三方服务公司, 提供 Oracle 华东区域技术支持 ; 后就职于 Oracle ACS( 原厂 Oracle 售后高级服务支持团队 ) 高级咨询顾问, 提供 Oracle 客户高级售后技术支持 ; 现为 Oracle 自由顾问, 为需要 Oracle 技术支持的客户提供服务 Oracle ACE, 中国 Oracle 用户组 (ACOUG) 和上海 Oracle 用户组 (SHOUG) 核心成员擅长 Oracle 数据库各种场景异常恢复, 熟悉 Oracle 的调优, 排错, 实施等热衷于 Oracle 技术的研究与分享, 长期坚持通过技术 BLOG 分享 Oracle 知识提供 ORACLE 技术支持 1 Oracle 数据库异常恢复 2 Oracle 数据库性能优化 3 Oracle 数据库部署实施 4 Oracle 数据库迁移升级 5 Oracle 数据库架构规划 6 Oracle 数据库备份容灾 7 Oracle 数据库异常诊断 8 Oracle 其他需求技术支持具体服务请见 : 具体服务范围 14 / 14

PowerPoint 演示文稿

PowerPoint 演示文稿在 Oracle Linux 6.5 上安装 Oracle RAC 12.2.0.1 预备知识 RAC 的拓扑图 RAC 安装和配置预备知识如果你想了解更多 Oracle 的知识, 官方文档是最佳途径 https://docs.oracle.com/en/ 最近我看到了 Oracle Upgrades 专家 Mike Dietrich 的这篇博客文章 https://mikedietrichde.com/2018/07/30/clarification-support-periods-for-oracle-12-2-0-1-and-18c/