Migrate Oracle 9i to Oracle 10g

5 pts.
Tags:
EXP dump files
IMP
Memory dump files
Microsoft Windows Server 2003
Oracle 10g
Oracle 9i
Oracle upgrades
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

Answer Wiki

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

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 !

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