Marvin Lapid, Author at Virtual-DBA Remote DBA Services & Support - Certified Database Experts Remote Database Administration Wed, 12 Nov 2025 16:30:20 +0000 en-US hourly 1 https://wordpress.org/?v=6.9.4 https://virtual-dba.com/wp-content/uploads/cropped-VirtualDBA-favicon-32x32.png Marvin Lapid, Author at Virtual-DBA Remote DBA Services & Support - Certified Database Experts 32 32 ORA-38824 During Datapatch https://virtual-dba.com/blog/ora-38824-during-datapatch/ Wed, 30 Jul 2025 19:53:51 +0000 https://virtual-dba.com/?p=243196 SUMMARY: When applying Oracle patches such as 19.27 (APR2025), the ORA-38824 error is encountered during the datapatch process because a CREATE OR REPLACE command attempts to change the EDITIONABLE property of existing CTXSYS packages, which is resolved by temporarily altering those specific packages to be editionable before re-running datapatch. This scenario highlights the crucial need […]

The post ORA-38824 During Datapatch appeared first on Virtual-DBA Remote DBA Services & Support - Certified Database Experts.

]]> How to Identify the Problematic Session and SQL Statement Behind ORA-1652 https://virtual-dba.com/blog/how-to-identify-the-problematic-session-and-sql-statement-behind-ora-1652/ https://virtual-dba.com/blog/how-to-identify-the-problematic-session-and-sql-statement-behind-ora-1652/#respond Tue, 30 Jul 2024 18:32:43 +0000 https://virtual-dba.com/?p=242465 Identifying the exact SQL statement causing ORA-1652 can often be challenging and time-consuming. Understand that Oracle uses temporary tablespaces as work areas for tasks such as sorting operations for users and sorting during index creation. Increasing the temporary tablespace size can be the quickest way to resolve the issue, but it is only sometimes the […]

The post How to Identify the Problematic Session and SQL Statement Behind ORA-1652 appeared first on Virtual-DBA Remote DBA Services & Support - Certified Database Experts.

]]> https://virtual-dba.com/blog/how-to-identify-the-problematic-session-and-sql-statement-behind-ora-1652/feed/ 0 Data Guard Database Migration and Upgrade to 19c Using Oracle AutoUpgrade https://virtual-dba.com/blog/data-guard-database-migration-and-upgrade-to-19c-using-oracle-autoupgrade/ https://virtual-dba.com/blog/data-guard-database-migration-and-upgrade-to-19c-using-oracle-autoupgrade/#respond Thu, 13 Jun 2024 22:07:00 +0000 https://virtual-dba.com/?p=242297 After completing several database migration and upgrade projects, utilizing Data Guard to migrate the database has been my preferred method when minimal downtime is required, and Golden Gate is not an option. From 11.2.0.1 onwards, it is possible to configure the Physical Standby database with a higher patch set or significant release from the Primary […]

The post Data Guard Database Migration and Upgrade to 19c Using Oracle AutoUpgrade appeared first on Virtual-DBA Remote DBA Services & Support - Certified Database Experts.

]]> https://virtual-dba.com/blog/data-guard-database-migration-and-upgrade-to-19c-using-oracle-autoupgrade/feed/ 0 Cloning 19c Oracle Home on RAC https://virtual-dba.com/blog/cloning-19c-oracle-home-on-rac/ https://virtual-dba.com/blog/cloning-19c-oracle-home-on-rac/#respond Wed, 16 Jun 2021 01:14:00 +0000 https://virtual-dba.com/?p=238239 Starting from Oracle19c cloning your oracle home is a bit different, whether you use this method for out of place patching or rolling out patches to multiple servers we no longer use clone.pl, instead oracle recommends using the software-only install option, available in the runInstaller command. Below are the steps to follow for a RAC […]

The post Cloning 19c Oracle Home on RAC appeared first on Virtual-DBA Remote DBA Services & Support - Certified Database Experts.

]]> https://virtual-dba.com/blog/cloning-19c-oracle-home-on-rac/feed/ 0 Refreshing a Physical Standby Using Recover from Service on 12c https://virtual-dba.com/blog/refreshing-physical-standby-using-recover-from-service-on-12c/ https://virtual-dba.com/blog/refreshing-physical-standby-using-recover-from-service-on-12c/#comments Thu, 02 Jul 2020 22:23:44 +0000 https://virtual-dba.com/?p=37537 SUMMARY: Database administrators must roll forward a troubled Oracle 12c Physical Standby database to resolve severe data gaps caused by missing or corrupt archive logs by executing a multi-step RMAN procedure utilizing the automated RECOVER FROM SERVICE command. This complex, multi-step RMAN intervention is essential for synchronizing the Data Guard environment and ensuring the continuous […]

The post Refreshing a Physical Standby Using Recover from Service on 12c appeared first on Virtual-DBA Remote DBA Services & Support - Certified Database Experts.

]]> https://virtual-dba.com/blog/refreshing-physical-standby-using-recover-from-service-on-12c/feed/ 2 Golden Gate 19c Unidirectional Replication from non-CDB to PDB https://virtual-dba.com/blog/golden-gate-19c-unidirectional-replication-from-non-cdb-to-pdb/ https://virtual-dba.com/blog/golden-gate-19c-unidirectional-replication-from-non-cdb-to-pdb/#comments Tue, 31 Mar 2020 22:41:59 +0000 https://virtual-dba.com/?p=37255 This article explains how to configure Oracle Golden Gate software to perform a unidirectional replication from a source non-CDB database on Oracle 12c to a target pluggable database on Oracle 19c. One possible use case is if you need to migrate from your non-CDB database to a pluggable database with the least downtime possible. The […]

The post Golden Gate 19c Unidirectional Replication from non-CDB to PDB appeared first on Virtual-DBA Remote DBA Services & Support - Certified Database Experts.

]]> https://virtual-dba.com/blog/golden-gate-19c-unidirectional-replication-from-non-cdb-to-pdb/feed/ 1