经过多年对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
|
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 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 |
[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 |
静默安装软件
|
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 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 |
# 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 |
静默创建数据库
|
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 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 |
[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. |
配置环境变量
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 |
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 |
连接数据库
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 |
[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: <strong><mark class="has-inline-color has-global-color-8-color">Oracle AI Database 26ai Enterprise Edition Release 23.26.1.0.0</mark></strong> - 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。
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 |
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(*) ---------- 4096 |
ok. 后续有时间再测试其他新特性。
— over —