Re: Process died -- no info in trace files

  • From: Stephane Faroult <sfaroult@xxxxxxxxxxxx>
  • To: saad4u@xxxxxxxxx
  • Date: Wed, 15 Apr 2009 21:20:28 +0200

The wording of your post ("I really dont see anything in the trace
file") makes me think that you are looking in the alert file or
something similar. You should look for .trc files under the directory
defined as "user_dump_dest" in you parameter files (cd ../udump from the
directory where you alert file is located should take you to the right
place).

HTH

S Faroult

Saad Khan wrote:
> Hi fellows,
>
> I've oracle 10g (10.2.0.4) running at Linux with partitioning option.
> The users were running pipelines while I was informed that the they
> got crashed. When I checked the alert log file, I could see the
> following error messages:
>
>
> /Wed Apr 15 14:03:54 2009
> Process P003 died, see its trace file
> Wed Apr 15 14:03:55 2009
> Process P004 died, see its trace file
> Wed Apr 15 14:03:56 2009
> Process P003 died, see its trace file
> Process P003 died, see its trace file
> Process P003 died, see its trace file
> Process P003 died, see its trace file
> Wed Apr 15 14:04:02 2009
> Process P005 died, see its trace file
> Process P005 died, see its trace file
>
>
>
> /Now, the wierd thing is, I really dont see anything in the trace file
> that could point anything that could have caused this.
>
> I checked my parameters and found that the PROCESSES parameter was set
> to a very low value (i.e.150). Now I've increased it to 400 but this
> is just a shot in dark. I'm totally unsure if this could be the reason.
>
> Can anyone please help me? Its quite urgent.
>
> Thanks,
>
>
> Khan.
>


--
//www.freelists.org/webpage/oracle-l


Other related posts: