Thursday, February 5, 2026

Oracle_AI_Database_26ai_Free_Installation_(formerly Express Edition XE)

Installing Oracle AI Database 26ai Free (formerly Express Edition/XE) involves downloading the appropriate package for your operating system (Linux or Windows) and running the installer. The 26ai version is designed for development, featuring 2 CPUs, 2 GB of RAM, and 12 GB of storage, with support for modern AI-driven data workloads.

Prerequisites

Operating System: Oracle Linux 8/9, Red Hat Enterprise Linux 8/9, or Windows x64.

Space: Approximately 9 GB in /opt for Linux or similar space on Windows.

Removal: Uninstall any previous versions of Oracle XE or Free.

========================================================================

1 - Install dependencies, database and configure DB

========================================================================

sudo -s

dnf upgrade

dnf -y install oracle-ai-database-preinstall-26ai-1.0-1.el9.x86_64.rpm

rpm -qa|grep oracle

Download db installation rpm.

https://www.oracle.com/in/database/free/get-started/

rpm -ivh oracle-ai-database-free-26ai-23.26.1-1.el8.x86_64.rpm >>> Manual Installation

dnf -y install oracle-ai-database-free-26ai-23.26.0-1.el9.x86_64.rpm

rpm -qa|grep oracle

/etc/init.d/oracle-free-26ai configure

export ORACLE_SID=FREE

export ORAENV_ASK=NO

. /opt/oracle/product/26ai/dbhomeFree/bin/oraenv

========================================================================

2 - Add tcp 1521 port in firewall

========================================================================

dnf install -y firewall-config

Use firewall configuration GUI in Linux

Allow DB connection to come in from outside

========================================================================

3 - Add environment variables

========================================================================

exit from root

vi ~/.bash_profile

add below lines at the end of .bash_profile

export ORACLE_SID=FREE

export ORACLE_BASE=/opt/oracle

export ORACLE_HOME=/opt/oracle/product/26ai/dbhomeFree

export PATH=$PATH:/opt/oracle/product/26ai/dbhomeFree/bin

========================================================================

4 - Configure Linux to automatically start Oracle Database when the system starts

========================================================================

sudo systemctl enable oracle-free-26ai

sudo systemctl daemon-reload

sudo /etc/init.d/oracle-free-26ai status

========================================================================

5 - Reboot Linux

========================================================================

6 - Test DB connection (Container DB)from sqlplus as sysdba

========================================================================

sqlplus sys@localhost:1521/FREE as sysdba

========================================================================

7 - Create an user in DB

========================================================================

alter session set "_ORACLE_SCRIPT"=true;

CREATE USER testuser1 IDENTIFIED BY test123;

grant connect to testuser1;

grant create session, grant any privilege to testuser1;

grant unlimited tablespace to testuser1;

GRANT SELECT ANY TABLE TO testuser1;

GRANT INSERT ANY TABLE TO testuser1;

GRANT CREATE ANY TABLE TO testuser1;

========================================================================

8 - Connect to DB (Pluggable DB) from sqlplus as testuser1

========================================================================

sqlplus testuser1@localhost:1521/FREE

========================================================================

9 - Install SQL Developer and connect to DB as testuser1

========================================================================

Logs:
++++++++++++

[root@oel810lab1 ~]# cat /etc/os-release

NAME="Oracle Linux Server"

VERSION="8.10"

ID="ol"

ID_LIKE="fedora"

VARIANT="Server"

VARIANT_ID="server"

VERSION_ID="8.10"

PLATFORM_ID="platform:el8"

PRETTY_NAME="Oracle Linux Server 8.10"

ANSI_COLOR="0;31"

CPE_NAME="cpe:/o:oracle:linux:8:10:server"

HOME_URL="https://linux.oracle.com/"

BUG_REPORT_URL="https://github.com/oracle/oracle-linux"

ORACLE_BUGZILLA_PRODUCT="Oracle Linux 8"

ORACLE_BUGZILLA_PRODUCT_VERSION=8.10

ORACLE_SUPPORT_PRODUCT="Oracle Linux"

ORACLE_SUPPORT_PRODUCT_VERSION=8.10

[root@oel810lab1 ~]#

[root@oel810lab1 ~]# yum install oracle* --skip-broken

Last metadata expiration check: 0:27:00 ago on Tue 03 Feb 2026 12:30:56 PM EST.

Package oracle-backgrounds-84.5-1.0.2.el8.noarch is already installed.

Package oracle-database-preinstall-23ai-1.0-4.el8.x86_64 is already installed.

Package oracle-indexhtml-8-7.0.2.el8.noarch is already installed.

Package oracle-logos-84.5-1.0.2.el8.x86_64 is already installed.

Package oraclelinux-developer-release-el8-1.0-7.el8.x86_64 is already installed.

Package oraclelinux-release-8:8.10-1.0.7.el8.x86_64 is already installed.

Package oraclelinux-release-el8-1.0-38.el8.x86_64 is already installed.

