ÔÚ64λLinux»·¾³Ï°²×°OracleÊý¾Ý¿â10g
¾¹ýÊýÌ첻иµÄŬÁ¦£¬LINUXÀú¾¡Èý´ÎÖØ×°£¬ORACLEÖØ×°N´ÎÖÕÓÚÔÚLiNUXAS4 update6 x86_64 Ï°²×°ºÃORACLE10g R 2 (64λ) ÁË¡£
ÏÂÃæ°Ñ°²×°¹ý³ÌºÍ´ó¼Ò·ÖÏíһϣ¬ÒÔÃâ¸ü¶àÈËÏñÎÒÒ»Ñù»¨·Ñ´óÁ¿µÄʱ¼äÔÚĪÃûÆäÃîµÄÎÊÌâÉÏ¡£
Ê×ÏÈҪ˵Ã÷µÄÊÇ£¬¹Ù·½Ò²ÓÐÏàÓ¦µÄÎĵµ°²×°µ«ÊÇʵ¼Ê¹ý³ÌÖУ¬»áÓÐһЩÎÊÌâÐèÒª½â¾ö¡£
±¾Îĵµ²ÎÕÕÁËÏà¹Ø˵Ã÷,Ö¼ÔÚ½áºÏ¾ßÌå»·¾³ËµÃ÷ÎÊÌ⵫ˮƽÔÒò¿ÉÄÜ»¹ÊÇûÓÐ˵Ã÷°×£¬»¶Ó´ó¼ÒÌáÒâ¼û¡£Step1 °²×°RH LINUX AS4ͼÐλ¯°²×°£¬±È½Ï¼òµ¥£¬Îª°²×°ORACLE×¢Òâa.SWAP·ÖÇøÒªÉèµÄ×ã¹»´ó£¬×îºÃÔÚ2GÒÔÉÏb.°²×°°üº¬µÄ°üÒª×ÔÑ¡£¬¿ª·¢°ü×îºÃ¶¼¹³ÉÏStep2 ¼ì²é°æ±¾ºÍÐèÒªµÄ¹¤¾ß°ü¸Ã²¿·Ö»ù±¾Ã»Ê²Ã´ÎÊÌâ¡£
uname -r
//Äں˰汾rpm -q gcc make binutils openmotif glibc
//»ù±¾Èí¼þ°ü£¬±ØÐëÐèÒªrpm -q gcc make binutils openmotif setarch compat-db compat-gcc openmotif compat-gcc-c++ compat-libstdc++ compat-libstdc++-devel
//Ïà¹ØÎĵµ¼ÇÔØÐèÒª¼ì²éÕâЩÈí¼þ°ü£¬µ«ÓÐЩÊÇûÓеģ¬ÊÂʵ֤Ã÷ҲȷʵÊDz»ÐèÒªµÄ¡£
/******************************************
//RHEL AS 4µÄ·¢ÐÐ×¢¼ÇÖÐÌáµ½ÕâЩÈí¼þ°üÒѾ±»É¾³ý£º
//compat-gcc//compat-gcc-c++//compat-glibc//compat-libstdc++//compat-libstdc++-devel
//ËùÒÔËûÃÇÔÙÒ²²»ÐèÒª±»°²×°ÉÏÁË¡£
*********************************************/grep MemTotal /proc/meminfo
//¼ì²éÄÚ´æ
grep SwapTotal /proc/meminfo //¼ì²é½»»»·ÖÇø
df -h //²é¿´Ó²ÅÌÇé¿öStep3 Õë¶Ô Oracle ÅäÖà Linux3.1 Ìí¼ÓÓû§ºÍ×飬½¨Á¢Ä¿Â¼
//Õâ¸ö¹ý³ÌÒ»°ã²»»áÓÐÎÊÌâgroupadd osintall
//Ìí¼Ó×égroupadd dba
//Ìí¼Ó×éuseradd -m -g oinstall -G dba oracle
//Ìí¼ÓÓû§id oracle
//ÑéÖ¤passwd oracle
//ÉèÖÃÃÜÂëmkdir -p /u01/app/oracle
//Ö÷Ŀ¼mkdir -p /u02/oradata
//Êý¾Ý¿âÎļþĿ¼chown -R oracle:osintall /u01/app/oracle/ /u02/oradata/
//Ŀ¼¹Øϵ
chmod -R 755 /u01/app/oracle/ /u02/oradata/
//¶ÁдȨÏÞÉèÖÃ3.2ÅäÖà Linux Äں˲ÎÊý°´ÕÕ¹Ù·½ËµÃ÷£¬Ó¦¸ÃÅäÖÃÈçϲÎÊý£ºÄں˲ÎÊývi /etc/sysctl.conf
//Ìí¼Ó kernel.shmall = 2097152
kernel.shmmax = 2147483648
kernel.shmmni = 4096
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
Ïà¹ØÎĵµ£º
Service Discovery Protocol(SDP)ÌṩһÖÖÄÜÁ¦£¬ÈÃÓ¦ÓóÌÐòÓз½·¨·¢ÏÖÄÄÖÖ·þÎñ¿ÉÓÃÒÔ¼°ÕâÖÖ·þÎñµÄÌØÐÔ¡£
·þÎñ·¢ÏÖÐÒé(SDP»òBluetooth SDP)ÔÚÀ¶ÑÀÐÒéÕ»ÖжÔÀ¶ÑÀ»·¾³ÖеÄÓ¦ÓóÌÐòÓÐÌØÊâµÄº¬Ò⣬·¢ÏÖÄĸö·þÎñÊÇ¿ÉÓõĺÍÈ·¶¨ÕâЩ¿ÉÓ÷þÎñµÄÌØÕ÷¡£SDP¶¨ÒåÁËbluetooth client·¢ÏÖ¿ÉÓÃbluetooth server·þÎñºÍËüÃǵÄÌØÕ÷µÄ·½·¨¡£ ......
Ò»¡¢oracleµ¼³öexcel
·½·¨Ò»£º×î¼òµ¥µÄ·½·¨---Óù¤¾ßplsql dev
Ö´ÐÐFile =>new Report Window ¡£ÔÚsql±êÇ©ÖÐдÈëÐèÒªµÄsql£¬µã»÷Ö´Ðлò°´¿ì½Ý¼üF8£¬»áÏȳԳö²éѯ½á¹û¡£ÔÚÓҲ๤¾ßÀ¸£¬¿ÉÒÔÑ¡Ôñ°´Å¥Áí´æΪhtml¡¢copy as html¡¢export results£¬ÆäÖÐexport results°´Å¥ÖоͿÉÒÔµ¼³öexcelÎļþ¡¢csvÎļþ¡¢tsvÎļþ¡¢xmlÎļþ¡ ......
OracleÐÔÄÜÓÅ»¯¼¼ÇÉ
http://tech.it168.com/db/o/2006-06-15/200606151715426.shtml
1.Ñ¡ÓÃÊʺϵÄORACLEÓÅ»¯Æ÷
ORACLEµÄÓÅ»¯Æ÷¹²ÓÐ3ÖÖ:
1.RULE(»ùÓÚ¹æÔò) 2.COST(»ùÓڳɱ¾) 3.CHOOSE(Ñ¡ÔñÐÔ)
ÉèÖÃȱʡµÄÓÅ»¯Æ÷,¿ÉÒÔͨ¹ý¶Ôinit.oraÎļþÖÐOPTIMIZER_MODE²ÎÊ ......
ÔÎÄ£ºhttp://blog.csdn.net/jackyvan/archive/2010/01/15/5193693.aspx
ÆäʵVIMÒ²ÄܰѱàÒë µ÷ÊÔ¼¯³ÉÔÚÒ»Æð£¬ÏñÊÇÒ»¸öIDEÒ»Ñù¡£
Ê×ÏÈÏÖÔÚVIMµÄÔ´Â룬ÒòΪҪ¼¯³Éµ÷ÊÔ»·¾³µÄ»°ÐèÒªÖØбàÒëVIM²ÅÐУ¬ËùÒÔÎÒÃDz»ÈçÖØа²×°Ò»¸ö¡£
VIMµÄÏÖÔÚµØÖ·£º
http://www.vim.org/sources.php
È»ºóÏÂÔØVIMGDB£¬ÕâÊÇvimµÄ¼¯³Éµ÷ÊÔ»·¾³µÄ ......