Showing posts with label oracle patch applied or not. Show all posts
Showing posts with label oracle patch applied or not. Show all posts

Monday, September 13, 2010

How to check if a patch is applied?

Patching consists of two things:-
1. Patch the oracle software (opatch lsinventory -detail)
2. Patch the database (select * from sys.registry$history; -- to check if sql file with patch was applied or not)