Tag Archives: oracle database administration

Install Oracle AI Database 26ai

Install Oracle AI Database 26ai (23.26.1) for Linux x86-64

Pre-requisites already been taken care like memory, swap, kernel parameters, add groups, profile and users…etc

Table of Contents

___________________________________________________________________________________________________

1. Hardware Requirements
2. Verify OS version
3. Download 19c db software
4. Oracle Installation Prerequisites
5. Unzip
6. Invoke ./runInstaller
7. Verify
___________________________________________________________________________________________________


1. Hardware Requirements

The first thing we need to verify the hardware requirements

— Check Physical RAM.

[root@lxicborasgv01 ~]# grep MemTotal /proc/meminfo
MemTotal:       17516840 kB
[root@lxicborasgv01 ~]#


— Check Swap Space.

[root@lxicborasgv01 ~]# grep SwapTotal /proc/meminfo
SwapTotal:       8253436 kB
[root@lxicborasgv01 ~]#

-– Check space available in /tmp

[root@lxicborasgv01 ~]# df -h /tmp
Filesystem              Size  Used Avail Use% Mounted on
/dev/mapper/ol_10-root   62G  7.2G   54G  12% /
[root@lxicborasgv01 ~]#


-– Check space for Oracle Software and pre-configured database.

[root@lxicborasgv01 ~]# df -h /u01
Filesystem              Size  Used Avail Use% Mounted on
/dev/mapper/ol_10-home   30G  246M   30G   1% /u01
[root@lxicborasgv01 ~]#


—- Check CPU 

[root@lxicborasgv01 ~]# lscpu | grep -i "CPU(s):" | head -n 1
CPU(s):                                  4
[root@lxicborasgv01 ~]#


2. Verify OS version

[root@lxicborasgv01 ~]# cat /etc/redhat-release
Red Hat Enterprise Linux release 9.6 (Plow)
[root@lxicborasgv01 ~]#

[root@lxicborasgv01 ~]# cat /etc/hosts | grep -i lxicborasgv01
192.168.2.52 lxicborasgv01
[root@lxicborasgv01 ~]#


3. Download Software

Download the Oracle software from OTN or MY ORACLE SUPPORT (MOS).

https://www.oracle.com/database/technologies/oracle26ai-linux-downloads.html


4. Oracle Installation Prerequisites

[root@lxicborasgv01 ~]# dnf install -y oracle-ai-database-preinstall-26ai
Last metadata expiration check: 0:44:40 ago on Wed 28 Jan 2026 06:14:51 PM.
Dependencies resolved.
==============================================================================================================================================================================================================
 Package                                                           Architecture                          Version                                           Repository                                    Size
==============================================================================================================================================================================================================
Installing:
 oracle-ai-database-preinstall-26ai                                x86_64                                1.0-1.el9                                         ol9_appstream                                 34 k
Installing dependencies:
 compat-openssl11                                                  x86_64                                1:1.1.1k-5.el9_6.1                                ol9_appstream                                1.5 M

Transaction Summary
==============================================================================================================================================================================================================
Install  2 Packages

Total download size: 1.5 M
Installed size: 3.8 M
Downloading Packages:
(1/2): oracle-ai-database-preinstall-26ai-1.0-1.el9.x86_64.rpm                                                                                                                295 kB/s |  34 kB     00:00
(2/2): compat-openssl11-1.1.1k-5.el9_6.1.x86_64.rpm                                                                                                                           3.4 MB/s | 1.5 MB     00:00
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Total                                                                                                                                                                         3.4 MB/s | 1.5 MB     00:00
Running transaction check
Transaction check succeeded.
Running transaction test
Transaction test succeeded.
Running transaction
  Preparing        :                                                                                                                                                                                      1/1
  Installing       : compat-openssl11-1:1.1.1k-5.el9_6.1.x86_64                                                                                                                                           1/2
  Installing       : oracle-ai-database-preinstall-26ai-1.0-1.el9.x86_64                                                                                                                                  2/2
  Running scriptlet: oracle-ai-database-preinstall-26ai-1.0-1.el9.x86_64                                                                                                                                  2/2
  Verifying        : compat-openssl11-1:1.1.1k-5.el9_6.1.x86_64                                                                                                                                           1/2
  Verifying        : oracle-ai-database-preinstall-26ai-1.0-1.el9.x86_64                                                                                                                                  2/2

Installed:
  compat-openssl11-1:1.1.1k-5.el9_6.1.x86_64                                                        oracle-ai-database-preinstall-26ai-1.0-1.el9.x86_64

Complete!
[root@lxicborasgv01 ~]#

[root@lxicborasgv01 ~]# id oracle
uid=54321(oracle) gid=54321(oinstall) groups=54321(oinstall),54322(dba),54323(oper),54324(backupdba),54325(dgdba),54326(kmdba),54330(racdba)
[root@lxicborasgv01 ~]#


