How to Find Database Properties in Oracle In this article, we will prepare a script for How to Find Database Properties in Oracle. Using the view DATABASE_PROPERTIES, we can fetch the default values of the database like the default permanent & temporary tablespace, dictionary endian type, character set, global database name, etc. Execute the below […]
Oracle Critical Database Patch ID for April 2022 An Essential/Critical Patch Update could be a collection of patches for multiple security vulnerabilities. These patches address vulnerabilities in Oracle code and third-party elements enclosed in Oracle merchandise. These patches are sometimes additive, however every informative describes only the protection patches intercalary since the previous essential Patch Update informative. […]
Steps to create a Heterogeneous Dataguard between Windows and Linux Heterogenous Dataguard is a best use case, when we need to perform DB migration from Windows to Linux with minimum downtime as the actual downtime comprises only DB switch. As both Windows and Linux are Little Endian so no conversion is required at the target […]
Steps to Add and Extend Swap Space in Linux Swap space is a virtual amount of physical memory that is allocated for use by the operating system when available RAM memory has been fully utilized. This swap memory is located on the disc and since disc reads and writes are slower than reading from RAM, […]
Step by Step Manual Upgrade Container (CDB-PDB) Database from 12c to 19c in Multitenant Architecture In a recent post, we demonstrated Step by Step Manual Upgrade Oracle Database from 12c to 19c, click here to read about it. In this article, we are going to demonstrate Step by Step Manual Upgrade Container (CDB-PDB) Database from 12c […]
Steps to Upgrade Grid Infra – Standalone (GI) and Oracle Database from 12.2 to 19.14 In recent two blogs, we discuss Applying the latest JAN-22 RU 33583921 on Grid Infra – Standalone and Database Home (OH) 12.2 Click here to read more. & Steps to Apply Database and Grid Infrastructure RU Patch Before Grid Infrastructure […]
Steps to Apply Database and Grid Infrastructure RU Patch Before Grid Infrastructure Configuration (before root.sh or rootupgrade.sh execution) If you are planning to upgrade your Grid Infrastructure (GI) and Database from the 12.2 version to the latest Release Update (RU) 19.14. First, we need to download Gold Image 19.3 software for GI and Database and then […]
Applying latest JAN-22 RU 33583921 on Grid Infra-Standalone (GI) and Oracle Database Home (OH) 12.2 The GI Jan 2022 Release Update 12.2.0.1.220118 includes updates for both the Clusterware (GRID) home and database (RDBMS) home. In this blog we are going to apply Patch 33583921 – GI Jan 2022 Release Update 12.2.0.1.220118 on our Grid Infrastructure […]
Step by Step Upgrade Oracle Database from 12c to 19c using DBUA In a previous post, we demonstrated Step by Step Manual Upgrade Oracle Database from 12c to 19c, click here to read more about it. In this article, we are going to demonstrate Step by Step Upgrade Oracle Database from12c to 19c using DBUA […]
Step by Step Manual Upgrade Oracle Database from 12c to 19c In a recent post, we demonstrated Step by Step Oracle Database Upgrade from 11g (11.2.0.4) to 12c (12.2.0.1) using DBUA, click here to read more about it. In this article, we are going to demonstrate Step by Step Manual Upgrade Oracle Database from12c to […]
Recent Comments