Upgrade 11gR2 (Non-CDB) to 19c (PDB) using AutoUpgrade

In this article we will upgrade 11gR2 DB to 19c DB using Autoupgrade utility which will not only upgrade the DB but also convert the non-CDB to PDB. This article assume that you have basic understanding of Autoupgrade utility and its different modes and stage, if not then go through a quick read of Oracle…

Oracle 19c AutoUpgrade Utility

The AutoUpgrade utility introduced with Oracle 19c identifies issues before upgrades, performs pre- and postupgrade actions, deploys upgrades, performs postupgrade actions, and starts the upgraded Oracle Database. In this article we’ll see how this new autoupgrade utility almost completely automates the database upgrade process including pre & post upgrade tasks. The autoupgrade.jar file is available…

Oracle 19c RPM Based Software Installation

From 19c Oracle can be installed on Oracle Linux OS using an RPM. In this article we’ll perform an RPM installation of Oracle Database 19c 64-bit on Oracle Linux 7 (OL7) 64-bit.  Step 1: Download the RPM from OTN Download the oracle-database-ee-19c-1.0-1.x86_64.rpm file from Oracle Technology Network required for performing an RPM-based installation to a directory of your choice.…

Locations of tnsnames.ora

During a recent troubleshooting, we came across a requirement where we wanted to know what all locations does Oracle searches tnsnames.ora ? So writing this quick post for the analysis that we did and the results we reached during this exercise. You might already aware of tnsnames.ora in path defined by TNS_ADMIN variable and default…

ORA-00368 Checksum error in redo log block

Cause: The redo block indicated by the accompanying error, is not vaild. It has a checksum that does not match the block contents. Action: Do recovery with a good version of the log or do time based recovery up to the indicated time. If this happens when archiving, archiving of the problem log can be…