Location>code7788 >text

Quickly silently install 23ai database on OCI

Popularity:428 ℃/2025-03-06 22:13:48

After getting the help of my colleagues to apply for the OCI environment [OEL 8.10], we started to install the 23ai database for subsequent testing. This article selects the fast silent installation mode.

The OCI environment is logged in by the opc user, and the sudo command is required to perform high-permission operations.

First create a directory where the media is stored and give the highest permissions:

sudo mkdir -p /u01/media
sudo chmod 777 /u01/media

Then upload the 23ai media to this directory.

At the same time, install using dnforacle-database-preinstall-23aiThis bag will be very convenient:

sudo dnf -y install oracle-database-preinstall-23ai

After the installation is completed, you will find that not only do the required dependency packages, but even the Oracle system users have built it for you. In addition, the regular system settings have been completed. If you are worried, you can check it:

cat /etc/security//
cat /etc/

In short, all these related details are ignored, which is very worry-free.

So what do we need to do?
Just create the installation directory you have planned according to the actual situation:

sudo mkdir -p /u01/app/oracle
sudo chown -R oracle:oinstall /u01/app

Then use the Oracle user to log in, set the environment variables, write it here~/.bash_profilemiddle:

export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=/u01/app/oracle/product/23.0.0/db_1
export ORACLE_SID=demo
export PATH=$ORACLE_HOME/bin:$PATH

After entering the ORACLE_HOME directory, decompress the 23ai installation media.

cd $ORACLE_HOME
unzip /u01/media/

Modify the response file required for silent installation, backup the previous one, and then edit and modify:

cd /u01/app/oracle/product/23.0.0/db_1/install/response
cp db_install.rsp db_install.
vi db_install.rsp

Test the modified files, in order to reduce the space, clean up the comments, and attach them to the end of the article for your reference:

After modification, start silently installing Oracle 23ai software:

./runInstaller -silent -ignorePrereqFailure -responseFile /u01/app/oracle/product/23.0.0/db_1/install/response/db_install.rsp

After the execution is successful, switch to the root user as prompted and execute two root scripts:

As a root user, run the following script(s):
        1. /u01/app/oraInventory/
        2. /u01/app/oracle/product/23.0.0/db_1/

After all root scripts are executed, switch back to Oracle user and execute:

/u01/app/oracle/product/23.0.0/db_1/runInstaller -executeConfigTools -responseFile /u01/app/oracle/product/23.0.0/db_1/install/response/db_install.rsp -silent

You will be prompted for a log, you can tail track and view the output, and finally the prompt is successful.

[oracle@dbtest ~]$ /u01/app/oracle/product/23.0.0/db_1/runInstaller -executeConfigTools -responseFile /u01/app/oracle/product/23.0.0/db_1/install/response/db_install.rsp -silent
Launching Oracle Database Setup Wizard...

You can find the logs of this session at:
/u01/app/oraInventory/logs/InstallActions2025-03-06_07-17-45AM


Successfully Configured Software.

The installation is completed successfully!
Try usingsqlplusLog in:

[oracle@dbtest ~]$ sqlplus / as sysdba

SQL*Plus: Release 23.0.0.0.0 - for Oracle Cloud and Engineered Systems on Thu Mar 6 07:26:25 2025
Version 23.8.0.25.04

Copyright (c) 1982, 2025, Oracle.  All rights reserved.


Connected to:
Oracle Database 23ai Enterprise Edition Release 23.0.0.0.0 - for Oracle Cloud and Engineered Systems
Version 23.8.0.25.04

SQL> show pdbs;

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO
         3 ALFRED                         READ WRITE NO

OK, at this point, the database environment of 23ai is ready to be completed.


FYI:

  1. Response file db_install.rsp reference

There are too many comments from the source file, clean up the comments first:

# Delete comment lines in the answer file (starting with #)
 sed -i 's/^#.*$//g' *.rsp
 # Delete blank lines without content (^$)
 sed -i '/^$/d' *.rsp

After cleaning the comments, the response file content is as follows, and you can DIY modify it according to your needs, especially the password:

