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


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 database patches for eHealth installations with the Oracle 11g database. These Oracle CPUs can be downloaded with the appropriate login credentials at


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


eHealth 6.3.2


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;




Patch 16

view recompilation

Upgraded from

view invalidation

Upgraded from




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"

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.