适用于Oracle的SSMA“连接到Oracle"错误 [英] SSMA for Oracle "Connect to Oracle" error

问题描述

我尝试使用适用于oracle的Sql服务器迁移助手(适用于oracle的SSMA)连接到Oracle. 并指定像这样的参数

i tried to connect to Oracle using Sql server migration assistant for oracle(SSMA for oracle). and specified parameters like this

提供者: Oracle Client Provider

模式:标准模式

和连接信息(服务器名称，端口...)

and connection info(servername, port ...)

但是我收到一条错误消息

but i got a error message

"无法找到指定的提供者. 在计算机上找不到兼容的Oracle数据访问连接库.您可以从Oracle产品介质安装它们，也可以从Oracle网站下载它们."

"Unable to find specified provider. Compatible Oracle Data Access Connectivity libraries were not found on the machine. You can install them from Oracle product media or download it from Oracle web site."

所以我安装了Oracle Data Access Components(ODAC)， http://www.oracle.com/technetwork/database/Windows/downloads/index-090165.html

so i installed Oracle Data Access Components(ODAC), http://www.oracle.com/technetwork/database/windows/downloads/index-090165.html

但出现了相同的错误消息.

but same error message appeared.

什么是兼容的Oracle Data Access Connectivity库?

what is Compatible Oracle Data Access Connectivity library?

推荐答案

我遇到了同样的问题，Oracle数据访问组件(ODAC)是应用程序连接到数据库所必需的，要使用"SSMA"，您需要安装Oracle即时客户端，

I faced the same problem, Oracle Data Access Components (ODAC) are required for applications to connect to the database, to use "SSMA" you need to install Oracle instant client,

1)下载 http://www.oracle.com/technetwork/database/database-technologies/instant-client/overview/index.html

2)解压缩，然后将文件夹添加到路径中，打开控制面板>系统>高级>环境变量>选择路径"并对其进行编辑，以在文件夹中添加新条目.

2) Unzip, then add the folder to the path, open control panel > system > Advanced > Environment Vriables > choose Path and Edit it to add a new entry with your folder.

3)与系统"用户(用户ID =系统)连接

3) Connect with the 'system' user (user id = system)

另请参阅此答案，它对我有所帮助 https://stackoverflow.com/a/26439785/4542599

see also this answer it helped me https://stackoverflow.com/a/26439785/4542599

这篇关于适用于Oracle的SSMA“连接到Oracle"错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！