Posts by Ramoji Rao

Upgrading Oracle database from 12.1.0.2 to 19.20 using AutoUpgrade tool

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 database.…

Read More

Converting a Non-CDB to PDB using remote cloning method

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…

Read More

Viewing alert log for Amazon RDS for Oracle

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…

Read More

Online reorganization of a table using Oracle DBMS_REDEFINITION package

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…

Read More

R12.2: Script $FND_TOP/bin/irep_parser.pl Fails With Error Can’t Locate Class/MethodMaker.pm When Attempting to Generate *.ildt File

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 the creation of…

Read More

Oracle Database 19C Time zone not updated in PDB after applying RDBMS DSTv40 Patch# 3469179

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:…

Read More