When doing Data migration using SSMA user may encounter the following pop-up message:
Failed prerequisites list:
Common requirement: SSMA extension pack was not found on the database server. Install the SSMA extension pack to use the data migration.
This error message usually occur when
a) Extension pack is not installed on SQL Server instance
b) The Sysdb and ssma_oracle databases doesn’t exist on the sql server instance which you are trying to connect or is not accessible because of lack of permissions.
a) Install the extension pack on SQL server instance.
b) Ensure that the Sysdb and ssma_oracle databases exists on the sql server machine which you are trying to connect and is accessible.
Article Id: KBO2SS1007
SSMA 2005 for Oracle
SSMA 2008 for Oracle