Infrastructure at your Service
Lot’s of companies do not use Grid- or Cloud Control for monitoring their Oracle databases for various reasons but rather use open source tools like nagios. And lot of those either implemented custom script frameworks or rely on plug-ins available for the monitoring solution of choice. This post shall show on how you can let Oracle check a lot of its own metrics and you only need one script for alerting various metrics. Oracle provides…
We saw in my last blog how to install the SQL Server plugin for Nagios. In this new blog, I will explain: how to create a wrapper to avoid the unset of the PERLLIB variable how to create and configure a configuration file by monitoring instance how to create an SQL Login for nagios How to subscribe to an alert As we saw in the first nagios blog, to be able to run the check…
Nagios is an IT Infrastructure monitoring solution which is able to monitor SQL Server instances with a specific plugin. I have installed this plugin to test those functionalities and I will explain here how to do it. Prerequisites installation FreeTDS installation FreeTDS is a set of libraries for Unix and Linux that allows your programs to natively talk to Microsoft SQL Server and Sybase databases. First we will download this set of libraries, for that…
As I said in my last blog, the Alfresco Summit 2014 took place in London from October 7 to 9. So yeah, unfortunately yesterday was the last day of this amazing event. It’s the first time I had the chance to participate in an Alfresco Summit but I’m quite sure it will not be the last! I can’t tell what moment I preferred during this event because the Keynote (presentation of Alfresco One 5.0) was very…
By Franck Pachot . You probably know about ‘nproc’ limits in Linux which are set in /etc/limits.conf and checked with ‘ulimit -u’. But do you know how to handle the monitoring and be alerted when you’re close the fixed limit? Nproc and ps Nproc is defined at OS level to limit the number of processes per user. Oracle 11.2.0.4 documentation recommends the following: oracle soft nproc 2047 oracle hard nproc 16384 But that is often…
By Franck Pachot . I have recently posted on the way I like to extract execution plans. When we have Tuning pack, I suggest to get them with SQL Real-Time Monitoring as an active report. However, Martin Preiss said in a comment that he prefers the text format – easier to search, copy, and paste. And that’s a very good remark. We still need plain text. My point is that if you send me the…
On a WebLogic Server, I had to write a WLST script to find the current number of consumers accessing a specific JMS Queue destination as this is not monitored by Oracle Grid Control 11g or Oracle Cloud Control 12c. Knowing only the short name of the queue, I uses a regular expression in my WLST script to find the needed information. To find the correct queue destination I had to search the Queue Destination Name….
I have read some blog postings concerning the new perfmon counters, but I have not seen really extensive overviews yet. In this post, I would like to present not only what is new, but also what has changed (or not) and how to find it. The first step is to select all objects in SQL2008R2 and SQL2012 from the view sys.dm_os_performance_counters. Remarks: All object or counter definitions from this post come from msdn. Objects comparison The…
I had the opportunity to spend two days in England (Birmingham) to participate in the UKOUG 2012. My first day was the Middleware sunday. This event is related to technical content and feedback for WebLogic administrators. It was an interesting day with useful feedback related to Oracle WebLogic. This Sunday middleware agenda event was as follows: WebLogic Sctripting Tool – Taking WLST to the Next Level (Simon Haslam, Veriton Limited) Node Manager under the Covers…
I spent three interesting days at the DOAG Konferenz 2012 – the German Oracle User Group’s conference. It was the 25th birthday and my first time as a DOAG Konferenz speaker. In this post, I will not talk about my presentation, but rather give you information from the sessions I went to. I will talk about three areas: Oracle WebLogic 12c, monitoring & diagnostics, and licensing. Regarding WebLogic, Mr. Munz from munz & more described…
