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: Ghassan Salem <salem.ghassan_at_gmail.com>
Date: Sun, 20 May 2007 10:37:40 +0200
Message-ID: <411d50f60705200137j62ff765cqec2ce3ccbbe926a7@mail.gmail.com>


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]
> *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>* 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/onesearch?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 Sun May 20 2007 - 03:37:40 CDT

Original text of this message

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