Monday, July 27, 2020

Oracle Database 19c Silent Mode Installation

Silent mode installation allows to configure necessary Oracle components without using graphical interface as we usually use in ./runInstaller 
In silent mode installation a response file can be used to provide all the required information for the installation, so no additional user input is required.

Pre-requisites Checks
# grep MemTotal /proc/meminfo -->We need at least 8192 MB of physical RAM.

# grep SwapTotal /proc/meminfo/* -->We need at least 8192 MB of swap
RAM up to 1024MB then swap = 2 times the size of RAM
RAM between 2049MB and 8192MB then swap = equal to the size of RAM
RAM more than 8192MB then swap size = 0.75 times the size of RAM

# df -h /tmp/* -->You need to have at least 2048 MB of space in the /tmp directory.

# df -h /u01 --> minimum 10GB space required for 19c database software

# grep "model name" /proc/cpuinfo -->Verify that the processor architecture matches the Oracle software release that you want to install. If you do not see the expected output, then you cannot install the software on this system.

[oracle@rac1 ~]$ cat /etc/redhat-release -->Verify OS version Oracle Linux Server release 7.5

[root@rac1 ~]# yum install -y oracle-database-preinstall-19c -->Oracle Installation Prerequisites
Download 19c db software from OTN site, https://www.oracle.com/database/technologies/oracle19c-linux-downloads.html

NOTE: You can't edit oracle home location while installation using OUI. It will pickup automatically ORACLE HOME location, where you have unzipped database binaries. Hence directly unzip in ORACLE HOME location and then start ./runInstaller
After unzip, it will NOT keep all files in single directory like 10g,11g and 12c.

Backup response file (db_install.rsp)
[oracle@rac1 response]$ ls -ltr /u01/app/oracle/product/19.0.0/db_1/install/response/db_install.rsp
[oracle@rac1 response]$ cd /u01/app/oracle/product/19.0.0/db_1/install/response
[oracle@rac1 response]$ cp db_install.rsp db_install.rsp.bkp

Modify the below parameters in the response file db_install.rsp.

[oracle@rac1 response]$ vi db_install.rsp

oracle.install.option=INSTALL_DB_SWONLY
UNIX_GROUP_NAME=oinstall
INVENTORY_LOCATION=/u01/app/oraInventory
ORACLE_HOME=/u01/app/oracle/product/19.0.0/db_1
ORACLE_BASE=/u01/app/oracle
oracle.install.db.InstallEdition=EE
oracle.install.db.OSDBA_GROUP=oinstall
oracle.install.db.OSOPER_GROUP=oinstall
oracle.install.db.OSBACKUPDBA_GROUP=oinstall
oracle.install.db.OSDGDBA_GROUP=oinstall
oracle.install.db.OSKMDBA_GROUP=oinstall
oracle.install.db.OSRACDBA_GROUP=oinstall
oracle.install.db.rootconfig.executeRootScript=false

[oracle@rac1 ~]$ cd /u01/app/oracle/product/19.0.0/db_1/
[oracle@rac1 db_1]$ ls -ltr runInstaller
-rwxr-x---. 1 oracle oinstall 1783 Jul 26 2020 runInstaller

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

Install oracle software in Silent mode
[oracle@rac1 db_1]$ ./runInstaller -silent -responseFile /u01/app/oracle/product/19.0.0/db_1/install/response/db_install.rsp

As a root user, execute the following script(s):
        /u01/app/oracle/product/19.0.0/db_1/root.sh

Verification
Verify the database software setup by setting the below environment variables and launch sqlplus utlity.
[oracle@rac1 db_1]$ export ORACLE_HOME=/u01/app/oracle/product/19.0.0/db_1
[oracle@rac1 db_1]$ export PATH=/u01/app/oracle/product/19.0.0/db_1/bin:$PATH;
[oracle@rac1 db_1]$ which sqlplus
/u01/app/oracle/product/19.0.0/db_1/bin/sqlplus
[oracle@rac1 db_1]$ sqlplus
SQL*Plus: Release 19.0.0.0.0 - Production on Sun Jan 26 13:06:03 2020
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle.  All rights reserved.
Enter user-name:

So here your oracle database 19c software is successfully setup. To create the database you can use dbca database configuration assistance utility.