Oracle Linux 8下安装Oracle AI Database 26ai

来源:这里教程网 时间:2026-03-03 23:26:26 作者:

环境说明操作系统: Oracle Linux 8 (x86-64)Database: Oracle AI Database 26ai -Single InstanceInstall Type: Software Only建库方式:DBCA创建CDB和PDB

一、安装操作系统

在这里插入图片描述 在这里插入图片描述 在这里插入图片描述 在这里插入图片描述 在这里插入图片描述 二、环境配置 1、配置本地yum源

[root@26aidb01 etc]# cd /etc
[root@26aidb01 etc]# mv yum.repos.d/ yum.repos.d_bak
[root@26aidb01 etc]# mkdir yum.repos.d
[root@26aidb01 etc]# vi yum.repos.d/local.repo
[local]
name=Local Repository
baseurl=file:///mnt/BaseOS
enabled=1
gpgcheck=0
[local-AppStream]
name=Local Repository
baseurl=file:///mnt/AppStream
enabled=1
gpgcheck=0
[root@26aidb01 etc]# mount /dev/cdrom /mnt

2、安装oracle-database-preinstall包

[root@26aidb01 etc]# yum install -y oracle-database-preinstall*
Last metadata expiration check: 0:05:14 ago on Thu 29 Jan 2026 01:23:29 AM EST.
Dependencies resolved.
=======================================================================================================================================================
 Package                                      Architecture         Version                                         Repository                     Size
=======================================================================================================================================================
Installing:
 oracle-database-preinstall-21c               x86_64               1.0-1.el8                                       local-AppStream                30 k
Installing dependencies:
 compat-openssl10                             x86_64               1:1.0.2o-4.el8_6                                local-AppStream               1.1 M
 glibc-devel                                  x86_64               2.28-251.0.2.el8                                local                          89 k
 ksh                                          x86_64               20120801-267.0.1.el8                            local-AppStream               923 k
 libnsl                                       x86_64               2.28-251.0.2.el8                                local                         111 k
 libxcrypt-devel                              x86_64               4.1.1-6.el8                                     local                          25 k
 lm_sensors-libs                              x86_64               3.4.0-23.20180522git70f7e08.el8                 local                          59 k
 make                                         x86_64               1:4.2.1-11.el8                                  local                         498 k
 sysstat                                      x86_64               11.7.3-12.0.1.el8                               local-AppStream               426 k
Transaction Summary
=======================================================================================================================================================
Install  9 Packages
Total size: 3.2 M
Installed size: 9.4 M
Downloading Packages:
Running transaction check
Transaction check succeeded.
Running transaction test
Transaction test succeeded.
Running transaction
  Preparing        :                                                                                                                               1/1
  Installing       : libxcrypt-devel-4.1.1-6.el8.x86_64                                                                                            1/9
  Installing       : glibc-devel-2.28-251.0.2.el8.x86_64                                                                                           2/9
  Running scriptlet: glibc-devel-2.28-251.0.2.el8.x86_64                                                                                           2/9
  Installing       : make-1:4.2.1-11.el8.x86_64                                                                                                    3/9
  Running scriptlet: make-1:4.2.1-11.el8.x86_64                                                                                                    3/9
  Installing       : compat-openssl10-1:1.0.2o-4.el8_6.x86_64                                                                                      4/9
  Running scriptlet: compat-openssl10-1:1.0.2o-4.el8_6.x86_64                                                                                      4/9
  Installing       : ksh-20120801-267.0.1.el8.x86_64                                                                                               5/9
  Running scriptlet: ksh-20120801-267.0.1.el8.x86_64                                                                                               5/9
  Installing       : lm_sensors-libs-3.4.0-23.20180522git70f7e08.el8.x86_64                                                                        6/9
  Running scriptlet: lm_sensors-libs-3.4.0-23.20180522git70f7e08.el8.x86_64                                                                        6/9
  Installing       : sysstat-11.7.3-12.0.1.el8.x86_64                                                                                              7/9
  Running scriptlet: sysstat-11.7.3-12.0.1.el8.x86_64                                                                                              7/9
  Installing       : libnsl-2.28-251.0.2.el8.x86_64                                                                                                8/9
  Installing       : oracle-database-preinstall-21c-1.0-1.el8.x86_64                                                                               9/9
  Running scriptlet: oracle-database-preinstall-21c-1.0-1.el8.x86_64                                                                               9/9
  Verifying        : glibc-devel-2.28-251.0.2.el8.x86_64                                                                                           1/9
  Verifying        : libnsl-2.28-251.0.2.el8.x86_64                                                                                                2/9
  Verifying        : libxcrypt-devel-4.1.1-6.el8.x86_64                                                                                            3/9
  Verifying        : lm_sensors-libs-3.4.0-23.20180522git70f7e08.el8.x86_64                                                                        4/9
  Verifying        : make-1:4.2.1-11.el8.x86_64                                                                                                    5/9
  Verifying        : compat-openssl10-1:1.0.2o-4.el8_6.x86_64                                                                                      6/9
  Verifying        : ksh-20120801-267.0.1.el8.x86_64                                                                                               7/9
  Verifying        : oracle-database-preinstall-21c-1.0-1.el8.x86_64                                                                               8/9
  Verifying        : sysstat-11.7.3-12.0.1.el8.x86_64                                                                                              9/9
