OracleNotes

Tag: Oracle AI Database 26ai

  • Oracle AI Database 26ai Software Install using AutoUpgrade on a Brand New VM!

    Oracle AI Database 26ai Software Install using AutoUpgrade on a Brand New VM!

    This week, I attended the East Coast Oracle Conference and listened to Alex Zaballa. He finished his session early and jumped to show some of the cool features available in AutoUpgrade. I was truly impressed by the new features and capabilities of AutoUpgrade. I think that soon the upgrade team will have to change the product name, as AutoUpgrade does a lot more than just Oracle Database upgrades.

    I wanted to check out the Oracle software install with all patches and updates automagically using AutoUpgrade on a brand new server. Thanks Alex!

    Let’s begin with 19c before I demonstrate the Oracle AI Database 26ai installation. By the way, 26ai is a RU patch for 23ai — the main version number remains at 23. To upgrade to AIDB 26ai, simply apply the October 2025 RU on your existing 23ai database.

    Virtual Machine on OCI Setup

    Provisioned a new VM on OCI – AMD E6 Flex, Oracle Linux Version 9 using Image Oracle-Linux-9.6-2025.09.16-0.

    Install the required rpms and create a directory for Oracle software install. Download the latest autoupgrade.jar file.

    # yum -y update
# yum -y install oracle-database-preinstall-19c
# yum -y install java-1.8.0-openjdk

# chown oracle:oinstall /u01

# su - oracle
$ cd /u01
$ mkdir autoupgrade
$ cd autoupgrade
$ wget https://download.oracle.com/otn-pub/otn_software/autoupgrade.jar

    For autoupgrade to download patches from My Oracle Support, it needs valid credentials.

    Used the following parameters, all may not be applicable to create the keystore, but it is the cfg file I will use to download and install the software. 

    global.global_log_dir=/u01/autoupgrade/logs
global.keystore=/u01/autoupgrade/keystore

install1.patch=RU,OPATCH,OJVM,DPBP
install1.folder=/u01/app/oracle/software
install1.target_home=/u01/app/oracle/product/dbhome_19
install1.home_settings.oracle_base=/u01/app/oracle
install1.home_settings.edition=EE
install1.home_settings.inventory_location=/u01/app/oraInventory
install1.target_version=19
install1.download=yes

    Create the keystore and save login credentials.

    [oracle@audbs01 autoupgrade]$ java -jar autoupgrade.jar -config newhome.cfg -patch -load_password
Processing config file ...

Starting AutoUpgrade Patching Password Loader - Type help for available options
Creating new AutoUpgrade Patching keystore - Password required
Enter password:
Enter password again:
AutoUpgrade Patching keystore was successfully created

MOS> add -user bXXXXXs@gXXXX.com
Enter your secret/Password:
Re-enter your secret/Password:
MOS>
MOS> exit
Save the AutoUpgrade Patching keystore before exiting [YES|NO] ? yes
Convert the AutoUpgrade Patching keystore to auto-login [YES|NO] ? yes

AutoUpgrade Patching Password Loader finished - Exiting AutoUpgrade Patching
[oracle@audbs01 autoupgrade]$

    Install 19c Software with latest RU

    Download the 19c RU and bundle patches. I did not specify the patch version or where to download the patches.

    install1.patch=RU,OPATCH,OJVM,DPBP
    install1.home_settings.edition=EE
    install1.target_version=19
    install1.download=yes

    Autoupgrade downloaded the latest RU.

    [oracle@audbs01 autoupgrade]$ java -jar autoupgrade.jar -config newhome.cfg -patch -mode download
AutoUpgrade Patching 25.6.251016 launched with default internal options
Processing config file ...
Loading AutoUpgrade Patching keystore
AutoUpgrade Patching keystore is loaded

Connected to MOS - Searching for specified patches

---------------------------------------------
Downloading files to /u01/app/oracle/software
---------------------------------------------
DATABASE RELEASE UPDATE 19.29.0.0.0
    File: p38291812_190000_Linux-x86-64.zip - VALIDATED

DATAPUMP BUNDLE PATCH 19.29.0.0.0
    File: p38535360_1929000DBRU_Generic.zip - VALIDATED

OJVM RELEASE UPDATE 19.29.0.0.0
    File: p38194382_190000_Linux-x86-64.zip - VALIDATED

OPatch 12.2.0.1.48 for DB 19.0.0.0.0 (Oct 2025)
    File: p6880880_190000_Linux-x86-64.zip - VALIDATED
---------------------------------------------

[oracle@audbs01 autoupgrade]$

    Since the patches are downloaded, I updated the target_home and download parameters in the cfg file.

    global.global_log_dir=/u01/autoupgrade/logs
global.keystore=/u01/autoupgrade/keystore

