Oracle service_names值为SYS$SYS.SCHEDULER$_EVENT_QUEUE.ORCL

最新推荐文章于 2022-01-21 21:34:49 发布

Floating warm sun

最新推荐文章于 2022-01-21 21:34:49 发布

阅读量327

点赞数

文章标签： oracle 数据库 database

本文链接：https://blog.csdn.net/loveLAxin/article/details/120889769

版权

通过查看service_names和监听状态都是可以看到这个服务名的，使用 “SYS.SCHEDULER$_EVENT_QUEUE.ORCL” 名称进行连接也是可以的。
以下为一个示例：

SQL> show parameter name
NAME               TYPE	   VALUE
--------------- ---------- -----------------------------------
service_names     string   SYS$SYS.SCHEDULER$_EVENT_QUEUE.ORCL

[oracle@rac1 trace]$ lsnrctl status
Service "SYS$SYS.SCHEDULER$_EVENT_QUEUE.ORCL" has 1 instance(s).
  Instance "orcl1", status READY, has 1 handler(s) for this service...
Service "orcl" has 1 instance(s).
  Instance "orcl1", status READY, has 1 handler(s) for this service...
Service "orclXDB" has 1 instance(s).
  Instance "orcl1", status READY, has 1 handler(s) for this service...
The command completed successfully

如果需要删除该服务名，执行以下操作：

SELECT service_id, inst_id,name,network_name, creation_date FROM gv$active_services WHERE name like '%SCHEDULER%';
EXECUTE DBMS_AQADM.stop_QUEUE( queue_name => 'SYS.SCHEDULER$_EVENT_QUEUE');
EXECUTE DBMS_AQADM.DROP_QUEUE( queue_name => 'SYS.SCHEDULER$_EVENT_QUEUE');

再次查看：

SQL> show parameter name
NAME               TYPE	   VALUE
--------------- ---------- -----------------------------------
service_names     string   orcl

[oracle@rac1 trace]$ lsnrctl status
Service "orcl" has 1 instance(s).
  Instance "orcl1", status READY, has 1 handler(s) for this service...
Service "orclXDB" has 1 instance(s).
  Instance "orcl1", status READY, has 1 handler(s) for this service...
The command completed successfully