Ameer Khan

Oracle Database 19c Installation On Oracle Linux 7 

• Download Software

Oracle Database 19c (19.3) Software (64-bit)

 Add hosts entry in hosts file

[root@oel7 ~]# cat /etc/hosts

127.0.0.1   localhost localhost.localdomain localhost4 localhost4.localdomain4

::1         localhost localhost.localdomain localhost6 localhost6.localdomain6

192.168.118.128 oel7.soumya.com oel7

Install the “oracle-database-preinstall-19c” package to perform all the prerequisite setup

# yum install -y oracle-database-preinstall-19c

The following packages are required :-

yum install -y bc   

yum install -y binutils

yum install -y compat-libcap1

yum install -y compat-libstdc++-33

yum install -y dtrace-utils

yum install -y elfutils-libelf

yum install -y elfutils-libelf-devel

yum install -y fontconfig-devel

yum install -y glibc

yum install -y glibc-devel

yum install -y ksh

yum install -y libaio

yum install -y libaio-devel

yum install -y libdtrace-ctf-devel

yum install -y libXrender

yum install -y libXrender-devel

yum install -y libX11

yum install -y libXau

yum install -y libXi

yum install -y libXtst

yum install -y libgcc

yum install -y librdmacm-devel

yum install -y libstdc++

yum install -y libstdc++-devel

yum install -y libxcb

yum install -y make

yum install -y net-tools # Clusterware

yum install -y nfs-utils # ACFS

yum install -y python # ACFS

yum install -y python-configshell # ACFS

yum install -y python-rtslib # ACFS

yum install -y python-six # ACFS

yum install -y targetcli # ACFS

yum install -y smartmontools

yum install -y sysstat

yum install -y unixODBC

Create the new groups and users if it doesnt exist. 

groupadd -g 54321 oinstall

groupadd -g 54322 dba

Create oracle user:-

useradd -u 54321 -g oinstall -G dba oracle

Set password for oracle user:- 

[root@oel7 ~]# passwd oracle

Changing password for user oracle.

New password:

BAD PASSWORD: The password is shorter than 8 characters

Retype new password:

passwd: all authentication tokens updated successfully.

 Disable selinux. Set it as disabled in the following file and restart the server to take effect.

 vi /etc/sysconfig/selinux

 SELINUX=disabled

Disable firewall

 #systemctl stop firewalld

#systemctl disable firewalld

 Create the directories in which the Oracle software will be installed.

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

chown -R oracle:oinstall /u01

chmod -R 775 /u01

 Open a new terminal as root user

xhost +

su – oracle

Edit bash_profile 

vi .bash_profile

 export TMP=/tmp

export TMPDIR=$TMP

 export ORACLE_HOSTNAME=oel7.soumya.com

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=orclcdb

export PDB_NAME=orclpdb1 

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

# Unzip software.

[oracle@oel7 ~]$ cd $ORACLE_HOME

[oracle@oel7 dbhome_1]$

[oracle@oel7 dbhome_1]$ unzip -oq /LINUX.X64_193000_db_home.zip

Start installation by invoking. We would only install the binary in first phase.

./runInstaller

Step1 : Click setup software only option

Step2 : Select Single Instance

Step 3:Select Enterprise  edition

Step 4: Provide Oracle Base path

Step 5: Provide Inventory directory & group name

Step 6 : Select groups as oinstall

Step 7: In this step you can provide root credential if you would like the installer to run the orainstRoot.sh and root.sh script later.

Here I chose to run those script myself, hence skipped this.

Step 8: Summary page for the binary installation information.

Step 9:Run the two scripts below from another terminal as root user.

Now this concludes the binary installation of oracle database.

We will proceed with the database instance creation using dbca utility.

[oracle@oel7 oradata]$ dbca

Step 1 : Select option create a database.

Step 2: Choose advanced configuration

Step 3: Select database type “single instance” 

Step 4:Provide database global name and database sid & pdb name.

Step 5: Choose the storage type and data file location

Step 6: Enable archiving and FRA location. We chose to configure this later.

Step 7: Configure listener .I skipped to configure this manually later.

Step 8: Skip this part unless you to want to configure DB Vault and Oracle Label Security

    Step 9: Provide sga size 

Step 10: Provide port and other details to configure EM

Step 11: Provide password for all administrative accounts

Step 12:Customize the redo log size and create the database

Step 13. Finally the summary page. You can save the response file which can be used later to create

database in silent mode.