DBAsupport.com Forums - Powered by vBulletin
Results 1 to 10 of 10

Thread: ‘DBW0: terminating instance due to error 472’.

  1. 03-19-2007, 06:32 AM #1
    sfgaldba
    sfgaldba is offline Junior Member
    Join Date
    Mar 2007
    Posts
    48

    ‘DBW0: terminating instance due to error 472’.

    My windows db (9i) was terminated due to 472. I was able to restart the db but I have no idea why yet. Can anyone tell me what this message means? :(
    Reply With Quote Reply With Quote
  2. 03-19-2007, 06:48 AM #2
    reydp's Avatar
    reydp
    reydp is offline Senior Advisor
    Join Date
    Sep 2001
    Location
    Makati, Philippines
    Posts
    857
    what command have you executed?
    Are you trying to create database manually?
    ---------------
    Reply With Quote Reply With Quote
  3. 03-19-2007, 07:47 AM #3
    tvrdileep
    tvrdileep is offline Member
    Join Date
    Oct 2001
    Location
    Doha, Qatar
    Posts
    103
    Hai,
    Do not use "SEGMENT SPACE MANAGEMENT AUTO" option when manually creating a database.
    Reply With Quote Reply With Quote
  4. 03-19-2007, 09:52 AM #4
    dbasan's Avatar
    dbasan
    dbasan is offline Advisor
    Join Date
    Mar 2004
    Location
    DC,USA
    Posts
    650
    Quote Originally Posted by sfgaldba
    My windows db (9i) was terminated due to 472. I was able to restart the db but I have no idea why yet. Can anyone tell me what this message means? :(
    Google out for more info.

    Also check the alert log and trace files for the errors.
    "What is past is PROLOGUE"
    Reply With Quote Reply With Quote
  5. 03-19-2007, 03:27 PM #5
    Bore
    Bore is offline Advisor
    Join Date
    Nov 2006
    Location
    Sofia
    Posts
    630
    tvrdileep why not?
    What's wrong with that?

    Thaks
    Reply With Quote Reply With Quote
  6. 03-19-2007, 04:29 PM #6
    PAVB's Avatar
    PAVB
    PAVB is offline Senior Advisor
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,555
    xxxxxx-oracle/xxxxxx02 [3]: oerr ORA 472
    00472, 00000, "PMON process terminated with error"
    // *Cause: The process cleanup process died
    // *Action: Warm start instance
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
    Reply With Quote Reply With Quote
  7. 03-19-2007, 04:45 PM #7
    davey23uk
    davey23uk is offline Senior Advisor
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    what a useless post, its what generated along with that error that is useful
    Reply With Quote Reply With Quote
  8. 03-19-2007, 04:52 PM #8
    PAVB's Avatar
    PAVB
    PAVB is offline Senior Advisor
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,555
    Quote Originally Posted by davey23uk
    what a useless post, its what generated along with that error that is useful
    Davey -- You have to read a little more carefully what the initial post asks for... the guy wants to know "what the message means"
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
    Reply With Quote Reply With Quote
  9. 03-19-2007, 05:27 PM #9
    sfgaldba
    sfgaldba is offline Junior Member
    Join Date
    Mar 2007
    Posts
    48
    PAVB:

    Other than 00472, 00000, "PMON process terminated with error", is there anything else ? I have no trace file generated. No error in the event viewer. I have to identify the cause but still fuzzy about what could go wrong. The only thing happen prior to the shutdown was someone was running several processes through Business Objects and Toad. Not sure if anything hang or not but the person who was running was the one called.
    Reply With Quote Reply With Quote
  10. 03-19-2007, 05:36 PM #10
    PAVB's Avatar
    PAVB
    PAVB is offline Senior Advisor
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,555
    Please check Oracle's Alert Log around your ORA-00472 looking for other errors, also check if Oracle generated a Trace file around the time the instance crashed.

    If some additional information is available chances are t was reported in the form of a Trace file.
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules

Click Here to Expand Forum to Full Width