Dependencies resolved.

=========================================================================================================================================================================================

Package Architecture Version Repository Size

=========================================================================================================================================================================================

Installing:

oracle-ai-database-preinstall-26ai x86_64 1.0-1.el8 ol8_appstream 29 k

oracle-database-preinstall-19c x86_64 1.0-2.el8 ol8_appstream 31 k

oracle-database-preinstall-21c x86_64 1.0-1.el8 ol8_appstream 30 k

oracle-epel-release-el8 x86_64 1.0-5.el8 ol8_baseos_latest 15 k

oracle-gluster-release-el8 x86_64 1.0-3.el8 ol8_baseos_latest 18 k

oracle-instantclient-release-26ai-el8 x86_64 1.0-6.el8 ol8_baseos_latest 14 k

oracle-instantclient-release-el8 x86_64 1.0-2.el8 ol8_baseos_latest 18 k

oracle-java-jdk-release-el8 x86_64 1.0-6.el8 ol8_baseos_latest 14 k

oracle-linux-manager-client-release-el8 x86_64 1.0-1.el8 ol8_baseos_latest 16 k

oracle-logos-httpd noarch 84.5-1.0.2.el8 ol8_baseos_latest 28 k

oracle-logos-ipa noarch 84.5-1.0.2.el8 ol8_baseos_latest 127 k

oracle-ocne-release-el8 x86_64 1.0-14.el8 ol8_baseos_latest 16 k

oracle-ovirt-release-45-el8 x86_64 1.0-39.el8 ol8_baseos_latest 25 k

oracle-ovirt-release-el8 x86_64 1.0-1.0.10.el8 ol8_baseos_latest 24 k

oracle-release-el8 x86_64 1.0-3.el8 ol8_baseos_latest 18 k

oracle-software-release-el8 x86_64 1.0-3.el8 ol8_baseos_latest 14 k

oracle-spacewalk-client-release-el8 x86_64 1.0-1.el8 ol8_baseos_latest 16 k

oraclelinux-automation-manager-release-el8 x86_64 2.3-1.el8 ol8_baseos_latest 16 k

Installing dependencies:

compat-openssl10 x86_64 1:1.0.2o-4.el8_10.1 ol8_appstream 1.1 M

libaio-devel x86_64 0.3.112-1.el8 ol8_baseos_latest 19 k

libnsl x86_64 2.28-251.0.3.el8_10.16 ol8_baseos_latest 115 k

libstdc++-devel x86_64 8.5.0-26.0.1.el8_10 ol8_appstream 2.1 M

python3-dnf-plugin-versionlock noarch 4.0.21-25.0.1.el8 ol8_baseos_latest 65 k

yum-utils noarch 4.0.21-25.0.1.el8 ol8_baseos_latest 75 k

Transaction Summary

=========================================================================================================================================================================================

Install 24 Packages

Total download size: 3.9 M

Installed size: 15 M

Is this ok [y/N]: y

Downloading Packages:

(1/24): oracle-epel-release-el8-1.0-5.el8.x86_64.rpm 441 kB/s | 15 kB 00:00

(2/24): oracle-gluster-release-el8-1.0-3.el8.x86_64.rpm 3.8 MB/s | 18 kB 00:00

(3/24): oracle-instantclient-release-26ai-el8-1.0-6.el8.x86_64.rpm 4.4 MB/s | 14 kB 00:00

(4/24): oracle-instantclient-release-el8-1.0-2.el8.x86_64.rpm 4.8 MB/s | 18 kB 00:00

(5/24): libaio-devel-0.3.112-1.el8.x86_64.rpm 359 kB/s | 19 kB 00:00

(6/24): oracle-java-jdk-release-el8-1.0-6.el8.x86_64.rpm 3.1 MB/s | 14 kB 00:00

(7/24): oracle-logos-httpd-84.5-1.0.2.el8.noarch.rpm 8.2 MB/s | 28 kB 00:00

(8/24): oracle-logos-ipa-84.5-1.0.2.el8.noarch.rpm 18 MB/s | 127 kB 00:00

(9/24): oracle-linux-manager-client-release-el8-1.0-1.el8.x86_64.rpm 1.2 MB/s | 16 kB 00:00

(10/24): oracle-ovirt-release-45-el8-1.0-39.el8.x86_64.rpm 6.8 MB/s | 25 kB 00:00

(11/24): oracle-ovirt-release-el8-1.0-1.0.10.el8.x86_64.rpm 5.5 MB/s | 24 kB 00:00

(12/24): oracle-ocne-release-el8-1.0-14.el8.x86_64.rpm 1.3 MB/s | 16 kB 00:00

(13/24): oracle-software-release-el8-1.0-3.el8.x86_64.rpm 3.2 MB/s | 14 kB 00:00

(14/24): oracle-release-el8-1.0-3.el8.x86_64.rpm 2.4 MB/s | 18 kB 00:00

