一、用户创建
[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
米乐app官网下载 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
米乐app官网下载 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
米乐app官网下载 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
米乐app官网下载 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
「喜欢这篇文章，您的关注和赞赏是给作者最好的鼓励」
关注作者
【米乐app官网下载的版权声明】本文为墨天轮用户原创内容，转载时必须标注文章的来源（墨天轮），文章链接，文章作者等基本信息，否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容，欢迎发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。