Æí¸®ÇÑ È£½ºÆÃ ¹Ì¼ÒIDC

   
 
 
 

      1Â÷ ³×ÀÓ¼­¹ö :
      ns1.misoidc.com
      101.79.73.101

      2Â÷ ³×ÀÓ¼­¹ö :
      ns2.misoidc.com
      101.79.73.105

      ¾îÁ¦ : 441 ,¿À´Ã : 175
      Àüü : 1,332,968


     

 

 
ÀÛ¼ºÀÏ : 12-05-14 10:05
ORA-00020: maximum number of processes (%s) exceeded
 ±Û¾´ÀÌ : ½ÑÀ¥È£½ºÆÃ
Á¶È¸ : 25,826  

¿¡·¯¸Þ¼¼Áö

ORA-00020: ÃÖ´ë ÇÁ·Î¼¼½º (%s) ¼ö¸¦ ÃʰúÇß½À´Ï´Ù

ORA-00020: maximum number of processes (100)

¿øÀÎ

1. ÇÁ·Î±×·¥ ³»¿¡¼­ Connection À» Close ÇØÁÖÁö ¾Ê¾Æ¼­ ¿À¶óŬ ÇÁ·Î¼¼½º°¡ °è¼Ó Áõ°¡.

2. init.oraÆÄÀÏÀÇ processesÆÄ¶ó¹ÌÅÍ¿¡¼­ Á¤ÇØÁø ÇÁ·Î¼¼½º °³¼ö°¡ ÃʰúµÊ.

ÇØ°á¹æ¹ý

1. ÇÁ·Î±×·¥ ³»¿¡¼­ Close µÇÁö ¾ÊÀº ºÎºÐÀÌ ÀÖ´ÂÁö È®ÀÎ.

2. $ORACLE_HOME/pfile/init.ora ¿¡¼­ processes ÆÄ¶ó¹ÌÅÍ °ªÀ» ´Ã·Á ÁÜ.


*½ÇÁ¦ Session È®ÀÎ

SQL> show parameter sessions

SQL> show parameter processes


SQL> select * from v$license;

SQL> select * from v$resource_limit;


SQL> select count(1) from V$SESSION;


SQL> select machine,osuser,program,count(1)

from V$SESSION

group by machine,osuser,program

order by machine,osuser,program;


SQL> select * from V$SESSION;



 
 

Total 78
¹øÈ£ Á¦   ¸ñ ±Û¾´ÀÌ ³¯Â¥ Á¶È¸
18 ¸®´ª½º¿¡¼­ ¼Ò½ºÄÄÆÄÀÏÀ» ÀÌ¿ëÇÑ Trac, Subversion ¼³Ä¡ ¿Ïº® °¡¡¦ (1) ½ÑÀ¥È£½ºÆÃ 05-10 154866
17 ORA-00020: maximum number of processes (%s) exceeded ½ÑÀ¥È£½ºÆÃ 05-14 25827
16 memcached Cacti Template ½ÑÀ¥È£½ºÆÃ 05-17 151290
15 rsyslog + LogAnalyzer ½ÑÀ¥È£½ºÆÃ 05-21 89617
14 backuppc ¼Ò½º¼³Ä¡ Çϱâ (1) ½ÑÀ¥È£½ºÆÃ 06-11 72738
13 ·¹ÀÌ¾î ÆË¾÷ - ´Ý±â&¿À´Ã ÇÏ·ç ¿­Áö ¾Ê±â ½ÑÀ¥È£½ºÆÃ 06-12 56057
12 PHP ¿Í MongoDB »ç¿ë¹ý ½ÑÀ¥È£½ºÆÃ 07-27 325756
11 mysql Replicating ½ÑÀ¥È£½ºÆÃ 10-31 50516
10 centos 6.2 oracle 10g ¼³Ä¡ (2) ½ÑÀ¥È£½ºÆÃ 12-17 419832
9 MSSQL¿¡¼­ DB º¹¿ø ÈÄ »ç¿ëÀÚ¿¡ ·Î±×ÀÎÀ̸§ÀÌ ¾ø¾î ¿À·ù°¡ ³ª´Â ¡¦ ½ÑÀ¥È£½ºÆÃ 02-19 28163
8 MSSQL _Log.LDF ÆÄÀÏ »çÀÌÆ® Ä¿Á³À»¶§ Á¤¸®ÇÏ´Â ¹æ¹ý ½ÑÀ¥È£½ºÆÃ 02-20 27172
7 [Àåºñ] OmniSwitch 6850-24x L2/L3 ½ºÀ§Ä¡ ¼³Á¤ ½ÑÀ¥È£½ºÆÃ 03-05 175216
6 The 5 minute DBA: Default My.cnf File ½ÑÀ¥È£½ºÆÃ 03-06 94203
5 [Linux] Çϵå¿þ¾î Á¤º¸ È®ÀÎÇϱâ - dmidecode, lshw ½ÑÀ¥È£½ºÆÃ 03-06 305180
4 MS-SQL ¸®Çø®ÄÉÀÌ¼Ç (º´ÇÕº¹Á¦) Å×À̺í Ãß°¡ ¹æ¹ý ½ÑÀ¥È£½ºÆÃ 05-09 38407
 1  2  3  4  5  6