Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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-34802: (OCI11) OLAP OCI operation caused ROLLBACK past an UPDATE of an attached analytic workspace. Current operation canceled.

1 Answers  


ORA-19724: snapshot too old: snapshot time is before file string plug-in time

1 Answers  


TNS-00146: Internal-- Retry data request withing pump.

1 Answers  


ORA-31413: change set string is currently being advanced

1 Answers  


NZE-28810: Cannot create key descriptor.

1 Answers  






DRG-50931: parser not opened

1 Answers  


ORA-02704: osndopop: fork failed

1 Answers  


PCC-01011: USAGE IS BINARY clause must be terminated by "." on same line

1 Answers  


PLS-00101: reserved for future use

1 Answers  


ORA-15113: alias name 'string' refers to a directory

1 Answers  


ORA-14151: invalid table partitioning method

1 Answers  


ORA-00370: potential deadlock during kcbchange operation

1 Answers  






Categories