Oracle 11g R1 for Linux(RHEL5)°²×°
1
¡¢°²×°Ç°µÄ×¼±¸
1.1
¼ì²éÓ²¼þ
ÎïÀíÄڴ棺
# grep
MemTotal /proc/meminfo
½»»»¿Õ¼ä£º
# grep
SwapTotal /proc/meminfo
½»»»¿Õ¼äµÄ´óСÊǸù¾ÝÎïÀíÄÚ´æµÄ´óСÀ´ÉèÖõģ¬ÎïÀíÄÚ´æÉÙÓÚ
2G
µÄÔò½»»»¿Õ¼äÉèΪÎïÀíÄÚ´æµÄÁ½±¶£¬ÎïÀíÄÚ´æ´óÓÚ
2G
µÄÔò½»»»¿Õ¼äºÍÎïÀíÄÚ´æ´óСһÑù¡£Èç¹û²»·ûºÏÉÏÊö¹æ¶¨£¬ÄÇô¾ÍÐèÒªÖØÐÂÉèÖý»»»¿Õ¼äµÄ´óС¡£ÖØÐÂÉèÖý»»»¿Õ¼äµÄ´óСÓÐÁ½ÖÖ·½·¨£ºÒ»ÖÖÊÇʹÓÃ
fdisk
ɾ³ý½»»»·ÖÇøÖØÐ»®·Ö´óС£»ÁíÒ»ÖÖÊÇ´´½¨Ò»¸öÐÂÎļþ£¬·ÖÅä´óСȻºó¸ñʽ»¯³É½»»»·ÖÇø¡£±¾ÊÖ²áʹÓõڶþÖÖ·½·¨¡£
´´½¨Îļþ£º
# touch /home/swap
·ÖÅä¿Õ¼ä£º
# dd if=/dev/zero of=/home/swap bs=1024
count=4100000
¸ñʽ»¯Îļþ£º
# mkswap /home/swap
Í£Ö¹
swap
£º
# swapoff –a
ʹÓÃ
swap
£º
# swapon /home/swap
×Ô¶¯¹ÒÔØ£º
#
ÔÚ
etc/fstab
¡¡Àï¼ÓÈëÒÔÏÂÒ»ÐУº
/home/swap swap
swap default 0 0
´ÅÅ̿ռ䣺
# df –ah
Oracle 11g
°²×°ËùÐèµÄ´ÅÅ̿ռäΪ
1.7G
£¬Èç¹û²»¹»µÄ»°µÃÁíÍâÌí¼Ó¡£
1.2
Èí¼þ°ü¼ì²é
¼ì²éÏÂÁаüÊÇ·ñ°²×°£¬Èç¹ûδ°²×°ÔòÒªÏȰ²×°¡£
# rpm -qa | grep make gcc glibc
µÈµÈ
binutils-2.17.50.0.6-2.el5
compat-libstdc++-33-3.2.3-61
elfutils-libelf-0.125-3.el5
elfutils-libelf-devel-0.125
glibc-2.5-12
glibc-common-2.5-12
glibc-devel-2.5-12
gcc-4.1.1-52
gcc-c++-4.1.1-52
libaio-0.3.106
libaio-devel-0.3.106
libgcc-4.1.1-52
libstdc++-4.1.1
libstdc++-devel-4.1.1-52.e15
make-3.81-1.1
sysstat-7.0.0
unixODBC-2.2.11
unixODBC-devel-2.2.11
1.3
ÏÂÔØÈí¼þ
ÕâÀïÐèҪעÒâµÄÓÐÁ½µã£ºÒ»ÊÇŪÇå³þ·þÎñÆ÷ÊÇ
32
λµÄ»¹ÊÇ
64
λ£»¶þÊDz»ÒªÏÂÔØ
Oracle 11gR2
£¬
R2
²»Äܹ»ÔÚ
RHEL5
Éϰ²×°¡£²»ÒªÐÁÐÁ¿à¿àµÄÏÂÔØÏÂÀ´£¬È´·¢ÏÖ°æ±¾²»¶Ô£¬ÄǾÍ×öÁ˺ܶàÎÞÓù¦ÁË¡£
Oracle Database Software Downloads
£º
http://www.oracle.com/technology/software/products/database/index.html
2
¡¢°²×°»·¾³ÉèÖÃ
2.1
ºËÐIJÎÊýÉèÖÃ
ÔÚ
/etc/sysctl.conf
ÎļþÖмÓÈëÏÂÁÐÐУº
kernel.shmall = 2097152
kernel.shmmax = 2147483648
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
fs.file-max = 65536
Ïà¹ØÎĵµ£º
£¨L2CAPÐÒé¼ò½é£¬L2CAPÔÚBlueZÖеÄʵÏÖÒÔ¼°L2CAP±à³Ì½Ó¿Ú£©
Ò»£ºL2CAPÐÒé¼ò½é£º
Logical Link Control and Adaptation Protocol(L2CAP)
Âß¼Á¬½Ó¿ØÖƺÍÊÊÅäÐÒé (L2CAP) ΪÉϲãÐÒéÌá¹©ÃæÏòÁ¬½ÓºÍÎÞÁ¬½ÓµÄÊý¾Ý·þÎñ£¬²¢Ìṩ¶àÐÒ鹦ÄܺͷָîÖØ×é²Ù×÷¡£L2CAP ³äÐíÉϲãÐÒéºÍÓ¦ÓÃÈí¼þ´«ÊäºÍ½ÓÊÕ×î´ó³¤¶ÈΪ 64K µÄ L2CAP Ê ......
1£® ½âÊÍFUNCTION£¬PROCEDUREºÍPACKAGEÇø±ð
´ð£ºfunction ºÍprocedureÊÇPL/SQL´úÂëµÄ¼¯ºÏ£¬Í¨³£ÎªÁËÍê³ÉÒ»¸öÈÎÎñ¡£procedure ²»ÐèÒª·µ»ØÈκÎÖµ¶øfunction½«·µ»ØÒ»¸öÖµÔÚÁíÒ»·½Ã棬PackageÊÇΪÁËÍê³ÉÒ»¸öÉÌÒµ¹¦ÄܵÄÒ»×éfunctionºÍprocedureµÄ¼¯ºÏ¡£
2£® ȡij¸öÐòÁеĵ±Ç°ÖµµÄPL/SQLÓï ......
Oracle developerÒÔÆä¿ìËÙµÄÊý¾Ý´¦Àí¿ª·¢¶øÎÅÃû£¬ÆäÒì³£´¦Àí»úÖÆÒ²ÊDZȽÏÍêÉÆ£¬²»¿ÉСêï¡£
1¡¢ Òì³£µÄÓŵã
Èç¹ûûÓÐÒì³££¬ÔÚ³ÌÐòÖУ¬Ó¦µ±¼ì²éÿ¸öÃüÁîµÄ³É¹¦»¹ÊÇʧ°Ü£¬Èç
BEGIN
SELECT ...
-- check for ’no data found’ error
SELECT ...
-- check for ’no data found’ error
SEL ......
Ð¶ÔØMysql
[root@localhost ~]# rpm -qa | grep mysql
mysql-3.23.58-9
php-mysql-4.3.4-11
mod_auth_mysql-20030510-4.1
mysql-server-3.23.58-9
˵Ã÷£ºrpm –qa | grep mysql ÃüÁîÊÇΪÁ˰ÑmysqlÏà¹ØµÄ°ü¶¼ÁгöÀ´£¬Ð¶Ôض¼´Ó×îÏÂÃæµÄÒ»¸ö°ü¿ªÊ¼£¬Ö±µ½Ð¶ÔصôµÚÒ»¸öΪֹ¡£Ö´ÐÐrpm -q php£¬Èç¹û·µ»Øphp°æ±¾£¬ ......
1.°²×°VM£¬¾ÍÊÇ´«ËµÖеÄvirtual machineÀ²¡£
£¨ÕâÀï²»Ïêϸ½²½âVMµÄ°²×°ÁË£¬¾Í°´ÕÕÒ»°ã³ÌÐò°²×°¾Í¿ÉÒÔÁË¡££©
2.ÔÚVMÖа²×°ÐéÄâϵͳ¡£
2-1.н¨Ò»¸öÐéÄâ»ú£¬²¢ÔÚµ¯³öµÄ¶Ô»°¿òÖÐÑ¡Ôñ¾µä£¨Ò²¿ÉÒÔÑ¡Ôñ×Ô¶¨Ò壩¡£"next"¡£
  ......