RE: listener on windows

Andrew,  

I ran into something similar in Unix. The VIP got failed over to the first node due to an error. If this is the similar condition then verify using ipconfig on each node that the VIPs are plumbed on the correct node. I haven't worked on Windows but I would think that the crs_stat or equivalent command will tell you whether and where the resources are online. Or it could be the case of rac2-vip not in the ../etc/hosts file in node 2  

-Krish  

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Andrew Kerber
Sent: Sunday, December 16, 2007 2:54 PM
To: oracle-l
Subject: listener on windows  

I have done a home rac installation in windows 2003. clusterware installed, and importantly vip ran correctly without error. HOwever, I cannot get the listener to start on the second node when I have it set up with this configuration:  

LISTENER_RAC2 =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = rac2-vip)(PORT = 1521)(IP = FIRST))
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.12.1.120)(PORT = 1521)(IP =
FIRST))
    )
  )  

If I remove the line wiht rac2-vip it will start. THe listener on the first node starts just fine with its corresponding line.  

I can ping the virtual ip to and from each node. I tried deleting the service and then starting the listener. Made no difference. Here is the error message. This doesnt have it, but usually there is something about listener error 1060 also:  

C:\Documents and Settings\Administrator>lsnrctl start listener_rac2

LSNRCTL for 32-bit Windows: Version 11.1.0.6.0 - Production on 16-DEC-2007 15:48
:10

Copyright (c) 1991, 2007, Oracle. All rights reserved.

Starting tnslsnr: please wait...

TNSLSNR for 32-bit Windows: Version 11.1.0.6.0 - Production System parameter file is
C:\app\Administrator\product\11.1.0\db_1\network\admin\ listener.ora
Log messages written to
c:\app\administrator\diag\tnslsnr\rac2\listener_rac2\ale rt\log.xml
Listening on:
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1521 ipc)))
Error listening on:
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=rac2-vip)(PORT=152 1)(IP=FIRST)))
TNS-12545: Connect failed because target host or object does not exist  TNS-12560: TNS:protocol adapter error
  TNS-00515: Connect failed because target host or object does not exist    32-bit Windows Error: 49: Unknown error

Listener failed to start. See the error message(s) above...

Ill keep working, but does anyone have ideas? Thanks...

-- 
Andrew W. Kerber

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



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