问题登场:
[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
需要了解更多数据库技术:The listener supports no services oracle注册监听,都可以关注数据库技术分享栏目—计算机技术网(www.ctvol.com)!
本文来自网络收集,不代表计算机技术网立场,如涉及侵权请联系管理员删除。
ctvol管理联系方式QQ:251552304
本文章地址:https://www.ctvol.com/dtteaching/797128.html