Installed:
  compat-openssl10-1:1.0.2o-4.el8_6.x86_64   glibc-devel-2.28-251.0.2.el8.x86_64               ksh-20120801-267.0.1.el8.x86_64
  libnsl-2.28-251.0.2.el8.x86_64             libxcrypt-devel-4.1.1-6.el8.x86_64                lm_sensors-libs-3.4.0-23.20180522git70f7e08.el8.x86_64
  make-1:4.2.1-11.el8.x86_64                 oracle-database-preinstall-21c-1.0-1.el8.x86_64   sysstat-11.7.3-12.0.1.el8.x86_64
Complete!
[root@26aidb01 etc]#
安装成功后oracle用户已创建成功,安装Oracle所需要的依赖包也已安装。
[root@26aidb01 etc]# id oracle
uid=54321(oracle) gid=54321(oinstall) groups=54321(oinstall),54322(dba),54323(oper),54324(backupdba),54325(dgdba),54326(kmdba),54330(racdba)
[root@26aidb01 etc]#
3、创建目录并修改权限和属组
[root@26aidb01 ]#mkdir -p /u01/app/oracle/product/26.23.1/db_1
[root@26aidb01 ]#chown -R oracle:oinstall /u01/app/oracle
[root@26aidb01 ]#chmod -R 775 /u01/ 
4、配置环境变量
export PATH
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=/u01/app/oracle/product/26.23.1/db_1
export JAVA_HOME=/u01/app/oracle/product/26.23.1/db_1/OPatch/jre
export PATH=$PATH:$JAVA_HOME/bin:$ORACLE_HOME/bin:$ORACLE_HOME/OPatch
export CLASSPATH=.:$JAVA_HOME/lib/dt.jar:$JAVA_HOME/lib/tools.jar
umask 022
export ORACLE_SID=26aidb
stty erase ^H

三、安装Oracle AI db 26ai软件

使用oracle用户在$ORACLE_HOME下执行

[oracle@26aidb01 ~]$ cd $ORACLE_HOME
[oracle@26aidb01 db_1]$ ./runInstaller

在这里插入图片描述

选择Softwar Only 在这里插入图片描述 在这里插入图片描述 在这里插入图片描述 在这里插入图片描述

在这里插入图片描述 在这里插入图片描述 在这里插入图片描述 在这里插入图片描述 在这里插入图片描述 以root用户执行上面界面中的2个脚本 在这里插入图片描述 脚本执行完成。

在这里插入图片描述 软件成功安装。 四、DBCA创建数据库 1、创建CDB

在这里插入图片描述

在这里插入图片描述 在这里插入图片描述 在这里插入图片描述 说明:26aicdb是关键字不能做为CDB的名称 在这里插入图片描述 CDB名称更换为cdbxf 在这里插入图片描述 在这里插入图片描述 在这里插入图片描述 在这里插入图片描述 在这里插入图片描述 在这里插入图片描述 在这里插入图片描述 在这里插入图片描述 在这里插入图片描述 在这里插入图片描述 CDB创建完成。

[oracle@26aidb01 ~]$ ps -ef|grep smon
oracle     59296   44340  0 02:10 ?        00:00:00 ora_smon_cdbxf
oracle     59791   59753  0 02:12 pts/0    00:00:00 grep --color=auto smon
[oracle@26aidb01 ~]$ sqlplus / as sysdba
SQL*Plus: Release 23.26.1.0.0 - Production on Thu Jan 29 02:12:55 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
SQL> show con_name con_id
CON_NAME
------------------------------
CDB$ROOT
CON_ID
------------------------------
1
SQL>

2、使用dbca创建PDB 在这里插入图片描述 在这里插入图片描述 在这里插入图片描述 在这在这里插入图片描述里插入图片描述 在这里插入图片描述 在这里插入图片描述

SQL> show pdbs
    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO
         3 XFPDB                          READ WRITE NO
SQL>

3、使用netca创建监听 在这里插入图片描述 在这里插入图片描述 在这里插入图片描述 在这里插入图片描述 检查监听状态 [oracle@26aidb01 ~]$ lsnrctl status LSNRCTL for Linux: Version 23.26.1.0.0 - Production on 29-JAN-2026 02:23:00 Copyright (c) 1991, 2026, Oracle.  All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=26aidb01)(PORT=1525))) STATUS of the LISTENER ------------------------ Alias                     LISTENER Version                   TNSLSNR for Linux: Version 23.26.1.0.0 - Production Start Date                29-JAN-2026 02:19:16 Uptime                    0 days 0 hr. 3 min. 44 sec Trace Level               off Security                  ON: Local OS Authentication SNMP                      OFF Listener Parameter File   /u01/app/oracle/product/26.23.1/db_1/network/admin/listener.ora Listener Log File         /u01/app/oracle/diag/tnslsnr/26aidb01/listener/alert/log.xml Listening Endpoints Summary...   (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=26aidb01)(PORT=1525)))   (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1525))) Services Summary... Service "48945b67d121c623e063399b5e6478e6" has 1 instance(s).   Instance "cdbxf", status READY, has 1 handler(s) for this service... Service "4982a3bcc60deb79e0637438a8c06483" has 1 instance(s).   Instance "cdbxf", status READY, has 1 handler(s) for this service... Service "cdbxf" has 1 instance(s).   Instance "cdbxf", status READY, has 1 handler(s) for this service... Service "cdbxfXDB" has 1 instance(s).   Instance "cdbxf", status READY, has 1 handler(s) for this service... Service "xfpdb" has 1 instance(s).   Instance "cdbxf", status READY, has 1 handler(s) for this service... The command completed successfully [oracle@26aidb01 ~]$

相关推荐