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…
This error appears when the process of starting up a dedicated server process failed and it could be either because the executable could not be found or the environment isn’t set up correctly. Turn on tracing at the ADMIN level and re-execute the operation. Tracing can be set by adding following clause in listener.ora file…
This post is to provide a script to auto-start Oracle Instances on Linux upon server restart. First step would be to configure /etc/oratab file as per your requirement, oratab file is in the following format: <DB NAME>:<ORACLE HOME>:<Y|N> The last letter tells oracle if the database need to restarted or not, so we would change…
This post is to provide a set of queries to monitor any user session on an Oracle Instance more efficiently. Below query (Lets name it Query1 for the sake of discussion) gives you an overall status of what all sessions are active, what wait event they are waiting on and what are they executing. set…
Library cache pins are used to manage library cache concurrency. Pinning an object causes the heaps to be loaded into memory (if not already loaded). PINS can be acquired in NULL, SHARE or EXCLUSIVE modes and can be considered like a special form of lock. A wait for a “library cache pin” implies some other…
Oracle Database Internal Mechanism 