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:
127.0.0.1:1521:XE
ORACLE_HOME= ... ... \product\11.1.0\db_1
解决这个问题需要几个地方的SID和端口号保持一致:
① 连接数据库的URL:
jdbc:oracle:thin:@127.0.0.1:1521:XE;
② tnsnames.ora文件配置信息:
该文件所在路径为:%ORACLE_HOME%\NETWORK\ADMIN
XE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME =