Home > IT Answers > Oracle > Migration Plan for 9i Linux to 10g Solaris
MLC
5 pts.
 Migration Plan for 9i Linux to 10g Solaris
Oracle 10g, Oracle 9i, Solaris
Does anyone have a migration plan for an Oracle 9i to 10g Migration. Migration will be from Linux running 9i to Solaris running 10g.

Software/Hardware used:
ASKED: March 6, 2008  10:06 PM
UPDATED: March 7, 2008  2:24 AM
RELATED QUESTIONS
Answer Wiki:
Last Wiki Answer Submitted:  Be the first to answer this question.
All Answer Wiki Contributors:  Be the first to answer this question.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

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.

Denny Cherry
 64,520 pts.