listener does not currently know of SID异常

Oracle中"listener does not currently know of SID given in connect descriptor"异常
大概意思：连接Oracle数据库时，监听无法识别SID

关于启动数据库后提示ora-12505的解决方法： listener does not currently know of SID given in connect descriptor

第一种可能
配置的数据库SID名不正确localhost:1521:oracle 即红字部分不是你本机的SID，那么如何查看本机得SID呢？用如下命令 select name from v$database;在sqlplus中执行就可以看到，把红字部分换成查询出来的SID就可以。
第二种可能
发现SID配置没有错误，但是还是报错，那可能就是oracle监听配置出了问题，需要检查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 = ljq-PC)(PORT = 1521))
)
)