Oracle 19C Create and Configure a Single Instance Database

 Pre-requisites for OS level:      


    Set the static IP Address
    Disable the Firewall (systemctl stop firewalld & systemctl disable firewalld)
    set SELINUX=permissive on /etc/selinux/config  ##Need to restart the server use init 6

Oracle Installation Pre-requisites Methods

  1.     Automatic Setup
  2.     Manual Setup

Automatic requisites Setup: (avoid step 1 to step 5):

dnf install -y oracle-database-preinstall-19c

Install the dependencies:

curl -o oracle-database-preinstall-19c-1.0-2.el8.x86_64.rpm https://yum.oracle.com/repo/OracleLinux/OL8/appstream/x86_64/getPackage/oracle-database-preinstall-19c-1.0-2.el8.x86_64.rpm

dnf -y localinstall oracle-database-preinstall-19c-1.0-2.el8.x86_64.rpm

Manual Setup:

step 1: Add the karenl parameters and values

vi /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

step 2: Run the command to change the current kernel parameters and values:

/sbin/sysctl -p    
    
step 3:Add the following lines:

vi /etc/security/limits.d/oracle-database-preinstall-19c.conf

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

step 4:install the listed packages

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 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 -y libnsl.i686
dnf install -y libnsl2
dnf install -y libnsl2.i686

step 5: Create the new users and groups.

groupadd -g 54321 oinstall
groupadd -g 54322 dba
groupadd -g 54323 oper

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

Addtional setup for Both( Automatic Setup and  Manual Setup):


step 6: set the password for oracle user

passwd oracle

step 7: create the oracle 19c home directory, database installation directory(set owner and privileges)

mkdir -p /u01/app/oracle/product/19.0.0/dbhome_1
mkdir -p /u02/oradata
chown -R oracle:oinstall /u01 /u02
chmod -R 775 /u01 /u02

step 7: login as root and Run the following command.

xhost +

step 8: create the bash profile and add the below lines

su - oracle

vi .bash_profile

export TMP=/tmp
export TMPDIR=$TMP

export ORACLE_HOSTNAME=192.168.31.201
export ORACLE_UNQNAME=pearl
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/19.0.0/dbhome_1
export ORA_INVENTORY=/u01/app/oraInventory
export ORACLE_SID=pearl
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 9: run the bash_profile

. .bash_profile

step 10: set the DISPLAY environmental variable.

export DISPLAY=:0.0;

step 11: need to give the privileges for Software Zip file in other terminal
su - root
cd /tmp
chmod o+r,o+w,o+x V982063-01.zip

su - oracle
. .bash_profile

export DISPLAY=:0.0;

export DISPLAY=localhost:10.0
 
cd $ORACLE_HOME
unzip -oq /tmp/V982063-01.zip

step 12: Run the runInstaller
        GUI Mode
        Silent Mode
    
Error: [WARNING] [INS-08101] Unexpected error while executing the action at state: 'supportedOSCheck'

Run:
export CV_ASSUME_DISTID=OEL8.8

 GUI Mode installation:

Run the runInstaller     ./runInstaller























Comments

Post a Comment