OraFAQ Forum: General » Oracle Migration 8i to 11g

Home » Other » General » Oracle Migration 8i to 11g (oracle 9i)

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

Oracle Migration 8i to 11g [message #638921]

Thu, 25 June 2015 07:49

arun888
Messages: 100
Registered: June 2015
Location: INDIA

Senior Member

dear sir/madam,

one of the application currently in 8i oracle. They have planned to migrate to oracle 11g. can you tell me what are the things need to be changed in the code wise.

One things I was aware was I need to re-compile the code. apart from that can you tell what are the things I need to change if it is migrated to oracle 10g.

[Updated on: Thu, 25 June 2015 08:30]

Report message to a moderator

Re: Oracle Migration 8i to 10g [message #638922 is a reply to message #638921]

Thu, 25 June 2015 07:58

John Watson
Messages: 8962
Registered: January 2010
Location: Global Village

Senior Member

I wouldn't think that anything particularly needs to be changed, if the code is well written. If it isn't, you may have some anomalies. For example, a lot of lazy programmers used to assume that GROUP BY also does ORDER BY. Well, it did in 8.x but it may not in 10.x.

On a related matter, why release 10.x? Why not 11.2.0.4 or 12.1.0.2? You will have to pay massive support fees for 10.x, and it will have only sustaining support.

Report message to a moderator

Re: Oracle Migration 8i to 10g [message #638923 is a reply to message #638922]

Thu, 25 June 2015 08:26

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Some will say that going from one unsupported version (8.x) to another unsupported & obsoleted version (10.x) is an exercise in futility.
In any case you are commended for joining the 21st Century, if only 15 years late.

Report message to a moderator

Re: Oracle Migration 8i to 10g [message #638925 is a reply to message #638923]

Thu, 25 June 2015 08:31

Roachcoach
Messages: 1576
Registered: May 2010
Location: UK

Senior Member

Iirc, 10.2.0.5 is the "earliest" version which can then be punted to 12c.

Perhaps this is intermediary.

Report message to a moderator

Re: Oracle Migration 8i to 10g [message #638928 is a reply to message #638925]

Thu, 25 June 2015 09:55

John Watson
Messages: 8962
Registered: January 2010
Location: Global Village

Senior Member

Ah yes, that would make sense.

Report message to a moderator

Re: Oracle Migration 8i to 10g [message #638929 is a reply to message #638928]

Thu, 25 June 2015 09:56

cookiemonster
Messages: 13961
Registered: September 2008
Location: Rainy Manchester

Senior Member

OP has updated original post to now state that the plan is to go to 11g

Report message to a moderator

Re: Oracle Migration 8i to 10g [message #638930 is a reply to message #638922]

Thu, 25 June 2015 09:57

John Watson
Messages: 8962
Registered: January 2010
Location: Global Village

Senior Member

I've remembered something else: when upgrading from 8.x, I did have problems with database links. IIRC, there were bugs in the way links, db_domain, and the db global_name worked together and several times after going from 8.1.x to 9.x I had to hack into sys.link$ to sort out problems.

Report message to a moderator

Re: Oracle Migration 8i to 10g [message #638945 is a reply to message #638930]

Fri, 26 June 2015 05:01

Dave Linehan
Messages: 2
Registered: September 2014
Location: Dublin, Ireland

Junior Member

One issue I've seen recently was a 'Create New User' feature in the front end failing after a migration to 11g, as there as a quota grant on the temp tablespace included in the SQL used - best advice is to test thoroughly before the actual cutover.

Report message to a moderator

Previous Topic:	.jar fil
Next Topic:	next step after creating database?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Dec 27 05:50:13 CST 2024