Oracle 26ai database installation and configuration Virtual machine with OS OEL9.

 

Dear All,

here i have shared step by step installation     on Oracle 26ai on Virtual machine on OS OEL9.

 

 

> Introduction

> Pre-requisites

> Software download and copy to server and untar

> OS users & groups setup

> DB Software Install

> DB creation DBCA

> Post DB creation steps .

 

Hardware & OS  Requirements :

Disk Space ::: 10G ( 40G)

Memory :: 2 G ( 4G)

CPU : 2

OS >> REHL / OEL 8,9 supported

Oracle AI Database 26ai Installation On Oracle Linux 9 (OL9)

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

OS Packages :

https://yum.oracle.com/oracle-linux-isos.html

 

cat /etc/hosts

 /etc/selinux/config

 

 stop firewall 

 

groupadd -g 54321 oinstall

groupadd -g 54322 dba

groupadd -g 54323 oper 

#groupadd -g 54324 backupdba

#groupadd -g 54325 dgdba

#groupadd -g 54326 kmdba

#groupadd -g 54327 asmdba

#groupadd -g 54328 asmoper

#groupadd -g 54329 asmadmin

#groupadd -g 54330 racdba

useradd -u 54321 -g oinstall -G dba,oper oracle

 

 

dnf install -y bc

dnf install -y binutils

dnf install -y compat-openssl10

dnf install -y elfutils-libelf

dnf install -y glibc

dnf install -y glibc-devel

dnf install -y ksh

dnf install -y libaio

dnf install -y libXrender

dnf install -y libX11

dnf install -y libXau

dnf install -y libXi

dnf install -y libXtst

dnf install -y libgcc

dnf install -y libnsl

dnf install -y libstdc++

dnf install -y libxcb

dnf install -y libibverbs

dnf install -y libasan

dnf install -y liblsan

dnf install -y make

dnf install -y policycoreutils

dnf install -y policycoreutils-python-utils

dnf install -y smartmontools

dnf install -y sysstat

# Additional packages.

dnf install -y ipmiutil

dnf install -y libnsl2

dnf install -y libnsl2-devel

dnf install -y libvirt-libs

dnf install -y net-tools

dnf install -y nfs-utils

# Added by me.

dnf install -y unixODBC

 

 

"/etc/security/limits.d/oracle-ai-database-preinstall-26ai.conf" file.

oracle   soft   nofile    1024

oracle   hard   nofile    65536

oracle   soft   nproc    16384

oracle   hard   nproc    16384

oracle   soft   stack    10240

oracle   hard   stack    32768

oracle   hard   memlock    134217728

oracle   soft   memlock    134217728

oracle   soft   data    unlimited

oracle   hard   data    unlimited

Manual Setup

If you have not used the "oracle-ai-database-preinstall-26ai" package to perform all prerequisites, you will need to manually perform the following setup tasks.

Add the following lines to the "/etc/sysctl.conf" file, or in a file called "/etc/sysctl.d/98-oracle.conf".

fs.file-max = 6815744

kernel.sem = 250 32000 100 128

kernel.shmmni = 4096

kernel.shmall = 1073741824

kernel.shmmax = 4398046511104

kernel.panic_on_oops = 1

net.core.rmem_default = 262144

net.core.rmem_max = 4194304

net.core.wmem_default = 262144

net.core.wmem_max = 1048576

net.ipv4.conf.all.rp_filter = 2

net.ipv4.conf.default.rp_filter = 2

fs.aio-max-nr = 1048576

net.ipv4.ip_local_port_range = 9000 65500

Run one of the following commands to change the current kernel parameters, depending on which file you edited.

/sbin/sysctl -p

# Or

/sbin/sysctl -p /etc/sysctl.d/98-oracle.conf

 

 

curl -o oracle-ai-database-preinstall-26ai-1.0-1.el9.x86_64.rpm https://yum.oracle.com/repo/OracleLinux/OL9/appstream/x86_64/getPackage/oracle-ai-database-preinstall-26ai-1.0-1.el9.x86_64.rpm

dnf -y localinstall oracle-ai-database-preinstall-26ai-1.0-1.el9.x86_64.rpm

 

 

# dnf install -y oracle-ai-database-preinstall-26ai

It is probably worth doing a full update as well, but this is not strictly speaking necessary.

# dnf update -y

 

 

mkdir -p /u01/app/oracle/product/26.0.0/dbhome_1

mkdir -p /u02/oradata

chown -R oracle:oinstall /u01 /u02

chmod -R 775 /u01 /u02

 

# Unzip software.

cd $ORACLE_HOME

unzip -oq /path/to/software/LINUX.X64_2326100_db_home.zip

# Interactive mode.

./runInstaller

 

 

 

 

 

thanks,

Srini