Problem:
I want to find out what all CPU patches/Patch set updates have been applied to my RDBMS Oracle Home.
Answer:
Use the below SQL command to see all the PSUs/CPUs applied to your database.
select * from dba_registry_history ;
Alternately, we can check successful CPU patch installation logs under $ORACLE_HOME/cfgtoollogs/catbundle directory.
Blog dedicated to Oracle Database, E-Business Suite; covers Apps Architecture, Administration and Fusion Middleware
Oracle Management Cloud
Introduction to Oracle Management Cloud We have been seeing so many products of Oracle off late. A new suite from Oracle named Oracle Manage...
Subscribe to:
Posts (Atom)
Most Viewed Posts
-
Problem: While creating a database link, the user is getting insufficient privileges error: SQL> create database link ASCP_TO_PROD connec...
-
This post provides with 2 scripts. First to check the Usage of each ASM disk groups. Second to check the free space and percent of ASM dis...
-
Aim: How to clear cache in Oracle Apps R12 without logging into Applications. Procedure: Login to Middletier and use below commands. ...