Home > IT Answers > Oracle > Migrate Oracle 9i to Oracle 10g
Smattar
5 pts.
 Migrate Oracle 9i to Oracle 10g
EXP dump files, IMP, Memory dump files, Oracle 10g, Oracle 9i, Oracle 9i migration, Oracle upgrades, Windows Server 2003
kindly provide me with details steps, as i will upgrade over 50 servers. what i am doing in three sites: 1) build temp server with same version. 2) uninstall Application. 3) uninstall 9i. 4) dis-join domain. 5) install Oracle 10g. 6) join domain mandatory for my application. 7) install my application. 8) imp sys/XXX@XXX file=xx.dmp fromuser=xx touser=xx i belive that there are a way that let me work much smart than this. please advice, Sherif

Software/Hardware used:
windows 2k3 HP DL380G6
ASKED: October 26, 2010  5:04 AM
UPDATED: November 8, 2010  6:02 AM
RELATED QUESTIONS
Answer Wiki:
Mirror Replication Agent for Oracle migration process to support Oracle 9i to Oracle 10g migration. NOTE: U need to verify that the Mirror Replication Agent is quiesced prior to migrating from Oracle 9i to Oracle 10g. That is, the replication environment must have completed processing of all transactions prior to migrating because the Mirror Replication Agent moves the truncation point to the end of the log during Oracle 9i to Oracle 10g migration. Steps to migrate from Oracle 9i to Oracle 10g 1. Follow the steps that Oracle provides in their documentation for upgrading from Oracle 9i to Oracle 10g. 2. After migrating Oracle, you must re-start the Mirror Replication Agent and issue the ra_migrate command. OR Now u have to do : Create a new 10g database with the DBCA (database configuration assistant). Create the user and any custom tablespaces that u have in your 9i database. You may need to export then import only one schema, if that is what ur application uses. CAUTION: It is good practice to take all necessary backups and build temp server with same version.... before doing anything Rest depends on u and ur employer !
Last Wiki Answer Submitted:  November 8, 2010  6:02 am  by  HMSSL2K   3,175 pts.
All Answer Wiki Contributors:  HMSSL2K   3,175 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


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