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



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

Answer / guest

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

Action: Error 1170 has occured 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 error is not
normally visible to the user. For further details, turn on
tracing and reexecute the operation. If error persists,
contact Oracle Customer Support.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

NNO-00327: server statistic counter dump ends

1 Answers  


TNS-02404: Service string contains no local handlers

1 Answers  


LFI-01520: close() failed(OSD return value = string) in string.

1 Answers  


TNS-00078: * log_on - ask process_name to turn logging on

1 Answers  


RMAN-06494: %s = string is out of range (string-string)

1 Answers  






PROC-00002: Cannot perform cluster registry operation at the current init level.

1 Answers  


ORA-16072: a minimum of one standby database destination is required

1 Answers  


DRG-11119: operation is not supported by this index type

1 Answers  


SQL*Loader-00105: Invalid data file name on command line

1 Answers  


ORA-02305: only EXECUTE, DEBUG, and UNDER privileges are valid for types

1 Answers  


ORA-02253: constraint specification not allowed here

3 Answers  


ORA-22871: ALTER TYPE with REPLACE is not allowed for pure incomplete types

1 Answers  


Categories