Hi I am trying to install and use the SSMA for Oracle v6.

Server is Windows 2012, SQL 2012

Two issues

1. Installer says Oracle client is not present. It is installed, version 11.1.  It successfully connects to the Oracle instance
2. I installed anyway thinking I could resolve that later (based on the screen that said it could be installed later).  When trying to run the SSMA Script Installer it fails immediately.  The Just In Time debugger says Unhandled Exception (System.IO.FileLoadException) occurred in SSMA Script Installer.exe [256]

I tried uninstalling to start fresh, but it will not uninstall.  Ive rebooted the server.

I cant proceed.  There are no logs that I have been able to find.

Do you have full Oracle <version> (for x64) client installed? &

Are you running SSMA as an administrator? 

Hello,

Make sure you installed the complete oracle client (I choose the Administrator installation type) and it must have the same version or later of your Oracle database server.

The following resources may be useful.

http://download.microsoft.com/download/F/C/A/FCA37580-53F5-46DB-A981-E08018661F09/Migrating-Oracle-to-SQL-Server-2014-and-Azure-SQL-DB.pdf

https://msdn.microsoft.com/en-us/library/hh313197(v=sql.110).aspx

https://msdn.microsoft.com/en-us/library/hh313203%28v=sql.110%29.aspx?f=255&MSPPError=-2147217396

Hope this helps.

Regards,

Alberto Morillo
SQLCoffee.com

Oracle 6?!?!?!?

Oracle 6 is probably too old to work, it's certainly not supported.

David

SSMA for Oracle requires the full Oracle Client, as I was only able to complete the SSMA for Oracle install after installing the full Oracle 11g (for x64) client. 

 Oracle 11.2.0.1, the client version for 64-bit and the Oracle client for 32-bit are shipped separately, and there is an$ORACLE_HOME/lib64 directory.

$ORACLE_HOME/lib/     ==> 32 bit
$ORACLE_HOME/lib64 ==>  64 bit

Oracle 6?!?!?!?

Oracle 6 is probably too old to work, it's certainly not supported.

Hello,

David is seems he is making a reference to SSMA 6 not Oracle 6

Hope this helps.

Regards,

Alberto Morillo
SQLCoffee.com

Yes and Yes.

I'm not running the SSMA yet, I can't get the extension pack to install completely, nor get it to uninstall, nor get it to run and create the objects it needs on the SQL side. 

Thanks

I'm not running the SSMA yet, I can't get the extension pack to install completely, nor get it to uninstall, nor get it to run and create the objects it needs on the SQL side. 

Unless having the wrong Oracle client would prevent the extension pack installation or removal?

You don't actually need the extension pack to use SSMA.  You can use it as a client-only tool for both schema conversion and data migration.

David

You don't actually need the extension pack to use SSMA.  You can use it as a client-only tool for both schema conversion and data migration.

As of 6.0 the Extension Pack is only needed for server-side data migration and for the testing component.

The SSMA client tool will client-side migration.  IE Oracle>SSMA on the Client>SQL Server.

https://msdn.microsoft.com/en-us/library/hh313165(v=sql.110).aspx

David

Yes I agree with David Extension pack is required only when you use server side migration. You can use client side data migration but which will be slow when compare to server side data migration and server side data migration will make use of SQL Server instance memory . Try to uninstall extension pack completely and reinstall.

I dont know how comfortable you are with this, but there are ways to remove an installed app by modifying the registry so the app no longer looks installed.
This is an operation you only want to perform if you know what you are doing.

This is not a well recommended method by Microsoft and there are few Microsoft articles on the topic mostly old like this one:
https://support.microsoft.com/en-us/kb/314481

But the content still applies.