Manivannan,
Often when a background process dies it creates a
domino effect crashing all the other background
processes in turn, so the process listed as crashing
the instance is frequently the last process to die,
not the one that actually started the crash.
Check the DBWR trace file and you'll probably see an
error that another background process terminated, so
check its trace file. Continue backtracking through
all of them and you'll eventually reach the one that
died first. It will typically contain an ORA-600,
ORA-7445, or some other major error, such as an I/O
error.
HTH,
- Anita
- "Manivannan.M" <manivannan.m_at_tatainfotech.com>
wrote:
> Hi
>
> While connecting to the database one of the users
> got this error.
> " DBWR process terminated with error"
>
> I couldn't understand why the writer process got
> terminated. I brought
> down the database and brought it up again. Then I'm
> able to connect to the
> database. I would be happy if somebody enlighten me
> why this error
> occurred.
>
> Thanks in advance,
>
>
> Manivannan
> Muthukrishnan.
>
>
> ADDRESS: E-MAIL:
> 68/4, Site no:3,
> manivannan.m_at_tatainfotech.com
> 80 Feet road,
> (opp) Deccan Studio,
> Indiranagar, PHONE:
> Bangalore - 560038. 5284681
> Ext: 464
>
>
>
>
>
>
>
> --
> Author: Manivannan.M
> INET: manivannan.m_at_tatainfotech.com
>
> Fat City Network Services -- (858) 538-5051 FAX:
> (858) 538-5051
> San Diego, California -- Public Internet
> access / Mailing Lists
>
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from). You may
> also send the HELP command for other information
> (like subscribing).
Do You Yahoo!?
Received on Tue Jun 20 2000 - 12:37:43 CDT