(15/24): oraclelinux-automation-manager-release-el8-2.3-1.el8.x86_64.rpm 4.1 MB/s | 16 kB 00:00

(16/24): python3-dnf-plugin-versionlock-4.0.21-25.0.1.el8.noarch.rpm 8.3 MB/s | 65 kB 00:00

(17/24): oracle-spacewalk-client-release-el8-1.0-1.el8.x86_64.rpm 1.1 MB/s | 16 kB 00:00

(18/24): yum-utils-4.0.21-25.0.1.el8.noarch.rpm 19 MB/s | 75 kB 00:00

(19/24): compat-openssl10-1.0.2o-4.el8_10.1.x86_64.rpm 41 MB/s | 1.1 MB 00:00

(20/24): oracle-ai-database-preinstall-26ai-1.0-1.el8.x86_64.rpm 6.1 MB/s | 29 kB 00:00

(21/24): oracle-database-preinstall-19c-1.0-2.el8.x86_64.rpm 8.1 MB/s | 31 kB 00:00

(22/24): oracle-database-preinstall-21c-1.0-1.el8.x86_64.rpm 7.8 MB/s | 30 kB 00:00

(23/24): libstdc++-devel-8.5.0-26.0.1.el8_10.x86_64.rpm 41 MB/s | 2.1 MB 00:00

(24/24): libnsl-2.28-251.0.3.el8_10.16.x86_64.rpm 61 kB/s | 115 kB 00:01

-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

Total 2.1 MB/s | 3.9 MB 00:01

Running transaction check

Transaction check succeeded.

Running transaction test

Transaction test succeeded.

Running transaction

Running scriptlet: oraclelinux-automation-manager-release-el8-2.3-1.el8.x86_64 1/1

Preparing : 1/1

Installing : yum-utils-4.0.21-25.0.1.el8.noarch 1/24

Installing : oracle-gluster-release-el8-1.0-3.el8.x86_64 2/24

Running scriptlet: oracle-gluster-release-el8-1.0-3.el8.x86_64 2/24

Installing : compat-openssl10-1:1.0.2o-4.el8_10.1.x86_64 3/24

Running scriptlet: compat-openssl10-1:1.0.2o-4.el8_10.1.x86_64 3/24

Installing : python3-dnf-plugin-versionlock-4.0.21-25.0.1.el8.noarch 4/24

Installing : libnsl-2.28-251.0.3.el8_10.16.x86_64 5/24

Installing : libstdc++-devel-8.5.0-26.0.1.el8_10.x86_64 6/24

Installing : libaio-devel-0.3.112-1.el8.x86_64 7/24

Running scriptlet: oracle-database-preinstall-19c-1.0-2.el8.x86_64 8/24

Installing : oracle-database-preinstall-19c-1.0-2.el8.x86_64 8/24

Installing : oracle-database-preinstall-21c-1.0-1.el8.x86_64 9/24

Running scriptlet: oracle-ovirt-release-45-el8-1.0-39.el8.x86_64 10/24

Installing : oracle-ovirt-release-45-el8-1.0-39.el8.x86_64 10/24

Running scriptlet: oracle-ovirt-release-45-el8-1.0-39.el8.x86_64 10/24

Setting up modules. This can take a minute

Running scriptlet: oracle-ovirt-release-el8-1.0-1.0.10.el8.x86_64 11/24

Installing : oracle-ovirt-release-el8-1.0-1.0.10.el8.x86_64 11/24

Running scriptlet: oracle-ovirt-release-el8-1.0-1.0.10.el8.x86_64 11/24

Installing : oracle-ai-database-preinstall-26ai-1.0-1.el8.x86_64 12/24

Installing : oracle-epel-release-el8-1.0-5.el8.x86_64 13/24

Installing : oracle-instantclient-release-26ai-el8-1.0-6.el8.x86_64 14/24

Installing : oracle-instantclient-release-el8-1.0-2.el8.x86_64 15/24

Running scriptlet: oracle-instantclient-release-el8-1.0-2.el8.x86_64 15/24

Installing : oracle-java-jdk-release-el8-1.0-6.el8.x86_64 16/24

Installing : oracle-linux-manager-client-release-el8-1.0-1.el8.x86_64 17/24

Running scriptlet: oracle-linux-manager-client-release-el8-1.0-1.el8.x86_64 17/24

Installing : oracle-ocne-release-el8-1.0-14.el8.x86_64 18/24

Installing : oracle-release-el8-1.0-3.el8.x86_64 19/24

Running scriptlet: oracle-release-el8-1.0-3.el8.x86_64 19/24

Installing : oracle-software-release-el8-1.0-3.el8.x86_64 20/24

Installing : oracle-spacewalk-client-release-el8-1.0-1.el8.x86_64 21/24

Running scriptlet: oracle-spacewalk-client-release-el8-1.0-1.el8.x86_64 21/24

Installing : oraclelinux-automation-manager-release-el8-2.3-1.el8.x86_64 22/24

