はじめに
Oracle Databaseに対してJavaアプリケーションから接続する際に利用するOracle JDBCドライバの入手方法について確認した際のメモをまとめます。
各JDKバージョンおよびOracle JDBCバージョンによって利用するjarファイル(ojdbcX.jar)が異なり、以下FAQの「Oracle JDBCのリリースとJDKのバージョンの関連について教えてください。」に組み合わせのマトリクスがまとまっています。
Oracle JDBCに関するFAQ
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から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)を事前に編集しておきます。
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のインストール
事前にOPatch(Patch 6880880)をダウンロードしてインストールディレクトリのものと置き換えます。
[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)をダウンロードしてサーバに配置し、事前に解凍しておきます。
[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の内容で無視可能です。
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と同様ですね。
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サイズ不足の警告ですが、今回はアプリケーションとしては利用しないので無視します。
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)および最新のOPatch(Patch 6880880)をダウンロードしてサーバに配置し、パッチを適用していきます。
[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
レスポンスファイルを事前に編集しておきます。
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)および最新のOPatch(Patch 6880880)をダウンロードしてサーバに配置し、パッチを適用していきます。
[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ドライバも四半期毎の不具合修正や脆弱性対応を行うことが可能です。
ぜひご活用してみてください。