目標
- Oracle Databaseをrpmでインストールする
参考）
RPMパッケージの実行によるOracle Databaseのインストール
Oracle Database Preinstallation RPMによるOracle Linuxの自動構成
環境
- RHEL8.5
- Oracle Database 19c(19.3.0.0.0)
準備するもの
- Oracle Database 19c(oracle-database-ee-19c-1.0-1.x86_64.rpm)
- Oracle Database Preinstallation(oracle-database-preinstall-19c-1.0-2.el8.x86_64.rpm)
Oracle Database 19cはOracleのサイトよりダウンロード(OTNアカウントが必要)
Oracle Database Preinstallationはcurlでダウンロード可能
※ OSのパッケージが必要となるため、yum installができること
RHEL8で必要なパッケージ
kernel Parameterを設定
# vi /etc/sysctl.conf
以下の内容を設定
### Oracle Parameter
fs.file-max = 6815744
kernel.sem = 250 32000 100 128
kernel.shmmni = 4096
kernel.shmall = 1073741824
kernel.shmmax = 4398046511104
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
### Oracle Parameter
RHEL8に対応したPreinstallationをダウンロード＋インストール
# curl -o oracle-database-preinstall-19c-1.0-2.el8.x86_64.rpm https://yum.oracle.com/repo/OracleLinux/OL8/appstream/x86_64/getPackage/oracle-database-preinstall-19c-1.0-2.el8.x86_64.rpm
# yum install oracle-database-preinstall-19c-1.0-2.el8.x86_64.rpm
# cat /etc/security/limits.d/oracle-database-preinstall-19c.conf
oracle-database-preinstall-19c.confにlimitなどの情報があることを確認
Oracle Databaseをインストール
# yum -y localinstall ./oracle-database-ee-19c-1.0-1.x86_64.rpm
インストールは時間がかかるのでエラーがでなければ気長に待つ
Last metadata expiration check: 1:09:14 ago on Wed 02 Feb 2022 04:52:55 PM JST.
Dependencies resolved.
=============================================================================================================================================================
Package Architecture Version Repository Size
=============================================================================================================================================================
Installing:
oracle-database-ee-19c x86_64 1.0-1 @commandline 2.5 G
Transaction Summary
=============================================================================================================================================================
Install 1 Package
Total size: 2.5 G
Installed size: 6.9 G
Downloading Packages:
Running transaction check
Transaction check succeeded.
Running transaction test
Transaction test succeeded.
Running transaction
~~~~~~~~~~~~~~~~~~~~~~~~~~ 省略
[INFO] Executing post installation scripts...
[INFO] Oracle home installed successfully and ready to be configured.
To configure a sample Oracle Database you can execute the following service configuration script as root: /etc/init.d/oracledb_ORCLCDB-19c configure
Verifying : oracle-database-ee-19c-1.0-1.x86_64 1/1
Installed products updated.
Installed:
oracle-database-ee-19c-1.0-1.x86_64
Complete!
#
コンフィグ設定を行う(上のスクリプト結果に表示されているコマンドを実行)
# /etc/init.d/oracledb_ORCLCDB-19c configure
コマンド実行出力例は以下
Configuring Oracle Database ORCLCDB.
Prepare for db operation
8% complete
Copying database files
31% complete
Creating and starting Oracle instance
32% complete
36% complete
40% complete
43% complete
46% complete
Completing Database Creation
51% complete
54% complete
Creating Pluggable Databases
58% complete
77% complete
Executing Post Configuration Actions
100% complete
Database creation complete. For details check the logfiles at:
/opt/oracle/cfgtoollogs/dbca/ORCLCDB.
Database Information:
Global Database Name:ORCLCDB
System Identifier(SID):ORCLCDB
Look at the log file "/opt/oracle/cfgtoollogs/dbca/ORCLCDB/ORCLCDB.log" for further details.
Database configuration completed successfully. The passwords were auto generated, you must change them by connecting to the database using 'sqlplus / as sysdba' as the oracle user.
Oracleの環境parameterを設定
# vi /etc/profile.d/oracle.sh
以下の内容を設定
export ORACLE_HOME=/opt/oracle/product/19c/dbhome_1
export ORACLE_SID=ORCLCDB
export NLS_LANG=Japanese_Japan.AL32UTF8
export PATH=$ORACLE_HOME/bin:$PATH
Oracle Database 19cが起動することを確認
# su - oracle
$ sqlplus / as sysdba
SQL*Plus: Release 19.0.0.0.0 - Production on 水 2月 2 20:57:52 2022
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle. All rights reserved.
アイドル・インスタンスに接続しました。
SQL> exit
切断しました。
#