Home » Other » General » Oracle Migration 8i to 11g (oracle 9i)
Oracle Migration 8i to 11g [message #638921] Thu, 25 June 2015 07:49 Go to next message
arun888
Messages: 55
Registered: June 2015
Location: INDIA
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 Go to previous messageGo to next message
John Watson
Messages: 8640
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.
Re: Oracle Migration 8i to 10g [message #638923 is a reply to message #638922] Thu, 25 June 2015 08:26 Go to previous messageGo to next message
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.
Re: Oracle Migration 8i to 10g [message #638925 is a reply to message #638923] Thu, 25 June 2015 08:31 Go to previous messageGo to next message
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.
Re: Oracle Migration 8i to 10g [message #638928 is a reply to message #638925] Thu, 25 June 2015 09:55 Go to previous messageGo to next message
John Watson
Messages: 8640
Registered: January 2010
Location: Global Village
Senior Member
Ah yes, that would make sense.
Re: Oracle Migration 8i to 10g [message #638929 is a reply to message #638928] Thu, 25 June 2015 09:56 Go to previous messageGo to next message
cookiemonster
Messages: 13894
Registered: September 2008
Location: Rainy Manchester
Senior Member
OP has updated original post to now state that the plan is to go to 11g
Re: Oracle Migration 8i to 10g [message #638930 is a reply to message #638922] Thu, 25 June 2015 09:57 Go to previous messageGo to next message
John Watson
Messages: 8640
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.
Re: Oracle Migration 8i to 10g [message #638945 is a reply to message #638930] Fri, 26 June 2015 05:01 Go to previous message
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.
Previous Topic: .jar fil
Next Topic: next step after creating database?
Goto Forum:
  


Current Time: Tue Nov 30 00:24:15 CST 2021