=/oracle/install/rspfmt_dbinstall_response_schema_v23.0.0
installOption=INSTALL_DB_AND_CONFIG
UNIX_GROUP_NAME=oinstall
INVENTORY_LOCATION=/u01/app/oraInventory
ORACLE_HOME=/u01/app/oracle/product/23.0.0/db_1
ORACLE_BASE=/u01/app/oracle
installEdition=EE
OSDBA=dba
OSOPER=oper
OSBACKUPDBA=backupdba
OSDGDBA=dgdba
OSKMDBA=kmdba
OSRACDBA=racdba
executeRootScript=
configMethod=
sudoPath=
sudoUserName=
clusterNodes=
dbType=GENERAL_PURPOSE
gdbName=demo
dbSID=demo
pdbName=alfred
charSet=AL32UTF8
enableAutoMemoryManagement=false
memoryLimit=16384
allSchemaPassword=ChangeYour_pwd
sysPassword=
systemPassword=
dbsnmpPassword=
pdbadminPassword=
managementOption=DEFAULT
omsHost=
omsPort=
emAdminUser=
emAdminPassword=
enableRecovery=false
storageType=FILE_SYSTEM_STORAGE
dataLocation=/u01/app/oracle/oradata
recoveryLocation=/u01/app/oracle/recovery_area
diskGroup=
asmsnmpPassword=
  1. Display of dnf installation oracle-database-preinstall-23ai
    It is just used to refer to what dependency packages it automatically installs:
[opc@dbtest media]$ sudo dnf -y install oracle-database-preinstall-23ai
Latest Unbreakable Enterprise Kernel Release 7 for Oracle Linux 8 (x86_64)                                                         110 MB/s |  56 MB     00:00    
Last metadata expiration check: 0:00:07 ago on Thu 06 Mar 2025 03:49:27 AM GMT.
Dependencies resolved.
===================================================================================================================================================================
 Package                                             Architecture               Version                                    Repository                         Size
===================================================================================================================================================================
Installing:
 oracle-database-preinstall-23ai                     x86_64                     1.0-4.el8                                  ol8_appstream                      31 k
Installing dependencies:
 ksh                                                 x86_64                     20120801-267.0.1.el8                       ol8_appstream                     923 k
 libICE                                              x86_64                     1.0.9-15.el8                               ol8_appstream                      74 k
 libSM                                               x86_64                     1.2.3-1.el8                                ol8_appstream                      47 k
 libX11-xcb                                          x86_64                     1.6.8-9.el8_10                             ol8_appstream                      14 k
 libXcomposite                                       x86_64                     0.4.4-14.el8                               ol8_appstream                      28 k
 libXi                                               x86_64                     1.7.10-1.el8                               ol8_appstream                      49 k
 libXinerama                                         x86_64                     1.1.4-1.el8                                ol8_appstream                      15 k
 libXmu                                              x86_64                     1.1.3-1.el8                                ol8_appstream                      75 k
 libXrandr                                           x86_64                     1.5.2-1.el8                                ol8_appstream                      34 k
 libXt                                               x86_64                     1.1.5-12.el8                               ol8_appstream                     185 k
 libXtst                                             x86_64                     1.2.3-7.el8                                ol8_appstream                      22 k
 libXv                                               x86_64                     1.0.11-7.el8                               ol8_appstream                      20 k
 libXxf86dga                                         x86_64                     1.1.5-1.el8                                ol8_appstream                      26 k
 libXxf86misc                                        x86_64                     1.0.4-1.el8                                ol8_appstream                      23 k
 libXxf86vm                                          x86_64                     1.1.4-9.el8                                ol8_appstream                      19 k
 libdmx                                              x86_64                     1.1.4-3.el8                                ol8_appstream                      22 k
 xorg-x11-utils                                      x86_64                     7.5-28.el8                                 ol8_appstream                     136 k
 xorg-x11-xauth                                      x86_64                     1:1.0.9-12.el8                             ol8_appstream                      39 k

Transaction Summary
===================================================================================================================================================================
Install  19 Packages