Installing : oracle-logos-ipa-84.5-1.0.2.el8.noarch 23/24

Installing : oracle-logos-httpd-84.5-1.0.2.el8.noarch 24/24

Running scriptlet: oracle-database-preinstall-19c-1.0-2.el8.x86_64 24/24

Running scriptlet: oracle-database-preinstall-21c-1.0-1.el8.x86_64 24/24

Running scriptlet: oracle-ovirt-release-45-el8-1.0-39.el8.x86_64 24/24

Last metadata expiration check: 0:00:24 ago on Tue 03 Feb 2026 01:01:11 PM EST.

Last metadata expiration check: 0:00:30 ago on Tue 03 Feb 2026 01:01:11 PM EST.

Last metadata expiration check: 0:00:36 ago on Tue 03 Feb 2026 01:01:11 PM EST.

Last metadata expiration check: 0:00:42 ago on Tue 03 Feb 2026 01:01:11 PM EST.

Last metadata expiration check: 0:00:49 ago on Tue 03 Feb 2026 01:01:11 PM EST.

Last metadata expiration check: 0:01:00 ago on Tue 03 Feb 2026 01:01:11 PM EST.

Last metadata expiration check: 0:01:06 ago on Tue 03 Feb 2026 01:01:11 PM EST.

Last metadata expiration check: 0:01:12 ago on Tue 03 Feb 2026 01:01:11 PM EST.

Last metadata expiration check: 0:01:18 ago on Tue 03 Feb 2026 01:01:11 PM EST.

Running scriptlet: oracle-ovirt-release-el8-1.0-1.0.10.el8.x86_64 24/24

Enabling OLVM 4.4 required Yum Channels...

Enabling ol8_baseos_latest Yum Channel...

Enabling ol8_UEKR6 Yum Channel...

Enabling ol8_gluster_appstream Yum Channel...

Enabling ol8_kvm_appstream Yum Channel...

Disabling yum module virt:ol

Enabling yum module virt:kvm_utils2

Enabling module pki-deps

Enabling module postgresql:13

Enabling module nodejs:18

Exclude ansible-core updates from OL ol8_appstream

Required oVirt 4.4 Yum Channels enabled.

Done.

Last metadata expiration check: 0:00:45 ago on Tue 03 Feb 2026 01:04:01 PM EST.

Adding versionlock on: qemu-kvm-15:6.1.1-8.module+el8.8.0+21161+70fb2747.*

Last metadata expiration check: 0:00:52 ago on Tue 03 Feb 2026 01:04:01 PM EST.

Adding versionlock on: qemu-kvm-common-15:6.1.1-8.module+el8.8.0+21161+70fb2747.*

Last metadata expiration check: 0:01:02 ago on Tue 03 Feb 2026 01:04:01 PM EST.

Adding versionlock on: qemu-kvm-core-15:6.1.1-8.module+el8.8.0+21161+70fb2747.*

Last metadata expiration check: 0:01:09 ago on Tue 03 Feb 2026 01:04:01 PM EST.

Adding versionlock on: qemu-kvm-block-ssh-15:6.1.1-8.module+el8.8.0+21161+70fb2747.*

Last metadata expiration check: 0:01:19 ago on Tue 03 Feb 2026 01:04:01 PM EST.

Adding versionlock on: qemu-kvm-block-rbd-15:6.1.1-8.module+el8.8.0+21161+70fb2747.*

Last metadata expiration check: 0:01:26 ago on Tue 03 Feb 2026 01:04:01 PM EST.

Adding versionlock on: qemu-kvm-block-iscsi-15:6.1.1-8.module+el8.8.0+21161+70fb2747.*

Last metadata expiration check: 0:01:33 ago on Tue 03 Feb 2026 01:04:01 PM EST.

Adding versionlock on: qemu-kvm-block-gluster-15:6.1.1-8.module+el8.8.0+21161+70fb2747.*

Last metadata expiration check: 0:01:39 ago on Tue 03 Feb 2026 01:04:01 PM EST.

Adding versionlock on: qemu-kvm-block-curl-15:6.1.1-8.module+el8.8.0+21161+70fb2747.*

Last metadata expiration check: 0:01:46 ago on Tue 03 Feb 2026 01:04:01 PM EST.

Adding versionlock on: qemu-img-15:6.1.1-8.module+el8.8.0+21161+70fb2747.*

Running scriptlet: oracle-ai-database-preinstall-26ai-1.0-1.el8.x86_64 24/24

Running scriptlet: oracle-logos-httpd-84.5-1.0.2.el8.noarch 24/24

Verifying : libaio-devel-0.3.112-1.el8.x86_64 1/24

Verifying : libnsl-2.28-251.0.3.el8_10.16.x86_64 2/24

Verifying : oracle-epel-release-el8-1.0-5.el8.x86_64 3/24

Verifying : oracle-gluster-release-el8-1.0-3.el8.x86_64 4/24

