hostname em13c.example.com
yum -y update
yum -y install epel-release
yum -y install open-vm-tools nfs-utils
mkdir -p /mnt/nfs/distr
mount 192.168.88.104:/export/distr /mnt/nfs/distr/
setenforce 0
systemctl disable firewalld
systemctl stop firewalld
export LANG=C
yum grouplist
yum -y groupinstall  "Development Tools" "System Administration Tools"
yum -y install libaio-devel ksh sysstat psmisc
#echo `ip addr show \`ip  addr show scope global | head -1 | awk '{ print substr($2,0,match($2,":")-1)}'\` | grep "inet " | awk '{print $2}' | awk -F "/" '{print $1}'`" em13c.example.com em13c" >>/etc/hosts
echo `ip addr show | grep global | awk '{print $2}' |  awk -F "/" '{print $1}'` em13c.example.com em13c >> /etc/hosts
groupadd dba
useradd -g dba oracle
mkdir -p /opt/oracle
mkdir -p /opt/oraInventory
chown -R oracle:dba /opt/ora*
cat >> /etc/sysctl.conf << EOF
kernel.shmall = 4294967296
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
fs.file-max = 6815744
net.ipv4.ip_local_port_range = 9000 65500
net.core.rmem_default = 262144
net.core.wmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_max = 1048576
fs.aio-max-nr = 1048576
EOF
sysctl -p

su - oracle

cat >> ~/ee_install.rsp << EOF

oracle.install.responseFileVersion=/oracle/install/rspfmt_dbinstall_response_schema_v12.2.0
oracle.install.option=INSTALL_DB_SWONLY
UNIX_GROUP_NAME=dba
INVENTORY_LOCATION=/opt/oraInventory
ORACLE_HOME=/opt/oracle/product/12.2
ORACLE_BASE=/opt/oracle
oracle.install.db.InstallEdition=EE
oracle.install.db.OSDBA_GROUP=dba
oracle.install.db.OSOPER_GROUP=dba
oracle.install.db.OSBACKUPDBA_GROUP=dba
oracle.install.db.OSDGDBA_GROUP=dba
oracle.install.db.OSKMDBA_GROUP=dba
oracle.install.db.OSRACDBA_GROUP=dba
EOF

cd /mnt/nfs/distr/oracle/linux/12.2/database
./runInstaller -responseFile /home/oracle/ee_install.rsp -silent -showProgress -ignorePrereqFailure -waitForCompletion
exit
/opt/oraInventory/orainstRoot.sh
/opt/oracle/product/12.2/root.sh
su - oracle

cat >> ~/.bashrc << EOF
ORACLE_HOSTNAME=em13c.example.com
ORACLE_UNQNAME=PROD
ORACLE_BASE=/opt/oracle
ORACLE_HOME=/opt/oracle/product/12.2
LD_LIBRARY_PATH=/opt/oracle/product/12.2/lib:$LD_LIBRARY_PATH
NLS_LANG=AMERICAN_AMERICA.UTF8
ORACLE_SID=EMGC
CLASSPATH=/opt/oracle/product/12.2/jlib:/opt/oracle/product/12.2/rdbms/jlib
PATH=/opt/oracle/product/12.2/bin:$PATH
export ORACLE_HOSTNAME ORACLE_UNQNAME LD_LIBRARY_PATH NLS_LANG ORACLE_SID CLASSPATH PATH ORACLE_HOME ORACLE_BASE
EOF

source ~/.bashrc

cd $ORACLE_HOME/
mv OPatch OPatch_back
cp /mnt/nfs/distr/oracle/linux/patch/p6880880_122010_Linux-x86-64.zip .
unzip p6880880_122010_Linux-x86-64.zip

export PATH=$PATH:/usr/ccs/bin
export PATH=$ORACLE_HOME/OPatch:$PATH

#install patches
cd /mnt/nfs/distr/oracle/linux/patch/
cd 27475613/
opatch apply -silent
cd ../27674384/
opatch apply -silent

cd

cat >> ~/netca.rsp << EOF

[GENERAL]
RESPONSEFILE_VERSION="12.2"
CREATE_TYPE="CUSTOM"
SHOW_GUI=false
LOG_FILE=""$ORACLE_HOME/network/tools/log/netca.log""

[oracle.net.ca]
INSTALLED_COMPONENTS={"server","net8","javavm"}
INSTALL_TYPE=""typical""
LISTENER_NUMBER=1
LISTENER_NAMES={"LISTENER"}
LISTENER_PROTOCOLS={"TCP;1521"}
LISTENER_START=""LISTENER""
NAMING_METHODS={"TNSNAMES","ONAMES","HOSTNAME"}
NSN_NUMBER=1
NSN_NAMES={"EXTPROC_CONNECTION_DATA"}
NSN_SERVICE={"PLSExtProc"}
NSN_PROTOCOLS={"TCP;HOSTNAME;1521"}
EOF

exit
su - oracle

netca -responsefile /home/oracle/netca.rsp -silent

cat >> ~/dbca.rsp << EOF
responseFileVersion=/oracle/assistants/rspfmt_dbca_response_schema_v12.2.0
gdbName=EMGC
sid=EMGC
databaseConfigType=SI
createAsContainerDatabase=false
templateName=General_Purpose.dbc
sysPassword=Welcome1
systemPassword=Welcome1
oracleHomeUserPassword=
emConfiguration=DBEXPRESS
emExpressPort=5500
dbsnmpPassword=Welcome1
characterSet=AL32UTF8
memoryPercentage=60
automaticMemoryManagement=
totalMemory=3000
EOF

dbca -silent -createDatabase -responseFile /home/oracle/dbca.rsp
#Patching for RCU access
echo "SQLNET.ALLOWED_LOGON_VERSION_SERVER= 10" >> $ORACLE_HOME/network/admin/sqlnet.ora
lsnrctl stop
lsnrctl start

sqlplus "/ as sysdba" <<EOF
ALTER SYSTEM SET "_allow_insert_with_update_check"=TRUE scope=spfile;
ALTER SYSTEM set sec_case_sensitive_logon=FALSE scope=spfile;
shu immediate
startup
alter user sys identified by Welcome1;
alter user system identified by Welcome1;
exit
EOF


#create service

cat >> /usr/lib/systemd/system/oracle-rdbms.service << EOF
# /etc/systemd/system/oracle-rdbms.service
# Invoking Oracle scripts to start/shutdown Instances defined in /etc/oratab
# and starts Listener
[Unit]
Description=Oracle Database(s) and Listener
Requires=network.target
Before=oracle-ems.service
[Service]
Type=forking
Restart=no
ExecStart=/opt/oracle/product/12.2/bin/dbstart /opt/oracle/product/12.2/
ExecStop=/opt/oracle/product/12.2/bin/dbshut /opt/oracle/product/12.2/
User=oracle
[Install]
WantedBy=multi-user.target
EOF