Wednesday, December 9, 2020

DBCA Silent Mode for Container Database

# ---------------------------------------------------------------------
# glogin.sql
# ---------------------------------------------------------------------
# Modify the configuration of GLOGIN to show you better results.

cat >> $ORACLE_HOME/sqlplus/admin/glogin.sql <<EOF
set pages 700 lines 700 timing on time on colsep '|' trim on trims on numformat 999999999999999 heading on feedback on
COLUMN NAME FORMAT A20
COLUMN FILE_NAME FORMAT A80
SET SQLPROMPT '&_user@&_connect_identifier> '
DEFINE _EDITOR=vi
EOF

# ---------------------------------------------------------------------
# Database Creation Version 19c (With CDB/PDB on ASM Disks)
# SINGLE Create Database Silent on ASM and Container True

dbca -silent -createDatabase -templateName General_Purpose.dbc \
  -gdbName cdbprod \
  -sid cdbprod \
  -createAsContainerDatabase true \
  -databaseConfigType single \
  -SysPassword Welcome1 \
  -SystemPassword Welcome1 \
  -emConfiguration NONE \
  -storageType ASM \
  -datafileDestination +DATA \
  -redoLogFileSize 200 \
  -characterSet AL32UTF8 \
  -enableArchive true \
  -archiveLogMode auto \
  -recoveryAreaDestination +FRA \
  -memoryPercentage 50 \
  -dbOptions IMEDIA:false,CWMLITE:false,SAMPLE_SCHEMA:false,ORACLE_TEXT:false,APEX:false,OMS:false,DV:false,JSERVER:false,SPATIAL:false

# ---------------------------------------------------------------------
# This is to setup the password of your new CDP, necessary when you use DBCA Silent.
# ---------------------------------------------------------------------

orapwd dbuniquename=cdbprod file='+DATA' force=y entries=10 password="Welcome1+"

# ---------------------------------------------------------------------
# Validate the Database Creation
# ---------------------------------------------------------------------

srvctl config database -db cdbprod

ORACLE Configuration

# ------------------------------------------------------------------------
su - oracle

# ------------------------------------------------------------------------
# Version Variable
# ------------------------------------------------------------------------
#

ORA_VER_INST="11.2.0.4"
ORA_VER_INST="12.1.0.2"
ORA_VER_INST="12.2.0.1"
ORA_VER_INST="12.2.0.2"
ORA_VER_INST="18.1.0.1"
ORA_VER_INST="18.1.0.2"
ORA_VER_INST="18.2.0.1"
ORA_VER_INST="18.2.0.2"
ORA_VER_INST="18.3.0.1"
ORA_VER_INST="18.3.0.2"
ORA_VER_INST="18.4.0.1"
ORA_VER_INST="19.1.0.1"
ORA_VER_INST="19.2.0.2"
ORA_VER_INST="19.3.0.1"

# ------------------------------------------------------------------------
# Oracle Edition
# ------------------------------------------------------------------------
#

ORA_EDITION="db_SE_01"
ORA_EDITION="db_SE1_01"
ORA_EDITION="db_SE2_01"
ORA_EDITION="db_EE_01"
ORA_EDITION="db_PE_01"
ORA_EDITION="db_XE_01"

# ------------------------------------------------------------------------
# SRV01 - ORACLE
# ------------------------------------------------------------------------
#

