Oracle Standalone DB

Clone Remote PDB using db link from one CDB to another CDB oracledna Oracle Standalone Database August 21, 2026 This post demonstrates how to clone...

Patching Oracle Database 19c oracledna Oracle Standalone Database August 13, 2026 This post demonstrates the patching of the Oracle Database from 19.27 to 19.30. Environment:============DB...

Installing Oracle Client 19c on Oracle Linux 9 oracledna Oracle Standalone Database August 8, 2026 This post demonstrates installing Oracle Client 19c on Oracle Linux...

Upgrade Time Zone to Specific Version in Oracle Standalone Database (Non-CDB) oracledna Oracle Standalone Database August 6, 2026 This post is to demonstrate upgrade Time...

Applying Higher RU to a Single Oracle Database in a Shared Oracle Home oracledna Oracle Standalone Database August 3, 2026 This post explains how to...

ORA-30012: undo tablespace ‘UNDOTBS1’ does not exist or of wrong type oracledna Oracle Standalone Database August 1, 2026 This post is to demonstrate how to...

Switch UNDO tablespace in Standalone Oracle Multitenant Pluggable Database   The aim of this post is to provide an example of switching the undo tablespace...

Upgrade Time Zone in Oracle Standalone Multitenant Database 19.18 and later oracledna Oracle Standalone Database July 30, 2026 This post is to demonstrate upgrade Time...

Upgrade Oracle Database 19c non cdb to 26ai using Autoupgrade oracledna Oracle Standalone Database March 30, 2026 This post demonstrated the upgrading Oracle Database 19c...

Perform out-of-place (OOP) patching using Autoupgrade in Oracle Database oracledna Oracle Standalone Database March 18, 2026 This post demonstrates to apply a RU patch on...

Reverting an Oracle Database upgrade using Flashback Database and AutoUpgrade oracledna Oracle Standalone Database March 17, 2026 This post demonstrates the reverting an Oracle Database...

Upgrade Oracle Database from 11g to 19c by Manual method (Non CDB & Non-RAC) oracledna Oracle Standalone Database March 16, 2026 This post demonstrates the...

Downgrade Oracle Database from 19c to 11g by using dbdowngrade (Non CDB) oracledna Oracle Standalone Database July 5, 2025 This post is to demonstrate downgrade...

Upgrade Oracle Database from 11g to 19c by DBUA (Non CDB) oracledna Oracle Standalone Database July 2, 2025 This post is to demonstrate upgrade Oracle...

Downgrade Oracle Database from 19c (19.3) to 11g (11.2.0.4) manually oracledna Oracle Standalone Database June 29, 2025 This post is to demonstrate downgrade Oracle Database...

Oracle Database Upgrade from 11g (11.2.0.4) to 19c (19.3) by Autoupgrade oracledna Oracle Standalone Database June 28, 2025 This post is demonstrate the upgrading Standalone...

Downgrade Standalone Oracle database (Non-CDB) from 19c (19.3) to 12c (12.2.0.1) manually using dbdowngrade utility oracledna Oracle Standalone Database June 24, 2025 This post is...

Downgrade Standalone DB (Non-CDB) from 19c (19.27) to 12c (12.2.0.1) Using Flashback Database oracledna Oracle Standalone Database June 14, 2025 This post is to demonstrate...

Upgrading Standalone Oracle Database (Non-CDB) from 12c (12.2.0.1) to 19c (19.27) by Autoupgrade oracledna Oracle Standalone Database June 14, 2025 1. Take the full RMAN...

Recover lost datafile of primary database by using a copy of datafile of physical standby database oracledna Oracle Core Database April 21, 2025 This post...