Re: RAC VIP Node

  • From: Dan Norris <dannorris@xxxxxxxxxxxxx>
  • To: smishra_97@xxxxxxxxx
  • Date: Fri, 30 May 2008 15:27:37 -0500

Looks like this listener is binding to "HOST=node1" instead of "HOST=node1-vip" as it should be. That wouldn't be causing the issue you reported, but should be noted anyway.

Tell me the IP addresses you're using for node1, node2 and node1-vip and node2-vip. You can also provide "crs_stat -p ora.node1.vip" and the same for ora.node2.vip to help debug. Sounds like maybe you're not using the right IP ranges?

It looks to me like the listener isn't the problem, just the symptom. The listener depends on the VIP and it seems that your VIP won't come online from the errors below. Hopefully, having the information above will help us (and maybe you) identify the reason for the problem.

Dan

Sanjay Mishra wrote:
$lsnrctl start listener
LSNRCTL for IBM/AIX RISC System/6000: Version 10.2.0.3.0 - Production on 30-MAY-2008 10:02:32
Copyright (c) 1991, 2006, Oracle.  All rights reserved.
Starting /u01/app/oracle/product/rdbms/10.2/bin/tnslsnr: please wait...
TNSLSNR for IBM/AIX RISC System/6000: Version 10.2.0.3.0 - Production
System parameter file is /u01/app/oracle/product/rdbms/10.2/network/admin/listener.ora
Log messages written to /u01/app/oracle/product/rdbms/10.2/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=node1)(PORT=1521)))
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias                     listener
Version                   TNSLSNR for IBM/AIX RISC System/6000: Version 10.2.0.3.0 - Production
Start Date                30-MAY-2008 10:02:32
Uptime                    0 days 0 hr. 0 min. 0 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      ON
Listener Parameter File   /u01/app/oracle/product/rdbms/10.2/network/admin/listener.ora
Listener Log File         /u01/app/oracle/product/rdbms/10.2/network/log/listener.log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=node1)(PORT=1521)))
The listener supports no services
The command completed successfully


----- Original Message ----
From: Andrew Kerber <andrew.kerber@xxxxxxxxx>
To: Sanjay Mishra <smishra_97@xxxxxxxxx>
Cc: oracle-l@xxxxxxxxxxxxx
Sent: Friday, May 30, 2008 9:33:53 AM
Subject: Re: RAC VIP Node

When you tried lsnrctl start listener on node 1, what did that say?


On Fri, May 30, 2008 at 8:02 AM, Sanjay Mishra <smishra_97@xxxxxxxxx> wrote:

Andrew

 

This Log portion is from Node1 crsd.log. I did tried to mount the Listener on Node as shown below

 

/home/oracle$srvctl start listener -n Node1


ode1:ora.node1.vip:Invalid parameters, or failed to bring up VIP (host=node1)
node1:ora.node1.vip:Invalid parameters, or failed to bring up VIP (host=node1)
CRS-0215: Could not start resource 'ora.node1.LISTENER_NODE1.lsnr'.


----- Original Message ----
From: Andrew Kerber <andrew.kerber@xxxxxxxxx>
Sent: Friday, May 30, 2008 8:55:31 AM
Subject: Re: RAC VIP Node

Is this in the crsd.log on node 1 or node 2?

Can you start the listener manually on node 1?  We need to find the true error message, and Oracle manages to hide those pretty thoroughly in RAC I have noticed.

On Fri, May 30, 2008 at 7:43 AM, Sanjay Mishra <smishra_97@xxxxxxxxx> wrote:
Andrew
 
