Home » RDBMS Server » Performance Tuning » Timed out trying to start process J002 massage
Timed out trying to start process J002 massage [message #208749] Tue, 12 December 2006 01:49 Go to next message
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.
Re: Timed out trying to start process J002 massage [message #208763 is a reply to message #208749] Tue, 12 December 2006 03:01 Go to previous message
Frank Naude
Messages: 4579
Registered: April 1998
Senior Member
Check if PMON is writing trace files with more detailed info.

Also, the problem might be related to this error:

ORA-00018: maximum number of sessions exceeded
Previous Topic: nothing in trace-file
Next Topic: Performance Issue
Goto Forum:
  


Current Time: Thu Mar 28 04:59:34 CDT 2024