Install and Configure 26AI Database on Linux

 

Topic: Install and Configure 26AI Database on Linux

 

Deployment Diagram:

In this QuickStart, we learn how to:

• Infrastructure details
• System configuration and RPM installation
• Directory and User Creation
• Unzip 26AI Software Binaries and installation
• Set Oracle user Bash profile
• Configure listener and network service
• Install database using DBCA
• Validation

Step-1 Infrastructure details

 

OS Details	Host Name	Database Version	ORACLE_HOME
8.6 (Ootpa)	26AI.example.com	23.26.1.0.0	/u01/app/oracle/product/26.0.0/dbhome_1

 

Ste-2 System configuration and rpm installation

 

Insert below parameter to /etc/sysctl.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

 

Create file  /etc/security/limits.d/oracle-database-26ai.conf and insert the following values in it.

 

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

 

Install below RPM package

dnf install -y bc   

dnf install -y binutils

dnf install -y compat-libstdc++-33

dnf install -y elfutils-libelf

dnf install -y elfutils-libelf-devel

dnf install -y fontconfig-devel

dnf install -y glibc

dnf install -y glibc-devel

dnf install -y ksh

dnf install -y libaio

dnf install -y libaio-devel

dnf install -y libXrender

dnf install -y libXrender-devel

dnf install -y libX11

dnf install -y libXau

dnf install -y libXi

dnf install -y libXtst

dnf install -y libgcc

dnf install -y librdmacm-devel

dnf install -y libnsl.i686

dnf install -y libnsl2

dnf install -y libnsl2.i686

dnf install -y libstdc++

dnf install -y libstdc++-devel

dnf install -y libxcb

dnf install -y make

dnf install -y net-tools # Clusterware

dnf install -y nfs-utils # ACFS

dnf install -y python # ACFS

dnf install -y python-configshell # ACFS

dnf install -y python-rtslib # ACFS

dnf install -y python-six # ACFS

dnf install -y targetcli # ACFS

dnf install -y smartmontools

dnf install -y sysstat

dnf install -y gcc

dnf install -y unixODBC

dnf install -y libnsl

dnf install compat-openssl10*

dnf install policycoreutils-python-utils-2.9-1*

 

Disable Firewall

[root@prim ~]# systemctl stop firewalld

[root@prim ~]# systemctl disable firewalld

[root@prim ~]#

Step-4 Unzip 26ai Software Binaries and Installation

 

[oracle@26AI ~]$ cd $ORACLE_HOME

[oracle@26AI dbhome_1]$ pwd

/u01/app/oracle/product/26.0.0/dbhome_1

[oracle@26AI dbhome_1]$ ./runInstaller

 

-          Set up Software Only

 

-          Single instance database installation

 

 

-          Click on next

 

-          Set the Inventory Directory and click Next

-          Click on next

 

-          Click on Next

 

-          We can ignore the Check and click on next

 

-          Click on install

 

 

/u01/app/oraInventory/orainstRoot.sh

/u01/app/oracle/product/26.0.0/dbhome_1/root.sh

Validation:

Step 4: Set the Oracle user Bash profile

[oracle@26AI ~]$ cat .bash_profile

# Oracle Settings

export TMP=/tmp

export TMPDIR=$TMP

export ORACLE_HOSTNAME=26AI.example.com

export ORACLE_UNQNAME=26CDB

export ORACLE_BASE=/u01/app/oracle

export ORACLE_HOME=$ORACLE_BASE/product/26.0.0/dbhome_1

export ORA_INVENTORY=/u01/app/oraInventory

export ORACLE_SID=26CDB

export PDB_NAME=pdb1

export DATA_DIR=/u02/oradata

export PATH=/usr/sbin:/usr/local/bin:$PATH

export PATH=$ORACLE_HOME/bin:$PATH

export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib

export CLASSPATH=$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib

 

Step-6 Configure the listener and network service

[oracle@26AI admin]$ lsnrctl start

[oracle@26AI admin]$ lsnrctl status

 

[oracle@prim admin]$ vi tnsnames.ora

[oracle@prim admin]$ cat tnsnames.ora

Step 7: Install database Using DBCA

-          Select Create a Database

 

[oracle@prim ~]$ dbca

-          Click on Advance configuration

 

-          Click on Next

-          Mention Global database name, SID, Click on Create as container database.

 

-          Click on Next

 

-          Specify the FRA location, Click on Enable Archiving

 

-          Specify the Archive location

-          Next screen will show running listener

 

-          Click on next

-          Specify the Memory target to the database

 

-          Click on character tab and select AL32UTF8 and AL16UTF16

-          Click on Next

 

-          Enter the Admin user password

 

-          Select Create database and click on next

 

-          Click on Finish

 

-          DB creation progress

 

-          Click on Close

Step-8 Validation