{"id":1087,"date":"2015-06-18T10:17:00","date_gmt":"2015-06-18T08:17:00","guid":{"rendered":"http:\/\/www.ludovicocaldara.net\/dba\/?p=1087"},"modified":"2020-08-18T16:33:36","modified_gmt":"2020-08-18T14:33:36","slug":"check-ulimit-running-instances","status":"publish","type":"post","link":"https:\/\/www.ludovicocaldara.net\/dba\/check-ulimit-running-instances\/","title":{"rendered":"Check the actual ulimits for all the running Oracle instances"},"content":{"rendered":"<p>I&#8217;ve read the recent good post from my friend <strong>Rene<\/strong> on <strong>Pythian&#8217;s Blog<\/strong> about how to troubleshoot when user ulimits are different from what specified in limits.conf:<\/p>\n<p><a href=\"http:\/\/www.pythian.com\/blog\/quick-tip-oracle-user-ulimit-doesnt-reflect-value-on-etcsecuritylimits-conf\/\" target=\"_blank\" rel=\"noopener noreferrer\">Quick Tip : Oracle User Ulimit Doesn\u2019t Reflect Value on \/etc\/security\/limits.conf<\/a><\/p>\n<p>I would like to add my 2 cents:<\/p>\n<p>Once you fix the problem, you may want to check (any maybe monitor) when an instance is running with a wrong value (and maybe encounter the famous Error message: Linux-x86_64 Error: 23: Too many open files in system).<\/p>\n<pre class=\"lang:sh decode:true\">for pmonspid in `ps -eaf | grep [p]mon | awk '{print $2}'` ; do ps -f -p $pmonspid  ; grep \"open files\" \/proc\/$pmonspid\/limits ; done<\/pre>\n<p>This single line gives you an overview of all your instances at once:<\/p>\n<pre class=\"lang:sh decode:true \">$ for pmonspid in `ps -eaf | grep [p]mon | awk '{print $2}'` ; do ps -f -p $pmonspid  ; grep \"open files\" \/proc\/$pmonspid\/limits ; done\r\nUID        PID  PPID  C STIME TTY     TIME CMD           \r\noracle     545     1  0 Mar18 ?   00:08:27 ora_pmon_orcl1\r\nMax open files            1024            1024           files &lt;&lt;&lt; 1024!!\r\nUID        PID  PPID  C STIME TTY     TIME CMD           \r\noracle    1294     1  0 Apr20 ?   00:00:09 ora_pmon_orcl2\r\nMax open files            1024            1024           files &lt;&lt;&lt; 1024!!\r\nUID        PID  PPID  C STIME TTY     TIME CMD           \r\noracle    9917     1  0 Jan26 ?   00:08:17 ora_pmon_orcl3\r\nMax open files            1024            1024           files &lt;&lt;&lt; 1024!!\r\nUID        PID  PPID  C STIME TTY     TIME CMD           \r\noracle   11286     1  0 Jan26 ?   00:07:35 ora_pmon_orcl4\r\nMax open files            1024            1024           files &lt;&lt;&lt; 1024!!\r\nUID        PID  PPID  C STIME TTY     TIME CMD           \r\noracle   11647     1  0 Mar04 ?   00:04:36 ora_pmon_orcl5\r\nMax open files            65536           65536          files\r\nUID        PID  PPID  C STIME TTY     TIME CMD           \r\noracle   11836     1  0 Jan26 ?   00:07:55 ora_pmon_orcl6\r\nMax open files            1024            1024           files &lt;&lt;&lt; 1024!!\r\nUID        PID  PPID  C STIME TTY     TIME CMD           \r\noracle   14183     1  0 Feb06 ?   00:07:13 ora_pmon_orcl7\r\nMax open files            65536           65536          files\r\nUID        PID  PPID  C STIME TTY     TIME CMD           \r\noracle   16023     1  0 Feb27 ?   00:05:20 ora_pmon_orcl8\r\nMax open files            65536           65536          files\r\nUID        PID  PPID  C STIME TTY     TIME CMD           \r\noracle   18756     1  0 Mar20 ?   00:03:24 ora_pmon_orcl9\r\nMax open files            65536           65536          files\r\n<\/pre>\n<p>If you find any wrong values, plan a restart before you encounter any error during peak hours!<\/p>\n<p>&#8212;<\/p>\n<p>Ludo<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>I&#8217;ve read the recent good post from my friend Rene on Pythian&#8217;s Blog about how to troubleshoot when user ulimits are different from what specified in limits.conf: Quick Tip : Oracle User Ulimit Doesn\u2019t Reflect Value on \/etc\/security\/limits.conf I would &hellip; <a href=\"https:\/\/www.ludovicocaldara.net\/dba\/check-ulimit-running-instances\/\">Continue reading <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[5,326,3,330,132],"tags":[229,285,67,230,228],"class_list":["post-1087","post","type-post","status-publish","format-standard","hentry","category-linux","category-oracle","category-oracledb","category-oracle-inst-upg","category-triblog","tag-error-23","tag-linux","tag-monitoring","tag-too-many-open-files","tag-ulimit"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.ludovicocaldara.net\/dba\/wp-json\/wp\/v2\/posts\/1087","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.ludovicocaldara.net\/dba\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.ludovicocaldara.net\/dba\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.ludovicocaldara.net\/dba\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.ludovicocaldara.net\/dba\/wp-json\/wp\/v2\/comments?post=1087"}],"version-history":[{"count":3,"href":"https:\/\/www.ludovicocaldara.net\/dba\/wp-json\/wp\/v2\/posts\/1087\/revisions"}],"predecessor-version":[{"id":1981,"href":"https:\/\/www.ludovicocaldara.net\/dba\/wp-json\/wp\/v2\/posts\/1087\/revisions\/1981"}],"wp:attachment":[{"href":"https:\/\/www.ludovicocaldara.net\/dba\/wp-json\/wp\/v2\/media?parent=1087"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.ludovicocaldara.net\/dba\/wp-json\/wp\/v2\/categories?post=1087"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.ludovicocaldara.net\/dba\/wp-json\/wp\/v2\/tags?post=1087"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}