cat > /home/oracle/.cdb1 <<EOF
# Variables Of Environment ORACLE [ ORACLE ]
export TMP=/tmp
export TMPDIR=\${TMP}
export HOST=\`hostname\`
export UPTIME=\`uptime | sed 's/.*up \([^,]*\), .*/\1/'\`
export ORACLE_HOSTNAME=\${HOST}
export ORACLE_BASE=/u01/app/oracle
export ORACLE_VERSION=${ORA_VER_INST}
export ORACLE_EDITION=${ORA_EDITION}
export ORACLE_HOME=\${ORACLE_BASE}/product/\${ORACLE_VERSION}/\${ORACLE_EDITION}
export GRID_HOME=/u01/app/\${ORACLE_VERSION}/grid
export ORACLE_TERM=xterm
export ORACLE_UNQNAME=cdbprod
export ORACLE_SID=cdbprod
export GRID_SID="+ASM"
export OGG_HOME=\${ORACLE_BASE}/product/ogg_19c
export TFA_HOME=\${ORACLE_HOME}/suptools/tfa/release/tfa_home
export OCK_HOME=\${ORACLE_HOME}/suptools/orachk
export OH=\${ORACLE_HOME}
export DBS=\${ORACLE_HOME}/dbs
export TNS=\${ORACLE_HOME}/network/admin
export OGG=\${OGG_HOME}
export TFA=\${TFA_HOME}
export OCK=\${OCK_HOME}
export ORATOP=\${ORACLE_HOME}/suptools/oratop/oratop
export OPATCH=\${ORACLE_HOME}/OPatch
export JAVA_HOME=\${ORACLE_HOME}/jdk
export PS1=\$'[ \${ORACLE_SID} ]|[ \${LOGNAME}@\h:\`pwd\`: ]\$ '
export PATH=\${PATH}:/usr/sbin:/usr/bin:/sbin:/bin:\${ORACLE_HOME}/bin:\${GRID_HOME}/bin:\${OPATCH}:\${ORACLE_HOME}/perl/bin:\${JAVA_HOME}/bin:\${OGG_HOME}:\${TFA_HOME}/bin:\${OCK_HOME}/
export LD_LIBRARY_PATH=\${ORACLE_HOME}/lib:\${ORACLE_HOME}/perl/lib:\${GRID_HOME}/lib:/lib:/usr/lib
export CLASSPATH=\${ORACLE_HOME}/JRE:\${ORACLE_HOME}/jlib:\${ORACLE_HOME}/rdbms/jlib
export ALERTDB=\${ORACLE_BASE}/diag/rdbms/\${ORACLE_UNQNAME}/\${ORACLE_SID}/trace/alert_\${ORACLE_SID}.log
export ALERTDG=\${ORACLE_BASE}/diag/rdbms/\${ORACLE_UNQNAME}/\${ORACLE_SID}/trace/drc\${ORACLE_SID}.log
export ALERTGG=\${OGG_HOME}/ggserr.log
export ALERTASM=\${ORACLE_BASE}/diag/asm/+asm/\${GRID_SID}/trace/alert_\${GRID_SID}.log
export LSNRCTL=\`ps -ef | grep tnslsnr | grep -v "grep" | wc -l\`
alias dblog='tail -f \${ALERTDB}'
alias dglog='tail -f \${ALERTDG}'
alias gglog='tail -f \${ALERTGG}'
alias asmlog='tail -f \${ALERTASM}'
alias sqlplus='rlwrap sqlplus'
alias s='rlwrap sqlplus / as sysdba'
alias rman='rlwrap rman'
alias r='rlwrap rman target /'
alias dgmgrl='rlwrap dgmgrl'
alias d='rlwrap dgmgrl /'
alias asmcmd='rlwrap asmcmd'
alias a='rlwrap asmcmd'
alias adrci='rlwrap adrci'
alias ad='rlwrap adrci'
alias ggsci='rlwrap \${OGG_HOME}/ggsci'
alias ogg='rlwrap \${OGG_HOME}/ggsci'
alias p='ps -ef | grep pmon | grep -v grep'
alias l='rlwrap lsnrctl status'
alias rest='crsctl stat res -t -init'
alias res='crsctl stat res -t'
alias orat='\${ORATOP}/oratop -f -i 10 / as sysdba'
alias meminfo='free -m -l -t'
alias psmem='ps auxf | sort -nr -k 4'
alias psmem10='ps auxf | sort -nr -k 4 | head -10'
alias pscpu='ps auxf | sort -nr -k 3'
alias pscpu10='ps auxf | sort -nr -k 3 | head -10'
alias cpuinfo='lscpu'
umask 0022
clear
if [[ \${ORACLE_SID} = \`ps -ef | grep pmon | grep -i \${ORACLE_SID} | awk '{ print \$NF }' | sed s/ora_pmon_//g\` ]]
then
  DB_STATUS="ONLINE"
else
  DB_STATUS="OFFLINE"
fi
if [ \${LSNRCTL} != 0 ]
then
  DB_LISTNER="ONLINE"
else
  DB_LISTNER="OFFLINE"
fi
echo ">----------------------------------------------------------------------------------------------"
echo "# SERVER_UPTIME.....: [ \${UPTIME} ]"
echo "# ORACLE_BASE.......: [ \${ORACLE_BASE} ]"
echo "# ORACLE_HOME.......: [ \${ORACLE_HOME} ]"
echo "# ORACLE_VERSION....: [ \${ORACLE_VERSION} ]"
echo "# ORACLE_SID........: [ \${ORACLE_SID} ]"
echo "# DATABASE_STATUS...: [ \${DB_STATUS} ]"
echo "# LISTENER_STATUS...: [ \${DB_LISTNER} ]"
echo ">----------------------------------------------------------------------------------------------"
EOF

grep -v '^#\|^$' /etc/oratab

# ------------------------------------------------------------------------
chown oracle.oinstall /home/oracle/.cdb1

echo ". /home/oracle/.cdb1" >> /home/oracle/.bash_profile

Tuesday, December 8, 2020

AFD / ACFS Configuration

# ------------------------------------------------------------------------
# AFD Manually Installation
# ------------------------------------------------------------------------
# AS ROOT

/u01/app/19.3.0.1/grid/bin/afdroot version_check      ---> only to enable acfs
/u01/app/19.3.0.1/grid/bin/afddriverstate supported   ---> only to enable acfs

# SINGLE RESTART
/u01/app/19.3.0.1/grid/bin/asmcmd afd_label DATA /dev/sdb --init
/u01/app/19.3.0.1/grid/bin/asmcmd afd_label FRA /dev/sdc --init

/u01/app/19.3.0.1/grid/bin/asmcmd afd_lslbl
/u01/app/19.3.0.1/grid/bin/asmcmd afd_lsdsk
/u01/app/19.3.0.1/grid/bin/asmcmd afd_state

# RAC
# /u01/app/19.3.0.1/grid/bin/asmcmd afd_label CONFIG /dev/sdb
/u01/app/19.3.0.1/grid/bin/asmcmd afd_label CONFIG /dev/sdb --init

# /u01/app/19.3.0.1/grid/bin/asmcmd afd_label DATA /dev/sdc
/u01/app/19.3.0.1/grid/bin/asmcmd afd_label DATA /dev/sdc --init

# /u01/app/19.3.0.1/grid/bin/asmcmd afd_label FRA /dev/sdd
/u01/app/19.3.0.1/grid/bin/asmcmd afd_label FRA /dev/sdd --init

/u01/app/19.3.0.1/grid/bin/asmcmd afd_lslbl
/u01/app/19.3.0.1/grid/bin/asmcmd afd_lsdsk
/u01/app/19.3.0.1/grid/bin/asmcmd afd_state

#
/u01/app/19.3.0.1/grid/bin/asmcmd lsdsk --statistics


# chown grid.asmadmin /dev/sdb
# chown grid.asmadmin /dev/sdc
# chown grid.asmadmin /dev/sdd

#
/u01/app/19.3.0.1/grid/crs/config/config.sh


# Clear

asmcmd afd_unlabel 'CONFIG'
asmcmd afd_unlabel 'DATA'
asmcmd afd_unlabel 'FRA'


disk /dev/sdb1 is already provisioned for ASM
disk /dev/sdc1 is already provisioned for ASM


dd if=/dev/zero of=/dev/sdb1 bs=1024 count=100
dd if=/dev/zero of=/dev/sdc1 bs=1024 count=100

# ------------------------------------------------------------------------
# Pre-Checks of Oracle Restart Installation
# ------------------------------------------------------------------------

./runcluvfy.sh stage -pre hacfg

GRID Configuration

# ------------------------------------------------------------------------
# ------------------------------------------------------------------------
# Version Variable
#

ORA_VER_INST="11.2.0.4"
ORA_VER_INST="12.1.0.2"
ORA_VER_INST="12.2.0.1"
ORA_VER_INST="12.2.0.2"
ORA_VER_INST="18.1.0.1"
ORA_VER_INST="18.1.0.2"
ORA_VER_INST="18.2.0.1"
ORA_VER_INST="18.2.0.2"
ORA_VER_INST="18.3.0.1"
ORA_VER_INST="18.3.0.2"
ORA_VER_INST="18.4.0.1"
ORA_VER_INST="19.3.0.1"

# ------------------------------------------------------------------------
# Oracle Edition
#

ORA_EDITION="db_SE_01"
ORA_EDITION="db_SE1_01"
ORA_EDITION="db_SE2_01"
ORA_EDITION="db_EE_01"
ORA_EDITION="db_PE_01"

# ------------------------------------------------------------------------
# Grid Folders
# ------------------------------------------------------------------------
#

mkdir -p /u01/app/grid
mkdir -p /u01/app/${ORA_VER_INST}/grid
mkdir -p /u01/app/oraInventory/
#
chown grid.oinstall -R /u01/app/grid
chown grid.oinstall -R /u01/app/${ORA_VER_INST}

#
# chown grid.oinstall /u01/app/oraInventory/

# ------------------------------------------------------------------------
# Database Folders
# ------------------------------------------------------------------------
#

mkdir -p /u01/app/oracle
mkdir -p /u01/app/oracle/product/${ORA_VER_INST}/${ORA_EDITION}

#
chown oracle.oinstall -R /u01/app/oracle
chown oracle.oinstall -R /u01/app/oracle/product/${ORA_VER_INST}
#
# chown oracle.oinstall /u01/app/oraInventory/
 

# ------------------------------------------------------------------------
# Configuration
# ------------------------------------------------------------------------

su - grid

# ------------------------------------------------------------------------
# Version Variable
#

ORA_VER_INST="11.2.0.4"
ORA_VER_INST="12.1.0.2"
ORA_VER_INST="12.2.0.1"
ORA_VER_INST="12.2.0.2"
ORA_VER_INST="18.1.0.1"
ORA_VER_INST="18.1.0.2"
ORA_VER_INST="18.2.0.1"
ORA_VER_INST="18.2.0.2"
ORA_VER_INST="18.3.0.1"
ORA_VER_INST="18.3.0.2"
ORA_VER_INST="18.4.0.1"
ORA_VER_INST="19.1.0.1"
ORA_VER_INST="19.2.0.2"
ORA_VER_INST="19.3.0.1"

# ------------------------------------------------------------------------
# Oracle Edition
#

ORA_EDITION="db_SE_01"
ORA_EDITION="db_SE1_01"
ORA_EDITION="db_SE2_01"
ORA_EDITION="db_EE_01"
ORA_EDITION="db_PE_01"
ORA_EDITION="db_XE_01"

#
# ------------------------------------------------------------------------
# SRV01 - GRID
# ------------------------------------------------------------------------
#

cat > /home/grid/.asm <<EOF
# Variables Of Environment ORACLE [ GRID ]
export TMP=/tmp
export TMPDIR=\${TMP}
export HOST=\`hostname\`
export HOSTNAME=\`hostname -a\`
export UPTIME=\`uptime | sed 's/.*up \([^,]*\), .*/\1/'\`
export ORACLE_HOSTNAME=\${HOST}
export ORACLE_BASE=/u01/app/grid
export ORACLE_VERSION=${ORA_VER_INST}
export GRID_HOME=/u01/app/\${ORACLE_VERSION}/grid
export ORACLE_HOME=\${GRID_HOME}
export OH=\${ORACLE_HOME}
export DBS=\${ORACLE_HOME}/dbs
export TNS=\${ORACLE_HOME}/network/admin
export ORACLE_SID=+ASM
export ORACLE_TERM=xterm
export OPATCH=\${ORACLE_HOME}/OPatch
export JAVA_HOME=\${ORACLE_HOME}/jdk
export PS1=\$'[ \${ORACLE_SID} ]|[ \${LOGNAME}@\h:\`pwd\`: ]\$ '
export PATH=\${PATH}:/usr/sbin:/usr/bin:/sbin:/bin:\${ORACLE_HOME}/bin:\${GRID_HOME}/bin:\${OPATCH}:\${ORACLE_HOME}/perl/bin:\${JAVA_HOME}/bin
export LD_LIBRARY_PATH=\${ORACLE_HOME}/lib:\${ORACLE_HOME}/perl/lib:\${GRID_HOME}/lib:/lib:/usr/lib
export CLASSPATH=\${ORACLE_HOME}/JRE:\${ORACLE_HOME}/jlib:\${ORACLE_HOME}/rdbms/jlib
export ALERTASM=\${ORACLE_BASE}/diag/asm/+asm/\${ORACLE_SID}/trace/alert_\${ORACLE_SID}.log
export LSNRCTL=\`ps -ef | grep tnslsnr | grep -v "grep" | wc -l\`
alias asmlog='tail -f \${ALERTASM}'
alias sqlplus='rlwrap sqlplus'
alias s='rlwrap sqlplus / as sysasm'
alias rman='rlwrap rman'
alias r='rlwrap rman target /'
alias asmcmd='rlwrap asmcmd -p'
alias a='rlwrap asmcmd -p'
alias adrci='rlwrap adrci'
alias ad='rlwrap adrci'
alias p='ps -ef | grep pmon | grep -v grep'
alias l='rlwrap lsnrctl status'
alias rest='crsctl stat res -t -init'
alias res='crsctl stat res -t'
alias wr='watch -d crsctl stat res -t'
alias meminfo='free -m -l -t'
alias psmem='ps auxf | sort -nr -k 4'
alias psmem10='ps auxf | sort -nr -k 4 | head -10'
alias pscpu='ps auxf | sort -nr -k 3'
alias pscpu10='ps auxf | sort -nr -k 3 | head -10'
alias cpuinfo='lscpu'
umask 0022
clear
if [[ \${ORACLE_SID} = \`ps -ef | grep pmon | grep -i \${ORACLE_SID} | awk '{ print \$NF }' | sed s/asm_pmon_//g\` ]]
then
  DB_STATUS="ONLINE"
else
  DB_STATUS="OFFLINE"
fi
if [ \${LSNRCTL} != 0 ]
then
  DB_LISTNER="ONLINE"
else
  DB_LISTNER="OFFLINE"
fi
echo ">----------------------------------------------------------------------------------------------"
echo "# SERVER_UPTIME.....: [ \${UPTIME} ]"
echo "# ORACLE_BASE.......: [ \${ORACLE_BASE} ]"
echo "# ORACLE_HOME.......: [ \${ORACLE_HOME} ]"
echo "# ORACLE_VERSION....: [ \${ORACLE_VERSION} ]"
echo "# ORACLE_SID........: [ \${ORACLE_SID} ]"
echo "# DATABASE_STATUS...: [ \${DB_STATUS} ]"
echo "# LISTENER_STATUS...: [ \${DB_LISTNER} ]"
echo ">----------------------------------------------------------------------------------------------"
EOF

# ------------------------------------------------------------------------
# Configure the Environment of Grid per File
# ------------------------------------------------------------------------
chown grid.oinstall /home/grid/.asm
echo ". /home/grid/.asm" >> /home/grid/.bash_profile

Thursday, December 3, 2020

Preparing Linux to install Oracle Products

# ---------------------------------------------------------------------
# Setup the ROOT Environment
# ---------------------------------------------------------------------
#

cat > /root/.bash_profile <<EOF
# Get the aliases and functions
if [ -f ~/.bashrc ]; then
      . ~/.bashrc
fi

# User specific environment and startup programs
export PS1=\$'[ \${LOGNAME}@\h:\`pwd\`: ]\$ '
export GRID_VERSION=19.3.0.1
export ORACLE_BASE=/u01/app/grid
export GRID_HOME=/u01/app/\${GRID_VERSION}/grid
export ORACLE_HOME=\${GRID_HOME}
export OPATCH=\${ORACLE_HOME}/OPatch
export JAVA_HOME=\${ORACLE_HOME}/jdk
export PATH=\${PATH}:\${HOME}/bin:\${GRID_HOME}/bin:\${OPATCH}:\${JAVA_HOME}/bin
EOF

. .bash_profile

# ---------------------------------------------------------------------
# OEL 7 and 8
# ---------------------------------------------------------------------
hostnamectl set hostname srv01.dbnitro.net --stats

# ---------------------------------------------------------------------
# OR
# ---------------------------------------------------------------------

vim /etc/hosts

# OR

echo "192.168.56.10   srv01.dbnitro.net   srv01"  >> /etc/hosts

# ---------------------------------------------------------------------
# OEL 7 and 8
# ---------------------------------------------------------------------systemctl stop firewalld
systemctl disable firewalld

# ---------------------------------------------------------------------
# yum -y install chrony
# ---------------------------------------------------------------------
systemctl enable chronyd.service
systemctl status chronyd.service
systemctl start chronyd.service
systemctl restart chronyd.service
systemctl status chronyd.service

# ---------------------------------------------------------------------
# Install EPEL for OL7
# ---------------------------------------------------------------------
rpm -Uvh https://dl.fedoraproject.org/pub/epel/epel-release-latest-7.noarch.rpm

# ---------------------------------------------------------------------
# Install EPEL for OL8
# ---------------------------------------------------------------------
rpm -Uvh https://dl.fedoraproject.org/pub/epel/epel-release-latest-8.noarch.rpm

# ---------------------------------------------------------------------# JAVA
# ---------------------------------------------------------------------
yum -y install java-1.8.0-openjdk-devel.x86_64 java-1.8.0-openjdk.x86_64

# ---------------------------------------------------------------------
dnf -y install java-1.8.0-openjdk-devel.x86_64 java-1.8.0-openjdk.x86_64

# ---------------------------------------------------------------------
# Update the Linux and Kernel
# ---------------------------------------------------------------------
yum -y upgrade

# ---------------------------------------------------------------------
# OEL 7 ---> https://yum.oracle.com/repo/OracleLinux/OL7/baseos/latest/x86_64/index.html

# ---------------------------------------------------------------------
# Verify Installed Packages
# ---------------------------------------------------------------------
rpm -q --qf '%{NAME}-%{VERSION}-%{RELEASE} (%{ARCH})\n' atop bc.x86_64 beakerlib-vim-syntax binutils bind-utils bzip2-devel.x86_64 bzip2-libs.x86_64 bzip2.x86_64 chrony cpp compat-libstdc++-33 compat-libcap1 dialog elinks elfutils-libelf elfutils-libelf-devel epel-release.noarch firefox gcc gcc-c++ glances glibc glibc-common glibc-devel glibc-headers htop iotop iptraf-ng iscsi-initiator-utils iscsi-initiator-utils-iscsiuio lsscsi libiscsi netbsd-iscsi targetcli ksh libaio libaio-devel libgcc libstdc++ libstdc++-devel libiscsi libXtst libXtst-devel lm_sensors lsof make mlocate nawk.x86_64 net-tools ntp nfs-utils nmap perl perl-DBI perl-TermReadKey perl-ExtUtils-MakeMaker perl-CPAN perl-CGI perl-URI.noarch psmisc readline-devel rlwrap smartmontools sos cockpit sysstat telnet tuned tuned-utils unixODBC unixODBC-devel unzip vim-X11 vim-common vim-enhanced vim-filesystem vim-minimal wget xorg-x11-server-Xorg xorg-x11-server-common xorg-x11-utils xorg-x11-apps xorg-x11-xauth xterm.x86_64 whois | egrep "is not installed"
rpm -q --qf '%{NAME}-%{VERSION}-%{RELEASE} (%{ARCH})\n' kmod-oracleasm.x86_64      --->   NOT NECESSARY FOR AFD/ACFS
rpm -q --qf '%{NAME}-%{VERSION}-%{RELEASE} (%{ARCH})\n' oracleasm-support.x86_64   --->   NOT NECESSARY FOR AFD/ACFS
rpm -q --qf '%{NAME}-%{VERSION}-%{RELEASE} (%{ARCH})\n' oracleasmlib.x86_64        --->   NOT NECESSARY FOR AFD/ACFS
rpm -q --qf '%{NAME}-%{VERSION}-%{RELEASE} (%{ARCH})\n' ocfs2-tools.x86_64
rpm -q --qf '%{NAME}-%{VERSION}-%{RELEASE} (%{ARCH})\n' oracle-rdbms-server-11gR2-preinstall.x86_64
rpm -q --qf '%{NAME}-%{VERSION}-%{RELEASE} (%{ARCH})\n' oracle-rdbms-server-12cR1-preinstall.x86_64
rpm -q --qf '%{NAME}-%{VERSION}-%{RELEASE} (%{ARCH})\n' oracle-database-server-12cR2-preinstall.x86_64
rpm -q --qf '%{NAME}-%{VERSION}-%{RELEASE} (%{ARCH})\n' oracle-database-preinstall-18c.x86_64
rpm -q --qf '%{NAME}-%{VERSION}-%{RELEASE} (%{ARCH})\n' oracle-database-preinstall-19c.x86_64

# ---------------------------------------------------------------------
# Install Packages
# ---------------------------------------------------------------------
yum -y install atop bc.x86_64 beakerlib-vim-syntax binutils bind-utils bzip2-devel.x86_64 bzip2-libs.x86_64 bzip2.x86_64 chrony cpp compat-libstdc++-33 compat-libcap1 dialog elinks elfutils-libelf elfutils-libelf-devel epel-release.noarch firefox gcc gcc-c++ glances glibc glibc-common glibc-devel glibc-headers htop iotop iptraf-ng iscsi-initiator-utils iscsi-initiator-utils-iscsiuio lsscsi libiscsi netbsd-iscsi targetcli ksh libaio libaio-devel libgcc libstdc++ libstdc++-devel libiscsi libXtst libXtst-devel lm_sensors lsof make mlocate nawk.x86_64 net-tools ntp nfs-utils nmap perl perl-DBI perl-TermReadKey perl-ExtUtils-MakeMaker perl-CPAN perl-CGI perl-URI.noarch psmisc readline-devel rlwrap smartmontools sos cockpit sysstat telnet tuned tuned-utils unixODBC unixODBC-devel unzip vim-X11 vim-common vim-enhanced vim-filesystem vim-minimal wget xorg-x11-server-Xorg xorg-x11-server-common xorg-x11-utils xorg-x11-apps xorg-x11-xauth xterm.x86_64 whois
yum -y install kmod-oracleasm.x86_64      --->   NOT NECESSARY FOR AFD/ACFS
yum -y install oracleasm-support.x86_64   --->   NOT NECESSARY FOR AFD/ACFS
yum -y install oracleasmlib.x86_64        --->   NOT NECESSARY FOR AFD/ACFS
yum -y install ocfs2-tools.x86_64
yum -y install oracle-rdbms-server-11gR2-preinstall.x86_64
yum -y install oracle-rdbms-server-12cR1-preinstall.x86_64
yum -y install oracle-database-server-12cR2-preinstall.x86_64
yum -y install oracle-database-preinstall-18c.x86_64
yum -y install oracle-database-preinstall-19c.x86_64


# ------------------------------------------------------------------------
# Set parameters on /etc/hosts on Single Instance
# ------------------------------------------------------------------------
#
echo "#"                                                                                                                     >> /etc/hosts
echo "`ifconfig -a | grep inet | awk '{ print $2 }' | head -2 | grep -v 127.0.0.1 | head -1`   `hostname`   `hostname -s`"   >> /etc/hosts

# ------------------------------------------------------------------------
# Disable SELINUX
# ------------------------------------------------------------------------
#

cat > /etc/sysconfig/selinux <<EOF
# This file controls the state of SELinux on the system.
# SELINUX= can take one of these three values:
#     enforcing - SELinux security policy is enforced.
#     permissive - SELinux prints warnings instead of enforcing.
#     disabled - No SELinux policy is loaded.
SELINUX=disabled
# SELINUXTYPE= can take one of these two values:
#     targeted - Targeted processes are protected,
#     mls - Multi Level Security protection.
SELINUXTYPE=targeted
EOF

# ------------------------------------------------------------------------
# Configure limits.conf
# ------------------------------------------------------------------------
#

cat >> /etc/security/limits.conf <<EOF
#
# Oracle Limits Configuration
#
* soft nproc 2047
* hard nproc 16384
* soft nofile 65536
* hard nofile 65536
* soft stack 10240
* hard stack 32768
* soft memlock 60397977
* hard memlock 60397977
EOF

# ------------------------------------------------------------------------
# Create the Groups and Users
# ------------------------------------------------------------------------
# ODA Environment
#

----------------------------------------------------------------------------------------------------------------------
Groups      Group Name      Group ID   Grid is a member           Oracle is a member       Agent is a member
----------- --------------- ---------- -----------------------    ---------------------    -----------------------
oinstall    oinstall        54321      yes (primary group)        yes (primary group)      yes (primary group)
osdba       dba             54322      yes                        yes                      yes
osdba       oper            54323      no                         yes                      yes
osbkpdba    backupdba       54324      no                         yes                      yes
osdba       asmdba          54325      yes                        yes                      yes
osdgdba     dgdba           54326      no                         yes                      yes
osdba       kmdba           54327      no                         yes                      yes
osasm       asmadmin        54328      yes                        no                       no
osoper      asmoper         54329      yes                        no                       yes
osracdba    racdba          54330      yes                        yes                      no
osoper      racoper         54331      yes                        yes                      yes

--------------------------------------------------------------------------------------------------------------------

# ------------------------------------------------------------------------
# Groups ( yum -y install system-config-users )
# ------------------------------------------------------------------------
#
/usr/sbin/groupadd -g 54321 oinstall
/usr/sbin/groupadd -g 54322 dba
/usr/sbin/groupadd -g 54323 oper
/usr/sbin/groupadd -g 54324 backupdba
/usr/sbin/groupadd -g 54325 asmdba
/usr/sbin/groupadd -g 54326 dgdba
/usr/sbin/groupadd -g 54327 kmdba
/usr/sbin/groupadd -g 54328 asmadmin
/usr/sbin/groupadd -g 54329 asmoper
/usr/sbin/groupadd -g 54330 racdba
/usr/sbin/groupadd -g 54331 racoper

/usr/sbin/useradd -u 54321 -g oinstall -G dba,oper,backupdba,asmdba,dgdba,kmdba,racdba,racoper oracle
/usr/sbin/useradd -u 54322 -g oinstall -G dba,asmdba,asmadmin,asmoper,racdba,racoper grid

# ------------------------------------------------------------------------
# Create Users Password
# ------------------------------------------------------------------------
# Password
#

passwd grid
passwd oracle

# OR

echo 'oracle:oracle' | chpasswd
echo 'grid:grid' | chpasswd

# ------------------------------------------------------------------------
# Install the Pre-Install Package for Databases
yum -y install oracle-database-preinstall-19c.x86_64


# ------------------------------------------------------------------------
# Validate the Kernel Parameters
sysctl -p

# ------------------------------------------------------------------------
# Creating Directories to Grid and Database Installation
# ------------------------------------------------------------------------
# General Folders
# ------------------------------------------------------------------------

mkdir -p /u01/app/oraInventory
#
mkdir -p /u01/app/grid
mkdir -p /u01/app/grid/diag
#
mkdir -p /u01/app/oracle
mkdir -p /u01/app/oracle/diag
#
chown -R grid.oinstall /u01
chown -R grid.oinstall /u01/app/grid
chown -R grid.oinstall /u01/app/grid/diag
#
chown -R oracle.oinstall /u01/app/oracle
chown -R oracle.oinstall /u01/app/oracle/diag
#
chmod -R 775 /u01/

 ------------------------------------------------------------------------
# Mount tmpfs automatically on Linux
# ------------------------------------------------------------------------
# Create the folders to Grid and Database
# Change the permission to GRID (verify if is necessary re-run this part of the script after Grid installation)
# ------------------------------------------------------------------------
# Grid (Verify this configuration before the Grid Installation)
# ------------------------------------------------------------------------
# Used to Manage Auto Memory

# mount -t tmpfs shmfs -o size=16g /dev/shm

#

echo "shmfs                                     /dev/shm                tmpfs   size=16g        0 0" >> /etc/fstab

#

mount -a


Thursday, August 27, 2020

ORACLE DATABASE IN 3 COMMAND LINES "ONLY" (Versions XE 18c and EE 19c).

Hello, I created this post to help people to create an easy and fast Oracle Database environment to test some commands, sql statements, backup and restore or just to learn something new. The goal here is to create one linux vm, as easy and simple as possible, than install and create an Oracle Database, with that you can use the learn and test almost all functionalities and increase your knowledge. If you find something wrong here, please inform me via comments or via email.

I hope you can learn something really helpful here, like it was for me.

# ----------------------------------

# Create a VM using VirtualBox.

# ----------------------------------
# The idea is create a VM as simple as possible. In this demonstration LAB that I am creating here, will fit for the versions XE and EE as well, we can have the same VM/Linux Installation for both tests.

# ----------------------------------
# VM Creating.
# ----------------------------------

OS: Oracle Linux 7.8 x86_64
Memory: 4 GB
SWAP: 8GB
DISKS: 1 Disk of 50GB
FS: XFS
Packages: BASIC (It's not necessary others package for this LAB during this installation).


# After installation of Linux on this VM, you can configure the "/etc/hosts" with the name of the server and the it's ip, this step is mandatory for the database creation.

# ----------------------------------
# 18c (Version XE)
# ----------------------------------
# To install all necessary packages on Linux, just execute this command, just it and all necessary packages will be installed for the Oracle Softwares.

yum -y install oracle-database-preinstall-18c-1.0-1.el7.x86_64.rpm

# OR

yum -y install oracle-database-preinstall-18c.x86_64


# ----------------------------------

# To install the Oracle XE software, just download and save the RPM Package, use this link to download it: 
https://download.oracle.com/otn-pub/otn_software/db-express/oracle-database-xe-18c-1.0-1.x86_64.rpm

# ----------------------------------
# Once the download it's done, just execute this command to install the Oracle XE Software.

yum -y localinstall /tmp/oracle-database-xe-18c-1.0-1.x86_64.rpm


# ----------------------------------

# After the installation process is done, we have to create the database, just execute that command and the database will be created, the SID will be: XE

/etc/init.d/oracle-xe-18c configure


# ----------------------------------

# This command asks you to insert the password of this instance.

# ----------------------------------
# That is it, after the database creation, you have to connect on the Oracle User, and connect on the database using sqlplus, (don't forget to setup the variables using . oraenv).

su – oracle

. oraenv <<< XE

sqlplus / as sysdba

select host_name
  , instance_number
  , instance_name
  , version
  , version_full
  , status
  , database_status
  , instance_role
  , instance_mode
  , database_type
  , edition 
from gv$instance
order by 1, 2;


# Look my example here!!!

# ----------------------------------

# Installation of Oracle XE

Last failed login: Thu Aug 27 14:30:18 CEST 2020 from 192.168.56.1 on ssh:notty
There was 1 failed login attempt since the last successful login.
Last login: Thu Aug 27 14:28:07 2020

# ----------------------------------
# Install the pre-install package

[root@oel7-ora-xe ~]# yum -y install oracle-database-preinstall-18c-1.0-1.el7.x86_64
Loaded plugins: ulninfo
ol7_UEKR5                                                                                | 2.5 kB  00:00:00
ol7_latest                                                                               | 2.7 kB  00:00:00
(1/5): ol7_latest/x86_64/group                                                           | 660 kB  00:00:00
(2/5): ol7_UEKR5/x86_64/updateinfo                                                       |  72 kB  00:00:00
(3/5): ol7_latest/x86_64/updateinfo                                                      | 2.9 MB  00:00:00
(4/5): ol7_UEKR5/x86_64/primary_db                                                       |  12 MB  00:00:00
(5/5): ol7_latest/x86_64/primary_db                                                      |  36 MB  00:00:00
Resolving Dependencies
--> Running transaction check
---> Package oracle-database-preinstall-18c.x86_64 0:1.0-1.el7 will be installed
--> Processing Dependency: bc for package: oracle-database-preinstall-18c-1.0-1.el7.x86_64
--> Processing Dependency: sysstat for package: oracle-database-preinstall-18c-1.0-1.el7.x86_64
--> Processing Dependency: xorg-x11-utils for package: oracle-database-preinstall-18c-1.0-1.el7.x86_64
--> Processing Dependency: bind-utils for package: oracle-database-preinstall-18c-1.0-1.el7.x86_64
--> Processing Dependency: net-tools for package: oracle-database-preinstall-18c-1.0-1.el7.x86_64
--> Processing Dependency: compat-libcap1 for package: oracle-database-preinstall-18c-1.0-1.el7.x86_64
--> Processing Dependency: ksh for package: oracle-database-preinstall-18c-1.0-1.el7.x86_64
--> Processing Dependency: libaio-devel for package: oracle-database-preinstall-18c-1.0-1.el7.x86_64
--> Processing Dependency: xorg-x11-xauth for package: oracle-database-preinstall-18c-1.0-1.el7.x86_64
--> Processing Dependency: libaio for package: oracle-database-preinstall-18c-1.0-1.el7.x86_64
--> Processing Dependency: psmisc for package: oracle-database-preinstall-18c-1.0-1.el7.x86_64
--> Processing Dependency: unzip for package: oracle-database-preinstall-18c-1.0-1.el7.x86_64
--> Processing Dependency: glibc-devel for package: oracle-database-preinstall-18c-1.0-1.el7.x86_64
--> Processing Dependency: compat-libstdc++-33 for package: oracle-database-preinstall-18c-1.0-1.el7.x86_64
--> Processing Dependency: libstdc++-devel for package: oracle-database-preinstall-18c-1.0-1.el7.x86_64
--> Processing Dependency: nfs-utils for package: oracle-database-preinstall-18c-1.0-1.el7.x86_64
--> Processing Dependency: smartmontools for package: oracle-database-preinstall-18c-1.0-1.el7.x86_64
--> Running transaction check
---> Package bc.x86_64 0:1.06.95-13.el7 will be installed
---> Package bind-utils.x86_64 32:9.11.4-16.P2.el7_8.6 will be installed
--> Processing Dependency: bind-libs(x86-64) = 32:9.11.4-16.P2.el7_8.6 for package: 32:bind-utils-9.11.4-16.P2.el7_8.6.x86_64
--> Processing Dependency: bind-libs-lite(x86-64) = 32:9.11.4-16.P2.el7_8.6 for package: 32:bind-utils-9.11.4-16.P2.el7_8.6.x86_64
--> Processing Dependency: libisc.so.169()(64bit) for package: 32:bind-utils-9.11.4-16.P2.el7_8.6.x86_64
--> Processing Dependency: libdns.so.1102()(64bit) for package: 32:bind-utils-9.11.4-16.P2.el7_8.6.x86_64
--> Processing Dependency: libisccfg.so.160()(64bit) for package: 32:bind-utils-9.11.4-16.P2.el7_8.6.x86_64
--> Processing Dependency: liblwres.so.160()(64bit) for package: 32:bind-utils-9.11.4-16.P2.el7_8.6.x86_64
--> Processing Dependency: libGeoIP.so.1()(64bit) for package: 32:bind-utils-9.11.4-16.P2.el7_8.6.x86_64
--> Processing Dependency: libirs.so.160()(64bit) for package: 32:bind-utils-9.11.4-16.P2.el7_8.6.x86_64
--> Processing Dependency: libbind9.so.160()(64bit) for package: 32:bind-utils-9.11.4-16.P2.el7_8.6.x86_64
---> Package compat-libcap1.x86_64 0:1.10-7.el7 will be installed
---> Package compat-libstdc++-33.x86_64 0:3.2.3-72.el7 will be installed
---> Package glibc-devel.x86_64 0:2.17-307.0.1.el7.1 will be installed
--> Processing Dependency: glibc-headers = 2.17-307.0.1.el7.1 for package: glibc-devel-2.17-307.0.1.el7.1.x86_64
--> Processing Dependency: glibc-headers for package: glibc-devel-2.17-307.0.1.el7.1.x86_64
---> Package ksh.x86_64 0:20120801-142.0.1.el7 will be installed
---> Package libaio.x86_64 0:0.3.109-13.el7 will be installed
---> Package libaio-devel.x86_64 0:0.3.109-13.el7 will be installed
---> Package libstdc++-devel.x86_64 0:4.8.5-39.0.5.el7 will be installed
--> Processing Dependency: libstdc++(x86-64) = 4.8.5-39.0.5.el7 for package: libstdc++-devel-4.8.5-39.0.5.el7.x86_64
---> Package net-tools.x86_64 0:2.0-0.25.20131004git.el7 will be installed
---> Package nfs-utils.x86_64 1:1.3.0-0.66.0.1.el7_8 will be installed
--> Processing Dependency: gssproxy >= 0.7.0-3 for package: 1:nfs-utils-1.3.0-0.66.0.1.el7_8.x86_64
--> Processing Dependency: libtirpc >= 0.2.4-0.7 for package: 1:nfs-utils-1.3.0-0.66.0.1.el7_8.x86_64
--> Processing Dependency: rpcbind for package: 1:nfs-utils-1.3.0-0.66.0.1.el7_8.x86_64
--> Processing Dependency: keyutils for package: 1:nfs-utils-1.3.0-0.66.0.1.el7_8.x86_64
--> Processing Dependency: libevent for package: 1:nfs-utils-1.3.0-0.66.0.1.el7_8.x86_64
--> Processing Dependency: libnfsidmap for package: 1:nfs-utils-1.3.0-0.66.0.1.el7_8.x86_64
--> Processing Dependency: quota for package: 1:nfs-utils-1.3.0-0.66.0.1.el7_8.x86_64
--> Processing Dependency: libevent-2.0.so.5()(64bit) for package: 1:nfs-utils-1.3.0-0.66.0.1.el7_8.x86_64
--> Processing Dependency: libtirpc.so.1()(64bit) for package: 1:nfs-utils-1.3.0-0.66.0.1.el7_8.x86_64
--> Processing Dependency: libnfsidmap.so.0()(64bit) for package: 1:nfs-utils-1.3.0-0.66.0.1.el7_8.x86_64
---> Package psmisc.x86_64 0:22.20-16.el7 will be installed
---> Package smartmontools.x86_64 1:7.0-2.el7 will be installed
--> Processing Dependency: mailx for package: 1:smartmontools-7.0-2.el7.x86_64
---> Package sysstat.x86_64 0:10.1.5-19.el7 will be installed
--> Processing Dependency: libsensors.so.4()(64bit) for package: sysstat-10.1.5-19.el7.x86_64
---> Package unzip.x86_64 0:6.0-21.el7 will be installed
---> Package xorg-x11-utils.x86_64 0:7.5-23.el7 will be installed
--> Processing Dependency: libXext.so.6()(64bit) for package: xorg-x11-utils-7.5-23.el7.x86_64
--> Processing Dependency: libXv.so.1()(64bit) for package: xorg-x11-utils-7.5-23.el7.x86_64
--> Processing Dependency: libXtst.so.6()(64bit) for package: xorg-x11-utils-7.5-23.el7.x86_64
--> Processing Dependency: libXrender.so.1()(64bit) for package: xorg-x11-utils-7.5-23.el7.x86_64
--> Processing Dependency: libXxf86vm.so.1()(64bit) for package: xorg-x11-utils-7.5-23.el7.x86_64
--> Processing Dependency: libXxf86misc.so.1()(64bit) for package: xorg-x11-utils-7.5-23.el7.x86_64
--> Processing Dependency: libX11-xcb.so.1()(64bit) for package: xorg-x11-utils-7.5-23.el7.x86_64
--> Processing Dependency: libXrandr.so.2()(64bit) for package: xorg-x11-utils-7.5-23.el7.x86_64
--> Processing Dependency: libdmx.so.1()(64bit) for package: xorg-x11-utils-7.5-23.el7.x86_64
--> Processing Dependency: libXinerama.so.1()(64bit) for package: xorg-x11-utils-7.5-23.el7.x86_64
--> Processing Dependency: libX11.so.6()(64bit) for package: xorg-x11-utils-7.5-23.el7.x86_64
--> Processing Dependency: libXxf86dga.so.1()(64bit) for package: xorg-x11-utils-7.5-23.el7.x86_64
--> Processing Dependency: libxcb.so.1()(64bit) for package: xorg-x11-utils-7.5-23.el7.x86_64
--> Processing Dependency: libxcb-shape.so.0()(64bit) for package: xorg-x11-utils-7.5-23.el7.x86_64
--> Processing Dependency: libXi.so.6()(64bit) for package: xorg-x11-utils-7.5-23.el7.x86_64
---> Package xorg-x11-xauth.x86_64 1:1.0.9-1.el7 will be installed
--> Processing Dependency: libXau.so.6()(64bit) for package: 1:xorg-x11-xauth-1.0.9-1.el7.x86_64
--> Processing Dependency: libXmuu.so.1()(64bit) for package: 1:xorg-x11-xauth-1.0.9-1.el7.x86_64
--> Running transaction check
---> Package GeoIP.x86_64 0:1.5.0-14.el7 will be installed
--> Processing Dependency: geoipupdate for package: GeoIP-1.5.0-14.el7.x86_64
---> Package bind-libs.x86_64 32:9.11.4-16.P2.el7_8.6 will be installed
--> Processing Dependency: bind-license = 32:9.11.4-16.P2.el7_8.6 for package: 32:bind-libs-9.11.4-16.P2.el7_8.6.x86_64
---> Package bind-libs-lite.x86_64 32:9.11.4-16.P2.el7_8.6 will be installed
---> Package glibc-headers.x86_64 0:2.17-307.0.1.el7.1 will be installed
--> Processing Dependency: kernel-headers >= 2.2.1 for package: glibc-headers-2.17-307.0.1.el7.1.x86_64
--> Processing Dependency: kernel-headers for package: glibc-headers-2.17-307.0.1.el7.1.x86_64
---> Package gssproxy.x86_64 0:0.7.0-28.el7 will be installed
--> Processing Dependency: libini_config >= 1.3.1-31 for package: gssproxy-0.7.0-28.el7.x86_64
--> Processing Dependency: libref_array.so.1(REF_ARRAY_0.1.1)(64bit) for package: gssproxy-0.7.0-28.el7.x86_64
--> Processing Dependency: libini_config.so.3(INI_CONFIG_1.1.0)(64bit) for package: gssproxy-0.7.0-28.el7.x86_64
--> Processing Dependency: libini_config.so.3(INI_CONFIG_1.2.0)(64bit) for package: gssproxy-0.7.0-28.el7.x86_64
--> Processing Dependency: libverto-module-base for package: gssproxy-0.7.0-28.el7.x86_64
--> Processing Dependency: libini_config.so.3()(64bit) for package: gssproxy-0.7.0-28.el7.x86_64
--> Processing Dependency: libbasicobjects.so.0()(64bit) for package: gssproxy-0.7.0-28.el7.x86_64
--> Processing Dependency: libref_array.so.1()(64bit) for package: gssproxy-0.7.0-28.el7.x86_64
--> Processing Dependency: libcollection.so.2()(64bit) for package: gssproxy-0.7.0-28.el7.x86_64
---> Package keyutils.x86_64 0:1.5.8-3.el7 will be installed
---> Package libX11.x86_64 0:1.6.7-2.el7 will be installed
--> Processing Dependency: libX11-common >= 1.6.7-2.el7 for package: libX11-1.6.7-2.el7.x86_64
---> Package libXau.x86_64 0:1.0.8-2.1.el7 will be installed
---> Package libXext.x86_64 0:1.3.3-3.el7 will be installed
---> Package libXi.x86_64 0:1.7.9-1.el7 will be installed
---> Package libXinerama.x86_64 0:1.1.3-2.1.el7 will be installed
---> Package libXmu.x86_64 0:1.1.2-2.el7 will be installed
--> Processing Dependency: libXt.so.6()(64bit) for package: libXmu-1.1.2-2.el7.x86_64
---> Package libXrandr.x86_64 0:1.5.1-2.el7 will be installed
---> Package libXrender.x86_64 0:0.9.10-1.el7 will be installed
---> Package libXtst.x86_64 0:1.2.3-1.el7 will be installed
---> Package libXv.x86_64 0:1.0.11-1.el7 will be installed
---> Package libXxf86dga.x86_64 0:1.1.4-2.1.el7 will be installed
---> Package libXxf86misc.x86_64 0:1.0.3-7.1.el7 will be installed
---> Package libXxf86vm.x86_64 0:1.1.4-1.el7 will be installed
---> Package libdmx.x86_64 0:1.1.3-3.el7 will be installed
---> Package libevent.x86_64 0:2.0.21-4.el7 will be installed
---> Package libnfsidmap.x86_64 0:0.25-19.el7 will be installed
---> Package libstdc++.x86_64 0:4.8.5-39.0.3.el7 will be updated
---> Package libstdc++.x86_64 0:4.8.5-39.0.5.el7 will be an update
---> Package libtirpc.x86_64 0:0.2.4-0.16.el7 will be installed
---> Package libxcb.x86_64 0:1.13-1.el7 will be installed
---> Package lm_sensors-libs.x86_64 0:3.4.0-8.20160601gitf9185e5.el7 will be installed
---> Package mailx.x86_64 0:12.5-19.el7 will be installed
---> Package quota.x86_64 1:4.01-19.el7 will be installed
--> Processing Dependency: quota-nls = 1:4.01-19.el7 for package: 1:quota-4.01-19.el7.x86_64
--> Processing Dependency: tcp_wrappers for package: 1:quota-4.01-19.el7.x86_64
---> Package rpcbind.x86_64 0:0.2.0-49.el7 will be installed
--> Running transaction check
---> Package bind-license.noarch 32:9.11.4-16.P2.el7_8.6 will be installed
---> Package geoipupdate.x86_64 0:2.5.0-1.el7 will be installed
---> Package kernel-headers.x86_64 0:3.10.0-1127.19.1.el7 will be installed
---> Package libX11-common.noarch 0:1.6.7-2.el7 will be installed
---> Package libXt.x86_64 0:1.1.5-3.el7 will be installed
--> Processing Dependency: libICE.so.6()(64bit) for package: libXt-1.1.5-3.el7.x86_64
--> Processing Dependency: libSM.so.6()(64bit) for package: libXt-1.1.5-3.el7.x86_64
---> Package libbasicobjects.x86_64 0:0.1.1-32.el7 will be installed
---> Package libcollection.x86_64 0:0.7.0-32.el7 will be installed
---> Package libini_config.x86_64 0:1.3.1-32.el7 will be installed
--> Processing Dependency: libpath_utils.so.1(PATH_UTILS_0.2.1)(64bit) for package: libini_config-1.3.1-32.el7.x86_64
--> Processing Dependency: libpath_utils.so.1()(64bit) for package: libini_config-1.3.1-32.el7.x86_64
---> Package libref_array.x86_64 0:0.1.5-32.el7 will be installed
---> Package libverto-libevent.x86_64 0:0.2.5-4.el7 will be installed
---> Package quota-nls.noarch 1:4.01-19.el7 will be installed
---> Package tcp_wrappers.x86_64 0:7.6-77.el7 will be installed
--> Running transaction check
---> Package libICE.x86_64 0:1.0.9-9.el7 will be installed
---> Package libSM.x86_64 0:1.2.2-2.el7 will be installed
---> Package libpath_utils.x86_64 0:0.2.1-32.el7 will be installed
--> Finished Dependency Resolution
Dependencies Resolved
================================================================================================================
 Package                              Arch         Version                               Repository        Size
================================================================================================================
Installing:
 oracle-database-preinstall-18c       x86_64       1.0-1.el7                             ol7_latest        18 k
Installing for dependencies:
 GeoIP                                x86_64       1.5.0-14.el7                          ol7_latest       1.5 M
 bc                                   x86_64       1.06.95-13.el7                        ol7_latest       114 k
 bind-libs                            x86_64       32:9.11.4-16.P2.el7_8.6               ol7_latest       155 k
 bind-libs-lite                       x86_64       32:9.11.4-16.P2.el7_8.6               ol7_latest       1.1 M
 bind-license                         noarch       32:9.11.4-16.P2.el7_8.6               ol7_latest        89 k
 bind-utils                           x86_64       32:9.11.4-16.P2.el7_8.6               ol7_latest       259 k
 compat-libcap1                       x86_64       1.10-7.el7                            ol7_latest        17 k
 compat-libstdc++-33                  x86_64       3.2.3-72.el7                          ol7_latest       190 k
 geoipupdate                          x86_64       2.5.0-1.el7                           ol7_latest        34 k
 glibc-devel                          x86_64       2.17-307.0.1.el7.1                    ol7_latest       1.1 M
 glibc-headers                        x86_64       2.17-307.0.1.el7.1                    ol7_latest       691 k
 gssproxy                             x86_64       0.7.0-28.el7                          ol7_latest       110 k
 kernel-headers                       x86_64       3.10.0-1127.19.1.el7                  ol7_latest       9.0 M
 keyutils                             x86_64       1.5.8-3.el7                           ol7_latest        53 k
 ksh                                  x86_64       20120801-142.0.1.el7                  ol7_latest       882 k
 libICE                               x86_64       1.0.9-9.el7                           ol7_latest        66 k
 libSM                                x86_64       1.2.2-2.el7                           ol7_latest        39 k
 libX11                               x86_64       1.6.7-2.el7                           ol7_latest       606 k
 libX11-common                        noarch       1.6.7-2.el7                           ol7_latest       164 k
 libXau                               x86_64       1.0.8-2.1.el7                         ol7_latest        28 k
 libXext                              x86_64       1.3.3-3.el7                           ol7_latest        38 k
 libXi                                x86_64       1.7.9-1.el7                           ol7_latest        40 k
 libXinerama                          x86_64       1.1.3-2.1.el7                         ol7_latest        13 k
 libXmu                               x86_64       1.1.2-2.el7                           ol7_latest        70 k
 libXrandr                            x86_64       1.5.1-2.el7                           ol7_latest        27 k
 libXrender                           x86_64       0.9.10-1.el7                          ol7_latest        25 k
 libXt                                x86_64       1.1.5-3.el7                           ol7_latest       172 k
 libXtst                              x86_64       1.2.3-1.el7                           ol7_latest        20 k
 libXv                                x86_64       1.0.11-1.el7                          ol7_latest        18 k
 libXxf86dga                          x86_64       1.1.4-2.1.el7                         ol7_latest        18 k
 libXxf86misc                         x86_64       1.0.3-7.1.el7                         ol7_latest        19 k
 libXxf86vm                           x86_64       1.1.4-1.el7                           ol7_latest        17 k
 libaio                               x86_64       0.3.109-13.el7                        ol7_latest        24 k
 libaio-devel                         x86_64       0.3.109-13.el7                        ol7_latest        12 k
 libbasicobjects                      x86_64       0.1.1-32.el7                          ol7_latest        25 k
 libcollection                        x86_64       0.7.0-32.el7                          ol7_latest        41 k
 libdmx                               x86_64       1.1.3-3.el7                           ol7_latest        15 k
 libevent                             x86_64       2.0.21-4.el7                          ol7_latest       208 k
 libini_config                        x86_64       1.3.1-32.el7                          ol7_latest        63 k
 libnfsidmap                          x86_64       0.25-19.el7                           ol7_latest        49 k
 libpath_utils                        x86_64       0.2.1-32.el7                          ol7_latest        28 k
 libref_array                         x86_64       0.1.5-32.el7                          ol7_latest        27 k
 libstdc++-devel                      x86_64       4.8.5-39.0.5.el7                      ol7_latest       1.5 M
 libtirpc                             x86_64       0.2.4-0.16.el7                        ol7_latest        89 k
 libverto-libevent                    x86_64       0.2.5-4.el7                           ol7_latest       8.2 k
 libxcb                               x86_64       1.13-1.el7                            ol7_latest       213 k
 lm_sensors-libs                      x86_64       3.4.0-8.20160601gitf9185e5.el7        ol7_latest        41 k
 mailx                                x86_64       12.5-19.el7                           ol7_latest       244 k
 net-tools                            x86_64       2.0-0.25.20131004git.el7              ol7_latest       305 k
 nfs-utils                            x86_64       1:1.3.0-0.66.0.1.el7_8                ol7_latest       412 k
 psmisc                               x86_64       22.20-16.el7                          ol7_latest       141 k
 quota                                x86_64       1:4.01-19.el7                         ol7_latest       178 k
 quota-nls                            noarch       1:4.01-19.el7                         ol7_latest        90 k
 rpcbind                              x86_64       0.2.0-49.el7                          ol7_latest        59 k
 smartmontools                        x86_64       1:7.0-2.el7                           ol7_latest       546 k
 sysstat                              x86_64       10.1.5-19.el7                         ol7_latest       315 k
 tcp_wrappers                         x86_64       7.6-77.el7                            ol7_latest        78 k
 unzip                                x86_64       6.0-21.el7                            ol7_latest       171 k
 xorg-x11-utils                       x86_64       7.5-23.el7                            ol7_latest       114 k
 xorg-x11-xauth                       x86_64       1:1.0.9-1.el7                         ol7_latest        29 k
Updating for dependencies:
 libstdc++                            x86_64       4.8.5-39.0.5.el7                      ol7_latest       306 k
Transaction Summary
================================================================================================================
Install  1 Package  (+60 Dependent packages)
Upgrade             (  1 Dependent package)
Total download size: 22 M
Downloading packages:
Delta RPMs disabled because /usr/bin/applydeltarpm not installed.
warning: /var/cache/yum/x86_64/7Server/ol7_latest/packages/bc-1.06.95-13.el7.x86_64.rpm: Header V3 RSA/SHA256 Signature, key ID ec551f03: NOKEY
Public key for bc-1.06.95-13.el7.x86_64.rpm is not installed
(1/62): bc-1.06.95-13.el7.x86_64.rpm                                                     | 114 kB  00:00:00
(2/62): bind-libs-9.11.4-16.P2.el7_8.6.x86_64.rpm                                        | 155 kB  00:00:00
(3/62): GeoIP-1.5.0-14.el7.x86_64.rpm                                                    | 1.5 MB  00:00:00
(4/62): bind-libs-lite-9.11.4-16.P2.el7_8.6.x86_64.rpm                                   | 1.1 MB  00:00:00
(5/62): bind-license-9.11.4-16.P2.el7_8.6.noarch.rpm                                     |  89 kB  00:00:00
(6/62): bind-utils-9.11.4-16.P2.el7_8.6.x86_64.rpm                                       | 259 kB  00:00:00
(7/62): compat-libcap1-1.10-7.el7.x86_64.rpm                                             |  17 kB  00:00:00
(8/62): compat-libstdc++-33-3.2.3-72.el7.x86_64.rpm                                      | 190 kB  00:00:00
(9/62): geoipupdate-2.5.0-1.el7.x86_64.rpm                                               |  34 kB  00:00:00
(10/62): glibc-headers-2.17-307.0.1.el7.1.x86_64.rpm                                     | 691 kB  00:00:00
(11/62): glibc-devel-2.17-307.0.1.el7.1.x86_64.rpm                                       | 1.1 MB  00:00:00
(12/62): gssproxy-0.7.0-28.el7.x86_64.rpm                                                | 110 kB  00:00:00
(13/62): keyutils-1.5.8-3.el7.x86_64.rpm                                                 |  53 kB  00:00:00
(14/62): ksh-20120801-142.0.1.el7.x86_64.rpm                                             | 882 kB  00:00:00
(15/62): libICE-1.0.9-9.el7.x86_64.rpm                                                   |  66 kB  00:00:00
(16/62): kernel-headers-3.10.0-1127.19.1.el7.x86_64.rpm                                  | 9.0 MB  00:00:00
(17/62): libSM-1.2.2-2.el7.x86_64.rpm                                                    |  39 kB  00:00:00
(18/62): libX11-common-1.6.7-2.el7.noarch.rpm                                            | 164 kB  00:00:00
(19/62): libX11-1.6.7-2.el7.x86_64.rpm                                                   | 606 kB  00:00:00
(20/62): libXau-1.0.8-2.1.el7.x86_64.rpm                                                 |  28 kB  00:00:00
(21/62): libXi-1.7.9-1.el7.x86_64.rpm                                                    |  40 kB  00:00:00
(22/62): libXinerama-1.1.3-2.1.el7.x86_64.rpm                                            |  13 kB  00:00:00
(23/62): libXmu-1.1.2-2.el7.x86_64.rpm                                                   |  70 kB  00:00:00
(24/62): libXrandr-1.5.1-2.el7.x86_64.rpm                                                |  27 kB  00:00:00
(25/62): libXrender-0.9.10-1.el7.x86_64.rpm                                              |  25 kB  00:00:00
(26/62): libXt-1.1.5-3.el7.x86_64.rpm                                                    | 172 kB  00:00:00
(27/62): libXtst-1.2.3-1.el7.x86_64.rpm                                                  |  20 kB  00:00:00
(28/62): libXv-1.0.11-1.el7.x86_64.rpm                                                   |  18 kB  00:00:00
(29/62): libXxf86dga-1.1.4-2.1.el7.x86_64.rpm                                            |  18 kB  00:00:00
(30/62): libXxf86misc-1.0.3-7.1.el7.x86_64.rpm                                           |  19 kB  00:00:00
(31/62): libXext-1.3.3-3.el7.x86_64.rpm                                                  |  38 kB  00:00:00
(32/62): libXxf86vm-1.1.4-1.el7.x86_64.rpm                                               |  17 kB  00:00:00
(33/62): libaio-0.3.109-13.el7.x86_64.rpm                                                |  24 kB  00:00:00
(34/62): libaio-devel-0.3.109-13.el7.x86_64.rpm                                          |  12 kB  00:00:00
(35/62): libbasicobjects-0.1.1-32.el7.x86_64.rpm                                         |  25 kB  00:00:00
(36/62): libcollection-0.7.0-32.el7.x86_64.rpm                                           |  41 kB  00:00:00
(37/62): libdmx-1.1.3-3.el7.x86_64.rpm                                                   |  15 kB  00:00:00
(38/62): libevent-2.0.21-4.el7.x86_64.rpm                                                | 208 kB  00:00:00
(39/62): libini_config-1.3.1-32.el7.x86_64.rpm                                           |  63 kB  00:00:00
(40/62): libnfsidmap-0.25-19.el7.x86_64.rpm                                              |  49 kB  00:00:00
(41/62): libpath_utils-0.2.1-32.el7.x86_64.rpm                                           |  28 kB  00:00:00
(42/62): libref_array-0.1.5-32.el7.x86_64.rpm                                            |  27 kB  00:00:00
(43/62): libstdc++-devel-4.8.5-39.0.5.el7.x86_64.rpm                                     | 1.5 MB  00:00:00
(44/62): libstdc++-4.8.5-39.0.5.el7.x86_64.rpm                                           | 306 kB  00:00:00
(45/62): libtirpc-0.2.4-0.16.el7.x86_64.rpm                                              |  89 kB  00:00:00
(46/62): libxcb-1.13-1.el7.x86_64.rpm                                                    | 213 kB  00:00:00
(47/62): lm_sensors-libs-3.4.0-8.20160601gitf9185e5.el7.x86_64.rpm                       |  41 kB  00:00:00
(48/62): mailx-12.5-19.el7.x86_64.rpm                                                    | 244 kB  00:00:00
(49/62): net-tools-2.0-0.25.20131004git.el7.x86_64.rpm                                   | 305 kB  00:00:00
(50/62): nfs-utils-1.3.0-0.66.0.1.el7_8.x86_64.rpm                                       | 412 kB  00:00:00
(51/62): libverto-libevent-0.2.5-4.el7.x86_64.rpm                                        | 8.2 kB  00:00:00
(52/62): oracle-database-preinstall-18c-1.0-1.el7.x86_64.rpm                             |  18 kB  00:00:00
(53/62): quota-4.01-19.el7.x86_64.rpm                                                    | 178 kB  00:00:00
(54/62): quota-nls-4.01-19.el7.noarch.rpm                                                |  90 kB  00:00:00
(55/62): psmisc-22.20-16.el7.x86_64.rpm                                                  | 141 kB  00:00:00
(56/62): rpcbind-0.2.0-49.el7.x86_64.rpm                                                 |  59 kB  00:00:00
(57/62): sysstat-10.1.5-19.el7.x86_64.rpm                                                | 315 kB  00:00:00
(58/62): smartmontools-7.0-2.el7.x86_64.rpm                                              | 546 kB  00:00:00
(59/62): tcp_wrappers-7.6-77.el7.x86_64.rpm                                              |  78 kB  00:00:00
(60/62): unzip-6.0-21.el7.x86_64.rpm                                                     | 171 kB  00:00:00
(61/62): xorg-x11-utils-7.5-23.el7.x86_64.rpm                                            | 114 kB  00:00:00
(62/62): xorg-x11-xauth-1.0.9-1.el7.x86_64.rpm                                           |  29 kB  00:00:00
----------------------------------------------------------------------------------------------------------------
Total                                                                            17 MB/s |  22 MB  00:00:01
Retrieving key from 
file:///etc/pki/rpm-gpg/RPM-GPG-KEY-oracle
Importing GPG key 0xEC551F03:
 Userid     : "Oracle OSS group (Open Source Software group) <build@oss.oracle.com>"
 Fingerprint: 4214 4123 fecf c55b 9086 313d 72f9 7b74 ec55 1f03
 Package    : 7:oraclelinux-release-7.8-1.0.7.el7.x86_64 (@anaconda/7.8)
 From       : /etc/pki/rpm-gpg/RPM-GPG-KEY-oracle
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
  Updating   : libstdc++-4.8.5-39.0.5.el7.x86_64                                                          1/63
  Installing : libXau-1.0.8-2.1.el7.x86_64                                                                2/63
  Installing : libxcb-1.13-1.el7.x86_64                                                                   3/63
  Installing : 32:bind-license-9.11.4-16.P2.el7_8.6.noarch                                                 4/63
  Installing : libref_array-0.1.5-32.el7.x86_64                                                           5/63
  Installing : libevent-2.0.21-4.el7.x86_64                                                               6/63
  Installing : libaio-0.3.109-13.el7.x86_64                                                               7/63
  Installing : libbasicobjects-0.1.1-32.el7.x86_64                                                        8/63
  Installing : libcollection-0.7.0-32.el7.x86_64                                                          9/63
  Installing : libICE-1.0.9-9.el7.x86_64                                                                 10/63
  Installing : libtirpc-0.2.4-0.16.el7.x86_64                                                             11/63
  Installing : rpcbind-0.2.0-49.el7.x86_64                                                               12/63
  Installing : libSM-1.2.2-2.el7.x86_64                                                                   13/63
  Installing : libaio-devel-0.3.109-13.el7.x86_64                                                        14/63
  Installing : libverto-libevent-0.2.5-4.el7.x86_64                                                      15/63
  Installing : libstdc++-devel-4.8.5-39.0.5.el7.x86_64                                                   16/63
  Installing : 1:quota-nls-4.01-19.el7.noarch                                                            17/63
  Installing : mailx-12.5-19.el7.x86_64                                                                  18/63|
  Installing : 1:smartmontools-7.0-2.el7.x86_64                                                          19/63
  Installing : compat-libstdc++-33-3.2.3-72.el7.x86_64                                                    20/63
  Installing : keyutils-1.5.8-3.el7.x86_64                                                               21/63
  Installing : libnfsidmap-0.25-19.el7.x86_64                                                            22/63
  Installing : lm_sensors-libs-3.4.0-8.20160601gitf9185e5.el7.x86_64                                      23/63
  Installing : sysstat-10.1.5-19.el7.x86_64                                                              24/63
  Installing : libpath_utils-0.2.1-32.el7.x86_64                                                         25/63
  Installing : libini_config-1.3.1-32.el7.x86_64                                                         26/63
  Installing : gssproxy-0.7.0-28.el7.x86_64                                                               27/63
  Installing : compat-libcap1-1.10-7.el7.x86_64                                                          28/63
  Installing : ksh-20120801-142.0.1.el7.x86_64                                                            29/63
  Installing : unzip-6.0-21.el7.x86_64                                                                   30/63
  Installing : libX11-common-1.6.7-2.el7.noarch                                                          31/63
  Installing : libX11-1.6.7-2.el7.x86_64                                                                 32/63
  Installing : libXext-1.3.3-3.el7.x86_64                                                                33/63
  Installing : libXi-1.7.9-1.el7.x86_64                                                                  34/63
  Installing : libXrender-0.9.10-1.el7.x86_64                                                            35/63
  Installing : libXrandr-1.5.1-2.el7.x86_64                                                              36/63
  Installing : libXtst-1.2.3-1.el7.x86_64                                                                37/63
  Installing : libXxf86misc-1.0.3-7.1.el7.x86_64                                                         38/63
  Installing : libdmx-1.1.3-3.el7.x86_64                                                                 39/63
  Installing : libXinerama-1.1.3-2.1.el7.x86_64                                                          40/63
  Installing : libXv-1.0.11-1.el7.x86_64                                                                 41/63
  Installing : libXxf86vm-1.1.4-1.el7.x86_64                                                             42/63
  Installing : libXxf86dga-1.1.4-2.1.el7.x86_64                                                           43/63
  Installing : xorg-x11-utils-7.5-23.el7.x86_64                                                          44/63
  Installing : libXt-1.1.5-3.el7.x86_64                                                                   45/63
  Installing : libXmu-1.1.2-2.el7.x86_64                                                                 46/63
  Installing : 1:xorg-x11-xauth-1.0.9-1.el7.x86_64                                                       47/63
  Installing : psmisc-22.20-16.el7.x86_64                                                                48/63
  Installing : net-tools-2.0-0.25.20131004git.el7.x86_64                                                 49/63
  Installing : kernel-headers-3.10.0-1127.19.1.el7.x86_64                                                50/63
  Installing : glibc-headers-2.17-307.0.1.el7.1.x86_64                                                   51/63
  Installing : glibc-devel-2.17-307.0.1.el7.1.x86_64                                                     52/63
  Installing : bc-1.06.95-13.el7.x86_64                                                                  53/63
  Installing : tcp_wrappers-7.6-77.el7.x86_64                                                            54/63
  Installing : 1:quota-4.01-19.el7.x86_64                                                                55/63
  Installing : 1:nfs-utils-1.3.0-0.66.0.1.el7_8.x86_64                                                   56/63
  Installing : geoipupdate-2.5.0-1.el7.x86_64                                                            57/63
  Installing : GeoIP-1.5.0-14.el7.x86_64                                                                 58/63
  Installing : 32:bind-libs-lite-9.11.4-16.P2.el7_8.6.x86_64                                             59/63
  Installing : 32:bind-libs-9.11.4-16.P2.el7_8.6.x86_64                                                  60/63
  Installing : 32:bind-utils-9.11.4-16.P2.el7_8.6.x86_64                                                  61/63
  Installing : oracle-database-preinstall-18c-1.0-1.el7.x86_64                                           62/63
  Cleanup    : libstdc++-4.8.5-39.0.3.el7.x86_64                                                         63/63
  Verifying  : libtirpc-0.2.4-0.16.el7.x86_64                                                             1/63
  Verifying  : libXext-1.3.3-3.el7.x86_64                                                                 2/63
  Verifying  : libXxf86misc-1.0.3-7.1.el7.x86_64                                                          3/63
  Verifying  : libdmx-1.1.3-3.el7.x86_64                                                                  4/63
  Verifying  : libICE-1.0.9-9.el7.x86_64                                                                   5/63
  Verifying  : geoipupdate-2.5.0-1.el7.x86_64                                                             6/63
  Verifying  : libXinerama-1.1.3-2.1.el7.x86_64                                                           7/63
  Verifying  : libXrender-0.9.10-1.el7.x86_64                                                             8/63
  Verifying  : libXt-1.1.5-3.el7.x86_64                                                                   9/63
  Verifying  : libXv-1.0.11-1.el7.x86_64                                                                 10/63
  Verifying  : libXi-1.7.9-1.el7.x86_64                                                                  11/63
  Verifying  : libXxf86vm-1.1.4-1.el7.x86_64                                                              12/63
  Verifying  : tcp_wrappers-7.6-77.el7.x86_64                                                            13/63
  Verifying  : libcollection-0.7.0-32.el7.x86_64                                                         14/63
  Verifying  : 1:nfs-utils-1.3.0-0.66.0.1.el7_8.x86_64                                                   15/63
  Verifying  : libbasicobjects-0.1.1-32.el7.x86_64                                                       16/63
  Verifying  : gssproxy-0.7.0-28.el7.x86_64                                                              17/63
  Verifying  : 1:smartmontools-7.0-2.el7.x86_64                                                           18/63
  Verifying  : 32:bind-libs-9.11.4-16.P2.el7_8.6.x86_64                                                  19/63
  Verifying  : bc-1.06.95-13.el7.x86_64                                                                  20/63
  Verifying  : GeoIP-1.5.0-14.el7.x86_64                                                                 21/63
  Verifying  : xorg-x11-utils-7.5-23.el7.x86_64                                                          22/63
  Verifying  : sysstat-10.1.5-19.el7.x86_64                                                              23/63
  Verifying  : kernel-headers-3.10.0-1127.19.1.el7.x86_64                                                24/63
  Verifying  : net-tools-2.0-0.25.20131004git.el7.x86_64                                                 25/63
  Verifying  : libXtst-1.2.3-1.el7.x86_64                                                                26/63
  Verifying  : 32:bind-libs-lite-9.11.4-16.P2.el7_8.6.x86_64                                              27/63
  Verifying  : rpcbind-0.2.0-49.el7.x86_64                                                               28/63
  Verifying  : 32:bind-utils-9.11.4-16.P2.el7_8.6.x86_64                                                 29/63
  Verifying  : glibc-headers-2.17-307.0.1.el7.1.x86_64                                                   30/63
  Verifying  : libstdc++-4.8.5-39.0.5.el7.x86_64                                                         31/63
  Verifying  : libaio-0.3.109-13.el7.x86_64                                                              32/63
  Verifying  : libini_config-1.3.1-32.el7.x86_64                                                         33/63
  Verifying  : psmisc-22.20-16.el7.x86_64                                                                 34/63
  Verifying  : libX11-common-1.6.7-2.el7.noarch                                                          35/63
  Verifying  : unzip-6.0-21.el7.x86_64                                                                   36/63
  Verifying  : libxcb-1.13-1.el7.x86_64                                                                  37/63
  Verifying  : libevent-2.0.21-4.el7.x86_64                                                              38/63
  Verifying  : ksh-20120801-142.0.1.el7.x86_64                                                           39/63
  Verifying  : libverto-libevent-0.2.5-4.el7.x86_64                                                      40/63
  Verifying  : compat-libcap1-1.10-7.el7.x86_64                                                           41/63
  Verifying  : libXrandr-1.5.1-2.el7.x86_64                                                              42/63
  Verifying  : libaio-devel-0.3.109-13.el7.x86_64                                                         43/63
  Verifying  : libref_array-0.1.5-32.el7.x86_64                                                          44/63
  Verifying  : 1:xorg-x11-xauth-1.0.9-1.el7.x86_64                                                       45/63
  Verifying  : libpath_utils-0.2.1-32.el7.x86_64                                                         46/63
  Verifying  : 1:quota-4.01-19.el7.x86_64                                                                47/63
  Verifying  : lm_sensors-libs-3.4.0-8.20160601gitf9185e5.el7.x86_64                                      48/63
  Verifying  : libnfsidmap-0.25-19.el7.x86_64                                                            49/63
  Verifying  : libstdc++-devel-4.8.5-39.0.5.el7.x86_64                                                   50/63
  Verifying  : libSM-1.2.2-2.el7.x86_64                                                                  51/63
  Verifying  : oracle-database-preinstall-18c-1.0-1.el7.x86_64                                            52/63
  Verifying  : libXxf86dga-1.1.4-2.1.el7.x86_64                                                          53/63
  Verifying  : libXmu-1.1.2-2.el7.x86_64                                                                 54/63
  Verifying  : keyutils-1.5.8-3.el7.x86_64                                                               55/63
  Verifying  : compat-libstdc++-33-3.2.3-72.el7.x86_64                                                   56/63
  Verifying  : 32:bind-license-9.11.4-16.P2.el7_8.6.noarch                                               57/63
  Verifying  : libXau-1.0.8-2.1.el7.x86_64                                                               58/63
  Verifying  : libX11-1.6.7-2.el7.x86_64                                                                 59/63
  Verifying  : glibc-devel-2.17-307.0.1.el7.1.x86_64                                                     60/63
  Verifying  : mailx-12.5-19.el7.x86_64                                                                  61/63
  Verifying  : 1:quota-nls-4.01-19.el7.noarch                                                            62/63
  Verifying  : libstdc++-4.8.5-39.0.3.el7.x86_64                                                          63/63
Installed:  oracle-database-preinstall-18c.x86_64 0:1.0-1.el7
Dependency Installed:
  GeoIP.x86_64 0:1.5.0-14.el7                                 bc.x86_64 0:1.06.95-13.el7
  bind-libs.x86_64 32:9.11.4-16.P2.el7_8.6                    bind-libs-lite.x86_64 32:9.11.4-16.P2.el7_8.6
  bind-license.noarch 32:9.11.4-16.P2.el7_8.6                 bind-utils.x86_64 32:9.11.4-16.P2.el7_8.6
  compat-libcap1.x86_64 0:1.10-7.el7                          compat-libstdc++-33.x86_64 0:3.2.3-72.el7
  geoipupdate.x86_64 0:2.5.0-1.el7                            glibc-devel.x86_64 0:2.17-307.0.1.el7.1
  glibc-headers.x86_64 0:2.17-307.0.1.el7.1                   gssproxy.x86_64 0:0.7.0-28.el7
  kernel-headers.x86_64 0:3.10.0-1127.19.1.el7                keyutils.x86_64 0:1.5.8-3.el7
  ksh.x86_64 0:20120801-142.0.1.el7                           libICE.x86_64 0:1.0.9-9.el7
  libSM.x86_64 0:1.2.2-2.el7                                  libX11.x86_64 0:1.6.7-2.el7
  libX11-common.noarch 0:1.6.7-2.el7                          libXau.x86_64 0:1.0.8-2.1.el7
  libXext.x86_64 0:1.3.3-3.el7                                libXi.x86_64 0:1.7.9-1.el7
  libXinerama.x86_64 0:1.1.3-2.1.el7                          libXmu.x86_64 0:1.1.2-2.el7
  libXrandr.x86_64 0:1.5.1-2.el7                              libXrender.x86_64 0:0.9.10-1.el7
  libXt.x86_64 0:1.1.5-3.el7                                  libXtst.x86_64 0:1.2.3-1.el7
  libXv.x86_64 0:1.0.11-1.el7                                 libXxf86dga.x86_64 0:1.1.4-2.1.el7
  libXxf86misc.x86_64 0:1.0.3-7.1.el7                         libXxf86vm.x86_64 0:1.1.4-1.el7
  libaio.x86_64 0:0.3.109-13.el7                              libaio-devel.x86_64 0:0.3.109-13.el7
  libbasicobjects.x86_64 0:0.1.1-32.el7                       libcollection.x86_64 0:0.7.0-32.el7
  libdmx.x86_64 0:1.1.3-3.el7                                 libevent.x86_64 0:2.0.21-4.el7
  libini_config.x86_64 0:1.3.1-32.el7                         libnfsidmap.x86_64 0:0.25-19.el7
  libpath_utils.x86_64 0:0.2.1-32.el7                         libref_array.x86_64 0:0.1.5-32.el7
  libstdc++-devel.x86_64 0:4.8.5-39.0.5.el7                   libtirpc.x86_64 0:0.2.4-0.16.el7
  libverto-libevent.x86_64 0:0.2.5-4.el7                      libxcb.x86_64 0:1.13-1.el7
  lm_sensors-libs.x86_64 0:3.4.0-8.20160601gitf9185e5.el7     mailx.x86_64 0:12.5-19.el7
  net-tools.x86_64 0:2.0-0.25.20131004git.el7                 nfs-utils.x86_64 1:1.3.0-0.66.0.1.el7_8
  psmisc.x86_64 0:22.20-16.el7                                quota.x86_64 1:4.01-19.el7
  quota-nls.noarch 1:4.01-19.el7                              rpcbind.x86_64 0:0.2.0-49.el7
  smartmontools.x86_64 1:7.0-2.el7                            sysstat.x86_64 0:10.1.5-19.el7
  tcp_wrappers.x86_64 0:7.6-77.el7                            unzip.x86_64 0:6.0-21.el7
  xorg-x11-utils.x86_64 0:7.5-23.el7                          xorg-x11-xauth.x86_64 1:1.0.9-1.el7
Dependency Updated:  libstdc++.x86_64 0:4.8.5-39.0.5.el7
Complete!

# ----------------------------------
# Install Oracle Software for XE Version

[root@oel7-ora-xe ~]# yum -y localinstall /tmp/oracle-database-xe-18c-1.0-1.x86_64.rpm
Loaded plugins: ulninfo
Examining /tmp/oracle-database-xe-18c-1.0-1.x86_64.rpm: oracle-database-xe-18c-1.0-1.x86_64
Marking /tmp/oracle-database-xe-18c-1.0-1.x86_64.rpm to be installed
Resolving Dependencies
--> Running transaction check
---> Package oracle-database-xe-18c.x86_64 0:1.0-1 will be installed
--> Finished Dependency Resolution
Dependencies Resolved
================================================================================================================
 Package                        Arch           Version       Repository                                    Size
================================================================================================================
Installing:
 oracle-database-xe-18c         x86_64         1.0-1         /oracle-database-xe-18c-1.0-1.x86_64         5.2 G
Transaction Summary
================================================================================================================
Install  1 Package
Total size: 5.2 G
Installed size: 5.2 G
Downloading packages:
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
  Installing : oracle-database-xe-18c-1.0-1.x86_64                                                          1/1
[INFO] Executing post installation scripts...
[INFO] Oracle home installed successfully and ready to be configured.
To configure Oracle Database XE, optionally modify the parameters in '/etc/sysconfig/oracle-xe-18c.conf' and then execute
'/etc/init.d/oracle-xe-18c configure' as root.

  Verifying  : oracle-database-xe-18c-1.0-1.x86_64                                                         1/1

Installed:  oracle-database-xe-18c.x86_64 0:1.0-1

Complete!

# ----------------------------------
# Creating the XE Database Instance

[root@oel7-ora-xe ~]# /etc/init.d/oracle-xe-18c configure
Specify a password to be used for database accounts. Oracle recommends that the password entered should be at least 8 characters in length, contain at least 1 uppercase character, 1 lower case character and 1 digit [0-9]. Note that the same password will be used for SYS, SYSTEM and PDBADMIN accounts:
Confirm the password:
Configuring Oracle Listener.
Listener configuration succeeded.
Configuring Oracle Database XE.
Enter SYS user password:
***********
Enter SYSTEM user password:
**********
Enter PDBADMIN User Password:
*********
Prepare for db operation
7% complete
Copying database files
29% complete
Creating and starting Oracle instance
30% complete
31% complete
34% complete
38% complete
41% complete
43% complete
Completing Database Creation
47% complete
50% complete
Creating Pluggable Databases
54% complete
71% complete
Executing Post Configuration Actions
93% complete
Running Custom Scripts
100% complete

Database creation complete. For details check the logfiles at: /opt/oracle/cfgtoollogs/dbca/XE.
Database Information:
Global Database Name:XE
System Identifier(SID):XE
Look at the log file "/opt/oracle/cfgtoollogs/dbca/XE/XE.log" for further details.
Connect to Oracle Database using one of the connect strings:
     Pluggable database: oel7-ora-xe.localdomain:1539/XEPDB1
     Multitenant container database: oel7-ora-xe.localdomain:1539
Use https://localhost:5500/em to access Oracle Enterprise Manager for Oracle Database XE

[root@oel7-ora-xe ~]# su – oracle
Last login: Thu Aug 27 14:40:56 CEST 2020 on pts/0
[oracle@oel7-ora-xe ~]$ . oraenv <<< XE
ORACLE_SID = [oracle] ? The Oracle base has been set to /opt/oracle
[oracle@oel7-ora-xe ~]$ sqlplus / as sysdba
SQL*Plus: Release 18.0.0.0.0 - Production on Thu Aug 27 14:50:12 2020
Version 18.4.0.0.0
Copyright (c) 1982, 2018, Oracle.  All rights reserved.
Connected to:
Oracle Database 18c Express Edition Release 18.0.0.0.0 – Production
Version 18.4.0.0.0

SQL> select host_name
  , instance_name
  , version
  , version_full
  , status
  , database_type
  , edition
from gv$instance
order by 1, 2;


HOST_NAME               INSTANCE_NAME VERSION    VERSION_FULL  STATUS  DATABASE_TYPE  EDITION
----------------------- ------------- ---------- ------------- ------- -------------- -------
oel7-ora-xe.localdomain XE            18.0.0.0.0 18.4.0.0.0    OPEN    SINGLE         XE

SQL> 

# DONE!!!

----------------------------------------------------------------------------------------------

# NOW THE 19c ENTERPRISE EDITION VERSION

# ----------------------------------
# 19c (Version EE)
# ----------------------------------
# For the 19c EE Version, the process is the same, what changes is the pre-install package and other necessary step to create the database.

# ----------------------------------
# Install the pre-install package.

yum -y install oracle-database-preinstall-19c-1.0-2.el7.x86_64.rpm

# ----------------------------------
# Install the software (you have to download it first, www.oracle.com/downloads
).

yum -y localinstall /tmp/oracle-database-ee-19c-1.0-1.x86_64.rpm


# ----------------------------------
# Create the folder where the database instance will be saved.

mkdir -p /opt/oracle/oradata/


# ----------------------------------

# This is the command to create the database using a single line command. (Remember, that is just an example).

dbca -silent -createDatabase -templateName General_Purpose.dbc \
 -databaseType OLTP \
 -gdbName dbprod \
 -sid dbprod \
 -createAsContainerDatabase false \
 -enableArchive true \
 -archiveLogMode auto \
 -SysPassword Welcome1 \
 -SystemPassword Welcome1 \
 -emConfiguration NONE \
 -storageType FS \
 -datafileDestination /opt/oracle/oradata/ \
 -redoLogFileSize 250 \
 -characterSet AL32UTF8 \
 -useOMF true \
 -dbOptions \
 -memoryMgmtType auto_sga \
 -memoryPercentage 60 \
 -dbOptions IMEDIA:false,CWMLITE:false,SAMPLE_SCHEMA:false,ORACLE_TEXT:false,APEX:false,OMS:false,DV:false,JSERVER:false,SPATIAL:false


# ----------------------------------
# DONE!!!

Now you can try on your own, good luck!!!