Here is what is coming in crsd.log
2008-05-29 23:36:18.965: [  CRSRES][11585]32startRunnable: setting CLI values
2008-05-29 23:36:18.973: [  CRSRES][11585]32Attempting to start `ora.node1.gsd` on member `node1`
2008-05-29 23:36:20.008: [  CRSRES][11585]32Start of `ora.node1.gsd` on member `node1` succeeded.
2008-05-29 23:36:20.180: [  CRSRES][11588]32startRunnable: setting CLI values
2008-05-29 23:36:20.185: [  CRSRES][11588]32Attempting to start `ora.node1.vip` on member `node1`
2008-05-29 23:36:27.238: [  CRSAPP][11588]32StartResource error for ora.node1.vip error code = 1
2008-05-29 23:36:27.718: [  CRSRES][11588]32Start of `ora.node1.vip` on member `node1` failed.
2008-05-29 23:36:27.745: [  CRSRES][11588]32Attempting to start `ora.node1.vip` on member `node2`
2008-05-29 23:36:31.162: [  CRSRES][11588]32Start of `ora.node1.vip` on member `node2` succeeded.
2008-05-29 23:36:31.317: [  CRSRES][11596]32startRunnable: setting CLI values
2008-05-29 23:36:31.325: [  CRSRES][11596]32Attempting to start `ora.node1.ons` on member `node1`
2008-05-29 23:36:33.384: [  CRSRES][11596]32Start of `ora.node1.ons` on member `node1` succeeded.
2008-05-29 23:36:33.568: [  CRSRES][11599]32StopResource: setting CLI values
2008-05-29 23:36:33.637: [  CRSRES][11599]32Attempting to stop `ora.node1.vip` on member `node2`
2008-05-29 23:36:34.001: [  CRSRES][11599]32Stop of `ora.node1.vip` on member `node2` succeeded.
2008-05-29 23:36:34.004: [  CRSRES][11599]32startRunnable: setting CLI values
2008-05-29 23:36:34.005: [  CRSRES][11599]32Attempting to start `ora.node1.vip` on member `node1`
2008-05-29 23:36:41.055: [  CRSAPP][11599]32StartResource error for ora.node1.vip error code = 1
2008-05-29 23:36:41.485: [  CRSRES][11599]32Start of `ora.node1.vip` on member `node1` failed.
2008-05-29 23:36:41.496: [  CRSRES][11599]32node2 : CRS-1019: Resource ora.node1.LISTENER_node1.lsnr (application) cannot run on node2

2008-05-29 23:36:41.535: [  CRSRES][11599]32Attempting to start `ora.node1.vip` on member `node2`
I eben tried to start the Vip Resource for Node1 usinf crs_start command but it faild and started on Node2. It is first attempted on Node1 but then failed and started on Node2
 
Nothng in Listener.log

----- Original Message ----
From: Andrew Kerber <andrew.kerber@xxxxxxxxx>
To: smishra_97@xxxxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx
Sent: Friday, May 30, 2008 8:28:23 AM
Subject: Re: RAC VIP Node

Is there anything in the listener log?  Anything else in the crs logs?

On Thu, May 29, 2008 at 10:17 PM, Sanjay Mishra <smishra_97@xxxxxxxxx> wrote:
I installed Clusterware and patched to 10203. Installed RAC software for ASM and RDBMS Home and Patched to 10203. Now I restarted the Cluster but strange thing is that VIP of Node1 is always coming on Node2
 
/u01/app/crs/10.2/bin$srvctl start nodeapps -n Node1
Node1:ora.node1.vip:Invalid parameters, or failed to bring up VIP (host=node1)
Node1:ora.node1.vip:Invalid parameters, or failed to bring up VIP (host=node1)
CRS-0215: Could not start resource 'ora.node1.LISTENER.NODE1.lsnr'.
 
I even modify using
srvctl modify nodeapps -n node1.....
I even tried to add again using srvctl add nodeapps
 
Still no luck
 
Any ideas  or suggestion
 
TIA
Sanjay




--
Andrew W. Kerber

'If at first you dont succeed, dont take up skydiving.'




--
Andrew W. Kerber

'If at first you dont succeed, dont take up skydiving.'




--
Andrew W. Kerber

'If at first you dont succeed, dont take up skydiving.'

-- //www.freelists.org/webpage/oracle-l

Other related posts: