Steps to create a Database Link from Oracle to MSSQL Server Nowadays many companies are using a mix of RDBMS systems, for example, some instances are running on Oracle and other instances are running on MSSQL Server, and if we want to access data we need to do it using a heterogeneous connection. Heterogeneous connections allow us to query data from non-Oracle databases using SQL. In the previous two
Steps to Clone Oracle Database from Windows to Oracle Linux In the previous blog, we saw Steps to create a Heterogeneous Dataguard between Windows and Linux Click here to read more. In this blog, we are going to perform a clone of Windows Oracle DB by taking RMAN backup and restoring it to Oracle Linux Server.
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,
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
Steps To Increase Mount Point Space In Oracle Linux Sometimes we need to increase our server mount point space if we are running out of disk space. We are performing this demonstration on VMware Workstation to increase mount point space in Oracle Linux, and we will extend our /u01 mount point which is 50GB in
Pluggable Database (PDB) Migration & Upgrade from 12c to 19c using Remote Clone In a recent blog, we demonstrated Pluggable Database (PDB) Migration & Upgrade from 12c to 19c using Full Transportable Tablespace Export-Import Click here to read more. In this blog, we will see steps for How we can migrate PDB from Window OS into
Pluggable Database (PDB) Migration & Upgrade from 12c to 19c using Full Transportable Tablespace Export-Import There are many ways to migrate PDB like Remote Clone, Unplug – Plug, RMAN. Here we will explore Full transportable tablespace export/import method that is fast and efficient. We will be migrating a pluggable database (TESTHIST) running on Oracle 12C
