Oracle Database 19cをインストールするのにユーザ作成など事前準備をしてくれるRPMパッケージがあるんですね。
About the Oracle Database Preinstallation RPM
https://docs.oracle.com/en/database/oracle/oracle-database/19/ladbi/about-the-oracle-preinstallation-rpm.html#GUID-C15A642B-534D-4E4A-BDE8-6DC7772AA9C8
When installed, the Oracle Database Preinstallation RPM does the following:
・Automatically downloads and installs any additional RPM packages needed for installing Oracle Grid Infrastructure and Oracle Database, and resolves any dependencies
・Creates an oracle user, and creates the oraInventory (oinstall) and OSDBA (dba) groups for that user
・As needed, sets sysctl.conf settings, system startup parameters, and driver parameters to values based on recommendations from the Oracle Database Preinstallation RPM program
・Sets hard and soft resource limits
・Sets other recommended parameters, depending on your kernel version
・Sets numa=off in the kernel for Linux x86_64 machines.
ユーザ作成、カーネルパラメータなど設定してくれるなんて、なんと便利な。
でもドキュメントにはOracle LinuxだけだからRHEL 8は無理かな?
でもちょっと試してみるかと試行錯誤した結果インストールできたようなので記事にしました。
もちろん動作保証はできません(^^;
環境
・Red Hat Enterprise Linux release 8.5 (Ootpa)
・Kernel 4.18.0-348.7.1.el8_5.x86_64
・開発環境、GNOME環境、日本語入力インストール
・Subscription登録
- Oracle Linux repositoryインストール
- /etc/pki/rpm-gpg/RPM-GPG-KEY-oracle作成
- oracle-database-preinstall-19c インストール
- 確認
- /etc/sysctl.conf
- /etc/group
- /etc/passwd
- hard and soft resource limits
- numa=off
oracle-database-preinstall-19c-1.0-3.el7.x86_64.rpmをインストールしようとしたのですが依存関係エラーになってしまいました。
1 2 3 4 5 6 7 8 |
[root@rhel8 ~]# dnf install https://yum.oracle.com/repo/OracleLinux/OL7/latest/x86_64/getPackage/oracle-database-preinstall-19c-1.0-3.el7.x86_64.rpm Updating Subscription Management repositories. Last metadata expiration check: 9:52:30 ago on Fri Jan 14 14:01:27 2022. oracle-database-preinstall-19c-1.0-3.el7.x86_64.rpm 569 kB/s | 27 kB 00:00 Error: Problem: conflicting requests - nothing provides compat-libcap1 needed by oracle-database-preinstall-19c-1.0-3.el7.x86_64 (try to add '--skip-broken' to skip uninstallable packages or '--nobest' to use not only best candidate packages) |
試行錯誤したのですがダメそうなのでOracle Linux repositoryをインストールしてみました。
oracle-database-preinstall-19cはOL8 repositoryには無くてOL7にあったので、こちらのreposirotyをインストールします。
Oracle Linux 7 (x86_64) Latest
https://yum.oracle.com/repo/OracleLinux/OL7/latest/x86_64/
Oracle Linux 8 (x86_64) BaseOS Latest
https://yum.oracle.com/repo/OracleLinux/OL8/baseos/latest/x86_64/index.html
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 |
[root@rhel8 ~]# dnf install https://yum.oracle.com/repo/OracleLinux/OL7/latest/x86_64/getPackage/oraclelinux-release-el7-1.0-8.el7.x86_64.rpm Updating Subscription Management repositories. oraclelinux-release-el7-1.0-8.el7.x86_64.rpm 90 kB/s | 19 kB 00:00 Dependencies resolved. ===================================================================================================== Package Arch Version Repository Size ===================================================================================================== Installing: oraclelinux-release-el7 x86_64 1.0-8.el7 @commandline 19 k Installing dependencies: yum-utils noarch 4.0.21-3.el8 rhel-8-for-x86_64-baseos-rpms 72 k Transaction Summary ===================================================================================================== Install 2 Packages Total size: 91 k Total download size: 72 k Installed size: 51 k Is this ok [y/N]: y Downloading Packages: yum-utils-4.0.21-3.el8.noarch.rpm 159 kB/s | 72 kB 00:00 ----------------------------------------------------------------------------------------------------- Total 158 kB/s | 72 kB 00:00 Running transaction check Transaction check succeeded. Running transaction test Transaction test succeeded. Running transaction Preparing : 1/1 Installing : yum-utils-4.0.21-3.el8.noarch 1/2 Running scriptlet: oraclelinux-release-el7-1.0-8.el7.x86_64 2/2 Installing : oraclelinux-release-el7-1.0-8.el7.x86_64 2/2 Running scriptlet: oraclelinux-release-el7-1.0-8.el7.x86_64 2/2 Verifying : yum-utils-4.0.21-3.el8.noarch 1/2 Verifying : oraclelinux-release-el7-1.0-8.el7.x86_64 2/2 Installed products updated. Installed: oraclelinux-release-el7-1.0-8.el7.x86_64 yum-utils-4.0.21-3.el8.noarch Complete! [root@rhel8 ~]# ls -l /etc/yum.repos.d/ total 172 -rw-r--r--. 1 root root 3594 Aug 8 2019 oracle-linux-ol7.repo -rw-r--r--. 1 root root 163682 Jan 16 08:10 redhat.repo -rw-r--r--. 1 root root 2116 Aug 8 2019 uek-ol7.repo -rw-r--r--. 1 root root 226 Aug 8 2019 virt-ol7.repo |
下記サイトからKEYをコピーして作成します。
https://yum.oracle.com/RPM-GPG-KEY-oracle-ol7
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 |
[root@rhel8 ~]# vi /etc/pki/rpm-gpg/RPM-GPG-KEY-oracle [root@rhel8 ~]# cat /etc/pki/rpm-gpg/RPM-GPG-KEY-oracle -----BEGIN PGP PUBLIC KEY BLOCK----- Version: GnuPG v1.4.5 (GNU/Linux) mQENBEwtJWoBCACpiY2rGA6T0ceBi92X88/QclytVBjtDRohOVzs3pmIPh3ULqsW G323nmyKbKQBBSjh9OnuO9Y09VG8mzr/w9YV0Ix4cI9/HDTERZ2+TR5u+VNn5J5h yvwQSN/FEK6oH2+mz7O0yUNleN7UltR4MOEkHIoAhIvv+1AQQKN3OM8oalz+3gv/ zz9rAoQczQzT7QWOtBrsRMZgBrKXY/TpJrpVSO3Hx8CnbhKGtLxCCrxZ5v7hh1ht 3CRAr2+h5bDA9KP6vBZWKEs7NgcvtZFDY6EJc7AoApr3phX9hHE2+snTxe82DkFT uA69C8wLyjPCoSy+tcaCqJKOZelNy9RN/WKRABEBAAG0RE9yYWNsZSBPU1MgZ3Jv dXAgKE9wZW4gU291cmNlIFNvZnR3YXJlIGdyb3VwKSA8YnVpbGRAb3NzLm9yYWNs ZS5jb20+iQE8BBMBAgAmAhsDBgsJCAcDAgQVAggDBBYCAwECHgECF4AFAlNhkUEF CSaOl9cACgkQcvl7dOxVHwNHFQf9G2ZI5ZH8T1VASvQteTyUR7uNgqXEbJhi9zZO 7EO26+wzkj9EGLmH1COdUApZ1cINsYfGGgUJT5mfcRV3yYZbwc4AZJbJe0z7C5Yu ZLs5W0ryV4bzIqcWnVphIAOwmxMxIVGz8Cr1Dsyyal7ORgYzdfOppYetwtZ+J+Wn /oVgFkh9v19l/CltBkRh2SqgUZYfCoELo7hUzLNh7cw2av8rcSUKSH3ra9MvpYfS ANCnouzbgKix1gD6niT3pm1s5II3VuQ2vEcJunnoRFci9FzLXelTuL00MvuxERr7 Fsqm1/D2JfKDbE09qy5bLWrWaTM6zOFQKN7F2edY2uaukLT6/w== =Djed -----END PGP PUBLIC KEY BLOCK----- |
1 2 3 4 5 |
[root@rhel8 ~]# dnf search oracle-database-preinstall-19c Updating Subscription Management repositories. ======================= Name Exactly Matched: oracle-database-preinstall-19c ======================== oracle-database-preinstall-19c.src : Oracle Database Preinstallation RPM oracle-database-preinstall-19c.x86_64 : Oracle Database Preinstallation RPM |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 |
[root@rhel8 ~]# dnf install oracle-database-preinstall-19c Updating Subscription Management repositories. Oracle Linux 8 Latest (x86_64) 17 MB/s | 49 MB 00:02 Latest Unbreakable Enterprise Kernel Release 5 for Oracle Linu 15 MB/s | 42 MB 00:02 Dependencies resolved. =============================================================================================== Package Arch Version Repository Size =============================================================================================== Installing: oracle-database-preinstall-19c x86_64 1.0-3.el7 ol7_latest 27 k Installing dependencies: bc x86_64 1.07.1-5.el8 rhel-8-for-x86_64-baseos-rpms 129 k bind-libs x86_64 32:9.11.26-6.el8 rhel-8-for-x86_64-appstream-rpms 174 k bind-libs-lite x86_64 32:9.11.26-6.el8 rhel-8-for-x86_64-appstream-rpms 1.2 M bind-license noarch 32:9.11.26-6.el8 rhel-8-for-x86_64-appstream-rpms 102 k bind-utils x86_64 32:9.11.26-6.el8 rhel-8-for-x86_64-appstream-rpms 451 k compat-libcap1 x86_64 1.10-7.el7 ol7_latest 17 k fstrm x86_64 0.6.1-2.el8 rhel-8-for-x86_64-appstream-rpms 29 k ksh x86_64 20120801-254.el8 rhel-8-for-x86_64-appstream-rpms 926 k libXxf86dga x86_64 1.1.5-1.el8 rhel-8-for-x86_64-appstream-rpms 26 k libaio-devel x86_64 0.3.112-1.el8 rhel-8-for-x86_64-baseos-rpms 19 k libdmx x86_64 1.1.4-3.el8 rhel-8-for-x86_64-appstream-rpms 22 k libmaxminddb x86_64 1.2.0-10.el8 rhel-8-for-x86_64-appstream-rpms 33 k lm_sensors-libs x86_64 3.4.0-23.20180522git70f7e08.el8 rhel-8-for-x86_64-baseos-rpms 59 k net-tools x86_64 2.0-0.52.20160912git.el8 rhel-8-for-x86_64-baseos-rpms 322 k protobuf-c x86_64 1.3.0-6.el8 rhel-8-for-x86_64-appstream-rpms 37 k python3-bind noarch 32:9.11.26-6.el8 rhel-8-for-x86_64-appstream-rpms 150 k python3-ply noarch 3.9-9.el8 rhel-8-for-x86_64-baseos-rpms 111 k smartmontools x86_64 1:7.1-1.el8 rhel-8-for-x86_64-baseos-rpms 544 k sysstat x86_64 11.7.3-6.el8 rhel-8-for-x86_64-appstream-rpms 425 k xorg-x11-utils x86_64 7.5-28.el8 rhel-8-for-x86_64-appstream-rpms 135 k Installing weak dependencies: geolite2-city noarch 20180605-1.el8 rhel-8-for-x86_64-appstream-rpms 19 M geolite2-country noarch 20180605-1.el8 rhel-8-for-x86_64-appstream-rpms 1.0 M Transaction Summary =============================================================================================== Install 23 Packages Total download size: 25 M Installed size: 71 M Is this ok [y/N]: y Downloading Packages: (1/23): compat-libcap1-1.10-7.el7.x86_64.rpm 406 kB/s | 17 kB 00:00 (2/23): oracle-database-preinstall-19c-1.0-3.el7.x86_64.rpm 433 kB/s | 27 kB 00:00 (3/23): libaio-devel-0.3.112-1.el8.x86_64.rpm 95 kB/s | 19 kB 00:00 (4/23): bc-1.07.1-5.el8.x86_64.rpm 530 kB/s | 129 kB 00:00 (5/23): net-tools-2.0-0.52.20160912git.el8.x86_64.rpm 1.3 MB/s | 322 kB 00:00 (6/23): python3-ply-3.9-9.el8.noarch.rpm 628 kB/s | 111 kB 00:00 (7/23): smartmontools-7.1-1.el8.x86_64.rpm 2.9 MB/s | 544 kB 00:00 (8/23): lm_sensors-libs-3.4.0-23.20180522git70f7e08.el8.x86_64 336 kB/s | 59 kB 00:00 (9/23): geolite2-country-20180605-1.el8.noarch.rpm 4.5 MB/s | 1.0 MB 00:00 (10/23): xorg-x11-utils-7.5-28.el8.x86_64.rpm 741 kB/s | 135 kB 00:00 (11/23): libdmx-1.1.4-3.el8.x86_64.rpm 86 kB/s | 22 kB 00:00 (12/23): ksh-20120801-254.el8.x86_64.rpm 3.1 MB/s | 926 kB 00:00 (13/23): libmaxminddb-1.2.0-10.el8.x86_64.rpm 157 kB/s | 33 kB 00:00 (14/23): libXxf86dga-1.1.5-1.el8.x86_64.rpm 131 kB/s | 26 kB 00:00 (15/23): protobuf-c-1.3.0-6.el8.x86_64.rpm 194 kB/s | 37 kB 00:00 (16/23): bind-libs-9.11.26-6.el8.x86_64.rpm 904 kB/s | 174 kB 00:00 (17/23): fstrm-0.6.1-2.el8.x86_64.rpm 153 kB/s | 29 kB 00:00 (18/23): bind-license-9.11.26-6.el8.noarch.rpm 525 kB/s | 102 kB 00:00 (19/23): sysstat-11.7.3-6.el8.x86_64.rpm 1.9 MB/s | 425 kB 00:00 (20/23): bind-libs-lite-9.11.26-6.el8.x86_64.rpm 3.9 MB/s | 1.2 MB 00:00 (21/23): python3-bind-9.11.26-6.el8.noarch.rpm 673 kB/s | 150 kB 00:00 (22/23): bind-utils-9.11.26-6.el8.x86_64.rpm 1.9 MB/s | 451 kB 00:00 (23/23): geolite2-city-20180605-1.el8.noarch.rpm 4.2 MB/s | 19 MB 00:04 ----------------------------------------------------------------------------------------------- Total 5.0 MB/s | 25 MB 00:04 Oracle Linux 8 Latest (x86_64) 988 kB/s | 1.0 kB 00:00 Importing GPG key 0xEC551F03: Userid : "Oracle OSS group (Open Source Software group) <build@oss.oracle.com>" Fingerprint: 4214 4123 FECF C55B 9086 313D 72F9 7B74 EC55 1F03 From : /etc/pki/rpm-gpg/RPM-GPG-KEY-oracle Is this ok [y/N]: y Key imported successfully Running transaction check Transaction check succeeded. Running transaction test Transaction test succeeded. Running transaction Preparing : 1/1 Installing : bind-license-32:9.11.26-6.el8.noarch 1/23 Installing : fstrm-0.6.1-2.el8.x86_64 2/23 Installing : protobuf-c-1.3.0-6.el8.x86_64 3/23 Installing : libXxf86dga-1.1.5-1.el8.x86_64 4/23 Installing : ksh-20120801-254.el8.x86_64 5/23 Running scriptlet: ksh-20120801-254.el8.x86_64 5/23 Installing : libdmx-1.1.4-3.el8.x86_64 6/23 Installing : xorg-x11-utils-7.5-28.el8.x86_64 7/23 Installing : geolite2-country-20180605-1.el8.noarch 8/23 Installing : geolite2-city-20180605-1.el8.noarch 9/23 Installing : libmaxminddb-1.2.0-10.el8.x86_64 10/23 Running scriptlet: libmaxminddb-1.2.0-10.el8.x86_64 10/23 Installing : bind-libs-lite-32:9.11.26-6.el8.x86_64 11/23 Installing : bind-libs-32:9.11.26-6.el8.x86_64 12/23 Installing : lm_sensors-libs-3.4.0-23.20180522git70f7e08.el8.x86_64 13/23 Running scriptlet: lm_sensors-libs-3.4.0-23.20180522git70f7e08.el8.x86_64 13/23 Installing : sysstat-11.7.3-6.el8.x86_64 14/23 Running scriptlet: sysstat-11.7.3-6.el8.x86_64 14/23 Installing : python3-ply-3.9-9.el8.noarch 15/23 Installing : python3-bind-32:9.11.26-6.el8.noarch 16/23 Installing : bind-utils-32:9.11.26-6.el8.x86_64 17/23 Running scriptlet: smartmontools-1:7.1-1.el8.x86_64 18/23 Installing : smartmontools-1:7.1-1.el8.x86_64 18/23 Running scriptlet: smartmontools-1:7.1-1.el8.x86_64 18/23 Installing : net-tools-2.0-0.52.20160912git.el8.x86_64 19/23 Running scriptlet: net-tools-2.0-0.52.20160912git.el8.x86_64 19/23 Installing : libaio-devel-0.3.112-1.el8.x86_64 20/23 Installing : bc-1.07.1-5.el8.x86_64 21/23 Running scriptlet: bc-1.07.1-5.el8.x86_64 21/23 Installing : compat-libcap1-1.10-7.el7.x86_64 22/23 Running scriptlet: compat-libcap1-1.10-7.el7.x86_64 22/23 Running scriptlet: oracle-database-preinstall-19c-1.0-3.el7.x86_64 23/23 Installing : oracle-database-preinstall-19c-1.0-3.el7.x86_64 23/23 Running scriptlet: oracle-database-preinstall-19c-1.0-3.el7.x86_64 23/23 Verifying : compat-libcap1-1.10-7.el7.x86_64 1/23 Verifying : oracle-database-preinstall-19c-1.0-3.el7.x86_64 2/23 Verifying : bc-1.07.1-5.el8.x86_64 3/23 Verifying : libaio-devel-0.3.112-1.el8.x86_64 4/23 Verifying : net-tools-2.0-0.52.20160912git.el8.x86_64 5/23 Verifying : smartmontools-1:7.1-1.el8.x86_64 6/23 Verifying : python3-ply-3.9-9.el8.noarch 7/23 Verifying : lm_sensors-libs-3.4.0-23.20180522git70f7e08.el8.x86_64 8/23 Verifying : geolite2-city-20180605-1.el8.noarch 9/23 Verifying : geolite2-country-20180605-1.el8.noarch 10/23 Verifying : xorg-x11-utils-7.5-28.el8.x86_64 11/23 Verifying : libdmx-1.1.4-3.el8.x86_64 12/23 Verifying : ksh-20120801-254.el8.x86_64 13/23 Verifying : libmaxminddb-1.2.0-10.el8.x86_64 14/23 Verifying : libXxf86dga-1.1.5-1.el8.x86_64 15/23 Verifying : protobuf-c-1.3.0-6.el8.x86_64 16/23 Verifying : bind-libs-32:9.11.26-6.el8.x86_64 17/23 Verifying : fstrm-0.6.1-2.el8.x86_64 18/23 Verifying : bind-license-32:9.11.26-6.el8.noarch 19/23 Verifying : bind-libs-lite-32:9.11.26-6.el8.x86_64 20/23 Verifying : sysstat-11.7.3-6.el8.x86_64 21/23 Verifying : python3-bind-32:9.11.26-6.el8.noarch 22/23 Verifying : bind-utils-32:9.11.26-6.el8.x86_64 23/23 Installed products updated. Installed: bc-1.07.1-5.el8.x86_64 bind-libs-32:9.11.26-6.el8.x86_64 bind-libs-lite-32:9.11.26-6.el8.x86_64 bind-license-32:9.11.26-6.el8.noarch bind-utils-32:9.11.26-6.el8.x86_64 compat-libcap1-1.10-7.el7.x86_64 fstrm-0.6.1-2.el8.x86_64 geolite2-city-20180605-1.el8.noarch geolite2-country-20180605-1.el8.noarch ksh-20120801-254.el8.x86_64 libXxf86dga-1.1.5-1.el8.x86_64 libaio-devel-0.3.112-1.el8.x86_64 libdmx-1.1.4-3.el8.x86_64 libmaxminddb-1.2.0-10.el8.x86_64 lm_sensors-libs-3.4.0-23.20180522git70f7e08.el8.x86_64 net-tools-2.0-0.52.20160912git.el8.x86_64 oracle-database-preinstall-19c-1.0-3.el7.x86_64 protobuf-c-1.3.0-6.el8.x86_64 python3-bind-32:9.11.26-6.el8.noarch python3-ply-3.9-9.el8.noarch smartmontools-1:7.1-1.el8.x86_64 sysstat-11.7.3-6.el8.x86_64 xorg-x11-utils-7.5-28.el8.x86_64 Complete! |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 |
[root@rhel8 ~]# cat /etc/sysctl.conf # sysctl settings are defined through files in # /usr/lib/sysctl.d/, /run/sysctl.d/, and /etc/sysctl.d/. # # Vendors settings live in /usr/lib/sysctl.d/. # To override a whole file, create a new file with the same in # /etc/sysctl.d/ and put new settings there. To override # only specific settings, add a file with a lexically later # name in /etc/sysctl.d/ and put new settings there. # # For more information, see sysctl.conf(5) and sysctl.d(5). # oracle-database-preinstall-19c setting for fs.file-max is 6815744 fs.file-max = 6815744 # oracle-database-preinstall-19c setting for kernel.sem is '250 32000 100 128' kernel.sem = 250 32000 100 128 # oracle-database-preinstall-19c setting for kernel.shmmni is 4096 kernel.shmmni = 4096 # oracle-database-preinstall-19c setting for kernel.shmall is 1073741824 on x86_64 kernel.shmall = 1073741824 # oracle-database-preinstall-19c setting for kernel.shmmax is 4398046511104 on x86_64 kernel.shmmax = 4398046511104 # oracle-database-preinstall-19c setting for kernel.panic_on_oops is 1 per Orabug 19212317 kernel.panic_on_oops = 1 # oracle-database-preinstall-19c setting for net.core.rmem_default is 262144 net.core.rmem_default = 262144 # oracle-database-preinstall-19c setting for net.core.rmem_max is 4194304 net.core.rmem_max = 4194304 # oracle-database-preinstall-19c setting for net.core.wmem_default is 262144 net.core.wmem_default = 262144 # oracle-database-preinstall-19c setting for net.core.wmem_max is 1048576 net.core.wmem_max = 1048576 # oracle-database-preinstall-19c setting for net.ipv4.conf.all.rp_filter is 2 net.ipv4.conf.all.rp_filter = 2 # oracle-database-preinstall-19c setting for net.ipv4.conf.default.rp_filter is 2 net.ipv4.conf.default.rp_filter = 2 # oracle-database-preinstall-19c setting for fs.aio-max-nr is 1048576 fs.aio-max-nr = 1048576 # oracle-database-preinstall-19c setting for net.ipv4.ip_local_port_range is 9000 65500 net.ipv4.ip_local_port_range = 9000 65500 |
下記Groupが追加されていました。
1 2 3 4 5 6 7 |
oinstall:x:54321:oracle dba:x:54322:oracle oper:x:54323:oracle backupdba:x:54324:oracle dgdba:x:54325:oracle kmdba:x:54326:oracle racdba:x:54330:oracle |
下記ユーザが作成されていました。
1 |
oracle:x:54321:54321::/home/oracle:/bin/bash |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 |
[root@rhel8 ~]# ulimit -aH core file size (blocks, -c) unlimited data seg size (kbytes, -d) unlimited scheduling priority (-e) 0 file size (blocks, -f) unlimited pending signals (-i) 63079 max locked memory (kbytes, -l) 64 max memory size (kbytes, -m) unlimited open files (-n) 262144 pipe size (512 bytes, -p) 8 POSIX message queues (bytes, -q) 819200 real-time priority (-r) 0 stack size (kbytes, -s) unlimited cpu time (seconds, -t) unlimited max user processes (-u) 63079 virtual memory (kbytes, -v) unlimited file locks (-x) unlimited [root@rhel8 ~]# ulimit -aS core file size (blocks, -c) 0 data seg size (kbytes, -d) unlimited scheduling priority (-e) 0 file size (blocks, -f) unlimited pending signals (-i) 63079 max locked memory (kbytes, -l) 64 max memory size (kbytes, -m) unlimited open files (-n) 1024 pipe size (512 bytes, -p) 8 POSIX message queues (bytes, -q) 819200 real-time priority (-r) 0 stack size (kbytes, -s) 8192 cpu time (seconds, -t) unlimited max user processes (-u) 63079 virtual memory (kbytes, -v) unlimited file locks (-x) unlimited |
NUMAって何?と思ったら自動負荷分散とのこと
https://access.redhat.com/documentation/ja-jp/red_hat_enterprise_linux/7/html/virtualization_tuning_and_optimization_guide/sect-virtualization_tuning_optimization_guide-numa-auto_numa_balancing
NUMA の自動分散により、NUMA ハードウェアシステムで実行しているアプリケーションのパフォーマンスが向上します。Red Hat Enterprise Linux 7 システムでデフォルトで有効になっています。
1 2 3 4 5 6 7 8 9 |
[root@rhel8 ~]# cat /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 resume=/dev/mapper/rhel_rhel8rootlinks-swap rd.lvm.lv=rhel_rhel8rootlinks/root rd.lvm.lv=rhel_rhel8rootlinks/swap rhgb quiet numa=off transparent_hugepage=never" GRUB_DISABLE_RECOVERY="true" GRUB_ENABLE_BLSCFG=true |
Configure Oracle Database Preinstallation RPM only once on your operating system when you install Oracle Database or Oracle Grid Infrastructure for the first time on your system. For subsequent installations on the same system, do not install Oracle Database Preinstallation RPM again.
Oracle Database Preinstallation RPMはそのシステムで一度だけのインストールです。