5 Replies Latest reply: May 15, 2014 11:21 AM by Nino Putra RSS

    Migrating Sql Server to Oracle 11g in different computer

    Nino Putra

      Hi guys, newbie here

       

      I can migrate My Sql to oracle database successfully but in 1 machine (computer)

       

      But now my question is how can I migrate Sql Server to Oracle Database in different computer???

      can u give me the nice tutorial and instructions?

       

      for example :

       

      PC 1 || 192.168.2.15                           PC 2 || 192.168.2.14

           SQL SERVER     ==========>>>    ORACLE DB

       

      thankyou so much

        • 1. Re: Migrating Sql Server to Oracle 11g in different computer
          979801

          Hi,     There are some Functions, oriented with your RDBMS software.You should migrate them first.Check few datatypes of SQL SERVER are not compatible with Oracle Database like datetime(in SQL SERVER)=> date(in Oracle). Hop this would help.

          • 2. Re: Migrating Sql Server to Oracle 11g in different computer
            Mkirtley-Oracle

            Hi,

               You can use the SQL*Developer migration workbench tool to migrate from SQL*Server to Oracle.

            You can find the download, further information and tutorials here -

             

            http://www.oracle.com/technetwork/database/migration/index-084442.html

             

            This has a link to the SQL*Server demonstration which is available here -

             

             

            http://www.oracle.com/technetwork/database/migration/sqlserver-095136.html

             

            If the SQL*Server database is large, for example more than 50mb, then you should use the offline migration method as this gives you more control for larger migrations.

             

            Regards,

            Mike

            • 3. Re: Migrating Sql Server to Oracle 11g in different computer
              Nino Putra

              Hi all..thank you for your reply

              first I had check the data type and the nice tutorial..Like I said before, I already tried moving mysql to oracle in one machine

               

              but my problem now is how to moving sql server to oracle, using sql developer in 2 machines..

              I had give the hostname as my PC 2 IP, but give e error like this

              IO Error: The network adapter could not establish the connection

               

              and I had follow this tutorial but no result

              IO Error: The network adapter could not establish the connection

              • 4. Re: Migrating Sql Server to Oracle 11g in different computer
                Mkirtley-Oracle

                Hi,

                   Have you setup the Oracle database on PC2 as a 'connection' in SQL*Developer ?  Are the property connection details correct -

                - IP address or machine name,

                - port number for the RDBMS listener

                - SID for the Oracle RDBMS SID

                 

                Are you able to 'ping' the machine where the database is running from the SQL*Developer machine and are the database and listener up and running ?

                 

                Regards,

                Mike

                • 5. Re: Migrating Sql Server to Oracle 11g in different computer
                  Nino Putra

                  Hi guys..good news

                  now I can test the connection perfectly

                   

                  so Im doing this :

                  1. change the localhost in listener.ora as my ip 192.168.2.14

                  2. turn off the firewall

                  3. install and setup the telnet

                  4. now i can try to migrate

                   

                  but I have new problem now..of Enterprise Manager 'sickness'

                  all of my listener and host instance was DOWN..only in EM by browser

                   

                  but I still can connecting via CMD..sql plus good, tnsping good, lsnrctl good

                  C:\Users\VIRGIANO>lsnrctl status
                  LSNRCTL for 64-bit Windows: Version 11.2.0.1.0 - Production on 15-MAY-2014 23:32
                  :06
                  Copyright (c) 1991, 2010, Oracle.  All rights reserved.
                  
                  Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
                  STATUS of the LISTENER
                  ------------------------
                  Alias                    LISTENER
                  Version                  TNSLSNR for 64-bit Windows: Version 11.2.0.1.0 - Production
                  Start Date                15-MAY-2014 22:40:28
                  Uptime                    0 days 0 hr. 51 min. 42 sec
                  Trace Level              off
                  Security                  ON: Local OS Authentication
                  SNMP                      OFF
                  Listener Parameter File  F:\app\VIRGIANO\product\11.2.0\dbhome_1\network\admin\listener.ora
                  Listener Log File        f:\app\virgiano\diag\tnslsnr\VIRGIANO-PC\listener\alert\log.xml
                  Listening Endpoints Summary...
                    (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521ipc)))
                    (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.2.14)(PORT=1521)))
                  Services Summary...
                  Service "CLRExtProc" has 1 instance(s).
                    Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
                  Service "orcl" has 1 instance(s).
                    Instance "orcl", status READY, has 1 handler(s) for this service...
                  Service "orclXDB" has 1 instance(s).
                    Instance "orcl", status READY, has 1 handler(s) for this service...
                  The command completed successfully
                  

                  can somebody help me??