OpenEuler2509安装oracle AI Database 26ai

Oracle AI Database 26ai Installation Report

Installation Date: 2026-08-14
System: openEuler 25.09 (x86_64)
Installation Method: RPM Package Installation (RPM-based Installation)

1. Installation Summary

Item Status Description
Pre-install package oracle-ai-database-preinstall-26ai-1.0-1.el10.x86_64.rpm :white_check_mark: Installed Creates oracle user/group, kernel parameters, and limits
Database software oracle-ai-database-ee-26ai-1.0-1.el10.x86_64.rpm :white_check_mark: Installed Oracle Home: /opt/oracle/product/26ai/dbhome_1
Container Database ORCLCDB :white_check_mark: READ WRITE SID=ORCLCDB, Character Set AL32UTF8
Pluggable Database ORCLPDB1 :white_check_mark: READ WRITE Created with CDB
Listener LISTENER:1521 :white_check_mark: READY Instance ORCLCDB registered
Datafile Location :white_check_mark: /opt/oracle/oradata (~3.4G)

2. Environment Information

System Version  : openEuler 25.09
Kernel          : 6.6.0-102.0.0.8.oe2509.x86_64
Architecture    : x86_64
Memory          : 30 GB
CPU             : 6 cores
Disk            : / partition 295G (available ~129G)

3. Installation Steps

3.1 Pre-install Package Installation (with Dependency Handling)

The pre-install package was built for el10 (RHEL 10), and some dependencies on openEuler 25.09 could not be directly satisfied. The following steps were taken:

  1. Dependency Diagnosis: First rpm -ivh failed due to missing dependencies:

    • /etc/redhat-release missing (openEuler does not have this file)
    • glibc >= 2.39 (system version is 2.38), glibc-devel >= 2.39
    • libgcc >= 14.2.1, libstdc++ >= 14.2.1 (system version is 12.3.1)
    • ksh, sysstat >= 12.7.6, libxcrypt-compat >= 4.4.36 not installed
  2. Resolution Measures:

    # Create /etc/redhat-release (openEuler has no such file)
    echo "openEuler release 25.09 (RHEL-compatible)" > /etc/redhat-release
    
    # Install available dependencies from openEuler repositories (ksh, sysstat 12.7.7, libxcrypt 4.4.38)
    dnf install -y ksh sysstat libxcrypt
    
    # glibc/libgcc/libstdc++ version requirements and libxcrypt-compat are only for RPM metadata validation;
    # the package scripts do not actually depend on them, so use --nodeps to install
    rpm -ivh --nodeps oracle-ai-database-preinstall-26ai-1.0-1.el10.x86_64.rpm
    
  3. Configuration Application: The package has no installation script; actual configuration is performed by /usr/bin/oracle-ai-database-preinstall-26ai-verify (or automatically invoked during posttrans). Applied settings:

    • User and Group (based on .param file in package):

      • oracle user: uid 54321, primary group oinstall
      • Groups: oinstall (54321), dba (54322), oper (54323), backupdba (54324), dgdba (54325), kmdba (54326), racdba (54330)
    • Kernel Parameters (/etc/sysctl.d/99-oracle-ai-database-preinstall-26ai-sysctl.conf, applied via sysctl):

      Parameter Value
      fs.file-max 6815744
      kernel.sem 250 32000 100 128
      kernel.shmmni 4096
      kernel.shmall 1073741824
      kernel.shmmax 4398046511104
      kernel.panic 10
      net.core.rmem_default / rmem_max 262144 / 4194304
      net.core.wmem_default / wmem_max 262144 / 1048576
      net.ipv4.conf.all/default.rp_filter 2
      fs.aio-max-nr 1048576
      net.ipv4.ip_local_port_range 9000 65535
      vm.hugetlb_shm_group 54321 (oinstall gid)
    • User Limits (/etc/security/limits.d/oracle-ai-database-preinstall-26ai.conf):

      Item soft hard
      nofile 1024 65536
      nproc 16384 16384
      stack 10240 KB 32768 KB
      memlock 134217728 KB 134217728 KB
      data unlimited unlimited
    • Boot Parameters (生效需重启, written to /etc/default/grub):

      • numa=off, transparent_hugepage=madvise
      • grub2-mkconfig executed to update all kernel entries

