Would like to upgrade to 10.2.0.4 from 9.2.0.7

5 pts.
Tags:
Oracle 10g
Oracle 9i
Oracle Database
Oracle upgrades
Ihave 3 test databases on Tru64 and I would like to install 10.2.0.4 and upgrade only one database. How do I do that? Once the testing is sucessful I will then upgrade other 2 test databases and then production database. Your step by step instructions will be appreciated Thanks

Answer Wiki

Thanks. We'll let you know when a new response is added.

I would recommend to use the oficial <a href=”http://download.oracle.com/docs/cd/B19306_01/server.102/b14238/toc.htm”>Oracle┬« Database Upgrade Guide 10g Release 2 (10.2)</a>

Be sure you have enough space and install the 10.2 Oracle software on the machine in a new/separate Oracle Home. I typically use /u01/dba/oracle/product/10.2.0. Once the software is installed follow the suggested migration guide to upgrade individual database instances. I have numerous servers which have multiple versions of Oracle running on them with no conflict. Whether you use 1 or multiple listeners will need to be decided, but if you aren’t using Oracle Names, then using the highest version for the listener is typically the best idea.

Be careful with your environment variables and follow the guide.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

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

Forgot Password

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

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

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

Thanks! We'll email you when relevant content is added and updated.

Following