linuxÏ oracleµÄ°²×°
°²×°×¼±¸£º
ÏÂÔØÎļþ
l Oracle Database 10g Release 2(10.2.0.1) Software
½âѹÎļþ
½âѹÎļþÃüÁ
unzip 10201_database_linux32.zip
½âѹºóµÄÎļþ¼Ð¿ÉÄÜ“database”»ò“db/Disk1”
HostsÎļþ
ÔÚ/etc/hosts ÎļþÖаüº¬Ò»¸öÍêÕûºÏ·¨µÄ·þÎñÆ÷Ãû
<IP-address> <fully-qualified-machine-name> <machine-name>
ÉèÖÃÄں˲ÎÊý
ÔÚ/etc/sysctl.confÖÐÌí¼ÓÒÔÏÂÐУº
#kernel.shmall = 2097152
#kernel.shmmax = 2147483648
kernel.shmmni = 4096
# semaphores: semmsl, semmns, semopm, semmni
kernel.sem = 250 32000 100 128
#fs.file-max = 65536
net.ipv4.ip_local_port_range = 1024 65000
net.core.rmem_default=262144
net.core.rmem_max=262144
net.core.wmem_default=262144
net.core.wmen_max=262144
ÔËÐÐÏÂÃæµÄÃüÁîÓ¦ÓÃÒÔÉÏOS²ÎÊý
/sbin/sysctl -p
Ìí¼ÓÒÔÏÂÐе½/ect/security/limits.confÎļþÖÐ
* soft nproc 2047
* hard nproc 16384
* soft nofile 1024
* hard nofile 65536
Èç¹û/etc/pam.d/loginÎļþÖÐûÓÐÒÔÏÂÐУ¬ÔòÌí¼ÓÒÔÏÂÄÚÈÝ£º
session required /lib/security/pam_limits.so
ÐÞ¸Ä/etc/selinux/configÎļþÀ´¹Ø±Õlinux·À»ðǽ£¬È·±£SELINUXÉèÖÃÈçÏ£º
SELINUX=disabled
¼ì²é°²×°°ü
¼ì²éÊÇ·ñ¾ß±¸ÒÔÏ°²×°°ü£º
make-3.79.1
gcc-3.2.3-34
glibc-2.3.2-95.20
compat-db-4.0.14-5
compat-gcc-7.3-2.96.128
compat-gcc-c++-7.3-2.96.128
compat-libstdc++-7.3-2.96.128
compat-libstdc++-devel-7.3-2.96.128
libXp
openmotif21-2.1.30-8
setarch-1.3-1
²éѯËùÐè°²×°°üÊÇ·ñÍêÕû(ȱÉÙ²¹É¶)
rpm -q gcc make binutils openmotif setarch compat-db compat-gcc compat-gcc
Ïà¹ØÎĵµ£º
oracle±í¿Õ¼ä²Ù×÷Ïê½â
1
2
3×÷Õߣº À´Ô´£º ¸üÐÂÈÕÆÚ£º2006-01-04
5
6
7½¨Á¢±í¿Õ¼ä
8
9CREATE TABLESPACE data01
10DATAFILE '/ora ......
ÓÐÈË×ܽáÁËÊý¾Ý¿âÖÐNullÖµµÄ¸ÅÄ±È½Ï¾«Á¶£¬ÕªÂ¼ÈçÏ£º
NullÊÇÊý¾Ý¿âÖÐÌØÓеÄÊý¾ÝÀàÐÍ£¬µ±Ò»Ìõ¼Ç¼µÄij¸öÁÐΪNull£¬Ôò±íʾÕâ¸öÁеÄÖµÊÇδ֪µÄ¡¢ÊDz»È·¶¨µÄ¡£¼ÈÈ»ÊÇδ֪µÄ£¬¾ÍÓÐÎÞÊýÖֵĿÉÄÜÐÔ¡£Òò´Ë£¬Null²¢²»ÊÇÒ»¸öÈ·¶¨µÄÖµ¡£
ÕâÊÇNullµÄÓÉÀ´¡¢Ò²ÊÇNullµÄ»ù´¡£¬ËùÓк ......
´¥·¢Æ÷ trigger
·ÖÀࣺǰ´¥·¢£¬ºó´¥·¢
Ðд¥·¢Æ÷£¬Óï¾ä´¥·¢Æ÷
Ðд¥·¢Æ÷ÓëÓï¾ä´¥·¢Æ÷µÄÇø±ð£º
Ðд¥·¢Æ÷ÒªÇóµ±Ò»¸ö DML Óï¾ä²Ù×÷Ó°ÏìÊý¾Ý¿âÖеĶàÐÐÊý¾Ýʱ£¬¶ÔÓÚÆäÖеÄÿ¸öÊý¾ÝÐУ¬Ö»ÒªËüÃÇ·ûºÏ´¥·¢Ô¼ÊøÌõ¼þ£¬¾ù¼¤»îÒ»´Î´¥·¢Æ÷,FOR EACH ROW Ñ¡Ïî˵Ã÷´¥·¢Æ÷ΪÐд¥·¢Æ÷£»
Óï¾ä´¥·¢Æ÷ ......
ÔÚOracle8i»òÒÔÉÏ°æ±¾ÖУ¬¿ÉÒÔ´´½¨ÒÔÏÂÁ½ÖÖÁÙʱ±í£º
1¡£»á»°ÌØÓеÄÁÙʱ±í
CREATE GLOBAL TEMPORARY <TABLE_NAME> (<column specification>)
ON COMMIT PRESERVE ROWS£»
2¡£ÊÂÎñÌØÓеÄÁÙʱ±í
CREATE GL ......
Ó¢ÎÄ°æµÄ¿ÉÒÔÓÃlinux channel bonding ËÑË÷µ½£¬ºÜÈÝÒ׵ģ¬²»¹ý·Òë¾Í²»ÄÇôºÃÕÒÁË£¬·ÑÁ˲»ÉÙ¾¢¡£
ÒÔÏÂתÔØ×Ôhttp://fedora.javaeye.com/blog/467584
´Ó¿ªÊ¼·Òëµ½ÏÖÔÚÒѾ¹ýÈ¥Ò»Äê¶àʱ¼äÁË£¬ÆÚ¼äÒ²Óкþü¸ºõûÓÐÓùýbondingÁË£¬Óкܳ¤Ò»¶Îʱ¼äÒѾûÓдòËã°ÑËü¼ÌÐøÏÂÈ¥µÄ¾öÐÄÁË£¬²»¹ý×îºóÖÕÓÚ»¹ÊǾö¶¨ÓÐʼÓÐÖÕ£¬ËäÈ»&rdq ......