清理类似SYS$SYS.KUPC$C_2_20230411115109_0服务
惜分飞发表于 2023-04-11 05:33:15
联系：手机/微信(+86 17813235971) QQ(107644445)
标题：清理类似SYS$SYS.KUPC$C_2_20230411115109_0服务
作者：惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]
查看监听发现大量类似SYS$SYS.KUPC$C_2_20230411115109_0 服务
[grid@dbserver1 ~]$ lsnrctl status LISTENER_SCAN1 LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 11-APR-2023 13:05:47 Copyright (c) 1991, 2022, Oracle. All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN1))) STATUS of the LISTENER ------------------------ Alias LISTENER_SCAN1 Version TNSLSNR for Linux: Version 19.0.0.0.0 - Production Start Date 07-SEP-2022 23:57:17 Uptime 215 days 13 hr. 8 min. 29 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Parameter File /u01/app/19c/grid/network/admin/listener.ora Listener Log File /u01/app/19c/grid/network/log/listener_scan1.log Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER_SCAN1))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.9.9)(PORT=11521))) Services Summary... Service "SYS$SYS.KUPC$C_2_20230411115109_0.XFF" has 1 instance(s). Instance "elcdb2", status READY, has 1 handler(s) for this service... Service "SYS$SYS.KUPC$S_2_20230411115109_0.XFF" has 1 instance(s). Instance "elcdb2", status READY, has 1 handler(s) for this service... Service "elcdb" has 2 instance(s). Instance "elcdb1", status READY, has 1 handler(s) for this service... Instance "elcdb2", status READY, has 1 handler(s) for this service... Service "elcdbXDB" has 2 instance(s). Instance "elcdb1", status READY, has 1 handler(s) for this service... Instance "elcdb2", status READY, has 1 handler(s) for this service...
清理这种服务
SQL> select 'exec DBMS_AQADM.STOP_QUEUE(queue_name=>'''||name||''');' as reservice from v$services where name like '%KUPC%'; RESERVICE -------------------------------------------------------------------------------- exec DBMS_AQADM.STOP_QUEUE(queue_name=>'SYS.KUPC$C_2_20230411115109_0'); exec DBMS_AQADM.STOP_QUEUE(queue_name=>'SYS.KUPC$S_2_20230411115109_0'); SQL> exec DBMS_AQADM.STOP_QUEUE(queue_name=>'SYS.KUPC$C_2_20230411115109_0'); exec DBMS_AQADM.STOP_QUEUE(queue_name=>'SYS.KUPC$S_2_20230411115109_0'); PL/SQL procedure successfully completed. SQL> PL/SQL procedure successfully completed. SQL> SQL> select 'exec DBMS_AQADM.DROP_QUEUE(queue_name=>'''||name||''');' as reservice from v$services where name like '%KUPC%'; RESERVICE -------------------------------------------------------------------------------- exec DBMS_AQADM.DROP_QUEUE(queue_name=>'SYS.KUPC$C_2_20230411115109_0'); exec DBMS_AQADM.DROP_QUEUE(queue_name=>'SYS.KUPC$S_2_20230411115109_0'); SQL> SQL> exec DBMS_AQADM.DROP_QUEUE(queue_name=>'SYS.KUPC$C_2_20230411115109_0'); exec DBMS_AQADM.DROP_QUEUE(queue_name=>'SYS.KUPC$S_2_20230411115109_0'); PL/SQL procedure successfully completed. SQL> PL/SQL procedure successfully completed. SQL>
再次查看服务确认已经被清理
[grid@dbserver1 ~]$ lsnrctl status LISTENER_SCAN1 LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 11-APR-2023 13:08:37 Copyright (c) 1991, 2022, Oracle. All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN1))) STATUS of the LISTENER ------------------------ Alias LISTENER_SCAN1 Version TNSLSNR for Linux: Version 19.0.0.0.0 - Production Start Date 07-SEP-2022 23:57:17 Uptime 215 days 13 hr. 11 min. 19 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Parameter File /u01/app/19c/grid/network/admin/listener.ora Listener Log File /u01/app/19c/grid/network/log/listener_scan1.log Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER_SCAN1))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.9.9)(PORT=11521))) Services Summary... Service "elcdb" has 2 instance(s). Instance "elcdb1", status READY, has 1 handler(s) for this service... Instance "elcdb2", status READY, has 1 handler(s) for this service... Service "elcdbXDB" has 2 instance(s). Instance "elcdb1", status READY, has 1 handler(s) for this service... Instance "elcdb2", status READY, has 1 handler(s) for this service... The command completed successfully [grid@dbserver1 ~]$