Return-Path: X-Original-To: oracle-l@orafaq.com Delivered-To: oracle-l@orafaq.com Received: from puck1183.startdedicated.com (localhost [127.0.0.1]) by puck1183.startdedicated.com (Postfix) with ESMTP id 486881960268 for ; Fri, 6 Jun 2014 22:12:30 +0200 (CEST) Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by puck1183.startdedicated.com (Postfix) with ESMTP for ; Fri, 6 Jun 2014 22:12:30 +0200 (CEST) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 55E8A2C67D; Fri, 6 Jun 2014 16:12:29 -0400 (EDT) X-Virus-Scanned: Debian amavisd-new at turing.freelists.org Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 2qtRwvd+GzMS; Fri, 6 Jun 2014 16:12:29 -0400 (EDT) Received: from turing.freelists.org (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 45EAE2C664; Fri, 6 Jun 2014 16:11:48 -0400 (EDT) Received: with ECARTIS (v1.0.0; list oracle-l); Fri, 06 Jun 2014 16:11:07 -0400 (EDT) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 170F02C5F0 for ; Fri, 6 Jun 2014 16:11:07 -0400 (EDT) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 8ETc0yorPMNt for ; Fri, 6 Jun 2014 16:11:07 -0400 (EDT) Received: from aserp1040.oracle.com (aserp1040.oracle.com [141.146.126.69]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id B1B1C2C5D1 for ; Fri, 6 Jun 2014 16:10:40 -0400 (EDT) Received: from ucsinet22.oracle.com (ucsinet22.oracle.com [156.151.31.94]) by aserp1040.oracle.com (Sentrion-MTA-4.3.2/Sentrion-MTA-4.3.2) with ESMTP id s56KAch0027432 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=OK); Fri, 6 Jun 2014 20:10:39 GMT Received: from userz7022.oracle.com (userz7022.oracle.com [156.151.31.86]) by ucsinet22.oracle.com (8.14.5+Sun/8.14.5) with ESMTP id s56KAcCD014790 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO); Fri, 6 Jun 2014 20:10:38 GMT Received: from abhmp0015.oracle.com (abhmp0015.oracle.com [141.146.116.21]) by userz7022.oracle.com (8.14.5+Sun/8.14.4) with ESMTP id s56KAaFv014723; Fri, 6 Jun 2014 20:10:37 GMT Received: from [130.35.170.141] (/130.35.170.141) by default (Oracle Beehive Gateway v4.0) with ESMTP ; Fri, 06 Jun 2014 13:10:36 -0700 Message-ID: <53922032.3090002@oracle.com> Date: Fri, 06 Jun 2014 13:10:26 -0700 From: Markus Michalewicz Organization: Oracle Corporation User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:24.0) Gecko/20100101 Thunderbird/24.5.0 MIME-Version: 1.0 To: stalinsk@gmail.com CC: oracle-l@freelists.org Subject: Fwd: oracle-l Digest V11 #161 - here: Scan listener monitoring References: <20140606050524.DD1282BBFA@turing.freelists.org> In-Reply-To: <20140606050524.DD1282BBFA@turing.freelists.org> Content-Type: multipart/alternative; boundary="------------010704020007040306070306" X-Source-IP: ucsinet22.oracle.com [156.151.31.94] X-archive-position: 54899 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: markus.michalewicz@oracle.com Precedence: normal Reply-To: markus.michalewicz@oracle.com List-help: List-unsubscribe: List-software: Ecartis version 1.0.0 List-Id: oracle-l X-List-ID: oracle-l List-subscribe: List-owner: List-post: List-archive: X-list: oracle-l --------------010704020007040306070306 Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit Hello Stalin, Regarding BUG 12659561 - this is a BUG and should be fixed by applying the respective patch. For more information see the following MOS note (Doc ID 12659561.8) - Bug 12659561 - after scan listener failover, database instance might not register to the scan listener SCAN listeners are already monitored as part of the Oracle Clusterware stack, which is why they are "failed over" as required. You trying to capture such a failover to perhaps apply the manual workaround mentioned in the note will require you to tail logs or implement an additional monitoring for the SCAN listener(s). As you noticed, the FAN events do not include listener events, as they are meant for clients. The client uses a service registered with the listener to connect to the DB. Hence, mainly service events will be sent to the client. If you ask me, I recommend fixing the BUG. BUG fixes are available in many patches and you can request an additional backport as required. Hope that helps. Thanks, good luck and have a great weekend, Markus Markus Michalewicz | Director of Product Management Oracle Real Application Clusters (RAC) Phone: +16505065444 | Mobile: +16502937832 500 Oracle Parkway M/S 4OP840 | Redwood Shores, CA 94065 -------- Original Message -------- Subject: oracle-l Digest V11 #161 Date: Fri, 06 Jun 2014 01:05:24 -0400 (EDT) From: FreeLists Mailing List Manager Reply-To: oracle-l@freelists.org To: oracle-l digest users oracle-l Digest Thu, 05 Jun 2014 Volume: 11 Issue: 161 In This Issue: Re: EM 12c best practise!! RE: Reads from Control file under "IOStat by Filetype summar Re: Reads from Control file under "IOStat by Filetype summar Re: Reads from Control file under "IOStat by Filetype summar Re: thanks to whomever made the suggestion to include anchor Oracle VM usage for database servers Re: Oracle VM usage for database servers Re: Oracle VM usage for database servers Used-Mem in execution plans Encryption over Database Link Re: Encryption over Database Link JDK 7 Garbage Collector with Oracle FMW 11g SOA Suite Re: Encryption over Database Link Re: Encryption over Database Link Re: Encryption over Database Link RE: Encryption over Database Link RE: Encryption over Database Link Re: ORA-16000: database open for read-only access DBA_AUDIT_SESSION shows a failed login for DBSNMP every 5 mi spfile used in RAC 10.2.0.4 Re: Encryption over Database Link Re: spfile used in RAC 10.2.0.4 Re: spfile used in RAC 10.2.0.4 Re: DB12c in Production? Re: spfile used in RAC 10.2.0.4 Re: spfile used in RAC 10.2.0.4 RE: spfile used in RAC 10.2.0.4 *Scan listener monitoring* Re: spfile used in RAC 10.2.0.4 Re: spfile used in RAC 10.2.0.4 Re: spfile used in RAC 10.2.0.4 OT: What about creating a repository of scripts of oracle-l OT: So, I also direct the University Chorus of the Upper Val Re: Used-Mem in execution plans ---------------------------------------------------------------------- .... ------------------------------ From: Stalin Subbiah Subject: Scan listener monitoring Date: Thu, 5 Jun 2014 15:29:21 -0700 We had an interesting problem few days ago in our production environment where one of the scan listener wasn't showing all the instances/services registered to it. Other 2 scans were fine. We did have scan listener fail-over to other active nodes when node reboots were performed. Apparently, we had hit "Bug 12659561 after scan listener failover, database instance might not register to the scan listener". I was wondering how to monitor scan listener fail-over / relocate to another active nodes, whenever that event happens. I looked up FAN user callouts which we use to monitor services up/down events but don't see anything for scan vip nor listener. Any ideas? Thanks, Stalin 11.2.0.2.6, RH x86_64 ------------------------------ End of oracle-l Digest V11 #161 ******************************* --------------010704020007040306070306 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: 8bit Hello Stalin,

    Regarding BUG 12659561 - this is a BUG and should be fixed by applying the respective patch.

