Oracle数据库12c尝试连接时出错:网络适配器无法建立连接 [英] Oracle database 12c Error while trying to connect: The Network Adapter could not establish the connection

问题描述

我是第一次安装Oracle数据库12c.我正确地遵循了所有步骤，并将其安装在Windows 7 64位上，但是当我单击SQL Developer并尝试创建新连接时，我输入了诸如用户名和密码之类的信息，并最终单击了TEST按钮，我得到了错误消息:网络适配器无法建立连接".

I installed Oracle database 12c for the first time. I followed correctly all the steps and installed it on Windows 7 64 bits, but when I click on SQL Developer and try to create a new connection, I put in the informations like Username and password, and finnaly click on TEST button, I get this error message: "The Network Adapter could not establish the connection".

我不知道该怎么办，我阅读了教程并无法解决该错误.另外，当我打开SQL Developer时，我收到一条消息，说Im使用Oracle数据库不支持的Java版本，Im使用Java 1.8，它说我应该只使用1.6到1.7.即时通讯不确定这是否会导致不良后果，但似乎还可以，因为我可以使用SQL Dev进行进一步的研究.所以我该怎么做?非常感谢你！

I dont know what to do anymore, I read tutorials and cant solve that error. Also, when I open SQL Developer, i get a message saying Im using a java version that is not supported by Oracle Database, Im using java 1.8 and it says I should use from 1.6 to 1.7 only. im not sure if that is causing something bad but it seems fine because I can go further using the SQL Dev. So, what should i do? Thank you very much!

推荐答案

这里有一些要检查的东西:

Here are some things to check:

1. 确保已正确配置TNSNAMES.ORA文件以引用数据库.检查SID，主机名和端口号(通常为1521).

1. Ensure that the TNSNAMES.ORA file is properly configured to reference the database. Check for the SID, host name, and port number (typically 1521).

检查是否可以直接从服务器连接，例如使用SQL PLus.这样可以隔离是服务器还是客户端问题.

Check whether you can connect directly from the server, such as with SQL PLus. This should isolate whether it's a server or client problem.

确保服务器上的侦听器服务正在运行.检查是否正确配置了LISTENER.ORA.

Ensure that the Listener service on the server is running. Check that LISTENER.ORA is properly configured.

过去，我遇到了客户端PC无法连接的情况.我发现通过删除(或重命名)SQLNET.ORA文件，可以建立连接.

I encountered a situation in the past where client PCs could not connect. I found that by deleting (or renaming) the SQLNET.ORA file, the connection could be made.

祝你好运.

这篇关于Oracle数据库12c尝试连接时出错:网络适配器无法建立连接的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！