Total download size: 1.7 M
Installed size: 5.0 M
Downloading Packages:
(1/19): ksh-20120801-267.0.1.el8.x86_64.rpm                                                                                         14 MB/s | 923 kB     00:00    
(2/19): libICE-1.0.9-15.el8.x86_64.rpm                                                                                             1.1 MB/s |  74 kB     00:00    
(3/19): libXcomposite-0.4.4-14.el8.x86_64.rpm                                                                                      1.2 MB/s |  28 kB     00:00    
(4/19): libX11-xcb-1.6.8-9.el8_10.x86_64.rpm                                                                                       277 kB/s |  14 kB     00:00    
(5/19): libSM-1.2.3-1.el8.x86_64.rpm                                                                                               194 kB/s |  47 kB     00:00    
(6/19): libXi-1.7.10-1.el8.x86_64.rpm                                                                                              217 kB/s |  49 kB     00:00    
(7/19): libXinerama-1.1.4-1.el8.x86_64.rpm                                                                                          68 kB/s |  15 kB     00:00    
(8/19): libXt-1.1.5-12.el8.x86_64.rpm                                                                                              4.7 MB/s | 185 kB     00:00    
(9/19): libXrandr-1.5.2-1.el8.x86_64.rpm                                                                                           465 kB/s |  34 kB     00:00    
(10/19): libXtst-1.2.3-7.el8.x86_64.rpm                                                                                            589 kB/s |  22 kB     00:00    
(11/19): libXxf86dga-1.1.5-1.el8.x86_64.rpm                                                                                        704 kB/s |  26 kB     00:00    
(12/19): libXv-1.0.11-7.el8.x86_64.rpm                                                                                             214 kB/s |  20 kB     00:00    
(13/19): libXxf86misc-1.0.4-1.el8.x86_64.rpm                                                                                       640 kB/s |  23 kB     00:00    
(14/19): libdmx-1.1.4-3.el8.x86_64.rpm                                                                                             290 kB/s |  22 kB     00:00    
(15/19): libXxf86vm-1.1.4-9.el8.x86_64.rpm                                                                                         188 kB/s |  19 kB     00:00    
(16/19): xorg-x11-utils-7.5-28.el8.x86_64.rpm                                                                                      3.6 MB/s | 136 kB     00:00    
(17/19): xorg-x11-xauth-1.0.9-12.el8.x86_64.rpm                                                                                    1.4 MB/s |  39 kB     00:00    
(18/19): oracle-database-preinstall-23ai-1.0-4.el8.x86_64.rpm                                                                      368 kB/s |  31 kB     00:00    
(19/19): libXmu-1.1.3-1.el8.x86_64.rpm                                                                                              38 kB/s |  75 kB     00:02    
-------------------------------------------------------------------------------------------------------------------------------------------------------------------
Total                                                                                                                              791 kB/s | 1.7 MB     00:02     
Running transaction check
Transaction check succeeded.
Running transaction test
Transaction test succeeded.
Running transaction
  Preparing        :                                                                                                                                           1/1 
  Installing       : libXi-1.7.10-1.el8.x86_64                                                                                                                1/19 
  Installing       : libICE-1.0.9-15.el8.x86_64                                                                                                               2/19 
  Installing       : libSM-1.2.3-1.el8.x86_64                                                                                                                 3/19 
  Installing       : libXt-1.1.5-12.el8.x86_64                                                                                                                4/19 
  Installing       : libXmu-1.1.3-1.el8.x86_64                                                                                                                5/19 
  Installing       : xorg-x11-xauth-1:1.0.9-12.el8.x86_64                                                                                                     6/19 
  Installing       : libXtst-1.2.3-7.el8.x86_64                                                                                                               7/19 
  Installing       : libdmx-1.1.4-3.el8.x86_64                                                                                                                8/19 
  Installing       : libXxf86vm-1.1.4-9.el8.x86_64                                                                                                            9/19 
  Installing       : libXxf86misc-1.0.4-1.el8.x86_64                                                                                                         10/19 
  Installing       : libXxf86dga-1.1.5-1.el8.x86_64                                                                                                          11/19 
  Installing       : libXv-1.0.11-7.el8.x86_64                                                                                                               12/19 
  Installing       : libXrandr-1.5.2-1.el8.x86_64                                                                                                            13/19 
  Installing       : libXinerama-1.1.4-1.el8.x86_64                                                                                                          14/19 
  Installing       : libXcomposite-0.4.4-14.el8.x86_64                                                                                                       15/19 
  Installing       : libX11-xcb-1.6.8-9.el8_10.x86_64                                                                                                        16/19 
  Installing       : xorg-x11-utils-7.5-28.el8.x86_64                                                                                                        17/19 
  Installing       : ksh-20120801-267.0.1.el8.x86_64                                                                                                         18/19 
  Running scriptlet: ksh-20120801-267.0.1.el8.x86_64                                                                                                         18/19 
  Installing       : oracle-database-preinstall-23ai-1.0-4.el8.x86_64                                                                                        19/19 
  Running scriptlet: oracle-database-preinstall-23ai-1.0-4.el8.x86_64                                                                                        19/19 
  Verifying        : ksh-20120801-267.0.1.el8.x86_64                                                                                                          1/19 
  Verifying        : libICE-1.0.9-15.el8.x86_64                                                                                                               2/19 
  Verifying        : libSM-1.2.3-1.el8.x86_64                                                                                                                 3/19 
  Verifying        : libX11-xcb-1.6.8-9.el8_10.x86_64                                                                                                         4/19 
  Verifying        : libXcomposite-0.4.4-14.el8.x86_64                                                                                                        5/19 
  Verifying        : libXi-1.7.10-1.el8.x86_64                                                                                                                6/19 
  Verifying        : libXinerama-1.1.4-1.el8.x86_64                                                                                                           7/19 
  Verifying        : libXmu-1.1.3-1.el8.x86_64                                                                                                                8/19 
  Verifying        : libXrandr-1.5.2-1.el8.x86_64                                                                                                             9/19 
  Verifying        : libXt-1.1.5-12.el8.x86_64                                                                                                               10/19 
  Verifying        : libXtst-1.2.3-7.el8.x86_64                                                                                                              11/19 
  Verifying        : libXv-1.0.11-7.el8.x86_64                                                                                                               12/19 
  Verifying        : libXxf86dga-1.1.5-1.el8.x86_64                                                                                                          13/19 
  Verifying        : libXxf86misc-1.0.4-1.el8.x86_64                                                                                                         14/19 
  Verifying        : libXxf86vm-1.1.4-9.el8.x86_64                                                                                                           15/19 
  Verifying        : libdmx-1.1.4-3.el8.x86_64                                                                                                               16/19 
  Verifying        : oracle-database-preinstall-23ai-1.0-4.el8.x86_64                                                                                        17/19 
  Verifying        : xorg-x11-utils-7.5-28.el8.x86_64                                                                                                        18/19 
  Verifying        : xorg-x11-xauth-1:1.0.9-12.el8.x86_64                                                                                                    19/19 

