2. Check environment
2.1. Check physical memory:
[root@kindo-dev-03 ~]# grep MemTotal /proc/meminfo MemTotal: 16267584 kB
2.2. Check the exchange space:
[root@kindo-dev-03 ~]# grep SwapTotal /proc/meminfo SwapTotal: 8257532 kB
2.3. Inspection / tmp Directory:
[root@kindo-dev-03 ~]# df -k /tmp file system 1K-block Used Available used% Mount point /dev/mapper/centos-root 52403200 19115248 33287952 37% /
2. Free disk space check:
[root@kindo-dev3 ~]# df -k Filesystem 1K-blocks Used Available Use% Mounted on /dev/sda2 738582560 524725152 176332928 75% / tmpfs 8233208 4316304 3916904 53% /dev/shm /dev/sda1 1998672 72568 1821248 4% /boot /dev/sda3 51513972 76940 48813544 1% /home
2.5. Check the version of linux kernel:
[root@kindo-dev-03 ~]# uname -i x86_64 [root@kindo-dev-03 ~]# uname -r 3.10.0-693.el7.x86_64 [root@kindo-dev-03 ~]# uname -a Linux kindo-dev-03 3.10.0-693.el7.x86_64 #1 SMP Tue Aug 22 21:09:27 UTC 2017 x86_64 x86_64 x86_64 GNU/Linux
[root@kindo-dev-03 ~]# cat /proc/version Linux version 3.10.0-693.el7.x86_64 (builder@kbuilder.dev.centos.org) (gcc version 4.8.5 20150623 (Red Hat 4.8.5-16) (GCC) ) #1 SMP Tue Aug 22 21:09:27 UTC 2017
2.6. Check the linux system version:
lsb_release -a applies to all linux versions, including Centos, RedHat, SUSE, Debian etc.
Install first redhat-lsb: [root@kindo-dev-03 ~]# yum install -y redhat-lsb [root@kindo-dev-03 ~]# lsb_release -a LSB Version: :core-4.1-amd64:core-4.1-noarch:cxx-4.1-amd64:cxx-4.1-noarch:desktop-4.1-amd64:desktop-4.1-noarch:languages-4.1-amd64:languages-4.1-noarch:printing-4.1-amd64:printing-4.1-noarch Distributor ID: n/a Description: redhat-7 Release: n/a Codename: n/a
Cat / etc / Redhat release. This method is only suitable for Linux of Redhat system:
[root@kindo-dev-03 ~]# cat /etc/redhat-release redhat-7
cat /etc/issue:
[root@kindo-dev3 ~]# cat /etc/issue CentOS release 6.10 (Final) Kernel \r on an \m
2.7. cat /proc/cpuinfo(Linux checks cpu related information, including model, dominant frequency, kernel information, etc.):
[root@kindo-dev-03 ~]# cat /proc/cpuinfo processor : 0 vendor_id : GenuineIntel cpu family : 6 model : 85 model name : Intel(R) Xeon(R) Silver 4216 CPU @ 2.10GHz stepping : 7 microcode : 0x5002f01 cpu MHz : 2094.023 cache size : 22528 KB physical id : 0 siblings : 4 core id : 0 cpu cores : 4 apicid : 0 initial apicid : 0 fpu : yes fpu_exception : yes cpuid level : 22 wp : yes flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush dts mmx fxsr sse sse2 ss ht syscall nx pdpe1gb rdtscp lm constant_tsc arch_perfmon pebs bts nopl xtopology tsc_reliable nonstop_tsc eagerfpu pni pclmulqdq ssse3 fma cx16 pcid sse4_1 sse4_2 x2apic movbe popcnt tsc_deadline_timer aes xsave avx f16c rdrand hypervisor lahf_lm abm 3dnowprefetch fsgsbase tsc_adjust bmi1 hle avx2 smep bmi2 invpcid rtm rdseed adx smap xsaveopt arat bogomips : 4190.15 clflush size : 64 cache_alignment : 64 address sizes : 42 bits physical, 48 bits virtual power management:
3. Configure the installation environment
3.1 linux dependency packages required by various oracle versions (from the official oracle 11g document)
3.1.1,Operating System Requirements
The following operating system versions (or later) are required for Oracle Database 11g Release 2 (11.2):
On Linux x86: Asianux Server 3 SP2 Asianux Server 4 SP3 Oracle Linux 4 Update 7 Oracle Linux 5 Update 2 Oracle Linux 6 Red Hat Enterprise Linux 4 Update 7 Red Hat Enterprise Linux 5 Update 2 Red Hat Enterprise Linux 6 SUSE Linux Enterprise Server 10 SP2 SUSE Linux Enterprise Server 11 On Linux x86-64: Asianux Server 3 SP2 Asianux Server 4 SP3 Oracle Linux 4 Update 7 Oracle Linux 5 Update 2 (with Red Hat Compatible Kernel) Oracle Linux 5 Update 5 Oracle Linux 6 Oracle Linux 6 (with Red Hat Compatible Kernel) Oracle Linux 7 Oracle Linux 7 (with Red Hat Compatible Kernel) Red Hat Enterprise Linux 4 Update 7 Red Hat Enterprise Linux 5 Update 2 Red Hat Enterprise Linux 6 Red Hat Enterprise Linux 7 SUSE Linux Enterprise Server 10 SP2 SUSE Linux Enterprise Server 11 SUSE Linux Enterprise Server 12 SP1 NeoKylin Linux Advanced Server 6 NeoKylin Linux Advanced Server 7 On IBM: Linux on System z: Red Hat Enterprise Linux 7 Update 1 Red Hat Enterprise Linux 6 Update 2 Red Hat Enterprise Linux 4 Update 8 Red Hat Enterprise Linux 5 Update 4 SUSE Linux Enterprise Server 10 SP3 SUSE Linux Enterprise Server 11 SP1
3.1.2,Kernel Requirements
The following are the kernel requirements for Oracle Database 11g Release 2 (11.2):
For Linux x86: On Oracle Linux 4 and Red Hat Enterprise Linux 4 2.6.9 or later On Asianux Server 3, Oracle Linux 5, and Red Hat Enterprise Linux 5 2.6.18 or later On Oracle Linux 6 2.6.32.100 or later On Asianux Server 4 and Red Hat Enterprise Linux 6 2.6.32-71 or later On SUSE Linux Enterprise Server 10 2.6.16.21 or later On SUSE Linux Enterprise Server 11 2.6.27.19 or later For Linux x86-64: On Oracle Linux 4 and Red Hat Enterprise Linux 4 2.6.9 or later On Oracle Linux 5 Update 2 with Red Hat Compatible Kernel 2.6.18 or later On Oracle Linux 5 Update 5 with Red Hat Compatible Kernel 2.6.18 or later On Oracle Linux 5 Update 5 with Unbreakable Enterprise Kernel 2.6.32-100.0.19 or later On Oracle Linux 6 2.6.32-100.28.5.el6.x86_64 or later On Oracle Linux 6 with Red Hat Compatible Kernel 2.6.32-71.el6.x86_64 or later On Oracle Linux 7 3.8.13-33.el7uek.x86_64 or later On Oracle Linux 7 with Red Hat Compatible Kernel 3.10.0-54.0.1.el7.x86_64 or later On Red Hat Enterprise Linux 5 Update 2 2.6.18 or later On Red Hat Enterprise Linux 5 Update 5 2.6.18 or later On Red Hat Enterprise Linux 6 2.6.32-71.el6.x86_64 or later On Red Hat Enterprise Linux 7 3.10.0-54.0.1.el7.x86_64 or later On Asianux Server 3 2.6.18 or later On Asianux Server 4 2.6.32-71.el6.x86_64 or later On SUSE Linux Enterprise Server 10 2.6.16.21 or later On SUSE Linux Enterprise Server 11 2.6.27.19 or later On SUSE Linux Enterprise Server 12 3.12.49-11 or later On NeoKylin Linux Advanced Server 6 2.6.32-431.el6.x86_64 or later On NeoKylin Linux Advanced Server 7 3.10.0-327.el7.x86_64 or later For IBM: Linux On System z: On Red Hat Enterprise Linux 7 3.10.0-229.el7 or later On Red Hat Enterprise Linux 6 2.6.32-200 or later On Red Hat Enterprise Linux 4 2.6.9 or later On Red Hat Enterprise Linux 5 2.6.18 or later On SUSE Linux Enterprise Server 10 2.6.16.60 or later On SUSE Linux Enterprise Server 11 2.6.32.12 or later
3.1.3,Package Requirements
The following are the list of packages required for Oracle Database 11g Release 2 (11.2):
3.1.3.1,Oracle Database Package Requirements for Linux x86
The following packages (or later versions) must be installed.
3.1.3.1.1,Oracle Linux 4 and Red Hat Enterprise Linux 4
binutils-2.15.92.0.2 compat-libstdc++-33-3.2.3 elfutils-libelf-0.97 elfutils-libelf-devel-0.97 gcc-3.4.6 gcc-c++-3.4.6 glibc-2.3.4-2.41 glibc-common-2.3.4 glibc-devel-2.3.4 glibc-headers-2.3.4 libaio-devel-0.3.105 libaio-0.3.105 libgcc-3.4.6 libstdc++-3.4.6 libstdc++-devel-3.4.6 make-3.80 numactl-0.6.4.i386 pdksh-5.2.14 sysstat-5.0.5
3.1.3.1.2,Asianux Server 3, Oracle Linux 5, and Red Hat Enterprise Linux 5
binutils-2.17.50.0.6 compat-libstdc++-33-3.2.3 elfutils-libelf-0.125 elfutils-libelf-devel-0.125 elfutils-libelf-devel-static-0.125 gcc-4.1.2 gcc-c++-4.1.2 glibc-2.5-24 glibc-common-2.5 glibc-devel-2.5 glibc-headers-2.5 kernel-headers-2.6.18 ksh-20060214 libaio-0.3.106 libaio-devel-0.3.106 libgcc-4.1.2 libgomp-4.1.2 libstdc++-4.1.2 libstdc++-devel-4.1.2 make-3.81 sysstat-7.0.2
3.1.3.1.3,Oracle Linux 6, Red Hat Enterprise Linux 6 and Asianux Server 4
binutils-2.20.51.0.2-5.11.el6.i686 compat-libcap1-1.10-1.i686 compat-libstdc++-33-3.2.3-69.el6.i686 gcc-4.4.4-13.el6.i686 gcc-c++-4.4.4-13.el6.i686 glibc-2.12-1.7.el6.i686 glibc-devel-2.12-1.7.el6.i686 ksh libgcc-4.4.4-13.el6.i686 libstdc++-4.4.4-13.el6.i686 libstdc++-devel-4.4.4-13.el6.i686 libaio-0.3.107-10.el6.i686 libaio-devel-0.3.107-10.el6.i686 make-3.81-19.el6.i686 sysstat-9.0.4-11.el6.i686
3.1.3.1.4,SUSE Linux Enterprise Server 10
binutils-2.16.91.0.5 compat-libstdc++-5.0.7 gcc-4.1.2 gcc-c++-4.1.2 glibc-2.4-31.63 glibc-devel-2.4-31.63 ksh-93r-12.9 libaio-0.3.104 libaio-devel-0.3.104 libelf-0.8.5 libgcc-4.1.2 libstdc++-4.1.2 libstdc++-devel-4.1.2 make-3.80 sysstat-8.0.4
3.1.3.1.5,SUSE Linux Enterprise Server 11
binutils-2.19 gcc-4.3 gcc-c++-4.3 glibc-2.9 glibc-devel-2.9 ksh-93t libstdc++33-3.3.3 libstdc++43-4.3.3_20081022 libstdc++43-devel-4.3.3_20081022 libaio-0.3.104 libaio-devel-0.3.104 libgcc43-4.3.3_20081022 libstdc++-devel-4.3 make-3.81 sysstat-8.1.5
3.1.3.2,Oracle Database Package Requirements for Linux x86-64
The following packages (or later versions) must be installed.
3.1.3.2.1,Oracle Linux 4 and Red Hat Enterprise Linux 4
binutils-2.15.92.0.2 compat-libstdc++-33-3.2.3 compat-libstdc++-33-3.2.3 (32 bit) elfutils-libelf-0.97 elfutils-libelf-devel-0.97 expat-1.95.7 gcc-3.4.6 gcc-c++-3.4.6 glibc-2.3.4-2.41 glibc-2.3.4-2.41 (32 bit) glibc-common-2.3.4 glibc-devel-2.3.4 glibc-headers-2.3.4 libaio-0.3.105 libaio-0.3.105 (32 bit) libaio-devel-0.3.105 libaio-devel-0.3.105 (32 bit) libgcc-3.4.6 libgcc-3.4.6 (32-bit) libstdc++-3.4.6 libstdc++-3.4.6 (32 bit) libstdc++-devel 3.4.6 make-3.80 numactl-0.6.4.x86_64 pdksh-5.2.14 sysstat-5.0.5
3.1.3.2.2,Oracle Linux 5, Red Hat Enterprise Linux 5, and Asianux Server 3
binutils-2.17.50.0.6 compat-libstdc++-33-3.2.3 compat-libstdc++-33-3.2.3 (32 bit) coreutils-5.97-23.el5_4.1 elfutils-libelf-0.125 elfutils-libelf-devel-0.125 gcc-4.1.2 gcc-c++-4.1.2 glibc-2.5-24 glibc-2.5-24 (32 bit) glibc-common-2.5 glibc-devel-2.5 glibc-devel-2.5 (32 bit) glibc-headers-2.5 ksh-20060214 libaio-0.3.106 libaio-0.3.106 (32 bit) libaio-devel-0.3.106 libaio-devel-0.3.106 (32 bit) libgcc-4.1.2 libgcc-4.1.2 (32 bit) libstdc++-4.1.2 libstdc++-4.1.2 (32 bit) libstdc++-devel-4.1.2 make-3.81 sysstat-7.0.2
3.1.3.2.3,Oracle Linux 6, Red Hat Enterprise Linux 6, and Asianux Server 4
binutils-2.20.51.0.2-5.11.el6 (x86_64) compat-libcap1-1.10-1 (x86_64) compat-libstdc++-33-3.2.3-69.el6 (x86_64) compat-libstdc++-33-3.2.3-69.el6.i686 gcc-4.4.4-13.el6 (x86_64) gcc-c++-4.4.4-13.el6 (x86_64) glibc-2.12-1.7.el6 (i686) glibc-2.12-1.7.el6 (x86_64) glibc-devel-2.12-1.7.el6 (x86_64) glibc-devel-2.12-1.7.el6.i686 ksh libgcc-4.4.4-13.el6 (i686) libgcc-4.4.4-13.el6 (x86_64) libstdc++-4.4.4-13.el6 (x86_64) libstdc++-4.4.4-13.el6.i686 libstdc++-devel-4.4.4-13.el6 (x86_64) libstdc++-devel-4.4.4-13.el6.i686 libaio-0.3.107-10.el6 (x86_64) libaio-0.3.107-10.el6.i686 libaio-devel-0.3.107-10.el6 (x86_64) libaio-devel-0.3.107-10.el6.i686 make-3.81-19.el6 sysstat-9.0.4-11.el6 (x86_64)
3.1.3.2.4,Oracle Linux 7 and Red Hat Enterprise Linux 7
binutils-2.23.52.0.1-12.el7.x86_64 compat-libcap1-1.10-3.el7.x86_64 compat-libstdc++-33-3.2.3-71.el7.i686 compat-libstdc++-33-3.2.3-71.el7.x86_64 gcc-4.8.2-3.el7.x86_64 gcc-c++-4.8.2-3.el7.x86_64 glibc-2.17-36.el7.i686 glibc-2.17-36.el7.x86_64 glibc-devel-2.17-36.el7.i686 glibc-devel-2.17-36.el7.x86_64 ksh libaio-0.3.109-9.el7.i686 libaio-0.3.109-9.el7.x86_64 libaio-devel-0.3.109-9.el7.i686 libaio-devel-0.3.109-9.el7.x86_64 libgcc-4.8.2-3.el7.i686 libgcc-4.8.2-3.el7.x86_64 libstdc++-4.8.2-3.el7.i686 libstdc++-4.8.2-3.el7.x86_64 libstdc++-devel-4.8.2-3.el7.i686 libstdc++-devel-4.8.2-3.el7.x86_64 libXi-1.7.2-1.el7.i686 libXi-1.7.2-1.el7.x86_64 libXtst-1.2.2-1.el7.i686 libXtst-1.2.2-1.el7.x86_64 make-3.82-19.el7.x86_64 sysstat-10.1.5-1.el7.x86_64
3.1.3.2.5,SUSE Linux Enterprise Server 10
binutils-2.16.91.0.5 compat-libstdc++-5.0.7 gcc-4.1.0 gcc-c++-4.1.2 glibc-2.4-31.63 glibc-devel-2.4-31.63 glibc-devel-32bit-2.4-31.63 ksh-93r-12.9 libaio-0.3.104 libaio-32bit-0.3.104 libaio-devel-0.3.104 libaio-devel-32bit-0.3.104 libelf-0.8.5 libgcc-4.1.2 libstdc++-4.1.2 libstdc++-devel-4.1.2 make-3.80 numactl-0.9.6.x86_64 sysstat-8.0.4
3.1.3.2.6,SUSE Linux Enterprise Server 11
binutils-2.19 gcc-4.3 gcc-32bit-4.3 gcc-c++-4.3 glibc-2.9 glibc-32bit-2.9 glibc-devel-2.9 glibc-devel-32bit-2.9 ksh-93t libaio-0.3.104 libaio-32bit-0.3.104 libaio-devel-0.3.104 libaio-devel-32bit-0.3.104 libstdc++33-3.3.3 libstdc++33-32bit-3.3.3 libstdc++43-4.3.3_20081022 libstdc++43-32bit-4.3.3_20081022 libstdc++43-devel-4.3.3_20081022 libstdc++43-devel-32bit-4.3.3_20081022 libgcc43-4.3.3_20081022 libstdc++-devel-4.3 make-3.81 sysstat-8.1.5
3.1.3.2.7,SUSE Linux Enterprise Server 12
You must download and install patch 18370031.
binutils-2.25.0-13.1 gcc-4.8-6.189 gcc48-4.8.5-24.1 glibc-2.19-31.9 glibc-32bit-2.19-31.9 glibc-devel-2.19-31.9.x86_64 glibc-devel-32bit-2.19-31.9.x86_64 libaio1-0.3.109-17.15 libaio-devel-0.3.109-17.15 libcap1-1.10-59.61 libstdc++48-devel-4.8.5-24.1.x86_64 libstdc++48-devel-32bit-4.8.5-24.1.x86_64 libstdc++6-5.2.1+r226025-4.1.x86_64 libstdc++6-32bit-5.2.1+r226025-4.1.x86_64 libstdc++-devel-4.8-6.189.x86_64 libstdc++-devel-32bit-4.8-6.189.x86_64 libgcc_s1-5.2.1+r226025-4.1.x86_64 libgcc_s1-32bit-5.2.1+r226025-4.1.x86_64 mksh-50-2.13 make-4.0-4.1.x86_64 sysstat-10.2.1-3.1.x86_64 xorg-x11-driver-video-7.6_1-14.30.x86_64 xorg-x11-server-7.6_1.15.2-36.21.x86_64 xorg-x11-essentials-7.6_1-14.17.noarch xorg-x11-Xvnc-1.4.3-7.2.x86_64 xorg-x11-fonts-core-7.6-29.45.noarch xorg-x11-7.6_1-14.17.noarch xorg-x11-server-extra-7.6_1.15.2-36.21.x86_64 xorg-x11-libs-7.6-45.14.noarch xorg-x11-fonts-7.6-29.45.noarch
3.1.3.2.8,NeoKylin Linux Advanced Server 6
binutils-2.20.51.0.2-5.36.el6 (x86_64) compat-libcap1-1.10-1 (x86_64) compat-libstdc++-33-3.2.3-69.el6 (x86_64) compat-libstdc++-33-3.2.3-69.el6 (i686) gcc-4.4.7-4.el6 (x86_64) gcc-c++-4.4.7-4.el6 (x86_64) glibc-2.12-1.132.el6 (i686) glibc-2.12-1.132.el6 (x86_64) glibc-devel-2.12-1.132.el6 (x86_64) glibc-devel-2.12-1.132.el6 (i686) ksh libgcc-4.4.7-4.el6 (i686) libgcc-4.4.7-4.el6 (x86_64) libstdc++-4.4.7-4.el6 (x86_64) libstdc++-4.4.7-4.el6 (i686) libstdc++-devel-4.4.7-4.el6 (x86_64) libstdc++-devel-4.4.7-4.el6 (i686) libaio-0.3.107-10.el6 (x86_64) libaio-0.3.107-10.el6 (i686) libaio-devel-0.3.107-10.el6 (x86_64) libaio-devel-0.3.107-10.el6 (i686) make-3.81-20.el6 sysstat-9.0.4-22.el6 (x86_64)
3.1.3.2.9,NeoKylin Linux Advanced Server 7
binutils-2.23.52.0.1-55.el7.x86_64 compat-libcap1-1.10-7.el7.x86_64 gcc-4.8.5-4.el7.ns7.01.x86_64 gcc-c++-4.8.5-4.el7.ns7.01.x86_64 glibc-2.17-105.el7.ns7.01.i686 glibc-2.17-105.el7.ns7.01.x86_64 glibc-devel-2.17-105.el7.ns7.01.i686 glibc-devel-2.17-105.el7.ns7.01.x86_64 ksh-20120801-22.el7_1.2.x86_64 libaio-0.3.109-13.el7.i686 libaio-0.3.109-13.el7.x86_64 libaio-devel-0.3.109-13.el7.i686 libaio-devel-0.3.109-13.el7.x86_64 libgcc-4.8.5-4.el7.ns7.01.i686 libgcc-4.8.5-4.el7.ns7.01.x86_64 libstdc++-4.8.5-4.el7.ns7.01.i686 libstdc++-4.8.5-4.el7.ns7.01.x86_64 libstdc++-devel-4.8.5-4.el7.ns7.01.i686 libstdc++-devel-4.8.5-4.el7.ns7.01.x86_64 libXi-1.7.4-2.el7.i686 libXi-1.7.4-2.el7.x86_64 libXtst-1.2.2-2.1.el7.i686 libXtst-1.2.2-2.1.el7.x86_64 make-3.82-21.el7.x86_64 sysstat-10.1.5-7.el7.x86_64
3.2. Installation dependency package
3.2.1. Refer to the dependent packages required by various versions of oracle in 3.1. The following commands are applicable for installation:
[root@kindo-dev-03 ~]# yum -y install binutils* compat-libcap1* compat-libstdc++* gcc* gcc-c++* glibc* glibc-devel* ksh* libaio* libaio-devel* libgcc* libstdc++* libstdc++-devel* libXi* libXtst* make* sysstat* elfutils* unixODBC*
Sometimes, when installing using yum, you will be prompted that another app is currently holding the yum lock. At this time, open another terminal and enter it under root
#rm -f /var/run/yum.pid
Force shutdown of yum process
3,2,2. You can also use the following command to check whether the dependent packages have been installed. If not, you need to install the dependent packages one by one from iso
Not installed: [root@localhost Packages]# rpm -qa|grep compat-libcap1- [root@localhost Packages]# Installed: [root@localhost Packages]# rpm -qa|grep compat-libcap1- compat-libcap1-1.10-7.el7.x86_64 [root@localhost Packages]#
3,2,3. If some packages are not found in iso, you can download them directly from the Internet and install them
To install compat libstdc + + - 33-3.2.3-71 el7. x86_ Take package 64 as an example:
[root@radhat7 Packages]# ls -al|grep compat-lib -r--r--r--. 1641 root root 19428 4 month 1 2014 compat-libcap1-1.10-7.el7.i686.rpm -r--r--r--. 1641 root root 19164 4 month 1 2014 compat-libcap1-1.10-7.el7.x86_64.rpm -r--r--r--. 1610 root root 290948 10 month 6 2015 compat-libcogl12-1.14.0-3.el7.i686.rpm -r--r--r--. 1610 root root 288408 10 month 6 2015 compat-libcogl12-1.14.0-3.el7.x86_64.rpm ...slightly [root@radhat7 ~]# wget http://mirrors.163.com/centos/7/os/x86_64/Packages/compat-libstdc%2b%2b-33-3.2.3-72.el7.x86_64.rpm --2020-08-27 11:04:01-- http://mirrors.163.com/centos/7/os/x86_64/Packages/compat-libstdc%2b%2b-33-3.2.3-72.el7.x86_64.rpm Resolving host mirrors.163.com (mirrors.163.com)... 59.111.0.251 on connection mirrors.163.com (mirrors.163.com)|59.111.0.251|:80... Connected. Issued HTTP Request, waiting for response... 200 OK Length:195388 (191K) [application/x-redhat-package-manager] Saving to: "compat-libstdc++-33-3.2.3-72.el7.x86_64.rpm" 100%[=======================================================================================================>] 195,388 --.-K/s Time use 0.1s 2020-08-27 11:04:01 (1.52 MB/s) - Saved“ compat-libstdc++-33-3.2.3-72.el7.x86_64.rpm" [195388/195388]) [root@radhat7 ~]# rpm -ivh compat-libstdc++-33-3.2.3-72.el7.x86_64.rpm Warning: compat-libstdc++-33-3.2.3-72.el7.x86_64.rpm: head V3 RSA/SHA256 Signature, secret key ID f4a80eb5: NOKEY In preparation... ################################# [100%] Upgrading/install... 1:compat-libstdc++-33-3.2.3-72.el7 ################################# [100%] [root@radhat7 ~]# rm compat-libstdc++-33-3.2.3-72.el7.x86_64.rpm rm: Delete normal file "compat-libstdc++-33-3.2.3-72.el7.x86_64.rpm"？yes [root@radhat7 ~]# ls
3.2.4. Use rpm to install the missing dependency package
[root@localhost Packages]# rpm -ivh ksh-20120801-19.el7.x86_64.rpm Warning: ksh-20120801-19.el7.x86_64.rpm: head V3 RSA/SHA256 Signature, secret key ID fd431d51: NOKEY In preparation... ################################# [100%] Upgrading/install... 1:ksh-20120801-19.el7 ################################# [100%] [root@localhost Packages]#
3.2.5. Uninstall the installed dependent packages (take yum as an example)
Check first yum Installed: [root@redhat7 ~]# rpm -qa |grep yum yum-3.4.3-154.el7.noarch PackageKit-yum-1.1.5-1.el7.x86_64 yum-utils-1.1.31-42.el7.noarch yum-metadata-parser-1.1.4-10.el7.x86_64 yum-rhn-plugin-2.0.1-9.el7.noarch yum-langpacks-0.4.2-7.el7.noarch Delete the corresponding yum Package: [root@redhat7 ~]# rpm -qa|grep yum|xargs rpm -e --nodeps Warning:/etc/yum/pluginconf.d/langpacks.conf Saved as /etc/yum/pluginconf.d/langpacks.conf.rpmsave [root@redhat7 ~]# rpm -qa |grep yum [root@redhat7 ~]#
4. Turn off the firewall
1 [root@localhost data]# systemctl status firewalld.service #View firewall status (running) 2 ● firewalld.service - firewalld - dynamic firewall daemon 3 Loaded: loaded (/usr/lib/systemd/system/firewalld.service; enabled; vendor preset: enabled) 4 Active: active (running) since Wed 2017-09-13 09:23:08 CST; 25min ago 5 Docs: man:firewalld(1) 6 Main PID: 641 (firewalld) 7 CGroup: /system.slice/firewalld.service 8 └─641 /usr/bin/python -Es /usr/sbin/firewalld --nofork --nopid 9 10 Sep 13 09:22:58 localhost.localdomain systemd[1]: Starting firewalld - dynami... 11 Sep 13 09:23:08 localhost.localdomain systemd[1]: Started firewalld - dynamic... 12 Hint: Some lines were ellipsized, use -l to show in full. 13 [root@localhost data]# systemctl stop firewalld.service #Turn off the firewall 14 [root@localhost data]# systemctl status firewalld.service #View firewall status (closed) 15 ● firewalld.service - firewalld - dynamic firewall daemon 16 Loaded: loaded (/usr/lib/systemd/system/firewalld.service; enabled; vendor preset: enabled) 17 Active: inactive (dead) since Wed 2017-09-13 09:48:55 CST; 10s ago 18 Docs: man:firewalld(1) 19 Process: 641 ExecStart=/usr/sbin/firewalld --nofork --nopid $FIREWALLD_ARGS (code=exited, status=0/SUCCESS) 20 Main PID: 641 (code=exited, status=0/SUCCESS) 21 22 Sep 13 09:22:58 localhost.localdomain systemd[1]: Starting firewalld - dynami... 23 Sep 13 09:23:08 localhost.localdomain systemd[1]: Started firewalld - dynamic... 24 Sep 13 09:48:54 localhost.localdomain systemd[1]: Stopping firewalld - dynami... 25 Sep 13 09:48:55 localhost.localdomain systemd[1]: Stopped firewalld - dynamic... 26 Hint: Some lines were ellipsized, use -l to show in full. 27 [root@localhost data]# systemctl disable firewalld.service #Prohibit the use of firewall (restart is also prohibited) 28 Removed symlink /etc/systemd/system/dbus-org.fedoraproject.FirewallD1.service. 29 Removed symlink /etc/systemd/system/basic.target.wants/firewalld.service.
5. If it is Centos, you need to modify the OS system ID to redhat
(oracle does not support CentOS system installation by default, but CentOS is actually redhat)
1 [root@localhost data]# cat /proc/version 2 Linux version 3.10.0-514.26.2.el7.x86_64 (builder@kbuilder.dev.centos.org) (gcc version 4.8.5 20150623 (Red Hat 4.8.5-11) (GCC) ) #1 SMP Tue Jul 4 15:04:05 UTC 2017 3 [root@localhost data]# cat /etc/redhat-release 4 CentOS Linux release 7.3.1611 (Core) 5 [root@localhost data]# vi /etc/redhat-release #CentOS Linux release 7.3.1611 (Core)Change to redhat-7 6 [root@localhost data]# cat /etc/redhat-release 7 redhat-7
6. Close selinux (restart to take effect)
[oracle@kindo-dev-03 ~]$ vi /etc/selinux/config
Modified results:
You can also modify it directly with the following command:
1 [root@radhat7 etc]# cp /etc/selinux/config /etc/selinux/config.bak 2 [root@radhat7 selinux]# sed -i "s/SELINUX=enforcing/SELINUX=disabled/" /etc/selinux/config 3 [root@radhat7 selinux]# setenforce 0
7. Modify hostname and hosts
[oracle@kindo-dev-03 ~]$ cat /etc/hostname kindo-dev-03 [oracle@kindo-dev-03 ~]$ cat /etc/hosts 127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4 ::1 localhost localhost.localdomain localhost6 localhost6.localdomain6 192.168.1.181 kindo-dev-03
8. Configuration before ORACLE installation
8.1. Create system users and user groups running oracle Database
1 [root@localhost]# groupadd oinstall #Create user group oinstall 2 [root@localhost]# groupadd dba #Create user group dba 3 [root@localhost]# useradd -g oinstall -g dba -m oracle #Create an oracle user and join the oinstall and dba user groups 4 [root@localhost]# passwd oracle #Login password cannot be set in oracle graphical login interface 5 Changing password for user oracle. 6 New password: # password 7 BAD PASSWORD: The password is shorter than 8 characters 8 Retype new password: # Confirm password 9 passwd: all authentication tokens updated successfully. 10 [root@localhost]# id oracle # View new oracle users 11 uid=1001(oracle) gid=1002(dba) groups=1002(dba)
8.2. Create oracle database installation directory
1 [root@kindo-dev-03]# cd /. #Enter the root directory 2 [root@kindo-dev-03]# mkdir -p /u01/app/oracle #oracle database installation directory 3 [root@kindo-dev-03]# mkdir -p /u01/app/oraInventory #oracle database configuration file directory 4 [root@kindo-dev-03]# mkdir -p /u01/app/database #oracle directory decompression software package 5 [root@kindo-dev-03]# cd /u01 6 [root@kindo-dev-03 u01]# ls #Check after creation 7 database oracle oraInventory 8 [root@kindo-dev-03 u01]# chown -R oracle:oinstall /u01 #Set the directory owner to the oracle user of the oinstall user group 9 [root@kindo-dev-03 u01]#
8.3. Configure user's environment variables
Add the following environment variables (note that the original PATH variable should be commented out):
1 export ORACLE_BASE=/u01/app/oracle #oracle database installation directory 2 export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1 #oracle database path 3 export PATH=$PATH:$HOME/bin:$ORACLE_HOME/bin #Add system environment variable 4 export ORACLE_SID=orcl #oracle startup database instance name 5 export ORACLE_PID=orcl 6 #export ORACLE_TERM=xterm #xterm window mode installation 7 #export LANG=C #Prevent garbled code during installation 8 export NLS_LANG=AMERICAN_AMERICA.AL32UTF8 #The Oracle client character set must be consistent with the character set set set during Oracle installation 9 export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/usr/lib #Add system environment variable
1 [oracle@kindo-dev-03 ~]$ env | grep ORA #Check whether the environment variable is completed 2 ORACLE_SID=orcl 3 ORACLE_BASE=/u01/app/oracle 4 ORACLE_PID=orcl 5 ORACLE_HOME=/u01/app/oracle/product/11.2.0/db_1
The environment variable takes effect by using the following command:
[root@localhost data]# source /home/oracle/.bash_profile
8.4. Modify the kernel parameter / etc / sysctl conf
#After modifying the parameters, you can allow linux to read large files. For example, the oracle file is very large, which may be limited by linux parameters and cannot be installed. At this time, you can modify it according to the following parameters
After modification, the following commands can be used to make the parameters take effect:
[root@localhost data]# sysctl -p
Generally, the following parameters can be added:
1 fs.aio-max-nr = 1048576 2 fs.file-max = 6815744 3 kernel.shmall = 2097152 4 kernel.shmmax = 4294967295 #More than half of physical memory 5 kernel.shmmni = 4096 6 kernel.sem = 250 32000 100 128 7 net.ipv4.ip_local_port_range = 9000 65500 8 net.core.rmem_default = 262144 9 net.core.rmem_max = 4194304 10 net.core.wmem_default = 262144 11 net.core.wmem_max = 1048576
More settings are as follows:
1 # sysctl settings are defined through files in 2 # /usr/lib/sysctl.d/, /run/sysctl.d/, and /etc/sysctl.d/. 3 # 4 # Vendors settings live in /usr/lib/sysctl.d/. 5 # To override a whole file, create a new file with the same in 6 # /etc/sysctl.d/ and put new settings there. To override 7 # only specific settings, add a file with a lexically later 8 # name in /etc/sysctl.d/ and put new settings there. 9 # 10 # For more information, see sysctl.conf(5) and sysctl.d(5). 11 12 13 # Disable packet filtering 14 net.ipv4.ip_forward = 0 15 16 # Enable source route verification 17 net.ipv4.conf.default.rp_filter = 1 18 19 # Disable all IP source routes 20 net.ipv4.conf.default.accept_source_route = 0 21 22 # Use the sysrq key combination to understand the current operation of the system. For safety reasons, set it to 0 and turn it off 23 kernel.sysrq = 0 24 25 # Controls whether to add pid as an extension to the file name of the core file 26 kernel.core_uses_pid = 1 27 28 # Enable SYN Cookies. When the SYN waiting queue overflows, enable cookies for processing 29 net.ipv4.tcp_syncookies = 1 30 31 # Size limit per message queue in bytes 32 kernel.msgmnb = 65536 33 34 # Maximum number of message queues in the whole system 35 kernel.msgmax = 65536 36 37 # The size (in bytes) limit of a single shared memory segment is calculated as 64G*1024*1024*1024(byte) 38 kernel.shmmax = 17179869183 39 40 # All memory sizes (unit: page, 1 page = 4Kb), calculation formula: 16G*1024*1024*1024/4KB(page) 41 kernel.shmall = 4194304 42 43 # The number of timewait s is 180000 by default 44 net.ipv4.tcp_max_tw_buckets = 6000 45 46 # Enable selective response 47 net.ipv4.tcp_sack = 1 48 49 # Support larger TCP window If the maximum TCP window exceeds 65535(64K), this value must be set to 1 50 net.ipv4.tcp_window_scaling = 1 51 52 # TCP read buffer 53 net.ipv4.tcp_rmem = 4096 131072 1048576 54 55 # TCP write buffer 56 net.ipv4.tcp_wmem = 4096 131072 1048576 57 58 # The default value of memory reserved for sending buffer for TCP socket (unit: bytes) 59 net.core.wmem_default = 8388608 60 61 # Maximum memory reserved for TCP socket for sending buffer (unit: bytes) 62 net.core.wmem_max = 16777216 63 64 # The default value of memory reserved for receiving buffer for TCP socket (unit: bytes) 65 net.core.rmem_default = 8388608 66 67 # Maximum memory reserved for TCP socket for receiving buffer (unit: bytes) 68 net.core.rmem_max = 16777216 69 70 # The maximum number of packets allowed to be sent to the queue when each network interface receives packets faster than the kernel processes them 71 net.core.netdev_max_backlog = 262144 72 73 # The backlog of the listen function in the web application will give us the net of the kernel parameter by default core. Somaxconn is limited to 128, while nginx defines NGX_LISTEN_BACKLOG defaults to 511, so it is necessary to adjust this value 74 net.core.somaxconn = 262144 75 76 # The maximum number of TCP sockets in the system that are not associated with any user file handle. This limit is only to prevent simple DoS attacks. We should not rely too much on it or artificially reduce this value. We should increase this value (if the memory is increased) 77 net.ipv4.tcp_max_orphans = 3276800 78 79 # The maximum number of connection requests recorded that have not yet received client confirmation. The default value is 1024 for systems with 128M memory and 128 for systems with small memory 80 net.ipv4.tcp_max_syn_backlog = 262144 81 82 # The time stamp can avoid the winding of the serial number. A 1Gbps link will definitely encounter the previously used serial number. Timestamp enables the kernel to accept such "abnormal" packets. It needs to be turned off here 83 net.ipv4.tcp_timestamps = 0 84 85 # In order to open the peer-to-peer connection, the kernel needs to send a SYN with an ACK in response to the previous SYN. That is the second handshake of the so-called three handshakes. This setting determines that the kernel sends SYN before abandoning the connection+ACK Number of packages 86 net.ipv4.tcp_synack_retries = 1 87 88 # The number of SYN packets sent before the kernel gives up establishing a connection 89 net.ipv4.tcp_syn_retries = 1 90 91 # Open time in TCP connection_ Fast recovery of wait sockets 92 net.ipv4.tcp_tw_recycle = 1 93 94 # Turn on the TCP connection multiplexing function to allow time_wait sockets are reused for new TCP connections (mainly for time_wait connections) 95 net.ipv4.tcp_tw_reuse = 1 96 97 # 1st is lower than this value, TCP has no memory pressure, 2nd enters the memory pressure stage, and 3rdTCP refuses to allocate socket (unit: memory page) 98 net.ipv4.tcp_mem = 94500000 915000000 927000000 99 100 # If the socket is requested to be closed by the local end, this parameter determines the time it remains in the FIN-WAIT-2 state. The opposite end can make an error and never close the connection, or even crash accidentally. The default value is 60 seconds.2.2 The normal value of the kernel is 180 seconds. You can press this setting, but remember, even if your machine is light loaded WEB The server also has the risk of memory overflow due to a large number of dead sockets, FIN- WAIT-2 Hazard ratio of FIN-WAIT-1 Be small, because it can only eat 1 at most.5K Memory, but they have a longer lifetime. 101 net.ipv4.tcp_fin_timeout = 15 102 103 # Indicates the frequency of TCP sending keepalive messages when keepalive is enabled (unit: seconds) 104 net.ipv4.tcp_keepalive_time = 30 105 106 # External connection port range 107 net.ipv4.ip_local_port_range = 2048 65000 108 109 # Represents the maximum number of file handles 110 fs.file-max = 102400 111 112 # Avoid amplification attacks 113 net.ipv4.icmp_echo_ignore_broadcasts = 1 114 115 # Enable malicious icmp error message protection 116 net.ipv4.icmp_ignore_bogus_error_responses = 1 117 118 # Enable SYN Flood attack protection 119 net.ipv4.tcp_syncookies = 1 120 121 # Enable and record spoofing, source routing and redirection packets 122 net.ipv4.conf.all.log_martians = 1 123 net.ipv4.conf.default.log_martians = 1 124 125 # Processing passive routed packets 126 net.ipv4.conf.all.accept_source_route = 0 127 net.ipv4.conf.default.accept_source_route = 0 128 129 # Turn on reverse path filtering 130 net.ipv4.conf.all.rp_filter = 1 131 net.ipv4.conf.default.rp_filter = 1 132 133 # Ensure that no one can modify the routing table 134 net.ipv4.conf.all.accept_redirects = 0 135 net.ipv4.conf.default.accept_redirects = 0 136 net.ipv4.conf.all.secure_redirects = 0 137 net.ipv4.conf.default.secure_redirects = 0 138 139 # Do not act as a router 140 net.ipv4.ip_forward = 0 141 net.ipv4.conf.all.send_redirects = 0 142 net.ipv4.conf.default.send_redirects = 0 143 144 # Exshiecld on 145 kernel.exec-shield = 1 146 kernel.randomize_va_space = 1 147 148 # IPv6 settings 149 net.ipv6.conf.default.router_solicitations = 0 150 net.ipv6.conf.default.accept_ra_rtr_pref = 0 151 net.ipv6.conf.default.accept_ra_pinfo = 0 152 net.ipv6.conf.default.accept_ra_defrtr = 0 153 net.ipv6.conf.default.autoconf = 0 154 net.ipv6.conf.default.dad_transmits = 0 155 net.ipv6.conf.default.max_addresses = 1 156 157 # Optimize the ports used by LB 158 159 # Increase system file descriptor limit 160 fs.file-max = 65535 161 162 # Allow more PIDs (reduce rollover problems); may break some programs 32768 163 kernel.pid_max = 65536 164 165 # Increase system IP port limit 166 net.ipv4.ip_local_port_range = 2000 65000 167 168 # Increase TCP maximum buffer size 169 net.ipv4.tcp_rmem = 4096 87380 8388608 170 net.ipv4.tcp_wmem = 4096 87380 8388608 171 172 # Increase the limit of TCP buffer automatically adjusted by Linux 173 # Minimum, default and maximum bytes available 174 # The maximum value is no less than 4MB. If you use a very high BDP path, you can set it higher 175 176 # Tcp window, etc 177 net.core.rmem_max = 8388608 178 net.core.wmem_max = 8388608 179 net.core.netdev_max_backlog = 5000 180 net.ipv4.tcp_window_scaling = 1
8.5. Modify / etc / security / limits Conf (system resource limit), add the following parameters at the end of the file
1 oracle soft nproc 2047 2 oracle hard nproc 16348 3 oracle soft nofile 1024 4 oracle hard nofile 65536
8.6. Modify / etc / PAM D / login (user authentication option), add the following parameters at the end of the file
session required pam_limits.so
9. In order to ensure that all configuration parameters are effective, it is best to restart the server
[root@localhost Desktop]# reboot
10. Silently install oracle Database
10.1 download 64 bit oracle 11g from oracle official website, upload it to / u01/app/database directory and unzip it, and then generate a database directory.
Enter the database directory, where there are three rsp file, which is used as the template of the answer file during silent installation:
db_install.rsp: install answer file
dbca.rsp: create database answer file
netca.rsp: establish response files for network settings such as monitoring and local service name
yum -y install unzip # Install unzip. If it is already installed, please ignore it Unzip together: ls *.zip | xargs -n1 unzip -o Or separate decompression: unzip linux.x64_11gR2_database_1of2.zip unzip linux.x64_11gR2_database_2of2.zip
10.2. Modify the configuration file dB of silent installation_ install. rsp
Before modification, it is better to back up the response folder to prevent the failure of modifying the configuration file.
Please refer to: https://www.cnblogs.com/snaid/p/3598234.html
Small skill: use grep - EV "^ $| [#;]"/ u01/database/response/db_ install. RSP can view the content of the configuration file, but the comment line and blank line are missing
Here is my profile:
1 oracle.install.responseFileVersion=/oracle/install/rspfmt_dbinstall_response_schema_v11_2_0 2 oracle.install.option=INSTALL_DB_SWONLY 3 ORACLE_HOSTNAME=kindo-dev-03 4 UNIX_GROUP_NAME=oinstall 5 INVENTORY_LOCATION=/u01/app/oracle/oraInventory 6 SELECTED_LANGUAGES=en,zh_CN 7 ORACLE_HOME=/u01/app/oracle/product/11.2.0/db_1 8 ORACLE_BASE=/u01/app/oracle 9 oracle.install.db.InstallEdition=EE 10 oracle.install.db.isCustomInstall=false 11 oracle.install.db.customComponents=oracle.server:11.2.0.1.0,oracle.sysman.ccr:10.2.7.0.0,oracle.xdk:11.2.0.1.0,oracle.rdbms.oci:11.2.0.1.0,oracle.network:11.2.0.1.0,oracle.network.listener:11.2.0.1.0,oracle.rdbms:11.2.0.1.0,oracle.options:11.2.0.1.0,oracle.rdbms.partitioning:11.2.0.1.0,oracle.oraolap:11.2.0.1.0,oracle.rdbms.dm:11.2.0.1.0,oracle.rdbms.dv:11.2.0.1.0,orcle.rdbms.lbac:11.2.0.1.0,oracle.rdbms.rat:11.2.0.1.0 12 oracle.install.db.DBA_GROUP=dba 13 oracle.install.db.OPER_GROUP=oinstall 14 oracle.install.db.CLUSTER_NODES= 15 oracle.install.db.config.starterdb.type=GENERAL_PURPOSE 16 oracle.install.db.config.starterdb.globalDBName=orcl 17 oracle.install.db.config.starterdb.SID=orcl 18 oracle.install.db.config.starterdb.characterSet=AL32UTF8 19 oracle.install.db.config.starterdb.memoryOption=true 20 oracle.install.db.config.starterdb.memoryLimit= 21 oracle.install.db.config.starterdb.installExampleSchemas=false 22 oracle.install.db.config.starterdb.enableSecuritySettings=true 23 oracle.install.db.config.starterdb.password.ALL=Kindo1234a 24 oracle.install.db.config.starterdb.password.SYS= 25 oracle.install.db.config.starterdb.password.SYSTEM= 26 oracle.install.db.config.starterdb.password.SYSMAN= 27 oracle.install.db.config.starterdb.password.DBSNMP= 28 oracle.install.db.config.starterdb.control=DB_CONTROL 29 oracle.install.db.config.starterdb.gridcontrol.gridControlServiceURL= 30 oracle.install.db.config.starterdb.dbcontrol.enableEmailNotification=false 31 oracle.install.db.config.starterdb.dbcontrol.emailAddress= 32 oracle.install.db.config.starterdb.dbcontrol.SMTPServer= 33 oracle.install.db.config.starterdb.automatedBackup.enable=false 34 oracle.install.db.config.starterdb.automatedBackup.osuid= 35 oracle.install.db.config.starterdb.automatedBackup.ospwd= 36 oracle.install.db.config.starterdb.storageType= 37 oracle.install.db.config.starterdb.fileSystemStorage.dataLocation= 38 oracle.install.db.config.starterdb.fileSystemStorage.recoveryLocation= 39 oracle.install.db.config.asm.diskGroup= 40 oracle.install.db.config.asm.ASMSNMPPassword= 41 MYORACLESUPPORT_USERNAME= 42 MYORACLESUPPORT_PASSWORD= 43 SECURITY_UPDATES_VIA_MYORACLESUPPORT= 44 DECLINE_SECURITY_UPDATES=true 45 PROXY_HOST= 46 PROXY_PORT= 47 PROXY_USER= 48 PROXY_PWD=
10.3. Start silent installation
[oracle@radhat7 database]$ ./runInstaller -silent -force -responseFile /u01/app/database/response/db_install.rsp -ignorePrereq
1 [oracle@radhat7 database]$ ./runInstaller -silent -force -responseFile /opt/database/response/db_install.rsp -ignorePrereq 2 Starting Oracle Universal Installer... 3 4 Check temporary space: Must be greater than 120 MB. Actually 19009 MB adopt 5 Check swap space: Must be greater than 150 MB. Actually 4094 MB adopt 6 Ready to launch from Oracle Universal Installer /tmp/OraInstall2020-08-27_04-44-51PM. please wait a moment...[oracle@radhat7 database]$ [WARNING] [INS-32055] The main product list is located at Oracle In the base directory. 7 reason: The main product list is located at Oracle In the base directory. 8 operation: Oracle It is recommended that this master product list be placed in Oracle In a location outside the base directory. 9 [WARNING] [INS-32055] The main product list is located at Oracle In the base directory. 10 reason: The main product list is located at Oracle In the base directory. 11 operation: Oracle It is recommended that this master product list be placed in Oracle In a location outside the base directory. 12 The log of this installation session can be found at the following location: 13 /u01/app/oracle/oraInventory/logs/installActions2020-08-27_04-44-51PM.log 14 The following configuration scripts need to "root" Execute as user. 15 #!/bin/sh 16 #Root script to run 17 18 /u01/app/oracle/oraInventory/orainstRoot.sh 19 /u01/app/oracle/product/11.2.0/db_1/root.sh 20 To execute the configuration script, Do the following: 21 1. Open a terminal window 22 2. with "root" Login as 23 3. Run script 24 4. Return to this window and press "Enter" Key continue 25 26 Successfully Setup Software.
10.4. After installation, run root as root according to the prompt sh,orainstRoot.sh file
[root@kindo-dev-03 ~]# sh /u01/app/oracle/oraInventory/orainstRoot.sh [root@kindo-dev-03 ~]# sh /u01/app/oracle/product/11.2.0/db_1/root.sh
10.5. Configure monitoring
[root@kindo-dev-03 ~]# su - oracle #Switch to oracle user [oracle@kindo-dev-03 ~]$ $ORACLE_HOME/bin/netca /silent /responseFile /u01/app/database/response/netca.rsp
View listening status:
Start listening: lsnrctl start
Stop listening: lsnrctl stop
Restart listening: lsnrctl reload
View listening: lsnrctl status
10.6. Build database by silent DBCA
Modify DBCS RSP profile
The following is my profile for reference:
1 [root@kindo-dev-03 ~]# grep -Ev "^$|[#;]" dbca.rsp 2 [GENERAL] 3 RESPONSEFILE_VERSION = "11.2.0" 4 OPERATION_TYPE = "createDatabase" 5 [CREATEDATABASE] 6 GDBNAME = "orcl" 7 SID = "orcl" 8 TEMPLATENAME = "General_Purpose.dbc" 9 SYSPASSWORD = "Kindo1234a" 10 SYSTEMPASSWORD = "Kindo1234a" 11 DATAFILEDESTINATION =/u01/app/oracle/oradata 12 RECOVERYAREADESTINATION=/u01/app/oracle/flash_recovery_area 13 CHARACTERSET = "AL32UTF8" 14 NATIONALCHARACTERSET= "UTF8"
Start creating database:
[oracle@radhat7 ~]$ $ORACLE_HOME/bin/dbca -silent -responseFile /u01/app/database/response/dbca.rsp
(the screen will be cleared after the above statement is executed. If there is no response after the screen is cleared, you need to enter the sys/system password (which can be modified directly in the response file) to start the installation. It seems that you need to enter twice.)
Check whether the installation is successful and whether the database can be connected:
[oracle@radhat7 ~]$ sqlplus / as sysdba SQL>show parameter; SQL>select table_name from dba_tables where rownum<5;
Delete log group:
Remove default installed redo: Switch the log group until the log becomes INACTIVE Delete after status: SQL> alter system switch logfile; System altered. SQL> select GROUP#,BYTES/1024/1024 M,MEMBERS,ARCHIVED,STATUS from v$log; GROUP# M MEMBERS ARC STATUS ---------- ---------- ---------- --- ---------------- 3 50 1 NO INACTIVE 4 1024 1 NO INACTIVE 5 1024 1 NO INACTIVE 6 1024 1 NO CURRENT delete group3: SQL>alter database drop logfile group 3 Database altered.
11. Configure automatic startup monitoring and startup of Oracle
11.1. Modify / etc/oratab
[root@radhat7 oracle]# vi /etc/oratab
11.2. Modify / etc / RC Local, add the following statement at the end
su - oracle -c 'dbstart' su - oracle -c 'lsnrctl start'
11.3. Modify configuration file permissions
[root@radhat7 oracle]# chmod +x /etc/rc.local # Profile permissions
12. Open 1521 port (required for remote connection to Oracle)
Check whether the port is open: firewall-cmd --query-port=1521/tcp Permanently open 1521 port number: firewall-cmd --permanent --zone=public --add-port=1521/tcp Restart firewall: systemctl restart firewalld.service View firewall status systemctl status firewalld.service Note: start | close | Restart firewall systemctl [start | stop | restart] firewalld.service
13,
session required pam_limits.so