Oracle Database 23c is Here!
Oracle is here with their latest version of RDBMS (Relational Database Management System) Technology – Developer edition/release. This allows ... Read More
Learn more about why Eclipsys has been named the 2023 Best Workplaces in Technology and Ontario, Certified as a Great Place to Work in Canada and named Canada’s Top SME Employer!
Learn more!This blog shows step-by-step how to install/set up a new Oracle 19.3 home and apply the 19.11 release update together.
1. Download and unzip 19.3.0 into its new Oracle Home, link below
https://www.oracle.com/ca-en/database/technologies/oracle19c-linux-downloads.html
2. Remove the OPatch directory and unzip the newest OPatch into the new Oracle Home (12.2.0.1.24 or later)
https://updates.oracle.com/download/6880880.html
3. Download and unzip 19.11.0 into a totally separate subdirectory (Patch 32545008 – GI Release Update 19.11.0.0.210420)
32545008 – Contains patches for both Grid/DB Home, If the installation is standalone apply only 32545013 from the downloaded patches.
5. Apply the patches on the new home – There are 2 methods that can be used,
5.1 Apply the Patch directly onto the home during the initial setup using “ApplyRU” or after the Database Home software is installed, apply using “OPatch”.
Using ApplyRU
5.1.1 Unzip LINUX.X64_193000_db_home.zip file.
5.1.2 Setup of Oracle Home
$ ./runInstaller –ApplyRU path/32545013
This will apply the DB RU onto the home and start the GUI post the patch application.
5.2 Using OPatch – Once the DB Home is installed, we apply the RU on top of the installed home.
Read me of the Patch Document:
https://updates.oracle.com/Orion/Services/download?type=readme&aru=24185767
5.2.1 Run pre-check to see if the patches conflict with the installed home binaries.
% $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir <UNZIPPED_PATCH_LOCATION>/32545008/32545013
5.2.2 For database home, as Home User:
% cat /tmp/patch_list_dbhome.txt
<UNZIPPED_PATCH_LOCATION>/32545008/32545013
<UNZIPPED_PATCH_LOCATION>/32545008/32579761
% $ORACLE_HOME/OPatch/opatch prereq CheckSystemSpace -phBaseFile /tmp/patch_list_dbhome.txt
The command output reports pass and fail messages as per the system space availability:
If OPatch reports Prereq “checkSystemSpace” failed., then clean up the system space as the required amount of space is not available.
If OPatch reports Prereq “checkSystemSpace” passed., then no action is needed. Proceed with patch installation.
5.2.3 For a single instance host, shut down all instances and listeners associated with the Oracle Home.
Set your current directory to the directory where the patch is located and run below
cd <UNZIPPED_PATCH_LOCATION>/32545008/32545013
opatch apply
6. Run the Datapatch post the patch apply
./datapatch -verbose
Download the following patch from Oracle Support
Read me file for the Patch.
https://updates.oracle.com/Orion/Services/download?type=readme&aru=24099425
2. Once the Db is patched and up to the current 19.11 RU update apply the OJVM patchset.
3. Unzip 32399816 patch p32399816_190000_Linux-x86-64.zip
4. Run Pre-check for any conflicts with Installed home.
$ cd <PATCH_TOP_DIR>/32399816
$ opatch prereq CheckConflictAgainstOHWithDetail -ph ./
5. Apply Patches
5.1 Set your current directory to the directory where the patch is located and then run the OPatch utility by entering the following commands:
$ cd <PATCH_TOP_DIR>/32399816
opatch apply
From 19c onwards, we don’t need to start the database in upgrade mode to apply the Datapatch, D should be up and can be run from any one instance (In case of RAC)
./datapatch -verbose
Oracle is here with their latest version of RDBMS (Relational Database Management System) Technology – Developer edition/release. This allows ... Read More
In this ever-changing database world, it’s good to have a few things which are constant, tamper proof and can validate the authenticity of an ... Read More