Oracle Migration Workbench Debugging Procedure

By completing the steps in this debugging procedure, you can provide the Support team with the specific details they require in order to quickly and efficiently debug the issue you encountered during your migration.


1. Identify the Installation Configuration

Please provide the version and operating system of the Oracle Migration Workbench, the Oracle database, the source database and the source ODBC driver as outlined in the following table:

Name Version Operating System
Oracle Migration Workbench 1.3.1.0.0 Windows NT 4.0, SP6
Oracle database 8.1.7 Solaris 8
Source database Sybase Adaptive Server 11.9.2 HP-UX 10
Source ODBC driver 3.11.00.01 Sybase Inc. N/A

You can do this by identifying the following two key pieces of information:

  1. At what stage of the migration did the error actually occur?
    Did it occur during the load of the source database, the creation of the Oracle Model or the migration to the Oracle database? In order to successfully identify the root cause of the migration failure, we recommend that you restart the migration (with a clean repository) and move through each stage of the migration using the Capture and Migration wizards, checking for errors at each stage.

  2. What is the exact text of the error message?
    Once you have located the error text, we recommend that you check the Oracle Migration Workbench FAQ to see if a workaround already exists and is documented. The Oracle Migration Workbench FAQ is available on the Oracle Technology Network and from the Help menu within the Oracle Migration Workbench itself.

A reproducible test case is required in order for the Support team to resolve your issue. Please provide the details that correspond to the time at which your error occurred, as outlined in the following table:

Stage of migration We need...
Loading Source Database
  • Source database export
  • Exact error text
Creating Oracle Model
  • Migration Workbench Repository
  • Exact error text
Migrating to Oracle database
  • Migration Workbench Repository
  • Exact error text
Data Moving
  • Table & data
  • Exact error text
Parsing the stored procedures, triggers, relations...
  • Text & options
  • Exact error text

*The exact error text can be supplied by providing your error.log file or a screenshot of the error message that was displayed.


 

 
 
Free Download

Support Documentation

Tutorials
Online Demo
Walk through the Oracle Migration Workbench and see how it reduces the complexity of database migration to the Oracle platform
.
Quick Tour
The Quick Tour will show you the main features of the Oracle Migration Workbench.

Consulting Services
E-mail this page
Printer View Printer View
Oracle Is The Information Company About Oracle | Oracle RSS Feeds | Careers | Contact Us | Site Maps | Legal Notices | Terms of Use | Privacy