Oracle Clientに同梱されているJDBCドライバを確認してみた

## はじめに
Oracle Databaseに対してJavaアプリケーションから接続する際に利用するOracle JDBCドライバの入手方法について確認した際のメモをまとめます。
各JDKバージョンおよびOracle JDBCバージョンによって利用するjarファイル(ojdbcX.jar)が異なり、以下FAQの「Oracle JDBCのリリースとJDKのバージョンの関連について教えてください。」に組み合わせのマトリクスがまとまっています。
[Oracle JDBCに関するFAQ](https://www.oracle.com/jp/database/technologies/faq-jdbc.html)

JDBCドライバのjarファイルは以下からダウンロードして配置することで利用できます。
https://www.oracle.com/jp/database/technologies/appdev/jdbc-downloads.html

またOracle DatabaseやOracle Clientをインストールしていればドライバも同梱されており、そちらを利用するることも可能です。
同梱されているドライバは$ORACLE_HOME/jdbc/lib配下に配置されています。
今回は19c～23aiのOracle Clientをサイレントインストールし、その中のJDBCドライバの同梱状況を確認してみます。

## 本記事の前提条件
* OCI Compute上のVM上でOracle Linux 8.10を利用
* Oracle Client 19c、21c、23ai
* 各Oracle Clientは[OracleSoftwareDeliveryCloud](https://edelivery.oracle.com)からGold Imageをダウンロードしてインストール

## 各Oracle Client内のJDBCドライバの同梱状況
### Oracle Client 19c
#### Oracle Clientインストール
前提パッケージを19c preinstallerからインストールします。
```
[opc@ol8 ~]$ sudo -s
[root@ol8 opc]# yum search preinstall
Last metadata expiration check: 2:07:25 ago on Tue 13 May 2025 03:20:39 AM GMT.
=============================== Name & Summary Matched: preinstall ===============================
oracle-database-preinstall-19c.src : Oracle Database Preinstallation RPM
oracle-database-preinstall-19c.x86_64 : Oracle Database Preinstallation RPM
oracle-database-preinstall-21c.src : Oracle Database Preinstallation RPM
oracle-database-preinstall-21c.x86_64 : Oracle Database Preinstallation RPM
oracle-database-preinstall-23ai.src : Oracle Database Preinstallation RPM
oracle-database-preinstall-23ai.x86_64 : Oracle Database Preinstallation RPM
==================================== Name Matched: preinstall ====================================
oracle-ebs-server-R12-preinstall.src : Sets the system for Oracle E-Business Suite Release 12 for
                                     : Oracle Linux 8
oracle-ebs-server-R12-preinstall.x86_64 : Sets the system for Oracle E-Business Suite Release 12
                                        : for Oracle Linux 8

[root@ol8 opc]# yum install -y oracle-database-preinstall-19c.x86_64
Last metadata expiration check: 2:08:06 ago on Tue 13 May 2025 03:20:39 AM GMT.
Dependencies resolved.
==================================================================================================
 Package                           Arch      Version                   Repository            Size
==================================================================================================
Installing:
 oracle-database-preinstall-19c    x86_64    1.0-2.el8                 ol8_appstream         31 k
Installing dependencies:
 ksh                               x86_64    20120801-267.0.1.el8      ol8_appstream        923 k
 libICE                            x86_64    1.0.9-15.el8              ol8_appstream         74 k
 libSM                             x86_64    1.2.3-1.el8               ol8_appstream         47 k
 libX11-xcb                        x86_64    1.6.8-9.el8_10            ol8_appstream         14 k
 libXcomposite                     x86_64    0.4.4-14.el8              ol8_appstream         28 k
 libXi                             x86_64    1.7.10-1.el8              ol8_appstream         49 k
 libXinerama                       x86_64    1.1.4-1.el8               ol8_appstream         15 k
 libXmu                            x86_64    1.1.3-1.el8               ol8_appstream         75 k
 libXrandr                         x86_64    1.5.2-1.el8               ol8_appstream         34 k
 libXt                             x86_64    1.1.5-12.el8              ol8_appstream        185 k
 libXtst                           x86_64    1.2.3-7.el8               ol8_appstream         22 k
 libXv                             x86_64    1.0.11-7.el8              ol8_appstream         20 k
 libXxf86dga                       x86_64    1.1.5-1.el8               ol8_appstream         26 k
 libXxf86misc                      x86_64    1.0.4-1.el8               ol8_appstream         23 k
 libXxf86vm                        x86_64    1.1.4-9.el8               ol8_appstream         19 k
 libaio-devel                      x86_64    0.3.112-1.el8             ol8_baseos_latest     19 k
 libdmx                            x86_64    1.1.4-3.el8               ol8_appstream         22 k
 libnsl                            x86_64    2.28-251.0.3.el8_10.14    ol8_baseos_latest    115 k
 libstdc++-devel                   x86_64    8.5.0-26.0.1.el8_10       ol8_appstream        2.1 M
 xorg-x11-utils                    x86_64    7.5-28.el8                ol8_appstream        136 k
 xorg-x11-xauth                    x86_64    1:1.0.9-12.el8            ol8_appstream         39 k

Transaction Summary
==================================================================================================
Install  22 Packages

Total download size: 3.9 M
Installed size: 16 M
Downloading Packages:
(1/22): libaio-devel-0.3.112-1.el8.x86_64.rpm                     859 kB/s |  19 kB     00:00
(2/22): libnsl-2.28-251.0.3.el8_10.14.x86_64.rpm                  4.5 MB/s | 115 kB     00:00
(3/22): libICE-1.0.9-15.el8.x86_64.rpm                             13 MB/s |  74 kB     00:00
(4/22): libSM-1.2.3-1.el8.x86_64.rpm                              7.5 MB/s |  47 kB     00:00
(5/22): ksh-20120801-267.0.1.el8.x86_64.rpm                        24 MB/s | 923 kB     00:00
(6/22): libX11-xcb-1.6.8-9.el8_10.x86_64.rpm                      1.1 MB/s |  14 kB     00:00
(7/22): libXcomposite-0.4.4-14.el8.x86_64.rpm                     2.7 MB/s |  28 kB     00:00
(8/22): libXi-1.7.10-1.el8.x86_64.rpm                             5.5 MB/s |  49 kB     00:00
(9/22): libXmu-1.1.3-1.el8.x86_64.rpm                             9.9 MB/s |  75 kB     00:00
(10/22): libXinerama-1.1.4-1.el8.x86_64.rpm                       1.2 MB/s |  15 kB     00:00
(11/22): libXrandr-1.5.2-1.el8.x86_64.rpm                         4.2 MB/s |  34 kB     00:00
(12/22): libXt-1.1.5-12.el8.x86_64.rpm                             21 MB/s | 185 kB     00:00
(13/22): libXtst-1.2.3-7.el8.x86_64.rpm                           2.4 MB/s |  22 kB     00:00
(14/22): libXxf86dga-1.1.5-1.el8.x86_64.rpm                       4.5 MB/s |  26 kB     00:00
(15/22): libXxf86vm-1.1.4-9.el8.x86_64.rpm                        5.5 MB/s |  19 kB     00:00
(16/22): libXv-1.0.11-7.el8.x86_64.rpm                            1.4 MB/s |  20 kB     00:00
(17/22): libdmx-1.1.4-3.el8.x86_64.rpm                            3.9 MB/s |  22 kB     00:00
(18/22): oracle-database-preinstall-19c-1.0-2.el8.x86_64.rpm      5.7 MB/s |  31 kB     00:00
(19/22): libXxf86misc-1.0.4-1.el8.x86_64.rpm                      1.2 MB/s |  23 kB     00:00
(20/22): xorg-x11-xauth-1.0.9-12.el8.x86_64.rpm                   7.8 MB/s |  39 kB     00:00
(21/22): xorg-x11-utils-7.5-28.el8.x86_64.rpm                      15 MB/s | 136 kB     00:00
(22/22): libstdc++-devel-8.5.0-26.0.1.el8_10.x86_64.rpm            20 MB/s | 2.1 MB     00:00
--------------------------------------------------------------------------------------------------
Total                                                              22 MB/s | 3.9 MB     00:00
Running transaction check
Transaction check succeeded.
Running transaction test
Transaction test succeeded.
Running transaction
  Preparing        :                                                                          1/1
  Installing       : libXi-1.7.10-1.el8.x86_64                                               1/22
  Installing       : libICE-1.0.9-15.el8.x86_64                                              2/22
  Installing       : libSM-1.2.3-1.el8.x86_64                                                3/22
  Installing       : libXt-1.1.5-12.el8.x86_64                                               4/22
  Installing       : libXmu-1.1.3-1.el8.x86_64                                               5/22
  Installing       : xorg-x11-xauth-1:1.0.9-12.el8.x86_64                                    6/22
  Installing       : libXtst-1.2.3-7.el8.x86_64                                              7/22
  Installing       : libstdc++-devel-8.5.0-26.0.1.el8_10.x86_64                              8/22
  Installing       : libdmx-1.1.4-3.el8.x86_64                                               9/22
  Installing       : libXxf86vm-1.1.4-9.el8.x86_64                                          10/22
  Installing       : libXxf86misc-1.0.4-1.el8.x86_64                                        11/22
  Installing       : libXxf86dga-1.1.5-1.el8.x86_64                                         12/22
  Installing       : libXv-1.0.11-7.el8.x86_64                                              13/22
  Installing       : libXrandr-1.5.2-1.el8.x86_64                                           14/22
  Installing       : libXinerama-1.1.4-1.el8.x86_64                                         15/22
  Installing       : libXcomposite-0.4.4-14.el8.x86_64                                      16/22
  Installing       : libX11-xcb-1.6.8-9.el8_10.x86_64                                       17/22
  Installing       : xorg-x11-utils-7.5-28.el8.x86_64                                       18/22
  Installing       : ksh-20120801-267.0.1.el8.x86_64                                        19/22
  Running scriptlet: ksh-20120801-267.0.1.el8.x86_64                                        19/22
  Installing       : libnsl-2.28-251.0.3.el8_10.14.x86_64                                   20/22
  Installing       : libaio-devel-0.3.112-1.el8.x86_64                                      21/22
  Running scriptlet: oracle-database-preinstall-19c-1.0-2.el8.x86_64                        22/22
  Installing       : oracle-database-preinstall-19c-1.0-2.el8.x86_64                        22/22
  Running scriptlet: oracle-database-preinstall-19c-1.0-2.el8.x86_64                        22/22
  Verifying        : libaio-devel-0.3.112-1.el8.x86_64                                       1/22
  Verifying        : libnsl-2.28-251.0.3.el8_10.14.x86_64                                    2/22
  Verifying        : ksh-20120801-267.0.1.el8.x86_64                                         3/22
  Verifying        : libICE-1.0.9-15.el8.x86_64                                              4/22
  Verifying        : libSM-1.2.3-1.el8.x86_64                                                5/22
  Verifying        : libX11-xcb-1.6.8-9.el8_10.x86_64                                        6/22
  Verifying        : libXcomposite-0.4.4-14.el8.x86_64                                       7/22
  Verifying        : libXi-1.7.10-1.el8.x86_64                                               8/22
  Verifying        : libXinerama-1.1.4-1.el8.x86_64                                          9/22
  Verifying        : libXmu-1.1.3-1.el8.x86_64                                              10/22
  Verifying        : libXrandr-1.5.2-1.el8.x86_64                                           11/22
  Verifying        : libXt-1.1.5-12.el8.x86_64                                              12/22
  Verifying        : libXtst-1.2.3-7.el8.x86_64                                             13/22
  Verifying        : libXv-1.0.11-7.el8.x86_64                                              14/22
  Verifying        : libXxf86dga-1.1.5-1.el8.x86_64                                         15/22
  Verifying        : libXxf86misc-1.0.4-1.el8.x86_64                                        16/22
  Verifying        : libXxf86vm-1.1.4-9.el8.x86_64                                          17/22
  Verifying        : libdmx-1.1.4-3.el8.x86_64                                              18/22
  Verifying        : libstdc++-devel-8.5.0-26.0.1.el8_10.x86_64                             19/22
  Verifying        : oracle-database-preinstall-19c-1.0-2.el8.x86_64                        20/22
  Verifying        : xorg-x11-utils-7.5-28.el8.x86_64                                       21/22
  Verifying        : xorg-x11-xauth-1:1.0.9-12.el8.x86_64                                   22/22

Installed:
  ksh-20120801-267.0.1.el8.x86_64               libICE-1.0.9-15.el8.x86_64
  libSM-1.2.3-1.el8.x86_64                      libX11-xcb-1.6.8-9.el8_10.x86_64
  libXcomposite-0.4.4-14.el8.x86_64             libXi-1.7.10-1.el8.x86_64
  libXinerama-1.1.4-1.el8.x86_64                libXmu-1.1.3-1.el8.x86_64
  libXrandr-1.5.2-1.el8.x86_64                  libXt-1.1.5-12.el8.x86_64
  libXtst-1.2.3-7.el8.x86_64                    libXv-1.0.11-7.el8.x86_64
  libXxf86dga-1.1.5-1.el8.x86_64                libXxf86misc-1.0.4-1.el8.x86_64
  libXxf86vm-1.1.4-9.el8.x86_64                 libaio-devel-0.3.112-1.el8.x86_64
  libdmx-1.1.4-3.el8.x86_64                     libnsl-2.28-251.0.3.el8_10.14.x86_64
  libstdc++-devel-8.5.0-26.0.1.el8_10.x86_64    oracle-database-preinstall-19c-1.0-2.el8.x86_64
  xorg-x11-utils-7.5-28.el8.x86_64              xorg-x11-xauth-1:1.0.9-12.el8.x86_64

Complete!
[root@ol8 opc]#
```
インストールディレクトリを作成して資材を展開します。
```
[root@ol8 opc]# mkdir /u01
[root@ol8 opc]# chown oracle:oinstall /u01
[root@ol8 opc]# su - oracle
Last login: Tue May 13 05:36:50 GMT 2025 on pts/0
[oracle@ol8 ~]$ mkdir -p /u01/app/oraInventory
[oracle@ol8 ~]$ ls -ld /u01/app/oraInventory
drwxr-xr-x. 2 oracle oinstall 6 May 13 05:38 /u01/app/oraInventory
[oracle@ol8 ~]$ mkdir -p /u01/app/oracle/product/19.0.0/client_1
[oracle@ol8 ~]$ ls -ld /u01/app/oracle/product/19.0.0/client_1
drwxr-xr-x. 2 oracle oinstall 6 May 13 05:38 /u01/app/oracle/product/19.0.0/client_1
[oracle@ol8 ~]$
[oracle@ol8 ~]$ unzip -q -d /u01/app/oracle/product/19.0.0/client_1/ /home/oracle/V982065-01.zip
```
runInstallerをサイレントインストールで実行するため、<展開ディレクトリ>/install/response/配下にあるレスポンスファイル(clientsetup.rsp)を事前に編集しておきます。
```txt:clientsetup.rsp
###############################################################################
## Copyright(c) Oracle Corporation 1998,2019. All rights reserved.           ##
##                                                                           ##
## Specify values for the variables listed below to customize                ##
## your installation.                                                        ##
##                                                                           ##
## Each variable is associated with a comment. The comment                   ##
## can help to populate the variables with the appropriate                   ##
## values.                                                                   ##
##                                                                           ##
###############################################################################


#-------------------------------------------------------------------------------
# Do not change the following system generated value.
#-------------------------------------------------------------------------------
oracle.install.responseFileVersion=/oracle/install/rspfmt_clientinstall_response_schema_v19.0.0

#-------------------------------------------------------------------------------
# Unix group to be set for the inventory directory.
#-------------------------------------------------------------------------------
UNIX_GROUP_NAME=oinstall
#-------------------------------------------------------------------------------
# Inventory location.
#-------------------------------------------------------------------------------
INVENTORY_LOCATION=/u01/app/oraInventory
#-------------------------------------------------------------------------------
# Complete path of the Oracle Base.
#-------------------------------------------------------------------------------
ORACLE_BASE=/u01/app/oracle
```

19cのインストール時のバージョン(19.3)ではOracle Linux 8ではサポートされていないため、以下マニュアルに従い最新のRUを適用しながらインストールを実行します。
[Oracle Linux 8およびRed Hat Enterprise Linux 8でのOracle Database 19cのインストール](https://docs.oracle.com/cd/F19136_01/rnrdm/linux-platform-issues.html#GUID-9D58E3B4-8E7B-4182-86A1-78321A999B52)

事前にOPatch([Patch 6880880](https://updates.oracle.com/download/6880880.html))をダウンロードしてインストールディレクトリのものと置き換えます。
```
[oracle@ol8 ~]$ ls -l /home/oracle/p6880880_190000_Linux-x86-64.zip
-rw-r--r--. 1 oracle oinstall 72539776 May 12 05:14 /home/oracle/p6880880_190000_Linux-x86-64.zip
[oracle@ol8 ~]$ mv /u01/app/oracle/product/19.0.0/client_1/OPatch /u01/app/oracle/product/19.0.0/client_1/OPatch.org
[oracle@ol8 ~]$ unzip -q -d /u01/app/oracle/product/19.0.0/client_1/ p6880880_190000_Linux-x86-64.zip
[oracle@ol8 ~]$ ls -ld /u01/app/oracle/product/19.0.0/client_1/OPatch*
drwxr-x---. 15 oracle oinstall 4096 Apr  6 12:03 /u01/app/oracle/product/19.0.0/client_1/OPatch
drwxr-xr-x. 12 oracle oinstall 4096 Apr 17  2019 /u01/app/oracle/product/19.0.0/client_1/OPatch.org
```

RUは2025/5時点で最新の19.27([Patch 37642901](https://updates.oracle.com/download/37642901.html))をダウンロードしてサーバに配置し、事前に解凍しておきます。
```
[oracle@ol8 ~]$ unzip -q p37642901_190000_Linux-x86-64.zip
[oracle@ol8 ~]$ ls -l 37642901/
total 104
drwxr-x---.  3 oracle oinstall    20 Apr 15 08:21 etc
drwxr-x---. 47 oracle oinstall  4096 Apr 15 08:17 files
-rw-r--r--.  1 oracle oinstall 97600 Apr 22 10:24 README.html
-rw-r--r--.  1 oracle oinstall    21 Apr 15 08:21 README.txt
```

applyRUオプションを利用してRUを適用したうえでインストールを実施します。
```
[oracle@ol8 ~]$ export CV_ASSUME_DISTID=OL7
[oracle@ol8 ~]$ /u01/app/oracle/product/19.0.0/client_1/runInstaller \
> -applyRU /home/oracle/37642901 \
> -silent \
> -responseFile /u01/app/oracle/product/19.0.0/client_1/install/response/clientsetup.rsp
Preparing the home to patch...
Applying the patch /home/oracle/37642901...
Successfully applied the patch.
The log can be found at: /tmp/InstallActions2025-05-13_06-47-20AM/installerPatchActions_2025-05-13_06-47-20AM.log
Launching Oracle Database Client Setup Wizard...

[WARNING] [INS-13014] Target environment does not meet some optional requirements.
   CAUSE: Some of the optional prerequisites are not met. See logs for details. installActions2025-05-13_06-47-20AM.log
   ACTION: Identify the list of failed prerequisite checks from the log: installActions2025-05-13_06-47-20AM.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/oracle/product/19.0.0/client_1/install/response/client_2025-05-13_06-47-20AM.rsp

You can find the log of this install session at:
 /tmp/InstallActions2025-05-13_06-47-20AM/installActions2025-05-13_06-47-20AM.log

As a root user, execute the following script(s):
        1. /u01/app/oraInventory/orainstRoot.sh

Execute /u01/app/oraInventory/orainstRoot.sh on the following nodes:
[ol8]


Successfully Setup Software with warning(s).
Moved the install session logs to:
 /u01/app/oraInventory/logs/InstallActions2025-05-13_06-47-20AM
[oracle@ol8 ~]$
[oracle@ol8 ~]$ exit
[root@ol8 opc]# /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.
```
警告として発生しているINS-13014に関してはインストールログより compat-libcap1-1.10 のパッケージが欠落している内容のメッセージです。
こちらは以下マニュアルに記載のバグ29772579の内容で無視可能です。

https://docs.oracle.com/cd/F19136_01/rnrdm/linux-platform-issues.html#GUID-69942B7A-B662-48DC-8FC1-DFC56A3719D6


```txt:installActions2025-05-13_06-47-20AM.log
INFO:  [May 13, 2025 6:50:43 AM] ------------------List of failed Tasks------------------
INFO:  [May 13, 2025 6:50:43 AM] *********************************************
INFO:  [May 13, 2025 6:50:43 AM] Swap Size: This is a prerequisite condition to test whether sufficient total swap space is available on the system.
INFO:  [May 13, 2025 6:50:43 AM] Severity:IGNORABLE
INFO:  [May 13, 2025 6:50:43 AM] OverallStatus:VERIFICATION_FAILED
INFO:  [May 13, 2025 6:50:43 AM] *********************************************
INFO:  [May 13, 2025 6:50:43 AM] Package: compat-libcap1-1.10: This is a prerequisite condition to test whether the package "compat-libcap1-1.10" is available on the system.
INFO:  [May 13, 2025 6:50:43 AM] Severity:IGNORABLE
INFO:  [May 13, 2025 6:50:43 AM] OverallStatus:VERIFICATION_FAILED
INFO:  [May 13, 2025 6:50:43 AM] -----------------End of failed Tasks List----------------
WARNING:  [May 13, 2025 6:50:43 AM] [WARNING] [INS-13014] Target environment does not meet some optional requirements.
   CAUSE: Some of the optional prerequisites are not met. See logs for details. installActions2025-05-13_06-47-20AM.log
   ACTION: Identify the list of failed prerequisite checks from the log: installActions2025-05-13_06-47-20AM.log. Then either from the log file or from installation manual find the appropriate configuration to meet the prerequisites and fix it manually.
   
```
#### JDBCドライバ確認
ドライバは$ORACLE_HOME/jdbc/lib配下にあります。
Oracle Client 19cではojdbc8.jarとojdbc10.jarが同梱されています。
```
[oracle@ol8 ~]$ cd /u01/app/oracle/product/19.0.0/client_1/jdbc/lib
[oracle@ol8 lib]$ pwd
/u01/app/oracle/product/19.0.0/client_1/jdbc/lib
[oracle@ol8 lib]$ ls -l
total 51144
-rw-r--r--. 1 oracle oinstall 7673052 Apr 15 08:21 ojdbc10dms_g.jar
-rw-r--r--. 1 oracle oinstall 6353008 Apr 15 08:21 ojdbc10dms.jar
-rw-r--r--. 1 oracle oinstall 7643347 Apr 15 08:21 ojdbc10_g.jar
-rw-r--r--. 1 oracle oinstall 4567139 Apr 15 08:21 ojdbc10.jar
-rw-r--r--. 1 oracle oinstall 7629107 Apr 15 08:21 ojdbc8dms_g.jar
-rw-r--r--. 1 oracle oinstall 6316884 Apr 15 08:21 ojdbc8dms.jar
-rw-r--r--. 1 oracle oinstall 7599227 Apr 15 08:21 ojdbc8_g.jar
-rw-r--r--. 1 oracle oinstall 4534022 Apr 15 08:21 ojdbc8.jar
-rw-r--r--. 1 oracle oinstall   29207 Apr 15 08:21 simplefan.jar
[oracle@ol8 lib]$
```
JDBCのバージョンは ```java -jar ojdbcX.jar -version``` コマンドで確認可能です。
ojdbc8.jarではJDBC 4.2ベース、ojdbc10.jarではJDBC 4.3ベースであることがわかります。
```
[oracle@ol8 lib]$ java -jar ojdbc8.jar -version
Oracle 19.27.0.0.0 JDBC 4.2 compiled with javac 1.8.0_441 on Fri_Feb_28_06:18:47_PST_2025
#Default Connection Properties Resource
#Tue May 13 07:25:44 GMT 2025

***** JCE UNLIMITED STRENGTH IS INSTALLED ****

[oracle@ol8 lib]$ java -jar ojdbc10.jar -version
Oracle 19.27.0.0.0 JDBC 4.3 compiled with javac 10 on Fri_Feb_28_06:19:40_PST_2025
#Default Connection Properties Resource
#Tue May 13 07:26:00 GMT 2025

***** JCE UNLIMITED STRENGTH IS INSTALLED ****
```

### Oracle Client 21c
#### Oracle Clientインストール
19cと同じく前提パッケージをpreinstallerからインストールします。
```
[opc@ol8 ~]$ sudo -s
[root@ol8 opc]# yum search preinstall
Last metadata expiration check: 0:00:18 ago on Tue 13 May 2025 08:01:12 AM GMT.
============================================= Name & Summary Matched: preinstall ==============================================
oracle-database-preinstall-19c.src : Oracle Database Preinstallation RPM
oracle-database-preinstall-19c.x86_64 : Oracle Database Preinstallation RPM
oracle-database-preinstall-21c.src : Oracle Database Preinstallation RPM
oracle-database-preinstall-21c.x86_64 : Oracle Database Preinstallation RPM
oracle-database-preinstall-23ai.src : Oracle Database Preinstallation RPM
oracle-database-preinstall-23ai.x86_64 : Oracle Database Preinstallation RPM
================================================== Name Matched: preinstall ===================================================
oracle-ebs-server-R12-preinstall.src : Sets the system for Oracle E-Business Suite Release 12 for Oracle Linux 8
oracle-ebs-server-R12-preinstall.x86_64 : Sets the system for Oracle E-Business Suite Release 12 for Oracle Linux 8

[root@ol8 opc]# yum install -y oracle-database-preinstall-21c.x86_64
Last metadata expiration check: 0:00:45 ago on Tue 13 May 2025 08:01:12 AM GMT.
Dependencies resolved.
===============================================================================================================================
 Package                                  Architecture     Version                           Repository                   Size
===============================================================================================================================
Installing:
 oracle-database-preinstall-21c           x86_64           1.0-1.el8                         ol8_appstream                30 k
Installing dependencies:
 compat-openssl10                         x86_64           1:1.0.2o-4.el8_6                  ol8_appstream               1.1 M
 ksh                                      x86_64           20120801-267.0.1.el8              ol8_appstream               923 k
 libICE                                   x86_64           1.0.9-15.el8                      ol8_appstream                74 k
 libSM                                    x86_64           1.2.3-1.el8                       ol8_appstream                47 k
 libX11-xcb                               x86_64           1.6.8-9.el8_10                    ol8_appstream                14 k
 libXcomposite                            x86_64           0.4.4-14.el8                      ol8_appstream                28 k
 libXi                                    x86_64           1.7.10-1.el8                      ol8_appstream                49 k
 libXinerama                              x86_64           1.1.4-1.el8                       ol8_appstream                15 k
 libXmu                                   x86_64           1.1.3-1.el8                       ol8_appstream                75 k
 libXrandr                                x86_64           1.5.2-1.el8                       ol8_appstream                34 k
 libXt                                    x86_64           1.1.5-12.el8                      ol8_appstream               185 k
 libXtst                                  x86_64           1.2.3-7.el8                       ol8_appstream                22 k
 libXv                                    x86_64           1.0.11-7.el8                      ol8_appstream                20 k
 libXxf86dga                              x86_64           1.1.5-1.el8                       ol8_appstream                26 k
 libXxf86misc                             x86_64           1.0.4-1.el8                       ol8_appstream                23 k
 libXxf86vm                               x86_64           1.1.4-9.el8                       ol8_appstream                19 k
 libdmx                                   x86_64           1.1.4-3.el8                       ol8_appstream                22 k
 libnsl                                   x86_64           2.28-251.0.3.el8_10.14            ol8_baseos_latest           115 k
 xorg-x11-utils                           x86_64           7.5-28.el8                        ol8_appstream               136 k
 xorg-x11-xauth                           x86_64           1:1.0.9-12.el8                    ol8_appstream                39 k

Transaction Summary
===============================================================================================================================
Install  21 Packages

Total download size: 3.0 M
Installed size: 8.0 M
Downloading Packages:
(1/21): libnsl-2.28-251.0.3.el8_10.14.x86_64.rpm                                               3.7 MB/s | 115 kB     00:00
(2/21): libICE-1.0.9-15.el8.x86_64.rpm                                                         8.4 MB/s |  74 kB     00:00
(3/21): compat-openssl10-1.0.2o-4.el8_6.x86_64.rpm                                              23 MB/s | 1.1 MB     00:00
(4/21): libSM-1.2.3-1.el8.x86_64.rpm                                                           4.3 MB/s |  47 kB     00:00
(5/21): ksh-20120801-267.0.1.el8.x86_64.rpm                                                     16 MB/s | 923 kB     00:00
(6/21): libX11-xcb-1.6.8-9.el8_10.x86_64.rpm                                                   1.4 MB/s |  14 kB     00:00
(7/21): libXcomposite-0.4.4-14.el8.x86_64.rpm                                                  3.0 MB/s |  28 kB     00:00
(8/21): libXinerama-1.1.4-1.el8.x86_64.rpm                                                     3.2 MB/s |  15 kB     00:00
(9/21): libXi-1.7.10-1.el8.x86_64.rpm                                                          5.4 MB/s |  49 kB     00:00
(10/21): libXrandr-1.5.2-1.el8.x86_64.rpm                                                      6.5 MB/s |  34 kB     00:00
(11/21): libXmu-1.1.3-1.el8.x86_64.rpm                                                         6.9 MB/s |  75 kB     00:00
(12/21): libXtst-1.2.3-7.el8.x86_64.rpm                                                        5.2 MB/s |  22 kB     00:00
(13/21): libXt-1.1.5-12.el8.x86_64.rpm                                                          18 MB/s | 185 kB     00:00
(14/21): libXv-1.0.11-7.el8.x86_64.rpm                                                         2.6 MB/s |  20 kB     00:00
(15/21): libXxf86misc-1.0.4-1.el8.x86_64.rpm                                                   5.3 MB/s |  23 kB     00:00
(16/21): libXxf86vm-1.1.4-9.el8.x86_64.rpm                                                     5.6 MB/s |  19 kB     00:00
(17/21): libdmx-1.1.4-3.el8.x86_64.rpm                                                         6.2 MB/s |  22 kB     00:00
(18/21): libXxf86dga-1.1.5-1.el8.x86_64.rpm                                                    2.0 MB/s |  26 kB     00:00
(19/21): oracle-database-preinstall-21c-1.0-1.el8.x86_64.rpm                                   4.2 MB/s |  30 kB     00:00
(20/21): xorg-x11-xauth-1.0.9-12.el8.x86_64.rpm                                                6.6 MB/s |  39 kB     00:00
(21/21): xorg-x11-utils-7.5-28.el8.x86_64.rpm                                                   13 MB/s | 136 kB     00:00
-------------------------------------------------------------------------------------------------------------------------------
Total                                                                                           30 MB/s | 3.0 MB     00:00
Running transaction check
Transaction check succeeded.
Running transaction test
Transaction test succeeded.
Running transaction
  Preparing        :                                                                                                       1/1
  Installing       : libXi-1.7.10-1.el8.x86_64                                                                            1/21
  Installing       : libICE-1.0.9-15.el8.x86_64                                                                           2/21
  Installing       : libSM-1.2.3-1.el8.x86_64                                                                             3/21
  Installing       : libXt-1.1.5-12.el8.x86_64                                                                            4/21
  Installing       : libXmu-1.1.3-1.el8.x86_64                                                                            5/21
  Installing       : xorg-x11-xauth-1:1.0.9-12.el8.x86_64                                                                 6/21
  Installing       : libXtst-1.2.3-7.el8.x86_64                                                                           7/21
  Installing       : libdmx-1.1.4-3.el8.x86_64                                                                            8/21
  Installing       : libXxf86vm-1.1.4-9.el8.x86_64                                                                        9/21
  Installing       : libXxf86misc-1.0.4-1.el8.x86_64                                                                     10/21
  Installing       : libXxf86dga-1.1.5-1.el8.x86_64                                                                      11/21
  Installing       : libXv-1.0.11-7.el8.x86_64                                                                           12/21
  Installing       : libXrandr-1.5.2-1.el8.x86_64                                                                        13/21
  Installing       : libXinerama-1.1.4-1.el8.x86_64                                                                      14/21
  Installing       : libXcomposite-0.4.4-14.el8.x86_64                                                                   15/21
  Installing       : libX11-xcb-1.6.8-9.el8_10.x86_64                                                                    16/21
  Installing       : xorg-x11-utils-7.5-28.el8.x86_64                                                                    17/21
  Installing       : ksh-20120801-267.0.1.el8.x86_64                                                                     18/21
  Running scriptlet: ksh-20120801-267.0.1.el8.x86_64                                                                     18/21
  Installing       : compat-openssl10-1:1.0.2o-4.el8_6.x86_64                                                            19/21
  Running scriptlet: compat-openssl10-1:1.0.2o-4.el8_6.x86_64                                                            19/21
  Installing       : libnsl-2.28-251.0.3.el8_10.14.x86_64                                                                20/21
  Installing       : oracle-database-preinstall-21c-1.0-1.el8.x86_64                                                     21/21
  Running scriptlet: oracle-database-preinstall-21c-1.0-1.el8.x86_64                                                     21/21
  Verifying        : libnsl-2.28-251.0.3.el8_10.14.x86_64                                                                 1/21
  Verifying        : compat-openssl10-1:1.0.2o-4.el8_6.x86_64                                                             2/21
  Verifying        : ksh-20120801-267.0.1.el8.x86_64                                                                      3/21
  Verifying        : libICE-1.0.9-15.el8.x86_64                                                                           4/21
  Verifying        : libSM-1.2.3-1.el8.x86_64                                                                             5/21
  Verifying        : libX11-xcb-1.6.8-9.el8_10.x86_64                                                                     6/21
  Verifying        : libXcomposite-0.4.4-14.el8.x86_64                                                                    7/21
  Verifying        : libXi-1.7.10-1.el8.x86_64                                                                            8/21
  Verifying        : libXinerama-1.1.4-1.el8.x86_64                                                                       9/21
  Verifying        : libXmu-1.1.3-1.el8.x86_64                                                                           10/21
  Verifying        : libXrandr-1.5.2-1.el8.x86_64                                                                        11/21
  Verifying        : libXt-1.1.5-12.el8.x86_64                                                                           12/21
  Verifying        : libXtst-1.2.3-7.el8.x86_64                                                                          13/21
  Verifying        : libXv-1.0.11-7.el8.x86_64                                                                           14/21
  Verifying        : libXxf86dga-1.1.5-1.el8.x86_64                                                                      15/21
  Verifying        : libXxf86misc-1.0.4-1.el8.x86_64                                                                     16/21
  Verifying        : libXxf86vm-1.1.4-9.el8.x86_64                                                                       17/21
  Verifying        : libdmx-1.1.4-3.el8.x86_64                                                                           18/21
  Verifying        : oracle-database-preinstall-21c-1.0-1.el8.x86_64                                                     19/21
  Verifying        : xorg-x11-utils-7.5-28.el8.x86_64                                                                    20/21
  Verifying        : xorg-x11-xauth-1:1.0.9-12.el8.x86_64                                                                21/21

Installed:
  compat-openssl10-1:1.0.2o-4.el8_6.x86_64          ksh-20120801-267.0.1.el8.x86_64    libICE-1.0.9-15.el8.x86_64
  libSM-1.2.3-1.el8.x86_64                          libX11-xcb-1.6.8-9.el8_10.x86_64   libXcomposite-0.4.4-14.el8.x86_64
  libXi-1.7.10-1.el8.x86_64                         libXinerama-1.1.4-1.el8.x86_64     libXmu-1.1.3-1.el8.x86_64
  libXrandr-1.5.2-1.el8.x86_64                      libXt-1.1.5-12.el8.x86_64          libXtst-1.2.3-7.el8.x86_64
  libXv-1.0.11-7.el8.x86_64                         libXxf86dga-1.1.5-1.el8.x86_64     libXxf86misc-1.0.4-1.el8.x86_64
  libXxf86vm-1.1.4-9.el8.x86_64                     libdmx-1.1.4-3.el8.x86_64          libnsl-2.28-251.0.3.el8_10.14.x86_64
  oracle-database-preinstall-21c-1.0-1.el8.x86_64   xorg-x11-utils-7.5-28.el8.x86_64   xorg-x11-xauth-1:1.0.9-12.el8.x86_64

Complete!
[root@ol8 opc]#
```
インストールディレクトリを作成して資材を展開します。
```
[root@ol8 opc]# mkdir /u01
[root@ol8 opc]# chown oracle:oinstall /u01
[root@ol8 opc]# su - oracle
[oracle@ol8 ~]$ mkdir -p /u01/app/oraInventory
[oracle@ol8 ~]$ ls -ld /u01/app/oraInventory
drwxr-xr-x. 2 oracle oinstall 6 May 13 08:03 /u01/app/oraInventory
[oracle@ol8 ~]$ mkdir -p /u01/app/oracle/product/21.0.0/client_1
[oracle@ol8 ~]$ ls -ld /u01/app/oracle/product/21.0.0/client_1
drwxr-xr-x. 2 oracle oinstall 6 May 13 08:03 /u01/app/oracle/product/21.0.0/client_1
[oracle@ol8 ~]$ unzip -q -d /u01/app/oracle/product/21.0.0/client_1/ /home/oracle/V1011500-01.zip
```

レスポンスファイルを事前に編集しておきます。
oracle.install.responseFileVersionのパラメータ以外は19cと同様ですね。
```txt:clientsetup.rsp
###############################################################################
## Copyright(c) Oracle Corporation 1998,2021. All rights reserved.           ##
##                                                                           ##
## Specify values for the variables listed below to customize                ##
## your installation.                                                        ##
##                                                                           ##
## Each variable is associated with a comment. The comment                   ##
## can help to populate the variables with the appropriate                   ##
## values.                                                                   ##
##                                                                           ##
###############################################################################


#-------------------------------------------------------------------------------
# Do not change the following system generated value.
#-------------------------------------------------------------------------------
oracle.install.responseFileVersion=/oracle/install/rspfmt_clientinstall_response_schema_v21.0.0

#-------------------------------------------------------------------------------
# Unix group to be set for the inventory directory.
#-------------------------------------------------------------------------------
UNIX_GROUP_NAME=oinstall
#-------------------------------------------------------------------------------
# Inventory location.
#-------------------------------------------------------------------------------
INVENTORY_LOCATION=/u01/app/oraInventory
#-------------------------------------------------------------------------------
# Complete path of the Oracle Base.
#-------------------------------------------------------------------------------
ORACLE_BASE=/u01/app/oracle
```

21cではベースリリースでOracle Linux 8でもインストール可能です。
サイレントインストールでインストールを実施します。
```
[oracle@ol8 ~]$ /u01/app/oracle/product/21.0.0/client_1/runInstaller \
> -silent \
> -responseFile /u01/app/oracle/product/21.0.0/client_1/install/response/clientsetup.rsp
Launching Oracle Database Client Setup Wizard...

[WARNING] [INS-13014] Target environment does not meet some optional requirements.
   CAUSE: Some of the optional prerequisites are not met. See logs for details. installActions2025-05-13_08-15-58AM.log
   ACTION: Identify the list of failed prerequisite checks from the log: installActions2025-05-13_08-15-58AM.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/oracle/product/21.0.0/client_1/install/response/client_2025-05-13_08-15-58AM.rsp

You can find the log of this install session at:
 /tmp/InstallActions2025-05-13_08-15-58AM/installActions2025-05-13_08-15-58AM.log

As a root user, execute the following script(s):
        1. /u01/app/oraInventory/orainstRoot.sh

Execute /u01/app/oraInventory/orainstRoot.sh on the following nodes:
[ol8]


Successfully Setup Software with warning(s).
Moved the install session logs to:
 /u01/app/oraInventory/logs/InstallActions2025-05-13_08-15-58AM
[oracle@ol8 ~]$
[oracle@ol8 ~]$ logout
[root@ol8 opc]# /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.
```

今回発生したINS-13014はswapサイズ不足の警告ですが、今回はアプリケーションとしては利用しないので無視します。
```txt:installActions2025-05-13_08-15-58AM.log
INFO:  [May 13, 2025 8:16:02 AM] ------------------List of failed Tasks------------------
INFO:  [May 13, 2025 8:16:02 AM] *********************************************
INFO:  [May 13, 2025 8:16:02 AM] Swap Size: This is a prerequisite condition to test whether sufficient total swap space is available on the system.
INFO:  [May 13, 2025 8:16:02 AM] Severity:IGNORABLE
INFO:  [May 13, 2025 8:16:02 AM] OverallStatus:VERIFICATION_FAILED
INFO:  [May 13, 2025 8:16:02 AM] -----------------End of failed Tasks List----------------
WARNING:  [May 13, 2025 8:16:02 AM] [WARNING] [INS-13014] Target environment does not meet some optional requirements.
   CAUSE: Some of the optional prerequisites are not met. See logs for details. installActions2025-05-13_08-15-58AM.log
   ACTION: Identify the list of failed prerequisite checks from the log: installActions2025-05-13_08-15-58AM.log. Then either from the log file or from installation manual find the appropriate configuration to meet the prerequisites and fix it manually.
```

その後21cの最新RUを適用します。2025/5時点で最新の21.18([Patch 37655430](https://updates.oracle.com/download/37655430.html))および最新のOPatch([Patch 6880880](https://updates.oracle.com/download/6880880.html))をダウンロードしてサーバに配置し、パッチを適用していきます。
```
[oracle@ol8 ~]$ ls -l /home/oracle/p6880880_210000_Linux-x86-64.zip
-rw-r--r--. 1 oracle oinstall 72539776 May 13 02:53 /home/oracle/p6880880_210000_Linux-x86-64.zip

[oracle@ol8 ~]$ mv /u01/app/oracle/product/21.0.0/client_1/OPatch /u01/app/oracle/product/21.0.0/client_1/OPatch.org
[oracle@ol8 ~]$ unzip -q -d /u01/app/oracle/product/21.0.0/client_1/ p6880880_210000_Linux-x86-64.zip
[oracle@ol8 ~]$ ls -ld /u01/app/oracle/product/21.0.0/client_1/OPatch*
drwxr-x---. 15 oracle oinstall 4096 Apr  6 12:03 /u01/app/oracle/product/21.0.0/client_1/OPatch
drwxr-xr-x. 13 oracle oinstall 4096 Jul 27  2021 /u01/app/oracle/product/21.0.0/client_1/OPatch.org

[oracle@ol8 ~]$ ls -l p37655430_210000_Linux-x86-64.zip
-rw-r--r--. 1 oracle oinstall 1678059603 May 13 02:55 p37655430_210000_Linux-x86-64.zip

[oracle@ol8 ~]$ unzip -q p37655430_210000_Linux-x86-64.zip
[oracle@ol8 ~]$ cd 37655430/
[oracle@ol8 37655430]$ ls -l
total 92
drwxr-x---.  3 oracle oinstall    20 Apr  8 06:08 etc
drwxr-x---. 42 oracle oinstall  4096 Apr  8 06:05 files
-rw-r--r--.  1 oracle oinstall 84851 Apr 15 12:21 README.html
-rw-r--r--.  1 oracle oinstall    21 Apr  8 06:08 README.txt

[oracle@ol8 37655430]$ /u01/app/oracle/product/21.0.0/client_1/OPatch/opatch lspatches
There are no Interim patches installed in this Oracle Home "/u01/app/oracle/product/21.0.0/client_1".

OPatch succeeded.
[oracle@ol8 37655430]$
[oracle@ol8 37655430]$ /u01/app/oracle/product/21.0.0/client_1/OPatch/opatch apply
Oracle Interim Patch Installer version 12.2.0.1.46
Copyright (c) 2025, Oracle Corporation.  All rights reserved.


Oracle Home       : /u01/app/oracle/product/21.0.0/client_1
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/21.0.0/client_1/oraInst.loc
OPatch version    : 12.2.0.1.46
OUI version       : 12.2.0.9.0
Log file location : /u01/app/oracle/product/21.0.0/client_1/cfgtoollogs/opatch/opatch2025-05-13_08-30-46AM_1.log

Verifying environment and performing prerequisite checks...
OPatch continues with these patches:   37655430

Do you want to proceed? [y|n]
y
User Responded with: Y
All checks passed.

Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/u01/app/oracle/product/21.0.0/client_1')


Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files...
Applying interim patch '37655430' to OH '/u01/app/oracle/product/21.0.0/client_1'
ApplySession: Optional component(s) [ oracle.rdbms, 21.0.0.0.0 ] , [ oracle.blaslapack, 21.0.0.0.0 ] , [ oracle.ctx, 21.0.0.0.0 ] , [ oracle.javavm.server, 21.0.0.0.0 ] , [ oracle.javavm.server.core, 21.0.0.0.0 ] , [ oracle.network.gsm, 21.0.0.0.0 ] , [ oracle.oraml.server, 21.0.0.0.0 ] , [ oracle.python, 3.9.5.0.0 ] , [ oracle.sdo, 21.0.0.0.0 ] , [ oracle.sdo.locator.jrf, 21.0.0.0.0 ] , [ oracle.tfa, 21.0.0.0.0 ] , [ oracle.tfa.db, 21.0.0.0.0 ] , [ oracle.pg4appc, 21.0.0.0.0 ] , [ oracle.sysman.ccr.client, 21.0.0.0.0 ] , [ oracle.sdo.companion, 21.0.0.0.0 ] , [ oracle.duma, 21.0.0.0.0 ] , [ oracle.rdbms.tg4db2, 21.0.0.0.0 ] , [ oracle.rdbms.tg4msql, 21.0.0.0.0 ] , [ oracle.rdbms.tg4tera, 21.0.0.0.0 ] , [ oracle.ovm, 21.0.0.0.0 ] , [ oracle.ons.cclient, 21.0.0.0.0 ] , [ oracle.rdbms.dv, 21.0.0.0.0 ] , [ oracle.precomp.companion, 21.0.0.0.0 ] , [ oracle.net.cman, 21.0.0.0.0 ] , [ oracle.rdbms.scheduler, 21.0.0.0.0 ] , [ oracle.ctx.rsf, 21.0.0.0.0 ] , [ oracle.rdbms.tg4sybs, 21.0.0.0.0 ] , [ oracle.rdbms.hs_common, 21.0.0.0.0 ] , [ oracle.rdbms.hsodbc, 21.0.0.0.0 ] , [ oracle.ctx.atg, 21.0.0.0.0 ] , [ oracle.oid.client, 21.0.0.0.0 ] , [ oracle.rdbms.tg4ifxm, 21.0.0.0.0 ] , [ oracle.assistants.server, 21.0.0.0.0 ] , [ oracle.rdbms.lbac, 21.0.0.0.0 ] , [ oracle.sdo.locator, 21.0.0.0.0 ] , [ oracle.ons.eons.bwcompat, 21.0.0.0.0 ] , [ oracle.rdbms.tg4ifmx, 21.0.0.0.0 ] , [ oracle.network.listener, 21.0.0.0.0 ] , [ oracle.network.cman, 21.0.0.0.0 ] , [ oracle.jdk, 1.8.0.271.00 ] , [ oracle.pg4mq, 21.0.0.0.0 ]  not present in the Oracle Home or a higher version is found.

Patching component oracle.rdbms.rsf, 21.0.0.0.0...

Patching component oracle.rdbms.util, 21.0.0.0.0...

Patching component oracle.network.rsf, 21.0.0.0.0...

Patching component oracle.buildtools.rsf, 21.0.0.0.0...

Patching component oracle.dbdev, 21.0.0.0.0...

Patching component oracle.dbjava.ic, 21.0.0.0.0...

Patching component oracle.dbjava.jdbc, 21.0.0.0.0...

Patching component oracle.dbjava.ucp, 21.0.0.0.0...

Patching component oracle.has.common.cvu, 21.0.0.0.0...

Patching component oracle.ldap.owm, 21.0.0.0.0...

Patching component oracle.ldap.rsf, 21.0.0.0.0...

Patching component oracle.ldap.rsf.ic, 21.0.0.0.0...

Patching component oracle.ldap.security.osdt, 21.0.0.0.0...

Patching component oracle.nlsrtl.rsf, 21.0.0.0.0...

Patching component oracle.perlint, 5.32.0.0.0...

Patching component oracle.rdbms.crs, 21.0.0.0.0...

Patching component oracle.rdbms.dbscripts, 21.0.0.0.0...

Patching component oracle.rdbms.deconfig, 21.0.0.0.0...

Patching component oracle.rdbms.install.plugins, 21.0.0.0.0...

Patching component oracle.rdbms.rman, 21.0.0.0.0...

Patching component oracle.rdbms.rsf.ic, 21.0.0.0.0...

Patching component oracle.sqlplus, 21.0.0.0.0...

Patching component oracle.ons, 21.0.0.0.0...

Patching component oracle.usm.deconfig, 21.0.0.0.0...

Patching component oracle.xdk.xquery, 21.0.0.0.0...

Patching component oracle.rdbms.ic, 21.0.0.0.0...

Patching component oracle.assistants.acf, 21.0.0.0.0...

Patching component oracle.precomp.rsf, 21.0.0.0.0...

Patching component oracle.odbc, 21.0.0.0.0...

Patching component oracle.xdk, 21.0.0.0.0...

Patching component oracle.xdk.rsf, 21.0.0.0.0...

Patching component oracle.rdbms.oci, 21.0.0.0.0...

Patching component oracle.ldap.client, 21.0.0.0.0...

Patching component oracle.assistants.deconfig, 21.0.0.0.0...

Patching component oracle.ons.ic, 21.0.0.0.0...

Patching component oracle.oraolap.mgmt, 21.0.0.0.0...

Patching component oracle.xdk.parser.java, 21.0.0.0.0...

Patching component oracle.sqlplus.ic, 21.0.0.0.0...

Patching component oracle.ldap.ssl, 21.0.0.0.0...

Patching component oracle.oracore.rsf, 21.0.0.0.0...

Patching component oracle.precomp.lang, 21.0.0.0.0...

Patching component oracle.precomp.common, 21.0.0.0.0...

Patching component oracle.jdk, 1.8.0.291.09...

Patching component oracle.precomp.common.core, 21.0.0.0.0...

Patching component oracle.rdbms.install.common, 21.0.0.0.0...
Patch 37655430 successfully applied.
Log file location: /u01/app/oracle/product/21.0.0/client_1/cfgtoollogs/opatch/opatch2025-05-13_08-30-46AM_1.log

OPatch succeeded.

[oracle@ol8 37655430]$ /u01/app/oracle/product/21.0.0/client_1/OPatch/opatch lspatches
37655430;Database Release Update : 21.18.0.0.250415 (37655430)

OPatch succeeded.
```
#### JDBCドライバ確認
Oracle Client 21cではojdbc8.jarとojdbc11.jarが同梱されています。
```
[oracle@ol8 37655430]$ cd /u01/app/oracle/product/21.0.0/client_1/jdbc/lib
[oracle@ol8 lib]$ pwd
/u01/app/oracle/product/21.0.0/client_1/jdbc/lib
[oracle@ol8 lib]$ ls -l
total 58472
-rw-r-----. 1 oracle oinstall 8726547 Apr  8 06:06 ojdbc11dms_g.jar
-rw-r-----. 1 oracle oinstall 7288150 Apr  8 06:06 ojdbc11dms.jar
-rw-r-----. 1 oracle oinstall 8724679 Apr  8 06:06 ojdbc11_g.jar
-rw-r-----. 1 oracle oinstall 5251901 Apr  8 06:06 ojdbc11.jar
-rw-r-----. 1 oracle oinstall 8581439 Apr  8 06:06 ojdbc8dms_g.jar
-rw-r-----. 1 oracle oinstall 7165124 Apr  8 06:06 ojdbc8dms.jar
-rw-r-----. 1 oracle oinstall 8579586 Apr  8 06:06 ojdbc8_g.jar
-rw-r-----. 1 oracle oinstall 5159559 Apr  8 06:06 ojdbc8.jar
-rw-r-----. 1 oracle oinstall  342572 Jul  1  2021 rsi.jar
-rw-r-----. 1 oracle oinstall   29243 Apr  8 06:06 simplefan.jar

[oracle@ol8 lib]$ java -jar ojdbc8.jar -version
Oracle 21.18.0.0.0 JDBC 4.2 compiled with javac 1.8.0_431 on Wed_Feb_19_01:16:44_PST_2025
#Default Connection Properties Resource
#Tue May 13 08:36:02 GMT 2025

***** JCE UNLIMITED STRENGTH IS INSTALLED ****
[oracle@ol8 lib]$ java -jar ojdbc11.jar -version
Oracle 21.18.0.0.0 JDBC 4.3 compiled with javac 11.0.1 on Wed_Feb_19_01:17:57_PST_2025
#Default Connection Properties Resource
#Tue May 13 08:36:10 GMT 2025

***** JCE UNLIMITED STRENGTH IS INSTALLED ****
```

### Oracle Client 23ai
#### Oracle Clientインストール
他と同様に前提パッケージをpreinstallerからインストールします。
```
[opc@ol8 ~]$ sudo -s
[root@ol8 opc]# yum search preinstall
Last metadata expiration check: 0:00:26 ago on Tue 13 May 2025 09:11:08 AM GMT.
================================== Name & Summary Matched: preinstall ==================================
oracle-database-preinstall-19c.src : Oracle Database Preinstallation RPM
oracle-database-preinstall-19c.x86_64 : Oracle Database Preinstallation RPM
oracle-database-preinstall-21c.src : Oracle Database Preinstallation RPM
oracle-database-preinstall-21c.x86_64 : Oracle Database Preinstallation RPM
oracle-database-preinstall-23ai.src : Oracle Database Preinstallation RPM
oracle-database-preinstall-23ai.x86_64 : Oracle Database Preinstallation RPM
======================================= Name Matched: preinstall =======================================
oracle-ebs-server-R12-preinstall.src : Sets the system for Oracle E-Business Suite Release 12 for Oracle
                                     : Linux 8
oracle-ebs-server-R12-preinstall.x86_64 : Sets the system for Oracle E-Business Suite Release 12 for
                                        : Oracle Linux 8

[root@ol8 opc]# yum install -y oracle-database-preinstall-23ai.x86_64
Last metadata expiration check: 0:01:04 ago on Tue 13 May 2025 09:11:08 AM GMT.
Dependencies resolved.
========================================================================================================
 Package                              Arch        Version                      Repository          Size
========================================================================================================
Installing:
 oracle-database-preinstall-23ai      x86_64      1.0-4.el8                    ol8_appstream       31 k
Installing dependencies:
 ksh                                  x86_64      20120801-267.0.1.el8         ol8_appstream      923 k
 libICE                               x86_64      1.0.9-15.el8                 ol8_appstream       74 k
 libSM                                x86_64      1.2.3-1.el8                  ol8_appstream       47 k
 libX11-xcb                           x86_64      1.6.8-9.el8_10               ol8_appstream       14 k
 libXcomposite                        x86_64      0.4.4-14.el8                 ol8_appstream       28 k
 libXi                                x86_64      1.7.10-1.el8                 ol8_appstream       49 k
 libXinerama                          x86_64      1.1.4-1.el8                  ol8_appstream       15 k
 libXmu                               x86_64      1.1.3-1.el8                  ol8_appstream       75 k
 libXrandr                            x86_64      1.5.2-1.el8                  ol8_appstream       34 k
 libXt                                x86_64      1.1.5-12.el8                 ol8_appstream      185 k
 libXtst                              x86_64      1.2.3-7.el8                  ol8_appstream       22 k
 libXv                                x86_64      1.0.11-7.el8                 ol8_appstream       20 k
 libXxf86dga                          x86_64      1.1.5-1.el8                  ol8_appstream       26 k
 libXxf86misc                         x86_64      1.0.4-1.el8                  ol8_appstream       23 k
 libXxf86vm                           x86_64      1.1.4-9.el8                  ol8_appstream       19 k
 libdmx                               x86_64      1.1.4-3.el8                  ol8_appstream       22 k
 xorg-x11-utils                       x86_64      7.5-28.el8                   ol8_appstream      136 k
 xorg-x11-xauth                       x86_64      1:1.0.9-12.el8               ol8_appstream       39 k

Transaction Summary
========================================================================================================
Install  19 Packages

Total download size: 1.7 M
Installed size: 5.0 M
Downloading Packages:
(1/19): libICE-1.0.9-15.el8.x86_64.rpm                                  3.0 MB/s |  74 kB     00:00
(2/19): libSM-1.2.3-1.el8.x86_64.rpm                                    1.8 MB/s |  47 kB     00:00
(3/19): libX11-xcb-1.6.8-9.el8_10.x86_64.rpm                            3.2 MB/s |  14 kB     00:00
(4/19): ksh-20120801-267.0.1.el8.x86_64.rpm                              26 MB/s | 923 kB     00:00
(5/19): libXcomposite-0.4.4-14.el8.x86_64.rpm                           2.8 MB/s |  28 kB     00:00
(6/19): libXi-1.7.10-1.el8.x86_64.rpm                                   4.8 MB/s |  49 kB     00:00
(7/19): libXinerama-1.1.4-1.el8.x86_64.rpm                              2.9 MB/s |  15 kB     00:00
(8/19): libXrandr-1.5.2-1.el8.x86_64.rpm                                7.9 MB/s |  34 kB     00:00
(9/19): libXmu-1.1.3-1.el8.x86_64.rpm                                   6.9 MB/s |  75 kB     00:00
(10/19): libXtst-1.2.3-7.el8.x86_64.rpm                                 4.3 MB/s |  22 kB     00:00
(11/19): libXv-1.0.11-7.el8.x86_64.rpm                                  4.5 MB/s |  20 kB     00:00
(12/19): libXt-1.1.5-12.el8.x86_64.rpm                                   13 MB/s | 185 kB     00:00
(13/19): libXxf86dga-1.1.5-1.el8.x86_64.rpm                             3.9 MB/s |  26 kB     00:00
(14/19): libXxf86misc-1.0.4-1.el8.x86_64.rpm                            3.8 MB/s |  23 kB     00:00
(15/19): libXxf86vm-1.1.4-9.el8.x86_64.rpm                              3.5 MB/s |  19 kB     00:00
(16/19): libdmx-1.1.4-3.el8.x86_64.rpm                                  5.5 MB/s |  22 kB     00:00
(17/19): oracle-database-preinstall-23ai-1.0-4.el8.x86_64.rpm           5.3 MB/s |  31 kB     00:00
(18/19): xorg-x11-xauth-1.0.9-12.el8.x86_64.rpm                          11 MB/s |  39 kB     00:00
(19/19): xorg-x11-utils-7.5-28.el8.x86_64.rpm                            16 MB/s | 136 kB     00:00
--------------------------------------------------------------------------------------------------------
Total                                                                    24 MB/s | 1.7 MB     00:00
Running transaction check
Waiting for process with pid 10373 to finish.
Transaction check succeeded.
Running transaction test
Transaction test succeeded.
Running transaction
  Preparing        :                                                                                1/1
  Installing       : libXi-1.7.10-1.el8.x86_64                                                     1/19
  Installing       : libICE-1.0.9-15.el8.x86_64                                                    2/19
  Installing       : libSM-1.2.3-1.el8.x86_64                                                      3/19
  Installing       : libXt-1.1.5-12.el8.x86_64                                                     4/19
  Installing       : libXmu-1.1.3-1.el8.x86_64                                                     5/19
  Installing       : xorg-x11-xauth-1:1.0.9-12.el8.x86_64                                          6/19
  Installing       : libXtst-1.2.3-7.el8.x86_64                                                    7/19
  Installing       : libdmx-1.1.4-3.el8.x86_64                                                     8/19
  Installing       : libXxf86vm-1.1.4-9.el8.x86_64                                                 9/19
  Installing       : libXxf86misc-1.0.4-1.el8.x86_64                                              10/19
  Installing       : libXxf86dga-1.1.5-1.el8.x86_64                                               11/19
  Installing       : libXv-1.0.11-7.el8.x86_64                                                    12/19
  Installing       : libXrandr-1.5.2-1.el8.x86_64                                                 13/19
  Installing       : libXinerama-1.1.4-1.el8.x86_64                                               14/19
  Installing       : libXcomposite-0.4.4-14.el8.x86_64                                            15/19
  Installing       : libX11-xcb-1.6.8-9.el8_10.x86_64                                             16/19
  Installing       : xorg-x11-utils-7.5-28.el8.x86_64                                             17/19
  Installing       : ksh-20120801-267.0.1.el8.x86_64                                              18/19
  Running scriptlet: ksh-20120801-267.0.1.el8.x86_64                                              18/19
  Installing       : oracle-database-preinstall-23ai-1.0-4.el8.x86_64                             19/19
  Running scriptlet: oracle-database-preinstall-23ai-1.0-4.el8.x86_64                             19/19
  Verifying        : ksh-20120801-267.0.1.el8.x86_64                                               1/19
  Verifying        : libICE-1.0.9-15.el8.x86_64                                                    2/19
  Verifying        : libSM-1.2.3-1.el8.x86_64                                                      3/19
  Verifying        : libX11-xcb-1.6.8-9.el8_10.x86_64                                              4/19
  Verifying        : libXcomposite-0.4.4-14.el8.x86_64                                             5/19
  Verifying        : libXi-1.7.10-1.el8.x86_64                                                     6/19
  Verifying        : libXinerama-1.1.4-1.el8.x86_64                                                7/19
  Verifying        : libXmu-1.1.3-1.el8.x86_64                                                     8/19
  Verifying        : libXrandr-1.5.2-1.el8.x86_64                                                  9/19
  Verifying        : libXt-1.1.5-12.el8.x86_64                                                    10/19
  Verifying        : libXtst-1.2.3-7.el8.x86_64                                                   11/19
  Verifying        : libXv-1.0.11-7.el8.x86_64                                                    12/19
  Verifying        : libXxf86dga-1.1.5-1.el8.x86_64                                               13/19
  Verifying        : libXxf86misc-1.0.4-1.el8.x86_64                                              14/19
  Verifying        : libXxf86vm-1.1.4-9.el8.x86_64                                                15/19
  Verifying        : libdmx-1.1.4-3.el8.x86_64                                                    16/19
  Verifying        : oracle-database-preinstall-23ai-1.0-4.el8.x86_64                             17/19
  Verifying        : xorg-x11-utils-7.5-28.el8.x86_64                                             18/19
  Verifying        : xorg-x11-xauth-1:1.0.9-12.el8.x86_64                                         19/19

Installed:
  ksh-20120801-267.0.1.el8.x86_64                            libICE-1.0.9-15.el8.x86_64
  libSM-1.2.3-1.el8.x86_64                                   libX11-xcb-1.6.8-9.el8_10.x86_64
  libXcomposite-0.4.4-14.el8.x86_64                          libXi-1.7.10-1.el8.x86_64
  libXinerama-1.1.4-1.el8.x86_64                             libXmu-1.1.3-1.el8.x86_64
  libXrandr-1.5.2-1.el8.x86_64                               libXt-1.1.5-12.el8.x86_64
  libXtst-1.2.3-7.el8.x86_64                                 libXv-1.0.11-7.el8.x86_64
  libXxf86dga-1.1.5-1.el8.x86_64                             libXxf86misc-1.0.4-1.el8.x86_64
  libXxf86vm-1.1.4-9.el8.x86_64                              libdmx-1.1.4-3.el8.x86_64
  oracle-database-preinstall-23ai-1.0-4.el8.x86_64           xorg-x11-utils-7.5-28.el8.x86_64
  xorg-x11-xauth-1:1.0.9-12.el8.x86_64

Complete!
[root@ol8 opc]#
```
また、23aiのpreinstallerではcompat-openssl10が入っていないようでインストール時にエラーが発生するため、事前にインストールしておきます。
```
[root@ol8 opc]# yum install -y compat-openssl10.x86_64
Last metadata expiration check: 0:08:55 ago on Tue 13 May 2025 09:11:08 AM GMT.
Dependencies resolved.
========================================================================================================
 Package                    Architecture     Version                      Repository               Size
========================================================================================================
Installing:
 compat-openssl10           x86_64           1:1.0.2o-4.el8_6             ol8_appstream           1.1 M

Transaction Summary
========================================================================================================
Install  1 Package

Total download size: 1.1 M
Installed size: 2.9 M
Downloading Packages:
compat-openssl10-1.0.2o-4.el8_6.x86_64.rpm                               35 MB/s | 1.1 MB     00:00
--------------------------------------------------------------------------------------------------------
Total                                                                    33 MB/s | 1.1 MB     00:00
Running transaction check
Transaction check succeeded.
Running transaction test
Transaction test succeeded.
Running transaction
  Preparing        :                                                                                1/1
  Installing       : compat-openssl10-1:1.0.2o-4.el8_6.x86_64                                       1/1
  Running scriptlet: compat-openssl10-1:1.0.2o-4.el8_6.x86_64                                       1/1
  Verifying        : compat-openssl10-1:1.0.2o-4.el8_6.x86_64                                       1/1

Installed:
  compat-openssl10-1:1.0.2o-4.el8_6.x86_64

Complete!
```

インストールディレクトリを作成して資材を展開します。
```
[root@ol8 opc]# mkdir /u01
[root@ol8 opc]# chown oracle:oinstall /u01
[root@ol8 opc]# su - oracle
[oracle@ol8 ~]$ mkdir -p /u01/app/oraInventory
[oracle@ol8 ~]$ ls -ld /u01/app/oraInventory
drwxr-xr-x. 2 oracle oinstall 6 May 13 09:13 /u01/app/oraInventory
[oracle@ol8 ~]$ mkdir -p /u01/app/oracle/product/23.0.0/client_1
[oracle@ol8 ~]$ ls -ld /u01/app/oracle/product/23.0.0/client_1
drwxr-xr-x. 2 oracle oinstall 6 May 13 09:13 /u01/app/oracle/product/23.0.0/client_1
[oracle@ol8 ~]$ unzip -q -d /u01/app/oracle/product/23.0.0/client_1/ /home/oracle/V1044258-01.zip
```

レスポンスファイルを事前に編集しておきます。
```txt:clientsetup.rsp
###############################################################################
## Copyright(c) Oracle Corporation 1998,2024. All rights reserved.           ##
##                                                                           ##
## Specify values for the variables listed below to customize                ##
## your installation.                                                        ##
##                                                                           ##
## Each variable is associated with a comment. The comment                   ##
## can help to populate the variables with the appropriate                   ##
## values.                                                                   ##
##                                                                           ##
###############################################################################


#-------------------------------------------------------------------------------
# Do not change the following system generated value.
#-------------------------------------------------------------------------------
oracle.install.responseFileVersion=/oracle/install/rspfmt_clientinstall_response_schema_v23.0.0

#-------------------------------------------------------------------------------
# Unix group to be set for the inventory directory.
#-------------------------------------------------------------------------------
UNIX_GROUP_NAME=oinstall
#-------------------------------------------------------------------------------
# Inventory location.
#-------------------------------------------------------------------------------
INVENTORY_LOCATION=/u01/app/oraInventory
#-------------------------------------------------------------------------------
# Complete path of the Oracle Base.
#-------------------------------------------------------------------------------
ORACLE_BASE=/u01/app/oracle
```

サイレントインストールを実施します。
```
[oracle@ol8 ~]$ /u01/app/oracle/product/23.0.0/client_1/runInstaller \
> -silent \
> -responseFile /u01/app/oracle/product/23.0.0/client_1/install/response/clientsetup.rsp
Launching Oracle Database Client Setup Wizard...

The response file for this session can be found at:
 /u01/app/oracle/product/23.0.0/client_1/install/response/client_2025-05-13_09-40-43AM.rsp

You can find the log of this install session at:
 /tmp/InstallActions2025-05-13_09-40-43AM/installActions2025-05-13_09-40-43AM.log

As a root user, run the following script(s):
        1. /u01/app/oraInventory/orainstRoot.sh

Run /u01/app/oraInventory/orainstRoot.sh on the following nodes:
[ol8]


Successfully Setup Software.
Moved the install session logs to:
 /u01/app/oraInventory/logs/InstallActions2025-05-13_09-40-43AM
[oracle@ol8 ~]$ logout
[root@ol8 opc]# /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@ol8 opc]#
```

23aiの最新RUを適用します。
2025/5時点で最新の23.8([Patch 37701421](https://updates.oracle.com/download/37701421.html))および最新のOPatch([Patch 6880880](https://updates.oracle.com/download/6880880.html))をダウンロードしてサーバに配置し、パッチを適用していきます。
```
[oracle@ol8 ~]$ ls -l /home/oracle/p6880880_230000_Linux-x86-64.zip
-rw-r--r--. 1 oracle oinstall 25093206 May 13 02:53 /home/oracle/p6880880_230000_Linux-x86-64.zip

[oracle@ol8 ~]$ mv /u01/app/oracle/product/23.0.0/client_1/OPatch /u01/app/oracle/product/23.0.0/client_1/OPatch.org
[oracle@ol8 ~]$ unzip -q -d /u01/app/oracle/product/23.0.0/client_1/ p6880880_230000_Linux-x86-64.zip
[oracle@ol8 ~]$ ls -ld /u01/app/oracle/product/23.0.0/client_1/OPatch*
drwxr-x---. 14 oracle oinstall 4096 Apr  6 12:06 /u01/app/oracle/product/23.0.0/client_1/OPatch
drwxr-xr-x. 13 oracle oinstall 4096 Jul 11  2024 /u01/app/oracle/product/23.0.0/client_1/OPatch.org

[oracle@ol8 ~]$ ls -l p37701421_230000_Linux-x86-64.zip
-rw-r--r--. 1 oracle oinstall 2965566398 May 13 08:51 p37701421_230000_Linux-x86-64.zip

[oracle@ol8 ~]$ unzip -q p37701421_230000_Linux-x86-64.zip
[oracle@ol8 ~]$ cd 37701421/
[oracle@ol8 37701421]$ ls -l
total 60
drwxr-x---.  3 oracle oinstall    21 Apr 17 11:50 custom
drwxr-x---.  3 oracle oinstall    20 Apr 17 11:50 etc
drwxr-x---. 64 oracle oinstall  4096 Apr 17 11:43 files
-rw-rw-r--.  1 oracle oinstall 51741 Apr 21 09:17 README.html
-rw-rw-r--.  1 oracle oinstall    21 Apr 17 11:50 README.txt

[oracle@ol8 37701421]$ /u01/app/oracle/product/23.0.0/client_1/OPatch/opatch lspatches
There are no Interim patches installed in this Oracle Home "/u01/app/oracle/product/23.0.0/client_1".

OPatch succeeded.

[oracle@ol8 37701421]$ /u01/app/oracle/product/23.0.0/client_1/OPatch/opatch apply
Oracle Interim Patch Installer version 12.2.0.1.46
Copyright (c) 2025, Oracle Corporation.  All rights reserved.


Oracle Home       : /u01/app/oracle/product/23.0.0/client_1
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/23.0.0/client_1/oraInst.loc
OPatch version    : 12.2.0.1.46
OUI version       : 12.2.0.9.0
Log file location : /u01/app/oracle/product/23.0.0/client_1/cfgtoollogs/opatch/opatch2025-05-13_09-56-11AM_1.log

Verifying environment and performing prerequisite checks...

--------------------------------------------------------------------------------
Start OOP by Prereq process.
Launch OOP...

Oracle Interim Patch Installer version 12.2.0.1.46
Copyright (c) 2025, Oracle Corporation.  All rights reserved.


Oracle Home       : /u01/app/oracle/product/23.0.0/client_1
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/23.0.0/client_1/oraInst.loc
OPatch version    : 12.2.0.1.46
OUI version       : 12.2.0.9.0
Log file location : /u01/app/oracle/product/23.0.0/client_1/cfgtoollogs/opatch/opatch2025-05-13_09-56-25AM_1.log

Verifying environment and performing prerequisite checks...
OPatch continues with these patches:   37701421

Do you want to proceed? [y|n]
y
User Responded with: Y
All checks passed.

Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/u01/app/oracle/product/23.0.0/client_1')


Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files...
Applying interim patch '37701421' to OH '/u01/app/oracle/product/23.0.0/client_1'
ApplySession: Optional component(s) [ oracle.assistants.server, 23.0.0.0.0 ] , [ oracle.blaslapack, 23.0.0.0.0 ] , [ oracle.companionCD.db, 23.0.0.0.0 ] , [ oracle.ctx, 23.0.0.0.0 ] , [ oracle.ctx.atg, 23.0.0.0.0 ] , [ oracle.ctx.companion, 23.0.0.0.0 ] , [ oracle.ctx.rsf, 23.0.0.0.0 ] , [ oracle.dbjava.dev, 23.0.0.0.0 ] , [ oracle.dbjava.server, 23.0.0.0.0 ] , [ oracle.dbtoolslistener, 23.0.0.0.0 ] , [ oracle.dslm, 23.0.0.0.0 ] , [ oracle.hadoopcore, 23.0.0.0.0 ] , [ oracle.has.db, 23.0.0.0.0 ] , [ oracle.has.db.cvu, 23.0.0.0.0 ] , [ oracle.javavm.companion, 23.0.0.0.0 ] , [ oracle.javavm.server, 23.0.0.0.0 ] , [ oracle.javavm.server.core, 23.0.0.0.0 ] , [ oracle.ldap.companion, 23.0.0.0.0 ] , [ oracle.mgw.common, 23.0.0.0.0 ] , [ oracle.mgw.common.companion, 23.0.0.0.0 ] , [ oracle.network, 23.0.0.0.0 ] , [ oracle.network.cman, 23.0.0.0.0 ] , [ oracle.network.gsm, 23.0.0.0.0 ] , [ oracle.network.listener, 23.0.0.0.0 ] , [ oracle.nlsrtl.companion, 23.0.0.0.0 ] , [ oracle.odbc.companion, 23.0.0.0.0 ] , [ oracle.onnx, 23.0.0.0.0 ] , [ oracle.options, 23.0.0.0.0 ] , [ oracle.oracler.server, 23.0.0.0.0 ] , [ oracle.oraml.server, 23.0.0.0.0 ] , [ oracle.oraolap, 23.0.0.0.0 ] , [ oracle.oraolap.dbscripts, 23.0.0.0.0 ] , [ oracle.ordim.server, 23.0.0.0.0 ] , [ oracle.ovm, 23.0.0.0.0 ] , [ oracle.pg4appc, 23.0.0.0.0 ] , [ oracle.pg4mq, 23.0.0.0.0 ] , [ oracle.precomp.companion, 23.0.0.0.0 ] , [ oracle.python, 3.12.3.0.0 ] , [ oracle.rdbms, 23.0.0.0.0 ] , [ oracle.rdbms.companion, 23.0.0.0.0 ] , [ oracle.rdbms.db, 23.0.0.0.0 ] , [ oracle.rdbms.dbcur, 23.0.0.0.0 ] , [ oracle.rdbms.dm, 23.0.0.0.0 ] , [ oracle.rdbms.dv, 23.0.0.0.0 ] , [ oracle.rdbms.hs_common, 23.0.0.0.0 ] , [ oracle.rdbms.hsodbc, 23.0.0.0.0 ] , [ oracle.rdbms.install.seeddb, 23.0.0.0.0 ] , [ oracle.rdbms.lbac, 23.0.0.0.0 ] , [ oracle.rdbms.locator, 23.0.0.0.0 ] , [ oracle.rdbms.olap, 23.0.0.0.0 ] , [ oracle.rdbms.rat, 23.0.0.0.0 ] , [ oracle.rdbms.scheduler, 23.0.0.0.0 ] , [ oracle.rdbms.tg4db2, 23.0.0.0.0 ] , [ oracle.rdbms.tg4ifmx, 23.0.0.0.0 ] , [ oracle.rdbms.tg4msql, 23.0.0.0.0 ] , [ oracle.rdbms.tg4sybs, 23.0.0.0.0 ] , [ oracle.rdbms.tg4tera, 23.0.0.0.0 ] , [ oracle.rhp.common, 23.0.0.0.0 ] , [ oracle.rhp.db, 23.0.0.0.0 ] , [ oracle.sdo, 23.0.0.0.0 ] , [ oracle.sdo.companion, 23.0.0.0.0 ] , [ oracle.sdo.locator, 23.0.0.0.0 ] , [ oracle.sdo.locator.jrf, 23.0.0.0.0 ] , [ oracle.server, 23.0.0.0.0 ] , [ oracle.sqlj.companion, 23.0.0.0.0 ] , [ oracle.sqlplus.companion, 23.0.0.0.0 ] , [ oracle.tfa.db, 23.0.0.0.0 ] , [ oracle.tg, 23.0.0.0.0 ] , [ oracle.xdk.companion, 23.0.0.0.0 ] , [ oracle.xdk.server, 23.0.0.0.0 ] , [ oracle.jdk, 11.0.25.9.0 ] , [ oracle.python, 3.12.5.0.0 ]  not present in the Oracle Home or a higher version is found.

Patching component oracle.assistants.acf, 23.0.0.0.0...

Patching component oracle.assistants.deconfig, 23.0.0.0.0...

Patching component oracle.assistants.netca.client, 23.0.0.0.0...

Patching component oracle.bali.ewt, 12.2.1.0.0...

Patching component oracle.bali.ice, 6.1.3.2.0...

Patching component oracle.bali.jewt, 11.1.1.1.0...

Patching component oracle.bali.share, 12.2.1.0.0...

Patching component oracle.buildtools.common, 23.0.0.0.0...

Patching component oracle.buildtools.rsf, 23.0.0.0.0...

Patching component oracle.client, 23.0.0.0.0...

Patching component oracle.crypto.fips, 23.0.0.0.0...

Patching component oracle.crypto.ojmisc, 23.0.0.0.0...

Patching component oracle.crypto.pki, 23.0.0.0.0...

Patching component oracle.crypto.rsa, 23.0.0.0.0...

Patching component oracle.crypto.rsf, 23.0.0.0.0...

Patching component oracle.dbdev, 23.0.0.0.0...

Patching component oracle.dbjava.ic, 23.0.0.0.0...

Patching component oracle.dbjava.jdbc, 23.0.0.0.0...

Patching component oracle.dbjava.ucp, 23.0.0.0.0...

Patching component oracle.has.client.cvu, 23.0.0.0.0...

Patching component oracle.has.common, 23.0.0.0.0...

Patching component oracle.has.common.cvu, 23.0.0.0.0...

Patching component oracle.has.rsf, 23.0.0.0.0...

Patching component oracle.help.ohj, 11.1.2.0.0...

Patching component oracle.help.share, 11.1.2.0.0...

Patching component oracle.install.deinstalltool, 23.0.0.0.0...

Patching component oracle.javavm.client, 23.0.0.0.0...

Patching component oracle.jdk, 11.0.24.7.0...

Patching component oracle.ldap.admin, 23.0.0.0.0...

Patching component oracle.ldap.client, 23.0.0.0.0...

Patching component oracle.ldap.rsf, 23.0.0.0.0...

Patching component oracle.network.aso, 23.0.0.0.0...

Patching component oracle.network.client, 23.0.0.0.0...

Patching component oracle.network.netmgr, 23.0.0.0.0...

Patching component oracle.network.rsf, 23.0.0.0.0...

Patching component oracle.nlsrtl.rsf, 23.0.0.0.0...

Patching component oracle.nlsrtl.rsf.core, 23.0.0.0.0...

Patching component oracle.nlsrtl.rsf.ic, 23.0.0.0.0...

Patching component oracle.nlsrtl.rsf.lbuilder, 23.0.0.0.0...

Patching component oracle.odbc, 23.0.0.0.0...

Patching component oracle.odbc.ic, 23.0.0.0.0...

Patching component oracle.ons, 23.0.0.0.0...

Patching component oracle.ons.core, 23.0.0.0.0...

Patching component oracle.ons.ic, 23.0.0.0.0...

Patching component oracle.oracore.rsf, 23.0.0.0.0...

Patching component oracle.oracore.rsf.core, 23.0.0.0.0...

Patching component oracle.oraolap.api, 23.0.0.0.0...

Patching component oracle.oraolap.mgmt, 23.0.0.0.0...

Patching component oracle.ordim.client, 23.0.0.0.0...

Patching component oracle.perlint, 5.38.2.0.0...

Patching component oracle.precomp.common, 23.0.0.0.0...

Patching component oracle.precomp.common.core, 23.0.0.0.0...

Patching component oracle.precomp.lang, 23.0.0.0.0...

Patching component oracle.precomp.rsf, 23.0.0.0.0...

Patching component oracle.rdbms.crs, 23.0.0.0.0...

Patching component oracle.rdbms.dbscripts, 23.0.0.0.0...

Patching component oracle.rdbms.deconfig, 23.0.0.0.0...

Patching component oracle.rdbms.ic, 23.0.0.0.0...

Patching component oracle.rdbms.install.common, 23.0.0.0.0...

Patching component oracle.rdbms.install.plugins, 23.0.0.0.0...

Patching component oracle.rdbms.oci, 23.0.0.0.0...

Patching component oracle.rdbms.plsql, 23.0.0.0.0...

Patching component oracle.rdbms.rman, 23.0.0.0.0...

Patching component oracle.rdbms.rsf, 23.0.0.0.0...

Patching component oracle.rdbms.rsf.ic, 23.0.0.0.0...

Patching component oracle.rdbms.util, 23.0.0.0.0...

Patching component oracle.rsf, 23.0.0.0.0...

Patching component oracle.slax.rsf, 23.0.0.0.0...

Patching component oracle.sqlj, 23.0.0.0.0...

Patching component oracle.sqlj.sqljruntime, 23.0.0.0.0...

Patching component oracle.sqlplus, 23.0.0.0.0...

Patching component oracle.sqlplus.ic, 23.0.0.0.0...

Patching component oracle.sqlplus.rsf, 23.0.0.0.0...

Patching component oracle.usm.deconfig, 23.0.0.0.0...

Patching component oracle.wwg.plsql, 23.0.0.0.0...

Patching component oracle.xdk, 23.0.0.0.0...

Patching component oracle.xdk.parser.java, 23.0.0.0.0...

Patching component oracle.xdk.rsf, 23.0.0.0.0...

Patching component oracle.xdk.xquery, 23.0.0.0.0...
Patch 37701421 successfully applied.
Log file location: /u01/app/oracle/product/23.0.0/client_1/cfgtoollogs/opatch/opatch2025-05-13_09-56-25AM_1.log

OPatch succeeded.
[oracle@ol8 37701421]$ /u01/app/oracle/product/23.0.0/client_1/OPatch/opatch lspatches
37701421;Database Release Update : 23.8.0.25.04 (37701421)

OPatch succeeded.
```
#### JDBCドライバ確認
Oracle Client 23aiではojdbc8.jar、ojdbc11.jar、ojdbc17.jarが同梱されていました。
また、-versionコマンドが使えなくなっているようでした。

```
[oracle@ol8 37701421]$ cd /u01/app/oracle/product/23.0.0/client_1/jdbc/lib
[oracle@ol8 lib]$ pwd
/u01/app/oracle/product/23.0.0/client_1/jdbc/lib
[oracle@ol8 lib]$ ls -l
total 21764
-rw-r--r--. 1 oracle oinstall 7367466 Apr 17 11:46 ojdbc11.jar
-rw-r--r--. 1 oracle oinstall 7368928 Apr 17 11:46 ojdbc17.jar
-rw-r--r--. 1 oracle oinstall 7251330 Apr 17 11:46 ojdbc8.jar
-rw-r--r--. 1 oracle oinstall  255334 Apr 17 11:46 rsi.jar
-rw-r--r--. 1 oracle oinstall   29247 Apr 17 11:46 simplefan.jar
[oracle@ol8 lib]$ java -jar ojdbc8.jar -version
Invalid command: -version

Try 'java -jar ojdbc8.jar help' for more information.

[oracle@ol8 lib]$ java -jar ojdbc8.jar help

Usage:  java -jar ojdbc8.jar [command] [argument]

Commands:

  getVersion     [JDBC URL]      - Prints the database and JDK information.
    Example: java -jar ojdbc8.jar getVersion jdbc:oracle:thin:user/password@host:port/service

  installTFOLib  [install path]  - Installs TCP Fast Open native library in the installation path.
    Example: java -jar ojdbc8.jar installTFOLib /usr/lib/tfo

  showConfiguration              - Displays configuration.
```

試しに引数なしで実行したらバージョン情報などは確認できました。
アスキーアートがド派手ですね。
```
[oracle@ol8 lib]$ java -jar ojdbc8.jar

==============================================================
===  ___                 _            _ ____  ____   ____  ===
==  / _ \ _ __ __ _  ___| | ___      | |  _ \| __ ) / ___|  ==
=  | | | | '__/ _` |/ __| |/ _ \  _  | | | | |  _ \| |       =
== | |_| | | | (_| | (__| |  __/ | |_| | |_| | |_) | |___   ==
=== \___/|_|  \__,_|\___|_|\___|  \___/|____/|____/ \____| ===
===                                                        ===
========================================= v.23.8.0.25.04 =====

Oracle 23.8.0.25.04 JDBC 4.2 debug compiled with javac 1.8.0_381-ea on Wed_Apr_02_14:50:45_PDT_2025

Try 'java -jar ojdbc8.jar help' for more information.

[oracle@ol8 lib]$ java -jar ojdbc11.jar

==============================================================
===  ___                 _            _ ____  ____   ____  ===
==  / _ \ _ __ __ _  ___| | ___      | |  _ \| __ ) / ___|  ==
=  | | | | '__/ _` |/ __| |/ _ \  _  | | | | |  _ \| |       =
== | |_| | | | (_| | (__| |  __/ | |_| | |_| | |_) | |___   ==
=== \___/|_|  \__,_|\___|_|\___|  \___/|____/|____/ \____| ===
===                                                        ===
========================================= v.23.8.0.25.04 =====

Oracle 23.8.0.25.04 JDBC 4.3 debug compiled with javac 11.0.27 on Wed_Apr_02_14:51:39_PDT_2025

Try 'java -jar ojdbc11.jar help' for more information.

[oracle@ol8 lib]$ java -jar ojdbc17.jar

==============================================================
===  ___                 _            _ ____  ____   ____  ===
==  / _ \ _ __ __ _  ___| | ___      | |  _ \| __ ) / ___|  ==
=  | | | | '__/ _` |/ __| |/ _ \  _  | | | | |  _ \| |       =
== | |_| | | | (_| | (__| |  __/ | |_| | |_| | |_) | |___   ==
=== \___/|_|  \__,_|\___|_|\___|  \___/|____/|____/ \____| ===
===                                                        ===
========================================= v.23.8.0.25.04 =====

Oracle 23.8.0.25.04 JDBC 4.3 debug compiled with javac 17.0.10 on Wed_Apr_02_14:52:41_PDT_2025

Try 'java -jar ojdbc17.jar help' for more information.
```

## おわりに
Oracle Client同梱のドライバを利用することで他のClientモジュールと合わせてJDBCドライバも四半期毎の不具合修正や脆弱性対応を行うことが可能です。
ぜひご活用してみてください。