问题描述
请注意,出于安全考虑,我更改了详细信息.但是,问题仍然完好无损.
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
. Pleasesee 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:故障-测试失败:网络适配器无法建立连接?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!