jdbc连接Oracle：Listener refused the connection with the following error: ORA-12505，解决

Exception in thread "main" 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
 
	at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:419)
	at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:536)
	at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:228)
	at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)
	at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:521)
	at java.sql.DriverManager.getConnection(DriverManager.java:571)
	at java.sql.DriverManager.getConnection(DriverManager.java:215)
	at com.test.OracleTest.main(OracleTest.java:13)
Caused by: oracle.net.ns.NetException: Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
 
	at oracle.net.ns.NSProtocol.connect(NSProtocol.java:386)
	at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1054)
	at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:308)
	... 7 more

//创建连接对象
Connection conn = DriverManager.getConnection(“jdbc:oracle:thin:@localhost:1521:orcl”,“admit”,“123”);

这个问题是数据库监听的配置文件中sid不正确，也就是url中的“orcl"，进入数据库安装目录下，找到tnsnames.ora文件，例如我的路径是/home/Oracle_11g/product/11.2.0/dbhome_1/network/admin/tnsnames.ora
发现SERVICE_NAME = XE,而不等于orcl，所以就可以将url中的orcl改为XE即可
Connection conn = DriverManager.getConnection(“jdbc:oracle:thin:@localhost:1521:orcl”,“admit”,“123”);