oracle 连接 sql developer

[camusie]

我新建一个连接，测试时会出现这个问题
状态: 失败 -测试失败: Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor

[小灰狼W]

检查tnsnames.ora中的配置，可能是sid配得不对 建议sid=xxx用service_name=xxx来替换 service_name可以数据库中查看service_names参数来看

[卖水果的net]

应该是 service_name 写错了。 到服务器端，查查是动态注册吗？

[PiaoShiSun]

[color=#0000FF]根据楼主你提供有限的信息，个人推测是listener.ora文件配置问题。 给你一个示例，可对比一下： SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = [color=#FF0000]ORCL) (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)) ) (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521)) ) )[/color][/color]