Hey readers, if you remember, last post was about how to create physical standby database in Oracle 19c And there I mentioned that you have to install the binaries on your DR server. And apply same patch as that of production. Earlier when we were on 11g we used to download the Oracle Binaries and PSU and install it separately. But what if I tell you we can do it simultaneously? Today we are going to apply PSU on DR server along with Oracle 19c Binaries installation. Lets begin with how to Install Oracle 19c binaries along with RU.
Table of Contents
Step by Step How To Install Oracle 19c Binaries Along with RU
When we are doing installation on a fresh server, it’s always mandatory to complete all the pre-requisites from OS end, Storage end and Oracle database end to have a Clean Installation. Lets focus on each of the Points.
What are Pre-requisite for Oracle 19c Installation
Pre-requisite for Oracle 19c with respect to OS
OS User Creation
Create user as Oracle and make it as part of oinstall as primary group and dba,oper,asmadmin.asmdba as secondary group.
OS Compatibility with Oracle 19c
If you are doing fresh installation then, it’s always better to check the certification of the version of Oracle. And inform System Administrator to install Specific version of OS. For Example For linux you can check this link – https://docs.oracle.com/en/database/oracle/oracle-database/19/ladbi/operating-system-checklist-for-oracle-database-installation-on-linux.html#GUID-E5C0A90E-7750-45D9-A8BC-C7319ED934F0
or
Check the Certification tab if you have Oracle Support login.
Package Installation as Per Oracle 19c
Make sure all the packages are installed. It become easy for you to inform System Administrator as you already have Production server. You inform them to install all the rpms same as that of Production on which we have system already running. If you are doing it on production then Oracle comes with a pre-requisite rpm itself which will install all the requisite for you. Let me provide you oracle official link for Linux – https://docs.oracle.com/en/database/oracle/oracle-database/19/ladbi/installing-the-oracle-preinstallation-rpm-with-uln-support.html#GUID-AF94713E-97AF-4F20-8DBC-36BC383D0301
For Linux 7 you can use -
yum install oracle-database-preinstall-19c
Server Configuration Pre-requisite for Oracle 19c
When you are installing Oracle 19c we need to have RAM,swap,/tmp and Mount point in specific way then only you will be able to install the Oracle binaries on the server.
Please go through the list – here https://docs.oracle.com/en/database/oracle/oracle-database/19/ladbi/server-configuration-checklist-for-oracle-database-installation.html#GUID-CD4657FB-2DDC-4B30-AAB4-2C927045A86D
Pre-requisite for Oracle 19c with respect to Storage
We usually keep 50 GB mount point for Oracle RDBMS Home Installation. It’s not an hard and fast rule here. But I recommend to keep buffer space if client is not ready to give additional mount point for storing Patches. So go with 100GB Oracle Home.
Pre-requisite for Oracle 19c with respect to Oracle DBA
Basic Directory Structure
We usually follow a directory structure to keep everything similar when I am doing a database installation. So decide your oracle home location, oracle base and oracle inventory location.
mkdir -p /oracle19c/oracle/app/product/19.3.0/
mkdir -p /oracle19c/oraInventory/
Following are my details –
ORACLE_HOME=/oracle19c/oracle/app/product/19.3.0
ORACLE_BASE=/oracle19c/oracle/app
Update OraInst.loc file –
What is the content of oraInst.loc?
oraInst.loc file will have two details – inventory location and group of inventory. This file will tell you your Central Inventory. And Central Inventory is kind of repository which will have details of all the oracle home/client/grid infrastructure (if any) installed on your server This can be re-created if lost, though you should be aware of all the oracle home. Since you have to re-register all database homes on home again.
You can read – how to recreate central inventory in oracle
If this is your fresh installation on a brand new server then you have to make sure you have changed the pointing to your system’s Central Inventory you chose to have.
vi /etc/oraInst.loc ###AIX
inventory_loc=/oracle19c/oraInventory
inst_group=oinstall
-------------------------------------------
File location changes for Sun Solaris
vi /var/opt/oracle/oraInst.loc ###Sun Solaris
inventory_loc=/oracle19c/oraInventory
inst_group=oinstall
Download The Oracle 19c Software
You have to download the software from oracle link. It requires authentication ( support.oracle.com login )
Use following official link to download Oracle 19c based on OS platform –
cp AIX.PPC64_193000_db_home.zip /oracle19c/oracle/app/product/19.3.0/
cd /oracle19c/oracle/app/product/19.3.0/
unzip AIX.PPC64_193000_db_home.zip
https://www.oracle.com/in/database/technologies/oracle-database-software-downloads.html#19c
Here I have downloaded AIX specific Oracle 19c software And I have moved the software on server.
Download the Latest RU
Based on what RU you want to apply on Top of your oracle home, you have to download it and move it to server. Along with this update OPatch utility version based on Readme.html on the server.
mkdir /oracle19c/PATCHES
cp p32545008_190000_AIX64-5L.zip /oracle19c/PATCHES
cd /oracle19c/PATCHES
unzip p32545008_190000_AIX64-5L.zip
You can use Oracle Support to Identify latest PSU available -> Assistant: Download Reference for Oracle Database/GI Update, Revision, PSU, SPU(CPU), Bundle Patches, Patchsets and Base Releases (Doc ID 2118136.2) If you need I will create a separate blog on how to find latest PSU/RU patches.
Check out How to update OPatch Utility | how to Install Latest OPatch Utility
All Slides on Installation of Oracle 19c Binaries Along with PSU
1 Go to Oracle Home location where you unzip the home and execute following command-
$ cd /oracle19c/oracle/app/product/19.3.0/
$ ./runInstaller -applyRU /oracle19c/PATCHES/32545008
Preparing the home to patch...
Applying the patch /oracle19c/PATCHES/32545008...
Successfully applied the patch.
The log can be found at: /oracle19c/oraInventory/logs/InstallActions2021-07-26_11-10-41PM/installerPatchActions_2021-07-26_11-10-41PM.log
********************************************************************************
Your platform requires the root user to perform certain pre-installation
OS preparation. The root user should run the shell script 'rootpre.sh' before
you proceed with Oracle installation. The rootpre.sh script can be found at:
/oracle19c/oracle/app/product/19.3.0/clone/rootpre.sh
Answer 'y' if root has run 'rootpre.sh' so you can proceed with Oracle
installation.
Answer 'n' to abort installation and then ask root to run 'rootpre.sh'.
********************************************************************************
Has 'rootpre.sh' been run by root in this machine? [y/n] (n)
y
$ ./runInstaller -applyRU /oracle19c/PATCHES/32545008
Preparing the home to patch...
Applying the patch /oracle19c/PATCHES/32545008...
Successfully applied the patch.
The log can be found at: /oracle19c/oraInventory/logs/InstallActions2021-07-26_11-21-27PM/installerPatchActions_2021-07-26_11-21-27PM.log
********************************************************************************
Your platform requires the root user to perform certain pre-installation
OS preparation. The root user should run the shell script 'rootpre.sh' before
you proceed with Oracle installation. The rootpre.sh script can be found at:
/oracle19c/oracle/app/product/19.3.0/clone/rootpre.sh
Answer 'y' if root has run 'rootpre.sh' so you can proceed with Oracle
installation.
Answer 'n' to abort installation and then ask root to run 'rootpre.sh'.
********************************************************************************
Has 'rootpre.sh' been run by root in this machine? [y/n] (n)
y
Launching Oracle Database Setup Wizard...
The response file for this session can be found at:
/oracle19c/oracle/app/product/19.3.0/install/response/db_2021-07-26_11-21-27PM.rsp
You can find the log of this install session at:
/oracle19c/oraInventory/logs/InstallActions2021-07-26_11-21-27PM/installActions2021-07-26_11-21-27PM.log
$
This way we have completed Installation of Oracle 19c Binaries along with RU. Happy Reading 🙂