O'Reilly logo

Oracle® Database 10g Insider Solutions by Richard Stroupe, John Kanagaraj, Arun Kumar R.

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required