{"id":717,"date":"2010-06-06T08:37:47","date_gmt":"2010-06-06T13:37:47","guid":{"rendered":"http:\/\/appcrawler.com\/wordpress\/?p=717"},"modified":"2011-07-06T10:12:49","modified_gmt":"2011-07-06T15:12:49","slug":"how-to-unregister-a-service-from-a-listener","status":"publish","type":"post","link":"http:\/\/appcrawler.com\/wordpress\/2010\/06\/06\/how-to-unregister-a-service-from-a-listener\/","title":{"rendered":"How to \u201cunregister\u201d a service from a listener"},"content":{"rendered":"<p>If a service is registered with your listener outside of the clusterware, you can unregister it with the following call:<\/p>\n<pre lang=\"sql\" line=\"1\">\r\ndbms_service.stop_service(service_name,instance_name)\r\n<\/pre>\n<p>I verified that this will not disconnect existing sessions in the instance on which the service is being stopped.<\/p>\n<p>I did this by performing the following steps:<\/p>\n<p>create 100 sessions to service and verify some are on the instance on which you want to stop the service<\/p>\n<pre lang=\"sql\" line=\"1\">\r\nexec dbms_service.stop_service(service_name,instance_name)\r\nselect count(*),inst_id from gv$session where service_name = '&service_name' group by inst_id;\r\n<\/pre>\n<p>You will see the sessions are still on the instance on which you stopped the service.\u00a0 However, if you issue the following:<\/p>\n<pre lang=\"text\" line=\"1\">\r\nlsnrctl service listener_name\r\n<\/pre>\n<p>&#8230;you will see the service no longer shows up in the list.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>If a service is registered with your listener outside of the clusterware, you can unregister it with the following call: dbms_service.stop_service(service_name,instance_name) I verified that this will not disconnect existing sessions in the instance on which the service is being stopped.&hellip;<\/p>\n<p class=\"more-link-p\"><a class=\"more-link\" href=\"http:\/\/appcrawler.com\/wordpress\/2010\/06\/06\/how-to-unregister-a-service-from-a-listener\/\">Read more &rarr;<\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_mi_skip_tracking":false,"footnotes":""},"categories":[19,22],"tags":[],"_links":{"self":[{"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/posts\/717"}],"collection":[{"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/comments?post=717"}],"version-history":[{"count":8,"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/posts\/717\/revisions"}],"predecessor-version":[{"id":958,"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/posts\/717\/revisions\/958"}],"wp:attachment":[{"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/media?parent=717"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/categories?post=717"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/appcrawler.com\/wordpress\/wp-json\/wp\/v2\/tags?post=717"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}