RAC ( Listener not starting )

[dbasupuser]

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.

[dbasupuser]

Also when tried to delete the listener using svrctl I got the following error.

srvctl remove listener -l LISTENER_TPHXCCO_CATLMSXT501
Usage: srvctl

[dbasupuser]

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))
)

[dbasupuser]

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