The listener supports no services oracle注册监听
- 作者: 草莓roii
- 来源: 51数据库
- 2021-08-17
问题登场：
[oracle@my-e450 ~]$ lsnrctl status
……
the listener supports no services
the command completed successfully
sql> conn sys/oracle@192.168.1.133:1521/orcl as sysdba
error:
ora-12514: tns:listener does not currently know of service requested in connect
descriptor
解决过程：
sql> alter system set local_listener='(address=(protocol=tcp)(host=192.168.1.133)(port=1521))';
system altered.
验证：
[oracle@my-e450 ~]$ lsnrctl status
……
service "orcl" has 1 instance(s).
instance "orcl", status ready, has 1 handler(s) for this service...
service "orclpdb" has 1 instance(s).
instance "orcl", status ready, has 1 handler(s) for this service...
sql> conn sys/oracle@192.168.1.133:1521/orcl as sysdba
connected.
嗯，问题解决了！
注： oracle 版本为 12.2.0.1.0
写于 oct.30, 2019
推荐阅读
