java - ORA-12505，TNS :listener does not currently know of SID given in connect descriptor

Question

这个问题已经有答案了:

ORA-12505, TNS:listener does not currently know of SID given in connect descriptor (33 个回答)

已关闭 6 年前。

连接代码:

Connection connection = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:orcl", "USER_NAME", "PASSWORD";

异常(exception):

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.(PhysicalConnection.java:536) at oracle.jdbc.driver.T4CConnection.(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)

Answer 1

已解决:

将连接字符串中的“orcl”更改为“XE”。