If you use the Spatial Data Option or Oracle Text in your Oracle AI Database, you should add the dedicated bundle patches to your Oracle home.
In AutoUpgrade, you can use the keywords SDOBP (Spatial) and TEXT (Oracle Text) to download and add the patches to your Oracle home. Here’s an example:
global.global_log_dir=/home/oracle/autoupgrade-patching/log
global.keystore=/home/oracle/autoupgrade-patching/keystore
global.folder=/home/oracle/autoupgrade/patches
patch1.target_version=19
patch1.platform=LINUX.X64
patch1.patch=RECOMMENDED,SDOBP,TEXT
I start AutoUpgrade in download mode:
java -jar autoupgrade.jar -config download.cfg -mode download -patch
AutoUpgrade determines that 19.30 is the latest Release Update and finds the appropriate bundle patches:
Connected to MOS - Searching for specified patches
-----------------------------------------------------
Downloading files to /home/oracle/autoupgrade/patches
-----------------------------------------------------
DATABASE RELEASE UPDATE 19.30.0.0.0(REL-JAN260130)
File: p38632161_190000_Linux-x86-64.zip - LOCATED
...
SPATIAL BUNDLE PATCH #1 ON DBRU 19.30.0.0.0
File: p38794194_1930000DBRU_Linux-x86-64.zip - LOCATED
MERGE OF 19.30 ORACLE TEXT RAC + NON-RAC MLRS
File: p38910143_1930000DBRU_Linux-x86-64.zip - LOCATED
-----------------------------------------------------
Simple and easy!
Missing Bundle Patches
At the time of writing, there are no Spatial or Oracle Text bundle patches for Oracle AI Database 26ai. AutoUpgrade reports:
Connected to MOS - Searching for specified patches
There were conditions found preventing AutoUpgrade Patching from successfully running
*Downloading files
Cannot find the Oracle Text patch
Cannot find the Oracle Spatial (SDO) patch
All necessary patches for Spatial and Oracle Text in Oracle AI Database 26ai are included in the latest Release Update.
This might change over time, and we may start to see bundle patches again.
Oracle Text
Fixes for Oracle Text are included in Release Updates whenever possible.
The Oracle Text bundle patch contains:
- Patches that haven’t made it into a Release Update yet.
- Patches that aren’t RAC Rolling installable.
Over time, you may see patches disappear from the bundle patch as they become part of the Release Update.
The Oracle Text bundle patch is also recommended for users of JSON and XML search indexes.
Databases Are Fun 