Articles on Emerging Technologies, Cloud Computing and Cyber Security

Thursday, July 19, 2018

How to verify the current level for the product family patches/patchsets installed on the system?


How to verify the current level for the product family patches/patchsets installed on the system?

 Current level for the product family patches/patchsets installed on the system can be
 verified by querying table : AD_TRACKABLE_ENTITIES

  It has Columns:
  ABBREVIATION VARCHAR2 - Product Abbreviation
  NAME VARCHAR2 - Holds the name of the trackable entity
  TYPE VARCHAR2 - Holds the type of the trackable entity
  CODELEVEL VARCHAR2 - Holds the codelevel of the trackable entity ---> baseline.delta      version
  BASELINE VARCHAR2 - Holds the baseline of the trackable entity


  An example query:
  SQL>
  SELECT ABBREVIATION,


             NAME,
             TYPE,
             CODELEVEL,
             BASELINE
       FROM AD_TRACKABLE_ENTITIES
       WHERE ABBREVIATION IN ('ad',
                          'txk',
                          'fnd',
                          'fwk',
                          'atg_pf',
                          'icx')
      ORDER BY ABBREVIATION;



   

       Doc ID 2234900.1

0 Comments: