OraFAQ Forum: General » Migration from oracle 8i to 11g

Home » Other » General » Migration from oracle 8i to 11g (on IBM machine)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Migration from oracle 8i to 11g [message #519893]

Wed, 17 August 2011 07:57

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

Report message to a moderator

Re: Migration from oracle 8i to 11g [message #519894 is a reply to message #519893]

Wed, 17 August 2011 08:04

Michel Cadot
Messages: 68418
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Only one: export/import

Regards
Michel

Report message to a moderator

Re: Migration from oracle 8i to 11g [message #519907 is a reply to message #519894]

Wed, 17 August 2011 09:14

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.

Report message to a moderator

Re: Migration from oracle 8i to 11g [message #519917 is a reply to message #519907]

Wed, 17 August 2011 09:42

Mahesh Rajendran
Messages: 10706
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.

Report message to a moderator

Re: Migration from oracle 8i to 11g [message #519925 is a reply to message #519917]

Wed, 17 August 2011 09:59

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)

Report message to a moderator

Re: Migration from oracle 8i to 11g [message #519948 is a reply to message #519893]

Wed, 17 August 2011 11:45

John Watson
Messages: 8804
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.

Report message to a moderator

Re: Migration from oracle 8i to 11g [message #519953 is a reply to message #519925]

Wed, 17 August 2011 13:14

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.

Report message to a moderator

Previous Topic:	difference between "Oracle Database" and "Oracle Client"
Next Topic:	Advantages with oracle 11g

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Mar 28 04:28:36 CDT 2023