Verifying : oracle-instantclient-release-26ai-el8-1.0-6.el8.x86_64 5/24

Verifying : oracle-instantclient-release-el8-1.0-2.el8.x86_64 6/24

Verifying : oracle-java-jdk-release-el8-1.0-6.el8.x86_64 7/24

Verifying : oracle-linux-manager-client-release-el8-1.0-1.el8.x86_64 8/24

Verifying : oracle-logos-httpd-84.5-1.0.2.el8.noarch 9/24

Verifying : oracle-logos-ipa-84.5-1.0.2.el8.noarch 10/24

Verifying : oracle-ocne-release-el8-1.0-14.el8.x86_64 11/24

Verifying : oracle-ovirt-release-45-el8-1.0-39.el8.x86_64 12/24

Verifying : oracle-ovirt-release-el8-1.0-1.0.10.el8.x86_64 13/24

Verifying : oracle-release-el8-1.0-3.el8.x86_64 14/24

Verifying : oracle-software-release-el8-1.0-3.el8.x86_64 15/24

Verifying : oracle-spacewalk-client-release-el8-1.0-1.el8.x86_64 16/24

Verifying : oraclelinux-automation-manager-release-el8-2.3-1.el8.x86_64 17/24

Verifying : python3-dnf-plugin-versionlock-4.0.21-25.0.1.el8.noarch 18/24

Verifying : yum-utils-4.0.21-25.0.1.el8.noarch 19/24

Verifying : compat-openssl10-1:1.0.2o-4.el8_10.1.x86_64 20/24

Verifying : libstdc++-devel-8.5.0-26.0.1.el8_10.x86_64 21/24

Verifying : oracle-ai-database-preinstall-26ai-1.0-1.el8.x86_64 22/24

Verifying : oracle-database-preinstall-19c-1.0-2.el8.x86_64 23/24

Verifying : oracle-database-preinstall-21c-1.0-1.el8.x86_64 24/24

Installed:

compat-openssl10-1:1.0.2o-4.el8_10.1.x86_64 libaio-devel-0.3.112-1.el8.x86_64 libnsl-2.28-251.0.3.el8_10.16.x86_64

libstdc++-devel-8.5.0-26.0.1.el8_10.x86_64 oracle-ai-database-preinstall-26ai-1.0-1.el8.x86_64 oracle-database-preinstall-19c-1.0-2.el8.x86_64

oracle-database-preinstall-21c-1.0-1.el8.x86_64 oracle-epel-release-el8-1.0-5.el8.x86_64 oracle-gluster-release-el8-1.0-3.el8.x86_64

oracle-instantclient-release-26ai-el8-1.0-6.el8.x86_64 oracle-instantclient-release-el8-1.0-2.el8.x86_64 oracle-java-jdk-release-el8-1.0-6.el8.x86_64

oracle-linux-manager-client-release-el8-1.0-1.el8.x86_64 oracle-logos-httpd-84.5-1.0.2.el8.noarch oracle-logos-ipa-84.5-1.0.2.el8.noarch

oracle-ocne-release-el8-1.0-14.el8.x86_64 oracle-ovirt-release-45-el8-1.0-39.el8.x86_64 oracle-ovirt-release-el8-1.0-1.0.10.el8.x86_64

oracle-release-el8-1.0-3.el8.x86_64 oracle-software-release-el8-1.0-3.el8.x86_64 oracle-spacewalk-client-release-el8-1.0-1.el8.x86_64

oraclelinux-automation-manager-release-el8-2.3-1.el8.x86_64 python3-dnf-plugin-versionlock-4.0.21-25.0.1.el8.noarch yum-utils-4.0.21-25.0.1.el8.noarch

Complete!

[root@oel810lab1 ~]#

[root@oel810lab1 dbhome_1]# id oracle

uid=54321(oracle) gid=54321(oinstall) groups=54321(oinstall),54322(dba),54323(oper),54324(backupdba),54325(dgdba),54326(kmdba),54330(racdba)

[root@oel810lab1 dbhome_1]# passwd oracle

Changing password for user oracle.

New password:

Retype new password:

passwd: all authentication tokens updated successfully.

[root@oel810lab1 dbhome_1]#

[root@oel810lab1 ~]# rpm -qa|grep oracle

oracle-ai-database-preinstall-26ai-1.0-1.el8.x86_64

[root@oel810lab1 ~]#

[root@oel810lab1 ~]# yum install oracle-ai-database-free-26ai-23.26.0-1.el9.x86_64.rpm

Last metadata expiration check: 1:49:15 ago on Wed 04 Feb 2026 02:00:08 PM EST.

Can not load RPM file: oracle-ai-database-free-26ai-23.26.0-1.el9.x86_64.rpm.

Could not open: oracle-ai-database-free-26ai-23.26.0-1.el9.x86_64.rpm

[root@oel810lab1 ~]# cd /etc/yum.repos.d/

[root@oel810lab1 yum.repos.d]# ll

