9 07, 2007

±È½Ïº±¼ûµÄÒ»¸öÎÊÌ⣬´ÅÅÌÎļþÊýĿ̫¶àµ¼ÖµÄLISTENER¼àÌýÆð²»À´

ÎÊÌâÌá³ö£º
һ̨²âÊԵķþÎñÆ÷£¬Í£µçÔÙÆðÀ´ºó·¢ÏÖlistenerÆð²»À´£¬±¨´íÈçÏ£º
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.191.100)(PORT=1521)))
Error listening on: (ADDRESS=(PROTOCOL=ipc)(PARTIAL=yes)(QUEUESIZE=1))
No longer listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.191.100)(PORT=1521)))
TNS-12549: TNSperating system resource quota exceeded
TNS-12560: TNSrotocol adapter error
TNS-00519: Operating system resource quota exceeded
Linux Error: 28: No space left on device


Ê×ÏȲ鿴logÎļþ£¬ÒѾ­2GÁË£¬´ò¿ª¿´¿´ÈÕÖ¾ÀïÃæÒ²Ã»·¢ÏÖʲôÒì³££¬ÈÏΪÈÕÖ¾ÊÇ×ÔÈ»Ôö³¤µ½Õâô´óµÄ£¬ÓÚÊÇÖ±½Ócat /dev/null>listener.log°ÑÈÕÖ¾Çå¿Õ¡£È»ºólistener»¹ÊÇÆð²»À´£¬ÈÔÈ»±¨ÉÏÃæµÄ´íÎó¡£Ö®ºóÖØÆô»úÆ÷£¬»¹ÊDz»ÐУ¬¼ì²é´ÅÅ̿ռ䣺
oracle@test-db1 admin]$ df -h
Filesystem Size Used Avail Use% Mounted on
/dev/sdb2 4.9G 1.9G 2.7G 42% /
/dev/sdb1 99M 15M 79M 16% /boot
/dev/sdb7 1012M 493M 468M 52% /home
/dev/sdb8 61G 41G 18G 71% /opt
none 1000M 0 1000M 0% /dev/shm
/dev/sdb5 2.0G 33M 1.9G 2% /tmp
/dev/sdb6 1012M 606M 355M 64% /var
/dev/sda1 34G 14G 19G 43% /
oracle°²×°ÔÚ/optĿ¼£¬ÉÏÃæ»¹ÓÐ18¸öGµÄ¿Õ¼ä£¬¶øÇÒÿ¸ö´ÅÅ̿ռ䶼ºÜ¶à¡£²é¿´processÏÞÖÆ£¬top·¢ÏÖϵͳ²Å¿ªÁË50¸öprocess£¬¶ø¶ÔoracleµÄÏÞÖÆÊÇ2048¸ö¡£ÔÚpubµÄ·¢Ìû£¬µØÖ·ÈçÏ£º
http://www.itpub.net/showthread.php?s=&threadid=809058&perpage=10&pagenumber=1
һֱûÓнâ¾ö£¬ºóÀ´Í¨ÖªÍ¬ÊÂÓÐÕâ¸öÎÊÌâ´æÔÚ¡£ÖÜÒ»Éϰ࣬ͬÊÂ˵Õâ¸öÎÊÌâÒѾ­±»Ëû½â¾öÁË£¬²¢ÍƼöһƪÎÄÕ¸øÎÒ£¬µØÖ·ÈçÏ£º
http://www.zeali.net/entry/480
ժ¼һ²¿·Ö£º
Linux/Unix like OS µÄÎļþϵͳÖÐÿ¸öĿ¼Ê÷ÖеĽڵ㲢²»ÊÇÏñ Windows ÄÇÑùÖ±½Ó°üº¬ÎļþµÄ¾ßÌåÐÅÏ¢£¬¶øÖ»°üº¬ÁËÎļþÃûºÍ Inode number ¡£Í¨¹ý Inode number ËùÕÒµ½¶ÔÓ¦ÓÚÎļþÃûµÄ Inode ½ÚµãÖвÅÕæÕý¼Ç¼ÁËÎļþµÄ´óС/ÎïÀíµØÖ·/ËùÓÐÕß/·ÃÎÊȨÏÞ/ʱ¼ä´Á/±»Ó²Á´½ÓµÄ´ÎÊýµÈʵ¼ÊµÄ metadata ¡£Òò´ËÄã¿ÉÒÔÔÚ Linux ϵͳÖÐͨ¹ýÓ²Á´½Ó( hard link ) µÄ·½Ê½¸øÄ³¸öÎļþ´´½¨ÎÞÊý¸öλÓÚ²»Í¬Ä¿Â¼ÏµÄÎļþÃû£¬¶øÊµ¼ÊµÄÎļþÊý¾ÝÖ»ÐèÒªÒ»·Ý¿½±´¡£µ«Ò²ÕýÒòΪÕâÖÖÎļþϵͳµÄ½á¹¹£¬µ±ÄãÔÚ Linux ÖнøÐÐ IO ²Ù×÷µÄʱºò£¬ÐèÒªµÄ×ÊÔ´³ýÁË´ÅÅ̿ռäÒÔÍ⣬»¹ÒªÓÐÊ£ÓàµÄ Inode ²ÅÐС£È±Ê¡Çé¿öÏ£¬ Linux ÔÚϵͳ°²×°¹ý³ÌÖа´ÕÕ1¸ö Inode ¶ÔÓ¦ 2k ´ÅÅ̿ռäÀ´¼ÆËãÿ¸ö·ÖÇøµÄ×î´ó Inode Êý¡£Ò»µ©Îļþϵͳ´´½¨Ö®ºó£¬Ã¿¸ö·ÖÇø¿ÉÓà Inode Êý¾ÍÎÞ·¨½øÐж¯Ì¬µ÷Õû¡£Õý³£À´Ëµ£¬Ò»°ã²»Ì«»á³öÏÖij¸ö·ÖÇøµÄ Inode ºÄ¾¡¶ø´ÅÅ̿ռäÉÐÓàµÄÇé¿ö£¬³ý·ÇÏñÎÒÅöµ½µÄÕâÑùÀ¬»øÐ¡Îļþ·è³¤¶øÓÖû½øÐÐÓÐЧµÄÇåÀí¡£µ«Èç¹ûȷʵÐèÒªµÄ»°£¬¿ÉÒÔÔÚ´´½¨Îļþϵͳ£¨±ÈÈçÓà mke2fs £©µÄʱºò¸ù¾Ýʵ¼ÊÐèÒªÀ´µ÷ÕûÕâ¸ö²ÎÊý£¨±ÈÈç·ÖÇøÈç¹ûÓÃÓÚ´æ·Å³¬´óÊÓÆµÎļþµÄ»° Inode µÄÊýÁ¿¿ÉÒÔÉÙһЩ£»Èç¹û´òËã´æ·ÅµÄÎļþÊÇ´óÁ¿Ð¡ÓÚ 2k µÄÃÔÄãÎļþµÄ»°¾ÍÒª¿¼ÂǶഴ½¨Ò»Ð© Inode£©¡£
ʹÓÃdf -iÃüÁî¿ÉÒÔ¿´µ½Ã¿¸ö·ÖÇøµÄ×ÜinodeÊýÄ¿ºÍ±»Ê¹ÓõÄÒÔ¼°¿ÕÏеÄinodeÊýÄ¿£º
[root@test-db1 log]# df -i
Filesystem Inodes IUsed IFree IUse% Mounted on
/dev/sdb2 640000 115018 524982 18% /
/dev/sdb1 26104 40 26064 1% /boot
/dev/sdb7 131616 409 131207 1% /home
/dev/sdb8 8077312 168316 7908996 3% /opt
none 255900 1 255899 1% /dev/shm
/dev/sdb5 262144 182 261962 1% /tmp
/dev/sdb6 131616 1500 130116 2% /var
/dev/sda1 4447744 117 4447627 1% /u01
ÉÏÃæµÄ½á¹ûÊÇͬÊÂÒѾ­´¦ÀíºóµÄ½á¹û£¬Ô­ÒòÊÇ/varµÄÒ»¸ö×ÓĿ¼Ï²úÉúºÜ¶àºÜСµÄÎļþ£¬É¾³ýºó»Ö¸´Õý³££¬listener¿ÉÒÔÕý³£ÆðÀ´ÁË¡£
¼ÌÐø×öÏÂÃæÒ»¸öÊÔÑ飺
Ê×ÏÈÕÒµ½Ò»¸ö´óСΪ200¶àkµÄ²âÊÔÎļþ
[root@localhost test]# ll
total 208
-rw-r--r-- 1 root root 206305 Mar 8 10:28 test.log
È»ºó²é¿´/usrµÄinodeʹÓÃÇé¿ö
[root@localhost test]# df -i
Filesystem Inodes IUsed IFree IUse% Mounted on
/dev/sda6 525888 98096 427792 19% /usr
È»ºó°Ñtest.log·Ö¸î³Éÿ¸ö×Ö½ÚÒ»¸öÎļþ£¬splitµÄʹÓ÷½·¨¿ÉÒԲο¼£ºhttp://zhang41082.itpub.net/post/7167/289531
[root@localhost test]# split -a 10 -b 1 test.log
ͳ¼Æ·Ö¸îºóµÄ×ÜÎļþÊýÄ¿£¬±Ètest.logµÄÎļþ´óС206305¶àÁËÁ½¸ö£¬Õâ¸öÒ»¸öÊÇÒòΪtest.logÎļþ±¾ÉíÕ¼Ò»¸ö£¬»¹ÓоÍÊÇͳ¼ÆµÄ·µ»Ø½á¹ûÕ¼Ò»ÐУ¬ËùÒÔ¿´µ½Îļþ±»³É¹¦·Ö¸îΪ206305¸ö¡£
[root@localhost test]# ll | wc -l
206307
²é¿´inodeʹÓÃÇé¿ö
[root@localhost test]# df -i
Filesystem Inodes IUsed IFree IUse% Mounted on
/dev/sda6 525888 304401 221487 58% /usr
¿ÉÒÔ¿´µ½£¬inodeÔö¼ÓÁË304401-98096=206305¸ö¡£È»ºó°Ñtest.logÖØÃüÃûΪtest1.log£¬ÖØÐ·ÖÁÑ
[root@localhost test]# split -a 10 -b 1 test1.log z
[root@localhost test]# ll|wc -l
412612
[root@localhost test]# df -i
Filesystem Inodes IUsed IFree IUse% Mounted on
/dev/sda6 525888 510706 15182 98% /usr
inodeÒѾ­Ê¹ÓÃÁË98%ÁË£¬ÔÙÖØ¸´Ò»´Î
[root@localhost test]# mv test1.log test2.log
[root@localhost test]# split -a 10 -b 1 test2.log y
split: yaaaaaaawly: No space left on device
¿ÉÒÔ¿´µ½£¬½øÐе½Ò»°ëµÄʱºòÒѾ­²»ÄܶÔÎļþÔÙ½øÐзָîÁË£¬¶ø´íÎóÌáʾҲÒѾ­³öÏÖ No space left on device¡£

