# Install RedHat 8.7 minimal server with:
yum -y groupinstall "Server with GUI" \
                    "Compatibility Libraries" \
                    "Development Tools" \
                    "Graphical Administration Tools" \
                    "Legacy UNIX Compatibility" \
                    "System Administration Tools"
rpm -qa | wc -l     :648

yum -y install bc bind-utils binutils curl dump elfutils-libelf elfutils-libelf-devel expect fuse fio gcc gcc-c++ glibc glibc-common glibc-devel glibc-headers iftop iperf3 ksh libaio libaio-devel libcap libcap-devel libgcc libnsl libstdc++ libstdc++-devel mailx make net-tools nfs-utils ntfs-3g ncurses ncurses-devel numactl redhat-lsb-core rsync setools-console sysstat traceroute unixODBC unixODBC-devel unzip wget xfsdump xorg-x11-xauth xterm zip

rpm -q bc bind-utils binutils curl dump elfutils-libelf elfutils-libelf-devel expect fuse fio gcc gcc-c++ glibc glibc-common glibc-devel glibc-headers iftop iperf3 ksh libaio libaio-devel libcap libcap-devel libgcc libnsl libstdc++ libstdc++-devel mailx make net-tools nfs-utils ntfs-3g ncurses ncurses-devel numactl redhat-lsb-core rsync setools-console sysstat traceroute unixODBC unixODBC-devel unzip wget xfsdump xorg-x11-xauth xterm zip

rpm -qa | wc -l     :682

# Install i7z
git clone https://github.com/ajaiantilal/i7z.git
cd i7z
make && make installr
cp -p i7z /usr/sbin/i7z
cd ..
rm -rf i7z

# 2022/12/19 System disk info
df -Th | egrep 'sed|xfs|fat|nfs|iso'
Filesystem     Type      Size  Used Avail Use% Mounted on
/dev/sdb2      xfs       135G  1.4G  134G   1% /          # Raid for mirror
/dev/sdb1      vfat     1022M  9.9M 1013M   1% /boot/efi
/dev/sda1      xfs       1.1T   60G  1.1T   6% /backup    # Raid for striping
/dev/sdc1      xfs       298G   60G  239G  20% /mnt       # USB external disk

# 2022/12/19 Unzip root & oracle files
# yum -y install libaio # For sqlplus execute
id oracle
groupmod -n oinstall oracle
groupadd -g 1001 dba
groupadd -g 1002 oper
usermod -G 10,1000,1001,1002 oracle
id oracle
uid=1000(oracle) gid=1000(oinstall) groups=1000(oinstall),10(wheel),1001,1002
tar -zxvf /backup/src/root.tgz         -C /root/
tar -zxvf /backup/src/oracle.tgz       -C /home/oracle/
tar -zxvf /backup/src/ora12cClient.tgz -C /u01/

##############################################################################
exit
##############################################################################
yum --skip-broken -y install fio
fio --randrepeat=1 \
    --ioengine=libaio \
    --direct=1 \
    --gtod_reduce=1 \
    --name=fiotest \
    --filename=testfio \
    --bs=4k \
    --iodepth=64 \
    --size=8G \
    --readwrite=randrw \
    --rwmixread=75

# Install for GUI server
yum -y groupinstall "Server with GUI" \
                    "Compatibility Libraries" \
                    "Development Tools" \
                    "Graphical Administration Tool" \
                    "Legacy UNIX Compatibility" \
                    "Office Suite and Productivity" \
                    "System Administration Tools" \
                    "System Management"
systemctl get-default
systemctl --type=target --all
systemctl set-default graphical.target
reboot

# Config home environment
scp -rp 172.16.53.203:.ssh .
rm -f .ssh/known*
scp -rp 172.16.53.203:bin .
scp -rp 172.16.53.203:kway/.bash_profile .
scp -rp 172.16.53.203:kway/oraconf.tar /tmp/.
su - oracle -c "tar -xvf /tmp/oraconf.tar"
rm -f /home/oracle/.ssh/known*
scp -rp 172.16.53.203:/etc/hosts.deny /etc/.
scp -rp 172.16.53.203:kway/motd/motd.178 /etc/motd

# Config for security
cat /etc/selinux/config
sed -i 's/SELINUX=enforcing/SELINUX=disabled/' /etc/selinux/config
firewall-cmd --state
firewall-cmd --permanent --add-port=1521/tcp
firewall-cmd --reload
firewall-cmd --list-all
systemctl stop    firewalld.service
systemctl disable firewalld.service
systemctl stop    libvirtd.service
systemctl disable libvirtd.service
cat /etc/default/grub
sed -i 's/quiet/quiet ipv6.disable=1/' /etc/default/grub
grub=`find /boot -name grub.cfg`
grub2-mkconfig -o $grub
cat /proc/cmdline

# Config hosts list
host=`hostname -s`
ip=`ifconfig -a|grep -w inet|grep 172.16|awk '{print $2}'`
cat>>/etc/hosts<<EOF

