 Huge migration from Windows to Solaris. [message #380974] |
Wed, 14 January 2009 09:33  |
leo.elias
Messages: 2
Registered: January 2009
|
Junior Member |
|
|
Hi there,
I am working on a project, huge one, to migrate all the Oracle Databases running on Windows to Solaris. The idea is, for example, to get an Oracle8i running on some version of Windows (2000) and export the database followed by an import on a Solaris 8/9/10 server running the same version of Oracle (8i). At first look that would work just fine with no impact to the application interfaces... I have some experience with this kind of migration and my experience makes me concerned..
So, i decide to post on this forum just to check if any of you guys have any tip or idea that would help.
Is there any difference on Oracle 8i/9i on Windows to Oracle 8i/9i on Solaris ? Any Floating Point issue or something ? Should i consider something before getting into the migration ?
PS: I know that 8i/9i is desupported and i/we also know all the legal problemas regarding to this migration and we (our company/client) are ok with it.
So guys, thats it.
Any tip/idea/help/*** will be Welcome! 
Thanks,
Leo
[Updated on: Wed, 14 January 2009 09:35] Report message to a moderator |
|
|
|
|
|
|
|
| Re: Huge migration from Windows to Solaris. [message #383206 is a reply to message #380974] |
Tue, 27 January 2009 14:15  |
Sanjay Bajracharya
Messages: 279
Registered: October 2001
Location: Florida
|
Senior Member |
|
|
To do : move from 8i on Windows to 9i on Sun (even better 10g).
Here is what I would do.
1. Install a higher version of Oracle in the Windows system, let's say 9i
2. Use the Oracle 9i Export and export the schema/db
3. Import into 9i on Sun
(Note: In this manner, you only need to install 9i in Sun. Even better go to 10g on Sun which is supported)
You have not mentioned how big your db is. Keep in mind, assign double the time for import as to what it takes for an export.
Example: it took 20 minutes to export, then think of 40 minutes to import.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
