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
Ïà¹ØÎĵµ£º
ÏÖÔÚµÄÏîÄ¿±È½Ï½ô£¬¼ÓÉÏ×Ô¼ºÒ²±È½ÏÀÁ£¬ÊµÔÚÊǓûʱ¼ä”д°¡£¬ºÇºÇ£¬×òÌì¿´µ½Ò»ÆªÍ¦ºÃµÄOracle´æ´¢¹ý³ÌµÄÀý×Ó£¬ÕýºÃ×î½üÒªÓã¬×ª¹ýÀ´´ó¼ÒÒ»Æð·ÖÏíһϣ¬Ð»Ð»£¨³¿¹âӳϼ£©£¬Ô×÷µØÖ·£ºhttp://blog.csdn.net/xuyabao/archive/2008/03/20/2200205.aspx¡£
--------------------×Ô¶¨Ò庯Êý¿ªÊ¼-------------- ......
²©Ñå¿Æ¼¼Oracle erpÃâ·Ñ½²×ù
×÷ΪOracle¹«Ë¾¹Ù·½ÊÚȨÅàѵ»ú¹¹£¬²©ÑåOracle erpרҵÈÏ֤ר¼Ò¿Î³ÌÔÚ±±¾©¡¢ÉϺ£Í¬²½¿ªÕ¹Oracle erpÅàѵ¿Î³Ì¡£
Oracleµç×ÓÉÌÎñÌ×¼þ R12 ²ÆÎñÓ¦ÓÃÈí¼þÄܹ»×Ô¶¯»¯²¢¼ò»¯¿Í»§µÄ²ÆÎñÒµÎñÁ÷³Ì£¬°ïÖúÆóÒµ»ñµÃÆóÒµ·¶Î§ÄÚµÄÈÕ³£ÉÌÎñÖÇÄÜ£¬´Ó¶ø×ö³ö¸üÃ÷Öǵľö²ß¡¢¸Ä½øÔËÓª²¢½ÚÔ¼³É±¾¡£Í³Ò»µÄÊý¾ÝÄ£ÐÍÎªË ......
ʹÓÃ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 ......
ÎÒÕâÀï˵µÄioctlº¯ÊýÊÇÔÚÇý¶¯³ÌÐòÀïµÄ£¬ÒòΪÎÒ²»ÖªµÀ»¹ÓÐûÓбðµÄ³¡ºÏÓõ½ÁËioctl£¬ ËùÒԾ͹涨ÁËÎÒÃÇÌÖÂ۵ķ¶Î§¡£ÎªÊ²Ã´ÒªÐ´ÆªÎÄÕÂÄØ£¬ÊÇÒòΪÎÒÇ°Ò»Õó×Ó±»ioctl¸ø¸ã»ìÁË£¬Õ⼸Ìì²ÅŪÃ÷°×Ëü£¬ÓÚÊÇÔÚÕâÀïÇåÀíÒ»ÏÂÍ·ÄÔ¡£
Ò»¡¢ ʲôÊÇioctl¡£
ioctlÊÇÉ豸Çý¶¯³ÌÐòÖжÔÉ豸µÄI/OͨµÀ½øÐйÜÀíµÄº¯Êý¡£Ëùν¶ÔI/OͨµÀ½øÐйÜÀí£ ......
gnome: µãÓÒ¼ü---new Launcher£¬ÊäÈë¿ì½Ý·½Ê½µÄÃû³Æ£¬²¢Ñ¡ÔñÖ´ÐеijÌÐò¼´¿É¡£
kde: ÓÒ¼üµ¥»÷×ÀÃæµÄ¿Õ°×´¦£¬ÔÚµ¯³öµÄ¶Ô»°¿òÖÐÑ¡“н¨£Ó¦ÓóÌÐòÁ´½Ó”¡£ÔÙÔÚµ¯³öµÄ´°¿ÚÖеã“Ö´ÐД£¬ÔÚÃüÁîÀ¸ÖеãºóÃæµÄä¯ÀÀ¼ü£¬ÕÒµ½ÏàÓ¦µÄ³ÌÐò¡£Ôٵ㓳£¹æ”£¬½øÐÐÈ¡Ãû¡¢¸ü¸Äͼ±êµÈ²Ù×÷£¬×îºóµãÈ·¶¨£¬ÕâÑù ......