Oracle and MySQL Database
Learn how to migrate an Oracle 19c Pluggable Database (PDB) using the Unplug/Plug method between different servers in a step-by-step and professional way. This guide explains the complete process of moving a PDB from one CDB to another across separate Linux hosts, including pre-checks, unplugging from the source database, copying datafiles, plugging into the target … Read more
This tutorial explains how to install Oracle Database 19c with the latest Release Update (RU) patch on Oracle Linux 9.4 using the ApplyRU method. The guide covers OS prerequisites, required packages, Oracle user creation, kernel parameters, OPatch update, and post-installation verification. This installation method is fully suitable for production and enterprise environments. Steps to Install … Read more
Applying the Oracle 19c RU 19.31 Patch is essential for improving database security, performance, stability, and Oracle support compliance. In this step-by-step guide, you will learn how to apply the Oracle 19c RU 19.31 Patch on Oracle Database 19c running on Linux using the OPatch utility. This tutorial covers prerequisite checks, OPatch upgrade, patch installation, … Read more
Apply RU 19.28 Patch on Oracle 19c Database: In this article we will discuss about how to Apply RU 19.28 Patch on Oracle 19c Database (Standalone). Steps to Apply RU Patch on Oracle 19c Database: Environment Details: Download the patch from MOS (My Oracle Support): Unzip Patch: Check OPatch Utility version and Update OPatch Utility: … Read more
Migrate a PDB Using Unplug/Plug on the same server: In this article, we explain how to migrate a PDB using the Unplug/Plug method in Oracle 19c on the same server. In this case, the source and target CDBs are different, but both are hosted on the same server and use the same Oracle home. Environment … Read more
ORA-19809: limit exceeded for recovery files: In this article we will be discuss about the ORA-19809: limit exceeded for recovery files. This same solution is also working for the error ORA-00257: archiver error. Connect internal only, until freed. Error: Cause: db_recovery_file_dest_size used space was filled. Solution: Check the db_recovery_file_dest_size value and the space usage in … Read more
Enable or Disable Unified Auditing in Oracle 19c: In this Article we will discuss about how to Enable or Disable Unified Auditing in Oracle 19c. What is Unified Auditing? After installing and starting up your oracle 19c database, check that the “Unified Auditing” status by default it should be “FALSE”. When you create a new … Read more
Auditing in Oracle Database: In this article we will discuss about Auditing in Oracle Database. Here we use our Oracle 19c database. Auditing is a default feature in Oracle Database to monitoring and recording of configured database actions, from both database users and nondatabase users. Below are the initialization parameters that can be displayed and … Read more
Recover Standby Database from Primary using Service in Oracle: In this article we will discuss about how to Recover Standby Database from Primary using Service in Oracle 19c. If your standby database is out of sync from primary. Or some archive logs got deleted before it is being shipped or applied to standby. Then, you … Read more
Transparent Data Encryption In Oracle: In this article we will discuss about configuring and enabling Transparent Data Encryption In Oracle 11g (11.2.0.4) RAC Database. Let’s see steps how to configure TDE. Take full database RMAN backup: Take full database RMAN backup before starting the TDE implementation activity. Use below script to take full Database RMAN … Read more
