Migration Plan for 9i Linux to 10g Solaris
Solaris, Oracle 10g, Oracle 9i
Does anyone have a migration plan for an Oracle 9i to 10g Migration. Migration will be from Linux running 9i to Solaris running 10g. Question
Solaris, Oracle 10g, Oracle 9i
Does anyone have a migration plan for an Oracle 9i to 10g Migration. Migration will be from Linux running 9i to Solaris running 10g. 
Subscribe to Alerts! Get questions and answers delivered to your Inbox.
Answer Wiki (Improve, edit or add to this answer)
Start this Answer and Earn your Knowledge Points!
By clicking "Create Answer", you can write the answer to this question that can be improved upon by your peers using the Answer Wiki.
By clicking "Create Answer", you can write the answer to this question that can be improved upon by your peers using the Answer Wiki.
Browse more Questions and Answers on DataCenter and Oracle.
Looking for relevant DataCenter Whitepapers? Visit the SearchDataCenter.com Research Library.
Discuss This Answer
You must be logged-in to discuss a question. Log-in/Register
Mrdenny | Mar 7 2008 2:24AM GMT
I don’t have a plan handy for you, but I can tell you that testing will be VERY important. At a prior company we decided to upgrade from 9i to 10g without testing (not my idea, or my project) and we had very bad results. The 10g optimizer didn’t like several of the queries which we were using and the Oracle database (running on a very nice new IBM server) was running slower than an Access database. Oracle ended up having to spend three weeks writing us a custom build of the database which basically had the 9i optimizer put back in.
