ORA-12514: TNS:listener does not currently know of service requested in connect descriptor

参考了一下网上的各种办法，加SID_LIST，检查/etc/hosts等等信息，结果发现都没有用，也可能并不适用我这个情况吧

背景：12c多租户环境，重启机器后监听断开了，lsnrctl start后出现The listener supports no services

解决办法：尝试了诸多办法，结果发现有一个地方比较奇怪

[oracle@db12 ~]$ sqlplus / as sysdba



Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

SQL> show parameter LOCAL_LISTENER;

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
local_listener                       string      LISTENER_DB12

这里的LOCAL_LISTENER和实际SID不太匹配，但是不敢直接修改，于是又加上了实例名

SQL> alter system set local_listener='LISTENER_DB12','DB12';

执行后再做lsnrctl reload操作，监听恢复正常！

Services Summary...
Service "ba8df643217d4c5fe0531a05a8c01de0" has 1 instance(s).
  Instance "db12", status READY, has 1 handler(s) for this service...
Service "bbe6f3ceff5306dce0531a05a8c067a8" has 1 instance(s).
  Instance "db12", status READY, has 1 handler(s) for this service...
Service "d88295f6b48a3597e0530100007f0ac1" has 1 instance(s).
  Instance "db12", status READY, has 1 handler(s) for this service...
Service "db12" has 1 instance(s).
  Instance "db12", status READY, has 1 handler(s) for this service...
Service "db12XDB" has 1 instance(s).
  Instance "db12", status READY, has 1 handler(s) for this service...
Service "db12pdb" has 1 instance(s).
  Instance "db12", status READY, has 1 handler(s) for this service...
Service "e3350454fee458c6e0530100007fb68d" has 1 instance(s).
  Instance "db12", status READY, has 1 handler(s) for this service...
Service "ec8e1ba7860b7f4ce0530100007fc005" has 1 instance(s).
  Instance "db12", status READY, has 1 handler(s) for this service...
Service "ecf0c04576107d7ce0530100007f6fb1" has 1 instance(s).
  Instance "db12", status READY, has 1 handler(s) for this service...