Detailed graphic tutorial on silent installation of oracle12.2 on CentOS under VMware

Environmental preparation:

VMware+CentOS, jdk

1. Verify the system disk size

1. Command df -h

Ensure that the available disk space is 15GB (including 7.5GB required for Oracle installation + nearly 3G for the Oracle installation zip package + 3G for the installation package decompression file)

If the disk is not sufficient, the installation will fail and the capacity needs to be expanded!

2. Installation Preparation

1. Create a system user and user group to run the Oracle database

groupadd oinstall
groupadd dba
useradd -g oinstall -g dba -m oracle

passwd oracle #Ignore the prompts and enter the password twice in a row to succeed

2. Create an Oracle database installation directory and grant the directory permissions to the Oracle user

mkdir -p /opt/oracle/database #Files extracted from the Oracle installation package mkdir -p /opt/oracle/product/oraInventory #
mkdir -p /opt/oracle/product/12.2.0/db_1 #Oracle installation directory chown -R oracle:oinstall /opt/oracle #Change the owner of the oracle directory chmod 755 -R /opt/oracle #Change the permissions of the oracle directory 

3. Install the software packages that the Oracle database depends on

3.1. Installation

yum -y install binutils compat-libstdc++-33 elfutils-libelf elfutils-libelf-devel glibc glibc-common glibc-devel gcc gcc-c++ libaio-devel libaio libgcc libstdc++ libstdc++-devel make sysstat unixODBC unixODBC-devel pdksh numactl-devel glibc-headers

3.2. Check whether the installation is successful

rpm -q \binutils \compat-libstdc++-33 \elfutils-libelf \elfutils-libelf-devel \expat \gcc \gcc-c++ \glibc \glibc-common \glibc-devel \glibc-headers \libaio \libaio-devel \libgcc \libstdc++ \libstdc++-devel \make \pdksh \sysstat \unixODBC \unixODBC-devel | grep "not installed" 

4. Disable selinux and restart to take effect (you can restart before installing oracle) vim /etc/selinux/config

5. Modify kernel parameters vim /etc/sysctl.conf

Add the following content:

net.ipv4.icmp_echo_ignore_broadcasts = 1

net.ipv4.conf.all.rp_filter = 1

fs.file-max = 6815744

fs.aio-max-nr = 1048576

kernel.shmall = 2097152

kernel.shmmax = 2147483648

kernel.shmmni = 4096

kernel.sem = 250 32000 100 128

net.ipv4.ip_local_port_range = 9000 65500

net.core.rmem_default = 262144

net.core.rmem_max = 4194304

net.core.wmem_default = 262144

net.core.wmem_max = 1048576

sysctl -p #Make the configuration effective

6. Set restrictions on oracle users to improve system performance

vim /etc/security/limits.conf

Add the following content:

oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536 

7. Configure user environment variables

vim /home/oracle/.bash_profile

Add the following content:

export ORACLE_BASE=/opt/oracle

export ORACLE_HOME=$ORACLE_BASE/product/12.2.0/db_1

export ORACLE_SID=orcl

export ORACLE_TERM=xterm

export PATH=$ORACLE_HOME/bin:/usr/sbin:$PATH

export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib

export LANG=C

export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK

source /home/oracle/.bash_profile #使配置失效

8. Unzip the compressed package of the Oracle installation file and unzip it in the /opt/oracle/ directory

unzip file name (unzip does not exist, you can install it with the command: yum install unzip) compression is slow, you need to wait

9. Configure the answer file

vim /opt/oracle/database/response/db_install.rsp

10. Configure the oraInventory directory location

Stores the directory information for Oracle software installation. This directory is required for Oracle installation and upgrade (preferably placed under the directory corresponding to ORACLE_BASE)

vim /etc/oraInst.loc

Add or modify the following content:

inventory_loc=/opt/oracle/product/oraInventory

inst_group=oinstall

11. Restart CentOS, reboot

12. Turn off the firewall, systemctl stop firewalld

3. Silently install Oracle12

1. Log in to the Linux system as oracle user

2. Silent installation

