Home » Other » General » Migration from oracle 8i to 11g (on IBM machine)
Migration from oracle 8i to 11g [message #519893] Wed, 17 August 2011 07:57 Go to next message
9390512774
Messages: 103
Registered: January 2011
Location: hyd
Senior Member
Hi All,
I have a plan to migrate my database oracle version 8i which is in Hp-UX to oracle 11g into linux server.
Can you please help me on finding what are the possible migration issues from oracle 8i to 11g. so that i can take precautions in prier to migration.

Thanks in advance
Re: Migration from oracle 8i to 11g [message #519894 is a reply to message #519893] Wed, 17 August 2011 08:04 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Only one: export/import

Regards
Michel
Re: Migration from oracle 8i to 11g [message #519907 is a reply to message #519894] Wed, 17 August 2011 09:14 Go to previous messageGo to next message
9390512774
Messages: 103
Registered: January 2011
Location: hyd
Senior Member
Can i update 8i to 11g directly or i need any intermediate step(i read some where. i.e. direct upgradation from 8i to 11g is not possible first we have to upgrade to 9i and than to 11g(8i-->9i-->11g))to upgrade to 11g.
Re: Migration from oracle 8i to 11g [message #519917 is a reply to message #519907] Wed, 17 August 2011 09:42 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Michel already answered it.

>>Can i update 8i to 11g directly or i need any intermediate step
You need to goto atleast to 9.2.0.8 for direct upgrade. But you are also migrating
between different OS, so getting to 9.2.0.8 is useless.
You can go to 10g and try RMAN Cross platform (Check with 10g upgrade guide for restrictions) to another 10g database and then upgrade to 11g.

So save yourself all the pain and just export and import.
There *might* be some incompatible datatypes depending on your application. If the volume is large, it will take time.
Just deal with it.
Re: Migration from oracle 8i to 11g [message #519925 is a reply to message #519917] Wed, 17 August 2011 09:59 Go to previous messageGo to next message
chris32680
Messages: 92
Registered: January 2006
Location: Charlotte
Member
and do what we did when we went from 9 to 11 (same OS)...

PRACTICE.

i performed the export/import process at least 3 times on the target machine before the actual go live to work out the kinks.

Also be sure to test your applications...especially if you are currently using the RBO in 8 (which we were in 9).

Quite a few apps had to be tweaked to maintain performance in our upgrade. (this place was a big help)
Re: Migration from oracle 8i to 11g [message #519948 is a reply to message #519893] Wed, 17 August 2011 11:45 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
Problems I have had with upgrading from 8i (any method) were to do with Advanced Queueing and Workflow. I think both of these were re-implemented from PL/SQL into Java at about that time, which may have had something to do with it.
Re: Migration from oracle 8i to 11g [message #519953 is a reply to message #519925] Wed, 17 August 2011 13:14 Go to previous message
joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA
Senior Member
chris32680 wrote on Wed, 17 August 2011 10:59

Also be sure to test your applications...especially if you are currently using the RBO in 8 (which we were in 9).


Good advice. Also in 8i if you were relying on GROUP BY to give you data in the right order and not using an ORDER BY clause, you are going to realize that in 10g forward, your results will no longer be in sorted order based on the GROUP BY clause.
Previous Topic: difference between "Oracle Database" and "Oracle Client"
Next Topic: Advantages with oracle 11g
Goto Forum:
  


Current Time: Thu Mar 28 14:32:09 CDT 2024