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

ubuntu 10.04 ϰ²×°oracle 11g

°²×°²½Ö裺
1. °²×°JDK£¬°²×°·½·¨¼û
Ubuntu
10.04ϵĴSUN JAVA¿ª·¢»·¾³
½â¾öÖÐÎÄÂÒÂëÎÊÌ⣬ÔÚjreĿ¼ÏÂ×ÖÌåĿ¼Öн¨Á¢"fallback"Ŀ¼£¬È»ºócopy»òÕßlinkÄãϲ»¶µÄ×ÖÌåÖÁĿ¼ÏÂ.
2. °²×°±ØÒªµÄÈí¼þ°ü
11gËùÐèÒªµÄÈí¼þ°ü²¢²»¶à£¬Ö»Òª°²×°build-essential,rpm,libaio,ksh,libtool,libstdc++5
sudo apt-get install rpm libaio1 ksh libtool libstdc++5 build-essential
3. ÉèÖÃĿ¼½á¹¹ºÍ·ûºÅÁ´½Ó
sudo ln -s /usr/bin/awk /bin/awk 
sudo ln -s /usr/bin/rpm /bin/rpm 
sudo ln -s /usr/bin/basename /bin/basename
sudo mkdir /etc/rc.d
for i in 0 1 2 3 4 5 6 ; do ln -s /etc/rc$i.d /etc/rc.d/rc$i.d ; done
ÔÚ"/opt"Ŀ¼Ï½¨Á¢Á½¸öĿ¼"/opt/oracle11g/server"£¬"/opt/oracle11g/oradata"£¬"server"ÓÃÓÚ´æ·Å11gµÄ³ÌÐòÎļþ£¬"oradata"ÓÃÓÚ´æ·ÅÊý¾Ý¿âÎļþ¡£ÆäÖÐluyaoweiÊÇÄãϵͳµÇ¼µÄÓû§Ãû
sudo mkdir /opt/oracle11g
sudo mkdir /opt/oracle11g/server
sudo mkdir /opt/oracle11g/oradata
sudo chown luyaowei /opt
sudo chown luyaowei /opt/oracle11g
sudo chown luyaowei /opt/oracle11g/server
sudo chown luyaowei /opt/oracle11g/oradata
4. ÉèÖÃϵͳ²ÎÊý
ÐÞ¸Ä/etc/sysctl.confÎļþ£¬ÔÚĩβÌí¼ÓÏÂÃæÄÚÈÝ
sudo gedit /etc/sysctl.conf
Ìí¼ÓµÄÄÚÈÝ
fs.aio-max-nr = 1048576 
fs.file-max = 6815744 
kernel.shmall = 2097152 
kernel.shmmax = 536870912 
kernel.shmmni = 4096 
kernel.sem = 250 32000 100 128 
net.ipv4.ip_local_port_range = 9000 65500 
net.core.rmem_default = 262144 
net.core.rmem_max = 4194304 
net.core.wmem_default = 262144 
net.core.wmem_max = 1048586
ÐÞ¸Ä/etc/security/limits.conf
sudo gedit /etc/security/limits.conf
Ìí¼ÓÄÚÈÝÈçÏÂ
luyaowei soft nproc  2047 
luyaowei hard nproc  16384 
luyaowei soft nofile 1024 
luyaowei hard nofile 65536
ÐÞ¸Ä/etc/pam.d/login£¬¼ÓÈëÈçÏÂÄÚÈÝ£º
sudo gedit /etc/pam.d/login
Ìí¼ÓÄÚÈÝÈçÏÂ
session required /lib/security/pam_limits.so 
session required pam_limits.so
Ö´ÐдúÂë
sudo sysctl -p
ÐÞ¸ÄprofileÎļþ
cdhttp://blog.csdn.net/luyaowei/archive/2010/05/19/56089


Ïà¹ØÎĵµ£º

×îÐÂoracle ²¹¶¡ÏÂÔØ


×îÐÂoracle ²¹¶¡ÏÂÔØ
ʹÓÃѸÀ×н¨ÈÎÎñÏÂÔØµØÖ·Ìîд
ftp://updates.oracle.com/<patch_num>/p<patch_num>_<version>_<os>.zip
¾Í¿ÉÒÔÏÂÔØµ½ÄãÏëÒªµÄ²¹¶¡ÁË¡£
ÒÔÏÂÊǼ¸¸ö³£Óò¹¶¡µÄÏÂÔØµØÖ·¡£
(10.2.0.3 patch)
ftp://updates.oracle.com/5337014/p5337014_10203_WINNT.zip ftp://updates.o ......

