Results 1 to 1 of 1
  1. #1
    Join Date
    Apr 2012
    Posts
    1

    Question Unanswered: RAC - Listener Dont take the remote vip

    hello I have the following problem on a 10.2.0.4 Oracle on AIX 1.6

    I have 2 RAC nodes as the node # 2 goes down, the VIP migrated correctly to the node # 1, but the listener # 1 do not see

    the change, and just resolve to the local ip.

    The same applies in the reverse case, when it drops the node # 1.

    the configuration is correct, according to the documentation, but can not find a reasonable answer.

    IP node # 1
    192.68.60.11
    VIP 192.68.60.13

    IP node # 2
    192.168.60.12
    VIP 192.168.60.14

    Some idea of ​​the failure?, How I can solve it?

    thank you very much

    Below I write as I detect the problem:


    scm1or01:/cots/oracle/app/oracle/product/10.2.0/db_1/network/admin> lsnrctl status

    LSNRCTL for IBM/AIX RISC System/6000: Version 10.2.0.4.0 - Production on 11-APR-2012 19:56:46

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

    Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
    STATUS of the LISTENER
    ------------------------
    Alias LISTENER_SCM1OR01
    Version TNSLSNR for IBM/AIX RISC System/6000: Version 10.2.0.4.0 - Production
    Start Date 11-APR-2012 16:50:19
    Uptime 0 days 3 hr. 6 min. 26 sec
    Trace Level off
    Security ON: Local OS Authentication
    SNMP ON
    Listener Parameter File /cots/oracle/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
    Listener Log File /cots/oracle/app/oracle/product/10.2.0/db_1/network/log/listener_scm1or01.log
    Listening Endpoints Summary...
    (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168. 60.13)(PORT=1521)))
    (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168. 60.11)(PORT=1521)))
    Services Summary...



    scm1or01:/cots/oracle/app/oracle/product/10.2.0/db_1/network/admin> ifconfig -a
    en7: flags=e080863,80<UP,BROADCAST,NOTRAILERS,RUNNING,S IMPLEX,MULTICAST,GROUPRT,64BIT,CHAIN>
    inet 10.1.1.1 netmask 0xffffff00 broadcast 10.1.1.255
    tcp_sendspace 131072 tcp_recvspace 65536 rfc1323 0
    en6: flags=e080863,80<UP,BROADCAST,NOTRAILERS,RUNNING,S IMPLEX,MULTICAST,GROUPRT,64BIT,CHAIN>
    inet 192.168.60.11 netmask 0xffffff00 broadcast 192.168.60.255
    inet 192.168.60.13 netmask 0xffffff00 broadcast 192.168.60.255
    inet 192.168.60.14 netmask 0xffffff00 broadcast 192.168.60.255
    tcp_sendspace 131072 tcp_recvspace 65536 rfc1323 0
    lo0: flags=e08084b,c0<UP,BROADCAST,LOOPBACK,RUNNING,SIM PLEX,MULTICAST,GROUPRT,64BIT,LARGESEND,CHAIN>
    inet 127.0.0.1 netmask 0xff000000 broadcast 127.255.255.255
    inet6 ::1%1/0
    tcp_sendspace 131072 tcp_recvspace 131072 rfc1323 1

    listener.ora #1 (idem listener.ora #2, except IPs)

    # listener.ora Network Configuration File: /cots/oracle/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
    # Generated by Oracle configuration tools.

    SID_LIST_LISTENER_SCM1OR01 =
    (SID_LIST =
    (SID_DESC =
    (SID_NAME = xa21s)
    (ORACLE_HOME = /cots/oracle/app/oracle/product/10.2.0/db_1)
    (GLOBAL_DBNAME = xa21bcs_DGMGRL)
    )
    (SID_DESC =
    (SID_NAME = xa211)
    (ORACLE_HOME = /cots/oracle/app/oracle/product/10.2.0/db_1)
    (GLOBAL_DBNAME = xa21_DGMGRL)
    )
    (SID_DESC =
    (SID_NAME = xa212)
    (ORACLE_HOME = /cots/oracle/app/oracle/product/10.2.0/db_1)
    (GLOBAL_DBNAME = xa21_DGMGRL)
    )
    (SID_DESC =
    (SID_NAME = xa211s)
    (ORACLE_HOME = /cots/oracle/app/oracle/product/10.2.0/db_1)
    (GLOBAL_DBNAME = xa21bcs_DGMGRL)
    )
    (SID_DESC =
    (SID_NAME = xa212s)
    (ORACLE_HOME = /cots/oracle/app/oracle/product/10.2.0/db_1)
    (GLOBAL_DBNAME = xa21bcs_DGMGRL)
    )
    (SID_DESC =
    (SID_NAME = PLSExtProc)
    (ORACLE_HOME = /cots/oracle/app/oracle/product/10.2.0/db_1)
    (PROGRAM = extproc)
    )
    )

    # Listener.ora for a RAC PCS/RAC BCS system

    LISTENER_SCM1OR01 =
    (DESCRIPTION_LIST =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = scm1or01-vip)(PORT = 1521))
    )
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = scm1or01)(PORT = 1521))
    )
    )


    Thanks in advenced!
    Last edited by carlino70; 04-11-12 at 17:31.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •