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…

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

Wait Event – cursor: pin S wait on X

A session waits for this event when it is requesting a shared mutex pin and another session is holding an exclusive mutex pin on the same cursor object. Wait Time: Microseconds   Parameter Description P1 Hash value of cursor P2 Mutex value (top 2 bytes contains SID holding mutex in exclusive mode, and bottom two bytes…