/opt/oracle/database/runInstaller -silent -force -ignorePrereq -responseFile /opt/oracle/database/response/db_install.rsp

The execution process will take several minutes.

Monitorable logs:

tail -f
/opt/oracle/product/oraInventory/logs/installActions2018-11-22_11-04-03AM.log 

3. Switch to root user login

4. Execute two sh files

4.1. sh /opt/oracle/product/oraInventory/orainstRoot.sh

If there is no script in the directory, you can create a new one with the following content:

# cat /oracle/oraInventory/orainstRoot.sh

#!/bin/sh

AWK=/bin/awk

CHMOD=/bin/chmod

CHGRP=/bin/chgrp

CP=/bin/cp

ECHO=/bin/echo

MKDIR=/bin/mkdir

RUID=`/usr/bin/id|$AWK -F 'print$2' |$AWK−F 'print$2'|$AWK−F '{print $2}'|$AWK -F '{print $1}'`

if [ ${RUID} != "root" ];then

  $ECHO "This script must be executed as root"

  exit 1

fi

if [ -d "/etc" ]; then

$CHMOD 755 /etc;

else

$MKDIR -p /etc;

fi

if [ -f "/oracle/oraInventory/oraInst.loc" ]; then

$CP /oracle/oraInventory/oraInst.loc /etc/oraInst.loc;

$CHMOD 644 /etc/oraInst.loc

else

INVPTR=/etc/oraInst.loc

INVLOC=/oracle/oraInventory

GRP=oinstall

PTRDIR="`dirname $INVPTR`";

# Create the software inventory location pointer file

if [ ! -d "$PTRDIR" ]; then

 $MKDIR -p $PTRDIR;

fi

$ECHO "Creating the Oracle inventory pointer file ($INVPTR)";

$ECHO inventory_loc = $INVLOC > $INVPTR

$ECHO inst_group=$GRP >> $INVPTR

chmod 644 $INVPTR

# Create the inventory directory if it doesn't exist

if [ ! -d "$INVLOC" ];then

 $ECHO "Creating the Oracle inventory directory ($INVLOC)";

 $MKDIR -p $INVLOC;

fi

fi

$ECHO "Changing permissions of /oracle/oraInventory.

Adding read,write permissions for group.

Removing read, write, execute permissions for world.

";

$CHMOD -R g+rw,o-rwx /oracle/oraInventory;

if [ $? != 0 ]; then

 $ECHO "OUI-35086:WARNING: chmod of /oracle/oraInventory

Adding read,write permissions for group.

,Removing read,write,execute permissions for world.

 failed!";

fi

$ECHO "Changing groupname of /oracle/oraInventory to oinstall.";

$CHGRP -R oinstall /oracle/oraInventory;

if [ $? != 0 ]; then

 $ECHO "OUI-10057:WARNING: chgrp of /oracle/oraInventory to oinstall failed!";

fi

$ECHO "The execution of the script is complete."

4.2. sh /opt/oracle/product/12.2.0/db_1/root.sh

5. Switch to oracle user login

6. Install monitoring

$ORACLE_HOME/bin/netca /silent /responseFile /opt/oracle/database/response/netca.rsp

7. Start the monitoring program

lsnrctl start

8. Check the monitoring status

lsnrctl status

9. Create a database through dbca

/opt/oracle/product/12.2.0/db_1/bin/dbca -silent -createDatabase -templateName General_Purpose.dbc -gdbname orcl -sid orcl -responseFile NO_VALUE -characterSet ZHS16GBK -memoryPercentage 30 -emConfiguration LOCAL

(Delete: dbca -silent -deleteDatabase -sourcedb orcl -sid orcl)

10. Start the instance (after creation, it will usually start automatically)

sqlplus / as sysdba
SQL> startup
SQL> select instance_name,version from v$instance;

View the database file dbf

SQL> select name from v$datafile;

Summarize

The above is a detailed graphic tutorial on how to silently install oracle12.2 on CentOS under VMware. I hope it will be helpful to you. If you have any questions, please leave me a message and I will reply to you in time. I would also like to thank everyone for their support of the 123WORDPRESS.COM website!