一·系统环境规则
1.1网络架构
节点1 节点2 主机名 19c1 19c2 Private IP 10.10.10.141 10.10.10.142 Public IP 10.13.13.141 10.13.13.142 VIP 10.13.13.143 10.13.13.144 SCANIP 10.13.13.145/146/147 SCAN_NAME scan-19c
1.2 存储
共享磁盘 ASM磁盘 ASM磁盘组 大小 冗余 /dev/sdb /dev/asmdisk1 OCR 50G 外部 /dev/sdc /dev/asmdisk2 DATA 60G 外部
1.3 软件版本
操作系统:Oracle Linux 7.1 集群软件: Oracle Clusterware 19.3.0 数据库软件:Oracle Database Enterprise 19.3.0
二·安装环境准备
2.1修改主机名和IP地址
修改主机名
[root@localhost ~]# hostnamectl set-hostname 19c1 [root@localhost ~]# hostnamectl set-hostname 19c2
2.2修改Private IP地址
[root@19c1 ~]# cat /etc/sysconfig/network-scripts/ifcfg-ens192 HWADDR=00:50:56:A3:10:82 TYPE=Ethernet BOOTPROTO=none IPADDR=10.10.10.141 PREFIX=24 GATEWAY=10.10.10.1 DEFROUTE=yes IPV4_FAILURE_FATAL=no IPV6INIT=yes IPV6_AUTOCONF=no IPV6_DEFROUTE=yes IPV6_FAILURE_FATAL=no NAME=ens192 UUID=7d9faf7c-d74c-41da-b02e-8703dfb8ef20 DEVICE=ens192 >2.3 修改Public IP地址
[root@19c1 ~]# cat /etc/sysconfig/network-scripts/ifcfg-ens160 TYPE=Ethernet BOOTPROTO=none DEFROUTE=yes IPV4_FAILURE_FATAL=no IPV6INIT=no IPV6_AUTOCONF=yes IPV6_DEFROUTE=yes IPV6_FAILURE_FATAL=no NAME=ens160 UUID=073349c5-40bc-4a0d-b1e6-44a935689d41 DEVICE=ens160 >2.4 关闭时间同步服务
[root@19c1 ~]# systemctl stop chronyd [root@19c1 ~]# systemctl disable chronyd rm '/etc/systemd/system/multi-user.target.wants/chronyd.service' [root@19c1 ~]# mv /etc/chrony.conf /etc/chrony.conf.bak [root@19c2 ~]# systemctl stop chronyd [root@19c2 ~]# systemctl disable chronyd rm '/etc/systemd/system/multi-user.target.wants/chronyd.service' [root@19c2 ~]# mv /etc/chrony.conf /etc/chrony.conf.bak2.5关闭防火墙和SELinux
[root@19c1 ~]# systemctl stop firewalld [root@19c1 ~]# systemctl disable firewalld rm '/etc/systemd/system/dbus-org.fedoraproject.FirewallD1.service' rm '/etc/systemd/system/basic.target.wants/firewalld.service' [root@19c1 ~]# setenforce 0 [root@19c1 ~]# sed -i "/^SELINUX=/s#enforcing#disabled#" /etc/selinux/config [root@19c1 ~]# cat /etc/selinux/config # This file controls the state of SELinux on the system. # SELINUX= can take one of these three values: # enforcing - SELinux security policy is enforced. # permissive - SELinux prints warnings instead of enforcing. # disabled - No SELinux policy is loaded. SELINUX=disabled # SELINUXTYPE= can take one of three two values: # targeted - Targeted processes are protected, # minimum - Modification of targeted policy. Only selected processes are protected. # mls - Multi Level Security protection. SELINUXTYPE=targeted [root@19c2 ~]# systemctl stop chronyd [root@19c2 ~]# systemctl disable chronyd rm '/etc/systemd/system/multi-user.target.wants/chronyd.service' [root@19c2 ~]# mv /etc/chrony.conf /etc/chrony.conf.bak [root@19c2 ~]# setenforce 0 [root@19c2 ~]# sed -i "/^SELINUX=/s#enforcing#disabled#" /etc/selinux/config [root@19c2 ~]# cat /etc/selinux/config # This file controls the state of SELinux on the system. # SELINUX= can take one of these three values: # enforcing - SELinux security policy is enforced. # permissive - SELinux prints warnings instead of enforcing. # disabled - No SELinux policy is loaded. SELINUX=disabled # SELINUXTYPE= can take one of three two values: # targeted - Targeted processes are protected, # minimum - Modification of targeted policy. Only selected processes are protected. # mls - Multi Level Security protection. SELINUXTYPE=targeted2.6 配置本地YUM
[root@19c1 ~]# ls -lrt /etc/yum.repos.d/ total 4 -rw-r--r--. 1 root root 2323 Feb 16 2015 public-yum-ol7.repo [root@19c1 ~]# mv /etc/yum.repos.d/public-yum-ol7.repo /etc/yum.repos.d/public-yum-ol7.repo.bak [root@19c1 ~]# mount /dev/sr0 /mnt/ mount: /dev/sr0 is write-protected, mounting read-only [root@19c1 ~]# cat >> /etc/yum.repos.d/jy.repo < [base] > name=jy > baseurl=file:///mnt > enabled=1 > gpgcheck=0 > multilib_policy=all > EOF [root@19c1 ~]# cat /etc/yum.repos.d/jy.repo [base] name=jy baseurl=file:///mnt enabled=1 gpgcheck=0 multilib_policy=all [root@19c1 ~]# yum clean all Loaded plugins: langpacks Cleaning repos: base ol7_UEKR3 ol7_latest Cleaning up everything [root@19c1 ~]# yum makecache Loaded plugins: langpacks base | 3.6 kB 00:00:00 (1/4): base/group_gz | 134 kB 00:00:00 (2/4): base/filelists_db | 3.4 MB 00:00:00 (3/4): base/primary_db | 4.0 MB 00:00:00 (4/4): base/other_db | 1.3 MB 00:00:00 Metadata Cache Created [root@19c2 ~]# ls -lrt /etc/yum.repos.d/ total 4 -rw-r--r--. 1 root root 2323 Feb 16 2015 public-yum-ol7.repo [root@19c2 ~]# mv /etc/yum.repos.d/public-yum-ol7.repo /etc/yum.repos.d/public-yum-ol7.repo.bak [root@19c2 ~]# mount /dev/sr0 /mnt/ mount: /dev/sr0 is write-protected, mounting read-only [root@19c2 ~]# cat >> /etc/yum.repos.d/jy.repo < [base] > name=jy > baseurl=file:///mnt > enabled=1 > gpgcheck=0 > multilib_policy=all > EOF [root@19c2 ~]# cat /etc/yum.repos.d/jy.repo [base] name=jy baseurl=file:///mnt enabled=1 gpgcheck=0 multilib_policy=all [root@19c2 ~]# yum clean all Loaded plugins: langpacks Cleaning repos: base Cleaning up everything [root@19c2 ~]# yum makecache Loaded plugins: langpacks base | 3.6 kB 00:00:00 (1/4): base/group_gz | 134 kB 00:00:00 (2/4): base/filelists_db | 3.4 MB 00:00:00 (3/4): base/primary_db | 4.0 MB 00:00:00 (4/4): base/other_db | 1.3 MB 00:00:00 Metadata Cache Created2.7 禁用NTP
[root@19c1 ~]# systemctl stop ntpd.service [root@19c1 ~]# systemctl disable ntpd.service [root@19c2 ~]# systemctl stop ntpd.service [root@19c2 ~]# systemctl disable ntpd.service2.8创建用户和组
创建用户组[root@19c1 ~]# systemctl stop ntpd.service [root@19c1 ~]# systemctl disable ntpd.service [root@19c1 ~]# groupadd -g 54321 oinstall [root@19c1 ~]# groupadd -g 54322 dba [root@19c1 ~]# groupadd -g 54323 oper [root@19c1 ~]# groupadd -g 54324 backupdba [root@19c1 ~]# groupadd -g 54325 dgdba [root@19c1 ~]# groupadd -g 54326 kmdba [root@19c1 ~]# groupadd -g 54327 asmdba [root@19c1 ~]# groupadd -g 54328 asmoper [root@19c1 ~]# groupadd -g 54329 asmadmin [root@19c1 ~]# groupadd -g 54330 racdba [root@19c1 ~]# grep 543 /etc/group dba:x:54322: oper:x:54323: backupdba:x:54324: dgdba:x:54325: kmdba:x:54326: asmdba:x:54327: asmoper:x:54328: asmadmin:x:54329: racdba:x:54330: oinstall:x:54321: [root@19c2 ~]# groupadd -g 54321 oinstall [root@19c2 ~]# groupadd -g 54322 dba [root@19c2 ~]# groupadd -g 54323 oper [root@19c2 ~]# groupadd -g 54324 backupdba [root@19c2 ~]# groupadd -g 54325 dgdba [root@19c2 ~]# groupadd -g 54326 kmdba [root@19c2 ~]# groupadd -g 54327 asmdba [root@19c2 ~]# groupadd -g 54328 asmoper [root@19c2 ~]# groupadd -g 54329 asmadmin [root@19c2 ~]# groupadd -g 54330 racdba [root@19c2 ~]# grep 543 /etc/group dba:x:54322: oper:x:54323: backupdba:x:54324: dgdba:x:54325: kmdba:x:54326: asmdba:x:54327: asmoper:x:54328: asmadmin:x:54329: racdba:x:54330: oinstall:x:54321:创建用户
[root@19c1 ~]# useradd -u 54322 -g oinstall -G asmadmin,asmdba,asmoper,racdba grid [root@19c1 ~]# useradd -g oinstall -G dba,asmdba,backupdba,dgdba,kmdba,racdba,oper oracle [root@19c1 ~]# passwd grid Changing password for user grid. New password: Retype new password: passwd: all authentication tokens updated successfully. [root@19c1 ~]# passwd oracle Changing password for user oracle. New password: Retype new password: passwd: all authentication tokens updated successfully. [root@19c2 ~]# useradd -u 54322 -g oinstall -G asmadmin,asmdba,asmoper,racdba grid [root@19c2 ~]# useradd -g oinstall -G dba,asmdba,backupdba,dgdba,kmdba,racdba,oper oracle [root@19c2 ~]# passwd grid Changing password for user grid. New password: Retype new password: passwd: all authentication tokens updated successfully. [root@19c2 ~]# passwd oracle Changing password for user oracle. New password: Retype new password: passwd: all authentication tokens updated successfully. [root@19c2 ~]#2.9创建相关目录
[root@19c1 ~]# mkdir -p /u01/tmp [root@19c1 ~]# mkdir -p /u01/app/19.3/grid [root@19c1 ~]# mkdir -p /u01/app/grid [root@19c1 ~]# mkdir -p /u01/app/oracle/product/19.3/db [root@19c1 ~]# mkdir -p /u01/app/oraInventory [root@19c1 ~]# chown -R grid:oinstall /u01 [root@19c1 ~]# chown oracle:oinstall /u01/app/oracle [root@19c1 ~]# chmod -R 775 /u01/ [root@19c2 ~]# mkdir -p /u01/tmp [root@19c2 ~]# mkdir -p /u01/app/19.3/grid [root@19c2 ~]# mkdir -p /u01/app/grid [root@19c2 ~]# mkdir -p /u01/app/oracle/product/19.3/db [root@19c2 ~]# mkdir -p /u01/app/oraInventory [root@19c2 ~]# chown -R grid:oinstall /u01 [root@19c2 ~]# chown oracle:oinstall /u01/app/oracle [root@19c2 ~]# chmod -R 775 /u01/2.10 安装软件包
[root@19c1 ~]# yum install -y bc binutils compat-libcap1 compat-libstdc++ elfutils-libelf elfutils-libelf-devel fontconfig-devel glibc glibc-devel ksh libaio libaio-devel libX11 libXau libXi libXtst libXrender libXrender-devel libgcc libstdc++ libstdc++-devel libxcb make net-tools nfs-utils python python-configshell python-rtslib python-six targetcli smartmontools sysstat gcc c-c++ gcc-info gcc-locale gcc48 gcc48-info gcc48-locale gcc48-c++ Loaded plugins: langpacks Package bc-1.06.95-13.el7.x86_64 already installed and latest version Package binutils-2.23.52.0.1-30.el7.x86_64 already installed and latest version Package compat-libcap1-1.10-7.el7.x86_64 already installed and latest version No package compat-libstdc++ available. --后面要单独安装这个包 Package elfutils-libelf-0.160-1.el7.x86_64 already installed and latest version Package glibc-2.17-78.0.1.el7.x86_64 already installed and latest version Package glibc-devel-2.17-78.0.1.el7.x86_64 already installed and latest version Package libaio-0.3.109-12.el7.x86_64 already installed and latest version Package libX11-1.6.0-2.1.el7.x86_64 already installed and latest version Package libXau-1.0.8-2.1.el7.x86_64 already installed and latest version Package libXi-1.7.2-2.1.el7.x86_64 already installed and latest version Package libXtst-1.2.2-2.1.el7.x86_64 already installed and latest version Package libXrender-0.9.8-2.1.el7.x86_64 already installed and latest version Package libgcc-4.8.3-9.el7.x86_64 already installed and latest version Package libstdc++-4.8.3-9.el7.x86_64 already installed and latest version Package libstdc++-devel-4.8.3-9.el7.x86_64 already installed and latest version Package libxcb-1.9-5.el7.x86_64 already installed and latest version Package 1:make-3.82-21.el7.x86_64 already installed and latest version Package net-tools-2.0-0.17.20131004git.el7.x86_64 already installed and latest version Package 1:nfs-utils-1.3.0-0.8.el7.x86_64 already installed and latest version Package python-2.7.5-16.el7.x86_64 already installed and latest version Package 1:python-configshell-1.1.fb14-1.el7.noarch already installed and latest version Package python-rtslib-2.1.fb50-1.el7.noarch already installed and latest version Package python-six-1.3.0-4.el7.noarch already installed and latest version Package targetcli-2.1.fb37-3.el7.noarch already installed and latest version Package 1:smartmontools-6.2-4.el7.x86_64 already installed and latest version Package sysstat-10.1.5-7.el7.x86_64 already installed and latest version Package gcc-4.8.3-9.el7.x86_64 already installed and latest version No package c-c++ available. No package gcc-info available. No package gcc-locale available. No package gcc48 available. No package gcc48-info available. No package gcc48-locale available. No package gcc48-c++ available. Resolving Dependencies --> Running transaction check ---> Package elfutils-libelf-devel.x86_64 0:0.160-1.el7 will be installed ---> Package fontconfig-devel.x86_64 0:2.10.95-7.el7 will be installed --> Processing Dependency: freetype-devel >= 2.1.4 for package: fontconfig-devel-2.10.95-7.el7.x86_64 --> Processing Dependency: pkgconfig(freetype2) for package: fontconfig-devel-2.10.95-7.el7.x86_64 --> Processing Dependency: pkgconfig(expat) for package: fontconfig-devel-2.10.95-7.el7.x86_64 ---> Package ksh.x86_64 0:20120801-22.el7 will be installed ---> Package libXrender-devel.x86_64 0:0.9.8-2.1.el7 will be installed --> Processing Dependency: pkgconfig(renderproto) >= 0.9 for package: libXrender-devel-0.9.8-2.1.el7.x86_64 --> Processing Dependency: pkgconfig(xproto) for package: libXrender-devel-0.9.8-2.1.el7.x86_64 --> Processing Dependency: pkgconfig(x11) for package: libXrender-devel-0.9.8-2.1.el7.x86_64 ---> Package libaio-devel.x86_64 0:0.3.109-12.el7 will be installed --> Running transaction check ---> Package expat-devel.x86_64 0:2.1.0-8.el7 will be installed ---> Package freetype-devel.x86_64 0:2.4.11-9.el7 will be installed --> Processing Dependency: zlib-devel for package: freetype-devel-2.4.11-9.el7.x86_64 ---> Package libX11-devel.x86_64 0:1.6.0-2.1.el7 will be installed --> Processing Dependency: pkgconfig(xcb) >= 1.1.92 for package: libX11-devel-1.6.0-2.1.el7.x86_64 --> Processing Dependency: pkgconfig(xcb) for package: libX11-devel-1.6.0-2.1.el7.x86_64 ---> Package xorg-x11-proto-devel.noarch 0:7.7-8.el7.1 will be installed --> Running transaction check ---> Package libxcb-devel.x86_64 0:1.9-5.el7 will be installed --> Processing Dependency: pkgconfig(xau) >= 0.99.2 for package: libxcb-devel-1.9-5.el7.x86_64 ---> Package zlib-devel.x86_64 0:1.2.7-13.el7 will be installed --> Running transaction check ---> Package libXau-devel.x86_64 0:1.0.8-2.1.el7 will be installed --> Finished Dependency Resolution Dependencies Resolved ============================================================================================================================================================================================================================================ Package Arch Version Repository Size ============================================================================================================================================================================================================================================ Installing: elfutils-libelf-devel x86_64 0.160-1.el7 base 34 k fontconfig-devel x86_64 2.10.95-7.el7 base 127 k ksh x86_64 20120801-22.el7 base 879 k libXrender-devel x86_64 0.9.8-2.1.el7 base 16 k libaio-devel x86_64 0.3.109-12.el7 base 12 k Installing for dependencies: expat-devel x86_64 2.1.0-8.el7 base 56 k freetype-devel x86_64 2.4.11-9.el7 base 354 k libX11-devel x86_64 1.6.0-2.1.el7 base 978 k libXau-devel x86_64 1.0.8-2.1.el7 base 14 k libxcb-devel x86_64 1.9-5.el7 base 1.0 M xorg-x11-proto-devel noarch 7.7-8.el7.1 base 280 k zlib-devel x86_64 1.2.7-13.el7 base 49 k Transaction Summary ============================================================================================================================================================================================================================================ Install 5 Packages (+7 Dependent packages) Total download size: 3.7 M Installed size: 12 M Downloading packages: -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Total 13 MB/s | 3.7 MB 00:00:00 Running transaction check Running transaction test Transaction test succeeded Running transaction Installing : xorg-x11-proto-devel-7.7-8.el7.1.noarch 1/12 Installing : libXau-devel-1.0.8-2.1.el7.x86_64 2/12 Installing : libxcb-devel-1.9-5.el7.x86_64 3/12 Installing : libX11-devel-1.6.0-2.1.el7.x86_64 4/12 Installing : expat-devel-2.1.0-8.el7.x86_64 5/12 Installing : zlib-devel-1.2.7-13.el7.x86_64 6/12 Installing : freetype-devel-2.4.11-9.el7.x86_64 7/12 Installing : fontconfig-devel-2.10.95-7.el7.x86_64 8/12 Installing : libXrender-devel-0.9.8-2.1.el7.x86_64 9/12 Installing : libaio-devel-0.3.109-12.el7.x86_64 10/12 Installing : elfutils-libelf-devel-0.160-1.el7.x86_64 11/12 Installing : ksh-20120801-22.el7.x86_64 12/12 Verifying : ksh-20120801-22.el7.x86_64 1/12 Verifying : libXrender-devel-0.9.8-2.1.el7.x86_64 2/12 Verifying : zlib-devel-1.2.7-13.el7.x86_64 3/12 Verifying : libxcb-devel-1.9-5.el7.x86_64 4/12 Verifying : libX11-devel-1.6.0-2.1.el7.x86_64 5/12 Verifying : expat-devel-2.1.0-8.el7.x86_64 6/12 Verifying : xorg-x11-proto-devel-7.7-8.el7.1.noarch 7/12 Verifying : elfutils-libelf-devel-0.160-1.el7.x86_64 8/12 Verifying : libaio-devel-0.3.109-12.el7.x86_64 9/12 Verifying : fontconfig-devel-2.10.95-7.el7.x86_64 10/12 Verifying : freetype-devel-2.4.11-9.el7.x86_64 11/12 Verifying : libXau-devel-1.0.8-2.1.el7.x86_64 12/12 Installed: elfutils-libelf-devel.x86_64 0:0.160-1.el7 fontconfig-devel.x86_64 0:2.10.95-7.el7 ksh.x86_64 0:20120801-22.el7 libXrender-devel.x86_64 0:0.9.8-2.1.el7 libaio-devel.x86_64 0:0.3.109-12.el7 Dependency Installed: expat-devel.x86_64 0:2.1.0-8.el7 freetype-devel.x86_64 0:2.4.11-9.el7 libX11-devel.x86_64 0:1.6.0-2.1.el7 libXau-devel.x86_64 0:1.0.8-2.1.el7 libxcb-devel.x86_64 0:1.9-5.el7 xorg-x11-proto-devel.noarch 0:7.7-8.el7.1 zlib-devel.x86_64 0:1.2.7-13.el7 Complete!安装compat-libstdc++-33-3.2.3-72.el7.i686.rpm，因为名字带有版本信息
[root@19c1 ~]# yum install compat-libstdc++-33-3.2.3-72.el7.i686 Loaded plugins: langpacks Resolving Dependencies --> Running transaction check ---> Package compat-libstdc++-33.i686 0:3.2.3-72.el7 will be installed --> Processing Dependency: libm.so.6 for package: compat-libstdc++-33-3.2.3-72.el7.i686 --> Processing Dependency: libgcc_s.so.1(GLIBC_2.0) for package: compat-libstdc++-33-3.2.3-72.el7.i686 --> Processing Dependency: libgcc_s.so.1(GCC_3.3) for package: compat-libstdc++-33-3.2.3-72.el7.i686 --> Processing Dependency: libgcc_s.so.1(GCC_3.0) for package: compat-libstdc++-33-3.2.3-72.el7.i686 --> Processing Dependency: libgcc_s.so.1 for package: compat-libstdc++-33-3.2.3-72.el7.i686 --> Processing Dependency: libc.so.6(GLIBC_2.3) for package: compat-libstdc++-33-3.2.3-72.el7.i686 --> Running transaction check ---> Package glibc.i686 0:2.17-78.0.1.el7 will be installed --> Processing Dependency: libfreebl3.so(NSSRAWHASH_3.12.3) for package: glibc-2.17-78.0.1.el7.i686 --> Processing Dependency: libfreebl3.so for package: glibc-2.17-78.0.1.el7.i686 ---> Package libgcc.i686 0:4.8.3-9.el7 will be installed --> Running transaction check ---> Package nss-softokn-freebl.i686 0:3.16.2.3-9.el7 will be installed --> Finished Dependency Resolution Dependencies Resolved ============================================================================================================================================================================================================================================ Package Arch Version Repository Size ============================================================================================================================================================================================================================================ Installing: compat-libstdc++-33 i686 3.2.3-72.el7 base 196 k Installing for dependencies: glibc i686 2.17-78.0.1.el7 base 4.2 M libgcc i686 4.8.3-9.el7 base 99 k nss-softokn-freebl i686 3.16.2.3-9.el7 base 186 k Transaction Summary ============================================================================================================================================================================================================================================ Install 1 Package (+3 Dependent packages) Total download size: 4.6 M Installed size: 16 M Is this ok [y/d/N]: y Downloading packages: -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Total 26 MB/s | 4.6 MB 00:00:00 Running transaction check Running transaction test Transaction test succeeded Running transaction Installing : libgcc-4.8.3-9.el7.i686 1/4 Installing : nss-softokn-freebl-3.16.2.3-9.el7.i686 2/4 Installing : glibc-2.17-78.0.1.el7.i686 3/4 Installing : compat-libstdc++-33-3.2.3-72.el7.i686 4/4 Verifying : compat-libstdc++-33-3.2.3-72.el7.i686 1/4 Verifying : glibc-2.17-78.0.1.el7.i686 2/4 Verifying : libgcc-4.8.3-9.el7.i686 3/4 Verifying : nss-softokn-freebl-3.16.2.3-9.el7.i686 4/4 Installed: compat-libstdc++-33.i686 0:3.2.3-72.el7 Dependency Installed: glibc.i686 0:2.17-78.0.1.el7 libgcc.i686 0:4.8.3-9.el7 nss-softokn-freebl.i686 0:3.16.2.3-9.el7 Complete! [root@19c2 ~]# yum install -y bc binutils compat-libcap1 compat-libstdc++ elfutils-libelf elfutils-libelf-devel fontconfig-devel glibc glibc-devel ksh libaio libaio-devel libX11 libXau libXi libXtst libXrender libXrender-devel libgcc libstdc++ libstdc++-devel libxcb make net-tools nfs-utils python python-configshell python-rtslib python-six targetcli smartmontools sysstat gcc c-c++ gcc-info gcc-locale gcc48 gcc48-info gcc48-locale gcc48-c++ Loaded plugins: langpacks Package bc-1.06.95-13.el7.x86_64 already installed and latest version Package binutils-2.23.52.0.1-30.el7.x86_64 already installed and latest version Package compat-libcap1-1.10-7.el7.x86_64 already installed and latest version No package compat-libstdc++ available. --后面要单独安装这个包 Package elfutils-libelf-0.160-1.el7.x86_64 already installed and latest version Package glibc-2.17-78.0.1.el7.x86_64 already installed and latest version Package glibc-devel-2.17-78.0.1.el7.x86_64 already installed and latest version Package libaio-0.3.109-12.el7.x86_64 already installed and latest version Package libX11-1.6.0-2.1.el7.x86_64 already installed and latest version Package libXau-1.0.8-2.1.el7.x86_64 already installed and latest version Package libXi-1.7.2-2.1.el7.x86_64 already installed and latest version Package libXtst-1.2.2-2.1.el7.x86_64 already installed and latest version Package libXrender-0.9.8-2.1.el7.x86_64 already installed and latest version Package libgcc-4.8.3-9.el7.x86_64 already installed and latest version Package libstdc++-4.8.3-9.el7.x86_64 already installed and latest version Package libstdc++-devel-4.8.3-9.el7.x86_64 already installed and latest version Package libxcb-1.9-5.el7.x86_64 already installed and latest version Package 1:make-3.82-21.el7.x86_64 already installed and latest version Package net-tools-2.0-0.17.20131004git.el7.x86_64 already installed and latest version Package 1:nfs-utils-1.3.0-0.8.el7.x86_64 already installed and latest version Package python-2.7.5-16.el7.x86_64 already installed and latest version Package 1:python-configshell-1.1.fb14-1.el7.noarch already installed and latest version Package python-rtslib-2.1.fb50-1.el7.noarch already installed and latest version Package python-six-1.3.0-4.el7.noarch already installed and latest version Package targetcli-2.1.fb37-3.el7.noarch already installed and latest version Package 1:smartmontools-6.2-4.el7.x86_64 already installed and latest version Package sysstat-10.1.5-7.el7.x86_64 already installed and latest version Package gcc-4.8.3-9.el7.x86_64 already installed and latest version No package c-c++ available. No package gcc-info available. No package gcc-locale available. No package gcc48 available. No package gcc48-info available. No package gcc48-locale available. No package gcc48-c++ available. Resolving Dependencies --> Running transaction check ---> Package elfutils-libelf-devel.x86_64 0:0.160-1.el7 will be installed ---> Package fontconfig-devel.x86_64 0:2.10.95-7.el7 will be installed --> Processing Dependency: freetype-devel >= 2.1.4 for package: fontconfig-devel-2.10.95-7.el7.x86_64 --> Processing Dependency: pkgconfig(freetype2) for package: fontconfig-devel-2.10.95-7.el7.x86_64 --> Processing Dependency: pkgconfig(expat) for package: fontconfig-devel-2.10.95-7.el7.x86_64 ---> Package ksh.x86_64 0:20120801-22.el7 will be installed ---> Package libXrender-devel.x86_64 0:0.9.8-2.1.el7 will be installed --> Processing Dependency: pkgconfig(renderproto) >= 0.9 for package: libXrender-devel-0.9.8-2.1.el7.x86_64 --> Processing Dependency: pkgconfig(xproto) for package: libXrender-devel-0.9.8-2.1.el7.x86_64 --> Processing Dependency: pkgconfig(x11) for package: libXrender-devel-0.9.8-2.1.el7.x86_64 ---> Package libaio-devel.x86_64 0:0.3.109-12.el7 will be installed --> Running transaction check ---> Package expat-devel.x86_64 0:2.1.0-8.el7 will be installed ---> Package freetype-devel.x86_64 0:2.4.11-9.el7 will be installed --> Processing Dependency: zlib-devel for package: freetype-devel-2.4.11-9.el7.x86_64 ---> Package libX11-devel.x86_64 0:1.6.0-2.1.el7 will be installed --> Processing Dependency: pkgconfig(xcb) >= 1.1.92 for package: libX11-devel-1.6.0-2.1.el7.x86_64 --> Processing Dependency: pkgconfig(xcb) for package: libX11-devel-1.6.0-2.1.el7.x86_64 ---> Package xorg-x11-proto-devel.noarch 0:7.7-8.el7.1 will be installed --> Running transaction check ---> Package libxcb-devel.x86_64 0:1.9-5.el7 will be installed --> Processing Dependency: pkgconfig(xau) >= 0.99.2 for package: libxcb-devel-1.9-5.el7.x86_64 ---> Package zlib-devel.x86_64 0:1.2.7-13.el7 will be installed --> Running transaction check ---> Package libXau-devel.x86_64 0:1.0.8-2.1.el7 will be installed --> Finished Dependency Resolution Dependencies Resolved ============================================================================================================================================================================================================================================ Package Arch Version Repository Size ============================================================================================================================================================================================================================================ Installing: elfutils-libelf-devel x86_64 0.160-1.el7 base 34 k fontconfig-devel x86_64 2.10.95-7.el7 base 127 k ksh x86_64 20120801-22.el7 base 879 k libXrender-devel x86_64 0.9.8-2.1.el7 base 16 k libaio-devel x86_64 0.3.109-12.el7 base 12 k Installing for dependencies: expat-devel x86_64 2.1.0-8.el7 base 56 k freetype-devel x86_64 2.4.11-9.el7 base 354 k libX11-devel x86_64 1.6.0-2.1.el7 base 978 k libXau-devel x86_64 1.0.8-2.1.el7 base 14 k libxcb-devel x86_64 1.9-5.el7 base 1.0 M xorg-x11-proto-devel noarch 7.7-8.el7.1 base 280 k zlib-devel x86_64 1.2.7-13.el7 base 49 k Transaction Summary ============================================================================================================================================================================================================================================ Install 5 Packages (+7 Dependent packages) Total download size: 3.7 M Installed size: 12 M Downloading packages: -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Total 8.1 MB/s | 3.7 MB 00:00:00 Running transaction check Running transaction test Transaction test succeeded Running transaction Installing : xorg-x11-proto-devel-7.7-8.el7.1.noarch 1/12 Installing : libXau-devel-1.0.8-2.1.el7.x86_64 2/12 Installing : libxcb-devel-1.9-5.el7.x86_64 3/12 Installing : libX11-devel-1.6.0-2.1.el7.x86_64 4/12 Installing : expat-devel-2.1.0-8.el7.x86_64 5/12 Installing : zlib-devel-1.2.7-13.el7.x86_64 6/12 Installing : freetype-devel-2.4.11-9.el7.x86_64 7/12 Installing : fontconfig-devel-2.10.95-7.el7.x86_64 8/12 Installing : libXrender-devel-0.9.8-2.1.el7.x86_64 9/12 Installing : libaio-devel-0.3.109-12.el7.x86_64 10/12 Installing : elfutils-libelf-devel-0.160-1.el7.x86_64 11/12 Installing : ksh-20120801-22.el7.x86_64 12/12 Verifying : ksh-20120801-22.el7.x86_64 1/12 Verifying : libXrender-devel-0.9.8-2.1.el7.x86_64 2/12 Verifying : zlib-devel-1.2.7-13.el7.x86_64 3/12 Verifying : libxcb-devel-1.9-5.el7.x86_64 4/12 Verifying : libX11-devel-1.6.0-2.1.el7.x86_64 5/12 Verifying : expat-devel-2.1.0-8.el7.x86_64 6/12 Verifying : xorg-x11-proto-devel-7.7-8.el7.1.noarch 7/12 Verifying : elfutils-libelf-devel-0.160-1.el7.x86_64 8/12 Verifying : libaio-devel-0.3.109-12.el7.x86_64 9/12 Verifying : fontconfig-devel-2.10.95-7.el7.x86_64 10/12 Verifying : freetype-devel-2.4.11-9.el7.x86_64 11/12 Verifying : libXau-devel-1.0.8-2.1.el7.x86_64 12/12 Installed: elfutils-libelf-devel.x86_64 0:0.160-1.el7 fontconfig-devel.x86_64 0:2.10.95-7.el7 ksh.x86_64 0:20120801-22.el7 libXrender-devel.x86_64 0:0.9.8-2.1.el7 libaio-devel.x86_64 0:0.3.109-12.el7 Dependency Installed: expat-devel.x86_64 0:2.1.0-8.el7 freetype-devel.x86_64 0:2.4.11-9.el7 libX11-devel.x86_64 0:1.6.0-2.1.el7 libXau-devel.x86_64 0:1.0.8-2.1.el7 libxcb-devel.x86_64 0:1.9-5.el7 xorg-x11-proto-devel.noarch 0:7.7-8.el7.1 zlib-devel.x86_64 0:1.2.7-13.el7 Complete!安装compat-libstdc++-33-3.2.3-72.el7.i686.rpm，因为名字带有版本信息
[root@19c2 ~]# yum install compat-libstdc++-33-3.2.3-72.el7.i686 Loaded plugins: langpacks Resolving Dependencies --> Running transaction check ---> Package compat-libstdc++-33.i686 0:3.2.3-72.el7 will be installed --> Processing Dependency: libm.so.6 for package: compat-libstdc++-33-3.2.3-72.el7.i686 --> Processing Dependency: libgcc_s.so.1(GLIBC_2.0) for package: compat-libstdc++-33-3.2.3-72.el7.i686 --> Processing Dependency: libgcc_s.so.1(GCC_3.3) for package: compat-libstdc++-33-3.2.3-72.el7.i686 --> Processing Dependency: libgcc_s.so.1(GCC_3.0) for package: compat-libstdc++-33-3.2.3-72.el7.i686 --> Processing Dependency: libgcc_s.so.1 for package: compat-libstdc++-33-3.2.3-72.el7.i686 --> Processing Dependency: libc.so.6(GLIBC_2.3) for package: compat-libstdc++-33-3.2.3-72.el7.i686 --> Running transaction check ---> Package glibc.i686 0:2.17-78.0.1.el7 will be installed --> Processing Dependency: libfreebl3.so(NSSRAWHASH_3.12.3) for package: glibc-2.17-78.0.1.el7.i686 --> Processing Dependency: libfreebl3.so for package: glibc-2.17-78.0.1.el7.i686 ---> Package libgcc.i686 0:4.8.3-9.el7 will be installed --> Running transaction check ---> Package nss-softokn-freebl.i686 0:3.16.2.3-9.el7 will be installed --> Finished Dependency Resolution Dependencies Resolved ============================================================================================================================================================================================================================================ Package Arch Version Repository Size ============================================================================================================================================================================================================================================ Installing: compat-libstdc++-33 i686 3.2.3-72.el7 base 196 k Installing for dependencies: glibc i686 2.17-78.0.1.el7 base 4.2 M libgcc i686 4.8.3-9.el7 base 99 k nss-softokn-freebl i686 3.16.2.3-9.el7 base 186 k Transaction Summary ============================================================================================================================================================================================================================================ Install 1 Package (+3 Dependent packages) Total download size: 4.6 M Installed size: 16 M Is this ok [y/d/N]: y Downloading packages: -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Total 74 MB/s | 4.6 MB 00:00:00 Running transaction check Running transaction test Transaction test succeeded Running transaction Installing : libgcc-4.8.3-9.el7.i686 1/4 Installing : nss-softokn-freebl-3.16.2.3-9.el7.i686 2/4 Installing : glibc-2.17-78.0.1.el7.i686 3/4 Installing : compat-libstdc++-33-3.2.3-72.el7.i686 4/4 Verifying : compat-libstdc++-33-3.2.3-72.el7.i686 1/4 Verifying : glibc-2.17-78.0.1.el7.i686 2/4 Verifying : libgcc-4.8.3-9.el7.i686 3/4 Verifying : nss-softokn-freebl-3.16.2.3-9.el7.i686 4/4 Installed: compat-libstdc++-33.i686 0:3.2.3-72.el7 Dependency Installed: glibc.i686 0:2.17-78.0.1.el7 libgcc.i686 0:4.8.3-9.el7 nss-softokn-freebl.i686 0:3.16.2.3-9.el7 Complete!检查已经安装的软件包
[root@19c1 ~]# rpm -q --qf '%{NAME}-%{VERSION}-%{RELEASE} (%{ARCH})\n' bc binutils compat-libcap1 compat-libstdc++ elfutils-libelf elfutils-libelf-devel fontconfig-devel glibc glibc-devel ksh libaio libaio-devel libX11 libXau libXi libXtst libXrender libXrender-devel libgcc libstdc++ libstdc++-devel libxcb make net-tools nfs-utils python python-configshell python-rtslib python-six targetcli smartmontools sysstat bc-1.06.95-13.el7 (x86_64) binutils-2.23.52.0.1-30.el7 (x86_64) compat-libcap1-1.10-7.el7 (x86_64) package compat-libstdc++ is not installed elfutils-libelf-0.160-1.el7 (x86_64) elfutils-libelf-devel-0.160-1.el7 (x86_64) fontconfig-devel-2.10.95-7.el7 (x86_64) glibc-2.17-78.0.1.el7 (x86_64) glibc-2.17-78.0.1.el7 (i686) glibc-devel-2.17-78.0.1.el7 (x86_64) ksh-20120801-22.el7 (x86_64) libaio-0.3.109-12.el7 (x86_64) libaio-devel-0.3.109-12.el7 (x86_64) libX11-1.6.0-2.1.el7 (x86_64) libXau-1.0.8-2.1.el7 (x86_64) libXi-1.7.2-2.1.el7 (x86_64) libXtst-1.2.2-2.1.el7 (x86_64) libXrender-0.9.8-2.1.el7 (x86_64) libXrender-devel-0.9.8-2.1.el7 (x86_64) libgcc-4.8.3-9.el7 (x86_64) libgcc-4.8.3-9.el7 (i686) libstdc++-4.8.3-9.el7 (x86_64) libstdc++-devel-4.8.3-9.el7 (x86_64) libxcb-1.9-5.el7 (x86_64) make-3.82-21.el7 (x86_64) net-tools-2.0-0.17.20131004git.el7 (x86_64) nfs-utils-1.3.0-0.8.el7 (x86_64) python-2.7.5-16.el7 (x86_64) python-configshell-1.1.fb14-1.el7 (noarch) python-rtslib-2.1.fb50-1.el7 (noarch) python-six-1.3.0-4.el7 (noarch) targetcli-2.1.fb37-3.el7 (noarch) smartmontools-6.2-4.el7 (x86_64) sysstat-10.1.5-7.el7 (x86_64) [root@19c2 ~]# rpm -q --qf '%{NAME}-%{VERSION}-%{RELEASE} (%{ARCH})\n' bc binutils compat-libcap1 compat-libstdc++ elfutils-libelf elfutils-libelf-devel fontconfig-devel glibc glibc-devel ksh libaio libaio-devel libX11 libXau libXi libXtst libXrender libXrender-devel libgcc libstdc++ libstdc++-devel libxcb make net-tools nfs-utils python python-configshell python-rtslib python-six targetcli smartmontools sysstat bc-1.06.95-13.el7 (x86_64) binutils-2.23.52.0.1-30.el7 (x86_64) compat-libcap1-1.10-7.el7 (x86_64) package compat-libstdc++ is not installed elfutils-libelf-0.160-1.el7 (x86_64) elfutils-libelf-devel-0.160-1.el7 (x86_64) fontconfig-devel-2.10.95-7.el7 (x86_64) glibc-2.17-78.0.1.el7 (x86_64) glibc-2.17-78.0.1.el7 (i686) glibc-devel-2.17-78.0.1.el7 (x86_64) ksh-20120801-22.el7 (x86_64) libaio-0.3.109-12.el7 (x86_64) libaio-devel-0.3.109-12.el7 (x86_64) libX11-1.6.0-2.1.el7 (x86_64) libXau-1.0.8-2.1.el7 (x86_64) libXi-1.7.2-2.1.el7 (x86_64) libXtst-1.2.2-2.1.el7 (x86_64) libXrender-0.9.8-2.1.el7 (x86_64) libXrender-devel-0.9.8-2.1.el7 (x86_64) libgcc-4.8.3-9.el7 (x86_64) libgcc-4.8.3-9.el7 (i686) libstdc++-4.8.3-9.el7 (x86_64) libstdc++-devel-4.8.3-9.el7 (x86_64) libxcb-1.9-5.el7 (x86_64) make-3.82-21.el7 (x86_64) net-tools-2.0-0.17.20131004git.el7 (x86_64) nfs-utils-1.3.0-0.8.el7 (x86_64) python-2.7.5-16.el7 (x86_64) python-configshell-1.1.fb14-1.el7 (noarch) python-rtslib-2.1.fb50-1.el7 (noarch) python-six-1.3.0-4.el7 (noarch) targetcli-2.1.fb37-3.el7 (noarch) smartmontools-6.2-4.el7 (x86_64) sysstat-10.1.5-7.el7 (x86_64)2.11编辑hosts文件
[root@19c1 ~]# vi /etc/hosts 127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4 ::1 localhost localhost.localdomain localhost6 localhost6.localdomain6 #public-ip 10.13.13.141 19c1 10.13.13.142 19c2 #public-vip 10.13.13.143 19c1-vip 10.13.13.144 19c2-vip #prive-ip 10.10.10.141 19c1-priv 10.10.10.142 19c2-priv #scan-ip 10.13.13.145 scan-19c 10.13.13.146 scan-19c 10.13.13.147 scan-19c [root@19c2 ~]# vi /etc/hosts 127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4 ::1 localhost localhost.localdomain localhost6 localhost6.localdomain6 #public-ip 10.13.13.141 19c1 10.13.13.142 19c2 #public-vip 10.13.13.143 19c1-vip 10.13.13.144 19c2-vip #prive-ip 10.10.10.141 19c1-priv 10.10.10.142 19c2-priv #scan-ip 10.13.13.145 scan-19c 10.13.13.146 scan-19c 10.13.13.147 scan-19c2.12 修改系统内核参数
[root@19c1 ~]# cat /etc/sysconfig/network # Created by anaconda [root@19c1 ~]# cat >> /etc/sysctl.conf < kernel.shmall = 4294967296 > kernel.sem = 510 65280 510 128 > kernel.shmmni = 4096 > kernel.shmmax = 429496729500 > net.ipv4.ip_local_port_range = 9000 65500 > net.core.rmem_default = 1048576 > net.core.rmem_max = 4194304 > net.core.wmem_default = 262144 > net.core.wmem_max = 1048576 > fs.file-max = 6815744 > fs.aio-max-nr = 1048576 > vm.swappiness = 0 > vm.dirty_background_ratio = 3 > vm.dirty_ratio = 80 > vm.dirty_expire_centisecs = 500 > vm.dirty_writeback_centisecs = 100 > net.ipv4.tcp_sack = 0 > net.ipv4.tcp_timestamps = 0 > net.ipv4.conf.default.rp_filter = 0 > net.ipv4.tcp_wmem = 262144 > net.ipv4.tcp_rmem = 4194304 > EOF [root@19c2 ~]# cat /etc/sysconfig/network # Created by anaconda [root@19c2 ~]# cat >> /etc/sysctl.conf < kernel.shmall = 4294967296 > kernel.sem = 510 65280 510 128 > kernel.shmmni = 4096 > kernel.shmmax = 429496729500 > net.ipv4.ip_local_port_range = 9000 65500 > net.core.rmem_default = 1048576 > net.core.rmem_max = 4194304 > net.core.wmem_default = 262144 > net.core.wmem_max = 1048576 > fs.file-max = 6815744 > fs.aio-max-nr = 1048576 > vm.swappiness = 0 > vm.dirty_background_ratio = 3 > vm.dirty_ratio = 80 > vm.dirty_expire_centisecs = 500 > vm.dirty_writeback_centisecs = 100 > net.ipv4.tcp_sack = 0 > net.ipv4.tcp_timestamps = 0 > net.ipv4.conf.default.rp_filter = 0 > net.ipv4.tcp_wmem = 262144 > net.ipv4.tcp_rmem = 4194304 > EOF [root@19c1 ~]# sysctl -p kernel.shmall = 4294967296 kernel.sem = 510 65280 510 128 kernel.shmmni = 4096 kernel.shmmax = 429496729500 net.ipv4.ip_local_port_range = 9000 65500 net.core.rmem_default = 1048576 net.core.rmem_max = 4194304 net.core.wmem_default = 262144 net.core.wmem_max = 1048576 fs.file-max = 6815744 fs.aio-max-nr = 1048576 vm.swappiness = 0 vm.dirty_background_ratio = 3 vm.dirty_ratio = 80 vm.dirty_expire_centisecs = 500 vm.dirty_writeback_centisecs = 100 net.ipv4.tcp_sack = 0 net.ipv4.tcp_timestamps = 0 net.ipv4.conf.default.rp_filter = 0 net.ipv4.tcp_wmem = 262144 net.ipv4.tcp_rmem = 4194304 [root@19c2 ~]# sysctl -p kernel.shmall = 4294967296 kernel.sem = 510 65280 510 128 kernel.shmmni = 4096 kernel.shmmax = 429496729500 net.ipv4.ip_local_port_range = 9000 65500 net.core.rmem_default = 1048576 net.core.rmem_max = 4194304 net.core.wmem_default = 262144 net.core.wmem_max = 1048576 fs.file-max = 6815744 fs.aio-max-nr = 1048576 vm.swappiness = 0 vm.dirty_background_ratio = 3 vm.dirty_ratio = 80 vm.dirty_expire_centisecs = 500 vm.dirty_writeback_centisecs = 100 net.ipv4.tcp_sack = 0 net.ipv4.tcp_timestamps = 0 net.ipv4.conf.default.rp_filter = 0 net.ipv4.tcp_wmem = 262144 net.ipv4.tcp_rmem = 41943042.13 配置LIMITS限制参数
[root@19c1 ~]# cat >> /etc/security/limits.conf < oracle soft nproc 2047 > oracle hard nproc 16384 > oracle soft nofile 65536 > oracle hard nofile 65536 > oracle soft memlock 3145728 > oracle hard memlock 3145728 > oracle soft stack 10240 > oracle hard stack 32768 > > grid soft nproc 2047 > grid hard nproc 16384 > grid soft nofile 65536 > grid hard nofile 65536 > grid soft memlock 3145728 > grid hard memlock 3145728 > grid soft stack 10240 > grid hard stack 32768 > EOF [root@19c2 ~]# cat >> /etc/security/limits.conf < oracle soft nproc 2047 > oracle hard nproc 16384 > oracle soft nofile 65536 > oracle hard nofile 65536 > oracle soft memlock 3145728 > oracle hard memlock 3145728 > oracle soft stack 10240 > oracle hard stack 32768 > > grid soft nproc 2047 > grid hard nproc 16384 > grid soft nofile 65536 > grid hard nofile 65536 > grid soft memlock 3145728 > grid hard memlock 3145728 > grid soft stack 10240 > grid hard stack 32768 > EOF2.14配置PAM
[root@19c1 ~]# cat >> /etc/pam.d/login < session required /lib64/security/pam_limits.so > EOF [root@19c2 ~]# cat >> /etc/pam.d/login < session required /lib64/security/pam_limits.so > EOF2.15 配置系统环境变量
[root@19c1 ~]# cat >> /etc/pam.d/login < if [ \$USER = "oracle" ]; then > if [ \$SHELL = "/bin/ksh" ]; then > ulimit -p 16384 > ulimit -n 65536 > else > ulimit -u 16384 -n 65536 > fi > fi > > if [ \$USER = "grid" ]; then > if [ \$SHELL = "/bin/ksh" ]; then > ulimit -p 16384 > ulimit -n 65536 > else > ulimit -u 16384 -n 65536 > fi > fi > > EOF [root@19c2 ~]# cat >> /etc/profile < if [ \$USER = "oracle" ]; then > if [ \$SHELL = "/bin/ksh" ]; then > ulimit -p 16384 > ulimit -n 65536 > else > ulimit -u 16384 -n 65536 > fi > fi > > if [ \$USER = "grid" ]; then > if [ \$SHELL = "/bin/ksh" ]; then > ulimit -p 16384 > ulimit -n 65536 > else > ulimit -u 16384 -n 65536 > fi > fi > > EOF2.16 配置grid用户环境变量
[grid@19c1 ~]$ vi .bash_profile # .bash_profile # Get the aliases and functions if [ -f ~/.bashrc ]; then . ~/.bashrc fi # User specific environment and startup programs PATH=$PATH:$HOME/.local/bin:$HOME/bin export PATH TEMP=/u01/tmp TMPDIR=/u01/tmp export TEMP TMPDIR export LD_ASSUME_KERNEL=3.8.13 export ORACLE_BASE=/u01/app/grid export ORACLE_HOME=/u01/app/19.3/grid export ORACLE_SID=+ASM1 export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK export ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/usr/local/lib export LD_LIBRARY_PATH export PATH=$PATH:$ORACLE_HOME/bin CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib CLASSPATH=$CLASSPATH:$ORACLE_HOME/network/jlib export CLASSPATH umask=022 export PATH=$PATH:$ORACLE_HOME/rdbms/lib [grid@19c2 ~]$ vi .bash_profile # .bash_profile # Get the aliases and functions if [ -f ~/.bashrc ]; then . ~/.bashrc fi # User specific environment and startup programs PATH=$PATH:$HOME/.local/bin:$HOME/bin export PATH TEMP=/u01/tmp TMPDIR=/u01/tmp export TEMP TMPDIR export LD_ASSUME_KERNEL=3.8.13 export ORACLE_BASE=/u01/app/grid export ORACLE_HOME=/u01/app/19.3/grid export ORACLE_SID=+ASM2 export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK export ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/usr/local/lib export LD_LIBRARY_PATH export PATH=$PATH:$ORACLE_HOME/bin CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib CLASSPATH=$CLASSPATH:$ORACLE_HOME/network/jlib export CLASSPATH umask=022 export PATH=$PATH:$ORACLE_HOME/rdbms/lib2.17 配置oracle用户环境变量
[oracle@19c1 ~]$ vi .bash_profile # .bash_profile # Get the aliases and functions if [ -f ~/.bashrc ]; then . ~/.bashrc fi # User specific environment and startup programs PATH=$PATH:$HOME/.local/bin:$HOME/bin export PATH TEMP=/u01/tmp TMPDIR=/u01/tmp export TEMP TMPDIR export LD_ASSUME_KERNEL=3.8.13 export ORACLE_BASE=/u01/app/oracle export ORACLE_HOME=/u01/app/oracle/product/19.3/db export ORACLE_SID=ora19c1 export ORACLE_UNQNAME=ora19c export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK export ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/usr/local/lib export LD_LIBRARY_PATH export PATH=$PATH:$ORACLE_HOME/bin CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib CLASSPATH=$CLASSPATH:$ORACLE_HOME/network/jlib export CLASSPATH umask=022 export PATH=$PATH:$ORACLE_HOME/rdbms/lib [oracle@19c2 ~]$ vi .bash_profile # .bash_profile # Get the aliases and functions if [ -f ~/.bashrc ]; then . ~/.bashrc fi # User specific environment and startup programs PATH=$PATH:$HOME/.local/bin:$HOME/bin export PATH TEMP=/u01/tmp TMPDIR=/u01/tmp export TEMP TMPDIR export LD_ASSUME_KERNEL=3.8.13 export ORACLE_BASE=/u01/app/oracle export ORACLE_HOME=/u01/app/oracle/product/19.3/db export ORACLE_SID=ora19c2 export ORACLE_UNQNAME=ora19c export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK export ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/usr/local/lib export LD_LIBRARY_PATH export PATH=$PATH:$ORACLE_HOME/bin CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib CLASSPATH=$CLASSPATH:$ORACLE_HOME/network/jlib export CLASSPATH umask=022 export PATH=$PATH:$ORACLE_HOME/rdbms/lib2.18 配置ASM所需磁盘,编辑/etc/udev/rules.d/99-my-asmdevices.rules配置文件
[root@19c1 ~]# fdisk -l
Disk /dev/sdc: 64.4 GB, 64424509440 bytes, 125829120 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytesDisk /dev/sda: 85.9 GB, 85899345920 bytes, 167772160 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
Disk label type: dos
Disk identifier: 0x0001fbacDevice Boot Start End Blocks Id System
/dev/sda1 * 2048 1026047 512000 83 Linux
/dev/sda2 1026048 167649279 83311616 8e Linux LVMDisk /dev/sdb: 53.7 GB, 53687091200 bytes, 104857600 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytesDisk /dev/mapper/ol-root: 76.8 GB, 76843843584 bytes, 150085632 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytesDisk /dev/mapper/ol-swap: 8455 MB, 8455716864 bytes, 16515072 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[root@19c1 ~]# /usr/lib/udev/scsi_id -g -u -d /dev/sdb
36000c299fe61de641fb3c6a854adf1f7
[root@19c1 ~]# /usr/lib/udev/scsi_id -g -u -d /dev/sdc
36000c29ad3aa426c31327dac0a2b2a01[root@19c1 ~]# vi /etc/udev/rules.d/99-my-asmdevices.rules
KERNEL=="sd*[!0-9]", ENV{DEVTYPE}=="disk", SUBSYSTEM=="block", PROGRAM=="/usr/lib/udev/scsi_id -g -u -d $devnode", RESULT=="36000c299fe61de641fb3c6a854adf1f7", RUN+="/bin/sh -c 'mknod /dev/asmdisk01 b $major $minor; chown grid:asmadmin /dev/asmdisk01; chmod 0660 /dev/asmdisk01'"
KERNEL=="sd*[!0-9]", ENV{DEVTYPE}=="disk", SUBSYSTEM=="block", PROGRAM=="/usr/lib/udev/scsi_id -g -u -d $devnode", RESULT=="36000c29ad3aa426c31327dac0a2b2a01", RUN+="/bin/sh -c 'mknod /dev/asmdisk02 b $major $minor; chown grid:asmadmin /dev/asmdisk02; chmod 0660 /dev/asmdisk02'"[root@19c1 ~]# /sbin/udevadm trigger --type=devices --action=change
[root@19c1 ~]# ls -lrt /dev/asm*
brw-rw----. 1 grid asmadmin 8, 16 May 18 18:30 /dev/asmdisk01
brw-rw----. 1 grid asmadmin 8, 32 May 18 18:30 /dev/asmdisk02[root@19c2 ~]# fdisk -l
Disk /dev/sdb: 53.7 GB, 53687091200 bytes, 104857600 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytesDisk /dev/sda: 85.9 GB, 85899345920 bytes, 167772160 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
Disk label type: dos
Disk identifier: 0x0001fbacDevice Boot Start End Blocks Id System
/dev/sda1 * 2048 1026047 512000 83 Linux
/dev/sda2 1026048 167649279 83311616 8e Linux LVMDisk /dev/sdc: 64.4 GB, 64424509440 bytes, 125829120 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytesDisk /dev/mapper/ol-root: 76.8 GB, 76843843584 bytes, 150085632 sectors
Units = sectors of 1 * 512 = 512 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytesDisk /dev/mapper/ol-swap: 8455 MB, 8455716864 bytes, 16515072 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[root@19c2 ~]# /usr/lib/udev/scsi_id -g -u -d /dev/sdb
36000c299fe61de641fb3c6a854adf1f7
[root@19c2 ~]# /usr/lib/udev/scsi_id -g -u -d /dev/sdc
36000c29ad3aa426c31327dac0a2b2a01[root@19c2 ~]# vi /etc/udev/rules.d/99-my-asmdevices.rules
KERNEL=="sd*[!0-9]", ENV{DEVTYPE}=="disk", SUBSYSTEM=="block", PROGRAM=="/usr/lib/udev/scsi_id -g -u -d $devnode", RESULT=="36000c299fe61de641fb3c6a854adf1f7", RUN+="/bin/sh -c 'mknod /dev/asmdisk01 b $major $minor; chown grid:asmadmin /dev/asmdisk01; chmod 0660 /dev/asmdisk01'"
KERNEL=="sd*[!0-9]", ENV{DEVTYPE}=="disk", SUBSYSTEM=="block", PROGRAM=="/usr/lib/udev/scsi_id -g -u -d $devnode", RESULT=="36000c29ad3aa426c31327dac0a2b2a01", RUN+="/bin/sh -c 'mknod /dev/asmdisk02 b $major $minor; chown grid:asmadmin /dev/asmdisk02; chmod 0660 /dev/asmdisk02'"[root@19c2 ~]# /sbin/udevadm trigger --type=devices --action=change
[root@19c2 ~]# ls -lrt /dev/asm*
brw-rw----. 1 grid asmadmin 8, 16 May 18 18:30 /dev/asmdisk01
brw-rw----. 1 grid asmadmin 8, 32 May 18 18:30 /dev/asmdisk022.19 禁用avahi
[root@19c1 /]# systemctl stop avahi-dnsconfd
Failed to issue method call: Unit avahi-dnsconfd.service not loaded.
[root@19c1 /]# systemctl stop avahi-daemon
Warning: Stopping avahi-daemon, but it can still be activated by:
avahi-daemon.socket
[root@19c1 /]# systemctl disable avahi-dnsconfd
[root@19c1 /]# systemctl disable avahi-daemon[root@19c2 /]# systemctl stop avahi-dnsconfd
Failed to issue method call: Unit avahi-dnsconfd.service not loaded.
[root@19c2 /]# systemctl stop avahi-daemon
Warning: Stopping avahi-daemon, but it can still be activated by:
avahi-daemon.socket
[root@19c2 /]# systemctl disable avahi-dnsconfd
[root@19c2 /]# systemctl disable avahi-daemon三·安装集群软件
3.1解压grid软件[root@19c1 /]# su - grid Last login: Mon May 18 18:15:15 CST 2020 on pts/0 [grid@19c1 ~]$ cd /soft [grid@19c1 soft]$ ls -lrt total 5809468 -rw-r--r--. 1 grid oinstall 2889184573 May 16 22:08 LINUX.X64_193000_grid_home.zip -rwxr-xr-x. 1 oracle oinstall 3059705302 May 18 18:44 LINUX.X64_193000_db_home.zip [grid@19c1 soft]$ unzip -q LINUX.X64_193000_grid_home.zip -d $ORACLE_HOME3.2 安装CVU
[root@19c1 /]# export CVUQDISK_GRP=oinstall; [root@19c1 /]# rpm -ivh /u01/app/19.3/grid/cv/rpm/cvuqdisk-1.0.10-1.rpm Preparing... ################################# [100%] Updating / installing... 1:cvuqdisk-1.0.10-1 ################################# [100%]把安装包复件到节点2
[root@19c1 /]# scp /u01/app/19.3/grid/cv/rpm/cvuqdisk-1.0.10-1.rpm 19c2:~ The authenticity of host '19c2 (10.13.13.142)' can't be established. ECDSA key fingerprint is 7f:1f:9a:0f:8b:d1:e0:17:32:08:12:73:d8:1d:9c:da. Are you sure you want to continue connecting (yes/no)? yes Warning: Permanently added '19c2,10.13.13.142' (ECDSA) to the list of known hosts. root@19c2's password: cvuqdisk-1.0.10-1.rpm [root@19c2 ~]# export CVUQDISK_GRP=oinstall; [root@19c2 ~]# rpm -ivh cvuqdisk-1.0.10-1.rpm Preparing... ################################# [100%] Updating / installing... 1:cvuqdisk-1.0.10-1 ################################# [100%]3.3 配置SSH信任
给grid用户进行配置[root@19c1 /]# /u01/app/19.3/grid/oui/prov/resources/scripts/sshUserSetup.sh -user grid -hosts "19c1 19c2" -advanced exverify -confirm [root@19c1 /]# /u01/app/19.3/grid/oui/prov/resources/scripts/sshUserSetup.sh -user oracle -hosts "19c1 19c2" -advanced exverify -confirm [root@19c1 /]# su - grid Last login: Mon May 18 19:03:39 CST 2020 on pts/0 [grid@19c1 ~]$ ssh 19c2 date Mon May 18 19:07:27 CST 2020 [grid@19c1 ~]$ ssh 19c1 date Mon May 18 19:07:36 CST 2020 [grid@19c1 ~]$ exit logout [root@19c1 /]# su - oracle Last login: Mon May 18 18:17:25 CST 2020 on pts/0 [oracle@19c1 ~]$ ssh 19c2 date Mon May 18 19:07:45 CST 2020 [oracle@19c1 ~]$ ssh 19c1 date Mon May 18 19:07:51 CST 2020 [root@19c2 ~]# su - grid Last login: Mon May 18 18:16:12 CST 2020 on pts/0 [grid@19c2 ~]$ ssh 19c1 date Mon May 18 19:04:05 CST 2020 [grid@19c2 ~]$ ssh 19c2 date Mon May 18 19:08:17 CST 2020 [grid@19c2 ~]$ exit logout [root@19c2 ~]# su - oracle Last login: Mon May 18 18:19:20 CST 2020 on pts/0 [oracle@19c2 ~]$ ssh 19c1 date Mon May 18 19:08:27 CST 2020 [oracle@19c2 ~]$ ssh 19c2 date Mon May 18 19:08:31 CST 20203.4 安装前环境检查GI
[grid@19c1 ~]$ $ORACLE_HOME/runcluvfy.sh stage -pre crsinst -n "19c1,19c2" -fixup -verbose 根据提示修复检查的问题 [root@19c1 /]# /u01/tmp/CVU_19.0.0.0.0_grid/runfixup.sh All Fix-up operations were completed successfully. [root@19c2 /]# /u01/tmp/CVU_19.0.0.0.0_grid/runfixup.sh All Fix-up operations were completed successfully.3.5开始安装Grid软件
[grid@19c1 ~]$ vi grid.rsp oracle.install.responseFileVersion=/oracle/install/rspfmt_crsinstall_response_schema_v19.0.0 INVENTORY_LOCATION=/u01/app/oraInventory oracle.install.option=CRS_CONFIG ORACLE_BASE=/u01/app/grid oracle.install.asm.OSDBA=asmdba oracle.install.asm.OSOPER=asmoper oracle.install.asm.OSASM=asmadmin oracle.install.crs.config.scanType=LOCAL_SCAN oracle.install.crs.config.gpnp.scanName=scan-19c oracle.install.crs.config.gpnp.scanPort=1521 oracle.install.crs.config.ClusterConfiguration=STANDALONE oracle.install.crs.config.configureAsExtendedCluster=false oracle.install.crs.config.clusterName=ora19c-cluster oracle.install.crs.config.gpnp.configureGNS=false oracle.install.crs.config.autoConfigureClusterNodeVIP=false oracle.install.crs.config.clusterNodes=19c1:19c1-vip,19c2:19c2-vip oracle.install.crs.config.networkInterfaceList=ens192:10.10.10.0:5,ens160:10.13.13.0:1 oracle.install.crs.configureGIMR=false oracle.install.asm.configureGIMRDataDG=false oracle.install.crs.config.useIPMI=false oracle.install.asm.storageOption=ASM oracle.install.asmOnNAS.configureGIMRDataDG=false oracle.install.asm.SYSASMPassword=xxzx7817600 oracle.install.asm.diskGroup.name=OCR oracle.install.asm.diskGroup.redundancy=EXTERNAL oracle.install.asm.diskGroup.AUSize=4 oracle.install.asm.diskGroup.disks=/dev/asmdisk01 oracle.install.asm.diskGroup.diskDiscoveryString=/dev/asm* oracle.install.asm.configureAFD=false oracle.install.asm.monitorPassword=xxzx7817600 oracle.install.crs.configureRHPS=false oracle.install.crs.config.ignoreDownNodes=false oracle.install.config.managementOption=NONE oracle.install.config.omsPort=0 oracle.install.crs.rootconfig.executeRootScript=false [grid@19c1 ~]$ $ORACLE_HOME/gridSetup.sh -silent -force -noconfig -waitforcompletion -ignorePrereq -responseFile /home/grid/grid.rsp Launching Oracle Grid Infrastructure Setup Wizard... [WARNING] [INS-30011] The SYS password entered does not conform to the Oracle recommended standards. CAUSE: Oracle recommends that the password entered should be at least 8 characters in length, contain at least 1 uppercase character, 1 lower case character and 1 digit [0-9]. ACTION: Provide a password that conforms to the Oracle recommended standards. [WARNING] [INS-30011] The ASMSNMP password entered does not conform to the Oracle recommended standards. CAUSE: Oracle recommends that the password entered should be at least 8 characters in length, contain at least 1 uppercase character, 1 lower case character and 1 digit [0-9]. ACTION: Provide a password that conforms to the Oracle recommended standards. [WARNING] [INS-32047] The location (/u01/app/oraInventory) specified for the central inventory is not empty. ACTION: It is recommended to provide an empty location for the inventory. [WARNING] [INS-13013] Target environment does not meet some mandatory requirements. CAUSE: Some of the mandatory prerequisites are not met. See logs for details. /u01/tmp/GridSetupActions2020-05-18_09-17-17PM/gridSetupActions2020-05-18_09-17-17PM.log ACTION: Identify the list of failed prerequisite checks from the log: /u01/tmp/GridSetupActions2020-05-18_09-17-17PM/gridSetupActions2020-05-18_09-17-17PM.log. Then either from the log file or from installation manual find the appropriate configuration to meet the prerequisites and fix it manually. The response file for this session can be found at: /u01/app/19.3/grid/install/response/grid_2020-05-18_09-17-17PM.rsp You can find the log of this install session at: /u01/tmp/GridSetupActions2020-05-18_09-17-17PM/gridSetupActions2020-05-18_09-17-17PM.log As a root user, execute the following script(s): 1. /u01/app/oraInventory/orainstRoot.sh 2. /u01/app/19.3/grid/root.sh Execute /u01/app/oraInventory/orainstRoot.sh on the following nodes: [19c1, 19c2] Execute /u01/app/19.3/grid/root.sh on the following nodes: [19c1, 19c2] Run the script on the local node first. After successful completion, you can start the script in parallel on all other nodes. Successfully Setup Software with warning(s). As install user, execute the following command to complete the configuration. /u01/app/19.3/grid/gridSetup.sh -executeConfigTools -responseFile /home/grid/grid.rsp [-silent] Moved the install session logs to: /u01/app/oraInventory/logs/GridSetupActions2020-05-18_09-17-17PM节点一 执行root脚本
[root@19c1 ~]# /u01/app/oraInventory/orainstRoot.sh Changing permissions of /u01/app/oraInventory. Adding read,write permissions for group. Removing read,write,execute permissions for world. Changing groupname of /u01/app/oraInventory to oinstall. The execution of the script is complete. [root@19c1 ~]# /u01/app/19.3/grid/root.sh Check /u01/app/19.3/grid/install/root_19c1_2020-05-18_21-35-58-622023345.log for the output of root script节点二 执行root脚本
[root@19c2 /]# /u01/app/oraInventory/orainstRoot.sh Changing permissions of /u01/app/oraInventory. Adding read,write permissions for group. Removing read,write,execute permissions for world. Changing groupname of /u01/app/oraInventory to oinstall. The execution of the script is complete. [root@19c2 /]# /u01/app/19.3/grid/root.sh Check /u01/app/19.3/grid/install/root_19c2_2020-05-18_21-58-15-384301417.log for the output of root script[grid@19c1 ~]$ crsctl stat res -t -------------------------------------------------------------------------------- Name Target State Server State details -------------------------------------------------------------------------------- Local Resources -------------------------------------------------------------------------------- ora.LISTENER.lsnr ONLINE ONLINE 19c1 STABLE ONLINE ONLINE 19c2 STABLE ora.chad ONLINE ONLINE 19c1 STABLE ONLINE ONLINE 19c2 STABLE ora.net1.network ONLINE ONLINE 19c1 STABLE ONLINE ONLINE 19c2 STABLE ora.ons ONLINE ONLINE 19c1 STABLE ONLINE ONLINE 19c2 STABLE -------------------------------------------------------------------------------- Cluster Resources -------------------------------------------------------------------------------- ora.19c1.vip 1 ONLINE ONLINE 19c1 STABLE ora.19c2.vip 1 ONLINE ONLINE 19c2 STABLE ora.ASMNET1LSNR_ASM.lsnr(ora.asmgroup) 1 ONLINE ONLINE 19c1 STABLE 2 ONLINE ONLINE 19c2 STABLE 3 OFFLINE OFFLINE STABLE ora.LISTENER_SCAN1.lsnr 1 ONLINE ONLINE 19c2 STABLE ora.LISTENER_SCAN2.lsnr 1 ONLINE ONLINE 19c1 STABLE ora.LISTENER_SCAN3.lsnr 1 ONLINE ONLINE 19c1 STABLE ora.OCR.dg(ora.asmgroup) 1 ONLINE ONLINE 19c1 STABLE 2 ONLINE ONLINE 19c2 STABLE 3 OFFLINE OFFLINE STABLE ora.asm(ora.asmgroup) 1 ONLINE ONLINE 19c1 Started,STABLE 2 ONLINE ONLINE 19c2 Started,STABLE 3 OFFLINE OFFLINE STABLE ora.asmnet1.asmnetwork(ora.asmgroup) 1 ONLINE ONLINE 19c1 STABLE 2 ONLINE ONLINE 19c2 STABLE 3 OFFLINE OFFLINE STABLE ora.cvu 1 ONLINE ONLINE 19c1 STABLE ora.qosmserver 1 ONLINE ONLINE 19c1 STABLE ora.scan1.vip 1 ONLINE ONLINE 19c2 STABLE ora.scan2.vip 1 ONLINE ONLINE 19c1 STABLE ora.scan3.vip 1 ONLINE ONLINE 19c1 STABLE --------------------------------------------------------------------------------3.6创建ASM磁盘组
[grid@19c1 ~]$ sqlplus / as sysasm SQL*Plus: Release 19.0.0.0.0 - Production on Mon May 18 22:10:54 2020 Version 19.3.0.0.0 Copyright (c) 1982, 2019, Oracle. All rights reserved. Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.3.0.0.0 SQL> create diskgroup DATA external REDUNDANCY disk '/dev/asmdisk02' ATTRIBUTE 'au_size'='4M', 'compatible.rdbms' = '19.0', 'compatible.asm' = '19.0'; Diskgroup created.节点二执行挂载
[grid@19c2 ~]$ sqlplus / as sysasm SQL*Plus: Release 19.0.0.0.0 - Production on Mon May 18 22:13:07 2020 Version 19.3.0.0.0 Copyright (c) 1982, 2019, Oracle. All rights reserved. Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.3.0.0.0 SQL> alter diskgroup data mount; Diskgroup altered. [grid@19c1 ~]$ crsctl stat res -t -------------------------------------------------------------------------------- Name Target State Server State details -------------------------------------------------------------------------------- Local Resources -------------------------------------------------------------------------------- ora.LISTENER.lsnr ONLINE ONLINE 19c1 STABLE ONLINE ONLINE 19c2 STABLE ora.chad ONLINE ONLINE 19c1 STABLE ONLINE ONLINE 19c2 STABLE ora.net1.network ONLINE ONLINE 19c1 STABLE ONLINE ONLINE 19c2 STABLE ora.ons ONLINE ONLINE 19c1 STABLE ONLINE ONLINE 19c2 STABLE -------------------------------------------------------------------------------- Cluster Resources -------------------------------------------------------------------------------- ora.19c1.vip 1 ONLINE ONLINE 19c1 STABLE ora.19c2.vip 1 ONLINE ONLINE 19c2 STABLE ora.ASMNET1LSNR_ASM.lsnr(ora.asmgroup) 1 ONLINE ONLINE 19c1 STABLE 2 ONLINE ONLINE 19c2 STABLE 3 OFFLINE OFFLINE STABLE ora.DATA.dg(ora.asmgroup) 1 ONLINE ONLINE 19c1 STABLE 2 ONLINE ONLINE 19c2 STABLE 3 OFFLINE OFFLINE STABLE ora.LISTENER_SCAN1.lsnr 1 ONLINE ONLINE 19c2 STABLE ora.LISTENER_SCAN2.lsnr 1 ONLINE ONLINE 19c1 STABLE ora.LISTENER_SCAN3.lsnr 1 ONLINE ONLINE 19c1 STABLE ora.OCR.dg(ora.asmgroup) 1 ONLINE ONLINE 19c1 STABLE 2 ONLINE ONLINE 19c2 STABLE 3 OFFLINE OFFLINE STABLE ora.asm(ora.asmgroup) 1 ONLINE ONLINE 19c1 Started,STABLE 2 ONLINE ONLINE 19c2 Started,STABLE 3 OFFLINE OFFLINE STABLE ora.asmnet1.asmnetwork(ora.asmgroup) 1 ONLINE ONLINE 19c1 STABLE 2 ONLINE ONLINE 19c2 STABLE 3 OFFLINE OFFLINE STABLE ora.cvu 1 ONLINE ONLINE 19c1 STABLE ora.qosmserver 1 ONLINE ONLINE 19c1 STABLE ora.scan1.vip 1 ONLINE ONLINE 19c2 STABLE ora.scan2.vip 1 ONLINE ONLINE 19c1 STABLE ora.scan3.vip 1 ONLINE ONLINE 19c1 STABLE --------------------------------------------------------------------------------四·安装数据库软件
4.1 解压安装包[oracle@19c1 ~]$ cd /soft [oracle@19c1 soft]$ ls -lrt total 5809468 -rw-r--r--. 1 grid oinstall 2889184573 May 16 22:08 LINUX.X64_193000_grid_home.zip -rwxr-xr-x. 1 oracle oinstall 3059705302 May 18 18:44 LINUX.X64_193000_db_home.zip [oracle@19c1 soft]$ unzip -q LINUX.X64_193000_db_home.zip -d $ORACLE_HOME 4.2安装前检查[grid@19c1 ~]$ $ORACLE_HOME/runcluvfy.sh stage -pre dbinst -n "19c1,19c2" -fixup -verbose4.3编写响应文件
[oracle@19c1 ~]$ vi dbinstall.rsp oracle.install.responseFileVersion=/oracle/install/rspfmt_dbinstall_response_schema_v19.0.0 oracle.install.option=INSTALL_DB_SWONLY UNIX_GROUP_NAME=oinstall INVENTORY_LOCATION=/u01/app/oraInventory ORACLE_BASE=/u01/app/oracle ORACLE_HOME=/u01/app/oracle/product/19.3/db oracle.install.db.InstallEdition=EE oracle.install.db.OSDBA_GROUP=dba oracle.install.db.OSOPER_GROUP=oper oracle.install.db.OSBACKUPDBA_GROUP=backupdba oracle.install.db.OSDGDBA_GROUP=dgdba oracle.install.db.OSKMDBA_GROUP=kmdba oracle.install.db.OSRACDBA_GROUP=racdba oracle.install.db.CLUSTER_NODES=19c1,19c2 oracle.install.db.config.starterdb.type=GENERAL_PURPOSE4.4执行安装
[oracle@19c1 ~]$ $ORACLE_HOME/runInstaller -silent -force -noconfig -ignorePrereq -responseFile /home/oracle/dbinstall.rsp Launching Oracle Database Setup Wizard... [WARNING] [INS-13013] Target environment does not meet some mandatory requirements. CAUSE: Some of the mandatory prerequisites are not met. See logs for details. /u01/app/oraInventory/logs/InstallActions2020-05-18_10-55-24PM/installActions2020-05-18_10-55-24PM.log ACTION: Identify the list of failed prerequisite checks from the log: /u01/app/oraInventory/logs/InstallActions2020-05-18_10-55-24PM/installActions2020-05-18_10-55-24PM.log. Then either from the log file or from installation manual find the appropriate configuration to meet the prerequisites and fix it manually. The response file for this session can be found at: /u01/app/oracle/product/19.3/db/install/response/db_2020-05-18_10-55-24PM.rsp You can find the log of this install session at: /u01/app/oraInventory/logs/InstallActions2020-05-18_10-55-24PM/installActions2020-05-18_10-55-24PM.log As a root user, execute the following script(s): 1. /u01/app/oracle/product/19.3/db/root.sh Execute /u01/app/oracle/product/19.3/db/root.sh on the following nodes: [19c1, 19c2] Successfully Setup Software with warning(s).4.5执行root.sh脚本
[root@19c1 ~]# /u01/app/oracle/product/19.3/db/root.sh Check /u01/app/oracle/product/19.3/db/install/root_19c1_2020-05-18_23-18-15-064687854.log for the output of root script [root@19c1 ~]# cat /u01/app/oracle/product/19.3/db/install/root_19c1_2020-05-18_23-18-15-064687854.log Performing root user operation. The following environment variables are set as: ORACLE_OWNER= oracle ORACLE_HOME= /u01/app/oracle/product/19.3/db Copying dbhome to /usr/local/bin ... Copying oraenv to /usr/local/bin ... Copying coraenv to /usr/local/bin ... Entries will be added to the /etc/oratab file as needed by Database Configuration Assistant when a database is created Finished running generic part of root script. Now product-specific root actions will be performed. [root@19c2 /]# /u01/app/19.3/grid/root.sh Check /u01/app/19.3/grid/install/root_19c2_2020-05-18_21-58-15-384301417.log for the output of root script [root@19c2 /]# /u01/app/oracle/product/19.3/db/root.sh Check /u01/app/oracle/product/19.3/db/install/root_19c2_2020-05-18_23-18-22-213501815.log for the output of root script [root@19c2 /]# cat /u01/app/oracle/product/19.3/db/install/root_19c2_2020-05-18_23-18-22-213501815.log Performing root user operation. The following environment variables are set as: ORACLE_OWNER= oracle ORACLE_HOME= /u01/app/oracle/product/19.3/db Copying dbhome to /usr/local/bin ... Copying oraenv to /usr/local/bin ... Copying coraenv to /usr/local/bin ... Entries will be added to the /etc/oratab file as needed by Database Configuration Assistant when a database is created Finished running generic part of root script. Now product-specific root actions will be performed.五·创建数据库
[oracle@19c1 ~]$ vi dbca.rsp responseFileVersion=/oracle/assistants/rspfmt_dbca_response_schema_v19.0.0 templateName=General_Purpose.dbc gdbName=ora19c sid=ora19c databaseConfigType=RAC responseFile=NO_VALUE characterSet=ZHS16GBK nationalCharacterSet=AL16UTF16 sysPassword=xxzx7817600 systemPassword=xxzx7817600 createAsContainerDatabase=true numberOfPDBs=1 pdbName=ora19cpdb useLocalUndoForPDBs=TRUE pdbAdminPassword=xxzx7817600 databaseType=MULTIPURPOSE automaticMemoryManagement=false totalMemory=3072 redoLogFileSize=50 emConfiguration=NONE nodelist=19c1,19c2 storageType=ASM diskGroupName=+DATA datafileDestination=+DATA asmsnmpPassword=xxzx7817600 sampleSchema=TRUE oracle@19c1 ~]$ dbca -silent -createDatabase -responseFile /home/oracle/dbca.rsp [WARNING] [DBT-06208] The 'SYS' password entered does not conform to the Oracle recommended standards. CAUSE: a. Oracle recommends that the password entered should be at least 8 characters in length, contain at least 1 uppercase character, 1 lower case character and 1 digit [0-9]. b.The password entered is a keyword that Oracle does not recommend to be used as password ACTION: Specify a strong password. If required refer Oracle documentation for guidelines. [WARNING] [DBT-06208] The 'SYSTEM' password entered does not conform to the Oracle recommended standards. CAUSE: a. Oracle recommends that the password entered should be at least 8 characters in length, contain at least 1 uppercase character, 1 lower case character and 1 digit [0-9]. b.The password entered is a keyword that Oracle does not recommend to be used as password ACTION: Specify a strong password. If required refer Oracle documentation for guidelines. [WARNING] [DBT-06208] The 'PDBADMIN' password entered does not conform to the Oracle recommended standards. CAUSE: a. Oracle recommends that the password entered should be at least 8 characters in length, contain at least 1 uppercase character, 1 lower case character and 1 digit [0-9]. b.The password entered is a keyword that Oracle does not recommend to be used as password ACTION: Specify a strong password. If required refer Oracle documentation for guidelines. [FATAL] [DBT-09101] Target environment does not meet some mandatory requirements. CAUSE: Some of the mandatory prerequisites are not met. See logs for details. /u01/app/oracle/cfgtoollogs/dbca/trace.log_2020-05-19_12-01-31AM ACTION: Find the appropriate configuration from the log file or from the installation guide to meet the prerequisites and fix this manually.查看错误日志可以看到因为操作系统内核版本过低等原因检查没有通过
INFO: May 19, 2020 12:09:27 AM oracle.install.commons.base.prereq.PrereqCheckerJob logTaskOverallResult INFO: OS Kernel Version: This is a prerequisite condition to test whether the system kernel version is at least "4.1.12". INFO: May 19, 2020 12:09:27 AM oracle.install.commons.base.prereq.PrereqCheckerJob logTaskOverallResult INFO: Severity:CRITICAL INFO: May 19, 2020 12:09:27 AM oracle.install.commons.base.prereq.PrereqCheckerJob logTaskOverallResult INFO: OverallStatus:VERIFICATION_FAILED INFO: May 19, 2020 12:09:27 AM oracle.install.commons.base.prereq.PrereqCheckerJob logTaskOverallResult INFO: ********************************************* INFO: May 19, 2020 12:09:27 AM oracle.install.commons.base.prereq.PrereqCheckerJob logTaskOverallResult INFO: Package: kmod-20-21 (x86_64): This is a prerequisite condition to test whether the package "kmod-20-21 (x86_64)" is available on the system. INFO: May 19, 2020 12:09:27 AM oracle.install.commons.base.prereq.PrereqCheckerJob logTaskOverallResult INFO: Severity:IGNORABLE INFO: May 19, 2020 12:09:27 AM oracle.install.commons.base.prereq.PrereqCheckerJob logTaskOverallResult INFO: OverallStatus:VERIFICATION_FAILED INFO: May 19, 2020 12:09:27 AM oracle.install.commons.base.prereq.PrereqCheckerJob logTaskOverallResult INFO: ********************************************* INFO: May 19, 2020 12:09:27 AM oracle.install.commons.base.prereq.PrereqCheckerJob logTaskOverallResult INFO: Package: kmod-libs-20-21 (x86_64): This is a prerequisite condition to test whether the package "kmod-libs-20-21 (x86_64)" is available on the system. INFO: May 19, 2020 12:09:27 AM oracle.install.commons.base.prereq.PrereqCheckerJob logTaskOverallResult INFO: Severity:IGNORABLE INFO: May 19, 2020 12:09:27 AM oracle.install.commons.base.prereq.PrereqCheckerJob logTaskOverallResult INFO: OverallStatus:VERIFICATION_FAILED INFO: May 19, 2020 12:09:27 AM oracle.install.commons.base.prereq.PrereqCheckerJob logTaskOverallResult INFO: ********************************************* INFO: May 19, 2020 12:09:27 AM oracle.install.commons.base.prereq.PrereqCheckerJob logTaskOverallResult INFO: Single Client Access Name (SCAN): This test verifies the Single Client Access Name configuration. INFO: May 19, 2020 12:09:27 AM oracle.install.commons.base.prereq.PrereqCheckerJob logTaskOverallResult INFO: Severity:CRITICAL INFO: May 19, 2020 12:09:27 AM oracle.install.commons.base.prereq.PrereqCheckerJob logTaskOverallResult INFO: OverallStatus:VERIFICATION_FAILED INFO: May 19, 2020 12:09:27 AM oracle.install.commons.base.prereq.PrereqCheckerJob logTaskOverallResult INFO: ********************************************* INFO: May 19, 2020 12:09:27 AM oracle.install.commons.base.prereq.PrereqCheckerJob logTaskOverallResult INFO: DNS/NIS name service 'scan-19c': This test verifies that the Name Service lookups for the Distributed Name Server (DNS) and the Network Information Service (NIS) match for the SCAN name entries. INFO: May 19, 2020 12:09:27 AM oracle.install.commons.base.prereq.PrereqCheckerJob logTaskOverallResult INFO: Severity:CRITICAL INFO: May 19, 2020 12:09:27 AM oracle.install.commons.base.prereq.PrereqCheckerJob logTaskOverallResult INFO: OverallStatus:VERIFICATION_FAILED使用-ignorePreReqs忽略警告和错误再次执行
[oracle@19c1 ~]$ dbca -ignorePreReqs -silent -createDatabase -responseFile /home/oracle/dbca.rsp [WARNING] [DBT-06208] The 'SYS' password entered does not conform to the Oracle recommended standards. CAUSE: a. Oracle recommends that the password entered should be at least 8 characters in length, contain at least 1 uppercase character, 1 lower case character and 1 digit [0-9]. b.The password entered is a keyword that Oracle does not recommend to be used as password ACTION: Specify a strong password. If required refer Oracle documentation for guidelines. [WARNING] [DBT-06208] The 'SYSTEM' password entered does not conform to the Oracle recommended standards. CAUSE: a. Oracle recommends that the password entered should be at least 8 characters in length, contain at least 1 uppercase character, 1 lower case character and 1 digit [0-9]. b.The password entered is a keyword that Oracle does not recommend to be used as password ACTION: Specify a strong password. If required refer Oracle documentation for guidelines. [WARNING] [DBT-06208] The 'PDBADMIN' password entered does not conform to the Oracle recommended standards. CAUSE: a. Oracle recommends that the password entered should be at least 8 characters in length, contain at least 1 uppercase character, 1 lower case character and 1 digit [0-9]. b.The password entered is a keyword that Oracle does not recommend to be used as password ACTION: Specify a strong password. If required refer Oracle documentation for guidelines. Prepare for db operation 7% complete Copying database files 27% complete Creating and starting Oracle instance 28% complete 31% complete 35% complete 37% complete 40% complete Creating cluster database views 41% complete 53% complete Completing Database Creation 57% complete 59% complete 60% complete Creating Pluggable Databases 64% complete 80% complete Executing Post Configuration Actions 100% complete Database creation complete. For details check the logfiles at: /u01/app/oracle/cfgtoollogs/dbca/ora19c. Database Information: Global Database Name:ora19c System Identifier(SID) Prefix:ora19c Look at the log file "/u01/app/oracle/cfgtoollogs/dbca/ora19c/ora19c0.log" for further details. [grid@19c2 ~]$ crsctl stat res -t -------------------------------------------------------------------------------- Name Target State Server State details -------------------------------------------------------------------------------- Local Resources -------------------------------------------------------------------------------- ora.LISTENER.lsnr ONLINE ONLINE 19c1 STABLE ONLINE ONLINE 19c2 STABLE ora.chad ONLINE ONLINE 19c1 STABLE ONLINE ONLINE 19c2 STABLE ora.net1.network ONLINE ONLINE 19c1 STABLE ONLINE ONLINE 19c2 STABLE ora.ons ONLINE ONLINE 19c1 STABLE ONLINE ONLINE 19c2 STABLE -------------------------------------------------------------------------------- Cluster Resources -------------------------------------------------------------------------------- ora.19c1.vip 1 ONLINE ONLINE 19c1 STABLE ora.19c2.vip 1 ONLINE ONLINE 19c2 STABLE ora.ASMNET1LSNR_ASM.lsnr(ora.asmgroup) 1 ONLINE ONLINE 19c1 STABLE 2 ONLINE ONLINE 19c2 STABLE 3 OFFLINE OFFLINE STABLE ora.DATA.dg(ora.asmgroup) 1 ONLINE ONLINE 19c1 STABLE 2 ONLINE ONLINE 19c2 STABLE 3 OFFLINE OFFLINE STABLE ora.LISTENER_SCAN1.lsnr 1 ONLINE ONLINE 19c2 STABLE ora.LISTENER_SCAN2.lsnr 1 ONLINE ONLINE 19c1 STABLE ora.LISTENER_SCAN3.lsnr 1 ONLINE ONLINE 19c1 STABLE ora.OCR.dg(ora.asmgroup) 1 ONLINE ONLINE 19c1 STABLE 2 ONLINE ONLINE 19c2 STABLE 3 OFFLINE OFFLINE STABLE ora.asm(ora.asmgroup) 1 ONLINE ONLINE 19c1 Started,STABLE 2 ONLINE ONLINE 19c2 Started,STABLE 3 OFFLINE OFFLINE STABLE ora.asmnet1.asmnetwork(ora.asmgroup) 1 ONLINE ONLINE 19c1 STABLE 2 ONLINE ONLINE 19c2 STABLE 3 OFFLINE OFFLINE STABLE ora.cvu 1 ONLINE ONLINE 19c1 STABLE ora.ora19c.db 1 ONLINE ONLINE 19c1 Open,HOME=/u01/app/o racle/product/19.3/d b,STABLE 2 ONLINE ONLINE 19c2 Open,HOME=/u01/app/o racle/product/19.3/d b,STABLE ora.qosmserver 1 ONLINE ONLINE 19c1 STABLE ora.scan1.vip 1 ONLINE ONLINE 19c2 STABLE ora.scan2.vip 1 ONLINE ONLINE 19c1 STABLE ora.scan3.vip 1 ONLINE ONLINE 19c1 STABLE --------------------------------------------------------------------------------测试连接
[oracle@19c2 ~]$ sqlplus / as sysdba SQL*Plus: Release 19.0.0.0.0 - Production on Tue May 19 02:12:46 2020 Version 19.3.0.0.0 Copyright (c) 1982, 2019, Oracle. All rights reserved. Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.3.0.0.0 SQL> select * from v$version; BANNER BANNER_FULL BANNER_LEGACY CON_ID ------------------------------------------------------------ ------------------------------------------------------------ -------------------------------------------------- ---------- Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Oracle Database 19c Enterprise Edition Release 19. 0 Production Production 0.0.0.0 - Production SQL> show pdbs; CON_ID CON_NAME OPEN MODE RESTRICTED ---------- ------------------------------ ---------- ---------- 2 PDB$SEED READ ONLY NO 3 ORA19CPDB READ WRITE NO到此安装就完了.
免责声明：本站发布的内容（图片、视频和文字）以原创、转载和分享为主，文章观点不代表本网站立场，如果涉及侵权请联系站长邮箱：is@yisu.com进行举报，并提供相关证据，一经查实，将立刻删除涉嫌侵权内容。
