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
Ïà¹ØÎĵµ£º
oracle±í¿Õ¼ä²Ù×÷Ïê½â
1
2
3×÷Õߣº À´Ô´£º ¸üÐÂÈÕÆÚ£º2006-01-04
5
6
7½¨Á¢±í¿Õ¼ä
8
9CREATE TABLESPACE data01
10DATAFILE '/ora ......
£¨L2CAPÐÒé¼ò½é£¬L2CAPÔÚBlueZÖеÄʵÏÖÒÔ¼°L2CAP±à³Ì½Ó¿Ú£©
Ò»£ºL2CAPÐÒé¼ò½é£º
Logical Link Control and Adaptation Protocol(L2CAP)
Âß¼Á¬½Ó¿ØÖƺÍÊÊÅäÐÒé (L2CAP) ΪÉϲãÐÒéÌá¹©ÃæÏòÁ¬½ÓºÍÎÞÁ¬½ÓµÄÊý¾Ý·þÎñ£¬²¢Ìṩ¶àÐÒ鹦ÄܺͷָîÖØ×é²Ù×÷¡£L2CAP ³äÐíÉϲãÐÒéºÍÓ¦ÓÃÈí¼þ´«ÊäºÍ½ÓÊÕ×î´ó³¤¶ÈΪ 64K µÄ L2CAP Ê ......
Oracle developerÒÔÆä¿ìËÙµÄÊý¾Ý´¦Àí¿ª·¢¶øÎÅÃû£¬ÆäÒì³£´¦Àí»úÖÆÒ²ÊDZȽÏÍêÉÆ£¬²»¿ÉСêï¡£
1¡¢ Òì³£µÄÓŵã
Èç¹ûûÓÐÒì³££¬ÔÚ³ÌÐòÖУ¬Ó¦µ±¼ì²éÿ¸öÃüÁîµÄ³É¹¦»¹ÊÇʧ°Ü£¬Èç
BEGIN
SELECT ...
-- check for ’no data found’ error
SELECT ...
-- check for ’no data found’ error
SEL ......
ÖÁ½ñ£¬Linux×ÀÃæÎÊÊÀÒÑÓÐÊ®¸öÄêÍ·£®»Ø¹ËÒÔÍù£¬Ò»ÊÂÎ޳ɣ¬²»¿°»ØÊ×£®´Ë»°Ôõ½²£¿
´óÔ¼ÔÚ10Äêǰ£¬ÃÀ¹úCorel¹«Ë¾×îÔ翪ʼ׷ÇóÒ»¸öÃÎÏ룺ÔÚLinux»ù´¡ÉϸøÓû§Ìṩһ¸ö¹¤×÷×ÀÃæ£¨¼´×îÔçµÄLinux×ÀÃæ£©£¬Õâ¾ÍÊÇCorelµÄWordPerfectÎÄ×Ö´¦Àí³ÌÐò£®¼ÇµÃ£¬´ó¸ÅÔÚ1999ÄêµÄº®¶¬£¬ÔÚ±±¾©Õ¹ÀÀ¹Ý¾Ù°ìµÄÄǴΣ¢±±¾©¹ú ......
±ä³ÉѧϰQTÁË...º¹.
ÖÆ×÷Hello World µ½ ʱÖÓ³ÌÐò ... ×î¶àµÄ»¹ÊÇÊìϤ×é¼þµÄʹÓã¬Ê¹ÓöøÒÑ£¬¹¤¾ß¶øÒÑ£¬´ó²¿·Ö¶¼ÊÇÀ×ͬµÄ£¬ÆäʵÎÒÃÇҪѧµÄ²»¶à£¬Ò²¾ÍÊǺÍVC++ »òÕßBC++²»Í¬µÄ»úÖÆ»òÕßеļ¼ÇÉ¡£×é¼þÓõ½Ê±ºò²é²é¾ÍOK£¬Ã»±ØÒªÏµÍ³µÄѧ£¬ÒòΪÎÒÃÇÓò»Ì«µ½¡£
  ......