This blog describes silent installation and configuration of Grid Infrastructure 18c (64bit) and Oracle Database 18c (64bit) on RHEL 7. The implementation described in this blog is based on a server installation with a minimum resource allocations required by Oracle.
Download Software
- Database 18c (18.3) for Linux x86-64 LINUX.X64_180000_db_home.zip)
- Grid Infrastructure (18.3) for Linux x86-64 (LINUX.X64_180000_grid_home.zip)
Pre-installation Tasks
Oracle recommends that you disable THP on all Oracle Database servers and rather use standard HugePages for enhanced performance.
Oracle recommends that you instead use standard HugePages for enhanced performance
Ensure the /etc/hosts file to contain the IP and FQDN of the server.
127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4 ::1 localhost localhost.localdomain localhost6 localhost6.localdomain6 192.168.1.18 dbhost.local dbhost
Ensure the correct hostname in the “/etc/hostname” file.
Identify your ASM disk by adding them to the to /etc/udev/rules.d/97-oracleasm.rules
OWNER="grid", GROUP="asmadmin", MODE="0660", ENV{DEVTYPE}=="disk", KERNEL=="xvdca", SYMLINK+="oracleasm/disks/DATA1"
OWNER="grid", GROUP="asmadmin", MODE="0660", ENV{DEVTYPE}=="disk", KERNEL=="xvdcb", SYMLINK+="oracleasm/disks/FRA1"Reload udev rules
# udevadm control --reload-rules
# udevadm triggerRun the following command to initialize ASM disks
# for dsk in `ls /dev/oracleasm/disks/*`; do echo 'initializing ',${dsk}; dd if=/dev/zero of=${dsk} bs=4096 count=1; done Adjust your Linux kernels as needed for your environment by adding the necessary entries and values in the /etc/sysctl.conf.
Reload the updated Linux kernels by running the following command:
# sysctl -pAdjust system resources available to oracle and grid OS user process by adding the necessary enrties and values in the /etc/security/limits.d/oracle-database-preinstall-18c.conf.
Install the following required OS packages required for RHEL 7.
# yum install -y bc binutils compat-libcap1 compat-libstdc++-33 compat-libstdc++-33.i686 elfutils-libelf.i686 elfutils-libelf elfutils-libelf-devel.i686 elfutils-libelf-devel fontconfig-devel glibc.i686 glibc glibc-devel.i686 glibc-devel ksh libaio.i686 libaio libaio-devel.i686 libaio-devel libX11.i686 libX11 libXau.i686 libXau libXi.i686 libXi libXtst.i686 libXtst libgcc.i686 libgcc librdmacm-devel libstdc++.i686 libstdc++ libstdc++-devel.i686 libstdc++-devel libxcb.i686 libxcb make nfs-utils net-tools python python-configshell python-rtslib python-six smartmontools sysstat targetcli unixODBCCreate the OS users and groups for the Oracle software stack
# groupadd oinstall
# groupadd dba
# groupadd bckpdba
# groupadd dgdba
# groupadd kmdba
# groupadd asmoper
# groupadd asmadmin
# groupadd asmdba
# useradd -g oinstall -G dba,bckpdba,dgdba,kmdba,asmoper,asmadmin oracle
# useradd -g oinstall -G dba,asmoper,asmadmin gridEnsure secure Linux is set to “targeted” in /etc/selinux/config
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=enforcing SELINUXTYPE= can take one of three two values: targeted - Targeted processes are protected, minimum - Modification of targeted policy. Only selected processes are protected. mls - Multi Level Security protection. SELINUXTYPE=targeted
Create software directories as needed. In my case I will simply assign ownership of an entire mountpoint
# chown -R oracle:oinstall /u01
# chmod 770 /u01Grid Infrastructure Installation & Configuration Tasks (Silent Mode)
Login as the grid OS user and perform the following actions
Add the following lines to the /home/grid/.bash_profile
ORACLE_BASE=/u01/grid/base; export ORACLE_BASE GRID_HOME=/u01/grid/home; export GRID_HOME ORACLE_HOME=$GRID_HOME; export ORACLE_HOME ORACLE_SID=+ASM; export ORACLE_SID PATH=$PATH:$ORACLE_HOME/bin:$ORACLE_HOME/OPatch; export PATH
Source the grid OS user bash profile
$ source ~/.bash_profileAdd the following lines in /home/grid/gi_soft.rsp in-order to create the response file for silent software installation.
oracle.install.responseFileVersion=/oracle/install/rspfmt_crsinstall_response_schema_v18.0.0 INVENTORY_LOCATION=/u01/oraInventory oracle.install.option=HA_CONFIG ORACLE_BASE=/u01/grid/base oracle.install.asm.OSDBA=oinstall oracle.install.asm.OSASM=asmadmin oracle.install.asm.storageOption=ASM oracle.install.asm.SYSASMPassword=putYourPassword oracle.install.asm.diskGroup.name=DATA oracle.install.asm.diskGroup.redundancy=EXTERNAL oracle.install.asm.diskGroup.disks=/dev/oracleasm/disks/DATA1,/dev/oracleasm/disks/FRA1 oracle.install.asm.diskGroup.diskDiscoveryString=/dev/oracleasm/disks/* oracle.install.asm.monitorPassword=putYourPassword oracle.install.asm.configureAFD=false
Unzip grid 18c software
$ mkdir -p /u01/grid/home
$ unzip /software_download/LINUX.X64_180000_grid_home.zip -d /u01/grid/homeInvoke OUI silent installation
$ /u01/grid/home/gridSetup.sh -silent -responseFile /home/grid/gi_soft.rspAfter installation, execute post installation script as root OS user
# /u01/oraInventory/orainstRoot.sh
# /u01/grid/home/root.sh[Run the following command to complete GI configuration
$ /u01/grid/home/gridSetup.sh -executeConfigTools -responseFile /home/grid/gi_soft.rsp -silentConfirm +ASM instance is running
$ ps -ef | grep smonConfirm +DATA diskgroup is created with the correct settings EXTERNAL redundancy
$ asmcmd lsdgCreate remaining ASM diskgroups that will be used by the database
$ asmca -silent -createDiskGroup -diskString '/dev/oracleasm/disks/*' -diskGroupName FRA -disk '/dev/oracleasm/disks/FRA*' -redundancy EXTERNAL -au_size 4Database Server Installation Tasks (Silent)
Login as the oracle OS user and perform the following actions
Add the following lines to the /home/oracle/.bash_profile
ORACLE_BASE=/u01/app; export ORACLE_BASE ORACLE_HOME=/u01/app/18R3; export ORACLE_HOME export ORACLE_SID=testdb PATH=$PATH:$ORACLE_HOME/bin:$ORACLE_HOME/OPatch; export PATH
Source the profile
$ source ~/.bash_profileAdd the following lines in /home/oracle/db_soft_only.rsp in-order to create the response file for silent software only installation.
oracle.install.responseFileVersion=/oracle/install/rspfmt_dbinstall_response_schema_v18.0.0 oracle.install.option=INSTALL_DB_SWONLY UNIX_GROUP_NAME=oinstall INVENTORY_LOCATION=/u01/oraInventory ORACLE_HOME=/u01/app/18R3 ORACLE_BASE=/u01/app oracle.install.db.InstallEdition=EE oracle.install.db.OSDBA_GROUP=dba oracle.install.db.OSOPER_GROUP=dba oracle.install.db.OSBACKUPDBA_GROUP=bckpdba oracle.install.db.OSDGDBA_GROUP=dgdba oracle.install.db.OSKMDBA_GROUP=kmdba oracle.install.db.OSRACDBA_GROUP=dba SECURITY_UPDATES_VIA_MYORACLESUPPORT=false DECLINE_SECURITY_UPDATES=true oracle.installer.autoupdates.option=SKIP_UPDATES
Unzip oracle database 18c software
$ unzip /software_download/LINUX.X64_180000_db_home.zip -d /u01/app/18R3Invoke OUI silent installation
$ u01/app/18R3/runInstaller -silent -responseFile ~/db_soft_only.rspUpon installation completion, execute the post installation scripts as root OS user
# /u01/app/18R3/root.shDatabase Creation Tasks (Silent)
Login as the oracle OS user and perform the following actions
Use the command below to create a general purpose transaction database
$ dbca -silent -createDatabase -templateName General_Purpose.dbc -gdbName $ORACLE_SID -sid $ORACLE_SID -sysPassword putYOURPASSWORD -systemPassword putYOURPASSWORD -storageType ASM -diskGroupName +DATA -recoveryGroupName +FRA -responseFile NO_VALUE -createAsContainerDatabase false -characterSet AL32UTF8 -nationalCharacterSet AL16UTF16 -archiveLogMode true -databaseType MULTIPURPOSE -emConfiguration NONEConfirm database instance is running and database is open (READ WRITE)
ps -ef | grep smonSQL> select open_mode from v$database; 