total 84

-rw-r--r--. 1 root root 3070 Apr 22 2024 mysql-community-debuginfo.repo

-rw-r--r--. 1 root root 2755 Apr 22 2024 mysql-community.repo

-rw-r--r--. 1 root root 2870 Apr 22 2024 mysql-community-source.repo

-rw-r--r--. 1 root root 530 Mar 28 2022 oracle-epel-ol8.repo

-rw-r--r--. 1 root root 246 Feb 3 13:02 oracle-gluster-ol8.repo

-rw-r--r--. 1 root root 286 Nov 4 05:50 oracle-instantclient-26ai-ol8.repo

-rw-r--r--. 1 root root 267 Apr 11 2023 oracle-instantclient-ol8.repo

-rw-r--r--. 1 root root 233 Nov 4 05:50 oracle-java-jdk-ol8.repo

-rw-r--r--. 1 root root 1117 Apr 3 2025 oraclelinux-automation-manager-ol8.repo

-rw-r--r--. 1 root root 694 Jan 14 2022 oraclelinux-developer-ol8.repo

-rw-r--r--. 1 root root 277 Dec 7 2020 oracle-linux-manager-client-ol8.repo

-rw-r--r--. 1 root root 4128 Feb 3 13:03 oracle-linux-ol8.repo

-rw-r--r--. 1 root root 2553 May 22 2025 oracle-ocne-ol8.repo

-rw-r--r--. 1 root root 260 Apr 14 2023 oracle-ol8.repo

-rw-r--r--. 1 root root 411 Jul 2 2025 oracle-ovirt-45-ol8.repo

-rw-r--r--. 1 root root 417 Dec 13 2024 oracle-ovirt-ol8.repo

-rw-r--r--. 1 root root 244 Oct 9 2024 oracle-software-ol8.repo

-rw-r--r--. 1 root root 249 Aug 4 2020 oracle-spacewalk-client-ol8.repo

-rw-r--r--. 1 root root 941 Feb 3 13:02 uek-ol8.repo

-rw-r--r--. 1 root root 243 Feb 3 13:02 virt-ol8.repo

[root@oel810lab1 yum.repos.d]#

[root@oel810lab1 yum.repos.d]# cd /u01/patches/

[root@oel810lab1 patches]# ll

total 1454852

drwxrwxrwx. 2 oracle oinstall 114 Oct 2 04:40 23c

drwxr-xr-x. 4 oracle oinstall 26 Feb 3 11:27 26ai

-rw-r--r--. 1 oracle oinstall 1489765640 Feb 4 15:59 oracle-ai-database-free-26ai-23.26.1-1.el8.x86_64.rpm

[root@oel810lab1 patches]# rpm -ivh oracle-ai-database-free-26ai-23.26.1-1.el8.x86_64.rpm

Verifying... ################################# [100%]

Preparing... ################################# [100%]

Updating / installing...

1:oracle-ai-database-free-26ai-23.2################################# [100%]