5. Unzip Software


NOTE: During installation using OUI, you cannot manually edit the Oracle Home location. The installer automatically detects the ORACLE_HOME from the directory where the database binaries are unzipped. Therefore, make sure to unzip the binaries directly inside the intended ORACLE_HOME directory before running ./runInstaller.

Also note that after unzipping, the files will not be placed under a single directory as in Oracle 10g, 11g, and 12c.

[root@lxicborasgv01 ~]# mkdir -p /u01/app/oracle/product/23.26.1/dbhome_1
[root@lxicborasgv01 ~]# chown -R oracle:oinstall /u01
[root@lxicborasgv01 ~]# chmod -R 775 /u01
[root@lxicborasgv01 ~]#

[root@lxicborasgv01 ~]# passwd oracle
Changing password for user oracle.
New password:
BAD PASSWORD: The password is shorter than 8 characters
Retype new password:
passwd: all authentication tokens updated successfully.
[root@lxicborasgv01 ~]#

[oracle@lxicborasgv01 ~]$ cd /u01/app/oracle/product/23.26.1/dbhome_1/
[oracle@lxicborasgv01 dbhome_1]$ ls -ltr
total 2349668
-rw-r--r--. 1 oracle oinstall 2406058543 Jan 28 12:25 LINUX.X64_2326100_db_home.zip
[oracle@lxicborasgv01 dbhome_1]$

[oracle@lxicborasgv01 dbhome_1]$ unzip LINUX.X64_2326100_db_home.zip
Archive:  LINUX.X64_2326100_db_home.zip
  inflating: META-INF/MANIFEST.MF
  inflating: META-INF/ORACLE_C.SF
  inflating: META-INF/ORACLE_C.RSA
   creating: OPatch/
  inflating: OPatch/README.txt
   creating: OPatch/auto/
..
..
  rdbms/mesg/ocius.msg   -> ./oraus.msg
  rdbms/mesg/ocizhs.msb  -> orazhs.msb
  rdbms/mesg/ocizht.msb  -> orazht.msb
[oracle@lxicborasgv01 dbhome_1]$


6. Invoke ./runInstaller

Start the Oracle Universal Installer (OUI) by issuing the following command.

[oracle@lxicborasgv01 ~]$ cd /u01/app/oracle/product/23.26.1/dbhome_1/

[oracle@lxicborasgv01 dbhome_1]$ ./runInstaller 

Launching Oracle AI Database Setup Wizard...
          

[root@lxicborasgv01 ~]# /u01/app/oraInventory/orainstRoot.sh
Changing permissions of /u01/app/oraInventory.
Adding read,write permissions for group.
Removing read,write,execute permissions for world.

Changing groupname of /u01/app/oraInventory to oinstall.
The execution of the script is complete.
[root@lxicborasgv01 ~]#
[root@lxicborasgv01 ~]# /u01/app/oracle/product/23.26.1/dbhome_1/root.sh
Performing root user operation.

The following environment variables are set as:
    ORACLE_OWNER= oracle
    ORACLE_HOME=  /u01/app/oracle/product/23.26.1/dbhome_1

Enter the full pathname of the local bin directory: [/usr/local/bin]:
   Copying dbhome to /usr/local/bin ...
   Copying oraenv to /usr/local/bin ...
   Copying coraenv to /usr/local/bin ...


Creating /etc/oratab file...
Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root script.
Now product-specific root actions will be performed.
[root@lxicborasgv01 ~]#
 


7. Verify

[oracle@lxicborasgv01 ~]$ export ORACLE_HOME=/u01/app/oracle/product/23.26.1/dbhome_1
[oracle@lxicborasgv01 ~]$ export PATH=$ORACLE_HOME/bin:$PATH
[oracle@lxicborasgv01 ~]$ which sqlplus
/u01/app/oracle/product/23.26.1/dbhome_1/bin/sqlplus
[oracle@lxicborasgv01 ~]$
[oracle@lxicborasgv01 ~]$ sqlplus /nolog

SQL*Plus: Release 23.26.1.0.0 - Production on Wed Jan 28 21:15:21 2026
Version 23.26.1.0.0

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

SQL>

Caution: Your use of any information or materials on this website is entirely at your own risk. It is provided for educational purposes only. It has been tested internally, however, we do not guarantee that it will work for you. Ensure that you run it in your test environment before using.

Thank you,
Rajasekhar Amudala
Email: br8dba@gmail.com
WhatsApp : +
Linkedin: https://www.linkedin.com/in/rajasekhar-amudala/

Post #7

BRIGHT DBA · Independent DBA Consultant

24/7 Managed Database Services

