Skip navigation
2212 Views 7 Replies Latest reply: Sep 16, 2011 10:36 AM by THogland RSS
THogland Rookie 28 posts since
Nov 26, 2008

Has received 1 of 9 achievements.
Currently Being Moderated

Sep 12, 2011 1:00 PM

LDMS9 overloading Oracle 11g

Since upgrading to LDMS9 sp2, we've had problems with the inventory service dropping offline. Our Oracle DBA was noticing the database listener would stop responding, which seemed to cause the service problems, and has been looking at Oracle. This morning, after rolling out patches over the weekend, I noticed that the inventory data is badly out of date on many machines, including mine. (Example - system does daily inventory scans, but machines are showing nothing since late July or early August.) I had clened out the ErrorScan folder 10 days ago, and in the last 10 days I have ~7300 failures in there (about 3/4 of all scans, if my ~1000 machines are scanning daily for the last 10 days.) Asked the DBA, and he had finally determined that LANDesk is overloading the listeners with the number of concurrent database sessions trying to connect to Oracle, and asked that I limit LDMS to 120 concurrent connections.

 

Is there a way to do something like this? I can't find anything in the community about it...

 

This isn't a huge system, either - one core, a dozen total users, about 1000 devices.

  • Specialist 240 posts since
    Apr 4, 2008

    Has received 6 of 9 achievements.
    Currently Being Moderated
    1. Sep 14, 2011 9:31 AM (in response to THogland)
    Re: LDMS9 overloading Oracle 11g

    Are you sure with the Overloading?

    You may check your Agent Options, how often you make Scans and so on,

    to reduce this.

    I would suggest you to open a case for this.

     

    Best Regards

    Troga

  • Specialist 240 posts since
    Apr 4, 2008

    Has received 6 of 9 achievements.
    Currently Being Moderated
    3. Sep 15, 2011 12:37 AM (in response to THogland)
    Re: LDMS9 overloading Oracle 11g

    Are you using the latest MCP Patches (0519?

    I remember that in one (Core) of them, was a fix for Oracle Database with updating PK.

    You may ask the Support for it.

     

    >>Feb 2011 MCP Datamart Creates invalid PK column leading to invalid triggers for Oracle users.

     

    Best Regards

    Troga

  • BigB SupportEmployee 3 posts since
    May 23, 2011

    Has received 2 of 9 achievements.
    Currently Being Moderated
    4. Sep 15, 2011 11:18 AM (in response to TrogaTrading)
    Re: LDMS9 overloading Oracle 11g

    Limiting the # of concurrent sessions will seriously cripple your LANDesk functionality. If you are managing 1000 nodes, then you should have as many as 200+ concurrent sessions running. LANDesk requires a database with close to dedicated database funcitionality.

  • MarXtar SSMMVPGroup 2,051 posts since
    Jul 2, 2008

    Has received 8 of 9 achievements.
    Currently Being Moderated
    6. Sep 16, 2011 2:27 AM (in response to THogland)
    Re: LDMS9 overloading Oracle 11g

    What do you mean by having four nodes? Have you setup multiple inventory services? For a 1,000 node environment this sound like a bit of overkill if you have.Not necessarily related to your issue, but sounded odd.

     

    Definitely look into the patch since it sounds like what you are encountering, and having constant errors certainly won't be helping your performance.

     

    Mark McGinn

    MarXtar Ltd

    http://www.marxtar.com

     

    The One-Stop Shop for LANDesk Enhancements

    - Wake-On-WAN - Distributed Wake-On-LAN, Scheduled Power Down, and SWDist Sequencing

    - Inventory Archiving/Change & Root Cause Analysis

    - Self-Service Password Reset

    - PC Power Management

    - Help/Service Desk Integration

    - LANDesk Data Manipulation/Integration/Bar Coding

    - LANDesk Executive Reporting Pack

    - Network Asset Discovery and Management

    - LANDesk Software Store

More Like This

  • Retrieving data ...

Bookmarked By (0)

Legend

  • Correct Answers - 20 points
  • Helpful Answers - 10 points
LANDESK Community powered by Jive SBS® 4.5.7.1  |  Legal Notices  |  Privacy Policy  |  Icon 

TweeterOn Twitter  |  Icon FacebookOn Facebook © 2007 LANDESK Software