database 用于连接到 SQLDeveloper 的供应商代码 17002
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/14340729/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
Vendor code 17002 to connect to SQLDeveloper
提问by Gutenberg
I'm trying to connect to a database using SQLDeveloper and I get the following error:
我正在尝试使用 SQLDeveloper 连接到数据库，但出现以下错误：
An Error was Encountered performing The requested operation:
IO Error: Conection reset
Vendor code 17002.
Could you please help me?
请你帮助我好吗？
回答by Wajid Hussain Siddiqi
Listed are the steps that could rectify the error:
列出了可以纠正错误的步骤：
- Press Windows+R
- Type
services.mscand strike Enter - Find all services
- Starting with
orastart these services and wait!! - When your server specific service is initialized (in my case it was
orcl) - Now run
mysqlor whatever you are using and start coding.P
- 按Windows+R
- 类型
services.msc和罢工Enter - 查找所有服务
- 从
ora启动这些服务开始等待！！ - 当您的服务器特定服务初始化时（在我的情况下是
orcl） - 现在运行
mysql或任何你正在使用的东西并开始编码。P
回答by luckyfish
I encountered same problem with ORACLE 11G express on Windows. After a long time waiting I got the same error message.
我在 Windows 上使用 ORACLE 11G express 遇到了同样的问题。经过长时间的等待，我收到了相同的错误消息。
My solution is to make sure the hostname in tnsnames.ora (usually it's not "localhost") and the default hostname in sql developer(usually it's "localhost") same. You can either do this by changing it in the tnsnames.ora, or filling up the same in the sql developer.
我的解决方案是确保 tnsnames.ora 中的主机名（通常不是“localhost”）和 sql developer 中的默认主机名（通常是“localhost”）相同。您可以通过在 tnsnames.ora 中更改它来完成此操作，也可以在 sql developer 中填写相同内容。
Oh, of course you need to reboot all the oracle services (just to be safe).
哦，当然你需要重新启动所有的 oracle 服务（只是为了安全）。
Hope it helps.
希望能帮助到你。
I came across the similar problem again on another machine, but this time above solution doesn't work. After some trying, I found restarting all the oracle related services can fix the problem. Originally when the installation is done, connection can be made. Somehow after several reboot of computer, there is problem. I change all the oracle services with start time as auto. And once I could not connect, I restart them all over again (the core service should be restarted at last order), and works fine.
我在另一台机器上再次遇到了类似的问题，但这次上述解决方案不起作用。经过一些尝试，我发现重新启动所有与 oracle 相关的服务可以解决问题。最初安装完成后，即可进行连接。不知何故，经过几次重新启动计算机后，出现了问题。我将开始时间更改为自动的所有 oracle 服务。一旦我无法连接，我就会重新启动它们（核心服务应该在最后一次重新启动），并且工作正常。
Some article says it might be due to the MTS problem. Microsoft's problem. Maybe!
有些文章说这可能是由于 MTS 问题。微软的问题。也许！
回答by user3766355
I had the same Problem. I had start my Oracle TNS Listener, then it works normally again.
我有同样的问题。我已经启动了我的 Oracle TNS 监听器，然后它又可以正常工作了。
回答by Punith Raj
In your case the "Vendor code 17002" is the equivalent of the ORA-12541 error: It's most likely that your listener is down, or has an improper port or service name. From the docs:
在您的情况下，“供应商代码 17002”相当于 ORA-12541 错误：很可能您的侦听器已关闭，或者端口或服务名称不正确。从文档：
ORA-12541: TNS no listener
Cause: Listener for the source repository has not been started.
原因：源存储库的侦听器尚未启动。
Action: Start the Listener on the machine where the source repository resides.
操作：在源存储库所在的机器上启动侦听器。
