程序连接oracle数据库，运行报错提示ORA-12505

Question

在我删掉workspace下的.metadata文件，再次创建的新workplace后，以前可以正常连接数据库的Java程序报错，提示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

Answer 1

listener.ora

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

)

ADR_BASE_LISTENER = D:\app\Administrator

tnsnames.ora

ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(CONNECT_DATA =
(SID = orcl)
(SERVER = DEDICATED)
(SID_NAME = orcl)
)
)