ubuntu°²×°oracle 10g
Ŀ¼
1. °²×°×¼±¸
1.1. ÉèÖÃÓû§
1.2. ´´½¨Ä¿Â¼ºÍÉèÖÃȨÏÞ
1.3. ¸ü¸ÄÅäÖÃ
1.4. °²×°
1.5. Æô¶¯/Í£Ö¹Oracle
1. °²×°×¼±¸
°²×°¿ªÊ¼Ç°£¬È·ÈÏÄãµÄϵͳ·ûºÏOracleµÄ×îС°²×°ÒªÇó:
* 500 MB ÄÚ´æ
* 1 GB ½»»»·ÖÇø
* È·ÈÏÄãÒѾ°²×°ÁËgcc, make, binutils, lesstif2, libc6, ºÍ rpm
*×îºÃÈ·ÈÏ dns ºÍ/»ò ÄãµÄ /etc/hosts ÎļþÒѾÕýÈ·ÅäÖÃÁË£¬ÒÔ±£Ö¤ÄãµÄIPµØÖ·ºÍhostnameÄÜÕýÈ·½âÎö.
1.1. ÉèÖÃÓû§
ÎÒÃÇÐèҪΪ°²×°³ÌÐò´´½¨Ò»¸öoracle Óû§ºÍÁ½¸ö×é. Ê×Ïȼì²éËüÃÇÊÇ·ñÒѾ´æÔÚ:
$grep oinstall /etc/group
$grep dba /etc/group
$grep nobody /etc/group
Èç¹ûËüÃÇ»¹²»ÔÚϵͳÖУ¬ÄÇô´´½¨ËüÃÇ¡£
#addgroup oinstall
#addgroup dba
#addgroup nobody
#useradd -g oinstall -G dba -p passwd -d /home/oracle -s /bin/bash oracle
#usermod -g nobody nobody
1.2. ´´½¨Ä¿Â¼ºÍÉèÖÃȨÏÞ
×¢Òâ: oracleȱʡĿ¼ÊÇ /u01 ºÍ /u02. ÎÒÃÇΪÁ˺ÍFHSÓиüºÃµÄ¼æÈÝÐÔ£¬¸ü¸ÄΪ /opt/oracle ºÍ /opt/oradata:
#mkdir -p /opt/oracle
#mkdir -p /opt/oradata
#chown -R oracle:oinstall /opt/ora*
#chmod -R 775 /opt/ora*
1.3. ¸ü¸ÄÅäÖÃ
Ìí¼ÓÒÔÏÂÐе½ /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
¸üÐÂϵͳ, ÔËÐÐ:
#sysctl -p
Ìí¼ÓÒÔÏÂÐе½ /etc/security/limits.conf ÎļþÖÐ:
* soft nproc 2407
* hard nproc 16384
* soft nofile 1024
* hard nofile 65536
½¨Á¢ÈíÁ¬½Ó:
#ln -s /usr/bin/awk /bin/awk
#ln -s /usr/bin/rpm /bin/rpm
#ln -s /usr/bin/basename /bin/basename
ͨ¹ý´´½¨Ò»¸öÐÂÎļþ/etc/redhat-release²¢Ìí¼ÓÒÔÏÂÐУ¬ÆÛÆ°²×°³ÌÐòÈÃËüÒÔΪÎÒÃǵÄϵͳÊÇRedHat
Ïà¹ØÎĵµ£º
oracle±í¿Õ¼ä²Ù×÷Ïê½â
1
2
3×÷Õߣº À´Ô´£º ¸üÐÂÈÕÆÚ£º2006-01-04
5
6
7½¨Á¢±í¿Õ¼ä
8
9CREATE TABLESPACE data01
10DATAFILE '/ora ......
Ò»¡£jobµÄÔËÐÐƵÂÊÉèÖÃ
1.ÿÌì¹Ì¶¨Ê±¼äÔËÐУ¬±ÈÈçÔçÉÏ8:10·ÖÖÓ£ºTrunc(Sysdate+1) + (8*60+10)/24*60
2.ToadÖÐÌṩµÄ£º
ÿÌ죺trunc(sysdate+1)
ÿÖÜ£ºtrunc(sysdate+7)
ÿÔ£ºtrunc(sysdate+30)
ÿ¸öÐÇÆÚÈÕ£ºnext_day(trunc(sysdate),'SUNDAY')
ÿÌì6µã£ºtrunc(sysdate+1)+6/24
°ë¸öСʱ£ºsysdate+30/1440
3.ÿ¸ö ......
Blob ²ÉÓõ¥×Ö½Ú´æ´¢£¬Êʺϱ£´æ¶þ½øÖÆÊý¾Ý£¬ÈçͼƬ¡¢ÊÓƵµÈ¡£
Clob ²ÉÓöà×Ö½Ú´æ´¢£¬Êʺϱ£´æ´óÐÍÎı¾Êý¾Ý¡£
1. ÔÚOracle JDBCÖвÉÓÃÁ÷»úÖÆ¶Ô BLOB/CLOB ½øÐжÁд²Ù×÷£¬ËùÒÔҪעÒâ²»ÄÜÔÚÅú´¦ÀíÖжÁд BLOB/CLOB×ֶΣ¬·ñÔò½«³öÏÖ
Stream type cannot be used in batching Òì³£¡£
2. Oracle BLOB/CLOB ×ֶα¾ÉíÓµÓÐÒ»¸öÓÎ ......
Oracle Text¹¦ÄÜÊ®·ÖÇ¿´ó£¬¿ªÊ¼Ñ§Ï°£¬Ö÷Òª²Î¿¼
yangtingkun
µÄblogºÍÎĵµ½øÐС£
µÚÒ»²½ÏȸãÇå³þdatastoreµÄÀàÐÍ¡£
DATASTOREµÄÀàÐÍÈçÏ£º
DIRECT_DATASTORE
MULTI_COLUMN_DATASTORE
DETAIL_DATASTORE
FILE_DATASTORE
NESTED_DATASTORE
URL_DATASTORE
USER_DATASTORE
ÏÂÃæ¾Í¸÷ÖÖÀàÐͽøÐвâÊÔ£¬DIRECT_DATASTOREÊ ......
ÕâƪÎÄÕ½éÉܵÄÊÇORACLE CTXCATË÷ÒýµÄINDEX SET£¬Ò²ÊÇCTXCATË÷ÒýÌØÓеÄÊôÐÔ¡£
CTXCAT
Ë÷ÒýÊÇCONTEXTË÷ÒýµÄ¼ò»¯°æ£¬CTXCATË÷ÒýÖ§³ÖµÄPREFERENCE°üÀ¨£ºLEXER¡¢STOPLIST¡¢WORDLISTºÍSTORAGE
²ÎÊý¡£²»Ö§³ÖÆäËûµÄ²ÎÊýÈ磺DATASTORE¡¢FILTER¡¢SECTION
GROUP¡£ËäȻ֧³ÖLEXERµ«²»Ö§³ÖTHEME²éѯ£¬¶øÇÒ²»Ö§³ÖFORMAT¡¢CHARSETºÍLAN ......