Tried workaround 1 but it didn't work for me, but workaround 2 did. I set the path to DLL in SSMS

To

‘C:\Microsoft SQL Server Migration Assistant for Oracle Extension Pack\bin\ext\x64\SSMA4OracleSQLServerExtensions.dll’.

I then had to grant execute permission to the stored procs.

xp_ora2ms_exec2

xp_ora2ms_exec2_ex

xp_ora2ms_versioninfo2