ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
此时,数据库服务器已经启动,连接的驱动程序和数据库SID都没错,用户名和口令也没错,数据源url中的端口号使用的是1521;纠结了很久,后来检查了数据库安装目录D:\oracle\product\10.2.0\db_1\network\ADMIN下面的listener.ora文件,发现里面的配置的端口号也不是我们一般使用的1521,而是1522,把端口号改为1522,数据源也就连接上了。
listener.ora文件内容
# listener.ora Network Configuration File: D:\oracle\product\10.2.0\db_1\network\admin\listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = D:\oracle\product\10.2.0\db_1)
(PROGRAM = extproc)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.4)(PORT = 1522))
)
)