oracle：SID匹配错误

报错：java.sql.SQLException: Listener refused the connection with the following error:ORA-12505, TNS:listener does not currently know of SID given in connect descriptorThe Connection descriptor used by the client was:localhost:1521:orcl

解决方案：

找到oracle中的app\oracle\product\10.2.0\server\NETWORK\ADMIN\tnsname.ora

tnsname.ora文件

XE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = GEMPTC)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = XE)
)
)

注意（1）书写oracle的url的时候需要将HOST = GEMPTC和 jdbc:oracle:thin:@GEMPTC:1521:XE匹配

SERVICE_NAME = XE 与 dbc:oracle:thin:@GEMPTC:1521:XE 匹配

（2）HOST = GEMPTC为什么是GEMPTC呢？

GEMPTC代表的是你的主机名，每个人的主机名都是不同的，所以你需要自己查询。查询语法如下：

select HOST_NAME from v$instance

希望对大家有所帮助！