Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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Ö´Ðмƻ®Ïà¹Ø¸ÅÄî http://blog.csdn.net/wh62592855/archive/2009/11/06/4778343.aspx
 
1.     Ê²Ã´ÊÇÖ´Ðмƻ®£¿ÎªÊ²Ã´ÒªÁ˽âÖ´Ðмƻ®£¿
ΪÁËÖ´ÐÐÒ»ÌõsqlÓï¾ä£¬oracle¿ÉÄܱØÐëÒªÖ´ÐÐijЩ²½ÖèµÄ²Ù×÷£¬Ã¿Ò»²½Öè¿ÉÄÜÊÇ´ÓÊý¾Ý¿âÖÐÎïÀí¼ìË÷Êý¾ÝÐУ¬»òÕßÓÃijÖÖ·½·¨×¼±¸Êý¾ÝÐУ¬¹© ......

oracleÖ®createÓ÷¨


create  database  --´´½¨Êý¾Ý¿â
create database test
controlfile reuse
datafile 'd:\data\system1.dbf' size 100m  autoextend on next 100m maxsize unlimited
sysaux datafile 'd:\data\sysaux1.dbf' size 100m reuse autoextend on next 100m maxsize unlimited
default temp ......

linuxϵͳÖÐÅäÖÃoracle¿ª»ú×ÔÆô¶¯

Centos  redhat ,oracle10g,oracle11g¾ùÊÊÓÃ
 
1.       ±àд½Å±¾£º
# vi  startoracle.sh
#11gµÄ»°Ö»ÊÇÕâ¸öĿ¼ÓÐËùÇø±ð
ORACLE_HOME=/home/oracle/product/10.2.0/db_1;export ORACLE_HOME
 
ORACLE_SID=orcl;export ORACLE_SID #ÕâÀïÅäÉÏÄãµÄ±¾µØÊ¾ÀýÃû
&nbs ......

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

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

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

F.1×Ö·ûº¯Êý——·µ»Ø×Ö·ûÖµ
ÕâЩº¯ÊýÈ«¶¼½ÓÊÕµÄÊÇ×Ö·û×åÀàÐ͵IJÎÊý(CHR³ýÍâ)²¢ÇÒ·µ»Ø×Ö·ûÖµ.³ýÁËÌØ±ð˵Ã÷µÄÖ®Íâ,ÕâЩº¯Êý´ó²¿·Ö·µ»ØVARCHAR2ÀàÐ͵ÄÊýÖµ.×Ö·ûº¯ÊýµÄ·µ»ØÀàÐÍËùÊܵÄÏÞÖÆºÍ»ù±¾Êý¾Ý¿âÀàÐÍËùÊܵÄÏÞÖÆÊÇÏàͬµÄ,±ÈÈç: VARCHAR2ÊýÖµ±»ÏÞÖÆÎª2000×Ö·û(ORACLE 8ÖÐΪ4000×Ö·û),¶øCHARÊýÖµ±»ÏÞÖÆÎª255×Ö·û(Ô ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