The update process is the following:
Oracle Database 19c ==> Upgrade to Oracle AI Database 26aiOracle Database 21c ==> Upgrade to Oracle AI Database 26ai
Oracle Database 23ai ==> Apply the October RU to get to Oracle AI Database 26ai
If you are on 19c or 21c, you can upgrade directly to 26ai – there is no need to upgrade to 23ai first.
If you are running on 23ai on Oracle’s Autonomous Database there is nothing for you to do! Your 23ai Autonomous Databases will be automatically updated to 26ai Autonomous AI Databases.
也就是说19c 可以直接升级到 26ai，不需要先升级到23ai或者21c。
咱们看下 Autonomous Database 19c 升级到 26ai Autonomous AI Databases的步骤（以上一篇的升级时间为 2025/10/20 14:30），可以通过 查看：
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 select * from DBA_REGISTRY_LOG; 20-10月-25 02.30.48.019436000 下午 GMT SERVER UPGRD_BGN START 20-10月-25 02.34.33.659022000 下午 GMT SERVER CATPROC LOADED 23.10.0.25.10 20-10月-25 02.35.01.999418000 下午 GMT SERVER RDBMS UPGRADED 23.10.0.25.10 20-10月-25 02.35.02.001488000 下午 GMT SERVER CMPUPGRD_BGN START 20-10月-25 02.35.02.165803000 下午 GMT SERVER OLS START 19.29.0.1.0 20-10月-25 02.35.05.378543000 下午 GMT SERVER OLS UPGRADED 23.10.0.25.10 20-10月-25 02.35.05.380656000 下午 GMT SERVER DV START 19.29.0.1.0 20-10月-25 02.35.12.050783000 下午 GMT SERVER DV UPGRADED 23.10.0.25.10 20-10月-25 02.35.12.053027000 下午 GMT SERVER CONTEXT START 19.29.0.1.0 20-10月-25 02.35.22.986098000 下午 GMT SERVER CONTEXT UPGRADED 23.10.0.25.10 20-10月-25 02.35.23.020698000 下午 GMT SERVER RAC START 19.29.0.1.0 20-10月-25 02.35.23.187244000 下午 GMT SERVER RAC UPGRADED 23.10.0.25.10 20-10月-25 02.35.23.993645000 下午 GMT SERVER SDO START 19.29.0.1.0 20-10月-25 02.36.15.610077000 下午 GMT SERVER SDO UPGRADED 23.10.0.25.10 20-10月-25 02.36.16.338758000 下午 GMT SERVER CMPUPGRD_END START 20-10月-25 02.36.16.340839000 下午 GMT SERVER ACTIONS_BGN START 20-10月-25 02.36.17.783803000 下午 GMT SERVER CATUPBOOT_BGN START 20-10月-25 02.36.24.233897000 下午 GMT SERVER CATUPBOOT_ENDED START 20-10月-25 02.36.24.249469000 下午 GMT SERVER DBRESTARTED START 20-10月-25 02.36.24.251581000 下午 GMT SERVER ACTIONS_END START 20-10月-25 02.36.24.253752000 下午 GMT SERVER FINALACTION START 20-10月-25 02.36.24.255800000 下午 GMT SERVER POSTUP_BGN START 20-10月-25 02.36.24.257856000 下午 GMT SERVER CATREQ_BGN START 20-10月-25 02.36.39.052457000 下午 GMT SERVER CATREQ_END START 20-10月-25 02.36.39.495909000 下午 GMT SERVER POSTUP_END START 20-10月-25 02.36.39.497794000 下午 GMT SERVER UPGRD_END START
可以看到 UPGRD_BGN 20-10月-25 02.30.48.019436000 下午，UPGRD_END at 20-10月-25 02.36.39.497794000 下午。
查看视图：DBA_REGISTRY_HISTORY
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 SQL> SELECT ACTION_TIME, ACTION,VERSION, ID, COMMENTS FROM DBA_REGISTRY_HISTORY ORDER BY ACTION_TIME DESC; ACTION_TIME ACTION VERSION ID COMMENTS ------------------------ ----------- -------------------- --------------- ---------- ------------------------------------------------------------------------------------------ BOOTSTRAP 19 RDBMS_PT.DBCLOUD19_LINUX.X64_200128 20-OCT-25 02.36.24.245184 PM UPGRADE 23.0.0.0.0 Upgraded from 19.29.0.1.0 to 23.10.0.25.10 18-OCT-25 03.01.21.902269 AM RU_APPLY 19.0.0.0.0 Patch applied on 19.29.0.1.0: Release_Update - 250924212059 27-SEP-25 03.01.52.603697 AM RU_APPLY 19.0.0.0.0 Patch applied from 19.28.0.1.0 to 19.29.0.1.0: Release_Update - 250911024431 13-SEP-25 04.06.13.253089 AM RU_APPLY 19.0.0.0.0 Patch applied on 19.28.0.1.0: Release_Update - 250824031914 30-AUG-25 03.01.39.053799 AM RU_APPLY 19.0.0.0.0 Patch applied on 19.28.0.1.0: Release_Update - 250730150606 02-AUG-25 03.01.50.384836 AM RU_APPLY 19.0.0.0.0 Patch applied on 19.28.0.1.0: Release_Update - 250718002749 19-JUL-25 03.01.30.455131 AM RU_APPLY 19.0.0.0.0 Patch applied on 19.28.0.1.0: Release_Update - 250702134716 05-JUL-25 03.04.41.863909 AM RU_APPLY 19.0.0.0.0 Patch applied from 19.27.0.1.0 to 19.28.0.1.0: Release_Update - 250618140203 07-JUN-25 04.02.49.589765 AM RU_APPLY 19.0.0.0.0 Patch applied on 19.27.0.1.0: Release_Update - 250515190146 17-MAY-25 04.03.57.106732 AM RU_APPLY 19.0.0.0.0 Patch applied on 19.27.0.1.0: Release_Update - 250430134659 03-MAY-25 04.01.28.289490 AM RU_APPLY 19.0.0.0.0 Patch applied on 19.27.0.1.0: Release_Update - 250416135012 19-APR-25 04.01.20.530942 AM RU_APPLY 19.0.0.0.0 Patch applied on 19.27.0.1.0: Release_Update - 250402145204 05-APR-25 04.01.17.636250 AM RU_APPLY 19.0.0.0.0 Patch applied on 19.27.0.1.0: Release_Update - 250319213254 22-MAR-25 04.01.25.889528 AM RU_APPLY 19.0.0.0.0 Patch applied from 19.26.0.1.0 to 19.27.0.1.0: Release_Update - 250307073415 省略*** 144rows
在看一下 23ai Autonomous Databases will be automatically updated to 26ai Autonomous AI Databases.
23ai Autonomous Databases automatically updated to 26ai 的步骤：
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 SQL> SELECT ACTION_TIME, ACTION, VERSION, ID, COMMENTS FROM DBA_REGISTRY_HISTORY ORDER BY ACTION_TIME DESC; ACTION_TIME ACTION VERSION ID COMMENTS ------------------------------ -------------------- --------------- ---------- ------------------------------------------------------------------------------------------ BOOTSTRAP 23 RDBMS_23.0.0.0.0_LINUX.X64_240419 BOOTSTRAP 23 ca1d019aff30b2db3fdfd55985a5968e|AC94252451E296090CF0DA55B54EDD60 BOOTSTRAP 23 395f6924a8636b0c79d567b200887def|EC8FDCD4372C30FB3659559AD3155574 BOOTSTRAP 23 cc33d7b58f7f4efa82f56bcd4e4cc655|CFE1C0F9D24EFBEAA05917AD4A3957B9 BOOTSTRAP 23 e0b85a0176a706b50918f5ba985f7bde|40E31CE3CE567D947FFFBE286C3BA439 08-MAR-25 05.08.57.399937 AM RU_APPLY 23.0.0.0.0 Patch applied from 23.6.0.24.11 to 23.7.0.25.03: Release_Update - 250128190917 23-NOV-24 06.18.22.937051 AM RU_APPLY 23.0.0.0.0 Patch applied from 23.6.0.24.10 to 23.6.0.24.11: Release_Update - 241024201430 19-OCT-24 05.06.23.021402 AM RU_APPLY 23.0.0.0.0 Patch applied from 23.6.0.24.07 to 23.6.0.24.10: Release_Update - 240903213120 10-AUG-24 02.42.21.803104 PM RU_APPLY 23.0.0.0.0 Patch applied from 23.5.0.24.06 to 23.6.0.24.07: Release_Update - 240709031703 27-JUN-24 02.00.50.183553 AM RU_APPLY 23.0.0.0.0 Patch applied from 23.5.0.24.05 to 23.5.0.24.06: Release_Update - 240613142504 12-JUN-24 08.55.42.625509 PM RU_APPLY 23.0.0.0.0 Patch applied from 23.4.0.24.05 to 23.5.0.24.05: Release_Update - 240520170829 22-MAY-24 05.16.20.991398 AM RU_APPLY 23.0.0.0.0 Patch applied on 23.4.0.24.05: Release_Update - 240419165507 16-APR-24 02.30.31.479974 AM RU_APPLY 23.0.0.0.0 Patch applied on 23.4.0.24.05: Release_Update - 240408092909 13 rows selected.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 SQL> SELECT PATCH_ID,PATCH_TYPE,STATUS,action,SOURCE_VERSION,TARGET_VERSION,ACTION_TIME FROM dba_registry_sqlpatch; PATCH_ID STATUS ACTION SOURCE_VERSION TARGET_VERSION ACTION_TIME ----------- ---------- -------------------- ------------------------------ ------------------------------ ------------------------------ 36735301 SUCCESS APPLY 23.5.0.24.05 23.5.0.24.06 27-JUN-24 02.00.50.159723 AM 36821795 SUCCESS APPLY 23.5.0.24.06 23.6.0.24.07 10-AUG-24 02.42.21.773492 PM 36655885 SUCCESS APPLY 23.4.0.24.05 23.5.0.24.05 12-JUN-24 08.55.42.597226 PM 37025549 SUCCESS APPLY 23.6.0.24.07 23.6.0.24.10 19-OCT-24 05.06.22.957417 AM 37228708 SUCCESS APPLY 23.6.0.24.10 23.6.0.24.11 23-NOV-24 06.18.22.891574 AM 37385169 SUCCESS APPLY 23.6.0.24.11 23.7.0.25.02 18-JAN-25 05.06.43.157786 AM 37540109 SUCCESS APPLY 23.7.0.25.02 23.7.0.25.03 08-MAR-25 05.08.57.378627 AM 37710995 SUCCESS APPLY 23.7.0.25.03 23.8.0.25.05 19-APR-25 05.08.20.539469 AM 37858811 SUCCESS APPLY 23.8.0.25.05 23.8.0.25.06 07-JUN-25 05.08.33.065490 AM 38065631 SUCCESS APPLY 23.8.0.25.06 23.9.0.25.08 19-JUL-25 03.08.15.237685 AM 38361783 SUCCESS APPLY 23.9.0.25.08 23.10.0.25.10 27-SEP-25 03.07.31.868577 AM 11 rows selected.
需要通过 dba_registry_sqlpatch 查看 最为直观，因为他是通过直接apply的ru。但是 19c升级到 26ai，通过 dba_registry_sqlpatch视图查看是没有结果的。
参考资料：https://mikedietrichde.com/2025/10/14/oracle-ai-database-26ai-replaces-oracle-database-23ai/
原文作者:
liups.com
原文链接:
http://liups.com/posts/64d6fc0/
许可协议: 知识共享署名-非商业性使用 4.0 国际许可协议
