Search for a command to run...
![[26ai] Install Oracle AI Database 26ai on Linux 9](/_next/image?url=https%3A%2F%2Fcdn.hashnode.com%2Fuploads%2Fcovers%2F65605419d28f19cc44df7ef1%2F243000b4-ccef-4cab-97db-f9b47328159f.png&w=3840&q=75)
Ingeniero informático, Oracle ACE, DBA y Arquitecto OCI, con más de 15 años de experiencia en plataformas Oracle. Certificado en OCI Certified Architect Professional y OCI Migration and Integration Certified Professional.
No comments yet. Be the first to comment.
If you prefer to read in Spanish Spanish version. Today, let's talk about the steps to clone a PDB using RMAN Active Duplicate or DDL commands betweent differents CDB$Root. DDL Let's use a script in
![[OCI] Clone PDB](/_next/image?url=https%3A%2F%2Fcdn.hashnode.com%2Fuploads%2Fcovers%2F65605419d28f19cc44df7ef1%2F4c20418f-c149-484c-a2b7-c30b4cfec47b.png&w=3840&q=75)
If you prefer to read in Spanish Spanish version. Today, let's see a little script in order to see quickly monitor jobs running into Oracle Database Cloud. Below, you can see the output our sh: At t
![[OCI] Check Jobs DBCli](/_next/image?url=https%3A%2F%2Fcdn.hashnode.com%2Fuploads%2Fcovers%2F65605419d28f19cc44df7ef1%2F4007e787-d6ad-47d9-b238-d69a285383ab.png&w=3840&q=75)
If you prefer to read in Spanish Spanish version. Today, let's talk about the new join syntax available in the last realease 26ai. It was introduced to simplify our joins avoiding common mistakes, wri
![[26ai] JOIN_TO_ME](/_next/image?url=https%3A%2F%2Fcdn.hashnode.com%2Fuploads%2Fcovers%2F65605419d28f19cc44df7ef1%2F49867547-f920-47a6-b11f-f5db511bcc73.png&w=3840&q=75)
If you prefer to read in Spanish Spanish version. Today, let's create an audit in order to clean up unused package/procedure/function in the database, with the porpuse of reducing the total amount of
![[26ai] Cleanup of Obsolete PL/SQL Objects](/_next/image?url=https%3A%2F%2Fcdn.hashnode.com%2Fuploads%2Fcovers%2F65605419d28f19cc44df7ef1%2F64ada612-0048-411c-b9df-61b8825af6e7.png&w=3840&q=75)
If you prefer to read in Spanish Spanish version. Today, let's talk about a new Hybrid Read-Only open-mode in 26ai. When we set up this mode, our PDB is read-only mode for local users and read-write f
![[26ai] Hybrid Read-Only Mode PDB](/_next/image?url=https%3A%2F%2Fcdn.hashnode.com%2Fuploads%2Fcovers%2F65605419d28f19cc44df7ef1%2F23e8f92e-f89b-4746-930e-98156e3a1ec4.png&w=3840&q=75)
If you prefer to read in Spanish Spanish version.
Today, we're going to see how to set up Oracle 26ai on Linux 9.
[root@~]# grep PRETTY /etc/os-release
PRETTY_NAME="Oracle Linux Server 9.7"
First of all, we need to download an Oracle 26ai pre-installation from here.
After downloading the rpm, let's set it up.
root@~]# ls -lac oracle-ai-database-preinstall-26ai-1.0-1.el9.x86_64.rpm
-rw-r--r--. 1 root root 35302 mar 8 11:39 oracle-ai-database-preinstall-26ai-1.0-1.el9.x86_64.rpm
[root@~]# dnf -y install oracle-ai-database-preinstall-26ai-1.0-1.el9.x86_64.rpm
...
...
¡Listo!
Done!, Let's check whether the oracle user exists on our machine in order to create ORACLE_HOME directory.
[root@~]# id oracle
uid=54321(oracle) gid=54321(oinstall) grupos=54321(oinstall),54322(dba),54323(oper),54324(backupdba),54325(dgdba),54326(kmdba),54330(racdba)
[root@~]#
[root@~]# mkdir -p /u01/app/oracle/product/23.26.1/dbhome_1
[root@~]# chown -R oracle:oinstall /u01 && chown -R oracle:oinstall /u01
[root@~]# su - oracle
[oracle@~]$ cd /u01/app/oracle/product/23.26.1/dbhome_1/
Let's edit the .bashrc and bash_profile files in order to set up the following variables:
[oracle@~]$ tail -8 .bashrc
# User specific aliases and functions
ORACLE_BASE=/u01/app/oracle/
ORACLE_HOME=/u01/app/oracle/product/23.26.1/dbhome_1; export ORACLE_HOME
PATH=\(PATH:\){ORACLE_HOME}/bin; export PATH
LD_LIBRARY_PATH={ORACLE_HOME}/lib; export LD_LIBRARY_PATH
Lastly, let's download Oracle AI Database 26ai (23.26.1) for Linux x86-64 from here.
After downloading it, let's copy the file to the following path:
[oracle@]$ pwd && ls -lash
/u01/app/oracle/product/23.26.1/dbhome_1
total 2,3G
0 drwxr-xr-x. 2 oracle oinstall 43 mar 14 12:12 .
0 drwxr-xr-x. 3 oracle oinstall 22 mar 9 22:54 ..
2,3G -rwxr-x---. 1 oracle oinstall 2,3G mar 14 12:18 LINUX.X64_2326100_db_home.zip
[oracle@]$ unzip LINUX.X64_2326100_db_home.zip
Let's modify the response file because we'll use silent mode in order to set it up.
[oracle@]$ vi install/response/db_install.rsp
[oracle@]\( grep -v "#" install/response/db_install.rsp | grep -v '^\)'
oracle.install.responseFileVersion=/oracle/install/rspfmt_dbinstall_response_schema_v23.0.0
installOption=INSTALL_DB_SWONLY
UNIX_GROUP_NAME=oinstall
INVENTORY_LOCATION=${ORA_INVENTORY}
ORACLE_HOME=/u01/app/oracle/product/23.26.1/dbhome_1
ORACLE_BASE=/u01/app/oracle/
installEdition=EE
OSDBA=dba
OSBACKUPDBA=dba
OSDGDBA=dba
OSKMDBA=dba
OSRACDBA=dba
[oracle@]$ ./runInstaller -silent -responsefile install/response/db_install.rsp
Let's run the folowing scripts as the root user:
[root@~]# . /u01/app/oraInventory/orainstRoot.sh
...
[root@~]# . /u01/app/oracle/product/23.26.1/dbhome_1/root.sh
...
Let's verify our instalation.
[oracle@~]$ sqlplus /nolog
SQL*Plus: Release 23.26.1.0.0 - Production on Sat Mar 14 17:49:10 2026
Version 23.26.1.0.0
Copyright (c) 1982, 2025, Oracle. All rights reserved.
SQL>
Looking forward to seeing you in the next article :)