install1.patch=RU,OPATCH,OJVM,DPBP
install1.folder=/u01/app/oracle/software
install1.target_home=/u01/app/oracle/product/dbhome_1929
install1.home_settings.oracle_base=/u01/app/oracle
install1.home_settings.edition=EE
install1.home_settings.inventory_location=/u01/app/oraInventory
install1.target_version=19
install1.download=no

    Oracle 19c database base image download is not availblae through MOS. So I had to download the software to perform the install. Oracle 23ai (26ai) is different, where you do not have to download any base image.

    Let’s use autoupgrade to install the Oracle software and apply all the bundle patches. 

    [oracle@audbs01 autoupgrade]$ java -jar autoupgrade.jar -config newhome.cfg -patch -mode create_home                   
AutoUpgrade Patching 25.6.251016 launched with default internal options
Processing config file ...
Loading AutoUpgrade Patching keystore
AutoUpgrade Patching keystore is loaded
+-----------------------------------------+
| Starting AutoUpgrade Patching execution |
+-----------------------------------------+
Type 'help' to list console commands
patch>

patch> lsj -r
+----+-------------+-------+---------+-------+----------+-------+---------------------+
|Job#|      DB_NAME|  STAGE|OPERATION| STATUS|START_TIME|UPDATED|              MESSAGE|
+----+-------------+-------+---------+-------+----------+-------+---------------------+
| 100|create_home_1|EXTRACT|EXECUTING|RUNNING|  21:56:17|42s ago|Extracting gold image|
+----+-------------+-------+---------+-------+----------+-------+---------------------+
Total jobs 1

patch> logs
AutoUpgrade Patching logs folder [/u01/autoupgrade/logs/cfgtoollogs/patch/auto]
logs folder [create_home_1][/u01/autoupgrade/logs/create_home_1]

patch>
patch>
patch> lsj -r
+----+-------------+-------+---------+-------+----------+-----------+----------------------+
|Job#|      DB_NAME|  STAGE|OPERATION| STATUS|START_TIME|    UPDATED|               MESSAGE|
+----+-------------+-------+---------+-------+----------+-----------+----------------------+
| 100|create_home_1|INSTALL|EXECUTING|RUNNING|  21:56:17|!!!465s ago|Installing ORACLE_HOME|
+----+-------------+-------+---------+-------+----------+-----------+----------------------+
Total jobs 1

patch>

patch> Job 100 completed
------------------- Final Summary --------------------
Number of databases            [ 1 ]

Jobs finished                  [1]
Jobs failed                    [0]
Jobs restored                  [0]
Jobs pending                   [0]

# Run the root.sh script as root for the following jobs:
For create_home_1 -> /u01/app/oracle/product/dbhome_1929/root.sh

# Run the orainstRoot.sh script as root for the following jobs:
For create_home_1 -> /u01/app/oraInventory/orainstRoot.sh

Please check the summary report at:
/u01/autoupgrade/logs/cfgtoollogs/patch/auto/status/status.html
/u01/autoupgrade/logs/cfgtoollogs/patch/auto/status/status.log
[oracle@audbs01 autoupgrade]$

    I could have simply waited for the job to finish. But wanted to check what’s going on, hence you see the “lsj” and “logs” commands.

    Run the root scripts, and your Oracle home is ready. 

    [root@audbs01 opc]# /u01/app/oracle/product/dbhome_1929/root.sh
Check /u01/app/oracle/product/dbhome_1929/install/root_audbs01_2025-11-06_22-12-59-020743232.log for the output of root script

[root@audbs01 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@audbs01 opc]#

    I wanted to check the software install by creating a database, just for fun. Again, no GUI. 

    [oracle@audbs01 ~]$ export ORACLE_HOME=/u01/app/oracle/product/dbhome_1929
[oracle@audbs01 ~]$ export ORACLE_SID=AUCDB01
[oracle@audbs01 ~]$ export PATH=$ORACLE_HOME/bin:$PATH
[oracle@audbs01 ~]$ which dbca
/u01/app/oracle/product/dbhome_1929/bin/dbca
[oracle@audbs01 ~]$

[oracle@audbs01 autoupgrade]$ mkdir createdb
[oracle@audbs01 autoupgrade]$ cd createdb
[oracle@audbs01 createdb]$ cp /u01/app/oracle/product/dbhome_1929/assistants/dbca/dbca.rsp .
[oracle@audbs01 createdb]$ vi dbca.rsp

[oracle@audbs01 createdb]$ dbca -createDatabase -silent -responseFile ./dbca.rsp
Prepare for db operation
8% complete
Copying database files
31% complete
Creating and starting Oracle instance
32% complete
36% complete
40% complete
43% complete
46% complete
Completing Database Creation
51% complete
53% complete
54% complete
Creating Pluggable Databases
58% complete
63% complete
77% complete
Executing Post Configuration Actions
100% complete
Database creation complete. For details check the logfiles at:
 /u01/app/oracle/cfgtoollogs/dbca/AUCDB01.