ORACLEËÀËø²éѯ¼´´¦Àí

¹ØÓÚÊý¾Ý¿âËÀËøµÄ¼ì²é·½·¨
Ò»¡¢         Êý¾Ý¿âËÀËøµÄÏÖÏó
³ÌÐòÔÚÖ´ÐеĹý³ÌÖУ¬µã»÷È·¶¨»ò±£´æ°´Å¥£¬³ÌÐòûÓÐÏìÓ¦£¬Ò²Ã»ÓгöÏÖ±¨´í¡£
¶þ¡¢        
ËÀËøµÄÔ­Àí
µ±¶ÔÓÚÊý¾Ý¿âij¸ö±íµÄijһÁÐ×ö¸üлòɾ³ýµÈ²Ù×÷£¬Ö´ÐÐÍê±Ïºó¸ÃÌõÓï¾ä ......

linuxϰ²×°oracle11g²½ÖèÓëÌå»á

ÔÚlinuxÉϰ²×°oracleÊÇÒ»¼þ¸´ÔÓµÄÊÂÇ飬ÓÈÆä¶ÔÓÚÒ»¸öÉúÊÖÀ´Ëµ£¬ËüµÄ¸´Ôӳ̶ÈÔ¶³¬¹ýÁËlinux²Ù×÷ϵͳµÄ°²×°£¬ÒòΪ²»ÏñwindowsÄÇÑù¿ÉÒÔÖ±½Óµã»÷sertup.exe¾ÍokÁË£¬ÔÚ°²×°Ö®Ç°ÄãÒªÅäÖû·¾³±äÁ¿£¬ÐÞ¸ÄÈô¸É¸öϵͳÎļþ£¬²¢ÇÒÕâЩ²ÎÊý¿ÉÄܸù¾ÝÄãlinux°æ±¾µÄ²»Í¬¶øÓÐËù²»Í¬£¬Èç¹ûÅäÖò»ÕýÈ·£¬¿ÉÄܵ¼ÖÂ×îÖյݲװʧ°Ü£¬ÆäËü»¹ÓÐÄãµÄÄ¿ ......

oracleº¯Êý´óÈ« Êý×Ö´¦Àíº¯Êý


oracleº¯Êý´óÈ«-Êý×Ö´¦Àíº¯Êý
F.3    Êý×Öº¯Êý
º¯Êý½ÓÊÜNUMBERÀàÐ͵IJÎÊý²¢·µ»ØNUMBERÀàÐ͵ÄÊýÖµ.³¬Ô½º¯ÊýºÍÈý½Çº¯ÊýµÄ·µ»ØÖµ¾«È·µ½36λ.ACOS¡¢ASIN¡¢ATAN¡¢ATAN2µÄ½á¹û¾«È·µ½36λ.
l         ABS
Óï·¨:   ABS(x)
¹¦ÄÜ:   µÃµ½xµÄ¾ø¶ÔÖ ......

oracleʵÀýÃû,·þÎñÃûµÈ¸ÅÄîÇø±ðÓëÁªÏµ

oracleʵÀýÃû,·þÎñÃûµÈ¸ÅÄîÇø±ðÓëÁªÏµ
 
Ò»¡¢Êý¾Ý¿âÃûITPUB¸öÈ˿ռäv{7x6lo\
ʲôÊÇÊý¾Ý¿âÃû£¿ITPUB¸öÈ˿ռä*s*R5LVBXZ2w$I
Êý¾Ý¿âÃû¾ÍÊÇÒ»¸öÊý¾Ý¿âµÄ±êʶ£¬¾ÍÏñÈ˵ÄÉí·ÝÖ¤ºÅÒ»Ñù¡£ËûÓòÎÊýDB_NAME±íʾ£¬Èç¹ûһ̨»úÆ÷ÉÏ×°Á˶àÈ«Êý¾Ý¿â£¬ÄÇôÿһ¸öÊý¾Ý¿â¶¼ÓÐÒ»¸öÊý¾Ý¿âÃû¡£ÔÚÊý¾Ý¿â°²×°»ò´´½¨Íê³ÉÖ®ºó£¬²Î ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