自己些了个JDBC的应用,昨天运行的还很正常,结果今天再调试的时候报错了:
wrong!java.sql.SQLException: 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:HERAIN说是SID不对,可是我打开tnsnames.ora看了,内容如下:
# tnsnames.ora Network Configuration File: D:\oracle\product\10.1.0\Db_1
\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.HERAIN =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = herain)
)
)EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)SID明明就是HERAIN啊
以为是程序出了问题,调出早前的一个测试通过的JDBC应用,发现也连不上了,检查
Oracle的各项服务,都是正常的,SQL+PLUS也可以正常访问数据库。为什么会这样??
期待大虾给点意见,谢谢了
wrong!java.sql.SQLException: 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:HERAIN说是SID不对,可是我打开tnsnames.ora看了,内容如下:
# tnsnames.ora Network Configuration File: D:\oracle\product\10.1.0\Db_1
\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.HERAIN =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = herain)
)
)EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)SID明明就是HERAIN啊
以为是程序出了问题,调出早前的一个测试通过的JDBC应用,发现也连不上了,检查
Oracle的各项服务,都是正常的,SQL+PLUS也可以正常访问数据库。为什么会这样??
期待大虾给点意见,谢谢了
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货