网络适​​配器无法在SQL开发人员中建立连接 [英] The Network Adapter could not establish the connection in SQL developer

问题描述

我使用SQL开发人员列表创建了一个包含1000个条目的数据库，并且已成功创建。连接也成功。但是今天我在尝试连接时发生错误：

I created a database using SQL developer list of 1000 entries and it created successfully. The connection also succeeded. But today while I'm trying to connect there is an error occurring:

IO Error: The Network Adapter could not establish the connection in SQL developer

我可以肯定地说，它不是连接我试过在命令提示符也在提示中提到协议适配器错误。

I can surely say it is not connecting I tried it in Command prompt also in prompt it is mentioning as Protocol Adapter Error.

这里有什么问题？

协议适配器错误是什么意思如何克服它？

What is meant by Protocol Adapter Error how can i overcome it?

什么是网络适配器错误？

What is Network Adapter Error?

推荐答案

请检查侦听器是否失效： -

Please check the listener to see if it is down:-

ps -ef | grep tns

如果你没有找到监听器的输出，那么你必须启动它。要在 LSNRCTL> 提示符中执行 start 。

If you dont find the output of the listener then you have to start it. To do that type start in the LSNRCTL> prompt.

从 Oracle论坛：

如果Oracle客户端已使用11.1.2.3安装，则TNS_ADMIN
将指向\user_projects\config\dbclient在
该文件夹中应该有一个tnsnames .ora，如果Oracle DB在
同一台机器上，您可能想将数据库tnsnames
文件夹的内容复制到TNS_ADMIN文件夹，或者根据建议更改环境
变量。

If the Oracle clients have been installed with 11.1.2.3 the TNS_ADMIN will be point to \user_projects\config\dbclient In that folder there should be a tnsnames.ora, if the Oracle DB is on the same machine you may want to copy the contents of database tnsnames folder to the TNS_ADMIN folder or as suggested change the environment variable.

这篇关于网络适​​配器无法在SQL开发人员中建立连接的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！