Q

Patch application incomplete

I have applied 9.2.0.6 to 9.2.0.1 but it did not complete fully. The catpatch.sql and utlrp.sql scripts have not been updated.

I have applied 9.2.0.6 to 9.2.0.1 but it did not complete fully. The catpatch.sql and utlrp.sql scripts have not been updated. Unfortunately I don't have a backup, but if I go into OUI to try reinstalling the patch, it says it's already installed. Can you offer any advice?
This is where you want to have a good backup of your database, Oracle software and inventory before you apply a patch of any kind. If application of the patch set did not complete successfully, without a backup the best course of action is to reinstall the Oracle software to the level it was at before the patch was attempted. If this was a Critical Patch Update (CPU), there would have been a way to rollback the patch but not with a patch set such as 9.2.0.6. If the database was not affected, i.e., you did not start it up and try running catpatch.sql, then it should be OK to start up after the binaries are reinstalled. You might want to review the log files to determine what caused the failure so that you can avoid this problem next time you attempt to apply the patch set.
This was first published in December 2006

Dig deeper on Oracle database installation, upgrades and patches

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close