My Oracle Support Banner

Listener endpoint for public host is removed for a brief period when crsd.bin crash (Doc ID 1605983.1)

Last updated on NOVEMBER 13, 2024

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.1.0 and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.

Symptoms

Listener endpoint information for public IP is removed from listener when crsd.bin crashes. It is added back automatically shortly after crsd.bin restart.

lsnrctl status listener
-----------------------------

-- before the crash of crsd.bin
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=<PUBLIC_IP1>)(PORT=1521)))   <<<
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=<VIRTUAL_IP1>)(PORT=1521)))
Services Summary...

-- after the crash of crsd.bin
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=<VIRTUAL_IP1>)(PORT=1521)))
Services Summary...

In the example, <PUBLIC_IP1> is the public host IP and <VIRTUAL_IP1> is the host VIP.

 -- listener.log

 Tue May 15 19:41:15 2012
 15-MAY-2012 19:41:15 * (CONNECT_DATA=... * status * 0
 No longer listening on:
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=<PUBLIC_IP1>)(PORT=1521)))
 15-MAY-2012 19:41:15 * service_died * LsnrAgt * 12537

This indicates oraagent process died.

This issue can also happen to SCAN Listener. If the endpoint for SCAN Listener is removed, client connection using SCAN Listener could end with error: ORA-12541: no listener.

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.