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
