TNS-01172

Error: TNS-01172: Listener has shut down since all listen addresses have been deallocated

Causa: The event detection mechanism broke and caused all listen addresses to be removed.

Acción: Error 1170 has occurred and caused all the listen addresses to be deallocated. Since all the listen addresses have been removed, no more connections can be established to this listener so it shuts itself down. This message is not normally visible to the user. For further details, turn on tracing and re-execute the operation. If the error persists, contact Oracle Support Services.