本人在用jdbc连接本机上Oracle数据库时,报了一个这样的错误,ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
The Connection descriptor used by the client was:
127.0.0.1:1521:xe
有遇到过这种情的朋友,求指点,感激不尽
The Connection descriptor used by the client was:
127.0.0.1:1521:xe
有遇到过这种情的朋友,求指点,感激不尽
解决方案 »
- virtual circuit wait等待事件是怎么产生的?如何去掉
- oracle统计用户在线时长,精确到秒
- 关于表的size增大问题
- oracle9i有没有像sql server企业管理器中的“返回所有行”的功能,即在界面上就可以往表中的字段写入数据不是通过语句INSERT的形式
- 如何新建用户,并给它所有有关某个表空间的权限,在线等。
- 如何在delphi中使用游标?高手指教
- SQL语句to_char(to_date..)的问题
- oracle9i如何备份到磁带机上呢?(急)
- 在中建表,某字段类型BLOB,在SQLPLUS中报错:“ORA-22866: 默认字符集具有不同的宽度”(50)
- 关于审计的问题,如何审计才能得到数据!
- ORACLE:动态SQL问题
- sql和ora存储过程转换,急求帮助,先谢谢啦!!!
或者通过netca 重新配置监听然后再进行连接..
注意你的listen的配置文件和tnsnames.ora文件的信息要有关联.
你确保你的 数据库的sid是xe?
tnsnames.ora文件打开看看
在network/admin/tnsnames.ora下边
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = tangxu-PC)(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)
)
)ORACLR_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE))
)
(CONNECT_DATA =
(SID = CLRExtProc)
(PRESENTATION = RO)
)
)
这个是tnsnames.ora的SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = G:\oracle\app\oracle\product\10.2.0\server)
(PROGRAM = extproc)
)
(SID_DESC =
(SID_NAME = CLRExtProc)
(ORACLE_HOME = G:\oracle\app\oracle\product\10.2.0\server)
(PROGRAM = extproc)
)
)LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE))
(ADDRESS = (PROTOCOL = TCP)(HOST = tangxu-PC)(PORT = 1521))
)
)DEFAULT_SERVICE_LISTENER = (XE)
这个是listener的,有什么不对么
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = G:\oracle\app\oracle\product\10.2.0\server)
(PROGRAM = extproc)
)
(SID_DESC =
(SID_NAME =
CLRExtProcXE)(ORACLE_HOME = G:\oracle\app\oracle\product\10.2.0\server)
(PROGRAM = extproc)
)
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = tangxu-PC)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = XE)[b] )
)你这一段代码中service_name是你主机tangxu-PC中oracle的sid吗?