Capturing patch details for Oracle instances in uCMDB

Idea ID 2807595

Capturing patch details for Oracle instances in uCMDB

Using the DB user configured to run Database jobs (Oracle Topology by SQL), patch information can also be captured using the below query:

select ACTION_TIME,COMMENTS from sys.registry$history where BUNDLE_SERIES='PSU' order by 1 desc ;

 

4 Comments
Contributor.. Contributor..
Contributor..

Example:

SQL> select ACTION_TIME,COMMENTS from sys.registry$history where BUNDLE_SERIES='PSU' order by 1 desc ;

ACTION_TIME                                        COMMENTS

-------------------------------------------------- --------------------------------------------------

02-JUN-13 02.04.50.674319 PM                       Patchset 11.2.0.2.0

02-JUN-13 01.36.43.425110 PM                       Patchset 11.2.0.2.0

06-JUN-10 04.20.59.766812 AM                       PSU 10.2.0.4.4

 

The highlighted output can be captured.

Honored Contributor.. Honored Contributor..
Honored Contributor..

There should be also a possibility to find SPU (Security Patch).

Currently there is a workaround for it. Oracle Discovery writes a folder in the attribute oracle_home. After the "_" the SPU Version is filled and therefore you can for example create an enrichment rule to grab it. Better would be a discovery adapter from MF to create PSU and SPU.

Micro Focus Expert
Micro Focus Expert
Thank you for sharing your idea! It’s open for comments and kudos, and we’re looking forward to input from the community. Once there is enough community traction, it will be further reviewed by the product team. 
Micro Focus Expert
Micro Focus Expert
Status changed to: Waiting for Votes
 
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.