Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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Ö®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 11g database·½·¨Ö¸µ¼(Èý)

±¸×¢£º¾­¹ýǰÆÚµÄlinuxϵͳ»·¾³µÄÅäÖôÍê³É£¬ÏÂÃæ¾Í¿ªÊ¼°²×°oracleÊý¾Ý¿â¡£oralceÊý¾Ý´ó¼ÒÈ¥oracle¹Ù·½ÍøÕ¾ÉÏÏÂÔØlinux»·¾³Ïµİ汾¡£ºÜÒź¶½ØÍ¼ÉÏ´«²»ÁË¡£
 
Èý£®Oracle database°²×°¾ßÌå°²×°²½Öè
 
<1>´´½¨°²×°oracleĿ¼¼°Ö÷Êôµ÷Õû
[root@mylinux oracle]# mv database/ /u01
[root@mylinux u ......

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º¯Êý´óÈ« Êý×Ö´¦Àíº¯Êý


oracleº¯Êý´óÈ«-Êý×Ö´¦Àíº¯Êý
F.3    Êý×Öº¯Êý
º¯Êý½ÓÊÜNUMBERÀàÐ͵IJÎÊý²¢·µ»ØNUMBERÀàÐ͵ÄÊýÖµ.³¬Ô½º¯ÊýºÍÈý½Çº¯ÊýµÄ·µ»ØÖµ¾«È·µ½36λ.ACOS¡¢ASIN¡¢ATAN¡¢ATAN2µÄ½á¹û¾«È·µ½36λ.
l         ABS
Óï·¨:   ABS(x)
¹¦ÄÜ:   µÃµ½xµÄ¾ø¶ÔÖ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