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" - Unknown