Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

°²×°Oracle¼ì²âlinuxÄں˲ÎÊý

Checking kernel parameters
Checking for semmsl=250; found semmsl=250.    Passed
Checking for semmns=32000; found semmns=32000.    Passed
Checking for semopm=100; found semopm=32.    Failed <<<<
Checking for semmni=128; found semmni=128.    Passed
Checking for shmmax=536870912; found shmmax=68719476736.    Passed
Checking for shmmni=4096; found shmmni=4096.    Passed
Checking for shmall=2097152; found shmall=4294967296.    Passed
Checking for file-max=65536; found file-max=88989.    Passed
Checking for VERSION=2.6.9; found VERSION=2.6.18-92.el5xen.    Passed
Checking for ip_local_port_range=1024 - 65000; found ip_local_port_range=32768 - 61000.    Failed <<<<
Checking for rmem_default=262144; found rmem_default=126976.    Failed <<<<
Checking for rmem_max=262144; found rmem_max=131071.    Failed <<<<
Checking for wmem_default=262144; found wmem_default=126976.    Failed <<<<
Checking for wmem_max=262144; found wmem_max=131071.    Failed <<<<
Check complete. The overall result of this check is: Failed <<<<
Problem: The kernel parameters do not meet the minimum requirements (see above).
Recommendation: Perform operating system specific instructions to update the kernel parameters.
ÐÞ¸Ä /etc/sysctl.conf ÄÚºËÅäÖÃÎļþ£¬Ôö¼Ó/ÐÞ¸ÄÒÔÏÂÏîÄ¿£¬ÈçûÓÐ×Ô¼ºÌí¼Ó
 
kernel.shmall = 2097152 # ¿ÉÒÔʹÓõĹ²ÏíÄÚ´æµÄ×ÜÁ¿¡£
kernel.shmmax = 2147483648 # ×î´ó¹²ÏíÄÚ´æ¶Î´óС¡£
kernel.shmmni = 4096 # Õû¸öϵͳ¹²ÏíÄÚ´æ¶ÎµÄ×î´óÊýÄ¿¡£
kernel.sem = 250 32000 100 128 # ÿ¸öÐźŶÔÏ󼯵Ä×î´óÐźŶÔÏóÊý£»ÏµÍ³·¶Î§ÄÚ×î´óÐźŶÔÏóÊý£»Ã¿¸öÐźŶÔÏóÖ§³ÖµÄ×î´ó²Ù×÷Êý£»ÏµÍ³·¶Î§ÄÚ×î´óÐźŶÔÏó¼¯Êý¡£
fs.file-max = 65536 # ϵͳÖÐËùÔÊÐíµÄÎļþ¾ä±ú×î´óÊýÄ¿¡£
net.ipv4.ip_local_port_range = 1024 650


Ïà¹ØÎĵµ£º

Oracle±í¿Õ¼ä¹ÜÀí

extent--×îС¿Õ¼ä·ÖÅ䵥λ --tablespace management
block --×îСi/oµ¥Î»      --segment    management
create tablespace james
datafile '/export/home/oracle/oradata/james.dbf'
size 100M ¡¡¡¡¡¡¡¡¡¡¡¡--³õʼµÄÎļþ´óС¡¡
autoextend On¡¡¡¡¡¡¡¡ --×Ô¶¯Ôö³¤
next 10M¡ ......

linuxÏÂÕÒ²»µ½¶¯Ì¬Á´½Ó¿â


Ô­ÌûµØÖ·:http://hi.baidu.com/tingyu521/blog/item/81a8b75180e4e21f377abedc.html
ÔÚ±àÒëһЩ¿ªÔ´Èí¼þµÄʱºò³£³£»áÓöµ½ÀàËÆÓÚerror while loading shared libraries: libmysqlclient.so µÈÁ´½Ó½Ó¿âÕÒ²»µ½¡£ÄÇÔõô°ìÄØ£¿
×ܵÄÀ´ËµÊÇÓÉÓÚ¿ªÔ´Èí¼þµÄ¶¯Ì¬Á´½Ó¿âûÓзÅÔÚ³ÌÐòѰÕҵĵط½£¬ÓÈÆäÊÇÁ¬¸ö¿ªÔ´Èí¼þÏ໥Э×÷ÔËÐÐµÄ ......

Linuxϰ²×°Óëɾ³ýÈí¼þ

  ÏñʹÓÃWindowsʱÄÇôֱ¹Û¡£ÆäʵÔÚLinuxϰ²×°ºÍÐ¶ÔØÈí¼þÒ²·Ç³£¼òµ¥£¬Í¬ÑùÒ²Óа²×°Ïò
µ¼»ò½âѹ°²×°µÄ·½Ê½£¬²»ÏàͬµÄÖ»²»¹ýÊdzýÁ˶þ½øÖÆÐÎʽµÄÈí¼þ·Ö·¢Í⣬»¹ÓÐÐíÐí¶à¶àÒÔ
Ô´´úÂëÐÎʽ·Ö·¢µÄÈí¼þ°ü£¬ÏÂÃæ¾ÍÀ´ÏêϸµØ½²Ò»½²ÕâЩÈí¼þµÄ°²×°ÓëÐ¶ÔØ£º Ò»¡¢¶þ½øÖÆ·Ö·¢Èí¼þ°üµÄ°²×°ÓëÐ¶ÔØ
LinuxÈí¼þµÄ¶þ½øÖÆ ......

Oracle JOBµÄ½¨Á¢£¬¶¨Ê±Ö´ÐÐÈÎÎñ

begin
  sys.dbms_job.submit(job => :job,
                      what => 'check_err;',
                 ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