Oracle APEXの環境作成(0) - はじめに
VirtualBoxのインストール
仮想マシンの作成
Oracle APEXの環境作成(2) - 仮想マシンの作成
https://apexugj.blogspot.com/2022/11/building-oracle-apex-environment-02-virtualmachine.html
Linuxのインストール
Oracle APEXの環境作成(3) - Linuxのインストール
https://apexugj.blogspot.com/2022/11/building-oracle-apex-environment-03-linux.html
データベースのインストール
% scp -P 2223 LINUX.ARM64_1919000_db_home.zip oracle@localhost:/home/oracle/
oracle@localhost's password: ********
LINUX.ARM64_1919000_db_home.zip 100% 2304MB 262.6MB/s 00:08
%
% scp -P 2223 LINUX.X64_2326100_db_home.zip oracle@localhost:/home/oracle/
oracle@localhost's password: **********
LINUX.X64_2326100_db_home.zip 100% 2295MB 113.1MB/s 00:20
%
[root@localhost ~]# dnf -y install oracle-database-preinstall-19c
メタデータの期限切れの最終確認: 0:43:00 前の 2026年02月03日 11時00分34秒 に実施しました。
依存関係が解決しました。
================================================================================
パッケージ Arch バージョン リポジトリー サイズ
================================================================================
インストール:
oracle-database-preinstall-19c
aarch64 1.0-3.el8 ol8_appstream 31 k
依存関係のインストール:
cpp aarch64 8.5.0-28.0.1.el8_10 ol8_appstream 9.0 M
gcc aarch64 8.5.0-28.0.1.el8_10 ol8_appstream 19 M
glibc-devel aarch64 2.28-251.0.3.el8_10.27 ol8_baseos_latest 93 k
glibc-headers aarch64 2.28-251.0.3.el8_10.27 ol8_baseos_latest 491 k
gssproxy aarch64 0.8.0-21.el8 ol8_baseos_latest 113 k
isl aarch64 0.16.1-6.el8 ol8_appstream 778 k
kernel-headers aarch64 4.18.0-553.97.1.el8_10 ol8_baseos_latest 12 M
keyutils aarch64 1.5.10-9.0.1.el8 ol8_baseos_latest 64 k
ksh aarch64 20120801-270.0.1.el8_10 ol8_appstream 898 k
libaio-devel aarch64 0.3.112-1.el8 ol8_baseos_latest 19 k
libasan aarch64 8.5.0-28.0.1.el8_10 ol8_baseos_latest 399 k
libatomic aarch64 8.5.0-28.0.1.el8_10 ol8_baseos_latest 37 k
libev aarch64 4.24-6.el8 ol8_appstream 51 k
libgfortran aarch64 8.5.0-28.0.1.el8_10 ol8_baseos_latest 353 k
libnsl aarch64 2.28-251.0.3.el8_10.27 ol8_baseos_latest 115 k
libstdc++-devel aarch64 8.5.0-28.0.1.el8_10 ol8_appstream 2.1 M
libubsan aarch64 8.5.0-28.0.1.el8_10 ol8_baseos_latest 157 k
libverto-libev aarch64 0.3.2-2.el8 ol8_appstream 16 k
libxcrypt-devel aarch64 4.1.1-6.el8 ol8_baseos_latest 25 k
lm_sensors-libs aarch64 3.4.0-23.20180522git70f7e08.el8
[中略]
インストール済み:
cpp-8.5.0-28.0.1.el8_10.aarch64
gcc-8.5.0-28.0.1.el8_10.aarch64
glibc-devel-2.28-251.0.3.el8_10.27.aarch64
glibc-headers-2.28-251.0.3.el8_10.27.aarch64
gssproxy-0.8.0-21.el8.aarch64
isl-0.16.1-6.el8.aarch64
kernel-headers-4.18.0-553.97.1.el8_10.aarch64
keyutils-1.5.10-9.0.1.el8.aarch64
ksh-20120801-270.0.1.el8_10.aarch64
libaio-devel-0.3.112-1.el8.aarch64
libasan-8.5.0-28.0.1.el8_10.aarch64
libatomic-8.5.0-28.0.1.el8_10.aarch64
libev-4.24-6.el8.aarch64
libgfortran-8.5.0-28.0.1.el8_10.aarch64
libnsl-2.28-251.0.3.el8_10.27.aarch64
libstdc++-devel-8.5.0-28.0.1.el8_10.aarch64
libubsan-8.5.0-28.0.1.el8_10.aarch64
libverto-libev-0.3.2-2.el8.aarch64
libxcrypt-devel-4.1.1-6.el8.aarch64
lm_sensors-libs-3.4.0-23.20180522git70f7e08.el8.aarch64
make-1:4.2.1-11.el8.aarch64
nfs-utils-1:2.3.3-64.0.1.el8_10.aarch64
oracle-database-preinstall-19c-1.0-3.el8.aarch64
rpcbind-1.2.5-10.el8.aarch64
sysstat-11.7.3-13.0.2.el8_10.aarch64
完了しました!
[root@localhost ~]#
[root@localhost ~]# dnf -y install oracle-ai-database-preinstall-26ai
メタデータの期限切れの最終確認: 0:55:32 前の 2026年02月03日 10時52分10秒 に実施しました。
依存関係が解決しました。
================================================================================
パッケージ Arch バージョン リポジトリー サイズ
================================================================================
インストール:
oracle-ai-database-preinstall-26ai
x86_64 1.0-1.el9 ol9_appstream 34 k
依存関係のインストール:
compat-openssl11 x86_64 1:1.1.1k-5.el9_6.1 ol9_appstream 1.5 M
glibc-devel x86_64 2.34-231.0.1.el9_7.2 ol9_appstream 60 k
glibc-headers x86_64 2.34-231.0.1.el9_7.2 ol9_appstream 922 k
gssproxy x86_64 0.8.4-7.el9 ol9_baseos_latest 120 k
initscripts x86_64 10.11.8-4.0.1.el9 ol9_baseos_latest 285 k
kernel-headers x86_64 5.14.0-611.26.1.el9_7 ol9_appstream 3.6 M
ksh x86_64 3:1.0.6-14.0.1.el9 ol9_appstream 885 k
libev x86_64 4.33-6.el9 ol9_baseos_latest 56 k
libnfsidmap x86_64 1:2.5.4-38.0.1.el9 ol9_baseos_latest 71 k
libverto-libev x86_64 0.3.2-3.el9 ol9_baseos_latest 14 k
libxcrypt-devel x86_64 4.4.18-3.el9 ol9_appstream 42 k
lm_sensors-libs x86_64 3.6.0-10.el9 ol9_appstream 42 k
make x86_64 1:4.3-8.el9 ol9_baseos_latest 570 k
nfs-utils x86_64 1:2.5.4-38.0.1.el9 ol9_baseos_latest 518 k
pcp-conf x86_64 6.3.7-5.0.6.el9 ol9_appstream 41 k
pcp-libs x86_64 6.3.7-5.0.6.el9 ol9_appstream 654 k
rpcbind x86_64 1.2.6-7.el9 ol9_baseos_latest 69 k
sssd-nfs-idmap x86_64 2.9.7-4.0.1.el9_7.1 ol9_baseos_latest 43 k
sysstat x86_64 12.5.4-9.0.2.el9 ol9_appstream 541 k
[中略]
インストール済み:
compat-openssl11-1:1.1.1k-5.el9_6.1.x86_64
glibc-devel-2.34-231.0.1.el9_7.2.x86_64
glibc-headers-2.34-231.0.1.el9_7.2.x86_64
gssproxy-0.8.4-7.el9.x86_64
initscripts-10.11.8-4.0.1.el9.x86_64
kernel-headers-5.14.0-611.26.1.el9_7.x86_64
ksh-3:1.0.6-14.0.1.el9.x86_64
libev-4.33-6.el9.x86_64
libnfsidmap-1:2.5.4-38.0.1.el9.x86_64
libverto-libev-0.3.2-3.el9.x86_64
libxcrypt-devel-4.4.18-3.el9.x86_64
lm_sensors-libs-3.6.0-10.el9.x86_64
make-1:4.3-8.el9.x86_64
nfs-utils-1:2.5.4-38.0.1.el9.x86_64
oracle-ai-database-preinstall-26ai-1.0-1.el9.x86_64
pcp-conf-6.3.7-5.0.6.el9.x86_64
pcp-libs-6.3.7-5.0.6.el9.x86_64
rpcbind-1.2.6-7.el9.x86_64
sssd-nfs-idmap-2.9.7-4.0.1.el9_7.1.x86_64
sysstat-12.5.4-9.0.2.el9.x86_64
完了しました!
[root@localhost ~]#
usermod --gid oinstall --groups oracle,wheel,oinstall oracle
[root@localhost ~]# usermod --gid oinstall --groups oracle,wheel,oinstall oracle
[root@localhost ~]#
[root@localhost ~]# mkdir /opt/oraInventory
[root@localhost ~]# chown oracle:oinstall /opt/oraInventory
[root@localhost ~]# mkdir -p /opt/oracle/product/19c/dbhome
[root@localhost ~]# chown -R oracle:oinstall /opt/oracle
[root@localhost ~]#
[root@localhost ~]# mkdir /opt/oraInventory
[root@localhost ~]# chown oracle:oinstall /opt/oraInventory
[root@localhost ~]# mkdir -p /opt/oracle/product/26ai/dbhome
[root@localhost ~]# chown -R oracle:oinstall /opt/oracle
[root@localhost ~]#
% ssh -p 2223 root@localhost
root@localhost's password: ********
Activate the web console with: systemctl enable --now cockpit.socket
Last login: Wed Feb 4 14:12:33 2026
[root@localhost ~]# su - oracle
最終ログイン: 2026/02/04 (水) 14:08:48 JST日時 tty2
[oracle@localhost ~]$
ORACLE_SID = [oracle] ? ORCL
export NLS_LANG=American_America.AL32UTF8
lsnrctl stop
lsnrctl start
startup
show pdbs
exit
[oracle@localhost ~]$ . oraenv
ORACLE_SID = [oracle] ? ORCL
The Oracle base has been set to /opt/oracle
[oracle@localhost ~]$ export NLS_LANG=American_America.AL32UTF8
[oracle@localhost ~]$ lsnrctl stop
LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 04-FEB-2026 12:25:24
Copyright (c) 1991, 2023, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521)))
The command completed successfully
[oracle@localhost ~]$ lsnrctl start
LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 04-FEB-2026 12:25:27
Copyright (c) 1991, 2023, Oracle. All rights reserved.
Starting /opt/oracle/product/19c/dbhome/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 19.0.0.0.0 - Production
System parameter file is /opt/oracle/product/19c/dbhome/network/admin/listener.ora
Log messages written to /opt/oracle/diag/tnslsnr/localhost/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 19.0.0.0.0 - Production
Start Date 04-FEB-2026 12:25:27
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /opt/oracle/product/19c/dbhome/network/admin/listener.ora
Listener Log File /opt/oracle/diag/tnslsnr/localhost/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
The listener supports no services
The command completed successfully
[oracle@localhost ~]$ sqlplus / as sysdba
SQL*Plus: Release 19.0.0.0.0 - Production on Wed Feb 4 12:25:33 2026
Version 19.19.0.0.0
Copyright (c) 1982, 2023, Oracle. All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.19.0.0.0
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
Total System Global Area 4664063784 bytes
Fixed Size 9172776 bytes
Variable Size 855638016 bytes
Database Buffers 3791650816 bytes
Redo Buffers 7602176 bytes
Database mounted.
Database opened.
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 ORCLPDB1 MOUNTED
SQL> alter pluggable database orclpdb1 open read write;
Pluggable database altered.
SQL> alter pluggable database orclpdb1 save state;
Pluggable database altered.
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 ORCLPDB1 READ WRITE NO
SQL> exit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.19.0.0.0
[oracle@localhost ~]$ lsnrctl status
LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 04-FEB-2026 12:28:47
Copyright (c) 1991, 2023, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 19.0.0.0.0 - Production
Start Date 04-FEB-2026 12:25:27
Uptime 0 days 0 hr. 3 min. 19 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /opt/oracle/product/19c/dbhome/network/admin/listener.ora
Listener Log File /opt/oracle/diag/tnslsnr/localhost/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=localhost)(PORT=5500))(Security=(my_wallet_directory=/opt/oracle/admin/ORCL/xdb_wallet))(Presentation=HTTP)(Session=RAW))
Services Summary...
Service "49f7dcf80cf55649e065000000000001" has 1 instance(s).
Instance "ORCL", status READY, has 1 handler(s) for this service...
Service "ORCL" has 1 instance(s).
Instance "ORCL", status READY, has 1 handler(s) for this service...
Service "ORCLXDB" has 1 instance(s).
Instance "ORCL", status READY, has 1 handler(s) for this service...
Service "orclpdb1" has 1 instance(s).
Instance "ORCL", status READY, has 1 handler(s) for this service...
The command completed successfully
[oracle@localhost ~]$
systemctl isolate multi-user.target
systemctl set-default multi-user.target
GUIに戻すターゲットはgraphical.targetです。
[root@localhost ~]# systemctl get-default
graphical.target
[root@localhost ~]# systemctl isolate multi-user.target
[root@localhost ~]# systemctl set-default multi-user.target
Removed /etc/systemd/system/default.target.
Created symlink /etc/systemd/system/default.target → /usr/lib/systemd/system/multi-user.target.
[root@localhost ~]#
firewall-cmd --add-port=1521/tcp
firewall-cmd --runtime-to-permanent
firewall-cmd --reload
firewall-cmd --list-all
[root@localhost ~]# firewall-cmd --add-port=1521/tcp
success
[root@localhost ~]# firewall-cmd --runtime-to-permanent
success
[root@localhost ~]# firewall-cmd --reload
success
[root@localhost ~]# firewall-cmd --list-all
public (active)
target: default
icmp-block-inversion: no
interfaces: enp0s8
sources:
services: cockpit dhcpv6-client http https ssh
ports: 1521/tcp
protocols:
forward: no
masquerade: no
forward-ports:
port=443:proto=tcp:toport=8443:toaddr=
port=80:proto=tcp:toport=8080:toaddr=
source-ports:
icmp-blocks:
rich rules:
[root@localhost ~]#
Oracle APEXやOracle REST Data Servicesのインストール
APEXやORDSの環境作成は、以下に含まれている記事にそって作業できます。
Oracle APEXの環境作成(0) - はじめに
以下、作業にあたっての差異です。
- SIDはFREEの代わりにORCLを指定します。
- PDBはFREEPDB1の代わりにORCLPDB1を指定します。
- Oracle DatabaseおよびTNSリスナーは自動的に起動しません。
chown oracle:oinstall /opt/oraInventory
mkdir -p /opt/oracle/product/19c/dbhome
chown -R oracle:oinstall /opt/oracle
root.shの実行はsudoではなく、rootに変更しています。
oracle.install.db.config.starterdb.password.SYS=
oracle.install.db.config.starterdb.password.SYSTEM=
oracle.install.db.config.starterdb.password.PDBADMIN=
memoryLimitは5970MBとなっています。環境に合わせて変更します。
oracle.install.db.config.starterdb.memoryLimit=5970
/opt/oracle/product/19c/dbhome/runInstaller -silent -executeConfigTools -responseFile /home/oracle/install.rsp
最初のコマンドの実行で、rootのパスワードが要求されます。また、スワップが足りないため警告が表示されています。
[oracle@localhost ~]$ /opt/oracle/product/19c/dbhome/runInstaller -silent -responseFile /home/oracle/install.rsp
Launching Oracle Database Setup Wizard...
Enter password for 'root' user: ********
[WARNING] [INS-13014] Target environment does not meet some optional requirements.
CAUSE: Some of the optional prerequisites are not met. See logs for details. /opt/oraInventory/logs/InstallActions2023-07-03_10-49-59AM/installActions2023-07-03_10-49-59AM.log
ACTION: Identify the list of failed prerequisite checks from the log: /opt/oraInventory/logs/InstallActions2023-07-03_10-49-59AM/installActions2023-07-03_10-49-59AM.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:
/opt/oracle/product/19c/dbhome/install/response/db_2023-07-03_10-49-59AM.rsp
You can find the log of this install session at:
/opt/oraInventory/logs/InstallActions2023-07-03_10-49-59AM/installActions2023-07-03_10-49-59AM.log
Successfully Setup Software with warning(s).
As install user, execute the following command to complete the configuration.
/opt/oracle/product/19c/dbhome/runInstaller -executeConfigTools -responseFile /home/oracle/install.rsp [-silent]
[oracle@localhost ~]$ /opt/oracle/product/19c/dbhome/runInstaller -silent -executeConfigTools -responseFile /home/oracle/install.rsp
Launching Oracle Database Setup Wizard...
You can find the logs of this session at:
/opt/oraInventory/logs/InstallActions2023-07-03_10-58-36AM
Successfully Configured Software.
[oracle@localhost ~]$
コマンドの実行が完了すると、GUIでの作業と同じ状態になります。
