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