Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
The Connection descriptor used by the client was:
localhost:1521:orcl
连接的时候,提示这个错误,今天刚学的oracle,坐等大神求解
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
The Connection descriptor used by the client was:
localhost:1521:orcl
连接的时候,提示这个错误,今天刚学的oracle,坐等大神求解
解决方案 »
- oracle查询连续记录,如何查
- 请教SQL
- oracle数据库掉电怎么解决???
- 急救,oracle双机复制失败,延迟事务堆积很多,是否有办法快速清除延迟事务
- 一个关于oracle 10g的很棘手的问题
- 有oracle 数据库级 触发器编程资料吗?
- 怎么样建立一个用户,让该用户只有查询数据表的权限啊?急!!!!!
- 关于在触发器中给自增型字段赋值的问题!
- 在用 create like 建用户时,出现 ORA_04042 的错误,这是什么原因啊???
- 出现"ORA-03113:通信通道的文件结束",怎么办?
- win2003server中安装oracle10g,通过系统服务启动数据库有问题
- 菜鸟弱弱的问下Oracle与SqlServer最大的区别是什么
http://zhidao.baidu.com/question/139871368.html
修改listener.ora文件,然后重启服务就ok了# listener.ora Network Configuration File: D:\app\Administrator\product\11.1.0\db_1\network\admin\listener.ora
# Generated by Oracle configuration tools.SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = D:\app\Administrator\product\11.1.0\db_1)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = orcl)
(ORACLE_HOME = D:\app\Administrator\product\11.1.0\db_1)
(SID_NAME = orcl)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
)
)
# Generated by Oracle configuration tools.SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = D:\app\Administrator\product\11.1.0\db_1)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = orcl)
(ORACLE_HOME = D:\app\Administrator\product\11.1.0\db_1)
(SID_NAME = orcl)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
)
)