How to check which Oracle Critical Patch Updates(CPU) has been installed on eHealth server?

Document ID : KB000039397
Last Modified Date : 14/02/2018
Show Technical Document Details

Introduction:

CA eHealth is designed to be able to use an embedded Oracle database.  Per CA's agreement with Oracle, CA is under obligation to provide supported CA customers with Oracle patch updates as an integrated patch with CA's product. CA is releasing the Oracle CPUs quarterly and these Oracle CPU kits are full PSU kits which contains the latest Oracle 11.2.0.4 database patches for eHealth installations with the Oracle 11g database. These Oracle CPUs can be downloaded with the appropriate login credentials at https://support.ca.com.

Question:

How to check which Oracle Critical Patch (CPU) has been installed on eHealth server?

Environment:

eHealth 6.3.2

Answer:

Here are the 3 ways to verify which Oracle CPU has been installed on your eHealth server:

 

Method #1:

  ->Login DB

         sqlplus %NH_USER%/%NH_USER%@%NH_DB_CONNECT_STRING%  (for Windows)

         sqlplus $NH_USER/$NH_USER@$NH_DB_CONNECT_STRING  (for Solaris/Linux)

 

  -> Run following query to verify which WinBundle is installed. Then, compare this WinBundle number with the one in readme file of the Oracle CPU you are caring about. 

           SQL> select comments from sys.registry$history;

Example:

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

COMMENTS

Patch 16

view recompilation

Upgraded from

view invalidation

Upgraded from 10.2.0.5.0

WinBundle 11.2.0.4.10

WinBundle 11.2.0.4.12

WinBundle 11.2.0.4.20

8 rows selected.

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

 

Method #2:

Run command    $NH_ORACLE_HOME\OPatch\opatch lsinventory

The output should list patch# from $UPDATE_DIR.

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

Patch description:  "WINDOWS DB BUNDLE PATCH 11.2.0.4.20:(21821802)"

Created on 7 Oct 2015, 06:35:47 hrs

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

 

Method #3:

Check the Oracle CPU install log located in $NH_HOME\log\install\orapatch.txt.

 

Additional Information:

All Oracle CPU updates are cumulative. That means the latest Oracle CPU includes all Oracle CPUs released before.