Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I got the following message in the <listnername>.log file. I want to find out the reason why it got automatically shutdown and restarted again with different PID.

03-MAR-2013 03:00:57 * service_died * fmm * 12537
No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=fmm)))
No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=
03-MAR-2013 03:00:59 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=EM2-A)(USER=root))(COMMAND=stop)(ARGUMENTS=64)(SERVICE=FMMLIS)(VERSION=169869568)) * stop * 0

Log messages written to /opt/oracle/10/network/log/fmmlis.log
Trace information written to /opt/oracle/10/network/trace/fmmlis.trc

Trace level is currently 0

Started with pid=18548

Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=fmm)))
share|improve this question

migrated from Mar 14 '13 at 15:59

This question came from our site for professional and enthusiast programmers.

Maybe a restart of the whole machine? – a_horse_with_no_name May 14 '13 at 8:33
It seems that a service stopped responding service_died * fmm * 12537, and - a shot in the dark here - a connection from host EM-A (Enterprise Manager?) stopped and restarted the listener. Is this a RAC or it's a single instance? – Dimitre Radoulov Jan 9 '14 at 8:45
Please provide the output of crs_stat -t. The command can be run as root and usually resides in CRS_HOME/bin or GI_HOME/bin. – kubanczyk Jan 9 '14 at 13:20
Check if there's any info in your CRS logs. Chances are you will only see CRS detect that the listener had stopped, and begin restarting it. But sometimes there are more detailed error messages in there. Otherwise, sometimes listeners crash and leave no info as to why. It is a particularly annoying feature of Oracle. – Andrew Brennan Jun 17 '14 at 10:00
What in Log messages written to /opt/oracle/10/network/log/fmmlis.log Trace information written to /opt/oracle/10/network/trace/fmmlis.trc? – Giova Jan 14 at 10:13

To the new PID (process id), any time a process is spawned whether from a restart or a new thread a PID is assigned to said process. In terms of the restart, this would occur depending on your Oracle settings, it is possible for Oracle to attempt a respawn of the listener if it is configured to do so.

Also, are you running it as root?

share|improve this answer
Hi, what you have said is correct, but my problem is why it got restarted automatically, what can be the reason for this and also where can I check for further analysis. I am running it via oracle user – user21388 Mar 17 '13 at 8:20

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.