×ܽ᣺ÕâÀà´íÎóÊDZȽÏÉÙ¼ûµÄ´íÎó£¬ÓÐʱºòoracleµÄbug»òÕ߯äËûÔ­Òò»áµ¼ÖÂij¸öĿ¼µÄtraceÎļþÊýÄ¿·è³¤£¬Õâʱºò¾ÍҪСÐÄÕâ¸öÎÊÌâÁË£¬Òò´ËÈÕ³£µÄϵͳ¼à¿Ø³ýÁËÒª¼à¿Ø´ÅÅ̿ռäµÄ´óС£¬¶ÔinodeµÄʹÓÃÇé¿öÒ²Ó¦¸Ã½øÐÐ¼à¿Ø¡£
´ÓÕâ¸öÎÊÌâ¿ÉÒÔ¿´³ö£¬²Ù×÷ϵͳµÄ֪ʶ¶àÃ´ÖØÒª£¬¸ÐлzealµÄÎÄÕ£¬¸ÐлͬÊÂÌṩÁËÕâÆªÎÄÕ¡£

ºóÐøºÍ²¹³ä£º

½ñÌì¿´µ½pubÉÏeygle¸ø³öÁ˸üºÏÀíµÄ½âÊÍ£¬·ÅÔÚÕâÀï×÷Ϊ²¹³ä¡£

