Home -> Mailing Lists -> Oracle-L -> Re: RAC VIP Node

Re: RAC VIP Node

From: Dan Norris <dannorris_at_dannorris.com>
Date: Fri, 30 May 2008 15:27:37 -0500
Message-ID: <48406339.9010807@dannorris.com> 




  


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@gmail.com>

To: Sanjay Mishra <smishra_97@yahoo.com>

Cc: oracle-l@freelists.org

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@yahoo.com>
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@gmail.com>

    

    
To: Sanjay Mishra <smishra_97@yahoo.com>

Cc: oracle-l@freelists.org

    

    

    
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@yahoo.com>
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@gmail.com>

To: smishra_97@yahoo.com

Cc: oracle-l@freelists.org

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@yahoo.com>
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.'

  

  





--
http://www.freelists.org/webpage/oracle-l
Received on Fri May 30 2008 - 15:27:37 CDT












Original text of this message