OraEasy

Introduction: We are going to configure a Bidirectional Golden Gate setup between two Oracle database environments. We will use Oracle Golden Gate 19c classic version. In this article, we will install the Golden Gate software and prepare the database for replication. Scenario: Suppose there are two bracnhes of a company one in Delhi & one in Noida. Both branches have similar business setup but using different database instances. So both databases are being used for read/write operation, thus in order to make both databases in sync we can use Bidirectional Golden Gate setup. Prerequisites: Below are the minimum requirements for Bidirectional Golden Gate setup. Databases should be installed & running in source & target. Connectivity between source & target servers. Free Disk space (approx. 15GB) for Golden Gate binary on both servers. Working TNS entry in tnsnames.ora file for database in both servers. Software Download: Oracle GoldenGate 19c on Linu...

Introduction: In this article, we will create a PDB manually using SQL command in different ways. We will also see how to rename and drop the PDB manually using SQL. Prerequisites: RMAN backup for rollback purpose. Disk space requirement is depending upon the PDB size. Summary of activities: We will do below acivities with PDB. Creating a clone PDB from an existing PDB. Creating a blank PDB. Creating a clone PDB from an existing PDB of different container database. Renaming a PDB. Dropping a PDB. Now let's proceed to perform manual PDB creation step by step: Clone the existing PDB. 1. We will create a clone PDB "TESTPDB" from existing PDB "ORCLPDB". Take precheck. SQL> show pdbs CON_ID CON_NAME OPEN MODE RESTRICTED ---------- ------------------------------ ---------- ---------- 2 PDB$SEED READ ONLY N...

Introduction: As Oracle 19c stands as the Long-Term Support (LTS) release in Oracle’s database roadmap, upgrading from Oracle 12c is not merely a version shift—it’s a strategic move to maintain support, unlock advanced features, and ensure long-term performance, stability, and compliance. In this article, we will see how to upgrade the database from 12c to 19c step by step. Methods of Upgradation: Using DBUA (Database Upgrade Assistant) Using Manual method Using autoupgrade.jar Using RMAN Along With catctl.pl Database Dictionary Upgrade We have already covered the upgrade using DBUA, Manual method and autoupgrade. Please visit: Upgrade Using DBUA Upgrade Using Manual Method Upgrade Using autoupgrade.jar In this article we will use RMAN & Database Dictionary Upgrade along With catctl.pl method for upgrade. Approach: We will first do full RMAN restoration from 12c to 19c. Then we will run database upgrade using catctl...