一、用户创建
[root@localhost ~]# /usr/sbin/groupadd -g 60001 oinstall [root@localhost ~]# /usr/sbin/groupadd -g 60002 dba [root@localhost ~]# /usr/sbin/groupadd -g 60003 oper [root@localhost ~]# /usr/sbin/groupadd -g 60004 backupdba [root@localhost ~]# /usr/sbin/groupadd -g 60005 dgdba [root@localhost ~]# /usr/sbin/groupadd -g 60006 kmdba [root@localhost ~]# /usr/sbin/groupadd -g 60007 asmdba [root@localhost ~]# /usr/sbin/groupadd -g 60008 asmoper [root@localhost ~]# /usr/sbin/groupadd -g 60009 asmadmin [root@localhost ~]# useradd -u 61001 -g oinstall -G dba,asmdba,backupdba,dgdba,kmdba,oper oracle useradd -u 61002 -g oinstall -G asmadmin,asmdba,asmoper,dba grid [root@localhost ~]# useradd -u 61002 -g oinstall -G asmadmin,asmdba,asmoper,dba grid [root@localhost ~]# [root@localhost ~]# passwd oracle Changing password for user oracle. New password: Retype new password: passwd: all authentication tokens updated successfully. [root@localhost ~]# passwd grid Changing password for user grid. New password: Retype new password: passwd: all authentication tokens updated successfully.复制
二、防火墙
[root@localhost ~]# echo "SELINUX=disabled" >> /etc/selinux/config [root@localhost ~]# echo "#SELINUXTYPE=targeted " >> /etc/selinux/config [root@localhost ~]# setenforce 1 setenforce: SELinux is disabled [root@localhost ~]# systemctl stop firewalld.service systemctl disable firewalld.service [root@localhost ~]# systemctl disable firewalld.service复制
三、禁用ntp
这个操作没必要
[root@localhost ~]# systemctl stop ntpd [root@localhost ~]# systemctl disable ntpd Removed symlink /etc/systemd/system/multi-user.target.wants/ntpd.service. systemctl stop chronyd.service systemctl disable chronyd.service rm -f /etc/chrony.conf [root@localhost ~]# systemctl stop chronyd.service [root@localhost ~]# systemctl disable chronyd.service Removed symlink /etc/systemd/system/multi-user.target.wants/chronyd.service. [root@localhost ~]# rm -f /etc/chrony.conf复制
四、语言环境调整
[root@localhost ~]# localectl set-locale LANG=en_US.UTF8 && localectl status|grep LANG System Locale: LANG=en_US.UTF8复制
五、时区调整
[root@localhost ~]# timedatectl Local time: Thu 2023-03-30 13:56:06 CST Universal time: Thu 2023-03-30 05:56:06 UTC RTC time: Thu 2023-03-30 05:57:24 Time zone: Asia/Shanghai (CST, +0800) NTP enabled: no NTP synchronized: no RTC in local TZ: no DST active: n/a复制
六、配置NOZEROCONF
这个操作其实没必要，顺手做一下吧
[root@localhost ~]# echo "NOZEROCONF=yes" >> /etc/sysconfig/network复制
七、安装依赖包
[root@localhost ~]# yum install binutils compat-libstdc++-33 gcc gcc-c++ glibc glibc-devel ksh libgcc libstdc++-devel libaio libaio libaio-devel libXext libXtst libX11 libXau libxcb libXi make sysstat unixODBC unixODBC-devel zlib-develcompat-libcap1 -y Loaded plugins: langpacks, product-id, search-disabled-repos local | 3.6 kB 00:00:00 file:///mnt/repodata/repomd.xml: [Errno 14] curl#37 - "Couldn't open file /mnt/repodata/repomd.xml" Trying other mirror. Package binutils-2.27-34.base.el7.x86_64 already installed and latest version No package compat-libstdc++-33 available. Package gcc-4.8.5-36.el7.x86_64 already installed and latest version Package gcc-c++-4.8.5-36.el7.x86_64 already installed and latest version Package glibc-2.17-260.el7.x86_64 already installed and latest version Package glibc-devel-2.17-260.el7.x86_64 already installed and latest version Package libgcc-4.8.5-36.el7.x86_64 already installed and latest version Package libstdc++-devel-4.8.5-36.el7.x86_64 already installed and latest version Package libaio-0.3.109-13.el7.x86_64 already installed and latest version Package libaio-0.3.109-13.el7.x86_64 already installed and latest version Package libXext-1.3.3-3.el7.x86_64 already installed and latest version Package libXtst-1.2.3-1.el7.x86_64 already installed and latest version Package libX11-1.6.5-2.el7.x86_64 already installed and latest version Package libXau-1.0.8-2.1.el7.x86_64 already installed and latest version Package libxcb-1.13-1.el7.x86_64 already installed and latest version Package libXi-1.7.9-1.el7.x86_64 already installed and latest version Package 1:make-3.82-23.el7.x86_64 already installed and latest version Package sysstat-10.1.5-17.el7.x86_64 already installed and latest version No package zlib-develcompat-libcap1 available. Resolving Dependencies --> Running transaction check ---> Package ksh.x86_64 0:20120801-139.el7 will be installed ---> Package libaio-devel.x86_64 0:0.3.109-13.el7 will be installed ---> Package unixODBC.x86_64 0:2.3.1-11.el7 will be installed ---> Package unixODBC-devel.x86_64 0:2.3.1-11.el7 will be installed --> Finished Dependency Resolution Dependencies Resolved =========================================================================================================================================================================================== Package Arch Version Repository Size =========================================================================================================================================================================================== Installing: ksh x86_64 20120801-139.el7 local 885 k libaio-devel x86_64 0.3.109-13.el7 local 13 k unixODBC x86_64 2.3.1-11.el7 local 413 k unixODBC-devel x86_64 2.3.1-11.el7 local 55 k Transaction Summary =========================================================================================================================================================================================== Install 4 Packages Total download size: 1.3 M Installed size: 4.5 M Downloading packages: (1/4): libaio-devel-0.3.109-13.el7.x86_64.rpm | 13 kB 00:00:00 (2/4): ksh-20120801-139.el7.x86_64.rpm | 885 kB 00:00:00 (3/4): unixODBC-devel-2.3.1-11.el7.x86_64.rpm | 55 kB 00:00:00 (4/4): unixODBC-2.3.1-11.el7.x86_64.rpm | 413 kB 00:00:00 ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Total 9.0 MB/s | 1.3 MB 00:00:00 Running transaction check Running transaction test Transaction test succeeded Running transaction Installing : unixODBC-2.3.1-11.el7.x86_64 1/4 Installing : unixODBC-devel-2.3.1-11.el7.x86_64 2/4 Installing : libaio-devel-0.3.109-13.el7.x86_64 3/4 Installing : ksh-20120801-139.el7.x86_64 4/4 Verifying : ksh-20120801-139.el7.x86_64 1/4 Verifying : unixODBC-devel-2.3.1-11.el7.x86_64 2/4 Verifying : unixODBC-2.3.1-11.el7.x86_64 3/4 Verifying : libaio-devel-0.3.109-13.el7.x86_64 4/4 Installed: ksh.x86_64 0:20120801-139.el7 libaio-devel.x86_64 0:0.3.109-13.el7 unixODBC.x86_64 0:2.3.1-11.el7 unixODBC-devel.x86_64 0:2.3.1-11.el7 Complete! [root@localhost ~]# yum -y install kmod* yum -y install libaio* yum -y install compat* Loaded plugins: langpacks, product-id, search-disabled-repos file:///mnt/repodata/repomd.xml: [Errno 14] curl#37 - "Couldn't open file /mnt/repodata/repomd.xml" Trying other mirror. Package kmod-20-23.el7.x86_64 already installed and latest version Package kmod-kvdo-6.1.1.125-5.el7.x86_64 already installed and latest version Package kmod-libs-20-23.el7.x86_64 already installed and latest version Nothing to do [root@localhost ~]# yum -y install ksh* Loaded plugins: langpacks, product-id, search-disabled-repos file:///mnt/repodata/repomd.xml: [Errno 14] curl#37 - "Couldn't open file /mnt/repodata/repomd.xml" Trying other mirror. Package ksh-20120801-139.el7.x86_64 already installed and latest version Nothing to do [root@localhost ~]# yum -y install libaio* Loaded plugins: langpacks, product-id, search-disabled-repos file:///mnt/repodata/repomd.xml: [Errno 14] curl#37 - "Couldn't open file /mnt/repodata/repomd.xml" Trying other mirror. Package libaio-0.3.109-13.el7.x86_64 already installed and latest version Package libaio-devel-0.3.109-13.el7.x86_64 already installed and latest version Nothing to do [root@localhost ~]# yum -y install compat* Loaded plugins: langpacks, product-id, search-disabled-repos file:///mnt/repodata/repomd.xml: [Errno 14] curl#37 - "Couldn't open file /mnt/repodata/repomd.xml" Trying other mirror. Package compat-db-headers-4.7.25-28.el7.noarch already installed and latest version Package compat-libtiff3-3.9.4-11.el7.x86_64 already installed and latest version Package compat-db47-4.7.25-28.el7.x86_64 already installed and latest version Package compat-libgfortran-41-4.1.2-44.el7.x86_64 already installed and latest version Package 1:compat-openldap-2.3.43-5.el7.x86_64 already installed and latest version Package compat-libf2c-34-3.4.6-32.el7.x86_64 already installed and latest version Package compat-exiv2-023-0.23-2.el7.x86_64 already installed and latest version Package compat-libcap1-1.10-7.el7.x86_64 already installed and latest version Resolving Dependencies --> Running transaction check ---> Package compat-cheese314.x86_64 0:3.14.2-1.el7 will be installed --> Processing Dependency: libgstreamer-1.0.so.0()(64bit) for package: compat-cheese314-3.14.2-1.el7.x86_64 --> Processing Dependency: libgstpbutils-1.0.so.0()(64bit) for package: compat-cheese314-3.14.2-1.el7.x86_64 --> Processing Dependency: libgstbase-1.0.so.0()(64bit) for package: compat-cheese314-3.14.2-1.el7.x86_64 --> Processing Dependency: libcogl.so.20()(64bit) for package: compat-cheese314-3.14.2-1.el7.x86_64 --> Processing Dependency: libcogl-path.so.20()(64bit) for package: compat-cheese314-3.14.2-1.el7.x86_64 --> Processing Dependency: libcogl-pango.so.20()(64bit) for package: compat-cheese314-3.14.2-1.el7.x86_64 --> Processing Dependency: libclutter-gtk-1.0.so.0()(64bit) for package: compat-cheese314-3.14.2-1.el7.x86_64 --> Processing Dependency: libclutter-gst-2.0.so.0()(64bit) for package: compat-cheese314-3.14.2-1.el7.x86_64 --> Processing Dependency: libclutter-1.0.so.0()(64bit) for package: compat-cheese314-3.14.2-1.el7.x86_64 --> Processing Dependency: libcanberra.so.0()(64bit) for package: compat-cheese314-3.14.2-1.el7.x86_64 --> Processing Dependency: libcanberra-gtk3.so.0()(64bit) for package: compat-cheese314-3.14.2-1.el7.x86_64 ---> Package compat-dapl.x86_64 1:1.2.19-4.el7 will be installed --> Processing Dependency: librdmacm.so.1(RDMACM_1.0)(64bit) for package: 1:compat-dapl-1.2.19-4.el7.x86_64 --> Processing Dependency: libibverbs.so.1(IBVERBS_1.1)(64bit) for package: 1:compat-dapl-1.2.19-4.el7.x86_64 --> Processing Dependency: libibverbs.so.1(IBVERBS_1.0)(64bit) for package: 1:compat-dapl-1.2.19-4.el7.x86_64 --> Processing Dependency: librdmacm.so.1()(64bit) for package: 1:compat-dapl-1.2.19-4.el7.x86_64 --> Processing Dependency: libibverbs.so.1()(64bit) for package: 1:compat-dapl-1.2.19-4.el7.x86_64 ---> Package compat-gcc-44.x86_64 0:4.4.7-8.el7 will be installed ---> Package compat-gcc-44-c++.x86_64 0:4.4.7-8.el7 will be installed ---> Package compat-glibc.x86_64 1:2.12-4.el7 will be updated ---> Package compat-glibc.x86_64 1:2.12-4.el7.centos will be an update ---> Package compat-glibc-headers.x86_64 1:2.12-4.el7 will be updated ---> Package compat-glibc-headers.x86_64 1:2.12-4.el7.centos will be an update ---> Package compat-gnome-desktop314.x86_64 0:3.14.2-1.el7 will be installed ---> Package compat-libcogl-pango12.x86_64 0:1.14.0-3.el7 will be installed ---> Package compat-libcogl12.x86_64 0:1.14.0-3.el7 will be installed ---> Package compat-libcolord1.x86_64 0:1.0.4-1.el7 will be installed ---> Package compat-libical1.x86_64 0:1.0.1-2.el7 will be installed ---> Package compat-libpackagekit-glib2-16.x86_64 0:0.8.9-1.el7 will be installed ---> Package compat-poppler022.x86_64 0:0.22.5-4.el7 will be installed --> Processing Dependency: poppler-data >= 0.4.0 for package: compat-poppler022-0.22.5-4.el7.x86_64 --> Processing Dependency: libopenjpeg.so.1()(64bit) for package: compat-poppler022-0.22.5-4.el7.x86_64 ---> Package compat-poppler022-glib.x86_64 0:0.22.5-4.el7 will be installed ---> Package compat-poppler022-qt.x86_64 0:0.22.5-4.el7 will be installed --> Processing Dependency: qt4(x86-64) >= 4.8.5 for package: compat-poppler022-qt-0.22.5-4.el7.x86_64 --> Processing Dependency: libQtXml.so.4()(64bit) for package: compat-poppler022-qt-0.22.5-4.el7.x86_64 --> Processing Dependency: libQtGui.so.4()(64bit) for package: compat-poppler022-qt-0.22.5-4.el7.x86_64 --> Processing Dependency: libQtCore.so.4()(64bit) for package: compat-poppler022-qt-0.22.5-4.el7.x86_64 --> Running transaction check ---> Package clutter.x86_64 0:1.26.2-2.el7 will be installed --> Processing Dependency: libinput(x86-64) >= 0.19.0 for package: clutter-1.26.2-2.el7.x86_64 --> Processing Dependency: libinput.so.10(LIBINPUT_0.21.0)(64bit) for package: clutter-1.26.2-2.el7.x86_64 --> Processing Dependency: libinput.so.10(LIBINPUT_0.20.0)(64bit) for package: clutter-1.26.2-2.el7.x86_64 --> Processing Dependency: libinput.so.10(LIBINPUT_0.12.0)(64bit) for package: clutter-1.26.2-2.el7.x86_64 --> Processing Dependency: libinput.so.10()(64bit) for package: clutter-1.26.2-2.el7.x86_64 ---> Package clutter-gst2.x86_64 0:2.0.18-1.el7 will be installed ---> Package clutter-gtk.x86_64 0:1.8.4-1.el7 will be installed ---> Package cogl.x86_64 0:1.22.2-2.el7 will be installed ---> Package gstreamer1.x86_64 0:1.10.4-2.el7 will be installed ---> Package gstreamer1-plugins-base.x86_64 0:1.10.4-2.el7 will be installed --> Processing Dependency: libvisual-0.4.so.0()(64bit) for package: gstreamer1-plugins-base-1.10.4-2.el7.x86_64 --> Processing Dependency: liborc-0.4.so.0()(64bit) for package: gstreamer1-plugins-base-1.10.4-2.el7.x86_64 --> Processing Dependency: libopus.so.0()(64bit) for package: gstreamer1-plugins-base-1.10.4-2.el7.x86_64 --> Processing Dependency: libcdda_paranoia.so.0()(64bit) for package: gstreamer1-plugins-base-1.10.4-2.el7.x86_64 --> Processing Dependency: libcdda_interface.so.0()(64bit) for package: gstreamer1-plugins-base-1.10.4-2.el7.x86_64 --> Processing Dependency: libXv.so.1()(64bit) for package: gstreamer1-plugins-base-1.10.4-2.el7.x86_64 ---> Package libcanberra.x86_64 0:0.30-5.el7 will be installed --> Processing Dependency: pulseaudio-libs >= 0.9.15 for package: libcanberra-0.30-5.el7.x86_64 --> Processing Dependency: sound-theme-freedesktop for package: libcanberra-0.30-5.el7.x86_64 --> Processing Dependency: libpulse.so.0(PULSE_0)(64bit) for package: libcanberra-0.30-5.el7.x86_64 --> Processing Dependency: libpulse.so.0()(64bit) for package: libcanberra-0.30-5.el7.x86_64 ---> Package libcanberra-gtk3.x86_64 0:0.30-5.el7 will be installed ---> Package libibverbs.x86_64 0:17.2-3.el7 will be installed --> Processing Dependency: rdma-core(x86-64) = 17.2-3.el7 for package: libibverbs-17.2-3.el7.x86_64 ---> Package librdmacm.x86_64 0:17.2-3.el7 will be installed ---> Package openjpeg-libs.x86_64 0:1.5.1-18.el7 will be installed ---> Package poppler-data.noarch 0:0.4.6-3.el7 will be installed ---> Package qt.x86_64 1:4.8.7-2.el7 will be installed --> Processing Dependency: qt-settings for package: 1:qt-4.8.7-2.el7.x86_64 ---> Package qt-x11.x86_64 1:4.8.7-2.el7 will be installed --> Processing Dependency: libmng.so.1()(64bit) for package: 1:qt-x11-4.8.7-2.el7.x86_64 --> Running transaction check ---> Package cdparanoia-libs.x86_64 0:10.2-17.el7 will be installed ---> Package libXv.x86_64 0:1.0.11-1.el7 will be installed ---> Package libinput.x86_64 0:1.10.7-2.el7 will be installed --> Processing Dependency: libevdev.so.2(LIBEVDEV_1_3)(64bit) for package: libinput-1.10.7-2.el7.x86_64 --> Processing Dependency: libevdev.so.2(LIBEVDEV_1)(64bit) for package: libinput-1.10.7-2.el7.x86_64 --> Processing Dependency: libwacom.so.2()(64bit) for package: libinput-1.10.7-2.el7.x86_64 --> Processing Dependency: libmtdev.so.1()(64bit) for package: libinput-1.10.7-2.el7.x86_64 --> Processing Dependency: libevdev.so.2()(64bit) for package: libinput-1.10.7-2.el7.x86_64 ---> Package libmng.x86_64 0:1.0.10-14.el7 will be installed ---> Package libvisual.x86_64 0:0.4.0-16.el7 will be installed ---> Package opus.x86_64 0:1.0.2-6.el7 will be installed ---> Package orc.x86_64 0:0.4.26-1.el7 will be installed ---> Package pulseaudio-libs.x86_64 0:10.0-5.el7 will be installed --> Processing Dependency: libsndfile.so.1(libsndfile.so.1.0)(64bit) for package: pulseaudio-libs-10.0-5.el7.x86_64 --> Processing Dependency: libsndfile.so.1()(64bit) for package: pulseaudio-libs-10.0-5.el7.x86_64 --> Processing Dependency: libasyncns.so.0()(64bit) for package: pulseaudio-libs-10.0-5.el7.x86_64 ---> Package qt-settings.noarch 0:19-23.8.el7.centos will be installed ---> Package rdma-core.x86_64 0:17.2-3.el7 will be installed ---> Package sound-theme-freedesktop.noarch 0:0.8-3.el7 will be installed --> Running transaction check ---> Package libasyncns.x86_64 0:0.8-7.el7 will be installed ---> Package libevdev.x86_64 0:1.5.6-1.el7 will be installed ---> Package libsndfile.x86_64 0:1.0.25-10.el7 will be installed --> Processing Dependency: libgsm.so.1()(64bit) for package: libsndfile-1.0.25-10.el7.x86_64 --> Processing Dependency: libFLAC.so.8()(64bit) for package: libsndfile-1.0.25-10.el7.x86_64 ---> Package libwacom.x86_64 0:0.30-1.el7 will be installed --> Processing Dependency: libwacom-data for package: libwacom-0.30-1.el7.x86_64 ---> Package mtdev.x86_64 0:1.1.5-5.el7 will be installed --> Running transaction check ---> Package flac-libs.x86_64 0:1.3.0-5.el7_1 will be installed ---> Package gsm.x86_64 0:1.0.13-11.el7 will be installed ---> Package libwacom-data.noarch 0:0.30-1.el7 will be installed --> Finished Dependency Resolution Dependencies Resolved =========================================================================================================================================================================================== Package Arch Version Repository Size =========================================================================================================================================================================================== Installing: compat-cheese314 x86_64 3.14.2-1.el7 local 54 k compat-dapl x86_64 1:1.2.19-4.el7 local 110 k compat-gcc-44 x86_64 4.4.7-8.el7 local 10 M compat-gcc-44-c++ x86_64 4.4.7-8.el7 local 6.3 M compat-gnome-desktop314 x86_64 3.14.2-1.el7 local 108 k compat-libcogl-pango12 x86_64 1.14.0-3.el7 local 27 k compat-libcogl12 x86_64 1.14.0-3.el7 local 282 k compat-libcolord1 x86_64 1.0.4-1.el7 local 96 k compat-libical1 x86_64 1.0.1-2.el7 local 172 k compat-libpackagekit-glib2-16 x86_64 0.8.9-1.el7 local 112 k compat-poppler022 x86_64 0.22.5-4.el7 local 722 k compat-poppler022-glib x86_64 0.22.5-4.el7 local 87 k compat-poppler022-qt x86_64 0.22.5-4.el7 local 150 k Updating: compat-glibc x86_64 1:2.12-4.el7.centos local 1.2 M compat-glibc-headers x86_64 1:2.12-4.el7.centos local 452 k Installing for dependencies: cdparanoia-libs x86_64 10.2-17.el7 local 56 k clutter x86_64 1.26.2-2.el7 local 1.1 M clutter-gst2 x86_64 2.0.18-1.el7 local 61 k clutter-gtk x86_64 1.8.4-1.el7 local 44 k cogl x86_64 1.22.2-2.el7 local 462 k flac-libs x86_64 1.3.0-5.el7_1 local 169 k gsm x86_64 1.0.13-11.el7 local 30 k gstreamer1 x86_64 1.10.4-2.el7 local 1.2 M gstreamer1-plugins-base x86_64 1.10.4-2.el7 local 1.4 M libXv x86_64 1.0.11-1.el7 local 18 k libasyncns x86_64 0.8-7.el7 local 26 k libcanberra x86_64 0.30-5.el7 local 82 k libcanberra-gtk3 x86_64 0.30-5.el7 local 30 k libevdev x86_64 1.5.6-1.el7 local 34 k libibverbs x86_64 17.2-3.el7 local 246 k libinput x86_64 1.10.7-2.el7 local 147 k libmng x86_64 1.0.10-14.el7 local 171 k librdmacm x86_64 17.2-3.el7 local 62 k libsndfile x86_64 1.0.25-10.el7 local 149 k libvisual x86_64 0.4.0-16.el7 local 138 k libwacom x86_64 0.30-1.el7 local 32 k libwacom-data noarch 0.30-1.el7 local 70 k mtdev x86_64 1.1.5-5.el7 local 18 k openjpeg-libs x86_64 1.5.1-18.el7 local 86 k opus x86_64 1.0.2-6.el7 local 630 k orc x86_64 0.4.26-1.el7 local 166 k poppler-data noarch 0.4.6-3.el7 local 2.2 M pulseaudio-libs x86_64 10.0-5.el7 local 651 k qt x86_64 1:4.8.7-2.el7 local 4.6 M qt-settings noarch 19-23.8.el7.centos local 17 k qt-x11 x86_64 1:4.8.7-2.el7 local 13 M rdma-core x86_64 17.2-3.el7 local 49 k sound-theme-freedesktop noarch 0.8-3.el7 local 377 k Transaction Summary =========================================================================================================================================================================================== Install 13 Packages (+33 Dependent packages) Upgrade 2 Packages Total download size: 47 M Downloading packages: Delta RPMs disabled because /usr/bin/applydeltarpm not installed. (1/48): cdparanoia-libs-10.2-17.el7.x86_64.rpm | 56 kB 00:00:00 (2/48): clutter-gst2-2.0.18-1.el7.x86_64.rpm | 61 kB 00:00:00 (3/48): clutter-1.26.2-2.el7.x86_64.rpm | 1.1 MB 00:00:00 (4/48): clutter-gtk-1.8.4-1.el7.x86_64.rpm | 44 kB 00:00:00 (5/48): compat-cheese314-3.14.2-1.el7.x86_64.rpm | 54 kB 00:00:00 (6/48): cogl-1.22.2-2.el7.x86_64.rpm | 462 kB 00:00:00 (7/48): compat-dapl-1.2.19-4.el7.x86_64.rpm | 110 kB 00:00:00 (8/48): compat-gcc-44-c++-4.4.7-8.el7.x86_64.rpm | 6.3 MB 00:00:00 (9/48): compat-gcc-44-4.4.7-8.el7.x86_64.rpm | 10 MB 00:00:00 (10/48): compat-glibc-2.12-4.el7.centos.x86_64.rpm | 1.2 MB 00:00:00 (11/48): compat-glibc-headers-2.12-4.el7.centos.x86_64.rpm | 452 kB 00:00:00 (12/48): compat-gnome-desktop314-3.14.2-1.el7.x86_64.rpm | 108 kB 00:00:00 (13/48): compat-libcogl-pango12-1.14.0-3.el7.x86_64.rpm | 27 kB 00:00:00 (14/48): compat-libcogl12-1.14.0-3.el7.x86_64.rpm | 282 kB 00:00:00 (15/48): compat-libcolord1-1.0.4-1.el7.x86_64.rpm | 96 kB 00:00:00 (16/48): compat-libical1-1.0.1-2.el7.x86_64.rpm | 172 kB 00:00:00 (17/48): compat-libpackagekit-glib2-16-0.8.9-1.el7.x86_64.rpm | 112 kB 00:00:00 (18/48): compat-poppler022-0.22.5-4.el7.x86_64.rpm | 722 kB 00:00:00 (19/48): compat-poppler022-glib-0.22.5-4.el7.x86_64.rpm | 87 kB 00:00:00 (20/48): compat-poppler022-qt-0.22.5-4.el7.x86_64.rpm | 150 kB 00:00:00 (21/48): flac-libs-1.3.0-5.el7_1.x86_64.rpm | 169 kB 00:00:00 (22/48): gsm-1.0.13-11.el7.x86_64.rpm | 30 kB 00:00:00 (23/48): gstreamer1-1.10.4-2.el7.x86_64.rpm | 1.2 MB 00:00:00 (24/48): gstreamer1-plugins-base-1.10.4-2.el7.x86_64.rpm | 1.4 MB 00:00:00 (25/48): libXv-1.0.11-1.el7.x86_64.rpm | 18 kB 00:00:00 (26/48): libasyncns-0.8-7.el7.x86_64.rpm | 26 kB 00:00:00 (27/48): libcanberra-0.30-5.el7.x86_64.rpm | 82 kB 00:00:00 (28/48): libcanberra-gtk3-0.30-5.el7.x86_64.rpm | 30 kB 00:00:00 (29/48): libevdev-1.5.6-1.el7.x86_64.rpm | 34 kB 00:00:00 (30/48): libibverbs-17.2-3.el7.x86_64.rpm | 246 kB 00:00:00 (31/48): libinput-1.10.7-2.el7.x86_64.rpm | 147 kB 00:00:00 (32/48): libmng-1.0.10-14.el7.x86_64.rpm | 171 kB 00:00:00 (33/48): librdmacm-17.2-3.el7.x86_64.rpm | 62 kB 00:00:00 (34/48): libsndfile-1.0.25-10.el7.x86_64.rpm | 149 kB 00:00:00 (35/48): libvisual-0.4.0-16.el7.x86_64.rpm | 138 kB 00:00:00 (36/48): libwacom-0.30-1.el7.x86_64.rpm | 32 kB 00:00:00 (37/48): libwacom-data-0.30-1.el7.noarch.rpm | 70 kB 00:00:00 (38/48): mtdev-1.1.5-5.el7.x86_64.rpm | 18 kB 00:00:00 (39/48): openjpeg-libs-1.5.1-18.el7.x86_64.rpm | 86 kB 00:00:00 (40/48): opus-1.0.2-6.el7.x86_64.rpm | 630 kB 00:00:00 (41/48): orc-0.4.26-1.el7.x86_64.rpm | 166 kB 00:00:00 (42/48): pulseaudio-libs-10.0-5.el7.x86_64.rpm | 651 kB 00:00:00 (43/48): poppler-data-0.4.6-3.el7.noarch.rpm | 2.2 MB 00:00:00 (44/48): qt-settings-19-23.8.el7.centos.noarch.rpm | 17 kB 00:00:00 (45/48): qt-4.8.7-2.el7.x86_64.rpm | 4.6 MB 00:00:00 (46/48): rdma-core-17.2-3.el7.x86_64.rpm | 49 kB 00:00:00 (47/48): sound-theme-freedesktop-0.8-3.el7.noarch.rpm | 377 kB 00:00:00 (48/48): qt-x11-4.8.7-2.el7.x86_64.rpm | 13 MB 00:00:00 ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Total 80 MB/s | 47 MB 00:00:00 Running transaction check Running transaction test Transaction test succeeded Running transaction Installing : cogl-1.22.2-2.el7.x86_64 1/50 Installing : gstreamer1-1.10.4-2.el7.x86_64 2/50 Installing : openjpeg-libs-1.5.1-18.el7.x86_64 3/50 Installing : rdma-core-17.2-3.el7.x86_64 4/50 Installing : libibverbs-17.2-3.el7.x86_64 5/50 Installing : librdmacm-17.2-3.el7.x86_64 6/50 Updating : 1:compat-glibc-2.12-4.el7.centos.x86_64 7/50 Updating : 1:compat-glibc-headers-2.12-4.el7.centos.x86_64 8/50 Installing : cdparanoia-libs-10.2-17.el7.x86_64 9/50 Installing : poppler-data-0.4.6-3.el7.noarch 10/50 Installing : compat-poppler022-0.22.5-4.el7.x86_64 11/50 Installing : gsm-1.0.13-11.el7.x86_64 12/50 Installing : orc-0.4.26-1.el7.x86_64 13/50 Installing : compat-gnome-desktop314-3.14.2-1.el7.x86_64 14/50 Installing : flac-libs-1.3.0-5.el7_1.x86_64 15/50 Installing : libsndfile-1.0.25-10.el7.x86_64 16/50 Installing : libvisual-0.4.0-16.el7.x86_64 17/50 Installing : libmng-1.0.10-14.el7.x86_64 18/50 Installing : libwacom-data-0.30-1.el7.noarch 19/50 Installing : libwacom-0.30-1.el7.x86_64 20/50 Installing : sound-theme-freedesktop-0.8-3.el7.noarch 21/50 Installing : compat-libcogl12-1.14.0-3.el7.x86_64 22/50 Installing : libasyncns-0.8-7.el7.x86_64 23/50 Installing : pulseaudio-libs-10.0-5.el7.x86_64 24/50 Installing : libcanberra-0.30-5.el7.x86_64 25/50 Installing : libcanberra-gtk3-0.30-5.el7.x86_64 26/50 Installing : opus-1.0.2-6.el7.x86_64 27/50 Installing : mtdev-1.1.5-5.el7.x86_64 28/50 Installing : libevdev-1.5.6-1.el7.x86_64 29/50 Installing : libinput-1.10.7-2.el7.x86_64 30/50 Installing : clutter-1.26.2-2.el7.x86_64 31/50 Installing : clutter-gtk-1.8.4-1.el7.x86_64 32/50 Installing : qt-settings-19-23.8.el7.centos.noarch 33/50 Installing : 1:qt-4.8.7-2.el7.x86_64 34/50 Installing : 1:qt-x11-4.8.7-2.el7.x86_64 35/50 Installing : libXv-1.0.11-1.el7.x86_64 36/50 Installing : gstreamer1-plugins-base-1.10.4-2.el7.x86_64 37/50 Installing : clutter-gst2-2.0.18-1.el7.x86_64 38/50 Installing : compat-gcc-44-4.4.7-8.el7.x86_64 39/50 Installing : compat-cheese314-3.14.2-1.el7.x86_64 40/50 Installing : compat-poppler022-qt-0.22.5-4.el7.x86_64 41/50 Installing : compat-libcogl-pango12-1.14.0-3.el7.x86_64 42/50 Installing : compat-poppler022-glib-0.22.5-4.el7.x86_64 43/50 Installing : 1:compat-dapl-1.2.19-4.el7.x86_64 44/50 Installing : compat-libical1-1.0.1-2.el7.x86_64 45/50 Installing : compat-libpackagekit-glib2-16-0.8.9-1.el7.x86_64 46/50 Installing : compat-libcolord1-1.0.4-1.el7.x86_64 47/50 Installing : compat-gcc-44-c++-4.4.7-8.el7.x86_64 48/50 Cleanup : 1:compat-glibc-2.12-4.el7.x86_64 49/50 Cleanup : 1:compat-glibc-headers-2.12-4.el7.x86_64 50/50 Verifying : compat-gcc-44-c++-4.4.7-8.el7.x86_64 1/50 Verifying : clutter-gtk-1.8.4-1.el7.x86_64 2/50 Verifying : clutter-1.26.2-2.el7.x86_64 3/50 Verifying : libXv-1.0.11-1.el7.x86_64 4/50 Verifying : gstreamer1-1.10.4-2.el7.x86_64 5/50 Verifying : compat-gcc-44-4.4.7-8.el7.x86_64 6/50 Verifying : librdmacm-17.2-3.el7.x86_64 7/50 Verifying : compat-libcolord1-1.0.4-1.el7.x86_64 8/50 Verifying : 1:qt-4.8.7-2.el7.x86_64 9/50 Verifying : qt-settings-19-23.8.el7.centos.noarch 10/50 Verifying : rdma-core-17.2-3.el7.x86_64 11/50 Verifying : 1:compat-glibc-headers-2.12-4.el7.centos.x86_64 12/50 Verifying : libevdev-1.5.6-1.el7.x86_64 13/50 Verifying : mtdev-1.1.5-5.el7.x86_64 14/50 Verifying : opus-1.0.2-6.el7.x86_64 15/50 Verifying : libasyncns-0.8-7.el7.x86_64 16/50 Verifying : compat-libpackagekit-glib2-16-0.8.9-1.el7.x86_64 17/50 Verifying : libinput-1.10.7-2.el7.x86_64 18/50 Verifying : compat-libcogl-pango12-1.14.0-3.el7.x86_64 19/50 Verifying : compat-libcogl12-1.14.0-3.el7.x86_64 20/50 Verifying : libcanberra-gtk3-0.30-5.el7.x86_64 21/50 Verifying : sound-theme-freedesktop-0.8-3.el7.noarch 22/50 Verifying : libwacom-data-0.30-1.el7.noarch 23/50 Verifying : openjpeg-libs-1.5.1-18.el7.x86_64 24/50 Verifying : libwacom-0.30-1.el7.x86_64 25/50 Verifying : libmng-1.0.10-14.el7.x86_64 26/50 Verifying : cogl-1.22.2-2.el7.x86_64 27/50 Verifying : pulseaudio-libs-10.0-5.el7.x86_64 28/50 Verifying : libcanberra-0.30-5.el7.x86_64 29/50 Verifying : libvisual-0.4.0-16.el7.x86_64 30/50 Verifying : flac-libs-1.3.0-5.el7_1.x86_64 31/50 Verifying : compat-gnome-desktop314-3.14.2-1.el7.x86_64 32/50 Verifying : orc-0.4.26-1.el7.x86_64 33/50 Verifying : gsm-1.0.13-11.el7.x86_64 34/50 Verifying : poppler-data-0.4.6-3.el7.noarch 35/50 Verifying : libsndfile-1.0.25-10.el7.x86_64 36/50 Verifying : compat-poppler022-0.22.5-4.el7.x86_64 37/50 Verifying : 1:compat-glibc-2.12-4.el7.centos.x86_64 38/50 Verifying : cdparanoia-libs-10.2-17.el7.x86_64 39/50 Verifying : compat-poppler022-glib-0.22.5-4.el7.x86_64 40/50 Verifying : compat-libical1-1.0.1-2.el7.x86_64 41/50 Verifying : compat-cheese314-3.14.2-1.el7.x86_64 42/50 Verifying : 1:compat-dapl-1.2.19-4.el7.x86_64 43/50 Verifying : libibverbs-17.2-3.el7.x86_64 44/50 Verifying : clutter-gst2-2.0.18-1.el7.x86_64 45/50 Verifying : compat-poppler022-qt-0.22.5-4.el7.x86_64 46/50 Verifying : gstreamer1-plugins-base-1.10.4-2.el7.x86_64 47/50 Verifying : 1:qt-x11-4.8.7-2.el7.x86_64 48/50 Verifying : 1:compat-glibc-headers-2.12-4.el7.x86_64 49/50 Verifying : 1:compat-glibc-2.12-4.el7.x86_64 50/50 Installed: compat-cheese314.x86_64 0:3.14.2-1.el7 compat-dapl.x86_64 1:1.2.19-4.el7 compat-gcc-44.x86_64 0:4.4.7-8.el7 compat-gcc-44-c++.x86_64 0:4.4.7-8.el7 compat-gnome-desktop314.x86_64 0:3.14.2-1.el7 compat-libcogl-pango12.x86_64 0:1.14.0-3.el7 compat-libcogl12.x86_64 0:1.14.0-3.el7 compat-libcolord1.x86_64 0:1.0.4-1.el7 compat-libical1.x86_64 0:1.0.1-2.el7 compat-libpackagekit-glib2-16.x86_64 0:0.8.9-1.el7 compat-poppler022.x86_64 0:0.22.5-4.el7 compat-poppler022-glib.x86_64 0:0.22.5-4.el7 compat-poppler022-qt.x86_64 0:0.22.5-4.el7 Dependency Installed: cdparanoia-libs.x86_64 0:10.2-17.el7 clutter.x86_64 0:1.26.2-2.el7 clutter-gst2.x86_64 0:2.0.18-1.el7 clutter-gtk.x86_64 0:1.8.4-1.el7 cogl.x86_64 0:1.22.2-2.el7 flac-libs.x86_64 0:1.3.0-5.el7_1 gsm.x86_64 0:1.0.13-11.el7 gstreamer1.x86_64 0:1.10.4-2.el7 gstreamer1-plugins-base.x86_64 0:1.10.4-2.el7 libXv.x86_64 0:1.0.11-1.el7 libasyncns.x86_64 0:0.8-7.el7 libcanberra.x86_64 0:0.30-5.el7 libcanberra-gtk3.x86_64 0:0.30-5.el7 libevdev.x86_64 0:1.5.6-1.el7 libibverbs.x86_64 0:17.2-3.el7 libinput.x86_64 0:1.10.7-2.el7 libmng.x86_64 0:1.0.10-14.el7 librdmacm.x86_64 0:17.2-3.el7 libsndfile.x86_64 0:1.0.25-10.el7 libvisual.x86_64 0:0.4.0-16.el7 libwacom.x86_64 0:0.30-1.el7 libwacom-data.noarch 0:0.30-1.el7 mtdev.x86_64 0:1.1.5-5.el7 openjpeg-libs.x86_64 0:1.5.1-18.el7 opus.x86_64 0:1.0.2-6.el7 orc.x86_64 0:0.4.26-1.el7 poppler-data.noarch 0:0.4.6-3.el7 pulseaudio-libs.x86_64 0:10.0-5.el7 qt.x86_64 1:4.8.7-2.el7 qt-settings.noarch 0:19-23.8.el7.centos qt-x11.x86_64 1:4.8.7-2.el7 rdma-core.x86_64 0:17.2-3.el7 sound-theme-freedesktop.noarch 0:0.8-3.el7 Updated: compat-glibc.x86_64 1:2.12-4.el7.centos compat-glibc-headers.x86_64 1:2.12-4.el7.centos Complete! [root@localhost ~]#复制
八、内核参数调整
[root@localhost ~]# echo "fs.file-max = 6815744 > kernel.sem = 250 32000 100 128 > kernel.shmmni = 4096 > kernel.shmall = 94371840 > kernel.shmmax = 386547056640 > vm.nr_hugepages = 184320 > kernel.panic_on_oops = 1 > net.core.rmem_default = 262144 > net.core.rmem_max = 4194304 > net.core.wmem_default = 262144 > net.core.wmem_max = 1048576 > net.ipv4.conf.all.rp_filter = 2 > net.ipv4.conf.default.rp_filter = 2 > fs.aio-max-nr = 1048576 > net.ipv4.ip_local_port_range = 9000 65500" >> /etc/sysctl.conf复制
九、资源限制
vi /etc/security/limits.conf grid soft nproc 16384 grid hard nproc 16384 grid soft nofile 65536 grid hard nofile 65536 grid soft stack 32768 grid hard stack 32768 oracle soft nproc 16384 oracle hard nproc 16384 oracle soft nofile 65536 oracle hard nofile 65536 oracle soft stack 32768 oracle hard stack 32768 oracle hard memlock 536870912 oracle soft memlock 536870912复制
十、控制给用户分配的资源
[root@localhost ~]# echo "session required pam_limits.so" >> /etc/pam.d/login You have mail in /var/spool/mail/root [root@localhost ~]# cat /etc/pam.d/login #%PAM-1.0 auth [user_unknown=ignore success=ok ignore=ignore default=bad] pam_securetty.so auth substack system-auth auth include postlogin account required pam_nologin.so account include system-auth password include system-auth # pam_selinux.so close should be the first session rule session required pam_selinux.so close session required pam_loginuid.so session optional pam_console.so # pam_selinux.so open should only be followed by sessions to be executed in the user context session required pam_selinux.so open session required pam_namespace.so session optional pam_keyinit.so force revoke session include system-auth session include postlogin -session optional pam_ck_connector.so session required pam_limits.so [root@localhost ~]#复制
十一、关闭透明页
vi /etc/rc.d/rc.local --编辑该文档，加入下面一段代码！然后，再将下面这段代码拷贝粘贴，执行一遍，接着，再用cat命令查询！ if test -f /sys/kernel/mm/transparent_hugepage/enabled; then echo never > /sys/kernel/mm/transparent_hugepage/enabled fi if test -f /sys/kernel/mm/transparent_hugepage/defrag; then echo never > /sys/kernel/mm/transparent_hugepage/defrag fi chmod +x /etc/rc.d/rc.local --设置开机执行复制
十二、目录创建
[root@localhost ~]# [root@localhost ~]# mkdir -p /u01/app/19.3.0/grid [root@localhost ~]# mkdir -p /u01/app/grid [root@localhost ~]# mkdir -p /u01/app/oracle/product/19.3.0/db_1 [root@localhost ~]# chown -R grid:oinstall /u01 [root@localhost ~]# chown -R oracle:oinstall /u01/app/oracle [root@localhost ~]# chmod -R 775 /u01/ [root@localhost ~]#复制
十三、环境变量
export ORACLE_SID=+ASM export ORACLE_BASE=/u01/app/grid export ORACLE_HOME=/u01/app/19.3.0/grid export PATH=$ORACLE_HOME/bin:$PATH:/usr/local/bin/:. export TEMP=/tmp export TMP=/tmp export TMPDIR=/tmp umask 022 export PATH复制
export TMP=/tmp export LANG=en_US export TMPDIR=$TMP export ORACLE_UNQNAME=orcl2 ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE ORACLE_HOME=$ORACLE_BASE/product/19.3.0/db_1; export ORACLE_HOME ORACLE_SID=orcl2; export ORACLE_SID ORACLE_TERM=xterm; export ORACLE_TERM NLS_DATE_FORMAT="yyyy-mm-dd HH24:MI:SS"; export NLS_DATE_FORMAT NLS_LANG=AMERICAN_AMERICA.ZHS16GBK;export NLS_LANG PATH=.:$PATH:$HOME/bin:$ORACLE_BASE/product/19.3.0/db_1/bin:$ORACLE_HOME/bin; export PATH THREADS_FLAG=native; export THREADS_FLAG if [ $USER = "oracle" ] || [ $USER = "grid" ]; then if [ $SHELL = "/bin/ksh" ]; then ulimit -p 16384 ulimit -n 65536 else ulimit -u 16384 -n 65536 fi umask 022 fi复制
十四、udev
for i in b c d e f g h i j k; do echo "KERNEL==\"sd?\",SUBSYSTEM==\"block\", PROGRAM==\"/usr/lib/udev/scsi_id --whitelisted --replace-whitespace --device=/dev/\$name\",RESULT==\"`/usr/lib/udev/scsi_id --whitelisted --replace-whitespace --device=/dev/sd$i`\", SYMLINK+=\"asmdisk/asmdisk$i\",OWNER=\"grid\", GROUP=\"asmadmin\",MODE=\"0660\"" done复制
KERNEL=="sd?",SUBSYSTEM=="block", PROGRAM=="/usr/lib/udev/scsi_id --whitelisted --replace-whitespace --device=/dev/$name",RESULT=="3688860300000006600f1a91565340235", SYMLINK+="asmdisk/asmdiskb",OWNER="grid", GROUP="asmadmin",MODE="0660" KERNEL=="sd?",SUBSYSTEM=="block", PROGRAM=="/usr/lib/udev/scsi_id --whitelisted --replace-whitespace --device=/dev/$name",RESULT=="3688860300000006700f1a91565340235", SYMLINK+="asmdisk/asmdiskc",OWNER="grid", GROUP="asmadmin",MODE="0660" KERNEL=="sd?",SUBSYSTEM=="block", PROGRAM=="/usr/lib/udev/scsi_id --whitelisted --replace-whitespace --device=/dev/$name",RESULT=="3688860300000006800f1a91565340235", SYMLINK+="asmdisk/asmdiskd",OWNER="grid", GROUP="asmadmin",MODE="0660" KERNEL=="sd?",SUBSYSTEM=="block", PROGRAM=="/usr/lib/udev/scsi_id --whitelisted --replace-whitespace --device=/dev/$name",RESULT=="3688860300000006900f1a91565340235", SYMLINK+="asmdisk/asmdiske",OWNER="grid", GROUP="asmadmin",MODE="0660" KERNEL=="sd?",SUBSYSTEM=="block", PROGRAM=="/usr/lib/udev/scsi_id --whitelisted --replace-whitespace --device=/dev/$name",RESULT=="3688860300000006a00f1a91565340235", SYMLINK+="asmdisk/asmdiskf",OWNER="grid", GROUP="asmadmin",MODE="0660" KERNEL=="sd?",SUBSYSTEM=="block", PROGRAM=="/usr/lib/udev/scsi_id --whitelisted --replace-whitespace --device=/dev/$name",RESULT=="3688860300000006b00f1a91565340235", SYMLINK+="asmdisk/asmdiskg",OWNER="grid", GROUP="asmadmin",MODE="0660" KERNEL=="sd?",SUBSYSTEM=="block", PROGRAM=="/usr/lib/udev/scsi_id --whitelisted --replace-whitespace --device=/dev/$name",RESULT=="3688860300000007000f1a91565340235", SYMLINK+="asmdisk/asmdiskh",OWNER="grid", GROUP="asmadmin",MODE="0660" KERNEL=="sd?",SUBSYSTEM=="block", PROGRAM=="/usr/lib/udev/scsi_id --whitelisted --replace-whitespace --device=/dev/$name",RESULT=="3688860300000006d00f1a91565340235", SYMLINK+="asmdisk/asmdiski",OWNER="grid", GROUP="asmadmin",MODE="0660" KERNEL=="sd?",SUBSYSTEM=="block", PROGRAM=="/usr/lib/udev/scsi_id --whitelisted --replace-whitespace --device=/dev/$name",RESULT=="3688860300000006e00f1a91565340235", SYMLINK+="asmdisk/asmdiskj",OWNER="grid", GROUP="asmadmin",MODE="0660" KERNEL=="sd?",SUBSYSTEM=="block", PROGRAM=="/usr/lib/udev/scsi_id --whitelisted --replace-whitespace --device=/dev/$name",RESULT=="3688860300000006f00f1a91565340235", SYMLINK+="asmdisk/asmdiskk",OWNER="grid", GROUP="asmadmin",MODE="0660"复制
vi /etc/udev/rules.d/99-oracle-asmdevices.rules [root@localhost dev]# /sbin/udevadm trigger --type=devices --action=change复制
十五、hosts修改
[root@localhost dev]# hostnamectl set-hostname jftest复制
十六、numa
root@jftest ~]# vi /etc/default/grub GRUB_TIMEOUT=5 GRUB_DISTRIBUTOR="$(sed 's, release .*$,,g' /etc/system-release)" GRUB_DEFAULT=saved GRUB_DISABLE_SUBMENU=true GRUB_TERMINAL_OUTPUT="console" GRUB_CMDLINE_LINUX="crashkernel=auto rd.lvm.lv=rhel/root rd.lvm.lv=rhel/swap rhgb quiet numa=off" GRUB_DISABLE_RECOVERY="true" [root@jftest ~]# grub2-mkconfig -o /etc/grub2.cfg Generating grub configuration file ... Found linux image: /boot/vmlinuz-3.10.0-957.el7.x86_64 Found initrd image: /boot/initramfs-3.10.0-957.el7.x86_64.img Found linux image: /boot/vmlinuz-0-rescue-78049fe504e3403ebd9cf5980b95610c Found initrd image: /boot/initramfs-0-rescue-78049fe504e3403ebd9cf5980b95610c.img done复制
十七、安装cvu
[grid@jftest grid]$ unzip LINUX.X64_193000_grid_home.zip [root@jftest rpm]# ls cvuqdisk-1.0.10-1.rpm [root@jftest rpm]# rpm -ivh cvuqdisk-1.0.10-1.rpm Preparing... ################################# [100%] Using default group oinstall to install package Updating / installing... 1:cvuqdisk-1.0.10-1 ################################# [100%]复制
十八、安装前检查
[grid@jftest ~]$ /u01/app/19.3.0/grid/runcluvfy.sh stage -pre crsinst -n jftest -fixup -verbose ERROR: PRVG-10467 : The default Oracle Inventory group could not be determined. Verifying Physical Memory ... Node Name Available Required Status ------------ ------------------------ ------------------------ ---------- jftest 503.3373GB (5.27787444E8KB) 8GB (8388608.0KB) passed Verifying Physical Memory ...PASSED Verifying Available Physical Memory ... Node Name Available Required Status ------------ ------------------------ ------------------------ ---------- jftest 494.0035GB (5.18000252E8KB) 50MB (51200.0KB) passed Verifying Available Physical Memory ...PASSED Verifying Swap Size ... Node Name Available Required Status ------------ ------------------------ ------------------------ ---------- jftest 64GB (6.710886E7KB) 16GB (1.6777216E7KB) passed Verifying Swap Size ...PASSED Verifying Free Space: jftest:/usr,jftest:/etc,jftest:/sbin ... Path Node Name Mount point Available Required Status ---------------- ------------ ------------ ------------ ------------ ------------ /usr jftest / 49.3545GB 25MB passed /etc jftest / 49.3545GB 25MB passed /sbin jftest / 49.3545GB 10MB passed Verifying Free Space: jftest:/usr,jftest:/etc,jftest:/sbin ...PASSED Verifying Free Space: jftest:/var ... Path Node Name Mount point Available Required Status ---------------- ------------ ------------ ------------ ------------ ------------ /var jftest /var 50.9854GB 5MB passed Verifying Free Space: jftest:/var ...PASSED Verifying Free Space: jftest:/tmp ... Path Node Name Mount point Available Required Status ---------------- ------------ ------------ ------------ ------------ ------------ /tmp jftest /tmp 31.3916GB 1GB passed Verifying Free Space: jftest:/tmp ...PASSED Verifying User Existence: grid ... Node Name Status Comment ------------ ------------------------ ------------------------ jftest passed exists(61002) Verifying Users With Same UID: 61002 ...PASSED Verifying User Existence: grid ...PASSED Verifying Group Existence: asmadmin ... Node Name Status Comment ------------ ------------------------ ------------------------ jftest passed exists Verifying Group Existence: asmadmin ...PASSED Verifying Group Existence: asmdba ... Node Name Status Comment ------------ ------------------------ ------------------------ jftest passed exists Verifying Group Existence: asmdba ...PASSED Verifying Group Membership: asmdba ... Node Name User Exists Group Exists User in Group Status ---------------- ------------ ------------ ------------ ---------------- jftest yes yes yes passed Verifying Group Membership: asmdba ...PASSED Verifying Group Membership: asmadmin ... Node Name User Exists Group Exists User in Group Status ---------------- ------------ ------------ ------------ ---------------- jftest yes yes yes passed Verifying Group Membership: asmadmin ...PASSED Verifying Run Level ... Node Name run level Required Status ------------ ------------------------ ------------------------ ---------- jftest 3 3,5 passed Verifying Run Level ...PASSED Verifying Architecture ... Node Name Available Required Status ------------ ------------------------ ------------------------ ---------- jftest x86_64 x86_64 passed Verifying Architecture ...PASSED Verifying OS Kernel Version ... Node Name Available Required Status ------------ ------------------------ ------------------------ ---------- jftest 3.10.0-957.el7.x86_64 3.10.0 passed Verifying OS Kernel Version ...PASSED Verifying OS Kernel Parameter: semmsl ... Node Name Current Configured Required Status Comment ---------------- ------------ ------------ ------------ ------------ ------------ jftest 250 250 250 passed Verifying OS Kernel Parameter: semmsl ...PASSED Verifying OS Kernel Parameter: semmns ... Node Name Current Configured Required Status Comment ---------------- ------------ ------------ ------------ ------------ ------------ jftest 32000 32000 32000 passed Verifying OS Kernel Parameter: semmns ...PASSED Verifying OS Kernel Parameter: semopm ... Node Name Current Configured Required Status Comment ---------------- ------------ ------------ ------------ ------------ ------------ jftest 32 100 100 failed Current value incorrect. Verifying OS Kernel Parameter: semopm ...FAILED (PRVG-1205) Verifying OS Kernel Parameter: semmni ... Node Name Current Configured Required Status Comment ---------------- ------------ ------------ ------------ ------------ ------------ jftest 128 128 128 passed Verifying OS Kernel Parameter: semmni ...PASSED Verifying OS Kernel Parameter: shmmax ... Node Name Current Configured Required Status Comment ---------------- ------------ ------------ ------------ ------------ ------------ jftest 18446744073692774000 386547056640 270227171328 passed Verifying OS Kernel Parameter: shmmax ...PASSED Verifying OS Kernel Parameter: shmmni ... Node Name Current Configured Required Status Comment ---------------- ------------ ------------ ------------ ------------ ------------ jftest 4096 4096 4096 passed Verifying OS Kernel Parameter: shmmni ...PASSED Verifying OS Kernel Parameter: shmall ... Node Name Current Configured Required Status Comment ---------------- ------------ ------------ ------------ ------------ ------------ jftest 18446744073692774000 94371840 2251799813685247 failed Configured value incorrect. Verifying OS Kernel Parameter: shmall ...FAILED (PRVG-1201) Verifying OS Kernel Parameter: file-max ... Node Name Current Configured Required Status Comment ---------------- ------------ ------------ ------------ ------------ ------------ jftest 52337417 6815744 6815744 passed Verifying OS Kernel Parameter: file-max ...PASSED Verifying OS Kernel Parameter: ip_local_port_range ... Node Name Current Configured Required Status Comment ---------------- ------------ ------------ ------------ ------------ ------------ jftest between 32768 & 60999 between 9000 & 65500 between 9000 & 65535 passed Verifying OS Kernel Parameter: ip_local_port_range ...PASSED Verifying OS Kernel Parameter: rmem_default ... Node Name Current Configured Required Status Comment ---------------- ------------ ------------ ------------ ------------ ------------ jftest 212992 262144 262144 failed Current value incorrect. Verifying OS Kernel Parameter: rmem_default ...FAILED (PRVG-1205) Verifying OS Kernel Parameter: rmem_max ... Node Name Current Configured Required Status Comment ---------------- ------------ ------------ ------------ ------------ ------------ jftest 4194304 4194304 4194304 passed Verifying OS Kernel Parameter: rmem_max ...PASSED Verifying OS Kernel Parameter: wmem_default ... Node Name Current Configured Required Status Comment ---------------- ------------ ------------ ------------ ------------ ------------ jftest 212992 262144 262144 failed Current value incorrect. Verifying OS Kernel Parameter: wmem_default ...FAILED (PRVG-1205) Verifying OS Kernel Parameter: wmem_max ... Node Name Current Configured Required Status Comment ---------------- ------------ ------------ ------------ ------------ ------------ jftest 212992 1048576 1048576 failed Current value incorrect. Verifying OS Kernel Parameter: wmem_max ...FAILED (PRVG-1205) Verifying OS Kernel Parameter: aio-max-nr ... Node Name Current Configured Required Status Comment ---------------- ------------ ------------ ------------ ------------ ------------ jftest 6553600 1048576 1048576 passed Verifying OS Kernel Parameter: aio-max-nr ...PASSED Verifying Package: kmod-20-21 (x86_64) ... Node Name Available Required Status ------------ ------------------------ ------------------------ ---------- jftest kmod(x86_64)-20-23.el7 kmod(x86_64)-20-21 passed Verifying Package: kmod-20-21 (x86_64) ...PASSED Verifying Package: kmod-libs-20-21 (x86_64) ... Node Name Available Required Status ------------ ------------------------ ------------------------ ---------- jftest kmod-libs(x86_64)-20-23.el7 kmod-libs(x86_64)-20-21 passed Verifying Package: kmod-libs-20-21 (x86_64) ...PASSED Verifying Package: binutils-2.23.52.0.1 ... Node Name Available Required Status ------------ ------------------------ ------------------------ ---------- jftest binutils-2.27-34.base.el7 binutils-2.23.52.0.1 passed Verifying Package: binutils-2.23.52.0.1 ...PASSED Verifying Package: compat-libcap1-1.10 ... Node Name Available Required Status ------------ ------------------------ ------------------------ ---------- jftest compat-libcap1-1.10-7.el7 compat-libcap1-1.10 passed Verifying Package: compat-libcap1-1.10 ...PASSED Verifying Package: libgcc-4.8.2 (x86_64) ... Node Name Available Required Status ------------ ------------------------ ------------------------ ---------- jftest libgcc(x86_64)-4.8.5-36.el7 libgcc(x86_64)-4.8.2 passed Verifying Package: libgcc-4.8.2 (x86_64) ...PASSED Verifying Package: libstdc++-4.8.2 (x86_64) ... Node Name Available Required Status ------------ ------------------------ ------------------------ ---------- jftest libstdc++(x86_64)-4.8.5-36.el7 libstdc++(x86_64)-4.8.2 passed Verifying Package: libstdc++-4.8.2 (x86_64) ...PASSED Verifying Package: libstdc++-devel-4.8.2 (x86_64) ... Node Name Available Required Status ------------ ------------------------ ------------------------ ---------- jftest libstdc++-devel(x86_64)-4.8.5-36.el7 libstdc++-devel(x86_64)-4.8.2 passed Verifying Package: libstdc++-devel-4.8.2 (x86_64) ...PASSED Verifying Package: sysstat-10.1.5 ... Node Name Available Required Status ------------ ------------------------ ------------------------ ---------- jftest sysstat-10.1.5-17.el7 sysstat-10.1.5 passed Verifying Package: sysstat-10.1.5 ...PASSED Verifying Package: gcc-c++-4.8.2 ... Node Name Available Required Status ------------ ------------------------ ------------------------ ---------- jftest gcc-c++-4.8.5-36.el7 gcc-c++-4.8.2 passed Verifying Package: gcc-c++-4.8.2 ...PASSED Verifying Package: ksh ... Node Name Available Required Status ------------ ------------------------ ------------------------ ---------- jftest ksh ksh passed Verifying Package: ksh ...PASSED Verifying Package: make-3.82 ... Node Name Available Required Status ------------ ------------------------ ------------------------ ---------- jftest make-3.82-23.el7 make-3.82 passed Verifying Package: make-3.82 ...PASSED Verifying Package: glibc-2.17 (x86_64) ... Node Name Available Required Status ------------ ------------------------ ------------------------ ---------- jftest glibc(x86_64)-2.17-260.el7 glibc(x86_64)-2.17 passed Verifying Package: glibc-2.17 (x86_64) ...PASSED Verifying Package: glibc-devel-2.17 (x86_64) ... Node Name Available Required Status ------------ ------------------------ ------------------------ ---------- jftest glibc-devel(x86_64)-2.17-260.el7 glibc-devel(x86_64)-2.17 passed Verifying Package: glibc-devel-2.17 (x86_64) ...PASSED Verifying Package: libaio-0.3.109 (x86_64) ... Node Name Available Required Status ------------ ------------------------ ------------------------ ---------- jftest libaio(x86_64)-0.3.109-13.el7 libaio(x86_64)-0.3.109 passed Verifying Package: libaio-0.3.109 (x86_64) ...PASSED Verifying Package: libaio-devel-0.3.109 (x86_64) ... Node Name Available Required Status ------------ ------------------------ ------------------------ ---------- jftest libaio-devel(x86_64)-0.3.109-13.el7 libaio-devel(x86_64)-0.3.109 passed Verifying Package: libaio-devel-0.3.109 (x86_64) ...PASSED Verifying Package: nfs-utils-1.2.3-15 ... Node Name Available Required Status ------------ ------------------------ ------------------------ ---------- jftest nfs-utils-1.3.0-0.61.el7 nfs-utils-1.2.3-15 passed Verifying Package: nfs-utils-1.2.3-15 ...PASSED Verifying Package: smartmontools-6.2-4 ... Node Name Available Required Status ------------ ------------------------ ------------------------ ---------- jftest smartmontools-6.5-1.el7 smartmontools-6.2-4 passed Verifying Package: smartmontools-6.2-4 ...PASSED Verifying Package: net-tools-2.0-0.17 ... Node Name Available Required Status ------------ ------------------------ ------------------------ ---------- jftest net-tools-2.0-0.24.20131004git.el7 net-tools-2.0-0.17 passed Verifying Package: net-tools-2.0-0.17 ...PASSED Verifying Package: compat-libstdc++-33-3.2.3 (x86_64) ... Node Name Available Required Status ------------ ------------------------ ------------------------ ---------- jftest missing compat-libstdc++-33(x86_64)-3.2.3 failed Verifying Package: compat-libstdc++-33-3.2.3 (x86_64) ...FAILED (PRVF-7532) Verifying Package: libxcb-1.11 (x86_64) ... Node Name Available Required Status ------------ ------------------------ ------------------------ ---------- jftest libxcb(x86_64)-1.13-1.el7 libxcb(x86_64)-1.11 passed Verifying Package: libxcb-1.11 (x86_64) ...PASSED Verifying Package: libX11-1.6.3 (x86_64) ... Node Name Available Required Status ------------ ------------------------ ------------------------ ---------- jftest libX11(x86_64)-1.6.5-2.el7 libX11(x86_64)-1.6.3 passed Verifying Package: libX11-1.6.3 (x86_64) ...PASSED Verifying Package: libXau-1.0.8 (x86_64) ... Node Name Available Required Status ------------ ------------------------ ------------------------ ---------- jftest libXau(x86_64)-1.0.8-2.1.el7 libXau(x86_64)-1.0.8 passed Verifying Package: libXau-1.0.8 (x86_64) ...PASSED Verifying Package: libXi-1.7.4 (x86_64) ... Node Name Available Required Status ------------ ------------------------ ------------------------ ---------- jftest libXi(x86_64)-1.7.9-1.el7 libXi(x86_64)-1.7.4 passed Verifying Package: libXi-1.7.4 (x86_64) ...PASSED Verifying Package: libXtst-1.2.2 (x86_64) ... Node Name Available Required Status ------------ ------------------------ ------------------------ ---------- jftest libXtst(x86_64)-1.2.3-1.el7 libXtst(x86_64)-1.2.2 passed Verifying Package: libXtst-1.2.2 (x86_64) ...PASSED Verifying Port Availability for component "Oracle Notification Service (ONS)" ... Node Name Port Number Protocol Available Status ---------------- ------------ ------------ ------------ ---------------- jftest 6200 TCP yes successful jftest 6100 TCP yes successful Verifying Port Availability for component "Oracle Notification Service (ONS)" ...PASSED Verifying Port Availability for component "Oracle Cluster Synchronization Services (CSSD)" ... Node Name Port Number Protocol Available Status ---------------- ------------ ------------ ------------ ---------------- jftest 42424 TCP yes successful Verifying Port Availability for component "Oracle Cluster Synchronization Services (CSSD)" ...PASSED Verifying Users With Same UID: 0 ...PASSED Verifying Current Group ID ...PASSED Verifying Root user consistency ... Node Name Status ------------------------------------ ------------------------ jftest passed Verifying Root user consistency ...PASSED Verifying Package: cvuqdisk-1.0.10-1 ... Node Name Available Required Status ------------ ------------------------ ------------------------ ---------- jftest cvuqdisk-1.0.10-1 cvuqdisk-1.0.10-1 passed Verifying Package: cvuqdisk-1.0.10-1 ...PASSED Verifying Host name ...PASSED Verifying Node Connectivity ... Verifying Hosts File ... Node Name Status ------------------------------------ ------------------------ jftest passed Verifying Hosts File ...PASSED Interface information for node "jftest" Name IP Address Subnet Gateway Def. Gateway HW Address MTU ------ --------------- --------------- --------------- --------------- ----------------- ------ bond0 10.227.62.9 10.227.62.0 0.0.0.0 10.227.62.1 58:F9:87:D3:01:20 1500 bond1.850 172.121.7.10 172.121.7.0 0.0.0.0 10.227.62.1 58:F9:87:D3:01:21 1500 bond1.860 172.121.7.142 172.121.7.128 0.0.0.0 10.227.62.1 58:F9:87:D3:01:21 1500 Check: MTU consistency of the subnet "10.227.62.0". Node Name IP Address Subnet MTU ---------------- ------------ ------------ ------------ ---------------- jftest bond0 10.227.62.9 10.227.62.0 1500 Check: MTU consistency of the subnet "172.121.7.0". Node Name IP Address Subnet MTU ---------------- ------------ ------------ ------------ ---------------- jftest bond1.850 172.121.7.10 172.121.7.0 1500 Check: MTU consistency of the subnet "172.121.7.128". Node Name IP Address Subnet MTU ---------------- ------------ ------------ ------------ ---------------- jftest bond1.860 172.121.7.142 172.121.7.128 1500 Verifying Check that maximum (MTU) size packet goes through subnet ...PASSED Verifying Node Connectivity ...PASSED Verifying Multicast or broadcast check ... Checking subnet "10.227.62.0" for multicast communication with multicast group "224.0.0.251" Verifying Multicast or broadcast check ...PASSED Verifying Network Time Protocol (NTP) ... Verifying '/etc/ntp.conf' ... Node Name File exists? ------------------------------------ ------------------------ jftest yes Verifying '/etc/ntp.conf' ...PASSED Verifying Network Time Protocol (NTP) ...FAILED (PRVG-1017) Verifying Same core file name pattern ...PASSED Verifying User Mask ... Node Name Available Required Comment ------------ ------------------------ ------------------------ ---------- jftest 0022 0022 passed Verifying User Mask ...PASSED Verifying User Not In Group "root": grid ... Node Name Status Comment ------------ ------------------------ ------------------------ jftest passed does not exist Verifying User Not In Group "root": grid ...PASSED Verifying Time zone consistency ...PASSED Verifying resolv.conf Integrity ... Node Name Status ------------------------------------ ------------------------ jftest failed Verifying resolv.conf Integrity ...FAILED (PRVF-5636, PRVG-2064) Verifying DNS/NIS name service ...PASSED Verifying Domain Sockets ...PASSED Verifying /boot mount ...PASSED Verifying Daemon "avahi-daemon" not configured and running ... Node Name Configured Status ------------ ------------------------ ------------------------ jftest no passed Node Name Running? Status ------------ ------------------------ ------------------------ jftest no passed Verifying Daemon "avahi-daemon" not configured and running ...PASSED Verifying Daemon "proxyt" not configured and running ... Node Name Configured Status ------------ ------------------------ ------------------------ jftest no passed Node Name Running? Status ------------ ------------------------ ------------------------ jftest no passed Verifying Daemon "proxyt" not configured and running ...PASSED Verifying User Equivalence ...PASSED Verifying RPM Package Manager database ...INFORMATION (PRVG-11250) Verifying /dev/shm mounted as temporary file system ...FAILED (PRVE-0421) Verifying File system mount options for path /var ...PASSED Verifying DefaultTasksMax parameter ...PASSED Verifying zeroconf check ...PASSED Verifying ASM Filter Driver configuration ...PASSED Pre-check for cluster services setup was unsuccessful on all the nodes. Failures were encountered during execution of CVU verification request "stage -pre crsinst". Verifying OS Kernel Parameter: semopm ...FAILED jftest: PRVG-1205 : OS kernel parameter "semopm" does not have expected current value on node "jftest" [Expected = "100" ; Current = "32"; Configured = "100"]. Verifying OS Kernel Parameter: shmall ...FAILED jftest: PRVG-1201 : OS kernel parameter "shmall" does not have expected configured value on node "jftest" [Expected = "2251799813685247" ; Current = "18446744073692774000"; Configured = "94371840"]. Verifying OS Kernel Parameter: rmem_default ...FAILED jftest: PRVG-1205 : OS kernel parameter "rmem_default" does not have expected current value on node "jftest" [Expected = "262144" ; Current = "212992"; Configured = "262144"]. Verifying OS Kernel Parameter: wmem_default ...FAILED jftest: PRVG-1205 : OS kernel parameter "wmem_default" does not have expected current value on node "jftest" [Expected = "262144" ; Current = "212992"; Configured = "262144"]. Verifying OS Kernel Parameter: wmem_max ...FAILED jftest: PRVG-1205 : OS kernel parameter "wmem_max" does not have expected current value on node "jftest" [Expected = "1048576" ; Current = "212992"; Configured = "1048576"]. Verifying Package: compat-libstdc++-33-3.2.3 (x86_64) ...FAILED jftest: PRVF-7532 : Package "compat-libstdc++-33(x86_64)" is missing on node "jftest" Verifying Network Time Protocol (NTP) ...FAILED jftest: PRVG-1017 : NTP configuration file "/etc/ntp.conf" is present on nodes "jftest" on which NTP daemon or service was not running Verifying resolv.conf Integrity ...FAILED jftest: PRVF-5636 : The DNS response time for an unreachable node exceeded "15000" ms on following nodes: jftest jftest: PRVG-2064 : There are no configured name servers in the file '/etc/resolv.conf' on the nodes "jftest" Verifying RPM Package Manager database ...INFORMATION PRVG-11250 : The check "RPM Package Manager database" was not performed because it needs 'root' user privileges. Verifying /dev/shm mounted as temporary file system ...FAILED jftest: PRVE-0421 : No entry exists in /etc/fstab for mounting /dev/shm CVU operation performed: stage -pre crsinst Date: Mar 30, 2023 2:27:35 PM CVU home: /u01/app/19.3.0/grid/ User: grid ****************************************************************************************** Following is the list of fixable prerequisites selected to fix in this session ****************************************************************************************** -------------- --------------- ------------- ------------- --- ----- Check failed. Failed on nodes Reboot Re-Login required? required? -------------- --------------- ------------- ------------- --- ----- OS Kernel Parameter: semopm jftest no no OS Kernel Parameter: shmall jftest no no OS Kernel Parameter: jftest no no rmem_default OS Kernel Parameter: jftest no no wmem_default OS Kernel Parameter: jftest no no wmem_max Execute "/tmp/CVU_19.0.0.0.0_grid/runfixup.sh" as root user on nodes "jftest" to perform the fix up operations manually Press ENTER key to continue after execution of "/tmp/CVU_19.0.0.0.0_grid/runfixup.sh" has completed on nodes "jftest" Fix: OS Kernel Parameter: semopm Node Name Status ------------------------------------ ------------------------ jftest failed ERROR: jftest: PRVG-9023 : Manual fix up command "/tmp/CVU_19.0.0.0.0_grid/runfixup.sh" was not issued by root user on node "jftest" Result: "OS Kernel Parameter: semopm" could not be fixed on nodes "jftest" Fix: OS Kernel Parameter: shmall Node Name Status ------------------------------------ ------------------------ jftest failed ERROR: jftest: PRVG-9023 : Manual fix up command "/tmp/CVU_19.0.0.0.0_grid/runfixup.sh" was not issued by root user on node "jftest" Result: "OS Kernel Parameter: shmall" could not be fixed on nodes "jftest" Fix: OS Kernel Parameter: rmem_default Node Name Status ------------------------------------ ------------------------ jftest failed ERROR: jftest: PRVG-9023 : Manual fix up command "/tmp/CVU_19.0.0.0.0_grid/runfixup.sh" was not issued by root user on node "jftest" Result: "OS Kernel Parameter: rmem_default" could not be fixed on nodes "jftest" Fix: OS Kernel Parameter: wmem_default Node Name Status ------------------------------------ ------------------------ jftest failed ERROR: jftest: PRVG-9023 : Manual fix up command "/tmp/CVU_19.0.0.0.0_grid/runfixup.sh" was not issued by root user on node "jftest" Result: "OS Kernel Parameter: wmem_default" could not be fixed on nodes "jftest" Fix: OS Kernel Parameter: wmem_max Node Name Status ------------------------------------ ------------------------ jftest failed ERROR: jftest: PRVG-9023 : Manual fix up command "/tmp/CVU_19.0.0.0.0_grid/runfixup.sh" was not issued by root user on node "jftest" Result: "OS Kernel Parameter: wmem_max" could not be fixed on nodes "jftest" Fix up operations for selected fixable prerequisites were unsuccessful on nodes "jftest"复制
十九、修复
[root@jftest rpm]# /tmp/CVU_19.0.0.0.0_grid/runfixup.sh All Fix-up operations were completed successfully.复制
二十、再次检查
[grid@jftest ~]$ /u01/app/19.3.0/grid/runcluvfy.sh stage -pre crsinst -n jftest -fixup -verbose Verifying Physical Memory ... Node Name Available Required Status ------------ ------------------------ ------------------------ ---------- jftest 503.3373GB (5.27787444E8KB) 8GB (8388608.0KB) passed Verifying Physical Memory ...PASSED Verifying Available Physical Memory ... Node Name Available Required Status ------------ ------------------------ ------------------------ ---------- jftest 494.2113GB (5.18218104E8KB) 50MB (51200.0KB) passed Verifying Available Physical Memory ...PASSED Verifying Swap Size ... Node Name Available Required Status ------------ ------------------------ ------------------------ ---------- jftest 64GB (6.710886E7KB) 16GB (1.6777216E7KB) passed Verifying Swap Size ...PASSED Verifying Free Space: jftest:/usr,jftest:/etc,jftest:/sbin ... Path Node Name Mount point Available Required Status ---------------- ------------ ------------ ------------ ------------ ------------ /usr jftest / 49.3545GB 25MB passed /etc jftest / 49.3545GB 25MB passed /sbin jftest / 49.3545GB 10MB passed Verifying Free Space: jftest:/usr,jftest:/etc,jftest:/sbin ...PASSED Verifying Free Space: jftest:/var ... Path Node Name Mount point Available Required Status ---------------- ------------ ------------ ------------ ------------ ------------ /var jftest /var 50.9834GB 5MB passed Verifying Free Space: jftest:/var ...PASSED Verifying Free Space: jftest:/tmp ... Path Node Name Mount point Available Required Status ---------------- ------------ ------------ ------------ ------------ ------------ /tmp jftest /tmp 31.3857GB 1GB passed Verifying Free Space: jftest:/tmp ...PASSED Verifying User Existence: grid ... Node Name Status Comment ------------ ------------------------ ------------------------ jftest passed exists(61002) Verifying Users With Same UID: 61002 ...PASSED Verifying User Existence: grid ...PASSED Verifying Group Existence: asmadmin ... Node Name Status Comment ------------ ------------------------ ------------------------ jftest passed exists Verifying Group Existence: asmadmin ...PASSED Verifying Group Existence: asmdba ... Node Name Status Comment ------------ ------------------------ ------------------------ jftest passed exists Verifying Group Existence: asmdba ...PASSED Verifying Group Existence: oinstall ... Node Name Status Comment ------------ ------------------------ ------------------------ jftest passed exists Verifying Group Existence: oinstall ...PASSED Verifying Group Membership: asmdba ... Node Name User Exists Group Exists User in Group Status ---------------- ------------ ------------ ------------ ---------------- jftest yes yes yes passed Verifying Group Membership: asmdba ...PASSED Verifying Group Membership: asmadmin ... Node Name User Exists Group Exists User in Group Status ---------------- ------------ ------------ ------------ ---------------- jftest yes yes yes passed Verifying Group Membership: asmadmin ...PASSED Verifying Group Membership: oinstall(Primary) ... Node Name User Exists Group Exists User in Group Primary Status ---------------- ------------ ------------ ------------ ------------ ------------ jftest yes yes yes yes passed Verifying Group Membership: oinstall(Primary) ...PASSED Verifying Run Level ... Node Name run level Required Status ------------ ------------------------ ------------------------ ---------- jftest 3 3,5 passed Verifying Run Level ...PASSED Verifying Architecture ... Node Name Available Required Status ------------ ------------------------ ------------------------ ---------- jftest x86_64 x86_64 passed Verifying Architecture ...PASSED Verifying OS Kernel Version ... Node Name Available Required Status ------------ ------------------------ ------------------------ ---------- jftest 3.10.0-957.el7.x86_64 3.10.0 passed Verifying OS Kernel Version ...PASSED Verifying OS Kernel Parameter: semmsl ... Node Name Current Configured Required Status Comment ---------------- ------------ ------------ ------------ ------------ ------------ jftest 250 250 250 passed Verifying OS Kernel Parameter: semmsl ...PASSED Verifying OS Kernel Parameter: semmns ... Node Name Current Configured Required Status Comment ---------------- ------------ ------------ ------------ ------------ ------------ jftest 32000 32000 32000 passed Verifying OS Kernel Parameter: semmns ...PASSED Verifying OS Kernel Parameter: semopm ... Node Name Current Configured Required Status Comment ---------------- ------------ ------------ ------------ ------------ ------------ jftest 100 100 100 passed Verifying OS Kernel Parameter: semopm ...PASSED Verifying OS Kernel Parameter: semmni ... Node Name Current Configured Required Status Comment ---------------- ------------ ------------ ------------ ------------ ------------ jftest 128 128 128 passed Verifying OS Kernel Parameter: semmni ...PASSED Verifying OS Kernel Parameter: shmmax ... Node Name Current Configured Required Status Comment ---------------- ------------ ------------ ------------ ------------ ------------ jftest 18446744073692774000 386547056640 270227171328 passed Verifying OS Kernel Parameter: shmmax ...PASSED Verifying OS Kernel Parameter: shmmni ... Node Name Current Configured Required Status Comment ---------------- ------------ ------------ ------------ ------------ ------------ jftest 4096 4096 4096 passed Verifying OS Kernel Parameter: shmmni ...PASSED Verifying OS Kernel Parameter: shmall ... Node Name Current Configured Required Status Comment ---------------- ------------ ------------ ------------ ------------ ------------ jftest 2251799813685247 2251799813685247 2251799813685247 passed Verifying OS Kernel Parameter: shmall ...PASSED Verifying OS Kernel Parameter: file-max ... Node Name Current Configured Required Status Comment ---------------- ------------ ------------ ------------ ------------ ------------ jftest 52337417 6815744 6815744 passed Verifying OS Kernel Parameter: file-max ...PASSED Verifying OS Kernel Parameter: ip_local_port_range ... Node Name Current Configured Required Status Comment ---------------- ------------ ------------ ------------ ------------ ------------ jftest between 32768 & 60999 between 9000 & 65500 between 9000 & 65535 passed Verifying OS Kernel Parameter: ip_local_port_range ...PASSED Verifying OS Kernel Parameter: rmem_default ... Node Name Current Configured Required Status Comment ---------------- ------------ ------------ ------------ ------------ ------------ jftest 262144 262144 262144 passed Verifying OS Kernel Parameter: rmem_default ...PASSED Verifying OS Kernel Parameter: rmem_max ... Node Name Current Configured Required Status Comment ---------------- ------------ ------------ ------------ ------------ ------------ jftest 4194304 4194304 4194304 passed Verifying OS Kernel Parameter: rmem_max ...PASSED Verifying OS Kernel Parameter: wmem_default ... Node Name Current Configured Required Status Comment ---------------- ------------ ------------ ------------ ------------ ------------ jftest 262144 262144 262144 passed Verifying OS Kernel Parameter: wmem_default ...PASSED Verifying OS Kernel Parameter: wmem_max ... Node Name Current Configured Required Status Comment ---------------- ------------ ------------ ------------ ------------ ------------ jftest 1048576 1048576 1048576 passed Verifying OS Kernel Parameter: wmem_max ...PASSED Verifying OS Kernel Parameter: aio-max-nr ... Node Name Current Configured Required Status Comment ---------------- ------------ ------------ ------------ ------------ ------------ jftest 6553600 1048576 1048576 passed Verifying OS Kernel Parameter: aio-max-nr ...PASSED Verifying Package: kmod-20-21 (x86_64) ... Node Name Available Required Status ------------ ------------------------ ------------------------ ---------- jftest kmod(x86_64)-20-23.el7 kmod(x86_64)-20-21 passed Verifying Package: kmod-20-21 (x86_64) ...PASSED Verifying Package: kmod-libs-20-21 (x86_64) ... Node Name Available Required Status ------------ ------------------------ ------------------------ ---------- jftest kmod-libs(x86_64)-20-23.el7 kmod-libs(x86_64)-20-21 passed Verifying Package: kmod-libs-20-21 (x86_64) ...PASSED Verifying Package: binutils-2.23.52.0.1 ... Node Name Available Required Status ------------ ------------------------ ------------------------ ---------- jftest binutils-2.27-34.base.el7 binutils-2.23.52.0.1 passed Verifying Package: binutils-2.23.52.0.1 ...PASSED Verifying Package: compat-libcap1-1.10 ... Node Name Available Required Status ------------ ------------------------ ------------------------ ---------- jftest compat-libcap1-1.10-7.el7 compat-libcap1-1.10 passed Verifying Package: compat-libcap1-1.10 ...PASSED Verifying Package: libgcc-4.8.2 (x86_64) ... Node Name Available Required Status ------------ ------------------------ ------------------------ ---------- jftest libgcc(x86_64)-4.8.5-36.el7 libgcc(x86_64)-4.8.2 passed Verifying Package: libgcc-4.8.2 (x86_64) ...PASSED Verifying Package: libstdc++-4.8.2 (x86_64) ... Node Name Available Required Status ------------ ------------------------ ------------------------ ---------- jftest libstdc++(x86_64)-4.8.5-36.el7 libstdc++(x86_64)-4.8.2 passed Verifying Package: libstdc++-4.8.2 (x86_64) ...PASSED Verifying Package: libstdc++-devel-4.8.2 (x86_64) ... Node Name Available Required Status ------------ ------------------------ ------------------------ ---------- jftest libstdc++-devel(x86_64)-4.8.5-36.el7 libstdc++-devel(x86_64)-4.8.2 passed Verifying Package: libstdc++-devel-4.8.2 (x86_64) ...PASSED Verifying Package: sysstat-10.1.5 ... Node Name Available Required Status ------------ ------------------------ ------------------------ ---------- jftest sysstat-10.1.5-17.el7 sysstat-10.1.5 passed Verifying Package: sysstat-10.1.5 ...PASSED Verifying Package: gcc-c++-4.8.2 ... Node Name Available Required Status ------------ ------------------------ ------------------------ ---------- jftest gcc-c++-4.8.5-36.el7 gcc-c++-4.8.2 passed Verifying Package: gcc-c++-4.8.2 ...PASSED Verifying Package: ksh ... Node Name Available Required Status ------------ ------------------------ ------------------------ ---------- jftest ksh ksh passed Verifying Package: ksh ...PASSED Verifying Package: make-3.82 ... Node Name Available Required Status ------------ ------------------------ ------------------------ ---------- jftest make-3.82-23.el7 make-3.82 passed Verifying Package: make-3.82 ...PASSED Verifying Package: glibc-2.17 (x86_64) ... Node Name Available Required Status ------------ ------------------------ ------------------------ ---------- jftest glibc(x86_64)-2.17-260.el7 glibc(x86_64)-2.17 passed Verifying Package: glibc-2.17 (x86_64) ...PASSED Verifying Package: glibc-devel-2.17 (x86_64) ... Node Name Available Required Status ------------ ------------------------ ------------------------ ---------- jftest glibc-devel(x86_64)-2.17-260.el7 glibc-devel(x86_64)-2.17 passed Verifying Package: glibc-devel-2.17 (x86_64) ...PASSED Verifying Package: libaio-0.3.109 (x86_64) ... Node Name Available Required Status ------------ ------------------------ ------------------------ ---------- jftest libaio(x86_64)-0.3.109-13.el7 libaio(x86_64)-0.3.109 passed Verifying Package: libaio-0.3.109 (x86_64) ...PASSED Verifying Package: libaio-devel-0.3.109 (x86_64) ... Node Name Available Required Status ------------ ------------------------ ------------------------ ---------- jftest libaio-devel(x86_64)-0.3.109-13.el7 libaio-devel(x86_64)-0.3.109 passed Verifying Package: libaio-devel-0.3.109 (x86_64) ...PASSED Verifying Package: nfs-utils-1.2.3-15 ... Node Name Available Required Status ------------ ------------------------ ------------------------ ---------- jftest nfs-utils-1.3.0-0.61.el7 nfs-utils-1.2.3-15 passed Verifying Package: nfs-utils-1.2.3-15 ...PASSED Verifying Package: smartmontools-6.2-4 ... Node Name Available Required Status ------------ ------------------------ ------------------------ ---------- jftest smartmontools-6.5-1.el7 smartmontools-6.2-4 passed Verifying Package: smartmontools-6.2-4 ...PASSED Verifying Package: net-tools-2.0-0.17 ... Node Name Available Required Status ------------ ------------------------ ------------------------ ---------- jftest net-tools-2.0-0.24.20131004git.el7 net-tools-2.0-0.17 passed Verifying Package: net-tools-2.0-0.17 ...PASSED Verifying Package: compat-libstdc++-33-3.2.3 (x86_64) ... Node Name Available Required Status ------------ ------------------------ ------------------------ ---------- jftest missing compat-libstdc++-33(x86_64)-3.2.3 failed Verifying Package: compat-libstdc++-33-3.2.3 (x86_64) ...FAILED (PRVF-7532) Verifying Package: libxcb-1.11 (x86_64) ... Node Name Available Required Status ------------ ------------------------ ------------------------ ---------- jftest libxcb(x86_64)-1.13-1.el7 libxcb(x86_64)-1.11 passed Verifying Package: libxcb-1.11 (x86_64) ...PASSED Verifying Package: libX11-1.6.3 (x86_64) ... Node Name Available Required Status ------------ ------------------------ ------------------------ ---------- jftest libX11(x86_64)-1.6.5-2.el7 libX11(x86_64)-1.6.3 passed Verifying Package: libX11-1.6.3 (x86_64) ...PASSED Verifying Package: libXau-1.0.8 (x86_64) ... Node Name Available Required Status ------------ ------------------------ ------------------------ ---------- jftest libXau(x86_64)-1.0.8-2.1.el7 libXau(x86_64)-1.0.8 passed Verifying Package: libXau-1.0.8 (x86_64) ...PASSED Verifying Package: libXi-1.7.4 (x86_64) ... Node Name Available Required Status ------------ ------------------------ ------------------------ ---------- jftest libXi(x86_64)-1.7.9-1.el7 libXi(x86_64)-1.7.4 passed Verifying Package: libXi-1.7.4 (x86_64) ...PASSED Verifying Package: libXtst-1.2.2 (x86_64) ... Node Name Available Required Status ------------ ------------------------ ------------------------ ---------- jftest libXtst(x86_64)-1.2.3-1.el7 libXtst(x86_64)-1.2.2 passed Verifying Package: libXtst-1.2.2 (x86_64) ...PASSED Verifying Port Availability for component "Oracle Notification Service (ONS)" ... Node Name Port Number Protocol Available Status ---------------- ------------ ------------ ------------ ---------------- jftest 6200 TCP yes successful jftest 6100 TCP yes successful Verifying Port Availability for component "Oracle Notification Service (ONS)" ...PASSED Verifying Port Availability for component "Oracle Cluster Synchronization Services (CSSD)" ... Node Name Port Number Protocol Available Status ---------------- ------------ ------------ ------------ ---------------- jftest 42424 TCP yes successful Verifying Port Availability for component "Oracle Cluster Synchronization Services (CSSD)" ...PASSED Verifying Users With Same UID: 0 ...PASSED Verifying Current Group ID ...PASSED Verifying Root user consistency ... Node Name Status ------------------------------------ ------------------------ jftest passed Verifying Root user consistency ...PASSED Verifying Package: cvuqdisk-1.0.10-1 ... Node Name Available Required Status ------------ ------------------------ ------------------------ ---------- jftest cvuqdisk-1.0.10-1 cvuqdisk-1.0.10-1 passed Verifying Package: cvuqdisk-1.0.10-1 ...PASSED Verifying Host name ...PASSED Verifying Node Connectivity ... Verifying Hosts File ... Node Name Status ------------------------------------ ------------------------ jftest passed Verifying Hosts File ...PASSED Interface information for node "jftest" Name IP Address Subnet Gateway Def. Gateway HW Address MTU ------ --------------- --------------- --------------- --------------- ----------------- ------ bond0 10.227.62.9 10.227.62.0 0.0.0.0 10.227.62.1 58:F9:87:D3:01:20 1500 bond1.850 172.121.7.10 172.121.7.0 0.0.0.0 10.227.62.1 58:F9:87:D3:01:21 1500 bond1.860 172.121.7.142 172.121.7.128 0.0.0.0 10.227.62.1 58:F9:87:D3:01:21 1500 Check: MTU consistency of the subnet "10.227.62.0". Node Name IP Address Subnet MTU ---------------- ------------ ------------ ------------ ---------------- jftest bond0 10.227.62.9 10.227.62.0 1500 Check: MTU consistency of the subnet "172.121.7.0". Node Name IP Address Subnet MTU ---------------- ------------ ------------ ------------ ---------------- jftest bond1.850 172.121.7.10 172.121.7.0 1500 Check: MTU consistency of the subnet "172.121.7.128". Node Name IP Address Subnet MTU ---------------- ------------ ------------ ------------ ---------------- jftest bond1.860 172.121.7.142 172.121.7.128 1500 Verifying Check that maximum (MTU) size packet goes through subnet ...PASSED Verifying Node Connectivity ...PASSED Verifying Multicast or broadcast check ... Checking subnet "10.227.62.0" for multicast communication with multicast group "224.0.0.251" Verifying Multicast or broadcast check ...PASSED Verifying Network Time Protocol (NTP) ... Verifying '/etc/ntp.conf' ... Node Name File exists? ------------------------------------ ------------------------ jftest yes Verifying '/etc/ntp.conf' ...PASSED Verifying Network Time Protocol (NTP) ...FAILED (PRVG-1017) Verifying Same core file name pattern ...PASSED Verifying User Mask ... Node Name Available Required Comment ------------ ------------------------ ------------------------ ---------- jftest 0022 0022 passed Verifying User Mask ...PASSED Verifying User Not In Group "root": grid ... Node Name Status Comment ------------ ------------------------ ------------------------ jftest passed does not exist Verifying User Not In Group "root": grid ...PASSED Verifying Time zone consistency ...PASSED Verifying resolv.conf Integrity ... Node Name Status ------------------------------------ ------------------------ jftest failed Verifying resolv.conf Integrity ...FAILED (PRVF-5636, PRVG-2064) Verifying DNS/NIS name service ...PASSED Verifying Domain Sockets ...PASSED Verifying /boot mount ...PASSED Verifying Daemon "avahi-daemon" not configured and running ... Node Name Configured Status ------------ ------------------------ ------------------------ jftest no passed Node Name Running? Status ------------ ------------------------ ------------------------ jftest no passed Verifying Daemon "avahi-daemon" not configured and running ...PASSED Verifying Daemon "proxyt" not configured and running ... Node Name Configured Status ------------ ------------------------ ------------------------ jftest no passed Node Name Running? Status ------------ ------------------------ ------------------------ jftest no passed Verifying Daemon "proxyt" not configured and running ...PASSED Verifying User Equivalence ...PASSED Verifying RPM Package Manager database ...INFORMATION (PRVG-11250) Verifying /dev/shm mounted as temporary file system ...FAILED (PRVE-0421) Verifying File system mount options for path /var ...PASSED Verifying DefaultTasksMax parameter ...PASSED Verifying zeroconf check ...PASSED Verifying ASM Filter Driver configuration ...PASSED Pre-check for cluster services setup was unsuccessful on all the nodes. Failures were encountered during execution of CVU verification request "stage -pre crsinst". Verifying Package: compat-libstdc++-33-3.2.3 (x86_64) ...FAILED jftest: PRVF-7532 : Package "compat-libstdc++-33(x86_64)" is missing on node "jftest" Verifying Network Time Protocol (NTP) ...FAILED jftest: PRVG-1017 : NTP configuration file "/etc/ntp.conf" is present on nodes "jftest" on which NTP daemon or service was not running Verifying resolv.conf Integrity ...FAILED jftest: PRVF-5636 : The DNS response time for an unreachable node exceeded "15000" ms on following nodes: jftest jftest: PRVG-2064 : There are no configured name servers in the file '/etc/resolv.conf' on the nodes "jftest" Verifying RPM Package Manager database ...INFORMATION PRVG-11250 : The check "RPM Package Manager database" was not performed because it needs 'root' user privileges. Verifying /dev/shm mounted as temporary file system ...FAILED jftest: PRVE-0421 : No entry exists in /etc/fstab for mounting /dev/shm CVU operation performed: stage -pre crsinst Date: Mar 30, 2023 2:31:10 PM CVU home: /u01/app/19.3.0/grid/ User: grid复制
二十一、准备gi响应文件
[grid@zwtest ~]$ cat gi.rsp oracle.install.responseFileVersion=/oracle/install/rspfmt_crsinstall_response_schema_v19.0.0 INVENTORY_LOCATION=/u01/app/oraInventory oracle.install.option=HA_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.ClusterConfiguration=STANDALONE oracle.install.crs.config.configureAsExtendedCluster=false oracle.install.crs.config.gpnp.configureGNS=false oracle.install.crs.config.autoConfigureClusterNodeVIP=false oracle.install.crs.config.gpnp.gnsOption=CREATE_NEW_GNS oracle.install.crs.configureGIMR=false oracle.install.asm.configureGIMRDataDG=false oracle.install.crs.config.useIPMI=false oracle.install.asm.SYSASMPassword=oracle oracle.install.asm.diskGroup.name=DATA oracle.install.asm.diskGroup.redundancy=EXTERNAL oracle.install.asm.diskGroup.AUSize=4 oracle.install.asm.diskGroup.disks=/dev/asmdisk/asmdiskf oracle.install.asm.diskGroup.diskDiscoveryString=/dev/asmdisk/asmdisk* oracle.install.asm.monitorPassword=oracle oracle.install.asm.configureAFD=false 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复制
二十二、静默安装gi
[grid@jftest ~]$ $ORACLE_HOME/gridSetup.sh -silent -responseFile /home/grid/gi.rsp Launching Oracle Grid Infrastructure Setup Wizard... [WARNING] [INS-30543] Installer has detected that one or more of the selected disk(s) is of size larger than 2 terabyte(TB). Because of this, the Oracle Database compatibility level (COMPATIBLE.RDBMS attribute) of the diskgroup (DATA) will be set to 12.1. This means that, in order to use the diskgroup for data storage, the COMPATIBLE initialization parameter of the Oracle Database should be greater than or equal to 12.1. CAUSE: The following disks are of size larger than 2 terabyte(TB): [/dev/asmdisk/asmdiskf] [WARNING] [INS-13014] Target environment does not meet some optional requirements. CAUSE: Some of the optional prerequisites are not met. See logs for details. gridSetupActions2023-03-30_02-34-54PM.log ACTION: Identify the list of failed prerequisite checks from the log: gridSetupActions2023-03-30_02-34-54PM.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.0/grid/install/response/grid_2023-03-30_02-34-54PM.rsp You can find the log of this install session at: /tmp/GridSetupActions2023-03-30_02-34-54PM/gridSetupActions2023-03-30_02-34-54PM.log As a root user, execute the following script(s): 1. /u01/app/oraInventory/orainstRoot.sh 2. /u01/app/19.3.0/grid/root.sh Execute /u01/app/19.3.0/grid/root.sh on the following nodes: [jftest] Successfully Setup Software with warning(s). As install user, execute the following command to complete the configuration. /u01/app/19.3.0/grid/gridSetup.sh -executeConfigTools -responseFile /home/grid/gi.rsp [-silent] Moved the install session logs to: /u01/app/oraInventory/logs/GridSetupActions2023-03-30_02-34-54PM [grid@jftest ~]$ exit logout You have mail in /var/spool/mail/root [root@jftest rpm]# /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@jftest rpm]# /u01/app/19.3.0/grid/root.sh Check /u01/app/19.3.0/grid/install/root_jftest_2023-03-30_14-37-17-359522824.log for the output of root script You have mail in /var/spool/mail/root [root@jftest rpm]# su - grid Last login: Thu Mar 30 14:39:24 CST 2023 on pts/0 [grid@jftest ~]$ /u01/app/19.3.0/grid/gridSetup.sh -executeConfigTools -responseFile /home/grid/gi.rsp -silent Launching Oracle Grid Infrastructure Setup Wizard... You can find the logs of this session at: /u01/app/oraInventory/logs/GridSetupActions2023-03-30_02-39-38PM You can find the log of this install session at: /u01/app/oraInventory/logs/UpdateNodeList2023-03-30_02-39-38PM.log Successfully Configured Software.复制
二十三、调整磁盘组
SQL> select name,path from v$asm_disk; NAME PATH ------------------------------ ------------------------------- /dev/asmdisk/asmdiskb /dev/asmdisk/asmdiskh /dev/asmdisk/asmdiskg /dev/asmdisk/asmdiskc /dev/asmdisk/asmdiskd /dev/asmdisk/asmdiskk /dev/asmdisk/asmdiskj /dev/asmdisk/asmdiske DATA_0000 /dev/asmdisk/asmdiskf 10 rows selected. SQL> alter diskgroup DATA add disk '/dev/asmdisk/asmdiski','/dev/asmdisk/asmdiskb','/dev/asmdisk/asmdiskh','/dev/asmdisk/asmdiskg','/dev/asmdisk/asmdiskc','/dev/asmdisk/asmdiskd'; Diskgroup altered. SQL> alter diskgroup DATA add disk '/dev/asmdisk/asmdiskk','/dev/asmdisk/asmdiskj','/dev/asmdisk/asmdiske'; Diskgroup altered. SQL> set lines 300 pages 300 SQL> select GROUP_NUMBER,NAME,TOTAL_MB/1024 total_GB,FREE_MB/1024 free_GB,USABLE_FILE_MB/1024 usable_GB from v$asm_diskgroup; GROUP_NUMBER NAME TOTAL_GB FREE_GB USABLE_GB ------------ ------------------------------ ---------- ---------- ---------- 1 DATA 20480 20479.7188 20479.7188复制
二十四、准备db相应文件
[oracle@jftest ~]$ cat db.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_HOME=/u01/app/oracle/product/19.3.0/db_1 ORACLE_BASE=/u01/app/oracle 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=dba oracle.install.db.rootconfig.executeRootScript=false oracle.install.db.config.starterdb.type=GENERAL_PURPOSE oracle.install.db.config.starterdb.memoryOption=false oracle.install.db.config.starterdb.installExampleSchemas=false oracle.install.db.config.starterdb.managementOption=DEFAULT oracle.install.db.config.starterdb.enableRecovery=false复制
二十五、安装db
[oracle@jftest db_1]$ ./runInstaller -silent -responseFile /home/oracle/db.rsp -skipPrereqs Launching Oracle Database Setup Wizard... The response file for this session can be found at: /u01/app/oracle/product/19.3.0/db_1/install/response/db_2023-03-30_02-54-15PM.rsp You can find the log of this install session at: /u01/app/oraInventory/logs/InstallActions2023-03-30_02-54-15PM/installActions2023-03-30_02-54-15PM.log As a root user, execute the following script(s): 1. /u01/app/oracle/product/19.3.0/db_1/root.sh Execute /u01/app/oracle/product/19.3.0/db_1/root.sh on the following nodes: [jftest] Successfully Setup Software. [root@jftest rpm]# /u01/app/oracle/product/19.3.0/db_1/root.sh Check /u01/app/oracle/product/19.3.0/db_1/install/root_jftest_2023-03-30_14-55-54-821335761.log for the output of root script复制
二十六、准备数据库响应文件
[oracle@zwtest ~]$ cat dbca.rsp responseFileVersion=/oracle/assistants/rspfmt_dbca_response_schema_v19.0.0 gdbName=orcl sid=orcl databaseConfigType=SI policyManaged=FALSE createServerPool=FALSE serverPoolName= createAsContainerDatabase=false templateName=/u01/app/oracle/product/19.3.0/db_1/assistants/dbca/templates/General_Purpose.dbc sysPassword=oracle systemPassword=oracle runCVUChecks=true dbsnmpPassword=oracle dvConfiguration=False olsConfiguration=False datafileJarLocation=/u01/app/oracle/product/19.3.0/db_1/assistants/dbca/templates/ datafileDestination=DATA storageType=ASM diskGroupName=DATA asmsnmpPassword=oracle recoveryGroupName=DATA characterSet=ZHS16GBK nationalCharacterSet=AL16UTF16 registerWithDirService=FALSE listeners=LISTENER sampleSchema=FALSE memoryPercentage=50 databaseType=MULTIPURPOSE automaticMemoryManagement=FALSE dbsnmpPassword=oracle复制
二十七、创建数据库
[oracle@jftest ~]$ dbca -silent -createDatabase -responseFile /home/oracle/dbca.rsp Prepare for db operation 10% complete Registering database with Oracle Restart 14% complete Copying database files 43% complete Creating and starting Oracle instance 45% complete 49% complete 53% complete 56% complete 62% complete Completing Database Creation 68% complete 70% complete 71% complete Executing Post Configuration Actions 100% complete Database creation complete. For details check the logfiles at: /u01/app/oracle/cfgtoollogs/dbca/orcl. Database Information: Global Database Name:orcl System Identifier(SID):orcl Look at the log file "/u01/app/oracle/cfgtoollogs/dbca/orcl/orcl.log" for further details.复制
二十八、数据库改名
SQL> shutdown immediate Database closed. Database dismounted. ORACLE instance shut down. SQL> startup mount; ORACLE instance started. Total System Global Area 5.3687E+10 bytes Fixed Size 30164616 bytes Variable Size 4.2681E+10 bytes Database Buffers 1.0737E+10 bytes Redo Buffers 238268416 bytes Database mounted. SQL> exit Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.3.0.0.0 [oracle@zwtest ~]$ nid target=sys/oracle DBNAME=orcl2 DBNEWID: Release 19.0.0.0.0 - Production on Thu Mar 30 15:20:08 2023 Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved. Connected to database orcl (DBID=2901896013) Connected to server version 19.3.0 Control Files in database: +DATA/orcl/CONTROLFILE/current.262.1132833165 +DATA/orcl/CONTROLFILE/current.261.1132833165 Change database ID and database name orcl to orcl2? (Y/[N]) => y Proceeding with operation Changing database ID from 2901896013 to 1522736040 Changing database name from orcl to orcl2 Control File +DATA/orcl/CONTROLFILE/current.262.1132833165 - modified Control File +DATA/orcl/CONTROLFILE/current.261.1132833165 - modified Datafile +DATA/orcl/DATAFILE/system.257.113283302 - dbid changed, wrote new name Datafile +DATA/orcl/DATAFILE/sysaux.258.113283307 - dbid changed, wrote new name Datafile +DATA/orcl/DATAFILE/undotbs1.259.113283309 - dbid changed, wrote new name Datafile +DATA/orcl/DATAFILE/users.260.113283310 - dbid changed, wrote new name Datafile +DATA/orcl/TEMPFILE/temp.269.113283317 - dbid changed, wrote new name Control File +DATA/orcl/CONTROLFILE/current.262.1132833165 - dbid changed, wrote new name Control File +DATA/orcl/CONTROLFILE/current.261.1132833165 - dbid changed, wrote new name Instance shut down Database name changed to orcl2. Modify parameter file and generate a new password file before restarting. Database ID for database orcl2 changed to 1522736040. All previous backups and archived redo logs for this database are unusable. Database is not aware of previous backups and archived logs in Recovery Area. Database has been shutdown, open database with RESETLOGS option. Succesfully changed database name and ID. DBNEWID - Completed succesfully.复制
二十九、启动新库
[oracle@zwtest ~]$ echo $ORACLE_SID orcl2 [oracle@zwtest ~]$ ss SQL*Plus: Release 19.0.0.0.0 - Production on Thu Mar 30 15:23:20 2023 Version 19.3.0.0.0 Copyright (c) 1982, 2019, Oracle. All rights reserved. Connected to an idle instance. SQL> startup pfile='/home/oracle/jfpfile'; ORA-09925: Unable to create audit trail file Linux-x86_64 Error: 2: No such file or directory Additional information: 9925 [oracle@zwtest ~]$ mkdir /u01/app/oracle/admin/orcl2/adump [oracle@zwtest ~]$ ss SQL*Plus: Release 19.0.0.0.0 - Production on Thu Mar 30 15:25:03 2023 Version 19.3.0.0.0 Copyright (c) 1982, 2019, Oracle. All rights reserved. Connected to an idle instance. SQL> startup pfile='/home/oracle/jfpfile'; ORACLE instance started. Total System Global Area 5.3687E+10 bytes Fixed Size 30164616 bytes Variable Size 4.2681E+10 bytes Database Buffers 1.0737E+10 bytes Redo Buffers 238268416 bytes Database mounted. ORA-01589: must use RESETLOGS or NORESETLOGS option for database open SQL> alter database open resetlogs; Database altered.复制
三十、删除数据库
[oracle@zwtest ~]$ export ORACLE_SID=zwdbb [oracle@zwtest ~]$ ss SQL*Plus: Release 19.0.0.0.0 - Production on Thu Mar 30 15:27:40 2023 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> shutdown immediate Database closed. Database dismounted. ORACLE instance shut down. SQL> startup mount exclusive restrict; ORACLE instance started. Total System Global Area 5.3687E+10 bytes Fixed Size 30164616 bytes Variable Size 4.2681E+10 bytes Database Buffers 1.0737E+10 bytes Redo Buffers 238268416 bytes Database mounted. SQL> alter system enable restricted session; System altered. SQL> drop database; Database dropped. Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.3.0.0.0 SQL>复制
最后修改时间：2023-04-05 09:52:12
「喜欢这篇文章，您的关注和赞赏是给作者最好的鼓励」
关注作者
【版权声明】本文为墨天轮用户原创内容，转载时必须标注文章的来源（墨天轮），文章链接，文章作者等基本信息，否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容，欢迎发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。
评论
目录
