Oracle SQL Developer:故障-测试失败:网络适配器无法建立连接? [英] Oracle SQL Developer: Failure - Test failed: The Network Adapter could not establish the connection?

问题描述

请注意，出于安全考虑，我更改了详细信息.但是，问题仍然完好无损.

Please note that I changed details for security purposes. However, the problem remains intact.

我在服务器herp-devDV.derp.edu上的服务器上安装了Oracle 11g数据库. 现在，我在服务器derp-db.derp.edu上有另一个Oracle 11g数据库.

I installed an Oracle 11g database on a server at location, say, herp-devDV.derp.edu. Now I have another Oracle 11g database on a server at location, say, derp-db.derp.edu.

我在Oracle SQL Developer中为herp-devDV.derp.edu和derp-db.derp.edu输入了连接名称，用户名，密码，主机名和服务名称.我可以连接到derp-db.derp.edu中的架构，但不能连接到herp-devDV.derp.edu.它给了我这个信息:

I entered the connection name, username, password, hostname, and service name in Oracle SQL developer for both herp-devDV.derp.edu and derp-db.derp.edu. I can connect to schema in derp-db.derp.edu, but not herp-devDV.derp.edu. It gives me this message:

Failure - Test failed: The Network Adapter could not establish the connection

详细信息

我有以下信息:

Details

I have the following information:

telnet时，
• 任一服务器的端口1521均未打开
• 我的听众都已启动并正在运行.
• 我可以在Oracle SQL Developer上访问derp-db.derp.edu.
• Oracle客户端在我的本地计算机上+ Oracle SQL Developer
• 我可以将台式机远程连接到两台服务器

• Port 1521 is not open for either server when I telnet
• My listener is up and running for both.
• I can access derp-db.derp.edu on Oracle SQL Developer.
• Oracle client is on my local machine + Oracle SQL Developer
• I can remote desktop to both servers

• Googled
• Stackoverflow
• 停止和启动lnrctl命令
• 在herp-devDB.derp.edu上，我运行了lsnrctl status

• Googled
• Stackoverflow
• Ran stop and start lnrctl commands
• On herp-devDB.derp.edu I ran lsnrctl status

我收到以下输出

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for 64-bit Windows: Version 11.2.0.1.0 - Production
Start Date                03-JUN-2014 13:37:22
Uptime                    6 days 0 hr. 53 min. 4 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   D:\oracle\product\11.2.0\dbhome_1\network\admin\listener.ora
Listener Log File         d:\oracle\diag\tnslsnr\HERP-DEVDB\listener\alert\log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521ipc)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=HERP-DEVDB.derp.edu)(PORT=1521)))
Services Summary...
Service "CLRExtProc" has 1 instance(s).
  Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "HERPDEVDBXDB" has 1 instance(s).
  Instance "herpdevdb", status READY, has 1 handler(s) for this service...
Service "herpdevdb" has 1 instance(s).
  Instance "herpdevdb", status READY, has 1 handler(s) for this service...
The command completed successfully

然后我查看我的listener.ora并找到

I then check out my listener.ora and find

  SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = CLRExtProc)
      (ORACLE_HOME = D:\oracle\product\11.2.0\dbhome_1)
      (PROGRAM = extproc)
      (ENVS = "EXTPROC_DLLS=ONLY:D:\oracle\product\11.2.0\dbhome_1\bin\oraclr11.dll")
    )
  )

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
      (ADDRESS = (PROTOCOL = TCP)(HOST = HERP-DEVDB.derp.edu)(PORT = 1521))
    )
  )

在这一点上，我承认我挠头，因为我看不到任何东西伸出来，并告诉我为什么这不起作用.

At this point, I confess I am scratching my head as I don't see anything sticking out and telling me why this should not be working.

唯一的线索是当我检查derp-db.derp.edu并运行命令lsnrctl status时.请 参见下面的摘录:

The only clue is when I check derp-db.derp.edu and run the command lsnrctl status. Please see excerpt below:

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=DERP-DB.edu)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for 64-bit Windows: Version 11.2.0.3.0 - Production
Start Date                18-MAY-2014 02:19:01
Uptime                    22 days 12 hr. 23 min. 18 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
---etc----

所以我仍在挠头.为什么derp-db将连接到DERP-DB.edu，而herp-devDB将连接到EXTPROC1521?我该如何解决?除了实例名称之外，这两个服务器之间的listener.ora和其他文件几乎相同. 嗯

So I am still scratching my head. Why would derp-db be connecting to the DERP-DB.edu but herp-devDB is connecting to EXTPROC1521? How do I fix this? The listener.ora and other files between these two servers are almost identical except for the name of the instances. Hmmm.

• EDIT1 :我更改了herp中的listener.ora.这没有解决.

• I changed the listener.ora in herp. This didn't fix it.

我无法通过端口1521 telnet到derp-db.derp.edu，但是我仍然可以使用SQL Developer连接到它吗?是什么?

I cannot telnet into derp-db.derp.edu on port 1521. But I can still connect to it with SQL Developer? Wth?

无论如何，我们将不胜感激.谢谢

Anyway assistance would be greatly appreciated. Thanks

关于， 怪异

推荐答案

我正在回答此问题，这是为了将来的社区用户受益.有多个问题.如果遇到此问题，建议您寻找以下内容:

I am answering this for the benefit of future community users. There were multiple issues. If you encounter this problem, I suggest you look for the following:

• 确保您的tnsnames.ora已完成，并且具有您要连接的数据库
• 确保您可以对要连接的服务器进行tmpping
• 在服务器上，确保将在要使用的特定应用程序所需的端口上将其打开.

一旦我做了这三件事，我就解决了我的问题.

Once I did these three things, I solved my problem.

这篇关于Oracle SQL Developer:故障-测试失败:网络适配器无法建立连接?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！