I'm managing Oracle9i ( on an HP-UX 64-bit server. I have downloaded the latest patch (4751921). Could you please explain upgrading Oracle9i step by step using the OPatch utility?

    Requires Free Membership to View

If you downloaded the patch from Metalink, you will see that there is a README file accompanying the patch itself. The complete instructions for applying this patch are included in this file. The basic steps for applying this patch are as follows:
  • Download a copy of OPatch from Metalink. This patch requires OPatch version
  • Shut down all databases and listeners using the ORACLE_HOME to be patched.
  • Apply the patch using OPatch. Check the log files for errors.
  • Start up each database using this ORACLE_HOME and run the catcpu.sql script. Again, check for errors or problems.
  • Recompile any invalid objects in the databases.
Remember to read the README file before you start applying this patch. The steps contained in this document are very detailed and specific. Note that there is also a procedure for uninstalling the patch should it fail.

This was first published in July 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: