10 Replies Latest reply: Apr 20, 2014 8:59 AM by ASulthan RSS

    Migration db from windows to linux

    951027

      Hello all,

       

      I need to migrate oracle db  from RHEL 6.2 64bit to  windows server 2007 64bit

       

      DB versions  are  11.2.0.3.0 (linux) 11.2.0.1.0( windows )

       

      Please give what strategies could be adapted to achieve this & which is recommended?

      Also provide steps if possible.

       

      Thanks

        • 1. Re: Migration db from windows to linux
          sybrand_b

          Google for 'migrating oracle from windows to linux'

          It will answer your question.

           

          This forum isn't a site to outsource your Google searches.

           

          -----------

          Sybrand Bakker

          Senior Oracle DBA

          • 2. Re: Migration db from windows to linux
            A_zaza

            Your best option is to use data pump export/import.

            Here is a good link:


            http://docs.oracle.com/cd/E11882_01/server.112/e23633/expimp.htm

            • 3. Re: Migration db from windows to linux
              EdStevens

              951027 wrote:

               

              Hello all,

               

              I need to migrate oracle db  from RHEL 6.2 64bit to  windows server 2007 64bit

               

              DB versions  are  11.2.0.3.0 (linux) 11.2.0.1.0( windows )

               

              Please give what strategies could be adapted to achieve this & which is recommended?

              Also provide steps if possible.

               

              Thanks

              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.

              • 4. Re: Migration db from windows to linux
                tvCa-Oracle

                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 ..

                • 5. Re: Migration db from windows to linux
                  tvCa-Oracle

                  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.

                  • 6. Re: Migration db from windows to linux
                    951027

                    Sorry for the subject line , friends its actually  from linux to windows.

                    any other approach apart from data dump?

                     

                    Thanks

                    • 7. Re: Migration db from windows to linux
                      tvCa-Oracle

                      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

                      transportable tablespace

                      transportable database

                      RMAN backup/restore

                      RMAN backup/restore with conversion

                      Golden Gate

                      Streams

                      CTAS (create table as select)/IAS (insert as select)

                      cold backup/restore

                       

                      I'm leaving this to experts, to remove the ones not suited. Some require additional software and licenses

                      • 8. Re: Migration db from windows to linux
                        Smohib

                        you can check SQL Developer also it has good options.

                        • 9. Re: Migration db from windows to linux
                          951027

                          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

                           

                           

                          Any suggestions?

                          • 10. Re: Migration db from windows to linux
                            ASulthan

                            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