Ameer Khan

Oracle Database 19c Software Installation On Oracle Linux 7 using silent mode

         Download Software

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

The objective of creating this post is sometimes we face difficulties in database binaries installation and database creation graphically. So to mitigate the problem I will show how to do the software installation through command lines. I will share the process of database creation though command line in my next blog post.

 I have shared steps of Oracle Database 19c installation in graphical mode in this post.

Step 1.  Add hosts entry in hosts file

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

127.0.0.1   localhost localhost.localdomain localhost4 localhost4.localdomain4

::1         localhost localhost.localdomain localhost6 localhost6.localdomain6

192.168.0.110 gg1.soumya.com gg1

 Step 2. 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-*

Step 3. Create the new groups and users if it doesn’t 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@gg1 ~]# 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.

Step 4.  Disable selinux. Set it as disabled in the following file and restart the server to make it effective.

 vi /etc/sysconfig/selinux

 SELINUX=disabled

Disable firewall

 #systemctl stop firewalld

#systemctl disable firewalld

Step 5. 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

Step 6.  Modify bash_profile of oracle user.

vi .bash_profile

export TMP=/tmp

export TMPDIR=$TMP

 export ORACLE_HOSTNAME=gg1.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

Step 7. Unzip software.

[oracle@gg1 ~]$ cd $ORACLE_HOME

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

Step 8. create the response file

[oracle@gg1 ]$ cd $ORACLE_HOME/install/response

[oracle@gg1 ]$ vi db_install.rsp

[oracle@gg1 ]$

####################################################################

## Copyright(c) Oracle Corporation 1998,2019. All rights reserved.##

##                                                                ##

## Specify values for the variables listed below to customize     ##

## your installation.                                             ##

##                                                                ##

## Each variable is associated with a comment. The comment        ##

## can help to populate the variables with the appropriate        ##

## values.                                                        ##

##                                                                ##

## IMPORTANT NOTE: This file contains plain text passwords and    ##

## should be secured to have read permission only by oracle user  ##

## or db administrator who owns this installation.                ##

##                                                                ##

####################################################################

#——————————————————————————

# Do not change the following system generated value.

#——————————————————————————

oracle.install.responseFileVersion=/oracle/install/rspfmt_dbinstall_response_schema_v19.0.0

#——————————————————————————-

# Specify the installation option.

# It can be one of the following:

#   – INSTALL_DB_SWONLY

#   – INSTALL_DB_AND_CONFIG

#——————————————————————————-

oracle.install.option=INSTALL_DB_SWONLY

#——————————————————————————-

# Specify the Unix group to be set for the inventory directory.

#——————————————————————————-

UNIX_GROUP_NAME=oinstall

#——————————————————————————-

# Specify the location which holds the inventory files.

# This is an optional parameter if installing on

# Windows based Operating System.

#——————————————————————————-

INVENTORY_LOCATION= /u01/app/oraInventory

#——————————————————————————-

# Specify the complete path of the Oracle Home.

#——————————————————————————-

ORACLE_HOME= /u01/app/oracle/product/19.0.0/dbhome_1

#——————————————————————————-

# Specify the complete path of the Oracle Base.

#——————————————————————————-

ORACLE_BASE=/u01/app/oracle

#——————————————————————————-

# Specify the installation edition of the component.

#

# The value should contain only one of these choices.

#   – EE     : Enterprise Edition

#   – SE2     : Standard Edition 2

#——————————————————————————-

oracle.install.db.InstallEdition=EE

###############################################################################

#                                                                             #

# PRIVILEGED OPERATING SYSTEM GROUPS                                          #

# ——————————————                                  #

# Provide values for the OS groups to which SYSDBA and SYSOPER privileges     #

# needs to be granted. If the install is being performed as a member of the   #

# group “dba”, then that will be used unless specified otherwise below.       #

#                                                                             #

# The value to be specified for OSDBA and OSOPER group is only for UNIX based #

# Operating System.                                                           #

#                                                                             #

###############################################################################

#——————————————————————————

# The OSDBA_GROUP is the OS group which is to be granted SYSDBA privileges.

