1. Oracle Instant Clientのリポジトリ定義の構成
sudo dnf install -y oracle-instantclient-release-23ai-el9
[opc@OracleClient ~]$ sudo dnf install -y oracle-instantclient-release-23ai-el9
Oracle Linux 9 BaseOS Latest (x86_64) 37 MB/s | 86 MB 00:02
Oracle Linux 9 Application Stream Packages (x86_64) 32 MB/s | 69 MB 00:02
Oracle Linux 9 Addons (x86_64) 1.9 MB/s | 733 kB 00:00
Oracle Linux 9 UEK Release 7 (x86_64) 38 MB/s | 81 MB 00:02
Last metadata expiration check: 0:00:01 ago on Wed 24 Sep 2025 11:06:55 PM EDT.
Dependencies resolved.
============================================================================================
Package Arch Version Repository Size
============================================================================================
Installing:
oracle-instantclient-release-23ai-el9 x86_64 1.0-5.el9 ol9_baseos_latest 14 k
Transaction Summary
============================================================================================
Install 1 Package
Total download size: 14 k
Installed size: 18 k
Downloading Packages:
oracle-instantclient-release-23ai-el9-1.0-5.el9.x86_64.rpm 177 kB/s | 14 kB 00:00
--------------------------------------------------------------------------------------------
Total 170 kB/s | 14 kB 00:00
Oracle Linux 9 BaseOS Latest (x86_64) 5.5 MB/s | 6.2 kB 00:00
Importing GPG key 0x8D8B756F:
Userid : "Oracle Linux (release key 1) <secalert_us@oracle.com>"
Fingerprint: 3E6D 826D 3FBA B389 C2F3 8E34 BC4D 06A0 8D8B 756F
From : /etc/pki/rpm-gpg/RPM-GPG-KEY-oracle
Key imported successfully
Importing GPG key 0x8B4EFBE6:
Userid : "Oracle Linux (backup key 1) <secalert_us@oracle.com>"
Fingerprint: 9822 3175 9C74 6706 5D0C E9B2 A7DD 0708 8B4E FBE6
From : /etc/pki/rpm-gpg/RPM-GPG-KEY-oracle
Key imported successfully
Running transaction check
Transaction check succeeded.
Running transaction test
Transaction test succeeded.
Running transaction
Preparing : 1/1
Installing : oracle-instantclient-release-23ai-el9-1.0-5.el9.x86_64 1/1
Verifying : oracle-instantclient-release-23ai-el9-1.0-5.el9.x86_64 1/1
Installed:
oracle-instantclient-release-23ai-el9-1.0-5.el9.x86_64
Complete!
[opc@OracleClient ~]$
2. Oracle Instant Client（SQL*Plus、Tools）のインストール
sudo dnf install -y oracle-instantclient-sqlplus oracle-instantclient-tools
[opc@OracleClient ~]$ sudo dnf install -y oracle-instantclient-sqlplus oracle-instantclient-tools
Oracle Instant Client 23 for Oracle Linux 9 - License Inclu 56 kB/s | 14 kB 00:00
Last metadata expiration check: 0:00:01 ago on Wed 24 Sep 2025 11:08:19 PM EDT.
Dependencies resolved.
============================================================================================
Package Arch Version Repository Size
============================================================================================
Installing:
oracle-instantclient-sqlplus x86_64 23.9.0.25.07-1.el9 ol9_oracle_instantclient23 2.6 M
oracle-instantclient-tools x86_64 23.9.0.25.07-1.el9 ol9_oracle_instantclient23 1.0 M
Installing dependencies:
oracle-instantclient-basic x86_64 23.9.0.25.07-1.el9 ol9_oracle_instantclient23 78 M
Transaction Summary
============================================================================================
Install 3 Packages
Total download size: 82 M
Installed size: 356 M
Downloading Packages:
(1/3): oracle-instantclient-tools-23.9.0.25.07-1.el9.x86_64 7.0 MB/s | 1.0 MB 00:00
(2/3): oracle-instantclient-sqlplus-23.9.0.25.07-1.el9.x86_ 8.6 MB/s | 2.6 MB 00:00
(3/3): oracle-instantclient-basic-23.9.0.25.07-1.el9.x86_64 29 MB/s | 78 MB 00:02
--------------------------------------------------------------------------------------------
Total 30 MB/s | 82 MB 00:02
Running transaction check
Transaction check succeeded.
Running transaction test
Transaction test succeeded.
Running transaction
Preparing : 1/1
Installing : oracle-instantclient-basic-23.9.0.25.07-1.el9.x86_64 1/3
Running scriptlet: oracle-instantclient-basic-23.9.0.25.07-1.el9.x86_64 1/3
Installing : oracle-instantclient-sqlplus-23.9.0.25.07-1.el9.x86_64 2/3
Running scriptlet: oracle-instantclient-sqlplus-23.9.0.25.07-1.el9.x86_64 2/3
Installing : oracle-instantclient-tools-23.9.0.25.07-1.el9.x86_64 3/3
Running scriptlet: oracle-instantclient-tools-23.9.0.25.07-1.el9.x86_64 3/3
Verifying : oracle-instantclient-basic-23.9.0.25.07-1.el9.x86_64 1/3
Verifying : oracle-instantclient-sqlplus-23.9.0.25.07-1.el9.x86_64 2/3
Verifying : oracle-instantclient-tools-23.9.0.25.07-1.el9.x86_64 3/3
Installed:
oracle-instantclient-basic-23.9.0.25.07-1.el9.x86_64
oracle-instantclient-sqlplus-23.9.0.25.07-1.el9.x86_64
oracle-instantclient-tools-23.9.0.25.07-1.el9.x86_64
Complete!
[opc@OracleClient ~]$
3. インストール後の状態の確認
SQL*Plusのパスの確認
[opc@OracleClient ~]$ which sqlplus
/usr/bin/sqlplus
[opc@OracleClient ~]$
SQL*Plusのシンボリック・リンクの確認
[opc@OracleClient ~]$ ls -l /usr/bin/sqlplus
lrwxrwxrwx. 1 root root 39 Jul 24 14:15 /usr/bin/sqlplus -> /usr/lib/oracle/23/client64/bin/sqlplus
[opc@OracleClient ~]$
Tools（Data Pump、SQL*Loader）のパスの確認
[opc@OracleClient ~]$ which expdp impdp sqlldr
/usr/bin/which: no expdp in (/home/opc/.local/bin:/home/opc/bin:/usr/local/bin:/usr/bin:/usr/local/sbin:/usr/sbin)
/usr/bin/which: no impdp in (/home/opc/.local/bin:/home/opc/bin:/usr/local/bin:/usr/bin:/usr/local/sbin:/usr/sbin)
/usr/bin/which: no sqlldr in (/home/opc/.local/bin:/home/opc/bin:/usr/local/bin:/usr/bin:/usr/local/sbin:/usr/sbin)
[opc@OracleClient ~]$
→Toolsのコンポーネントのシンボリック・リンクが作成されていない。
4. シンボリック・リンクの作成
/usr/binに移動
[opc@OracleClient ~]$ cd /usr/bin
expdpのシンボリック・リンクの作成
[opc@OracleClient bin]$ sudo ln -s /usr/lib/oracle/23/client64/bin/expdp
[opc@OracleClient bin]$
impdpのシンボリック・リンクの作成
[opc@OracleClient bin]$ sudo ln -s /usr/lib/oracle/23/client64/bin/impdp
[opc@OracleClient bin]$
作成したシンボリック・リンクの確認
[opc@OracleClient bin]$ ls -l *dp
lrwxrwxrwx. 1 root root 37 Sep 24 23:15 expdp -> /usr/lib/oracle/23/client64/bin/expdp
lrwxrwxrwx. 1 root root 37 Sep 24 23:15 impdp -> /usr/lib/oracle/23/client64/bin/impdp
[opc@OracleClient bin]$
SQL*Loaderのシンボリック・リンクの作成
[opc@OracleClient bin]$ sudo ln -s /usr/lib/oracle/23/client64/bin/sqlldr
[opc@OracleClient bin]$
作成したシンボリック・リンクの確認
[opc@OracleClient bin]$ ls -l sqlldr
lrwxrwxrwx. 1 root root 38 Sep 24 23:19 sqlldr -> /usr/lib/oracle/23/client64/bin/sqlldr
[opc@OracleClient bin]$
5. 作成したシンボリック・リンクの動作確認
ホーム・ディレクトリに移動
[opc@OracleClient bin]$ cd
[opc@OracleClient ~]$
Tools（Data Pump、SQL*Loader）のパスの確認
[opc@OracleClient ~]$ which expdp impdp sqlldr
/usr/bin/expdp
/usr/bin/impdp
/usr/bin/sqlldr
[opc@OracleClient ~]$
expdpの動作確認
[opc@OracleClient ~]$ expdp
Export: Release 23.0.0.0.0 - Production on Wed Sep 24 23:41:19 2025
Version 23.9.0.25.07
Copyright (c) 1982, 2025, Oracle and/or its affiliates. All rights reserved.
Username:
impdpの動作確認
[opc@OracleClient ~]$ impdp
Import: Release 23.0.0.0.0 - Production on Wed Sep 24 23:41:36 2025
Version 23.9.0.25.07
Copyright (c) 1982, 2025, Oracle and/or its affiliates. All rights reserved.
Username:
SQL*Loaderの動作確認
[opc@OracleClient ~]$ sqlldr
SQL*Loader: Release 23.0.0.0.0 - Production on Wed Sep 24 23:41:58 2025
Version 23.9.0.25.07
Copyright (c) 1982, 2025, Oracle and/or its affiliates. All rights reserved.
Usage: SQLLDR keyword=value [,keyword=value,...]
Valid Keywords:
userid -- ORACLE username/password
control -- control file name
log -- log file name
bad -- bad file name
data -- data file name
discard -- discard file name
discardmax -- number of discards to allow (Default all)
skip -- number of logical records to skip (Default 0)
load -- number of logical records to load (Default all)
errors -- number of errors to allow (Default 50)
rows -- number of rows in conventional path bind array or between direct path data saves
(Default: Conventional path 250, Direct path all)
bindsize -- size of conventional path bind array in bytes (Default 1048576)
silent -- suppress messages during run (header,feedback,errors,discards,partitions)
direct -- use direct path (Default FALSE)
parfile -- parameter file: name of file that contains parameter specifications
parallel -- do parallel load (Default FALSE)
file -- file to allocate extents from
skip_unusable_indexes -- disallow/allow unusable indexes or index partitions (Default FALSE)
skip_index_maintenance -- do not maintain indexes, mark affected indexes as unusable (Default FALSE)
commit_discontinued -- commit loaded rows when load is discontinued (Default FALSE)
readsize -- size of read buffer (Default 1048576)
external_table -- use external table for load; NOT_USED, GENERATE_ONLY, EXECUTE
columnarrayrows -- number of rows for direct path column array (Default 5000)
streamsize -- size of direct path stream buffer in bytes (Default 256000)
multithreading -- use multithreading in direct path
resumable -- enable or disable resumable for current session (Default FALSE)
resumable_name -- text string to help identify resumable statement
resumable_timeout -- wait time (in seconds) for RESUMABLE (Default 7200)
date_cache -- size (in entries) of date conversion cache (Default 1000)
no_index_errors -- abort load on any index errors (Default FALSE)
partition_memory -- direct path partition memory limit to start spilling (kb) (Default 0)
table -- Table for express mode load
date_format -- Date format for express mode load
timestamp_format -- Timestamp format for express mode load
terminated_by -- terminated by character for express mode load
enclosed_by -- enclosed by character for express mode load
optionally_enclosed_by -- optionally enclosed by character for express mode load
characterset -- characterset for express mode load
degree_of_parallelism -- degree of parallelism for express mode load and external table load, number of loader threads for direct path and conventional path parallel load
trim -- trim type for express mode load and external table load
csv -- csv format data files for express mode load
nullif -- table level nullif clause for express mode load
field_names -- field names setting for first record of data files for express mode load
dnfs_enable -- option for enabling or disabling Direct NFS (dNFS) for input data files (Default FALSE)
dnfs_readbuffers -- the number of Direct NFS (dNFS) read buffers (Default 4)
sdf_prefix -- prefix to append to start of every LOB File and Secondary Data File
help -- display help messages (Default FALSE)
empty_lobs_are_null -- set empty LOBs to null (Default FALSE)
defaults -- direct path default value loading; EVALUATE_ONCE, EVALUATE_EVERY_ROW, IGNORE, IGNORE_UNSUPPORTED_EVALUATE_ONCE, IGNORE_UNSUPPORTED_EVALUATE_EVERY_ROW
direct_path_lock_wait -- wait for access to table when currently locked (Default FALSE)
credential -- credential used for object store access
proxy -- proxy used for object store access
load_shards -- shards to load
gsm_name -- global service name
gsm_host -- global service host
gsm_port -- global service port
optimize_parallel -- optimize parallel (Default TRUE)
compress_stream -- compress stream data (Default FALSE)
reader_count -- number of reader/assigner threads (Default 1)
granule_size -- granule size (Default calculated per file)
PLEASE NOTE: Command-line parameters may be specified either by
position or by keywords. An example of the former case is 'sqlldr
scott/tiger foo'; an example of the latter is 'sqlldr control=foo
userid=scott/tiger'. One may specify parameters by position before
but not after parameters specified by keywords. For example,
'sqlldr scott/tiger control=foo logfile=log' is allowed, but
'sqlldr scott/tiger control=foo log' is not, even though the
position of the parameter 'log' is correct.
[opc@OracleClient ~]$