Hope, this doesn't look good. It looks like the daemon process keeps hanging after successful connection to the database because of a database lock or it takes too long to retrieve a message or message attachment causing the DB Mail to "think" the daemon is hung. Try the following 1. Check if DB_MAIL.MAIL_ATTACH table is locked. If yes, kill locking processes. 2. If 1st is no help, check what you have in DB_MAIL.MAIL_ATTACH table. If there are really large attachments delete them from the table. 3. If 2nd doesn't help delete everything from that table (TRUNCATE TABLE DB_MAIL.MAIL_ATTACH) 4. If 3rd doesn't help purge database side message queue CALL DBMS_PIPE.REMOVE_PIPE('DB_MAIL') 5. If 4th does not help try restarting computer running DB Mail server and if even that doesn't help try bouncing the database. : I see this in the log file - we are running on NT - connecting to an Oracle : database on Unix. : Is this normal - or is something set up incorrectly. : Thanks. : -------------- : 7/12/2005 00:06:58> Daemon for mail on xxx is not responding. Restarting : process... : 7/12/2005 00:06:58> Starting daemon process for mail on xxx : 7/12/2005 00:06:58> Daemon for mail on xxx started. System process #3104 : 7/12/2005 00:07:00> Connected to mail on xxx (xxxxxproduction) as : mailuserx : 7/12/2005 00:07:00> Connected to mail on xxx : 7/12/2005 00:12:58> Daemon for mail on xxx is not responding. Restarting : process... : 7/12/2005 00:12:58> Starting daemon process for mail on xxx : 7/12/2005 00:12:58> Daemon for mail on xxx started. System process #3448 : 7/12/2005 00:13:00> Connected to mail on xxx (xxxxxproduction) as : mailuserx : 7/12/2005 00:13:00> Connected to mail on xxx : 7/12/2005 00:18:58> Daemon for mail on xxx is not responding. Restarting : process... : 7/12/2005 00:18:58> Starting daemon process for mail on xxx : 7/12/2005 00:18:58> Daemon for mail on xxx started. System process #3504 : 7/12/2005 00:19:00> Connected to mail on xxx (xxxxxproduction) as : mailuserx : 7/12/2005 00:19:00> Connected to mail on xxx : 7/12/2005 00:24:58> Daemon for mail on xxx is not responding. Restarting : process... : 7/12/2005 00:24:58> Starting daemon process for mail on xxx : 7/12/2005 00:24:58> Daemon for mail on xxx started. System process #3532 : 7/12/2005 00:25:00> Connected to mail on xxx (xxxxxproduction) as : mailuserx : 7/12/2005 00:25:00> Connected to mail on xxx : 7/12/2005 00:30:58> Daemon for mail on xxx is not responding. Restarting : process... : 7/12/2005 00:30:58> Starting daemon process for mail on xxx : 7/12/2005 00:30:58> Daemon for mail on xxx started. System process #1808 : 7/12/2005 00:31:00> Connected to mail on xxx (xxxxxproduction) as : mailuserx : 7/12/2005 00:31:00> Connected to mail on xxx : 7/12/2005 00:36:58> Daemon for mail on xxx is not responding. Restarting : process... : 7/12/2005 00:36:58> Starting daemon process for mail on xxx : 7/12/2005 00:36:58> Daemon for mail on xxx started. System process #3104 : 7/12/2005 00:37:00> Connected to mail on xxx (xxxxxproduction) as : mailuserx : 7/12/2005 00:37:00> Connected to mail on xxx : 7/12/2005 00:42:58> Daemon for mail on xxx is not responding. Restarting : process... : 7/12/2005 00:42:58> Starting daemon process for mail on xxx : 7/12/2005 00:42:58> Daemon for mail on xxx started. System process #3380 : 7/12/2005 00:43:00> Connected to mail on xxx (xxxxxproduction) as : mailuserx : 7/12/2005 00:43:00> Connected to mail on xxx : 7/12/2005 00:48:58> Daemon for mail on xxx is not responding. Restarting : process... : 7/12/2005 00:48:58> Starting daemon process for mail on xxx : 7/12/2005 00:48:58> Daemon for mail on xxx started. System process #2812 : 7/12/2005 00:49:00> Connected to mail on xxx (xxxxxproduction) as : mailuserx : 7/12/2005 00:49:00> Connected to mail on xxx : etc.. this continues and stops on some days.
|