PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 10/06/2017 9:50 AM by  Jeff White
Lawson DB Randomly Crashing
 2 Replies
Sort:
You are not authorized to post a reply.
Author Messages
Jeff White
Private
Private
Veteran Member
(225 points)
Veteran Member
Posts:81


Send Message:

--
10/05/2017 1:53 PM

    HP Integrity 11iv3 - Apps

    Linux server - Oracle 11g DB

    Lawson 9.0.1.12 Env

    Just within the last few weeks we started having our production database crashing randomly.  Everything had been running solidly for at least 4 years when we started with the Oracle DB on the Linux server.

    Does anyone have any thoughts on what could be causing this?  Or what to look at/for?

    Lawson logs just show it losing connection with the database, and the Oracle logs have been sent to Oracle with no reply as of yet, and don't really show much either, that we can tell.

    The interesting thing is that we've converted most of our HR/PR/BN/GL/AP data over to SAP, and only have Canadian companies still on Lawson.  So our "power user" base has probably went from 150 users to 15, and the database crashes now with less utilization?

    TIA

    Jeff

    AlanK
    Project Manager
    Private
    Basic Member
    (22 points)
    Basic Member
    Posts:8


    Send Message:

    --
    10/05/2017 7:27 PM
    Hi Jeff,

    We are a MSSQL shop but found during our prep work and move to a new data center that the S3 to database connection is very sensitive to network interuptions. This seems to be due to older drivers that are not as resilient as those used on the landmark side. We started with recurring ping traces to confirm the network interuptions.
    HTH
    Alan
    Jeff White
    Private
    Private
    Veteran Member
    (225 points)
    Veteran Member
    Posts:81


    Send Message:

    --
    10/06/2017 9:50 AM
    Well, Oracle came back with "OS Resource Exhaustion" as the reason for the database crashing, and to make more memory available.

    I didn't realize that the DBA's added a new database instance (about 3 weeks ago) on the server to support an application that SAP will be using. More Swap space being added this weekend when the database can be shutdown. Hopefully that will do it.
    You are not authorized to post a reply.