Take the 2-minute 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.

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

migrated from stackoverflow.com Mar 14 '13 at 15:59

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

1 Answer

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
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.