Remote DBA services from an independent senior Oracle and PostgreSQL consultant: monitoring, backup, patching, tuning, high availability and migration, with a DBA you can talk to directly.

OraclePostgreSQLReliableSecureScalable

What you get

  • Round-the-clock monitoring and alerting
  • Fast response when something breaks
  • Tested backups and recovery
  • A predictable monthly cost instead of a full-time hire
  • A senior DBA who knows your systems
What We Manage

Everything your databases need to stay healthy

One person responsible for availability, performance and recoverability, so problems are caught before your users notice them.

📡

24/7 Monitoring & Alerting

Continuous checks on availability, space, sessions, locks, replication lag and slow queries, with alerts that reach a person.

💾

Backup & Recovery

Backup strategy, verification and regular restore tests with RMAN, pgBackRest and point-in-time recovery.

🔧

Patching & Upgrades

Planned patching and version upgrades with rollback plans and minimal downtime.

🚀

Performance Tuning

Find and fix slow SQL, tune statistics, memory and I/O, and keep performance steady as data grows.

🛡️

High Availability & DR

Data Guard, RAC, Patroni and repmgr, designed, built and tested with switchover drills.

🔁

Migrations

Zero-downtime migrations with GoldenGate, between versions and platforms, including Oracle to PostgreSQL.

Our Specialities

Deep expertise where it matters

🔴

Oracle

RAC, Data Guard, GoldenGate, Exadata, multitenant, RMAN backup and recovery, patching, upgrades and performance tuning.

View Oracle DBA services →
🐘

PostgreSQL

Patroni, repmgr, HAProxy and pgBackRest, streaming replication, point-in-time recovery, tuning and version upgrades.

View PostgreSQL DBA services →
🔀

Oracle to PostgreSQL Migration

Cut licence costs by moving to PostgreSQL. We assess, plan and migrate your databases with minimal downtime.

Learn more →
How We Support You

Clear, direct and easy to work with

💬

Direct chat channel

A WhatsApp or Slack channel for quick questions and updates, so you talk to the DBA, not a ticket queue.

📞

Incident calls

When something critical breaks, we join a live call on Zoom or Meet and work the problem with your team.

📊

Monthly health report

A clear report on performance, capacity, backups and risks, with recommendations.

🔐

Security & access review

Regular checks of users, privileges and patch levels to keep your databases safe.

📘

Runbooks & documentation

Your procedures documented, so recovery and routine tasks do not depend on one person.

⏱️

Agreed response targets

Response times are agreed per plan, matched to how critical each database is.

Service Plans

Choose the level of cover you need

Every plan is scoped to your environment. Pricing is a custom quote, and response targets are agreed per plan.

Essential

Business-hours care

For smaller environments that need regular attention.

  • Monitoring during business hours
  • Daily backup checks
  • Monthly health report
  • Email and WhatsApp support
Standard · Most popular

24/7 coverage

For production systems that cannot go down.

  • 24/7 monitoring and alerting
  • Incident response with agreed targets
  • Planned patching and maintenance
  • Monthly review with recommendations
Premium

Proactive and complete

For critical, high-availability databases.

  • Everything in Standard
  • Proactive performance tuning
  • Disaster recovery drills
  • Priority response and named DBA
How It Works

Up and running in four steps

1

Book a call

Tell us about your databases and what worries you.

2

Assessment

We review your databases and agree the scope and plan with you.

3

Onboarding

We set up monitoring, access and runbooks, then take over.

4

We run it

We watch, maintain and report on your databases every month.

FAQ

Frequently asked questions

What is included in a managed database plan?

Depending on the plan: monitoring, backup checks, patching, performance tuning and regular reports. We agree the exact scope with you before we start.

What response time do you offer?

Response targets are agreed per plan, based on how critical your databases are to your business.

Which databases do you manage?

Oracle (including RAC, Data Guard, GoldenGate and Exadata) and PostgreSQL.

Can you help us migrate from Oracle to PostgreSQL?

Yes. We assess your Oracle databases, plan the move and carry it out with minimal downtime, using the tools that suit your case.

How do you handle backups and recovery?

We set up and monitor backups, for example RMAN for Oracle and pgBackRest for PostgreSQL, and we test restores regularly so recovery is proven, not assumed.

How do you access our systems, and is it secure?

Access is agreed up front, through your VPN or bastion host, with named accounts and the least privileges needed. Confidentiality terms are part of the agreement.

Do you work with databases in the cloud?

We can manage databases running on cloud servers. Tell us your setup and we will confirm what we can support.

How do we get started?

Book a call or send us a message. We begin with an assessment of your environment and then propose a plan.

Talk to Us

Let us look after your databases

Book a call, or tell us what you run and what keeps you up at night. We will get back to you soon with a proposal.

Tell us what you need

💬