12 ноября 2010 г. 22:21
During install of SSMA 4.2 for Oracle, I immediately get the error:
"Required Component Missed
Oracle client software not found.
Setup is unable to find Oracle client software. You can install it from Oracle product media... etc."
I have the following versions of Oracle client installed:
Oracle database 10g Express Edition (XE database w/client included?)
Oracle - OraClient11g_home1 (part of Oracle 11g Release 2 ODAC Oracle Data Access Components install - contains a client?)
Oracle instant client 10g.
Does SSMA require the standard client (not free), or is it supposed to work with any of the above free Oracle client versions?
I have tried pointing ORACLE_HOME to each of the 3 clients, and PATH to each bin directory, but all give the same error during SSMA install.
15 ноября 2010 г. 7:22Модератор
Under “Requirements for the SSMA for Oracle client” section in the download page of SQL Server Migration Assistant for Oracle v4.2, I have found the following statements:
Oracle Client 8.1.7 or a later version, and connectivity to the Oracle databases that you want to migrate. The Oracle client version must be the same version as, or a later version than, the Oracle database version.
If anything is unclear, please let me know.
15 ноября 2010 г. 14:36
All my clients are the same version or later than the database. That's not the issue. I just want SSMA for Orcle to stop giving that error message, and find one of the 3 clients.
Has anyone had success with SSMA connecting to an Oracle 10g XE database using any of those 3 Oracle clients?
16 ноября 2010 г. 17:02
Apparently, 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.
None of the 3 flavors of Oracle clients mentioned above would satisfy the SSMA installer.
- Помечено в качестве ответа Ken L. Cooley 16 ноября 2010 г. 17:02
24 января 2012 г. 5:24
Can anyone please advise which installation type should be use for oracle client in following screen shot.
5 апреля 2012 г. 9:08
I installed type administrator for my oracle 10G client and was able to connect SSMA 5.2 with Oracle as source.
18 апреля 2012 г. 18:11For what it is worth, prior to installing SSMA I had already installed the Oracle client according to the custom settings we normally use so I knew the client was installed and working. When I went to install SSMA I received the message about can't find the Oracle client as well but I just went ahead with the install and when I provided SSMA with the configurations it connected to the Oracle database just fine.