当前位置： 移动技术网 > IT编程>数据库>Oracle > The listener supports no services oracle注册监听

The listener supports no services oracle注册监听

2019年10月30日  | 移动技术网IT编程  | 我要评论

问题登场：

[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

您可能感兴趣的文章:

如对本文有疑问，请在下面进行留言讨论，广大热心网友会与你互动！！ 点击进行留言回复

相关文章:

验证码：
最近更新的文章
大家感兴趣的文章
移动技术网