Oracle migration from Unix to Windows

Oracle 9i to Oracle 9i from Sun Solaris to Windows 2003 Server.

I have a Sun Solaris Server with Oracle 9i database currently running and working,  was asked to move/migrate this Unix database of Oracle to a Windows 2003 Server box in order to run IBM Clearquest to keep everything on one box.  I know how to move databases from Unix to Unix not sure about the ramifications or instructions to move from Unix to a Windows Platform.  Do I use the export/import utility as usual?  Any issues? I also have 3 SID's on this Sun Box that needs to go over to the Windows Server.   Please let me know thanks
kaypooAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Praveen Kumar ChandrashekatrConnect With a Mentor Database Analysist Senior Commented:
export/import will do to migrate ur database from unix to windows machine, but make sure ur sid's structure is same as in sun box..
0
 
gheistCommented:
It is not a good idea to keep Oracle alongside application.
You have to use Windows 2003 Advanced Server and install WSRM to prevent system meltdown.
Moving includes full database dump and restore - disk formats are different.
0
 
kaypooAuthor Commented:
I know, I dont like moving Oracle from Unix to Windows either, but it's a requirement. What is WSRM?  We have to do everything Manually here since we do not have RMAN and such.
0
The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

 
gheistCommented:
It is resource policy tool which allows for example to give Oracle 10% of CPU and all the RAM it needs while webapp overloads and vice-versa.
0
 
kaypooAuthor Commented:
Is it a free download? if so link?  So export and import is ok there are no special instructions? The item libraries are currently on Windows so I do not have to worry about any file support just Oracle.
0
 
kaypooAuthor Commented:
Thanks for the Site!  Looking for Oracle answers now.
0
 
kaypooAuthor Commented:
what do you mean SID structure?  I have multiple SIDs on the Unix box, will I have to change the SID connection each time I need to connect?  how about the slashes from unix to windows? will the meta data be corrupted?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.