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

Linux(Centos5.4)Éϰ²×°oracle10gR2(10.2.1)

http://www.puschitz.com/InstallingOracle10g.shtml
ÎÒÓõÄÊÇCentos5.4
DVD¹âÅ̰²×°µÄlinux²Ù×÷ϵͳ£¬°²×°linuxµÄʱºòÑ¡ÉÏ¿ª·¢¹¤¾ß£¬Xmanager,ÓëÊý¾Ý¿âÏà¹ØµÄ°ü¡£
²Ù×÷ϵͳ°²×°Íê³ÉÖ®ºóÐèÒª½øÐÐһϵÁеÄÅäÖòÅÄܰ²×°oracle10g£¬ÏÂÃæ°Ñ
Ö÷Òª²½Öè¼Ç¼ÏÂÀ´¡£
1.°²×°Íê²Ù×÷ϵͳ֮ºó»¹ÊÇÓÐЩ°üûÓа²×°£¬È»¶ø°²×°oracle10gµÄʱºò
ÐèÒªÓõ½£¬Ã»Óа²×°µÄ°üÓÐ:
libXp-1.0.0-8.i386.rpm  
openmotif-2.3.0-0.3.el5.i386.rpm
compat-db-4.2.52-5.1.i386.rpm
ps
ÒÀÀµµÄ°üÓУº
      £±£®binutils-2.17.50.0.6-12.el5
¡¡¡¡£²£®compat-db-4.2.52-5.1
¡¡¡¡£³£®control-center-2.16.0-16.el5
¡¡¡¡£´£®gcc-4.1.2-46.el5_4.1
¡¡¡¡£µ£®gcc-c++-4.1.2-46.el5_4.1
¡¡¡¡£¶£®glibc-2.5-42
¡¡¡¡£·£®glibc-common-2.5-42
¡¡¡¡£¸£®libstdc++-4.1.2-46.el5_4.1
¡¡¡¡£¹£®libstdc++-devel-4.1.2-46.el5_4.1
¡¡¡¡£±£°£®make-3.81-3.el5
¡¡¡¡£±£±£®pdksh-5.2.14-36.el5
¡¡¡¡£±£²£®sysstat-7.0.2-3.el5
¡¡¡¡£±£³£®libaio-0.3.106-3.2
¡¡¡¡£±£´£®openmotif22-2.2.3-18
¡¡¡¡£±£µ£®libXp-1.0.0-8.1.el5
2.Ìí¼Ó×éºÍÓû§
groupadd
dba                     --´´½¨dba×é
groupadd
oinstall                --´´½¨oinstall×é
useradd -g oinstall -G dba
-m oracle
-g±íʾ
oracleÓû§ÊôÓÚoinstall×飬Ҳ¾ÍÊÇÇ°Ãæ´´½¨µÄoinstall×é
-G±íʾ
oracleµÄ¸½¼Ó×éΪdba,Ò²¾ÍÊÇÇ°Ãæ´´½¨µÄdba×é
-m±íʾ×Ô¶¯´´½¨
oracleÓû§µÄµÇÈëĿ¼
passwd oracle --¸øoracle´´½¨ÃÜÂë
ÐèÒªÁ¬ÐøÊäÈëÁ½´Î
3.´´½¨°²×°Ä¿Â¼ºÍÊÚÓèȨÏÞ
mkdir -p
/u01/app/oracle         --´´½¨ORACLE_BASEĿ¼,ÎÒÊǽ«/u01/app/oracleµ¥¶À¹ÒÔÚµ½Ò»¸ö´ÅÅÌ
chown -R oracle.oinstall 
/u01   --ÈÃoracleÓû§³ÉΪ/u01µÄÓµÓÐÕß
4.ÔÚ/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


Ïà¹ØÎĵµ£º

ÔÚlinuxÏÂʵÏÖweb qqµÄ×ÀÃæ»¯


´´½¨×ÀÃæÍ¼±ê
Ŀǰ½«ÍøÂçÓ¦ÓÃÀ©Õ¹µ½×ÀÃæÊÇÒ»¸öÇ÷ÊÆ£¬´æÔÚןܶà½â¾ö·½°¸£¬±¾ÎÄÒÔ Mozilla Prism ΪÀý£¬ÀàËÆµÄ·½·¨Í¬ÑùÊÊÓÃÓÚ Google Chrome ¡£
1. µ½ Mozilla Prism µÄÍøÕ¾ÉÏÏÂÔØ Prism£¬µã»÷ Download Now Ö®ºó»áÌáʾÓÐÁ½ÖÖ£¬Ò»ÖÖÊÇÒÔ Mozilla Firefox À©Õ¹µÄ·½Ê½£¬ÊʺÏÒѾ­°²×°ÓÐ Firefox µÄÅóÓÑ£»Ò»Ö ......

oracle hintÖÐordered ºÍleadingÔ­ÀíºÜºÃµÄÌû×Ó

ÎÊÌ⣺Çë½ÌHINTд·¨
ÎÒÓÐÒ»¸öSQLÌí¼ÓÈçÏÂhint,Ä¿µÄÊÇÖ¸¶¨hash_join·½Ê½¡£
select /*+ordered use_hash(a,b,c,d) */ *
from a,b,c,d
Where ...
ÆäÖÐ,
      aÖ»ÓëbÓйØÁª¹ØÏµ£¬bÖ»ÓëcÓйØÁª¹ØÏµ£¬bÖ»ÓëcÓйØÁª¹ØÏµ,cÖ»ÓëdÓйØÁª¹ØÏµ£¬
    ÊýÁ¿¼¶£ºa:1000Ìõ,  b:100 ÍòÌõ£¬ ......

oracleѧϰ±Ê¼Ç2

ʹÓÃunrecoverable´´½¨±í
create table new_emp as select * from emp unrecoverable;
create table new_emp as select * from emp nologging; 
ÍÆ¼öʹÓÃlogging»òÕßnologging.
½«±íÒÆ¶¯µ½ÐµÄÊý¾Ý¶Î»òеıí¿Õ¼ä
ͨ¹ýÒÆ¶¯À´ÊµÏÖ´æ´¢²ÎÊýµÄÐÞ¸Ä
alter table emp move storage(initial 1m next 512k mimexte ......

ʹÓÃbusybox×öÒ»¸öСÇɵÄlinux²Ù×÷ϵͳ

1.»ù´¡ÖªÊ¶
Ò»¸ö²Ù×÷ϵͳ¿ÉÒÔ¼òµ¥µÄ³éÏóΪ£¬Òýµ¼³ÌÐò ÄÚºË Îļþϵͳ¡£
vmlinuzÊÇLinux Äں˵ľµÏñÎļþ,¿ÉÒÔ±»Òýµ¼³ÌÐò¼ÓÔØ,´Ó¶øÆô¶¯Linuxϵͳ¡£
initrdµÄÈ«³ÆÊÇboot loader initialized RAM disk£¬ËüÊÇϵͳÆô¶¯Ê±ËùʹÓõĸùÎļþϵͳӳÏñÎļþ£¬Õâ¸öÎļþϵͳÖаüº¬¼¸¸öÇý¶¯Ä£¿é£¬ÓÃÀ´×°ÔØÊµ¼ÊµÄ¸ùÎļþϵͳ£¬±ÈÈçÒ»¸öIDE»òS ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