Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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 SQL Developer¹¤¾ß

ÏÂÔØ½âѹÁËOracle SQL Developer¹¤¾ß£¬ÔËÐÐʱ£¬Æô¶¯²»ÁË£¬±¨´íÐÅÏ¢ÈçÏ£º
---------------------------
Unable to create an instance of the Java Virtual Machine
Located at path:
<SQLDEVELOPER>\jdk\jre\bin\client\jvm.dll
---------------------------
ÊÇJVM²ÎÊýÉèÖõÄÎÊÌ⣬ÎҵĽâ¾ö·½°¸ÈçÏ£º
<SQ ......

QtµÄOracleÊý¾Ý¿âQOCIÇý¶¯ÎÊÌâ

ÓÃQt¿ª·¢Oracle³ÌÐòʱ£¬³£»áÓöµ½QOCIÇý¶¯ÎÊÌ⣬Ö÷Òª±íÏÖΪ³ÌÐòÔËÐÐʱ³öÏÖÏÂÃæµÄ´íÎó¡£
QOCI driver not loaded
available drivers: QSQLITE QODBC3 QODBC
Õâ˵Ã÷ûÓа²×°QtÖ§³ÖOracleµÄÇý¶¯¡£
.
ÒªÏë±ÜÃâÕâ¸öÎÊÌ⣬µÚÒ»ÖÖ·½·¨ÊÇʹÓÃЧÂʵÍϲ¢ÇÒ·ÑʵÄODBC£»µÚ¶þÖÖ·½·¨¾ÍÊǰ²×°QOCIÇý¶¯¿©~
.
Ҫ˵һϵÄÊÇ£ºQOCIÔÚqt ......

OracleµÄ³£ÓÃÊý¾ÝÀàÐÍ

CHAR ¹Ì¶¨³¤¶È×Ö·û´® ×î´ó³¤¶È2000 bytes   
VARCHAR2 ¿É±ä³¤¶ÈµÄ×Ö·û´® ×î´ó³¤¶È4000 bytes  ¿É×öË÷ÒýµÄ×î´ó³¤¶È749
NCHAR ¸ù¾Ý×Ö·û¼¯¶ø¶¨µÄ¹Ì¶¨³¤¶È×Ö·û´® ×î´ó³¤¶È2000 bytes   
NVARCHAR2 ¸ù¾Ý×Ö·û¼¯¶ø¶¨µÄ¿É±ä³¤¶È×Ö·û´® ×î´ó³¤¶È4000 bytes   
DATE ÈÕÆÚ£ ......

¹ØÓÚoracleµÄ³¹µ×Ð¶ÔØÎÊÌâ

oracle9iÐ¶ÔØ
1,ÔÚ·þÎñÖÐÍ£Ö¹oracleµÄËùÓзþÎñ
2,ÔÚ³ÌÐòÁËжװËùÓÐOracle²úÆ·£¬(µ«Universal Installer±¾Éí²»Äܱ»É¾³ý)
3,ɾ³ý×¢²á±í:
(1)ÔËÐÐregeditÑ¡ÔñHKEY_LOCAL_MACHINE\SOFTWARE\ORACLE£¬É¾³ýÕâ¸öÏî
(2)Ñ¡ÔñHKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Oracle,ɾ³ýÕâ¸öÏî.
(3),Ñ¡ÔñHKEY_LOCAL_MACHI ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