For more information see the following MOS note (Doc ID 12659561.8) - Bug 12659561 - after scan listener failover, database instance might not register to the scan listener

SCAN listeners are already monitored as part of the Oracle Clusterware stack, which is why they are "failed over" as required. You trying to capture such a failover to perhaps apply the manual workaround mentioned in the note will require you to tail logs or implement an additional monitoring for the SCAN listener(s). As you noticed, the FAN events do not include listener events, as they are meant for clients. The client uses a service registered with the listener to connect to the DB. Hence, mainly service events will be sent to the client.

If you ask me, I recommend fixing the BUG. BUG fixes are available in many patches and you can request an additional backport as required.

Hope that helps. Thanks, good luck and have a great weekend,
      Markus

Markus Michalewicz | Director of Product Management
Oracle Real Application Clusters (RAC)
Phone: +16505065444 | Mobile: +16502937832
500 Oracle Parkway M/S 4OP840 | Redwood Shores, CA 94065



-------- Original Message --------
Subject: oracle-l Digest V11 #161
Date: Fri, 06 Jun 2014 01:05:24 -0400 (EDT)
From: FreeLists Mailing List Manager <ecartis@freelists.org>
Reply-To: oracle-l@freelists.org
To: oracle-l digest users <oracle-l@freelists.org> 


oracle-l Digest	Thu, 05 Jun 2014	Volume: 11  Issue: 161

In This Issue:
		Re: EM 12c best practise!!
		RE: Reads from Control file under "IOStat by Filetype summar
		Re: Reads from Control file under "IOStat by Filetype summar
		Re: Reads from Control file under "IOStat by Filetype summar
		Re: thanks to whomever made the suggestion to include anchor
		Oracle VM usage for database servers
		Re: Oracle VM usage for database servers
		Re: Oracle VM usage for database servers
		Used-Mem in execution plans
		Encryption over Database Link
		Re: Encryption over Database Link
		JDK 7 Garbage Collector with Oracle FMW 11g SOA Suite
		Re: Encryption over Database Link
		Re: Encryption over Database Link
		Re: Encryption over Database Link
		RE: Encryption over Database Link
		RE: Encryption over Database Link
		Re: ORA-16000: database open for read-only access
		DBA_AUDIT_SESSION shows a failed login for DBSNMP every 5 mi
		spfile used in RAC 10.2.0.4
		Re: Encryption over Database Link
		Re: spfile used in RAC 10.2.0.4
		Re: spfile used in RAC 10.2.0.4
		Re: DB12c in Production?
		Re: spfile used in RAC 10.2.0.4
		Re: spfile used in RAC 10.2.0.4
		RE: spfile used in RAC 10.2.0.4
		Scan listener monitoring
		Re: spfile used in RAC 10.2.0.4
		Re: spfile used in RAC 10.2.0.4
		Re: spfile used in RAC 10.2.0.4
		OT: What about creating a repository of scripts of oracle-l
		OT: So, I also direct the University Chorus of the Upper Val
		Re: Used-Mem in execution plans

----------------------------------------------------------------------

....

------------------------------

From: Stalin Subbiah <stalinsk@gmail.com>
Subject: Scan listener monitoring
Date: Thu, 5 Jun 2014 15:29:21 -0700

We had an interesting problem few days ago in our production environment where one of the scan listener wasn't showing all the instances/services registered to it. Other 2 scans were fine. We did have scan listener fail-over to other active nodes when node reboots were performed.
Apparently, we had hit "Bug 12659561  after scan listener failover, database instance might not register to the scan listener".

I was wondering how to monitor scan listener fail-over / relocate to another active nodes, whenever that event happens. I looked up FAN user callouts which we use to monitor services up/down events but don't see anything for scan vip nor listener.

Any ideas?

Thanks,
Stalin
11.2.0.2.6, RH x86_64



------------------------------

End of oracle-l Digest V11 #161
*******************************


--------------010704020007040306070306-- -- http://www.freelists.org/webpage/oracle-l