Microsoft SQL Server Migration Assistant for Oracle Extension Pack missing SSMA for Oracle Data Migration Assistant.dll

We installed SSMA for Oracle 10.1 and were trying to use the client side migration but it is calling for too much ram, so we tried to use the server side migration. However that fails immediately without much info as to why. We installed the extension pack on the target sql server and have noticed that the run attempts fail with the following windows event view errors:

WARNING

Log Name: Application

Source: SQLSERVERAGENT

Date: 5/14/2025 5:49:00 PM

Event ID: 208

Task Category: Job Engine

Level: Warning

Keywords: Classic

User: N/A

Computer: {xxx our server name xxx}

Description:

SQL Server Scheduled Job 'ssma_oracle data migration package {23665CA9-150A-4702-BDE3-4D49348585E2}' (0xCB520104882BE14D8652493D1CFC2944) - Status: Failed - Invoked on: 2025-05-14 17:49:00 - Message: The job failed. The Job was invoked by User {xxx our user xxx}. The last step to run was step 1 (migrate data).

Event Xml:

<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">

<System>

<Provider Name="SQLSERVERAGENT" />

<EventID Qualifiers="16384">208</EventID>

<Version>0</Version>

<Level>3</Level>

<Task>3</Task>

<Opcode>0</Opcode>

<Keywords>0x80000000000000</Keywords>

<TimeCreated SystemTime="2025-05-14T21:49:00.7742345Z" />

<EventRecordID>15954</EventRecordID>

<Correlation />

<Execution ProcessID="0" ThreadID="0" />

<Channel>Application</Channel>

<Computer>{xxx our server name xxx}</Computer>

<Security />

</System>

<EventData>

<Data>ssma_oracle data migration package {23665CA9-150A-4702-BDE3-4D49348585E2}</Data>

<Data>0xCB520104882BE14D8652493D1CFC2944</Data>

<Data>Failed</Data>

<Data>2025-05-14 17:49:00</Data>

<Data>The job failed.  The Job was invoked by User {xxx our user name xxx}.  The last step to run was step 1 (migrate data).</Data>

</EventData>

</Event>

ERROR

Log Name: Application

Source: .NET Runtime

Date: 5/14/2025 6:03:07 PM

Event ID: 1023

Task Category: None

Level: Error

Keywords: Classic

User: N/A

Computer: {xxx our server name xxx}

Description:

Description: A .NET application failed.

Application: SSMA for Oracle Data Migration Assistant.exe

Path: D:\Program Files\Microsoft SQL Server\MSSQL16.MSSQLSERVER\MSSQL\Binn\Microsoft SQL Server Migration Assistant for Oracle Extension Pack\bin\SSMA for Oracle Data Migration Assistant.exe

Message: The application to execute does not exist: 'D:\Program Files\Microsoft SQL Server\MSSQL16.MSSQLSERVER\MSSQL\Binn\Microsoft SQL Server Migration Assistant for Oracle Extension Pack\bin\SSMA for Oracle Data Migration Assistant.dll'.

Event Xml:

<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">

<System>

<Provider Name=".NET Runtime" />

<EventID Qualifiers="0">1023</EventID>

<Version>0</Version>

<Level>2</Level>

<Task>0</Task>

<Opcode>0</Opcode>

<Keywords>0x80000000000000</Keywords>

<TimeCreated SystemTime="2025-05-14T22:03:07.8501819Z" />

<EventRecordID>15970</EventRecordID>

<Correlation />

<Execution ProcessID="0" ThreadID="0" />

<Channel>Application</Channel>

<Computer>{xxx our server name xxx}</Computer>

<Security />

</System>

<EventData>

<Data>Description: A .NET application failed.

Application: SSMA for Oracle Data Migration Assistant.exe

Path: D:\Program Files\Microsoft SQL Server\MSSQL16.MSSQLSERVER\MSSQL\Binn\Microsoft SQL Server Migration Assistant for Oracle Extension Pack\bin\SSMA for Oracle Data Migration Assistant.exe

Message: The application to execute does not exist: 'D:\Program Files\Microsoft SQL Server\MSSQL16.MSSQLSERVER\MSSQL\Binn\Microsoft SQL Server Migration Assistant for Oracle Extension Pack\bin\SSMA for Oracle Data Migration Assistant.dll'.

</Data>

</EventData>

</Event>