やれること
2025/10/14 Oracle AI World 2025当日にリリースされた Oracle Database 26ai Freeを最速インストール。
OCIのComputeでOracle Linux 8環境を作ったデフォルト状態からスタートします。
環境
・Oracle Linux 8 (OCI)
・Oracle Database 26ai Free
・作業するOSユーザ:root
手順で実施できること
・手順内で OSユーザ「oracle」が作成される
・Oracle AI DatabaseのS/Wがインストールされる。
・データベース「FREE」が作成される
・SQL*Plusが使えるようになる。
Oracle Database 26ai Free 環境の構築
0.26aiインストールファイルのダウンロード
今回はLinux8用の「oracle-ai-database-free-26ai-23.26.0-1.el8.x86_64.rpm」をダウンロードしました。
Computeの/tmpに配置します。
https://www.oracle.com/database/free/get-started/
1.26aiインストール1 (OSユーザ root で実行)####
<実行コマンド>
dnf install -y oracle-ai-database-preinstall-26ai
<実行例>
★の部分が入力箇所です
★[root@nishi26ai ~]# dnf install -y oracle-ai-database-preinstall-26ai
Ksplice for Oracle Linux 8 (x86_64) 72 MB/s | 33 MB 00:00
MySQL 8.4 Server Community for Oracle Linux 8 ( 21 MB/s | 1.2 MB 00:00
MySQL 8.4 Tools Community for Oracle Linux 8 (x 11 MB/s | 538 kB 00:00
MySQL Connectors Community for Oracle Linux 8 ( 932 kB/s | 48 kB 00:00
Oracle Software for OCI users on Oracle Linux 8 49 MB/s | 245 MB 00:04
Oracle Linux 8 BaseOS Latest (x86_64) 70 MB/s | 116 MB 00:01
Oracle Linux 8 Application Stream (x86_64) 71 MB/s | 73 MB 00:01
Oracle Linux 8 Addons (x86_64) 12 MB/s | 49 MB 00:03
Latest Unbreakable Enterprise Kernel Release 7 79 MB/s | 77 MB 00:00
Dependencies resolved.
================================================================================
Package Arch Version Repository Size
================================================================================
Installing:
oracle-ai-database-preinstall-26ai
x86_64 1.0-1.el8 ol8_appstream 29 k
Installing dependencies:
compat-openssl10 x86_64 1:1.0.2o-4.el8_10.1 ol8_appstream 1.1 M
ksh x86_64 20120801-269.0.1.el8_10 ol8_appstream 924 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 20 Packages
Total download size: 2.9 M
Installed size: 7.9 M
Downloading Packages:
(1/20): libICE-1.0.9-15.el8.x86_64.rpm 3.0 MB/s | 74 kB 00:00
(2/20): libSM-1.2.3-1.el8.x86_64.rpm 7.1 MB/s | 47 kB 00:00
(3/20): libX11-xcb-1.6.8-9.el8_10.x86_64.rpm 2.8 MB/s | 14 kB 00:00
(4/20): compat-openssl10-1.0.2o-4.el8_10.1.x86_ 26 MB/s | 1.1 MB 00:00
(5/20): libXcomposite-0.4.4-14.el8.x86_64.rpm 3.0 MB/s | 28 kB 00:00
(6/20): libXinerama-1.1.4-1.el8.x86_64.rpm 2.9 MB/s | 15 kB 00:00
(7/20): libXi-1.7.10-1.el8.x86_64.rpm 3.8 MB/s | 49 kB 00:00
(8/20): libXmu-1.1.3-1.el8.x86_64.rpm 8.8 MB/s | 75 kB 00:00
(9/20): libXrandr-1.5.2-1.el8.x86_64.rpm 3.1 MB/s | 34 kB 00:00
(10/20): libXt-1.1.5-12.el8.x86_64.rpm 13 MB/s | 185 kB 00:00
(11/20): libXtst-1.2.3-7.el8.x86_64.rpm 1.9 MB/s | 22 kB 00:00
(12/20): libXv-1.0.11-7.el8.x86_64.rpm 2.7 MB/s | 20 kB 00:00
(13/20): libXxf86misc-1.0.4-1.el8.x86_64.rpm 3.4 MB/s | 23 kB 00:00
(14/20): libXxf86dga-1.1.5-1.el8.x86_64.rpm 1.8 MB/s | 26 kB 00:00
(15/20): libXxf86vm-1.1.4-9.el8.x86_64.rpm 2.5 MB/s | 19 kB 00:00
(16/20): libdmx-1.1.4-3.el8.x86_64.rpm 1.7 MB/s | 22 kB 00:00
(17/20): xorg-x11-utils-7.5-28.el8.x86_64.rpm 7.7 MB/s | 136 kB 00:00
(18/20): xorg-x11-xauth-1.0.9-12.el8.x86_64.rpm 3.4 MB/s | 39 kB 00:00
(19/20): ksh-20120801-269.0.1.el8_10.x86_64.rpm 5.5 MB/s | 924 kB 00:00
(20/20): oracle-ai-database-preinstall-26ai-1.0 353 kB/s | 29 kB 00:00
--------------------------------------------------------------------------------
Total 16 MB/s | 2.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/20
Installing : libICE-1.0.9-15.el8.x86_64 2/20
Installing : libSM-1.2.3-1.el8.x86_64 3/20
Installing : libXt-1.1.5-12.el8.x86_64 4/20
Installing : libXmu-1.1.3-1.el8.x86_64 5/20
Installing : xorg-x11-xauth-1:1.0.9-12.el8.x86_64 6/20
Installing : libXtst-1.2.3-7.el8.x86_64 7/20
Installing : libdmx-1.1.4-3.el8.x86_64 8/20
Installing : libXxf86vm-1.1.4-9.el8.x86_64 9/20
Installing : libXxf86misc-1.0.4-1.el8.x86_64 10/20
Installing : libXxf86dga-1.1.5-1.el8.x86_64 11/20
Installing : libXv-1.0.11-7.el8.x86_64 12/20
Installing : libXrandr-1.5.2-1.el8.x86_64 13/20
Installing : libXinerama-1.1.4-1.el8.x86_64 14/20
Installing : libXcomposite-0.4.4-14.el8.x86_64 15/20
Installing : libX11-xcb-1.6.8-9.el8_10.x86_64 16/20
Installing : xorg-x11-utils-7.5-28.el8.x86_64 17/20
Installing : ksh-20120801-269.0.1.el8_10.x86_64 18/20
Running scriptlet: ksh-20120801-269.0.1.el8_10.x86_64 18/20
Installing : compat-openssl10-1:1.0.2o-4.el8_10.1.x86_64 19/20
Running scriptlet: compat-openssl10-1:1.0.2o-4.el8_10.1.x86_64 19/20
Installing : oracle-ai-database-preinstall-26ai-1.0-1.el8.x86_6 20/20
Running scriptlet: oracle-ai-database-preinstall-26ai-1.0-1.el8.x86_6 20/20
Verifying : compat-openssl10-1:1.0.2o-4.el8_10.1.x86_64 1/20
Verifying : ksh-20120801-269.0.1.el8_10.x86_64 2/20
Verifying : libICE-1.0.9-15.el8.x86_64 3/20
Verifying : libSM-1.2.3-1.el8.x86_64 4/20
Verifying : libX11-xcb-1.6.8-9.el8_10.x86_64 5/20
Verifying : libXcomposite-0.4.4-14.el8.x86_64 6/20
Verifying : libXi-1.7.10-1.el8.x86_64 7/20
Verifying : libXinerama-1.1.4-1.el8.x86_64 8/20
Verifying : libXmu-1.1.3-1.el8.x86_64 9/20
Verifying : libXrandr-1.5.2-1.el8.x86_64 10/20
Verifying : libXt-1.1.5-12.el8.x86_64 11/20
Verifying : libXtst-1.2.3-7.el8.x86_64 12/20
Verifying : libXv-1.0.11-7.el8.x86_64 13/20
Verifying : libXxf86dga-1.1.5-1.el8.x86_64 14/20
Verifying : libXxf86misc-1.0.4-1.el8.x86_64 15/20
Verifying : libXxf86vm-1.1.4-9.el8.x86_64 16/20
Verifying : libdmx-1.1.4-3.el8.x86_64 17/20
Verifying : oracle-ai-database-preinstall-26ai-1.0-1.el8.x86_6 18/20
Verifying : xorg-x11-utils-7.5-28.el8.x86_64 19/20
Verifying : xorg-x11-xauth-1:1.0.9-12.el8.x86_64 20/20
Installed:
compat-openssl10-1:1.0.2o-4.el8_10.1.x86_64
ksh-20120801-269.0.1.el8_10.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-ai-database-preinstall-26ai-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@nishi26ai ~]#
2.26aiインストール2 (OSユーザ root で実行)####
<実行コマンド>
dnf -y localinstall /tmp/oracle-ai-database-free-26ai-23.26.0-1.el8.x86_64.rpm
<実行例>
★の部分が入力箇所です
★[root@nishi26ai ~]# dnf -y localinstall /tmp/oracle-ai-database-free-26ai-23.26.0-1.el8.x86_64.rpm
Last metadata expiration check: 0:53:08 ago on Tue 14 Oct 2025 04:25:26 PM GMT.
Dependencies resolved.
=======================================================================================================================
Package Architecture Version Repository Size
=======================================================================================================================
Installing:
oracle-ai-database-free-26ai x86_64 23.26.0-1 @commandline 1.3 G
Transaction Summary
=======================================================================================================================
Install 1 Package
Total size: 1.3 G
Installed size: 3.6 G
Downloading Packages:
Running transaction check
Transaction check succeeded.
Running transaction test
Transaction test succeeded.
Running transaction
Preparing : 1/1
Running scriptlet: oracle-ai-database-free-26ai-23.26.0-1.x86_64 1/1
Installing : oracle-ai-database-free-26ai-23.26.0-1.x86_64 1/1
Running scriptlet: oracle-ai-database-free-26ai-23.26.0-1.x86_64 1/1
[INFO] Executing post installation scripts...
[INFO] Oracle home installed successfully and ready to be configured.
To configure Oracle AI Database Free, optionally modify the parameters in '/etc/sysconfig/oracle-free-26ai.conf' and then run '/etc/init.d/oracle-free-26ai configure' as root.
Verifying : oracle-ai-database-free-26ai-23.26.0-1.x86_64 1/1
Installed:
oracle-ai-database-free-26ai-23.26.0-1.x86_64
Complete!
[root@nishi26ai ~]#
3.26aiデータベース・リスナー作成 (OSユーザ root で実行)
<実行コマンド>
/etc/init.d/oracle-free-26ai configure
※ 実行するとSYSユーザのパスワード入力が求められるので、入力します。8文字以上数字必要
<実行例>
★の部分が入力箇所です
★[root@nishi26ai ~]# /etc/init.d/oracle-free-26ai configure
Specify a password to be used for database accounts. Oracle recommends that the password
entered should be at least 8 characters in length, contain at least 1 uppercase character,
1 lower case character and 1 digit [0-9]. Note that the same password will be used for SYS,
SYSTEM and PDBADMIN accounts:★パスワード入力
Confirm the password:★パスワード確認入力
Configuring Oracle Listener.
Listener configuration succeeded.
Configuring Oracle AI Database FREE.
Enter SYS user password:
*********
Enter SYSTEM user password:
**********
Enter PDBADMIN User Password:
***********
Prepare for db operation
7% complete
Copying database files
29% complete
Creating and starting Oracle instance
30% complete
33% complete
36% complete
39% complete
43% complete
Completing Database Creation
47% complete
49% complete
50% complete
Creating Pluggable Databases
54% complete
71% complete
Executing Post Configuration Actions
93% complete
Running Custom Scripts
100% complete
Database creation complete. For details check the logfiles at:
/opt/oracle/cfgtoollogs/dbca/FREE.
Database Information:
Global Database Name:FREE
System Identifier(SID):FREE
Look at the log file "/opt/oracle/cfgtoollogs/dbca/FREE/FREE.log" for further details.
これで完成です!
使いやすくするための設定
<構築されたDB>
OSユーザ:oracle
インストールパス(ORACLE_HOME):/opt/oracle/product/26ai/dbhomeFree/
SID:FREE
OSユーザ oracle の設定
OSユーザの環境変数に設定するのがおすすめです
--★/home/oracle/.bash_profileに以下を設定
export ORACLE_BASE=/opt/oracle
export ORACLE_HOME=/opt/oracle/product/26ai/dbhomeFree
export ORACLE_SID=FREE
export NLS_LANG=Japanese_Japan.AL32UTF8
export PATH=$ORACLE_HOME/bin:$PATH
作られた環境の確認
<実行するコマンド>
環境確認をしてみます
sqlplus / as sysdba
show parameter instance_name
show pdbs
alter session set container=FREEPDB1;
select username from dba_users order by 1;
exit
実行例
--★SQL*Plusで接続します。26aiは23.26と表現されるみたいです。
[oracle@nishi26ai ~]$ sqlplus / as sysdba
SQL*Plus: Release 23.26.0.0.0 - Production on 火 10月 14 17:34:21 2025
Version 23.26.0.0.0
Copyright (c) 1982, 2025, Oracle. All rights reserved.
Oracle AI Database 26ai Free Release 23.26.0.0.0 - Develop, Learn, and Run for Free
Version 23.26.0.0.0
に接続されました。
--★インスタンス名を確認します(FREEです)
SQL> show parameter instance_name
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
instance_name string FREE
--★作成されているPDBを確認します(FREEPDB1があります)
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 FREEPDB1 READ WRITE NO
--★FREEPDB1に接続します
SQL> alter session set container=FREEPDB1;
セッションが変更されました。
--★DBユーザを確認します(初期ユーザのみでサンプルデータはない)
SQL> select username from dba_users order by 1;
USERNAME
--------------------------------------------------------------------------------
ANONYMOUS
APPQOSSYS
AUDSYS
BAASSYS
CTXSYS
DBSFWUSER
DBSNMP
DGPDB_INT
DIP
DVF
DVSYS
USERNAME
--------------------------------------------------------------------------------
GGSHAREDCAP
GGSYS
GSMADMIN_INTERNAL
GSMCATUSER
GSMUSER
LBACSYS
MDDATA
MDSYS
OJVMSYS
OLAPSYS
OUTLN
USERNAME
--------------------------------------------------------------------------------
PDBADMIN
REMOTE_SCHEDULER_AGENT
SYS
SYS$UMF
SYSBACKUP
SYSDG
SYSKM
SYSRAC
SYSTEM
VECSYS
WMSYS
USERNAME
--------------------------------------------------------------------------------
XDB
XS$NULL
35行が選択されました。
SQL> exit
Oracle AI Database 26ai Free Release 23.26.0.0.0 - Develop, Learn, and Run for Free
Version 23.26.0.0.0との接続が切断されました。
[oracle@nishi26ai ~]$