Skip to Content
author's profile photo Former Member
Former Member

Server shutdown suddenly

Hi Friends,

Yesterday night our server went down suddenly, after restarting it is working fine, but i have gone through SM21 i can find the log as --- around 8.pm

SQL error 3113 (possibly network error) : WP in reconnect status.

in ST22 - in the afternoon 1.54pm -- dump as SET_Parameter_Memory_Overflow

around 8.22pm.--In Oracle alert log i can see -- Shutting down the instance .

Our Server information is -- HP unix, Oracle 8 with SAP 4.0B. Can anyone suggest what should i do to overcome this issue in future. Please update me.

Thanks & Regards

sathya.

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jun 15, 2012 at 03:59 AM

    Hi,

    It seems somebody (or some automatic process) has shut down the database.

    Do you have a cluster configuration?

    Is there a 3rd party monitoring tool that could have shut down the database?

    What other messages are there around the "shutting down the instance" message?

    BR,

    Samuli

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 15, 2012 at 07:03 AM

    Hi Sathya,

    Check SAP note :335199 - ora-3113 collective note.

    oracle 10.2.0.2 is not supported any more,If you are on oracle 10.2.0.2 than you need to apply latest patch set as per note 839187 and 1431752.

    Regards,

    Vipin

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.