#——————————————————————————-

oracle.install.db.OSDBA_GROUP=oinstall

#——————————————————————————

# The OSOPER_GROUP is the OS group which is to be granted SYSOPER privileges.

# The value to be specified for OSOPER group is optional.

#——————————————————————————

oracle.install.db.OSOPER_GROUP=oinstall

#——————————————————————————

# The OSBACKUPDBA_GROUP is the OS group which is to be granted SYSBACKUP privileges.

#——————————————————————————

oracle.install.db.OSBACKUPDBA_GROUP=oinstall

#——————————————————————————

# The OSDGDBA_GROUP is the OS group which is to be granted SYSDG privileges.

#——————————————————————————

oracle.install.db.OSDGDBA_GROUP=oinstall

#——————————————————————————

# The OSKMDBA_GROUP is the OS group which is to be granted SYSKM privileges.

#——————————————————————————

oracle.install.db.OSKMDBA_GROUP=oinstall

################################################################################

#                                                                              #

#                      Root script execution configuration                     #

#                                                                              #

################################################################################

#——————————————————————————————————-

# Specify the root script execution mode.

#

#   – true  : To execute the root script automatically by using the appropriate configuration methods.

#   – false : To execute the root script manually.

#

# If this option is selected, password should be specified on the console.

#——————————————————————————————————-

oracle.install.db.rootconfig.executeRootScript=false

#————————————————————————————–

# Specify the configuration method to be used for automatic root script execution.

#

# Following are the possible choices:

#   – ROOT

#   – SUDO

#————————————————————————————–

oracle.install.db.rootconfig.configMethod=ROOT

#————————————————————————————–

# Specify the absolute path of the sudo program.

#

# Applicable only when SUDO configuration method was chosen.

#————————————————————————————–

oracle.install.db.rootconfig.sudoPath=

#————————————————————————————–

# Specify the name of the user who is in the sudoers list.

# Applicable only when SUDO configuration method was chosen.

# Note:For Single Instance database installations,the sudo user name must be the username of the user installing the database.

#————————————————————————————–

oracle.install.db.rootconfig.sudoUserName=

###############################################################################

#                                                                             #

#                               Grid Options                                  #

#                                                                             #

###############################################################################

#——————————————————————————

# Value is required only if the specified install option is INSTALL_DB_SWONLY

#

# Specify the cluster node names selected during the installation.

#

# Example : oracle.install.db.CLUSTER_NODES=node1,node2

#——————————————————————————

oracle.install.db.CLUSTER_NODES=

###############################################################################

#                                                                             #

#                        Database Configuration Options                       #

#                                                                             #

###############################################################################

#——————————————————————————-

# Specify the type of database to create.

# It can be one of the following:

#   – GENERAL_PURPOSE

#   – DATA_WAREHOUSE

# GENERAL_PURPOSE: A starter database designed for general purpose use or transaction-heavy applications.

# DATA_WAREHOUSE : A starter database optimized for data warehousing applications.

#——————————————————————————-

oracle.install.db.config.starterdb.type=

#——————————————————————————-

# Specify the Starter Database Global Database Name.

#——————————————————————————-

oracle.install.db.config.starterdb.globalDBName=

#——————————————————————————-

# Specify the Starter Database SID.

#——————————————————————————-

oracle.install.db.config.starterdb.SID=

#——————————————————————————-

# Specify whether the database should be configured as a Container database.

# The value can be either “true” or “false”. If left blank it will be assumed

# to be “false”.

#——————————————————————————-

oracle.install.db.ConfigureAsContainerDB=

#——————————————————————————-

# Specify the  Pluggable Database name for the pluggable database in Container Database.

#——————————————————————————-

oracle.install.db.config.PDBName=

#——————————————————————————-

# Specify the Starter Database character set.

#

#  One of the following

#  AL32UTF8, WE8ISO8859P15, WE8MSWIN1252, EE8ISO8859P2,

#  EE8MSWIN1250, NE8ISO8859P10, NEE8ISO8859P4, BLT8MSWIN1257,

