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