Re: Down the oracle itself.

sivababu wrote:
>
> Hello all,
> One of our customer has the following problem. The oracle is shutting
> down itself after few hours. I could not know the reason. I got the
> following error from the alert log file..
>
> Am 1. August:
> PMON: terminating instance due to error 471
> Instance terminated by PMON, pid = 10001
>
> Heute:
> SNP1: terminating instance due to error 472
> Instance terminated by SNP1, pid = 5991
>
> Thanks and expecting your reply.
>
> with regards,
> sivababu

Check your DBA_JOBS.
Ususally, the SNPn processes are for either snapshots, or DBMS_JOBs. There should also be a trace file in $ORACLE_BASE\admin\<db_name>\bdump named $ORACLE_SID||SNPn.trc

hth,

Paul Received on Sat Aug 18 2001 - 14:42:15 CDT