I am trying to migrate a database from SQL Server
to Oracle
, for this I am 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
- To transfer
- Trigger
- Move Data
I follow the steps above, but at the end of the transfer section I get the following error:
Mistake:
<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>
Full 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 SQLServer 2012
- Oracle 11g V2
- Oracle SQL Developer 4.1.3.20.78
- Java(TM) 1.80_60
- jtds-1.2-dist
I don't know, if it is the best solution, but I solved the situation with the following steps.
Grant ALL PRIVILEGES to migration_repo identified by migration_repo;
I know this topic is closed but I have a similar problem. I am following these same steps and the migration completes successfully, but the tables it created for me are empty.
I think my problem is that I'm looking at the wrong schematic. When the migration finishes I check what in your case is called "migration_repo" and it has no data. This schema is created to support the migration and it makes sense that it has no data. But then, what schema is the one that will contain the data? I have tried to connect as SYS in the Oracle database and do a select count(*) of the tables that do not have data either.
Thank you and regards