oracle ORA-12505，TNS:listener 当前不知道连接描述符中给出的 SID。Eclipse 和 Fedora 20 通过 JDBC
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/22768870/
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
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor. Eclipse and Fedora 20 via JDBC
提问by Tony
I've installed Oracle 11g XE on a Fedora 20 Virtual Machine, configured it and set the enviroment variables (running the oracle_env.sh). I've got this error when trying to connect Eclipse with the database via jdbc, using this string "jdbc.databaseurl=jdbc:oracle:thin:@192.168.88.134:1521:XE"
我已经在 Fedora 20 虚拟机上安装了 Oracle 11g XE，对其进行了配置并设置了环境变量（运行oracle_env.sh. 尝试使用此字符串通过 jdbc 将 Eclipse 与数据库连接时出现此错误 "jdbc.databaseurl=jdbc:oracle:thin:@192.168.88.134:1521:XE"
I can connect to the database in the Virtual Machine via SQL*Plus (sqlplus / as sysdba).
我可以通过 SQL*Plus ( sqlplus / as sysdba)连接到虚拟机中的数据库。
The $ORACLE_SIDvariable is ok (XE). I've already tried to stop and start the listener, then startup the database, and use the alter system register;command.
的$ORACLE_SID变量是确定（XE）。我已经尝试停止并启动侦听器，然后启动数据库，并使用该alter system register;命令。
Also statically registering the database without success (I cannot asure I did not mistake doing this, so if somebody thinks this could solve my problem I would try again).
静态注册数据库也没有成功（我不能保证我没有弄错，所以如果有人认为这可以解决我的问题，我会再试一次）。
Here is the listener.orafile:
这是listener.ora文件：
# listener.ora Network Configuration File:
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /u01/app/oracle/product/11.2.0/xe)
(PROGRAM = extproc)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE))
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.88.134)(PORT = 1521))
)
)
DEFAULT_SERVICE_LISTENER = (XE)
And the tnsnames.orafile:
和tnsnames.ora文件：
# tnsnames.ora Network Configuration File:
XE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.88.134)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = XE)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
And lsnrctl status:
并且lsnrctl status：
LSNRCTL for Linux: Version 11.2.0.2.0 - Production on 31-MAR-2014 01:22:35
Copyright (c) 1991, 2011, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC_FOR_XE)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.2.0 - Production
Start Date 30-MAR-2014 22:41:35
Uptime 0 days 2 hr. 41 min. 1 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Default Service XE
Listener Parameter File /u01/app/oracle/product/11.2.0/xe/network/admin/listener.ora
Listener Log File /u01/app/oracle/product/11.2.0/xe/log/diag/tnslsnr/192/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC_FOR_XE)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.88.134)(PORT=1521)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
I'm almost sure that the problem is that the listener doesn't know about the database. The previous command should show, apart from what it already shows, something like
我几乎可以肯定问题在于侦听器不知道数据库。上一个命令应该显示，除了它已经显示的内容之外，类似于
Service XE has 1 instance.
Instance "XE", status READY, has 1 handler for this service
... but it doesn't, and I don't know how to solve this.
...但它没有，我不知道如何解决这个问题。
I'm new at this, mainly at Linux, so I will appreciate every detail in the solutions you suggest.
我是这方面的新手，主要是在 Linux 上，所以我会很欣赏你建议的解决方案中的每一个细节。
回答by Alex Poole
This sounds like your database is trying to register using the wrong IP address to contact the listener. Your listener is configured to listen on 192.168.88.134, but perhaps the DB is assuming localhost (127.0.0.1), or an old IP value if the configuration has ever changed.
这听起来像是您的数据库正在尝试使用错误的 IP 地址进行注册以联系侦听器。您的侦听器配置为在 192.168.88.134 上侦听，但如果配置发生更改，DB 可能会假设 localhost (127.0.0.1) 或旧 IP 值。
By default the database will attempt to register against the server's external host name (the default when local_listener is blank), but you may be getting an unexpected value from that - so what is in /etc/hostsfor the machine name matters. Whatever has caused that, registration seems to be failing.
默认情况下，数据库将尝试针对服务器的外部主机名进行注册（local_listener 为空时的默认值），但您可能会从中获得意外的值 - 所以/etc/hosts机器名称的内容很重要。无论是什么原因造成的，注册似乎都失败了。
You can explicitly tell the DB to register using the actual listener address:
您可以明确地告诉数据库使用实际的侦听器地址进行注册：
alter system set local_listener = '192.168.88.134:1521' scope=memory;
alter system register;
If that works and lsnrctl servicesnow shows XE, then repeat the setcommand with scope=bothto make it stick on the next DB restart.
如果可行并且lsnrctl services现在显示XE，则重复该set命令scope=both以使其在下一次数据库重新启动时保持不变。
回答by Bjarte Brandt
Troubleshooting:
故障排除：
- remove listener.ora (for this initial setup, you don't need it. make a backup of it)
- lsnrctl reload
- 删除 listener.ora（对于这个初始设置，您不需要它。备份它）
- lsnrctl 重新加载
or
或者
add XE to your SID_LIST like:
将 XE 添加到您的 SID_LIST 中，例如：
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = XE)
(ORACLE_HOME = /u01/app/oracle/product/11.2.0/xe)
)
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /u01/app/oracle/product/11.2.0/xe)
(PROGRAM = extproc)
)
)
lsnrctl reload
lsnrctl 重新加载
check the alert log for messages.
检查警报日志中的消息。
回答by Yavor
In your listener.ora:
在您的 listener.ora 中：
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.88.134)(PORT = 1521))
(地址 = (协议 = TCP)(主机 = 192.168.88.134)(端口 = 1521))
Usually here by default there is a hostname instead of IP address. Did you do something special so that you have that IP there (192.168.88.134)?
通常默认情况下这里有一个主机名而不是 IP 地址。您是否做了一些特别的事情，以便在那里拥有该 IP (192.168.88.134)？
