Steps to Apply Combo Patch (Oct 2022) on Clusterware in Two Node RAC in Oracle In this article, we are going to demonstrate the Steps to Apply combo patch 34449117 (19.17.0.0.221018) of October 2022 on Oracle Clusterware in Two Node RAC version 19c. Here we will apply a combo patch 34449117 that contains two patches 34416665 (GRID) and 34411846 […]
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 […]
RMAN Active Duplicate Database in Oracle from ASM to ASM In a recent article, we demonstrated about Step by Step Migrate Database from Non-ASM to ASM in Oracle click here to know more about it. In this article, we will demonstrate step by step RMAN Active Duplicate Database in Oracle from ASM to ASM with […]
Step by Step Migrate Database from Non-ASM to ASM in Oracle This article is a continuation of a recent article where we have demonstrated Offline Restore or Clone Database on the same server or rename database in Oracle click here to go through it. In this article, we will perform a Step by Step Migrate […]
Starting and stopping an Oracle ASM instance for Noncluster Databases Oracle database is made up of memory structure, background processes, and database. This memory structure and background processes altogether called Oracle Instance. The same as Oracle Database Instance ASM(Automatic Storage Management) instance is also built. It’s also having separate SGA(System global area) and background processes. […]
Sometimes we need to fetch ASM diskgroup utilization of the database in Oracle. Below is the SQL query to find ASM diskgroup size in a database which includes Name, Total_GB, Free_GB, Used_GB and Free_percentage of the disk. SQL query to fetch ASM diksgroup size. Click here to get sample output. Click here to know about […]
How to add disks to ASM disk group in oracle using command line. Application team requested to create new user along with new tablespace. This is require to deploy new application to fulfil testing. As per requirement, we need additional space in our database. Below are the steps that we have to follow to add […]
Recent Comments