Explore our sites

Stack Exchange
tour help
Take the tour ×
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. It's 100% free, no registration required.
up vote 2 down vote favorite

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=10.67.7.192)(PORT=1522)))
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
 
Maybe a restart of the whole machine? –  a_horse_with_no_name May 14 at 8:33
add comment

migrated from stackoverflow.com Mar 14 at 15:59

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

1 Answer

up vote 0 down vote

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 at 8:20
add comment

Your Answer

 
discard

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.