This blog aims to support DBAs upgrading databases from 12.1.0.2 to 19.20 using the new AutoUpgrade tool. Oracle Database AutoUpgrade is the supported and recommended method for upgrading Oracle [...]

This blog aims to support DBAs in converting a Non-CDB database to a PDB using remote cloning method. Note: Non-CDB and target CDB are on different hosts (both on-premises) Create a user in [...]

This blog is intended for Oracle DBA’s administering Amazon RDS for Oracle. Issue: Oracle DBAs may need to view alertlog for the database, for troubleshooting issues and looking out for any ORA- [...]

This blog is intended for DBA’s who would like to reorganize tables online using Oracle dbms_redefinition package. Issue: DBAs may need to reorganize tables to improve the SQL query performance [...]

This blog is intended for Oracle Application DBA’s who have issues generating Integration Repository loader file (iLDT). Exposing Oracle E-Business Suite PL/SQL packages a web services requires [...]

Oracle Database 19C Timezone not updated in PDB after applying RDBMS DSTv40 Patch# 3469179 This blog is intended for Oracle DBA’s who are tasked with patching the database.   ISSUE:   Applied [...]