Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

migration from windows to linux

nohupAug 13 2012 — edited Aug 24 2012
Hello people
using windows server 2003, X86 based system
oracle version we are using is 10.2.0.1.0.. nls_character set is WE8ISO8859P1
i want to migrate this to linux
i have a linux 5.7 installed on a 32 bit machine with oracle 11.2.0.1.0 here, there is one database currently which is AL32UTF8
endian formats are same for linux and windows, both little
right now i have just performed an export of the data(on the test server) and placed in the linux database
but only 248 out of 312 tables got imported, this is okay right now but i it wont be okay for the production server
so i am planning to use rman to migrate
i am using
10237978
2228496
http://kamranagayev.com/2010/08/20/rman-convert-database-video-tutorial/
a pdf by Alejandro Vargas
please suggest any material related to this
1)is there a neccessity to change the character set?
2)*can we migrate when the database version is different?*
can i start the process between these databases 10.2.0.1.0 on windows to 11.2.0.1.0 on linux
thanks in advance

Edited by: 946207 on Aug 13, 2012 11:01 AM
This post has been answered by saurabh on Aug 13 2012
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 21 2012
Added on Aug 13 2012
7 comments
681 views