3.2 Database Software Installation

  1. Media Verification: The initially downloaded oracle-ai-database-ee-26ai package was only 18.8MB; rpm -K reported Payload SHA256: BAD (download truncated). After re-downloading the full 2.1GB package, verification passed:

    rpm -Kv oracle-ai-database-ee-26ai-1.0-1.el10.x86_64.rpm
    # Header SHA256/SHA1 OK, Payload SHA256/MD5 OK
    
  2. Ownership Fix: The %pre script reported ORACLE_BASE (/opt/oracle) not owned by oracle user. After fixing ownership, installation succeeded:

    chown oracle:oinstall /opt/oracle
    yum -y localinstall oracle-ai-database-ee-26ai-1.0-1.el10.x86_64.rpm
    
  3. Installation Artifacts:

    • Oracle Home: /opt/oracle/product/26ai/dbhome_1 (~5.8G after install)
    • Service script: /etc/init.d/oracledb_ORCLCDB-26ai
    • Configuration file: /etc/sysconfig/oracledb_ORCLCDB-26ai.conf

3.3 Database Creation (configure)

Used the RPM-provided configuration script to create CDB + 1 PDB:

/etc/init.d/oracledb_ORCLCDB-26ai configure

Internally executed:

dbca -silent -createDatabase \
  -gdbName ORCLCDB -templateName General_Purpose.dbc \
  -characterSet AL32UTF8 -createAsContainerDatabase true \
  -numberOfPDBs 1 -pdbName ORCLPDB1 \
  -createListener LISTENER:1521 \
  -datafileDestination /opt/oracle/oradata -sid ORCLCDB \
  -autoGeneratePasswords

Configuration parameters (/etc/sysconfig/oracledb_ORCLCDB-26ai.conf):

LISTENER_PORT=1521
CHARSET=AL32UTF8
ORACLE_DATA_LOCATION=/opt/oracle/oradata
CONFIGURE_TDE=false

Database creation took approximately 15 minutes. Final output: Database configuration completed successfully. Logs located at /opt/oracle/cfgtoollogs/dbca/ORCLCDB/.

4. Verification Results

SQL> select name, open_mode from v$database;
ORCLCDB   READ WRITE

SQL> select con_id, name, open_mode from v$pdbs;
 2  PDB$SEED  READ ONLY
 3  ORCLPDB1  READ WRITE

Listener: Service "ORCLCDB" has 1 instance(s), status READY

5. Usage Instructions

5.1 Connect to Database (password is auto-generated; must be changed on first login)

su - oracle
export ORACLE_HOME=/opt/oracle/product/26ai/dbhome_1
export ORACLE_SID=ORCLCDB
export PATH=$ORACLE_HOME/bin:$PATH

# Log in as sysdba and change password
sqlplus / as sysdba
SQL> alter user sys identified by <new_password>;
SQL> alter user system identified by <new_password>;

5.2 Connection Strings

  • CDB: ORCLCDB=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=<hostname/IP>)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=ORCLCDB)))
  • PDB: ORCLPDB1=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=<hostname/IP>)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=ORCLPDB1)))

5.3 Service Management

# Start/stop/status (as root)
/etc/init.d/oracledb_ORCLCDB-26ai start|stop|status

Instance is configured to start automatically at boot.

5.4 Notes

  1. Boot parameters require a system reboot to take full effect (numa=off, transparent_hugepage=madvise).
  2. Passwords are auto-generated during configuremust be changed immediately after first login.
  3. Version 26ai has changed column names in the V$VERSION view (querying version column returns ORA-00904); this is expected behavior.
  4. --nodeps was used for pre-install package handling — only skips metadata validation, does not affect functionality. For future deployment on official RHEL 10, use full official dependencies.
  5. Log locations:
    • Installation log: /var/log/oracle-ai-database-ee-26ai/results/oraInstall.log
    • Pre-install verification log: /var/log/oracle-ai-database-preinstall-26ai/results/
    • Database creation log: /opt/oracle/cfgtoollogs/dbca/ORCLCDB/
    • Alert log: /opt/oracle/diag/rdbms/orclcdb/ORCLCDB/trace/alert_ORCLCDB.log

6. Installation Media

File Size Description
oracle-ai-database-preinstall-26ai-1.0-1.el10.x86_64.rpm 35 KB Pre-install package (official SHA256 9e70e660… matches)
oracle-ai-database-ee-26ai-1.0-1.el10.x86_64.rpm 2.1 GB Database software (integrity verified)