Applying Patches to Database Installations

After you have installed a database, you may find that it needs periodic patching as per scheduled patch releases by Oracle Corporation. If you are not sure about the latest patch release applied to your database, use the OPatch utility (located in $ORACLE_HOME/OPatch) to get a list of installed software components as well as the installed patches. Use the command opatch lsinventory to get a list from your database installation. A sample output for an Oracle Data base 10g Release 2 installation is given here.

 $ opatch lsinventory Oracle interim Patch Installer version 10.2.0.0.0 Copyright (c) 2004, Oracle Corporation. All rights reserved.. Oracle Home : /opt/app/oracle10g/oracle/product/10.2.0/db_1 ...

Get Oracle® Database 10g Insider Solutions now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.