SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
disconnect - reconnect

 
Reply to topic    SoftTree Technologies Forum Index » DB Audit, DB Mail, DB Tools View previous topic
View next topic
disconnect - reconnect
Author Message
bill jolly



Joined: 12 Jul 2005
Posts: 2

Post disconnect - reconnect Reply with quote

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.

Tue Jul 12, 2005 12:47 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7842

Post Re: disconnect - reconnect Reply with quote

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.

Tue Jul 12, 2005 1:01 pm View user's profile Send private message
bill jolly



Joined: 12 Jul 2005
Posts: 2

Post Re: disconnect - reconnect Reply with quote

Thanks for you quick response ..
I'll get the DBA's busy - thanks again.

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

Tue Jul 12, 2005 1:43 pm View user's profile Send private message
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » DB Audit, DB Mail, DB Tools All times are GMT - 4 Hours
Page 1 of 1

 
Jump to: 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


 

 

Powered by phpBB © 2001, 2005 phpBB Group
Design by Freestyle XL / Flowers Online.