ORA-12505错误解决措施

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 = XE)
    )
  )

 

③ listener.ora文件配置信息：

该文件所在路径为：%ORACLE_HOME%\NETWORK\ADMIN

SID_LIST_LISTENER =
(SID_LIST =
    (SID_DESC =
    (SID_NAME = PLSExtProc)
    (ORACLE_HOME = D:\app\product\11.1.0\db_1)
    (PROGRAM = extproc)
    )
    ( SID_DESC =     
  (GLOBAL_DBNAME = XE)      
  (ORACLE_HOME = D:\app\product\11.1.0\db_1)     
  (SID_NAME = XE)   
 )
)

LISTENER =
(DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
      (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
    )
)

 

④ 通过运行services.msc，查看SID值：OracleServiceXE

 

最后，重启Oracle监听OracleOraDb11g_home1TNSListener