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?

    Requires Free Membership to View

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

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

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: