Oracle 23ai BaseDB 23.6 to 23.7 Tips
Oracle 23ai 23.7
README
This patch is applicable to 23ai Cloud Services, Exadata, Oracle Database Appliance (ODA) Engineered Systems, Private Cloud Appliance (PCA), and Compute Cloud@Customer (C3) only.
Patch numbers came from here:
Oracle Support Document 3053981.1 (Oracle Database 23ai Proactive Patch Information)
Oracle BaseDB 23.6
Oracle Database 23ai Release Updates
Release Date
23.7.0.25.01 - Mon, Feb 3, 2025, 14:05:13 UTC
Manual Update in BaseDB
Precheck
Apply
Updating from 23.6.0.24.10 to 23.7.0.25.01
It takes around 20 mins with the following env.
- VM.Standard.E4.Flex 4 OCPU / 64 GB Memory / 4 Gbps Network / 64K IOPS
dba_objects in Oracle 23ai 23.7
[oracle@db23ai01 ~]$ sql / as sysdba
SQLcl: Release 24.3 Production on Wed Feb 12 11:26:32 2025
Copyright (c) 1982, 2025, Oracle. All rights reserved.
Connected to:
Oracle Database 23ai EE High Perf Release 23.0.0.0.0 - for Oracle Cloud and Engineered Systems
Version 23.7.0.25.01
SQL>
SQL> select status,count(*) from dba_objects group by status;
STATUS COUNT(*)
_________ ___________
VALID 70984
SQL>
Referece
Oracle Database 23ai Release Updates
Have a good work&life! 2025/02 via LinHong