Database Release Notes
Database Release Notes
23ai
F47542-14
November 2024
Oracle Database Database Release Notes, 23ai
F47542-14
This software and related documentation are provided under a license agreement containing restrictions on use and
disclosure and are protected by intellectual property laws. Except as expressly permitted in your license agreement or
allowed by law, you may not use, copy, reproduce, translate, broadcast, modify, license, transmit, distribute, exhibit,
perform, publish, or display any part, in any form, or by any means. Reverse engineering, disassembly, or decompilation
of this software, unless required by law for interoperability, is prohibited.
The information contained herein is subject to change without notice and is not warranted to be error-free. If you find
any errors, please report them to us in writing.
If this is software, software documentation, data (as defined in the Federal Acquisition Regulation), or related
documentation that is delivered to the U.S. Government or anyone licensing it on behalf of the U.S. Government, then
the following notice is applicable:
U.S. GOVERNMENT END USERS: Oracle programs (including any operating system, integrated software, any
programs embedded, installed, or activated on delivered hardware, and modifications of such programs) and Oracle
computer documentation or other Oracle data delivered to or accessed by U.S. Government end users are "commercial
computer software," "commercial computer software documentation," or "limited rights data" pursuant to the applicable
Federal Acquisition Regulation and agency-specific supplemental regulations. As such, the use, reproduction,
duplication, release, display, disclosure, modification, preparation of derivative works, and/or adaptation of i) Oracle
programs (including any operating system, integrated software, any programs embedded, installed, or activated on
delivered hardware, and modifications of such programs), ii) Oracle computer documentation and/or iii) other Oracle
data, is subject to the rights and limitations specified in the license contained in the applicable contract. The terms
governing the U.S. Government's use of Oracle cloud services are defined by the applicable contract for such services.
No other rights are granted to the U.S. Government.
This software or hardware is developed for general use in a variety of information management applications. It is not
developed or intended for use in any inherently dangerous applications, including applications that may create a risk of
personal injury. If you use this software or hardware in dangerous applications, then you shall be responsible to take all
appropriate fail-safe, backup, redundancy, and other measures to ensure its safe use. Oracle Corporation and its
affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications.
Oracle®, Java, MySQL, and NetSuite are registered trademarks of Oracle and/or its affiliates. Other names may be
trademarks of their respective owners.
Intel and Intel Inside are trademarks or registered trademarks of Intel Corporation. All SPARC trademarks are used
under license and are trademarks or registered trademarks of SPARC International, Inc. AMD, Epyc, and the AMD logo
are trademarks or registered trademarks of Advanced Micro Devices. UNIX is a registered trademark of The Open
Group.
This software or hardware and documentation may provide access to or information about content, products, and
services from third parties. Oracle Corporation and its affiliates are not responsible for and expressly disclaim all
warranties of any kind with respect to third-party content, products, and services unless otherwise set forth in an
applicable agreement between you and Oracle. Oracle Corporation and its affiliates will not be responsible for any loss,
costs, or damages incurred due to your access to or use of third-party content, products, or services, except as set forth
in an applicable agreement between you and Oracle.
Contents
Preface
Audience v
Documentation Accessibility v
Related Resources v
Conventions v
iii
Bug 36326543 3-2
Bug 35517929 3-2
iv
Preface
This document describes last-minute features and changes that are not included in the Oracle
Database Documentation Library for Oracle Database 23ai.
• Audience
• Documentation Accessibility
• Related Resources
• Conventions
Audience
This document is relevant only to Oracle Database 23ai and documents new features,
changes, unsupported products, preinstallation requirements, generic and platform-specific
bug fixes, and known issues that are not included in the Oracle Database documentation
library.
Documentation Accessibility
For information about Oracle's commitment to accessibility, visit the Oracle Accessibility
Program website at http://www.oracle.com/pls/topic/lookup?ctx=acc&id=docacc.
Related Resources
Refer to the following documentation for more information related to this release:
• http://docs.oracle.com/en/database/database.html
• For licensing information, refer to Oracle Database Licensing Information User Manual.
• Additional readme or release notes files also exist. Refer to Other Readmes, Release
Notes, or Installation Guides.
Conventions
The following text conventions are used in this document:
v
Preface
Convention Meaning
boldface Boldface type indicates graphical user interface elements associated with an
action, or terms defined in text or the glossary.
italic Italic type indicates book titles, emphasis, or placeholder variables for which
you supply particular values.
monospace Monospace type indicates commands within a paragraph, URLs, code in
examples, text that appears on the screen, or text that you enter.
vi
1
Purpose of These Release Notes
More recent versions of some Oracle Database 23ai documentation may be available in either
HTML or PDF format.
Updates to this release note document can occur after it is released. Check for updates to this
document and view other Oracle documentation at:
http://docs.oracle.com/en/database/database.html
For licensing information, refer to Oracle Database Licensing Information User Manual.
Additional readme or release notes files also exist. Refer to the Other Readmes, Release
Notes, or Installation Guides.
1-1
2
Issues Affecting All Platforms for Oracle
Database 23ai
These topics contain last-minute features and changes that affect all platforms for Oracle
Database 23ai.
2-1
Chapter 2
Restrictions for Oracle AI Vector Search
2-2
Chapter 2
Restrictions for JavaScript Object Notation and JSON-Relational Duality Views
* IOTs
* Clusters or cluster tables
* Global temporary tables
* Blockchain tables
* Immutable tables
* Materialized views
– There is no support for the following:
* Vector index creation on non-vector columns (for example, VARCHAR, NUMBER, and
so on)
* Function-based vector index
* Alter index DDL for vector indexes
* Local partitioned vector indexes
* Online creation of vector indexes
– INMEMORY NEIGHBOR GRAPH restrictions include:
* DMLs are not supported on base tables that have an INMEMORY NEIGHBOR GRAPH
index.
• The latest python-oracledb, node-oracledb, JDBC, ODP.NET, and OCI drivers enable
native binds.
– All other SQL drivers need to use CLOBs or VARCHAR2 for binds and for vector
definitions.
– Oracle clients from release 19c and release 21c will see vectors as CLOBs.
• Integration with the following is not supported:
– Vector indexes with transportable tablespaces are not supported with Oracle Data
Pump.
– Oracle Database Advanced Queuing
– Oracle Database Gateways
• A maximum of 65535 dimensions is supported.
• Data redaction is not supported for the VECTOR data type. Specifically, you cannot:
– Add a data redaction policy on a vector column.
– Alter a table to modify a column to the VECTOR data type if the column has a redaction
policy defined on it.
2-3
Chapter 2
Restrictions for JavaScript Object Notation and JSON-Relational Duality Views
2-4
Chapter 2
Property Graph Features That Work With Oracle Database 23ai
• Because JSON-relational duality views rely on JSON type, a 19c or earlier SQL*Plus client
cannot be used for queries, DML or other SQL operations that use the DATA column which
is of data type JSON.
• Duality views cannot be created on base tables with textual JSON columns (VC2/CLOB/
BLOB with IS-JSON constraint) in the base table.
• The same subquery cannot be used multiple times to define nested JSON structures
(object or array) in the same parent object.
• Fine-grained auditing policies are not supported with duality views.
• DML error logging is not supported with duality views.
2-5
Chapter 2
Open Bugs Affecting All Platforms
• Bug 36843400
Bug 36843400
UTL_TO_SUMMARY in AI Vector Search is broken for OCI Generative AI in Oracle Database
release 23.6 DB and ADB since the command.cohere model and /summarizeText endpoint
have been retired.
Workaround
The workaround is to either call UTL_TO_GENERATE_TEXT with a prompt to summarize such as
"Generate a summary for the following: ..." or to use a different provider.
• Bug 36934985
Bug 36934985
When using callable statements with result set cache, the driver returns the same results (the
first results to be cached) for different bind data.
Workaround
If possible, use prepared statements instead of callable statements. Otherwise, disable result
set cache for the query.
2-6
Chapter 2
Open Bugs Affecting All Platforms
• Bug 36953348
Bug 36953348
When the statics gathering query involves an expression (for example, INSERT INTO TARGET
SELECT VECTOR_EMBEDDING FROM src), the expression, VECTOR_EMBEDDING in this example, is
evaluated once to gather statistics on the value and then again when the value is populated
into the target. If the expression is expensive, the repetitive expression evaluation can incur
heavy overhead.
Workaround
If you are experiencing reduced performance while loading data in Oracle Database 23ai
release 23.6, try adding the following SQL hint:
/*+ No_gather_optimizer_statistics */
• Bug 37169626
Bug 37169626
During upgrade, when modifying the types of SQL Monitor type hierarchy, the dictionary tables
for inheritance can get corrupted. This affects some of the types and the data of the related
tables (for example, WRI$_REPT_COMPONENTS). This results in error ORA-30625: method
dispatch on NULL SELF argument is disallowed when SQL Monitor APIs are invoked.
Workaround
Install the fix for this bug 37169626 prior to database upgrade. If upgrade is run without this fix,
run the script fix_sql_monitor_metadata.sql as the SYS user in each upgraded container.
2-7
3
Issues Affecting Linux for Oracle Database
23ai
These topics contain last-minute features and changes for Linux for Oracle Database 23ai.
• Unsupported Products for Oracle Database 23ai
This topic describes products or features that are unavailable for Oracle Database 23ai.
• Product Support
This topic describes the supported products or features for Oracle Database 23ai.
• Known Issues and Bugs for Oracle Linux 8 and Red Hat Enterprise Linux 8
This section contains information about issues related to Oracle Linux 8 and Red Hat
Enterprise Linux 8:
• Open Bugs Affecting Linux
This topic contains last-minute features and changes for Oracle Database 23ai.
Product Support
This topic describes the supported products or features for Oracle Database 23ai.
• For Oracle Database 23ai on Oracle Linux 9 Red Hat Compatible Kernel (RHCK), Oracle
ASMLIB V3 is supported on kernel version 5.14.0-362.8.1.el9_3 or later only.
Known Issues and Bugs for Oracle Linux 8 and Red Hat
Enterprise Linux 8
This section contains information about issues related to Oracle Linux 8 and Red Hat
Enterprise Linux 8:
• Bug 36756459
3-1
Chapter 3
Open Bugs Affecting Linux
Bug 36756459
If you use Oracle Database Configuration Assistant (DBCA) with Oracle Data Guard to carry
out a database move operation, then you must move the Data Guard Broker configuration files
before starting your database move operation.
The default location for the DB_BROKER_CONFIG files is in the dbs directory in the earlier release
Oracle Database Oracle home. When you use a database move operation to carry out a
database move of database instances using Oracle Data Guard, you must move the
DG_BROKER_CONFIG files to a mount point location outside of the earlier release Oracle home.
Also ensure that the DG_BROKER_CONFIG_FILE parameters specify that location, instead of a
location in the Oracle home.
Tasks Before Starting Your Database Move Operation using Oracle DBCA
To enable access to the DB_BROKER_CONFIG files during a rolling upgrade, you must complete
the following tasks before starting the database move operation.
1. Before you start the database move operation, set the Oracle Data Guard files
DG_BROKER_CONFIG_FILE1 and DG_BROKER_CONFIG_FILE2 to a separate mount point on your
server that is outside of the Oracle home path for either the source or target Oracle
Database Oracle homes.
2. Complete a successful database move operation of your earlier release Oracle home to
the new Oracle Database release.
Bug 36326543
On Oracle Linux 9.2, the listener fails to start due to issues with getaddrinfo() if the /etc/
hosts has an entry in the order IPv4 and IPv6 addresses when the same host name and
listener are configured with IPv6 address and ip=v6_only.
Workaround
Change the order of the address in the /etc/hosts entry with IPv6 first and then IPv4.
Bug 35517929
Static linking demos fail during compilation on Oracle Database 23ai on Oracle Linux 9 and
Red Hat Enterprise Linux 9.
Workaround:
Oracle Database 23ai supports only Dynamic linking demos on Oracle Linux 9 and Red Hat
Enterprise Linux 9.
3-2
4
Issues Affecting Microsoft Windows for Oracle
Database 23ai
These topics contain last-minute features and changes for Microsoft Windows for Oracle
Database 23ai and Oracle Instant Client 23ai.
• Known Issues and Bugs Affecting Oracle Instant Client 23ai for Microsoft Windows
The following section contains information about a known issue affecting Oracle Instant
Client 23ai for Microsoft Windows.
Known Issues and Bugs Affecting Oracle Instant Client 23ai for
Microsoft Windows
The following section contains information about a known issue affecting Oracle Instant Client
23ai for Microsoft Windows.
• Unzip Issue with Windows Oracle Instant Client Package
Workaround
Do not use unzip -t. Use unzip <windows_pkg_name> instead.
4-1
5
Issues Affecting Microsoft Windows for Oracle
Database 23ai Free
These topics contain last-minute features and changes for Microsoft Windows for Oracle
Database 23ai Free.
• Known Issues and Bugs Affecting Oracle Database 23ai Free for Microsoft Windows
The following section contains information about a known issue affecting Oracle Database
23ai Free for Microsoft Windows.
Known Issues and Bugs Affecting Oracle Database 23ai Free for
Microsoft Windows
The following section contains information about a known issue affecting Oracle Database 23ai
Free for Microsoft Windows.
• Bug 35706665
Bug 35706665
Upgrading from Oracle Database 21c XE to Oracle Database 23ai Free may detect one or
more invalid objects.
Workaround
Ignore these invalid objects and proceed with the upgrade.
5-1
6
Issues Affecting Oracle Instant Client 23ai for
macOS (ARM64)
This topic contains last-minute features and changes for Oracle Instant Client 23ai for macOS
(ARM64).
• Unsupported Features and Components
The following features or components are not supported on Apple macOS (ARM64):
• Known Issues and Bugs Affecting Oracle Instant Client 23ai for macOS (ARM64)
The following section contains information about a known issue affecting Oracle Instant
Client 23ai for Apple macOS (ARM64).
Known Issues and Bugs Affecting Oracle Instant Client 23ai for
macOS (ARM64)
The following section contains information about a known issue affecting Oracle Instant Client
23ai for Apple macOS (ARM64).
• Advanced Queuing Operations Error
Workaround
Add the en0 inet IP address and host name to the /etc/hosts file: IP_address host_name.
You can obtain the en0 inet IP address by running the ipconfig getifaddr en0 command in
the terminal.
You can obtain the host name by running the hostname -f command in the terminal.
6-1