How can we see what Oracle patches have been applied to our server?
- Product: Aleph
- Product Version: 20, 21, 22, 23
- Relevant for Installation Type: Dedicated-Direct, Direct, Local, Total Care
Description
How can we see what Oracle patches have been applied to our server?
Resolution
First, you need to either login as oracle, or log in as root and do:
> sudo su - oracle;
Then:
> sqlplus '/as sysdba'
Then:
SQL> select * from registry$history order by 1;
OR
logged in as oracle, do:
> cd /exlibris/app/oracle/product/"oracle_version"/OPatch
And run opatch lsinventory.
Also, you should be able to see at /exlibris/ftp_from_exlibris the PSU's previously downloaded from the ftp server,
such as, "ora12.1.0.2_linux64.tar" .
- Article last edited: 31-Aug-2018