DISCLAIMER: The information and links provided on this site are my personal notes, based on my limited experience installing, using, and deinstalling Oracle databases and application servers on a variety of computers using Windows NT/2000/XP operating systems. The installation and deinstallation procedures found here can cause irreversible loss of data and may damage your operating system. However, you are welcome to use them AT YOUR OWN RISK. I am in no way responsible for data you lose or operating systems you damage or destroy.
To check which (if any) patches have been applied to an Oracle home:
C:\>cd \orahome3\opatch
C:\OraHome3\OPatch>set ORACLE_HOME=c:\orahome3
C:\OraHome3\OPatch>opatch lsinventory
Oracle Interim Patch Installer version 1.0.0.0.53
Copyright (c) 2005 Oracle Corporation. All Rights Reserved..
We recommend you refer to the OPatch documentation under
OPatch/docs for usage reference. We also recommend using
the latest OPatch version. For the latest OPatch version
and other support related issues, please refer to document
293369.1 which is viewable from metalink.oracle.com
Oracle Home = c:\orahome3
Location of Oracle Universal Installer components = C:\orahome3\oui
Location of OraInstaller.jar = "C:\orahome3\oui\jlib"
Oracle Universal Installer shared library = C:\orahome3\oui\lib\win32\oraInstall
er.dll
Location of Oracle Inventory Pointer = N/A
Location of Oracle Inventory = C:\orahome3\inventory
Path to Java = "C:\orahome3\jre\1.4.2\bin\java.exe"
Log file = c:\orahome3/.patch_storage/<patch ID>/*.log
Creating log file "C:\orahome3\.patch_storage\LsInventory__01-24-2006_14-11-33.l
og"
Result:
Installed Patch List:
=====================
1) Patch 4751528 applied on Thu Jan 19 15:23:00 CST 2006
[ Base Bug(s): 3801082 2701372 3721136 4741071 3101559 3206617 4523371 457
2340 4083461 4285404 4656033 4369410 4486132 4192148 3243584 4308824 4049345 420
7529 3396162 4544805 4632494 4592382 3429960 4754842 4567733 2595474 3857781 456
7854 4567971 4579590 3967276 4312390 2816302 4162272 3350337 4036921 4124059 410
7544 4529007 4253914 4121749 4379241 4632780 4627335 4547641 4751923 4751528 449
9035 4188472 4607458 4548339 4573980 4547566 4658188 4294948 3889156 4409977 471
8976 ]
OPatch succeeded.
OPatch returns with error code = 0
C:\OraHome3\OPatch>