Linux System Prep for Oracle

Overview

These instructions prepare a Linux 9 system for Oracle 26ai, excluding irrelevant or legacy steps. Change as required for your environment - minimally change this to your database: mydb.

Assumes

 - Linux OS patches up-to-date
 - DNS working.
 - Logged in as root.

Database Software

Oracle Database Software downloads are here.

 - Example: Oracle AI Database 26ai (23.61.1) for Linux x86-64
 - File: LINUX.X64_2326100_db_home.zip

Requirements (min)

 - OEL9\RHEL9
 - RAM: 2 GB minimum (8+ GB recommended)
 - Disk: 10gb (30+ GB recommended)
 - Firewall Ports (if firewalld enabled): 1521 and 5500.
 - Show SELinux Status: getenforce

Linux System Prep for Oracle

1) Preinstall

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

2) QC

id oracle
sysctl -a | egrep "shm|sem|file-max|aio|ip_local_port_range"
su - oracle -c 'ulimit -a'
timedatectl

3) Firewall (if needed)

firewall-cmd --state && \
firewall-cmd --add-port=1521/tcp --permanent && \
firewall-cmd --add-port=5500/tcp --permanent && \
firewall-cmd --reload

grep -R "oracle" /etc/sysctl.d /etc/sysctl.conf 2>/dev/null
grep -R "oracle" /etc/security/limits.d 2>/dev/null
sysctl -a | egrep "shm|sem|file-max|aio|ip_local_port_range"
ulimit -a

4) Set PW

passwd oracle 

5) Create Dirs

 mkdir -p /u01/orasw
 mkdir -p /u01/app/oracle/product/26ai/dbhome_1
 mkdir -p /u02/oradata/mydb
 mkdir -p /u03/fra/mydb

6) Set Privs

chown -R oracle:oinstall /u01 /u02 /u03
chmod -R 775 /u01 /u02 /u03

7) Set .bashrc

 # Oracle environment
 export ORACLE_SID=mydb
 export ORACLE_BASE=/u01/app/oracle
 export ORACLE_HOME=/u01/app/oracle/product/26ai/dbhome_1
 export PATH=$ORACLE_HOME/bin:$PATH

 # Temp
 export TMP=/tmp
 export TMPDIR=/tmp