I want to upgrade Oracle 9.2.0.4 to 9.2.0.7 on HP-Unix 9000 64-bit. I have five production databases in Oracle 9.2.0.4. Please let me know the procedure/process. Thanks.

    Requires Free Membership to View

The basic steps for applying the Oracle 9.2.0.7 patchset are:
  • Download the patch from Oracle's Metalink Web site.
  • UnTAR it on the database server.
  • Shut down all databases using the Oracle9i home.
  • Apply the patchset to the Oracle binaries.
  • Start up all databases using the Oracle9i home and run required SQL scripts within each database.
The step-by-step instructions are quite detailed and beyond the scope of this forum, but when you download the Oracle 9.2.0.7 patchset from Metalink, a README file with instructions for installing the patch is included. Ensure you have an appropriate back-out plan in place just in case the patch fails. This includes having an appropriate backup of all your databases, as well as the Oracle software and inventory.

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