We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

Migration Oracle 9i to 10g

Biju1149
Biju1149 asked
on
Medium Priority
3,281 Views
Last Modified: 2012-05-07
Currently I am using Oracle 9.2.0.1.0 and planning to upgrade it to Oracle 10g.

Please help me to get migration process steps.
Comment
Watch Question

CERTIFIED EXPERT

Commented:
Best way is to backup your databases. Uninstall oracle 9 and install 10g.
Once you have done this you create your instances again and import the Oracle 9 databases. As they import they will be automatically upgraded to Oracle 10g.
Top Expert 2009
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
Top Expert 2009

Commented:
>>Uninstall oracle 9

No this not a good idea and is not the way it is done. You NEVER uninstall the old binaries during the upgrade! Dangerous advice.

CERTIFIED EXPERT
Top Expert 2008
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION

Author

Commented:
Database size is 3 GB
CERTIFIED EXPERT
Top Expert 2008

Commented:
If it is 3GB then possibly Export/Import file will hit the 2 GB frontier.
So use many smaller files if you chose to use Export and
pay attention to NLS_LANG enviroment parameter in order to not lose
the nonEnglish letters
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.