Database Information:
Global Database Name:AUCDB01
System Identifier(SID):AUCDB01
Look at the log file "/u01/app/oracle/cfgtoollogs/dbca/AUCDB01/AUCDB01.log" for further details.
[oracle@audbs01 createdb]$

    Install Oracle AI Database 26ai Software

    So, 19c is all working well. How about the latest and greatest Oracle AI Database 26ai. Let’s try. 

    global.global_log_dir=/u01/autoupgrade/logs
global.keystore=/u01/autoupgrade/keystore

install1.patch=RU,OPATCH,DPBP
install1.folder=/u01/app/oracle/software
install1.target_home=/u01/app/oracle/product/dbhome_2326
install1.home_settings.oracle_base=/u01/app/oracle
install1.home_settings.edition=EE
install1.home_settings.inventory_location=/u01/app/oraInventory
install1.target_version=23
install1.download=yes

    The config file updated with target_version 23. Repeat the same steps as before. 

    [oracle@audbs01 autoupgrade]$ java -jar autoupgrade.jar -config newhome23.cfg -patch -mode download
AutoUpgrade Patching 25.6.251016 launched with default internal options
Processing config file ...
Loading AutoUpgrade Patching keystore
AutoUpgrade Patching keystore is loaded

Connected to MOS - Searching for specified patches

---------------------------------------------
Downloading files to /u01/app/oracle/software
---------------------------------------------
DATABASE RELEASE UPDATE 23.26.0.0.0
    File: p38411960_230000_Linux-x86-64.zip - VALIDATED

DATAPUMP BUNDLE PATCH 23.26.0.0.0
    File: p38504058_2326000DBRU_Generic.zip - VALIDATED

OPatch 12.2.0.1.48 for DB 23.0.0.0.0 (Oct 2025)
    File: p6880880_230000_Linux-x86-64.zip - VALIDATED
---------------------------------------------

[oracle@audbs01 autoupgrade]$ vi newhome23.cfg

    The 23.26 software RU and bundle patches are downloaded. The 23ai (or 26ai as it is known now) RU is full software image, there is no need to install a base image and apply RU on top. 

    [oracle@audbs01 autoupgrade]$ java -jar autoupgrade.jar -config newhome23.cfg -patch -mode create_home
AutoUpgrade Patching 25.6.251016 launched with default internal options
Processing config file ...
Loading AutoUpgrade Patching keystore
AutoUpgrade Patching keystore is loaded
+-----------------------------------------+
| Starting AutoUpgrade Patching execution |
+-----------------------------------------+
Type 'help' to list console commands
patch> lsj -r
+----+-------------+-------+---------+-------+----------+-------+---------------------+
|Job#|      DB_NAME|  STAGE|OPERATION| STATUS|START_TIME|UPDATED|              MESSAGE|
+----+-------------+-------+---------+-------+----------+-------+---------------------+
| 101|create_home_1|EXTRACT|EXECUTING|RUNNING|  23:25:11| 7s ago|Extracting gold image|
+----+-------------+-------+---------+-------+----------+-------+---------------------+
Total jobs 1

patch> lsj
+----+-------------+-------+---------+-------+----------+-------+----------------------+
|Job#|      DB_NAME|  STAGE|OPERATION| STATUS|START_TIME|UPDATED|               MESSAGE|
+----+-------------+-------+---------+-------+----------+-------+----------------------+
| 101|create_home_1|INSTALL|EXECUTING|RUNNING|  23:25:11|53s ago|Installing ORACLE_HOME|
+----+-------------+-------+---------+-------+----------+-------+----------------------+
Total jobs 1

patch> Job 101 completed
------------------- Final Summary --------------------
Number of databases            [ 1 ]

Jobs finished                  [1]
Jobs failed                    [0]
Jobs restored                  [0]
Jobs pending                   [0]

# Run the root.sh script as root for the following jobs:
For create_home_1 -> /u01/app/oracle/product/dbhome_2326/root.sh

Please check the summary report at:
/u01/autoupgrade/logs/cfgtoollogs/patch/auto/status/status.html
/u01/autoupgrade/logs/cfgtoollogs/patch/auto/status/status.log
[oracle@audbs01 autoupgrade]$

    That was much faster than the 19c install+RU. Since I ran the commands on OCI VM, the 26ai download and install worked. My understanding is that this will not work on premises Linux VM.

    Thanks to the AutoUpgrade team. No more searching for RU and Bundle patches. If your database server does not have access to internet, you can download the sofware on your Mac or Windows laptop using autoupgrade easily.

    On to next steps… Create an Oracle AI Database 26ai!