Installed:
  ksh-20120801-267.0.1.el8.x86_64                    libICE-1.0.9-15.el8.x86_64         libSM-1.2.3-1.el8.x86_64               libX11-xcb-1.6.8-9.el8_10.x86_64  
  libXcomposite-0.4.4-14.el8.x86_64                  libXi-1.7.10-1.el8.x86_64          libXinerama-1.1.4-1.el8.x86_64         libXmu-1.1.3-1.el8.x86_64         
  libXrandr-1.5.2-1.el8.x86_64                       libXt-1.1.5-12.el8.x86_64          libXtst-1.2.3-7.el8.x86_64             libXv-1.0.11-7.el8.x86_64         
  libXxf86dga-1.1.5-1.el8.x86_64                     libXxf86misc-1.0.4-1.el8.x86_64    libXxf86vm-1.1.4-9.el8.x86_64          libdmx-1.1.4-3.el8.x86_64         
  oracle-database-preinstall-23ai-1.0-4.el8.x86_64   xorg-x11-utils-7.5-28.el8.x86_64   xorg-x11-xauth-1:1.0.9-12.el8.x86_64  

Complete!

In addition, as of now, the OP version of Oracle 23ai's universal platform has not been officially released. Partners who want to test the functions can move on.23ai free version environment is ready quickly》。