Timed out trying to start process J002 massage [message #208749] |
Tue, 12 December 2006 01:49 |
shilpa.rajput
Messages: 31 Registered: May 2006 Location: Pune
|
Member |
|
|
Hello All,
I'm getting the 'Timed out trying to start process J002' message in my alert log file at specific intervals.
Can anyone help me out by predicting what could be the possible reason for the same?
Hope this contents of the alert log file make u get the clear idea of the problem.
Thanks in advance...
Sat Dec 9 14:21:38 2006
Timed out trying to start process J002.
Sat Dec 9 14:26:09 2006
Restarting dead background process QMN0
QMN0 started with pid=9
Sat Dec 9 23:48:06 2006
Thread 1 advanced to log sequence 145
Current log# 3 seq# 145 mem# 0: /oracle/ora92/oradata/test/redo03.log
Current log# 3 seq# 145 mem# 1: /oracle/ora92/oradata/test/redo13.log
Sat Dec 9 23:48:07 2006
ARC0: Evaluating archive log 2 thread 1 sequence 144
ARC0: Beginning to archive log 2 thread 1 sequence 144
Creating archive destination LOG_ARCHIVE_DEST_1: '/oracle/ora92/oradata/test/archive/1_144.dbf'
Sat Dec 9 23:49:04 2006
ARC0: Completed archiving log 2 thread 1 sequence 144
Mon Dec 11 07:19:26 2006
Thread 1 advanced to log sequence 146
Current log# 1 seq# 146 mem# 0: /oracle/ora92/oradata/test/redo01.log
Current log# 1 seq# 146 mem# 1: /oracle/ora92/oradata/test/redo11.log
Mon Dec 11 07:19:26 2006
ARC1: Evaluating archive log 3 thread 1 sequence 145
ARC1: Beginning to archive log 3 thread 1 sequence 145
Creating archive destination LOG_ARCHIVE_DEST_1: '/oracle/ora92/oradata/test/archive/1_145.dbf'
Mon Dec 11 07:20:24 2006
ARC1: Completed archiving log 3 thread 1 sequence 145
Mon Dec 11 18:23:14 2006
Errors in file /oracle/ora92/admin/test/bdump/test_j002_11638.trc:
ORA-00018: maximum number of sessions exceeded
Mon Dec 11 18:25:20 2006
Timed out trying to start process J002.
|
|
|
|