Caused by: oracle.net.ns.NetException: Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor还原系统几次了,搞死人了都没好 有经验的朋友帮帮忙请不要贴百度搜来的东西,希望是有经过实践的D:\app\Administrator\product\11.2.0\dbhome_1\NETWORK\ADMIN
listener.ora
内容如下
# listener.ora Network Configuration File: D:\app\Administrator\product\11.2.0\dbhome_1\network\admin\listener.ora
# Generated by Oracle configuration tools.SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = CLRExtProc)
(ORACLE_HOME = D:\app\Administrator\product\11.2.0\dbhome_1)
(PROGRAM = extproc)
(ENVS = "EXTPROC_DLLS=ONLY:D:\app\Administrator\product\11.2.0\dbhome_1\bin\oraclr11.dll")
)
)LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
)
ADR_BASE_LISTENER = D:\app\Administrator网上说改这个文件,貌似没啥效果。
连接字符串绝对没问题,pl/sql连127.0.0.1:1521/orcl报错ORA-12514不要贴百度搜来的东西,可以谈下经验,谢谢各位!
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor还原系统几次了,搞死人了都没好 有经验的朋友帮帮忙请不要贴百度搜来的东西,希望是有经过实践的D:\app\Administrator\product\11.2.0\dbhome_1\NETWORK\ADMIN
listener.ora
内容如下
# listener.ora Network Configuration File: D:\app\Administrator\product\11.2.0\dbhome_1\network\admin\listener.ora
# Generated by Oracle configuration tools.SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = CLRExtProc)
(ORACLE_HOME = D:\app\Administrator\product\11.2.0\dbhome_1)
(PROGRAM = extproc)
(ENVS = "EXTPROC_DLLS=ONLY:D:\app\Administrator\product\11.2.0\dbhome_1\bin\oraclr11.dll")
)
)LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
)
ADR_BASE_LISTENER = D:\app\Administrator网上说改这个文件,貌似没啥效果。
连接字符串绝对没问题,pl/sql连127.0.0.1:1521/orcl报错ORA-12514不要贴百度搜来的东西,可以谈下经验,谢谢各位!
解决方案 »
- eclipse配置resin运行的问题
- wicket:how to get dropdownlist selected value in ListView
- 很想知道的几个概念,请达人进来解释 谢谢了
- 在用poi读取excel数据时,为什么cell.getNumericCellValue()总是得到8.8888888E7(应该得到数字88888888才对)
- 急问!明天客户就验收了,还有一个莫名其妙的错误,请大家救我!
- JBoss发布CXF生成的WebService的时候报错!Failed to define class org.apache.cxf.wsn.jms.JmsPu
- 100分求jsp资料,比如论坛精华包等,谢谢,我是初学者
- getPathInfo的问题?
- 求教 jquery 与 servlet 关于json交互问题!
- 【Spring AOP环绕通知】spring配置文件编译时期错误,附详细代码
- 一个表的外键太多好不好
- tomcat启动报错
还是修改那个文件
# listener.ora Network Configuration File: D:\app\Administrator\product\11.2.0\dbhome_1\network\admin\listener.ora
# Generated by Oracle configuration tools.SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = CLRExtProc)
(ORACLE_HOME = D:\app\Administrator\product\11.2.0\dbhome_1)
(PROGRAM = extproc)
(ENVS = "EXTPROC_DLLS=ONLY:D:\app\Administrator\product\11.2.0\dbhome_1\bin\oraclr11.dll")
) (SID_DESC =
(GLOBAL_DBNAME = orcl)
(ORACLE_HOME = D:\app\Administrator\product\11.2.0\dbhome_1)
(SID_NAME = orcl)
) )LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
)
ADR_BASE_LISTENER = D:\app\Administrator红色部分为添加的内容,两个orcl就是SID,希望对遇到相同问题的人有帮助楼下的接分吧,明晚下班结贴真他大爷的,哥为了这个搞到12点了快,苦逼的程序员啊!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!