Migrate SQL Server database to Oracle

1

I'm trying to migrate a database from SQL Server to Oracle , for this I'm using Oracle SQL Developer as suggested by the following Oracle Tutorial , which has the following sections:

  • Connection: 1. Install Oracle SQL Developer 2. Create and configure migration repository:

a) Assign permissions: Grant connect, resource, create session, create view to migration_repo identified by migration_repo;

b) Connect to created repository:

Nombre de Conexión: migration_repo 
Usuario: migration_repo 
Contraseña: migration_repo 
SID: MYSID_ORACLE

C) Associate Repository: Tools / Migration / Repository Management / Create Repository, choose " migration_repo "

3. Connect to third party database

  • Capture
  • Convert
  • Transfer
  • Generate
  • Move Data

I follow the previous steps, but at the end of the transfer section I get the following error:

Error:

<message>Error:ORA-06550: línea 1, columna 14:
    PLS-00201: el identificador 'SS2K5ALLPLATFORM.STAGECAPTURE' se debe declarar
    ORA-06550: línea 1, columna 7:
    PL/SQL: Statement ignored
    : FAILED : Migración de Base de Datos : FAILED</message>

Complete Log Information:

<?xml version="1.0" encoding="windows-1252" standalone="no"?>
<log>
<record>
  <date>2016-06-01T16:48:18</date>
  <logger>oracle.dbtools.migration.workbench.core.MigrationLogResourceBundle</logger>
  <level>SEVERE</level>
  <class>oracle.dbtools.migration.workbench.core.logging.MigrationLogUtil</class>
  <message>Capture
Enterprise Capture
Capture failed.  Refer to MIGRLOG table in the repository for details</message>
  <param>oracle.dbtools.migration.workbench.core.ui.FullMigrateTask.doOnlineEnterpriseCapture(FullMigrateTask.java:758)</param>
  <param>oracle.dbtools.migration.workbench.core.ui.FullMigrateTask.doCapture(FullMigrateTask.java:601)</param>
  <param>oracle.dbtools.migration.workbench.core.ui.FullMigrateTask.doMaskBasedActions(FullMigrateTask.java:400)</param>
  <param>oracle.dbtools.migration.workbench.core.ui.FullMigrateTask.doWork(FullMigrateTask.java:314)</param>
  <param>oracle.dbtools.migration.workbench.core.ui.FullMigrateTask.doWork(FullMigrateTask.java:147)</param>
  <param>oracle.dbtools.raptor.backgroundTask.RaptorTask.call(RaptorTask.java:193)</param>
  <param>java.util.concurrent.FutureTask.run(FutureTask.java:266)</param>
  <param>oracle.dbtools.raptor.backgroundTask.RaptorTaskManager$RaptorFutureTask.run(RaptorTaskManager.java:621)</param>
  <param>java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)</param>
  <param>java.util.concurrent.FutureTask.run(FutureTask.java:266)</param>
  <param>java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)</param>
  <param>java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)</param>
  <param>java.lang.Thread.run(Thread.java:745)</param>
  <param>oracle.dbtools.migration.workbench.core.logging.LogInfo@572aa33a</param>
  <exception>
    <message>oracle.dbtools.migration.workbench.core.ui.FullMigrateTask$FullMigrateTaskException: Capture
Enterprise Capture
Capture failed.  Refer to MIGRLOG table in the repository for details</message>
    <frame>
      <class>oracle.dbtools.migration.workbench.core.ui.FullMigrateTask</class>
      <line>758</line>
    </frame>
    <frame>
      <class>oracle.dbtools.migration.workbench.core.ui.FullMigrateTask</class>
      <line>601</line>
    </frame>
    <frame>
      <class>oracle.dbtools.migration.workbench.core.ui.FullMigrateTask</class>
      <line>400</line>
    </frame>
    <frame>
      <class>oracle.dbtools.migration.workbench.core.ui.FullMigrateTask</class>
      <line>314</line>
    </frame>
    <frame>
      <class>oracle.dbtools.migration.workbench.core.ui.FullMigrateTask</class>
      <line>147</line>
    </frame>
    <frame>
      <class>oracle.dbtools.raptor.backgroundTask.RaptorTask</class>
      <line>193</line>
    </frame>
    <frame>
      <class>java.util.concurrent.FutureTask</class>
      <line>266</line>
    </frame>
    <frame>
      <class>oracle.dbtools.raptor.backgroundTask.RaptorTaskManager$RaptorFutureTask</class>
      <line>621</line>
    </frame>
    <frame>
      <class>java.util.concurrent.Executors$RunnableAdapter</class>
      <line>511</line>
    </frame>
    <frame>
      <class>java.util.concurrent.FutureTask</class>
      <line>266</line>
    </frame>
    <frame>
      <class>java.util.concurrent.ThreadPoolExecutor</class>
      <line>1142</line>
    </frame>
    <frame>
      <class>java.util.concurrent.ThreadPoolExecutor$Worker</class>
      <line>617</line>
    </frame>
    <frame>
      <class>java.lang.Thread</class>
      <line>745</line>
    </frame>
  </exception>

</record>
<record>
  <date>2016-06-01T16:48:18</date>
  <logger>oracle.dbtools.migration.workbench.core.MigrationLogResourceBundle</logger>
  <level>WARNING</level>
  <class>oracle.dbtools.migration.workbench.core.ui.FullMigrateTask</class>
  <message>Error:ORA-06550: línea 1, columna 14:
PLS-00201: el identificador 'SS2K5ALLPLATFORM.STAGECAPTURE' se debe declarar
ORA-06550: línea 1, columna 7:
PL/SQL: Statement ignored
: FAILED : Migración de Base de Datos : FAILED</message>
  <param>oracle.dbtools.migration.workbench.core.logging.LogInfo@7e8e4394</param>

Tools:

  • Microsoft SQL Server 2012
  • Oracle 11g V2
  • Oracle SQL Developer 4.1.3.20.78
  • Java (TM) 1.80_60
  • jtds-1.2-dist
asked by Goerman 02.06.2016 в 00:37
source

1 answer

3

I do not know if it's the best solution, but I solved the situation with the following steps.

  • Modify the privileges of the migration repository Grant ALL PRIVILEGES to migration_repo identified by migration_repo;
  • Remove repository created "migration_repo"
  • Delete connection to migration_repo
  • Start again with the tutorial steps
  • answered by 02.06.2016 в 18:06