[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.

[root@oel810lab1 patches]#

[root@oel810lab1 patches]# /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.

Connect to Oracle AI Database using one of the connect strings:

Pluggable database: oel810lab1.localdomain.com/FREEPDB1

Multitenant container database: oel810lab1.localdomain.com

[root@oel810lab1 patches]#

[root@oel810lab1 patches]# more /opt/oracle/cfgtoollogs/dbca/FREE/FREE.log

[ 2026-02-04 16:12:36.288 EST ] Prepare for db operation

DBCA_PROGRESS : 7%

[ 2026-02-04 16:12:36.419 EST ] Copying database files

DBCA_PROGRESS : 29%

[ 2026-02-04 16:14:06.258 EST ] Creating and starting Oracle instance

DBCA_PROGRESS : 30%

DBCA_PROGRESS : 33%

DBCA_PROGRESS : 36%

DBCA_PROGRESS : 39%

DBCA_PROGRESS : 43%

[ 2026-02-04 16:14:58.297 EST ] Completing Database Creation

DBCA_PROGRESS : 47%

DBCA_PROGRESS : 49%

DBCA_PROGRESS : 50%

[ 2026-02-04 16:17:37.275 EST ] Creating Pluggable Databases

DBCA_PROGRESS : 54%

DBCA_PROGRESS : 71%

[ 2026-02-04 16:17:51.268 EST ] Executing Post Configuration Actions

DBCA_PROGRESS : 93%

[ 2026-02-04 16:17:51.275 EST ] Running Custom Scripts

DBCA_PROGRESS : 100%

[ 2026-02-04 16:17:52.543 EST ] Database creation complete. For details check the logfiles at:

/opt/oracle/cfgtoollogs/dbca/FREE.

Database Information:

Global Database Name:FREE

System Identifier(SID):FREE

Trace file location:/opt/oracle/cfgtoollogs/dbca/FREE/trace.log_2026-02-04_04-12-24PM_106961

[root@oel810lab1 patches]#

[root@oel810lab1 ~]# cd /opt/oracle/product/26ai/dbhomeFree

[root@oel810lab1 dbhomeFree]#

[root@oel810lab1 dbhomeFree]# ls

addnode crypto deinstall hs jdk md oml4py oss QOpatch runInstaller sqlpatch xdk

assistants css demo install jlib mgw OPatch oui R schagent.conf sqlplus

bin ctx diagnostics instantclient ldap network opmn perl racg sdk srvm

cfgtoollogs cv dv inventory lib nls oracore plsql rdbms slax ucp

clone data env.ora javavm LICENSE odbc oraInst.loc precomp relnotes sqlcl usm

crs dbs has jdbc log olap ord python root.sh sqlj utl

[root@oel810lab1 dbhomeFree]#

[root@oel810lab1 patches]# ps -ef|grep smon

oracle 64723 13340 0 Feb03 ? 00:00:01 ora_smon_ORA26AI

oracle 108963 1 0 16:17 ? 00:00:00 db_smon_FREE

root 109381 105489 0 16:18 pts/0 00:00:00 grep --color=auto smon

[root@oel810lab1 patches]# su - oracle

[oracle@oel810lab1 ~]$ export ORACLE_SID=FREE

[oracle@oel810lab1 ~]$ export ORAENV_ASK=NO

[oracle@oel810lab1 ~]$ . /opt/oracle/product/26ai/dbhomeFree/bin/oraenv

The Oracle base has been set to /opt/oracle

[oracle@oel810lab1 dbhomeFree]$ env |grep ORA

ORACLE_SID=FREE

ORACLE_BASE=/opt/oracle

ORACLE_HOME=/opt/oracle/product/26ai/dbhomeFree

ORAENV_ASK=NO

[oracle@oel810lab1 dbhomeFree]$

[oracle@oel810lab1 dbhomeFree]$ sqlplus / as sysdba

SQL*Plus: Release 23.26.1.0.0 - Production on Wed Feb 4 16:20:03 2026

Version 23.26.1.0.0

Connected to:

Oracle AI Database 26ai Free Release 23.26.1.0.0 - Develop, Learn, and Run for Free

Version 23.26.1.0.0

SQL> select instance_name, status from v$instance;

INSTANCE_NAME STATUS

---------------- ------------

FREE OPEN

SQL> select name, open_mode from v$database;

NAME OPEN_MODE

--------- --------------------

FREE READ WRITE

SQL> show pdbs

CON_ID CON_NAME OPEN MODE RESTRICTED

---------- ------------------------------ ---------- ----------

2 PDB$SEED READ ONLY NO

3 FREEPDB1 READ WRITE NO

SQL> alter session set container=FREEPDB1

2 ;

Session altered.

SQL> show pdbs

CON_ID CON_NAME OPEN MODE RESTRICTED

---------- ------------------------------ ---------- ----------

3 FREEPDB1 READ WRITE NO

SQL> exit

Disconnected from Oracle AI Database 26ai Free Release 23.26.1.0.0 - Develop, Learn, and Run for Free

Version 23.26.1.0.0

[oracle@oel810lab1 dbhomeFree]$

Mallikarjun Ramadurg

THE ORACLE SME – ORACLE ACE, EXADATA, OCI, OCP, OCA, RAC EXPERT. Mallikarjun Ramadurg is the one of the active member of Oracle Community. Mallikarjun is an Oracle DBA and EXADATA administration Expert and has a deep knowledge in Oracle EBS APPS. He is having more than 11 Years of experience. He has got In-depth knowledge of database design, build, cloning and administration and he has got good exposure to environments like database HA, RAC, Oracle Cloud and Datawarehouse. He has worked on Oracle ERP, having sound knowledge on EBS application administration, apps cloning and upgradation, patching, security and performance turning. He has worked on informatica administration, implementation, design, mappings, workflows. He has good knowledge on data modeling, Erwin data modeling. He has good hands-on experience in Oracle Cloud and infrastructure level. He is currently working as Oracle SME & Staff Customer Success Engineer @ Rubrik Inc, Bangalore India

Wednesday, February 4, 2026

Oracle 26ai Installation DB Creation

1. Download and Install Oracle Home/Oracle Software -> Download 26ai Oracle Software and Install:

- Oracle Software

- DB Software

- Oracle Home

- DB Home

a. Download DB software (26ai) from https://edelivery.oracle.com

- Oracle AI Database 23.26.1.0.0 for Linux x86-64

- DB - V1054592-01.zip

b. Install Oracle Software / DB software / Oracle Home / DB Home

- Copy DB SW from lapttop / Desktop to VM

- Use winscp

- Shared folder / NFS shared drive

- Directory creation & SW unzip

- mkdir -p /u01/app/oracle/product/26ai/dbhome_1

- unzip V1054592-01.zip -d /u01/app/oracle/product/26ai/dbhome_1

- yum install oracle* --skip-broken (It will set all kernel parameters and it will install all pre-requisite rpms and set all shared memory setting and create all oracle user & groups)

- yum -y install oracle-database-ee-19c

- yum -y install oracle-database-ee-21c

- yum -y oracle-ai-database-preinstall-26ai

https://docs.oracle.com/en/database/oracle/oracle-database

19C -> https://docs.oracle.com/en/database/oracle/oracle-database/19/ladbi/running-rpm-packages-to-install-oracle-database.html

26ai -> https://docs.oracle.com/en/database/oracle/oracle-database/26/ladbi/installing-the-oracle-preinstallation-rpm-with-uln-support.html

- Optional (In case if you installed above RPM)

- User & group create (Not required)

# groupadd dba

# groupadd oinstall

# useradd -g oinstall -G oinstall,dba oracle

Advantages of oracle pre-requisite rpm installation

- all kernel parameter are set

- all the required rpms are auto installed

- all the oracle user and groups are auto created

- Change permission

#chown -R oracle:oinstall /u01

- passwd oracle (set password)

- Database SW Installation / Oracle SW Installation / Oracle Home Installation (from GUI screen as oracle user)

$ cd /u01/app/oracle/product/26ai/dbhome_1

$ ./runInstaller

2. Create Database -> ORA26AI

$ cd /u01/app/oracle/product/26ai/dbhome_1/bin (from GUI screen as oracle user)

$ ./dbca

logs:
+++++++++++++

[root@oel810lab1 ~]# cat /etc/os-release

NAME="Oracle Linux Server"

VERSION="8.10"

ID="ol"

ID_LIKE="fedora"

VARIANT="Server"

VARIANT_ID="server"

VERSION_ID="8.10"

PLATFORM_ID="platform:el8"

PRETTY_NAME="Oracle Linux Server 8.10"

ANSI_COLOR="0;31"

CPE_NAME="cpe:/o:oracle:linux:8:10:server"

HOME_URL="https://linux.oracle.com/"

BUG_REPORT_URL="https://github.com/oracle/oracle-linux"

ORACLE_BUGZILLA_PRODUCT="Oracle Linux 8"

ORACLE_BUGZILLA_PRODUCT_VERSION=8.10

ORACLE_SUPPORT_PRODUCT="Oracle Linux"

ORACLE_SUPPORT_PRODUCT_VERSION=8.10

[root@oel810lab1 ~]# cd /u01/patches/26ai/

[root@oel810lab1 26ai]# ll

total 0

drwxr-xr-x. 2 root root 29 Feb 3 11:27 DB

drwxr-xr-x. 2 root root 29 Feb 3 11:27 GI

[root@oel810lab1 26ai]# cd DB

[root@oel810lab1 DB]# ll

total 2349668

-rw-r--r--. 1 root root 2406058543 Feb 3 11:26 V1054592-01.zip

[root@oel810lab1 DB]# pwd

/u01/patches/26ai/DB

[root@oel810lab1 DB]# mkdir -p /u01/app/oracle/product/26ai/dbhome_1

[root@oel810lab1 DB]# unzip V1054592-01.zip -d /u01/app/oracle/product/26ai/dbhome_1

Archive: V1054592-01.zip

inflating: /u01/app/oracle/product/26ai/dbhome_1/META-INF/MANIFEST.MF

inflating: /u01/app/oracle/product/26ai/dbhome_1/META-INF/ORACLE_C.SF

inflating: /u01/app/oracle/product/26ai/dbhome_1/META-INF/ORACLE_C.RSA

creating: /u01/app/oracle/product/26ai/dbhome_1/OPatch/

<<<<<< Truncated >>>>>>>

/u01/app/oracle/product/26ai/dbhome_1/rdbms/mesg/ocitr.msb -> oratr.msb

/u01/app/oracle/product/26ai/dbhome_1/rdbms/mesg/ocius.msb -> oraus.msb

/u01/app/oracle/product/26ai/dbhome_1/rdbms/mesg/ocius.msg -> ./oraus.msg

/u01/app/oracle/product/26ai/dbhome_1/rdbms/mesg/ocizhs.msb -> orazhs.msb

/u01/app/oracle/product/26ai/dbhome_1/rdbms/mesg/ocizht.msb -> orazht.msb

[root@oel810lab1 DB]# cd /u01/app/oracle/product/26ai/dbhome_1

[root@oel810lab1 dbhome_1]#

[root@oel810lab1 dbhome_1]# ls

addnode crypto dbs env.ora inventory ldap mgw oml4py ords precomp rdbms sdk sqlplus utl

assistants css deinstall has javavm lib network OPatch oss python relnotes slax srvm xdk

bin ctx demo hs jdbc log nls opmn oui QOpatch root.sh sqlcl suptools

clone cv diagnostics install jdk md odbc oracore perl R runInstaller sqlj ucp

crs data dv instantclient jlib META-INF olap ord plsql racg schagent.conf sqlpatch usm