Prev
Next
Forums Infor / Lawson Platforms S3 Systems Administration

Lawson DB Randomly Crashing

 2 Replies
 0 Subscribed to this topic
 27 Subscribed to this forum
Sort:
Author
Messages
Jeff White
Veteran Member
Posts: 83
Veteran Member
10/5/2017 5: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
    Basic Member
    Posts: 16
    Basic Member
    10/5/2017 11: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
      Veteran Member
      Posts: 83
      Veteran Member
      10/6/2017 1:50 PM
        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.