RAC ( Listener not starting )
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: RAC ( Listener not starting )

Hybrid View

  1. #1
    Join Date
    Nov 2002
    Posts
    170

    RAC ( Listener not starting )

    I have a two node RAC cluster and on DB. I created the second DB and got an error "FAILED TO RETRIEVE NETWORK LISTENER RESOURCES FOR REAL APPLICATION CLUSTER HIGH AVAILABILITY EXTENSION CLUSTER ON AND " I contined the DB creation and it complerted successfully.

    Now I see the following...The listeners are offline and rest all the services are online.

    > crs_stat -t
    Name Type Target State Host
    ------------------------------------------------------------
    ora....00.lsnr application ONLINE OFFLINE
    ora....01.lsnr application ONLINE OFFLINE

    When I tried to start the CRS services I got the following error.

    =========================================
    > crs_start -all
    Attempting to start `ora.catlmsxt500.LISTENER_TPHXCCO_CATLMSXT500.lsnr` on member `catlmsxt500`
    Attempting to start `ora.catlmsxt501.LISTENER_TPHXCCO_CATLMSXT501.lsnr` on member `catlmsxt501`
    Start of `ora.catlmsxt500.LISTENER_TPHXCCO_CATLMSXT500.lsnr` on member `catlmsxt500` failed.
    catlmsxt501 : CRS-1018: Resource ora.catlmsxt500.vip (application) is already running on catlmsxt500

    Start of `ora.catlmsxt501.LISTENER_TPHXCCO_CATLMSXT501.lsnr` on member `catlmsxt501` failed.
    catlmsxt500 : CRS-1018: Resource ora.catlmsxt501.vip (application) is already running on catlmsxt501

    CRS-0215: Could not start resource 'ora.catlmsxt500.LISTENER_TPHXCCO_CATLMSXT500.lsnr'.

    CRS-0215: Could not start resource 'ora.catlmsxt501.LISTENER_TPHXCCO_CATLMSXT501.lsnr'.
    ===================================================

    I am not sure why it created a listener LISTENER_TPHXCCO_CATLMSXT501 whereas it should have only "LISTENER_CATLMSXT501" but it added the SID in the listener name.

    WHat should I do. How can I delete this listener and add the correct listener ??

    Thanks.

  2. #2
    Join Date
    Nov 2002
    Posts
    170
    Also when tried to delete the listener using svrctl I got the following error.

    srvctl remove listener -l LISTENER_TPHXCCO_CATLMSXT501
    Usage: srvctl []
    catlmsxt501.corp.cox.com | CRS | /export/home/oracle
    >
  3. #3
    Join Date
    Nov 2002
    Posts
    170
    Here is my listener.ora

    LISTENER_CATLMSXT501 =
    (DESCRIPTION_LIST =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = catlmsxt501v)(PORT = 1521)(IP = FIRST))
    )
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 10.62.206.121)(PORT = 1521)(IP = FIRST))
    )
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
    )
    )
    )

    and tnsnames.ora
    TPHXCCO2 =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = catlmsxt501v.corp.cox.com)(PORT = 1521))
    (CONNECT_DATA =
    (SERVER = DEDICATED)
    (SERVICE_NAME = TPHXCCO)
    (INSTANCE_NAME = TPHXCCO2)
    )
    )

    TPHXCCO1 =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = catlmsxt500v.corp.cox.com)(PORT = 1521))
    (CONNECT_DATA =
    (SERVER = DEDICATED)
    (SERVICE_NAME = TPHXCCO)
    (INSTANCE_NAME = TPHXCCO1)
    )
    )

    TPHXCCO =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = catlmsxt500v.corp.cox.com)(PORT = 1521))
    (ADDRESS = (PROTOCOL = TCP)(HOST = catlmsxt501v.corp.cox.com)(PORT = 1521))
    (LOAD_BALANCE = yes)
    (CONNECT_DATA =
    (SERVER = DEDICATED)
    (SERVICE_NAME = TPHXCCO)
    )
    )

    LISTENERS_TPHXCCO =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = catlmsxt500v.corp.cox.com)(PORT = 1521))
    (ADDRESS = (PROTOCOL = TCP)(HOST = catlmsxt501v.corp.cox.com)(PORT = 1521))
    )



    TATLCCO2 =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = catlmsxt501v.corp.cox.com)(PORT = 1521))
    (CONNECT_DATA =
    (SERVER = DEDICATED)
    (SERVICE_NAME = TATLCCO)
    (INSTANCE_NAME = TATLCCO2)
    )
    )

    TATLCCO1 =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = catlmsxt500v.corp.cox.com)(PORT = 1521))
    (CONNECT_DATA =
    (SERVER = DEDICATED)
    (SERVICE_NAME = TATLCCO)
    (INSTANCE_NAME = TATLCCO1)
    )
    )

    TATLCCO =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = catlmsxt500v.corp.cox.com)(PORT = 1521))
    (ADDRESS = (PROTOCOL = TCP)(HOST = catlmsxt501v.corp.cox.com)(PORT = 1521))
    (LOAD_BALANCE = yes)
    (CONNECT_DATA =
    (SERVER = DEDICATED)
    (SERVICE_NAME = TATLCCO)
    )
    )


    LISTENERS_TATLCCO =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = catlmsxt500v.corp.cox.com)(PORT = 1521))
    (ADDRESS = (PROTOCOL = TCP)(HOST = catlmsxt501v.corp.cox.com)(PORT = 1521))
    )

  4. #4
    Join Date
    Nov 2002
    Posts
    170
    I was able to remove all the listeners using netca and added one listener as cluster listener. Now when I start the crs_start -all I get the following error.

    ==================================================
    Attempting to start `ora.catlmsxt500.LISTENER_CATLMSXT500.lsnr` on member `catlmsxt500`
    Attempting to start `ora.catlmsxt501.LISTENER_CATLMSXT501.lsnr` on member `catlmsxt501`
    Start of `ora.catlmsxt500.LISTENER_CATLMSXT500.lsnr` on member `catlmsxt500` failed.
    catlmsxt501 : CRS-1018: Resource ora.catlmsxt500.vip (application) is already running on catlmsxt500


    catlmsxt501 : CRS-1018: Resource ora.catlmsxt500.vip (application) is already running on catlmsxt500


    Start of `ora.catlmsxt501.LISTENER_CATLMSXT501.lsnr` on member `catlmsxt501` failed.
    catlmsxt500 : CRS-1018: Resource ora.catlmsxt501.vip (application) is already running on catlmsxt501


    catlmsxt500 : CRS-1018: Resource ora.catlmsxt501.vip (application) is already running on catlmsxt501


    CRS-0215: Could not start resource 'ora.catlmsxt500.LISTENER_CATLMSXT500.lsnr'.

    CRS-0223: Resource 'ora.catlmsxt500.LISTENER_TPHXCCO_CATLMSXT500.lsnr' has placement error.

    CRS-0215: Could not start resource 'ora.catlmsxt501.LISTENER_CATLMSXT501.lsnr'.

    CRS-0223: Resource 'ora.catlmsxt501.LISTENER_TPHXCCO_CATLMSXT501.lsnr' has placement error.

    catlmsxt500.corp.cox.com | CRS | /export/home/oracle

  5. Posting Permissions

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



Click Here to Expand Forum to Full Width