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

ORA-31425: subscription does not exist

1 Answers  


ORA-01644: tablespace 'string' is already read only

1 Answers  


ORA-31669: Worker process string violated startup protocol.

1 Answers  


EXP-00035: QUERY parameter valid only for table mode exports

1 Answers  


ORA-02371: Loader must be at least version string.string.string.string.string for direct path

1 Answers  






ORA-01782: UNRECOVERABLE cannot be specified for a cluster or clustered table

1 Answers  


ORA-22878: duplicate LOB partition or subpartition specified

1 Answers  


QSM-00788: the table string is invalid for directive string

1 Answers  


RMAN-06002: command not allowed when not connected to a recovery catalog

1 Answers  


NNC-00414: invalid name-value binding string "string"

1 Answers  


ORA-31674: worker process interrupt for unhandled exception in master process

1 Answers  


ORA-02835: Server unable to send signal to client

1 Answers  


Categories