+ Reply to Thread
Page 1 of 2 1 2 LastLast
Results 1 to 10 of 15

ORA-00474: SMON process terminated with error

  1. ORA-00474: SMON process terminated with error

    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 ID1.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


  2. Re: ORA-00474: SMON process terminated with error

    On 6 Apr 2006 10:44:05 -0700, epipko@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 ID1.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



    http://tahiti.oracle.com has the error messages manual.
    Don't tell you didn't know that.

    --
    Sybrand Bakker, Senior Oracle DBA

  3. Re: ORA-00474: SMON process terminated with error

    On 6 Apr 2006 10:44:05 -0700, epipko@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 ID1.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



    http://tahiti.oracle.com has the error messages manual.
    Don't tell you didn't know that.

    --
    Sybrand Bakker, Senior Oracle DBA

  4. Re: ORA-00474: SMON process terminated with error

    epipko@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 ID1.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@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

  5. Re: ORA-00474: SMON process terminated with error

    epipko@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 ID1.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@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

  6. Re: ORA-00474: SMON process terminated with error

    Thanks Brian,
    I've looked at the trace file already (as I mentioned in my original
    message). It has nothing in it except what I already show.
    I guess I will contact Oracle Suppot.

    Hey Sybrand, are you blind? Can't you see that I've looked at the error
    and followed its description. How about this: next time don't bother
    answering.

    Thanks,
    Eugene


  7. Re: ORA-00474: SMON process terminated with error

    Thanks Brian,
    I've looked at the trace file already (as I mentioned in my original
    message). It has nothing in it except what I already show.
    I guess I will contact Oracle Suppot.

    Hey Sybrand, are you blind? Can't you see that I've looked at the error
    and followed its description. How about this: next time don't bother
    answering.

    Thanks,
    Eugene


  8. Re: ORA-00474: SMON process terminated with error

    > I've looked at the trace file already (as I mentioned in my original
    > message). It has nothing in it except what I already show.
    > I guess I will contact Oracle Suppot.


    They might have you sent an event equal to the error number, which will
    then (hopefully) generate a trace file the next time this error is
    raised. No guarantees, but that trace file might contain a nice big hex
    dump which Oracle Support can interpret.

    HTH,
    Brian

    --
    ===================================================================

    Brian Peasland
    oracle_dba@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

  9. Re: ORA-00474: SMON process terminated with error

    > I've looked at the trace file already (as I mentioned in my original
    > message). It has nothing in it except what I already show.
    > I guess I will contact Oracle Suppot.


    They might have you sent an event equal to the error number, which will
    then (hopefully) generate a trace file the next time this error is
    raised. No guarantees, but that trace file might contain a nice big hex
    dump which Oracle Support can interpret.

    HTH,
    Brian

    --
    ===================================================================

    Brian Peasland
    oracle_dba@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

  10. Re: ORA-00474: SMON process terminated with error

    Hi,
    We had the similar problem with our windows box earlier. Support has
    advised us to upgrade to next patchset and it solved the problem.
    When one of the background process dies, pmon or smon will bring the
    db down with ora-474 or ora-472. In my case the errorstack event 474
    doesn't provide much info. Somehow upgrading the DB did the trick.

    Thanks and Regards,
    Satheesh Babu.S


+ Reply to Thread
Page 1 of 2 1 2 LastLast