Oracle E-Business Suite R12.2: Step-by-Step Guide to Change APPS Password Using FNDCPASS This blog explains the complete procedure to change the APPS/APPLSYS password in Oracle E-Business Suite R12.2 using FNDCPASS …

Installing and Configuring MySQL 8.0 on Ubuntu for Production Use In this blog, we will walk through the complete installation and basic production-level configuration of MySQL 8.0 on Ubuntu Linux. …

Oracle Database RMAN Backup & Recovery – Step by Step Guide Introduction:This guide provides a practical, step-by-step approach to configuring RMAN backups in Oracle Database. Prerequisites:– Oracle Database 19c installed– …

Copy Password File from Primary to Standby ASM   Recently, while working on an Oracle 19c Data Guard environment, I came across a requirement where the password file from the …

Corrupted Undo Tablespace in an Oracle RAC Database Overview Recently, I came across an issue in one of the Oracle RAC database environments where the undo tablespace became problematic and …

Complete Step-by-Step Guide to Convert Physical Standby to Snapshot Standby   Introduction Recently, I had to work on a requirement where the standby database needed to be opened in read-write …

Oracle RAC Architecture Explained (19c & 23ai) – Complete DBA Guide   Introduction Oracle Corporation Real Application Clusters (RAC) is a core technology for high availability and scalability. Unlike traditional …

How to Move SPFILE from ASM to File System   Recently, I faced a requirement where I had to move the Oracle database SPFILE from ASM to the file system, …

Recovery and Restore of Oracle Muti-tenant Environment Scenario: In this scenario we have full backup of entire container and we want to perform point-in-time recovery (PITR) of the entire container …

 Scenario: In this scenario we have full backup of entire container and we want to restore the entire container on different location or directory structure than production.    NOTE: The …