Ϊʲô/varĿ¼µÄinodeÂúÁË»áÓ°Ïìµ½×°ÔÚ/optĿ¼µÄoracle²»ÄÜÆô¶¯ÄØ£¿Ô­À´listenerÆô¶¯µÄʱºò»áÔÚ/var/tmpĿ¼ÏµÄ.oracleÒþ²ØÄ¿Â¼Ï´´½¨Á½¸öÁÙʱÎļþ£º

[oracle@stream .oracle]$ ll
total 0
srwxrwxrwx 1 oracle oinstall 0 Feb 5 05:49 s#4036.1
srwxrwxrwx 1 oracle oinstall 0 Feb 5 05:49 s#4036.2
srwxrwxrwx 1 oracle oinstall 0 Apr 20 04:26 s#5332.1
srwxrwxrwx 1 oracle oinstall 0 Apr 20 04:26 s#5332.2
srwxrwxrwx 1 oracle oinstall 0 Jan 22 21:53 s#7306.1
srwxrwxrwx 1 oracle oinstall 0 Jan 22 21:53 s#7306.2
srwxrwxrwx 1 oracle oinstall 0 Jan 13 04:21 s#9611.1
srwxrwxrwx 1 oracle oinstall 0 Jan 13 04:21 s#9611.2

¿ÉÒÔ¿´µ½Õâ¸öÁÙʱÎļþȷʵÊdzɶԳöÏֵġ£

×îлظ´