#  BLT8ISO8859P13, CL8ISO8859P5, CL8MSWIN1251, AR8ISO8859P6,

#  AR8MSWIN1256, EL8ISO8859P7, EL8MSWIN1253, IW8ISO8859P8,

#  IW8MSWIN1255, JA16EUC, JA16EUCTILDE, JA16SJIS, JA16SJISTILDE,

#  KO16MSWIN949, ZHS16GBK, TH8TISASCII, ZHT32EUC, ZHT16MSWIN950,

#  ZHT16HKSCS, WE8ISO8859P9, TR8MSWIN1254, VN8MSWIN1258

#——————————————————————————-

oracle.install.db.config.starterdb.characterSet=

#——————————————————————————

# This variable should be set to true if Automatic Memory Management

# in Database is desired.

# If Automatic Memory Management is not desired, and memory allocation

# is to be done manually, then set it to false.

#——————————————————————————

oracle.install.db.config.starterdb.memoryOption=

#——————————————————————————-

# Specify the total memory allocation for the database. Value(in MB) should be

# at least 256 MB, and should not exceed the total physical memory available

# on the system.

# Example: oracle.install.db.config.starterdb.memoryLimit=512

#——————————————————————————-

oracle.install.db.config.starterdb.memoryLimit=

#——————————————————————————-

# This variable controls whether to load Example Schemas onto

# the starter database or not.

# The value can be either “true” or “false”. If left blank it will be assumed

# to be “false”.

#——————————————————————————-

oracle.install.db.config.starterdb.installExampleSchemas=

###############################################################################

#                                                                             #

# Passwords can be supplied for the following four schemas in the             #

# starter database:                                                           #

#   SYS                                                                       #

#   SYSTEM                                                                    #

#   DBSNMP (used by Enterprise Manager)                                       #

#                                                                             #

# Same password can be used for all accounts (not recommended)                #

# or different passwords for each account can be provided (recommended)       #

#                                                                             #

###############################################################################

#——————————————————————————

# This variable holds the password that is to be used for all schemas in the

# starter database.

#——————————————————————————-

oracle.install.db.config.starterdb.password.ALL=

#——————————————————————————-

# Specify the SYS password for the starter database.

#——————————————————————————-

#——————————————————————————-

oracle.install.db.config.starterdb.password.SYS=

#——————————————————————————-

# Specify the SYSTEM password for the starter database.

#——————————————————————————-

oracle.install.db.config.starterdb.password.SYSTEM=

#——————————————————————————-

# Specify the DBSNMP password for the starter database.

# Applicable only when oracle.install.db.config.starterdb.managementOption=CLOUD_CONTROL

#——————————————————————————-

oracle.install.db.config.starterdb.password.DBSNMP=

#——————————————————————————-

# Specify the PDBADMIN password required for creation of Pluggable Database in the Container Database.

#——————————————————————————-

oracle.install.db.config.starterdb.password.PDBADMIN=

#——————————————————————————-

# Specify the management option to use for managing the database.

# Options are:

# 1. CLOUD_CONTROL – If you want to manage your database with Enterprise Manager Cloud Control along with Database Express.

# 2. DEFAULT   -If you want to manage your database using the default Database Express option.

#——————————————————————————-

oracle.install.db.config.starterdb.managementOption=

#——————————————————————————-

# Specify the OMS host to connect to Cloud Control.

# Applicable only when oracle.install.db.config.starterdb.managementOption=CLOUD_CONTROL

#——————————————————————————-

oracle.install.db.config.starterdb.omsHost=

#——————————————————————————-

# Specify the OMS port to connect to Cloud Control.

# Applicable only when oracle.install.db.config.starterdb.managementOption=CLOUD_CONTROL

#——————————————————————————-

#——————————————————————————-

# Specify the OMS host to connect to Cloud Control.

# Applicable only when oracle.install.db.config.starterdb.managementOption=CLOUD_CONTROL

#——————————————————————————-

oracle.install.db.config.starterdb.omsHost=

#——————————————————————————-

# Specify the OMS port to connect to Cloud Control.

