Re: DB Control crashing every couple of days for 10.2.0.2 database

Hi Daniel, haven't talked to you in a while--hope things are going well.

One thing I'd check is the /var/log/messages on this server. Linux has a memory monitor process (I think it was also in the RH 4 kernels) and if the server becomes too short on free memory, this kernel thread will start killing processes to save the server from crashing. This was the case for me recently when my 10g DB went down for no apparent reason and I found that Linux dutifully logged that it killed my process due to a memory shortage on the box.

Dan

PS Given our common history, you might be interested in this tidbit: http://www.dannorris.com/2008/01/23/acquisition-wednesday-round-2-indian-firm-rolta-buys-tusc/

• Original Message ---- From: daniel koehne <koehned_at_gmail.com> To: ORACLE-L_at_freelists.org Sent: Wednesday, January 23, 2008 3:12:06 PM Subject: DB Control crashing every couple of days for 10.2.0.2 database

Every couple of days my single Database Control install dies. It has been hard to find any error message in the log files, but I do see the following in the emdb.nohup file when the crash happens (just including the first 4 lines for completeness, I don't think that they have anything to do with the crash):

08/01/14 10:51:18 ## 2. newPage = /database/instance/sitemap/healthgif
08/01/14 10:51:22 ## oracle.sysman.db.adm.inst.SitemapController: event="doLoad"
08/01/14 10:51:22 ## 1. newPage = /database/instance/sitemap/sitemap

08/01/14 10:51:22 ## 2. newPage = /database/instance/sitemap/sitemap
----- Tue Jan 15 10:44:10 2008::DBConsole exited at Tue Jan 15 10:44:10 2008 with signal 9 -----

• Tue Jan 15 10:44:10 2008::DBConsole has been forcibly killed. -----
• Tue Jan 15 10:44:10 2008::Stopping other components. ----- Tue Jan 15 10:44:10 2008::EMWD Stopping EMAgent (pid=21984): emagent now exiting normally
• Tue Jan 15 10:44:32 2008::Commiting Process death. -----
• Tue Jan 15 15:39:47 2008::DBConsole. Monitoring Agent+Console -----

Oracle support really isn't providing any help diagnosing this problem apart from telling me to reinstall Database Control. Has anyone else experienced this behavior or know anything about the mysterious "signal 9"?

For completeness the system with Database Control running on it is:

   OS: RHAS 4 U4
   System: 4 CPU, 8Gb
   Oracle: 10.2.0.2 with patch 5225799.

Thanks for any help.

   Daniel

--
http://www.freelists.org/webpage/oracle-l