Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Subscribe_for_node_down_event

RE: Subscribe_for_node_down_event

From: William Wagman <wjwagman_at_ucdavis.edu>
Date: Mon, 21 May 2007 08:54:44 -0700
Message-ID: <FE043305B38A0F448F3924429D650C2A02A79DF0@VEXBE2.ex.ad3.ucdavis.edu>


Thanks for the suggestions. The answers highlight something I am beginning to think I don't understand fully and perhaps you can help. The question is. which home should the listener be running from. This is a recent installation and for the first time I have followed Oracle's suggestion and created a separate home for ASM. In previous installations ASM and RDBMS shared the same home but now I have three, CRS, ASM and RDBMS home. Things are configured now such that when the nodes are rebooted the listener is started out of the ASM home. My question is, should the listener start out of a particular home or does it matter?  

Also, the environment variable ORACLE_CONFIG_HOME is one I am not familiar with, what does that do?  

Thanks.  

Bill Wagman
Univ. of California at Davis
IET Campus Data Center
wjwagman_at_ucdavis.edu
(530) 754-6208  


From: Ghassan Salem [mailto:salem.ghassan_at_gmail.com] Sent: Sunday, May 20, 2007 1:38 AM
To: fairlie_r_at_yahoo.com
Cc: William Wagman; oracle-l
Subject: Re: Subscribe_for_node_down_event

Try renaming the ons.config file that's in the oracle_home (not the crs_home), and restart the listener, or before starting the listener set the ORACLE_CONFIG_HOME to the crs home.

rgds

On 5/19/07, fairlie rego <fairlie_r_at_yahoo.com> wrote:

        William,          

	Are you sure that your environments on both nodes point
	to the CRS_HOME and not the ORACLE_HOME. I know
	of issues where onsctl ping would work
	from the CRS_HOME but not from the ORACLE_HOME 
	 
	Also a trace of srvctl with SRVM_TRACE=DEBUG might
	help you to find out what exactly is causing the hang on node 1
	
	 
	Thanks 
	Fairlie
	
	
	William Wagman <wjwagman_at_ucdavis.edu> wrote:

		Fairlie,
		 
		Thanks for the response. Here is another piece to the
puzzle which to me just adds to the confusion. On node 1...                  

                $ srvctl status nodeapps -n brownshoe                  

                hangs

		$ onsctl ping
		Number of onsconfiguration retrieved, numcfg = 2 
		onscfg[0]
		   {node = brownshoe.ucdavis.edu, port = 6200}
		Adding remote host brownshoe.ucdavis.edu:6200
		onscfg[1]
		   {node = tenspeed.ucdavis.edu, port = 6200}
		Adding remote host tenspeed.ucdavis.edu:6200
		ons is not running ...
		$
		 
		on node 2 I see...
		 
		$ srvctl status nodeapps -n tenspeed
		VIP is running on node: tenspeed
		GSD is running on node: tenspeed
		Listener is not running on node: tenspeed 
		ONS daemon is running on node: tenspeed
		$ onsctl ping
		Number of onsconfiguration retrieved, numcfg = 2
		onscfg[0]
		   {node = brownshoe.ucdavis.edu, port = 6200}
		Adding remote host brownshoe.ucdavis.edu:6200
		onscfg[1]
		   {node = tenspeed.ucdavis.edu, port = 6200}
		Adding remote host tenspeed.ucdavis.edu:6200
		ons is not running ...
		$ 
		 
		Why does node 1 hang and why does srvctl show ons
running but onsctl ping says no. I don't understand the discrepancy.                  

                Thanks.                  

		Bill Wagman
		Univ. of California at Davis
		IET Campus Data Center
		wjwagman_at_ucdavis.edu
		(530) 754-6208 
		 

________________________________

		From: fairlie rego [mailto: fairlie_r_at_yahoo.com

<mailto:fairlie_r_at_yahoo.com> ]
Sent: Friday, May 18, 2007 4:14 PM To: William Wagman Cc: oracle-l Subject: Re: Subscribe_for_node_down_event William, In brief this is all a part of the FAN framework where a listener registers with ONS. You shouldn't have this problem if you set SUBSCRIBE_FOR_NODE_DOWN_EVENT_<listener> to OFF which should disable ONS subscription If you still have an issue can you paste/send the output of onsctl debug Thanks Fairlie William Wagman < wjwagman_at_ucdavis.edu

<mailto:wjwagman_at_ucdavis.edu> > wrote:

                        Greetings,                         

                        On a two node RAC cluster, Oracle 10.2.0.3.0 Enterprise Edition on RHEL4

                        64-bit using CRS.                         

                        In my listener.log I see numerous occurrences of the message...

                        WARNING: Subscription for node down event still pending

                        In searching for the web I find it commonly suggested that the

                        listener.ora file by updated to include the parameter

                        SUBSCRIBE_FOR_NODE_DOWN_EVENT_LSNR=                                                  This is where I get lost. I am unable to find any documentation as to

                        what constitutes a node down event and what the ramifications are. What

                        is a node down event?                         

                        I have searched the Oracle docs for this parameter, nothing is found.

                        Searching for listener.ora refers me to the net services guide but I am

                        unable to find specific syntax for this parameter, it doesn't even

                        appear in the index. Searching also refers me to the configuring the

                        listener.ora in the various clusterware guides but again, no syntax for

                        the parameter is given nor is it listed in the index. I'm stumped.                         

                        What we are seeing is that our application is using web logic and it

                        appears that after a while connections and querying start to slow down

                        and restarting the listener temporarily appears to resolve the issue.

                        Some of the notes about the warning message indicates that the listener

                        encountering some memory issues but I really can't find any explanations

                        of this anywhere.                         

                        If anyone can shed any light on this or point me to some documentation

                        on what this means or how to troubleshoot this problem I would be very

                        grateful.                         

                        Thanks.                         

			Bill Wagman
			Univ. of California at Davis
			IET Campus Data Center
			wjwagman_at_ucdavis.edu 
			(530) 754-6208
			--
			http://www.freelists.org/webpage/oracle-l
			
			
			




		Fairlie Rego
		Senior Oracle Consultant
		http://el-caro.blogspot.com/
		M: +61 402 792 405
		 
________________________________

		Yahoo! oneSearch: Finally, mobile search that gives
answers
<http://us.rd.yahoo.com/evt=48252/*http://mobile.yahoo.com/mobileweb/one
search?refer=1ONXIC> , not web links.
	Fairlie Rego
	Senior Oracle Consultant
	http://el-caro.blogspot.com/
	M: +61 402 792 405
	 
	

________________________________

	Don't be flakey. Get Yahoo! Mail for Mobile

<http://us.rd.yahoo.com/evt=43909/*http://mobile.yahoo.com/mail> and
always stay connected

<http://us.rd.yahoo.com/evt=43909/*http://mobile.yahoo.com/mail> to
friends.         
--
http://www.freelists.org/webpage/oracle-l
Received on Mon May 21 2007 - 10:54:44 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US