Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 898
  • Last Modified:

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
0
kaypoo
Asked:
kaypoo
  • 4
  • 3
1 Solution
 
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
 
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
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
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
 
Praveen Kumar ChandrashekatrDatabase 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
 
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

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now