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,坐等大神求解
解决方案 »
- windows 2008 装 oracle 10g 问题
- 求助!vss中,签出时候没有出现“勾选此文件夹下面的所有子菜单”的框,这是为什么?怎么解决?
- 另外一个关于SQL 2000访问oracle的问题
- sql语句查询排序
- 妹妹求助,外网的机子怎么通过Web服务器访问与其连接着的内网Oracle?谢谢!
- 为什么oracle clob不能用getString读取呢?
- 知道数据库中有一个表名,怎样才能知道这个表位于哪个用户?哪个表空间中?
- 谁有SQL Navigator 3的authorization key?
- 热备份?
- Oracle远程无法连接
- 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))
)
)
)