经过多年对oracle database on-premises 新版本的等待终于结束了，2026年1月27日起，Oracle AI Database 26ai Enterprise Edition for Linux x86-64现在可以在本地使用,将 Oracle 最新的人工智能原生创新直接引入客户数据中心, 这次发布不仅仅是一次版本更新——它是向智能、自我管理和对开发人员友好的数据平台的根本性转变。注入了人工智能和自动化，并且还在SQL、安全性、性能、可管理性和开发方面提供了大量增强。
Oracle尝新怎么少的了，下载安装测试走起…
今天开始
客户现在可以直接从 Oracle 软件交付云下载 Oracle AI 数据库 26ai(23.26.1 企业版):
👉 https://edelivery.oracle.com/ 或 AI DB 26ai(Linux x86-64)组件下载页面
安装测试Orale 26ai EE (单机)
该环境之前安装过oracle 23ai 对于OS 内核rpm、和参数配置省略。当然也可以安装preinstall package 简化安装
下载oracle-ai-database-preinstall-26ai-1.0–1.el9.x86_64.rpm
[root@db1 ~]# cat /etc/*relea*
Oracle Linux Server release 8.7
NAME="Oracle Linux Server"
VERSION="8.7"
ID="ol"
ID_LIKE="fedora"
VARIANT="Server"
VARIANT_ID="server"
VERSION_ID="8.7"
PLATFORM_ID="platform:el8"
PRETTY_NAME="Oracle Linux Server 8.7"
ANSI_COLOR="0;31"
CPE_NAME="cpe:/o:oracle:linux:8:7:server"
HOME_URL="https://linux.oracle.com/"
BUG_REPORT_URL="https://bugzilla.oracle.com/"
ORACLE_BUGZILLA_PRODUCT="Oracle Linux 8"
ORACLE_BUGZILLA_PRODUCT_VERSION=8.7
ORACLE_SUPPORT_PRODUCT="Oracle Linux"
ORACLE_SUPPORT_PRODUCT_VERSION=8.7
Red Hat Enterprise Linux release 8.7 (Ootpa)
Oracle Linux Server release 8.7
# create user
groupadd -g 54321 oinstall
groupadd -g 54322 dba
groupadd -g 54323 oper
groupadd -g 54324 backupdba
groupadd -g 54325 dgdba
groupadd -g 54326 kmdba
groupadd -g 54327 asmdba
groupadd -g 54328 asmoper
groupadd -g 54329 asmadmin
useradd -g oinstall -G dba,oper oracle
# create directory
mkdir -p /u01/app/oracle/product/26.0.0/dbhome_1/
mkdir -p /u01/app/oraInventory
chown -R oracle:oinstall /u01
chmod -R 775 /u01
# download and upload oracle install file. unzip it
[oracle@db1 ~]$ cd /u01/app/oracle/product/26.0.0/dbhome_1/
[oracle@db1 dbhome_1]$ ls
LINUX.X64_2326100_db_home.zip
unzip -q LINUX.X64_2326100_db_home.zip
静默安装软件
# install db software
[oracle@db1 ~]$ cd /u01/app/oracle/product/26.0.0/dbhome_1/
[oracle@db1 response]$cd install/response/
[oracle@db1 response]$ ls
db_install.rsp
[oracle@db1 response]$ cp db_install.rsp /home/oracle/orarsp/
[oracle@db1 orarsp]$ vi db_install.rsp
[oracle@db1 orarsp]$ cat db_install.rsp |grep -v '^#'|grep -v '^$'
oracle.install.responseFileVersion=/oracle/install/rspfmt_dbinstall_response_schema_v23.0.0
installOption=INSTALL_DB_SWONLY
UNIX_GROUP_NAME=anbob
INVENTORY_LOCATION=/u01/app/oraInventory
ORACLE_HOME=/u01/app/oracle/product/26.0.0/dbhome_1
ORACLE_BASE=/u01/app/oracle
installEdition=EE
OSDBA=dba
OSOPER=oper
OSBACKUPDBA=backupdba
OSDGDBA=dgdba
OSKMDBA=kmdba
OSRACDBA=racdba
[oracle@db1 dbhome_1]$ id oracle
uid=54323(oracle) gid=54321(oinstall) groups=54321(oinstall),54322(dba),54323(oper),54324(backupdba),54325(dgdba),54326(kmdba),54327(asmdba),54330(racdba)
[oracle@db1 dbhome_1]$ ./runInstaller -silent -responseFile /home/oracle/orarsp/db_install.rsp -ignorePrereq
Launching Oracle AI Database Setup Wizard...
[WARNING] [INS-13013] Target environment does not meet some mandatory requirements.
CAUSE: Some of the mandatory prerequisites are not met. See logs for details. /u01/app/oraInventory/logs/InstallActions2026-01-28_02-23-49PM/installActions2026-01-28_02-23-49PM.log.
ACTION: Identify the list of failed prerequisite checks from the log: /u01/app/oraInventory/logs/InstallActions2026-01-28_02-23-49PM/installActions2026-01-28_02-23-49PM.log. Then either from the log file or from installation manual find the appropriate configuration to meet the prerequisites and fix it manually.
The response file for this session can be found at:
/u01/app/oracle/product/26.0.0/dbhome_1/install/response/db_2026-01-28_02-23-49PM.rsp
You can find the log of this install session at:
/u01/app/oraInventory/logs/InstallActions2026-01-28_02-23-49PM/installActions2026-01-28_02-23-49PM.log
As a root user, run the following script(s):
1. /u01/app/oracle/product/26.0.0/dbhome_1/root.sh
Run /u01/app/oracle/product/26.0.0/dbhome_1/root.sh on the following nodes:
[db1]
Successfully Setup Software with warning(s).
[root@db1 ~]# /u01/app/oracle/product/26.0.0/dbhome_1/root.sh
Check /u01/app/oracle/product/26.0.0/dbhome_1/install/root_db1_2026-01-28_15-04-01-721623015.log for the output of root script
静默创建数据库
[root@db1 ~]# mkdir -p /oracle/oradata/datafile
[root@db1 ~]# mkdir -p /oracle/oradata/fast_recovery_area
[root@db1 ~]# chown -R oracle:oinstall /oracle
cd $ORACLE_HOME/bin
./dbca -silent -createDatabase \
-templateName General_Purpose.dbc \
-gdbname anbob.internal -sid anbob -responseFile NO_VALUE \
-characterSet AL32UTF8 \
-sysPassword OraWelcome1 \
-systemPassword OraWelcome2 \
-createAsContainerDatabase true \
-numberOfPDBs 3 \
-pdbName pdb1 \
-pdbAdminPassword OraWelcome3 \
-databaseType MULTIPURPOSE \
-automaticMemoryManagement false \
-totalMemory 3072 \
-storageType FS \
-datafileDestination /oracle/oradata/datafile \
-recoveryAreaDestination /oracle/oradata/fast_recovery_area \
-recoveryAreaSize 10000 \
-redoLogFileSize 200 \
-ignorePreReqs \
-enableArchive TRUE \
-useOMF true
WARNING] [DBT-06801] Specified Fast Recovery Area size (1,200 MB) is less than the recommended value.
CAUSE: Fast Recovery Area size should at least be three times the database size (4,355 MB).
ACTION: Specify Fast Recovery Area Size to be at least three times the database size.
Prepare for db operation
7% complete
Registering database with Oracle Grid Infrastructure
11% complete
Copying database files
33% complete
Creating and starting Oracle instance
35% complete
38% complete
41% complete
44% complete
48% complete
Completing Database Creation
53% complete
55% complete
56% complete
Creating Pluggable Databases
60% complete
64% complete
69% complete
78% complete
Executing Post Configuration Actions
100% complete
Database creation complete. For details check the logfiles at:
/u01/app/oracle/cfgtoollogs/dbca/anbob.
Database Information:
Global Database Name:anbob.internal
System Identifier(SID):anbob
Look at the log file "/u01/app/oracle/cfgtoollogs/dbca/anbob/anbob.log" for further details.配置环境变量
vi 26ai.env
# Oracle Settings
TMP=/tmp; export TMP
TMPDIR=$TMP; export TMPDIR
ORACLE_BASE=/u01/app/oracle ; export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/26.0.0/dbhome_1; export ORACLE_HOME
ORACLE_SID=anbob; export ORACLE_SID
PATH=$ORACLE_HOME/bin:$PATH; export PATH
LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib:$LD_LIBRARY_PATH; export LD_LIBRARY_PATH
CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATH
连接数据库
[oracle@db1 ANBOB]$ ps -ef|grep smon
oracle 554594 1 0 15:49 ? 00:00:00 ora_smon_anbob
[oracle@db1 ~]$ sqlplus / as sysdba
SQL*Plus: Release 23.26.1.0.0 - Production on Wed Jan 28 16:40:03 2026
Version 23.26.1.0.0
Copyright (c) 1982, 2025, Oracle. All rights reserved.
Connected to:
Oracle AI Database 26ai Enterprise Edition Release 23.26.1.0.0 - Production
Version 23.26.1.0.0
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 PDB11 READ WRITE NO
4 PDB12 READ WRITE NO
5 PDB13 READ WRITE NO
Oracle 26ai 新特性50+
1.Oracle AI Database 26ai — SQL Domain
2.Oracle AI Database 26ai — Wide Tables
3.Oracle AI Database 26ai — Dictionary Protection
4.Reducing Unified Audit Trail Size in Oracle AI Database 26ai
5.Oracle AI Database 26ai: Filtering Analytic Function Results with the QUALIFY Clause
6.Oracle AI Database 26ai: RESETTABLE Clause
7.Oracle AI Database 26ai: Bind Variable Support in Materialized View Query Rewrite
8.Oracle AI Database 26ai — Automatic Transaction Rollback (Priority Transactions with high, medium and low priority)
9.SQL Diagnostic Report(26ai, 19.28)
10.Oracle Database 26ai,19c — RMAN Progress Status Report
11.Oracle AI Database 26ai(23.9) — GROUP BY ALL
12.Oracle AI Database 26ai(23.9) — Introducing Non-Positional INSERT INTO SET Clause
13.26ai: Using IF [NOT] EXISTS Clause When Creating or Dropping an Object
14.Oracle 26ai — ConnStr Tool
15.Transport Tablespace over Network
16.Identifying Data Dictionary Inconsistencies with DBMS_DICTIONARY_CHECK
17.Oracle AI Database 26ai — error_message_details Parameter for Displaying Error Details
18.The INMEMORY(ALL) and NO INMEMORY(ALL) Clauses
19.Oracle 26ai — Applying Grid Infrastructure Patches via GUI(Zero-Downtime)
20.Oracle 26ai: Utilizing Memoptimized Rowstore Without Setting a Hint
21.Oracle 26ai — Storing Flashback Logs Outside FRA
22.Read-Only Session in Oracle 26ai
23.Shrinking Smallfile Tablespaces in Oracle 26ai(23.7)
24.DBMS_DEVELOPER.GET_METADATA in Oracle 26ai(23.7)
25.Sessionless Transactions in Database 26ai(23.6)
26.Data Redaction and View Enhancements — Oracle 26ai(23.6)
27.Staging Tables in Oracle 26ai
28.Oracle 26ai — Track Table and Partition Scan Access
29.Read-Only Oracle Home: Disabled by Default in Oracle 26ai
30.Oracle 26ai — Speed up IMPDP Using NOVALIDATE Constraints
31.Column Level Audit in Oracle AI Database 26ai
32.Schema Privileges in Oracle AI Database 26ai
33.Key Features No Longer Supported in Oracle AI Database 26ai
34.Oracle 26ai — Hybrid Read-Only Mode for Pluggable Databases
35.Oracle 26ai — Automatic SQL Transpiler Feature
36.Oracle 26ai — Control PDB Open Order
37.Boolean Data Type in Oracle AI Database 26ai
38.Convert LONG to LOB on import(26ai)
39.Oracle AI Database 26ai : Group By and Having using Column Aliases
40.Oracle AI Database 26ai — Read-Only User Feature
41.Annotations in Oracle AI Database 26ai
42.DB_DEVELOPER_ROLE Role in Oracle AI Database 26ai
43.Oracle AI DATABASE 26ai (23.7) — Materialized Expression Columns
44.In-Memory Advisor in Oracle AI DATABASE 26ai
45.Oracle AI Database 26ai Fast Ingest Enhancements
46.Blockchain and Immutable Tables Enhancements in Oracle AI Database 26ai
47.26ai — Analyzing Optimizer Environment Using DBA_HIST_OPTIMIZER_ENV_DETAILS
48.Oracle 26ai: Direct Joins for UPDATE and DELETE Statements
49.SQL Firewall in Oracle AI Database 26ai
50.Lock-free reservation in Oracle AI Database 26ai
51.SQL History in Oracle AI Database 26ai
52.Wide tables 4096 columns
WIde tables宽表测试
数据库知识需要持续的学习，因为总有一些上限被打破.
现在有些做分析类或对象属性多的模型，在23c之前的Oracle版本中，每个表的最大列数是1000。此限制适用于8i、9i、10g、11g、12c、18c和19c等版本。从Oracle AI Database 26ai开始，这一限制得到了显著扩展，允许每个表最多包含4096列。
和长字符串一样需要修改参数到extended。
SQL> alter system set max_columns=extended scope=spfile;
System altered.
SQL> startup force
ORACLE instance started.
SQL> alter table tb add c4096 number;
Table altered.
SQL> alter table tb add c4097 number;
alter table tb add c4097 number
*
ERROR at line 1:
ORA-01792: maximum number of columns in a table or view is 4096
Help: https://docs.oracle.com/error-help/db/ora-01792/
SQL> select count(*) from dba_tab_columns p where p.table_name='TB' and owner='SYS';
COUNT(*)
----------
4096ok. 后续有时间再测试其他新特性。
— over —