How to Upgrade OPatch to Latest Version

This is a quick article to upgrade OPatch to latest release as its always recommended to use the latest version of OPatch before patching your database or grid. This would also be base reference for future posts on Applying latest Release Updates (RUs) and Release Update Revisions (RURs). Download the latest copy of Opatch from…

Upgrade 12cR2 (Non-CDB) to 19c (PDB) using AutoUpgrade

In this article, we’ll perform an upgrade from 12cR2 Non container database to a 19c pluggable database using autoupgrade. If you are not aware of this autoupgrade utility, I would recommend to read my blog post on this topic Oracle 19c AutoUpgrade Utility which explains the workflow, stages and modes in autoupgrade utility. For 11gR2…

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…