$ip $host $host.kway.com.tw
EOF
cat /etc/hosts

# Config CDROM repositry
mkdir /iso /cdrom
scp 172.16.53.203:/iso/rhel87x64.iso /iso/.
cat>>/etc/fstab<<EOF
/iso/rhel87x64.iso /cdrom iso9660 defaults,loop 0 0
EOF

cat <<EOF>> /etc/fstab
/iso/rhel79iso.iso /cdrom iso9660 defaults,loop 0 0
/iso/rhel87iso.iso /cdrom iso9660 defaults,loop 0 0
EOF

mount -a
cat>/etc/yum.repos.d/local.repo<<EOF
[BaseOS]
name=BaseOS CDROM
baseurl=file:///cdrom/BaseOS
enabled=1
gpgcheck=0
[AppStream]
name=AppStream CDROM
baseurl=file:///cdrom/AppStream
enabled=1
gpgcheck=0
EOF
yum makecache
rpm -ivh https://dl.fedoraproject.org/pub/epel/epel-release-latest-8.noarch.rpm
yum makecache

# Setup package for Oracle Database
rpm -q binutils elfutils-libelf iftop ksh mailx make \
    elfutils-libelf-devel expect gcc gcc-c++ glibc glibc-common glibc-devel \
    glibc-headers libaio libaio-devel libgcc libnsl libstdc++ libstdc++-devel \
    sysstat unixODBC unixODBC-devel xorg-x11-xauth xterm xfsdump | grep ^pack
yum -y install binutils elfutils-libelf iftop ksh mailx make \
    elfutils-libelf-devel expect gcc gcc-c++ glibc glibc-common glibc-devel \
    glibc-headers libaio libaio-devel libgcc libnsl libstdc++ libstdc++-devel \
    sysstat unixODBC unixODBC-devel xorg-x11-xauth xterm xfsdump

# Add users for Oracle Database Install
groupmod -n oinstall oracle
groupadd -g 1000 oinstall
groupadd -g 1001 dba
groupadd -g 1002 oper
useradd  -u 1000 -g 1000 -G 10,1001,1002 -c "Oracle DBA" oracle
usermod  -G 10,1001,1002 oracle
echo kway1234 | passwd --stdin oracle
mkdir -p /u01/app/oracle
chown -R 1000:1000 /u01
su - oracle -c "tar -xvf /tmp/oraconf.tar"
rm -f /home/oracle/.ssh/known*

# Config system parameters for Oracle Database
day=`date +"%F %T"`
cat>>/etc/sysctl.conf<<EOF

### For Oracle 19.3.0.0 install (modify: $day)
fs.aio-max-nr = 1048576
fs.file-max = 6815744
kernel.sem = 250 32000 100 128
kernel.shmmni = 4096
kernel.shmall = 1073741824
kernel.shmmax = 25769803776
kernel.sysrq = 1
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048576
net.ipv4.ip_local_port_range = 9000 65500
EOF
cat>>/etc/security/limits.conf<<EOF

### For Oracle 19.3.0.0 install (modify: $day)
oracle   soft   nofile      1024
oracle   hard   nofile     65536
oracle   soft   nproc      16384
oracle   hard   nproc      16384
oracle   soft   stack      10240
oracle   hard   stack      32768
oracle   hard   memlock  7549747
oracle   soft   memlock  7549747
EOF
cat>>/etc/pam.d/login<<EOF

### For Oracle 19.3.0.0 install (modify: $day)
session    required     pam_limits.so
EOF
cat>>/etc/profile<<EOF

### For Oracle 19.3.0.0 install (modify: $day)
ulimit -u 16384 -n 65536
umask 022
EOF

### Create operate script
cat>$HOME/dbOper<<EOF
#!/bin/bash
export PATH=/bin:/sbin:/usr/bin:/usr/sbin:/usr/local/bin:.
export ORACLE_HOME=/u01/app/oracle/product/19.3.0/db
case \$1 in
start)   su - oracle -c "dbstart \$ORACLE_HOME" ; \$0 status ;;
stop)    su - oracle -c "dbshut  \$ORACLE_HOME" ; \$0 status ;;
restart) su - oracle -c "dbshut  \$ORACLE_HOME"
         su - oracle -c "dbstart \$ORACLE_HOME" ; \$0 status ;;
status)  su - oracle -c "lsnrctl start"
         su - oracle -c "lsnrctl status" ;;
*) echo "USAGE: \$0 { start | stop | restart | status }" ;;
esac
EOF
chmod 755 $HOME/dbOper
cp $HOME/dbOper /etc/init.d/oracle
ln -s /etc/init.d/oracle /etc/rc5.d/S99oracle

# Extract oracle setup source from network
su - oracle
mkdir -p $ORACLE_HOME
cd $ORACLE_HOME
ssh root@172.16.53.203 dd if=/backup/src/ora19.3.0.0home.tar|tar -xvf -
ssh root@172.16.53.203 dd if=/backup/src/ora19.3.0.0home.tgz|tar -zxvf -