Command to show me Oracle Critical Patch Updates on server
- Article Type: General
- Product: Aleph
- Product Version: 20
Description:
Is there a command which will show me what Oracle Critical Patch Updates are present on a server?
Resolution:
login as the oracle unix user, then:
> sqlplus / as sysdba
run the following in a sqlplus session:
set line 200 pause off
col action_time for a28
col action for a10
col namespace for a9
col version for a10
col id for 99999999
col comments for a20
select * from registry$history order by 1;
Additional Information
cpu, patch level
- Article last edited: 10/8/2013