Home » Other » General » oracle database migration issues (merged 2) (oracle 8i HP-UX to oracle 11g IBM machines)
oracle database migration issues (merged 2) [message #523613] Mon, 19 September 2011 09:26 Go to next message
9390512774
Messages: 103
Registered: January 2011
Location: hyd
Senior Member
Hi All,

We are migrating oracle 8i(HP-UX machine) to 11g(IBM machine).
1.)what are the ALL Possible migration issues?How to solve them?
2.)can we migrate directly from 8i to 11g?

once after the migration is completed we have to test the working functionality of the 11g with working functionality of 8i, by getting data from 8i machine to 11g machine how to do it?

how to get the data from 8i to 11g machine?

Can you please help me on the migration work?
can you suggest me any sites or books for reference.

ALL your help and support on this issue solving is apprised greatly?

Thanks in Advance
Re: oracle database migration issues (merged 2) [message #523630 is a reply to message #523613] Mon, 19 September 2011 09:59 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10694
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>> 1.)what are the ALL Possible migration issues?How to solve them?
I cannot answer that question. Nobody can.
Some documented issues are available in metalink/upgrade guide.

>> 2.)can we migrate directly from 8i to 11g?
Actually you are migrating and upgrading.

http://download.oracle.com/docs/cd/E11882_01/server.112/e17222/preup.htm#i1007814

Go through above mentioned upgrade guide. All information you need is there.

You need to atleast in 9i.
The exact methods depend on volume of database, affordable downtime etc.
While a simple export/import ***might** work through an intermediate 9i database, it is not always the best option.

>>once after the migration is completed we have to test the working functionality of the 11g with working functionality of 8i, by getting data from 8i machine to 11g machine how to do it?
I would set up a parallel environment in the IBM Box.
Test your upgrade methods. Document the procedures. Test your applications/functionality. Then do it again and cut-over.
Re: oracle database migration issues (merged 2) [message #523642 is a reply to message #523613] Mon, 19 September 2011 10:40 Go to previous messageGo to next message
9390512774
Messages: 103
Registered: January 2011
Location: hyd
Senior Member
How to get the data from "8i PROD machine" to "11g STG machine" once after getting the data we have to Cross verify the functionality of the "11g STG" with "8i PROD" to prove both are in SYNC.

For this what method/way i have to follow?

>> I would set up a parallel environment in the IBM Box.
What is this set up of parallel ENV. how to do it?
What is its use?


Thanks,
Re: oracle database migration issues (merged 2) [message #523644 is a reply to message #523642] Mon, 19 September 2011 10:47 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10694
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>> For this what method/way i have to follow?
Already mentioned in the previous post.
Go through the upgrade guide.
Subtopics
Determine the Upgrade Path
Choose an Upgrade Method
Talk about it.

>>What is this set up of parallel ENV.

Means, set up the database on IBM and have it running parallel to current HP box.
So you can compare the 8i functionality with 11g.
Re: oracle database migration issues (merged 2) [message #523646 is a reply to message #523644] Mon, 19 September 2011 11:01 Go to previous messageGo to next message
9390512774
Messages: 103
Registered: January 2011
Location: hyd
Senior Member
Sorry Mahesh Rajendran,
I am unable to understand what you are saying?
Pelase give me any realtime example?
Example:
Supose I have a emp table in both 8i and 11g. Now i have to test data in 8i emp table with emp table in 11g.
Can you please tell me(code) the process?

Thanks,
Re: oracle database migration issues (merged 2) [message #523651 is a reply to message #523646] Mon, 19 September 2011 11:37 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10694
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
You can compare the data in two tables using dblinks. Not sure whether dblinks between 8i and 11g are supported.
But in real world, this is not an issue.
The data will* be the same in most cases (* Unsupported datatypes/conversion?). Oracle and OS versions are now different.
Will your code and applications behave the same?
So You should test it with your applications.
Re: oracle database migration issues (merged 2) [message #523670 is a reply to message #523613] Mon, 19 September 2011 13:40 Go to previous message
joy_division
Messages: 4951
Registered: February 2005
Location: East Coast USA
Senior Member
One thing I know for sure will be different is that if you were relying on GROUP BY to sort your data, it will no longer be the case. You will need to put an ORDER BY clause anywhere you expect data to be sorted.
Now, Oracle always stated this, so it is nothing new, but a side effect of GROUP BY up through 9i seemed to also sort the data. Not anymore.
Previous Topic: max size of SGA
Next Topic: Re: Username and Password problems for 10g SQL Plus? (split from hijacked thread by bb)
Goto Forum:
  


Current Time: Wed Sep 22 08:41:23 CDT 2021