Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-00474: SMON process terminated with error
epipko_at_gmail.com wrote:
> Hi all,
> We got this error second time now. All we do it bring d/b up and it
> works fine.
> I've looked in .TRC file and found following:
> -------------------------------------------------------------------------
> Redo thread mounted by this instance: 1
> Oracle process number: 2
> Windows thread id: 3196, image: ORACLE.EXE
>
> *** 2006-04-06 10:20:32.653
> *** SESSION ID:(1.1) 2006-04-06 10:20:32.653
> error 474 detected in background process
> ORA-00474: SMON process terminated with error
> -------------------------------------------------------------------------
> Where can I look for the cause of this error?
>
> Thanks,
> Eugene
>
Have a look in your BACKGROUND_DUMP_DEST directory for any [sid]_smon_xxx.trc files. They may provide more information. Also look in your Alert log to see if there are any additional clues. In the end, you'll probably have to contact Oracle Support to get this resolved.
HTH,
Brian
-- =================================================================== Brian Peasland oracle_dba_at_nospam.peasland.net http://www.peasland.net Remove the "nospam." from the email address to email me. "I can give it to you cheap, quick, and good. Now pick two out of the three" - UnknownReceived on Thu Apr 06 2006 - 14:51:54 CDT