# Applicable only when oracle.install.db.config.starterdb.managementOption=CLOUD_CONTROL

#——————————————————————————-

oracle.install.db.config.starterdb.omsPort=

#——————————————————————————-

# Specify the EM Admin user name to use to connect to Cloud Control.

# Applicable only when oracle.install.db.config.starterdb.managementOption=CLOUD_CONTROL

#——————————————————————————-

oracle.install.db.config.starterdb.emAdminUser=

#——————————————————————————-

# Specify the EM Admin password to use to connect to Cloud Control.

# Applicable only when oracle.install.db.config.starterdb.managementOption=CLOUD_CONTROL

#——————————————————————————-

oracle.install.db.config.starterdb.emAdminPassword=

###############################################################################

#                                                                             #

# SPECIFY RECOVERY OPTIONS                                                    #

# ————————————                                        #

# Recovery options for the database can be mentioned using the entries below  #

#                                                                             #

###############################################################################

#——————————————————————————

# This variable is to be set to false if database recovery is not required. Else

# this can be set to true.

#——————————————————————————-

oracle.install.db.config.starterdb.enableRecovery=

#——————————————————————————-

# Specify the type of storage to use for the database.

# It can be one of the following:

#   – FILE_SYSTEM_STORAGE

#   – ASM_STORAGE

#——————————————————————————-

oracle.install.db.config.starterdb.storageType=

#——————————————————————————-

# Specify the database file location which is a directory for datafiles, control

# files, redo logs.

#

# Applicable only when oracle.install.db.config.starterdb.storage=FILE_SYSTEM_STORAGE

#——————————————————————————-

oracle.install.db.config.starterdb.fileSystemStorage.dataLocation=

#——————————————————————————-

# Specify the recovery location.

#

# Applicable only when oracle.install.db.config.starterdb.storage=FILE_SYSTEM_STORAGE

#——————————————————————————-

oracle.install.db.config.starterdb.fileSystemStorage.recoveryLocation=

#——————————————————————————-

# Specify the existing ASM disk groups to be used for storage.

#

# Applicable only when oracle.install.db.config.starterdb.storageType=ASM_STORAGE

#——————————————————————————-

oracle.install.db.config.asm.diskGroup=

#——————————————————————————-

# Specify the password for ASMSNMP user of the ASM instance.

#

# Applicable only when oracle.install.db.config.starterdb.storage=ASM_STORAGE

#——————————————————————————-

oracle.install.db.config.asm.ASMSNMPPassword=

Step 9. Run the prerequisite check

[oracle@gg1 ~]$ cd $ORACLE_HOME

[oracle@gg1 dbhome_1]$ ./runInstaller -executePrereqs -silent -responseFile /u01/app/oracle/product/19.0.0/dbhome_1/install/response/db_install.rsp

Launching Oracle Database Setup Wizard…

Prerequisite checks executed successfully.

Step 10. Begin oracle software installation

[oracle@gg1 dbhome_1]$ ./runInstaller -silent -responseFile /u01/app/oracle/product/19.0.0/dbhome_1/install/response/db_install.rsp

Launching Oracle Database Setup Wizard…

The response file for this session can be found at:

 /u01/app/oracle/product/19.0.0/dbhome_1/install/response/db_2020-12-23_10-28-11PM.rsp

You can find the log of this install session at:

 /u01/app/oraInventory/logs/InstallActions2020-12-23_10-28-11PM/installActions2020-12-23_10-28-11PM.log

As a root user, execute the following script(s):

        1. /u01/app/oracle/product/19.0.0/dbhome_1/root.sh

Execute /u01/app/oracle/product/19.0.0/dbhome_1/root.sh on the following nodes:

[gg1]

Step 11.

Execute root.sh script

Login as root user to execute the following script

[root@gg1 19c]# /u01/app/oracle/product/19.0.0/dbhome_1/root.sh

Check /u01/app/oracle/product/19.0.0/dbhome_1/install/root_gg1.soumya.com_2020-12-23_22-40-39-618157216.log for the output of root script

So this concludes the process of oracle 19c software installation using command line on Linux.