Google for 'migrating oracle from windows to linux'
It will answer your question.
This forum isn't a site to outsource your Google searches.
Senior Oracle DBA
I need to migrate oracle db from RHEL 6.2 64bit to windows server 2007 64bit
DB versions are 22.214.171.124.0 (linux) 126.96.36.199.0( windows )
Please give what strategies could be adapted to achieve this & which is recommended?
Also provide steps if possible.
Your subject line says "from windows to linux"
your message body says "from RHEL 6.2 64bit to windows "
Which is it?
What you describe in the message body is retrograde at every level - downgrading the version of Oracle; moving to a family of OS that is inferior in every way to the family from which you are moving; and moving to an older (than current) version of that inferior OS.
I guess he really means from Windows to Linux. It's tricky, cause if you do searches, the order of the words is not always respected. And, documentation may also only mention the target platform, which will often be Linux, because that is what people migrate to.
I'm also wondering why to move away from Linux ..
Windows x86 and Linux x86 are endian compatible, so there are so many options, some of which may be much easier.
Often you see people asking what the options are, and ppl reply only one option, knowing very well that there are other options, but just because they prefer that & advise something that may be absolutely bad given the unknown variables like actual database size, procedures which are known/unknown to the OP starter, etc. etc.
Sorry for the subject line , friends its actually from linux to windows.
any other approach apart from data dump?
This is a list of almost all DB migration methods, excluding the one mentioned, being export/import (with Datapump).
I didn't remove any option, although some may not be valid for you, for reasons mentioned or for reasons not mentioned.
dataguard physical standby
dataguard logical standby
RMAN backup/restore with conversion
CTAS (create table as select)/IAS (insert as select)
I'm leaving this to experts, to remove the ones not suited. Some require additional software and licenses
you can check SQL Developer also it has good options.
while doing full db import im getting this error
ORA-23327: imported deferred rpc data does not match GLOBAL NAME and platform of importing db
Can you try below steps
List of Steps Needed to Complete the Migration
The migration process is simple, but as it has several steps it is convenient to be familiar with them before running it.
1. Check platform compatibility between source and target OS
2. Start the database in read only mode
3. Check database readiness for transport from Windows to Linux using DBMS_TDB.CHECK_DB
4. Check if there are any external objects
5. Execute the Rman Convert database command
6. Copy converted datafiles, generated Transport Script and Parameter File to Linux
7. Edit the init.ora for the new database
8. Edit the Transport Script and Parameter File changing the windows paths to Linux Paths
9. Execute the Transport Script
10.Change the Database ID
11.Check database integrity
For a detailed step by step guide please check this document : Database Migration From Windows to Linux Using RMAN