ÔÚLinuxÃüÁîÐÐÏ°²×°Oracle 10g
Oracle 10gÖ§³ÖÔÚÃüÁîÐÐÏÂÓþ²Ä¬Ä£Ê½(Silent)°²×°£¬¸øÄÇЩûÓа²×°Í¼ÐνçÃæµÄLinuxϵͳÌṩÁ˼«´óµÄ±ãÀû¡£
ÏÂÃæÒÔFedora Core 6ΪÀý£¬½éÉÜÔÚÃüÁîÐÐÏ°²×°OracleOracle 10gµÄ·½·¨¡£
1 °²×°Ç°µÄ×¼±¸
×¼±¸¹¤×÷ÒªÓõǼΪrootÓû§À´½øÐС£
1.1 Ñ¡Ôñ°²×°»·¾³µÄÓïÑÔ
Oracle°²×°Ê±¿ÉÒÔͨ¹ý»·¾³±äÁ¿LANGÖ¸¶¨°²×°ÓïÑÔ£¬Èç¹ûLinuxÃüÁîÐв»ÄÜÏÔʾÖÐÎÄ£¬¾ÍÒª½«ÓïÑÔ»·¾³ÉèÖÃΪӢÓï¡£
ÀýÈ磺export LANG=en_US.UTF-8
1.2 ÐÞ¸Ägennttab
Oracle 10gÔÚһЩLinuxϵͳÏ°²×°¿ÉÄܻᱻÖжϣ¬ÔÚ°²×°ÈÕÖ¾Îļþ
$ORACLE_HOME/install/make.log
Àï¿ÉÒÔ¿´¼ûÒÔÏ´íÎóÐÅÏ¢
/bin/sed: -e expression #1, char 7: unterminated `s' command
Òª½â¾öÕâ¸öÎÊÌâ¾Í±ØÐë±à¼Îļþ gennttab¡£
ÏȽâѹOracle°²×°Ä¿Â¼Ï嵀 stage/Components/oracle.network.rsf/10.2.0.1.0/1/DataFiles/filegroup6.jar£¬¿ÉÒÔÓÃÒÔÏ·½·¨Ö®Ò»½øÐнâѹ
ÓÃjar½âѹ£ºjar -xf filegroup6.jar bin/gennttab
ÓÃunzip½âѹ£ºunzip filegroup6.jar bin/gennttab
ÔÙÓÃÎı¾±à¼Æ÷£¨ÀýÈçvi£©´ò¿ª½âѹ³öÀ´µÄ gennttab£¬½«ÒÔÏÂÄÚÈÝ
LIB=`$ECHO ${TtoLIB} | $SED 's/ /\\
/g' | $GREP "^${T}:" | $AWK -F: '{print $2}'`
INI=`$ECHO ${TtoINI} | $SED 's/ /\\
/g' | $GREP "^${T}:" | $AWK -F: '{print $2}'`
BAS=`$ECHO ${TtoBAS} | $SED 's/ /\\
/g' | $GREP "^${T}:" | $AWK -F: '{print $2}'`
¸ÄΪ
LIB=`$ECHO ${TtoLIB} | $SED 's/ /\n/g' | $GREP "^${T}:" | $AWK -F:
'{print $2}'`
INI=`$ECHO ${TtoINI} | $SED 's/ /\n/g' | $GREP "^${T}:" | $AWK -F:
'{print $2}'`
BAS=`$ECHO ${TtoBAS} | $SED 's/ /\n/g' | $GREP "^${T}:" | $AWK -F:
'{print $2}'`
±£´æºóÔÙÓý«gennttab¸üе½filegroup6.jarÀïÃ棬¿ÉÒÔÓÃÒÔÏ·½·¨Ö®Ò»½øÐиüÐÂ
ÓÃjar¸üУºjar -uvf filegroup6.jar bin/gennttab
ÓÃzip¸üУºzip -vu filegroup6.jar bin/gennttab
1.3 ÐÞ¸ÄÄں˲ÎÊý
±à¼Îļþ /etc/sysctl.conf£¬ÐÞ¸ÄÒÔÏÂÏîÄ¿£¬Èç¹ûûÓпÉÒÔ×Ô¼ºÌí¼Ó¡£
kernel.shmall = 2097152 # ¿ÉÒÔʹÓõĹ²ÏíÄÚ´æµÄ×ÜÁ¿¡£
kernel.shmmax = 2147483648 # ×î´ó¹²ÏíÄÚ´æ¶Î´óС¡£
kernel.shmmni = 4096 # Õû¸öϵͳ¹²ÏíÄÚ´æ¶ÎµÄ×î´óÊýÄ¿¡£
kernel.sem = 250 32000 100 128 # ÿ¸öÐźŶÔÏ󼯵Ä×î´óÐźŶÔÏóÊý£»ÏµÍ³·¶Î§ÄÚ×î´óÐźŶÔÏóÊý£»Ã¿¸öÐźŶÔÏóÖ§³ÖµÄ×î´ó²Ù×÷Êý£»ÏµÍ³·¶Î§ÄÚ×î´óÐźŶÔÏó¼¯Êý¡£
fs.file-max =
Ïà¹ØÎĵµ£º
ÔÚOracleÖн¨¿â£¬Í¨³£ÓÐÁ½ÖÖ·½·¨¡£Ò»ÊÇʹÓÃOracleµÄ½¨¿â¹¤
ÇÒDBCA£¬ÕâÊÇÒ»¸öͼÐνçÃ湤ÇÒ£¬Ê¹ÓÃÆðÀ´·½±ãÇÒºÜÈÝÒ×Àí½â£¬ÒòΪËüµÄ½çÃæÓѺá¢ÃÀ¹Û£¬¶øÇÒÌáʾҲ±È½ÏÆëÈ«¡£ÔÚ£×indowsϵͳÖУ¬Õâ¸ö¹¤¾ß¿ÉÒÔÔÚOracle³ÌÐò×éÖдò¿ª£¨”¿ªÊ¼”—“³ÌÐò”—“ Oracle OraDb10g_home1”&mdash ......
OracleϵÁУºÍ¼Æ¬µÄ´æ´¢
Ò»£ºÊ²Ã´ÊÇ´ó¶ÔÏ󣬴ó¶ÔÏó»ù±¾²Ù×÷£¿
²Î¼ûÎÒµÄBLOG£ºOracleϵÁУºLOB´ó¶ÔÏó´¦Àí
http://blog.csdn.net/qfs_v/archive/2008/05/21/2464599.aspx
¶þ£¬Í¼Æ¬µÄ´æ´¢»ò¶þ½øÖÆÎļþµÄ´æ´¢
1£¬ÏȲåÈëÆÕͨÊý¾Ý£¬Óöµ½´ó¶ÔÏóÁÐʹÓÃempty_blob()¹¹Ôì¿ÕµÄÖ¸Õë¡£
Àý× ......
Tablespace
ORACLEÖУ¬±í¿Õ¼äÊÇÊý¾Ý¹ÜÀíµÄ»ù±¾·½·¨£¬ËùÓÐÓû§µÄ¶ÔÏóÒª´æ·ÅÔÚ±í¿Õ¼äÖУ¬Ò²¾ÍÊÇÓû§ÓпռäµÄʹÓÃȨ£¬²ÅÄÜ´´½¨Óû§¶ÔÏó£®·ñÔòÊDz»³äÐí´´½¨¶ÔÏó£¬ÒòΪ¾ÍÊÇÏë´´½¨¶ÔÏó,Èç±í,Ë÷ÒýµÈ£¬Ò²Ã»Óеط½´æ·Å,Oracle»áÌáʾ:ûÓд洢Åä¶î£®
¡¡¡¡Òò´Ë£¬ÔÚ´´½¨¶ÔÏó֮ǰ£¬Ê×ÏÈÒª·ÖÅä´æ´¢¿Õ¼ä£®¡¡¡¡
·ÖÅä´æ ......
1£¬Ê²Ã´ÊÇÓαꣿ
¢Ù´Ó±íÖмìË÷³ö½á¹û¼¯£¬´ÓÖÐÿ´ÎÖ¸ÏòÒ»Ìõ¼Ç¼½øÐн»»¥µÄ»úÖÆ¡£
¢Ú¹ØϵÊý¾Ý¿âÖеIJÙ×÷ÊÇÔÚÍêÕûµÄÐм¯ºÏÉÏÖ´Ðеġ£
ÓÉ SELECT Óï¾ä·µ»ØµÄÐм¯ºÏ°üÀ¨Âú×ã¸ÃÓï¾äµÄ WHERE ×Ó¾äËùÁÐÌõ¼þµÄËùÓÐÐС£ÓɸÃÓï¾ä·µ»ØÍêÕûµÄÐм¯ºÏ½Ð×ö½á¹û¼¯¡£
&n ......
×î½üÒ»¶Îʱ¼äһֱûд²©¿Í£¬²»ÊÇÀÁ£¬ÊÇѧÁËÌ«¶à¶«Î÷¡£ÒÔºóÂýÂý²¹ÉÏ¡£ 1. odbcÖÐÌí¼ÓoracleÊý¾ÝÔ´ odbcÖÐÌí¼ÓoracleÊý¾ÝÔ´Ê×ÒªÌõ¼þ£º°²×°oracle client¡£°²×°ÍêÖ®ºóÌí¼Ó£¬µ«ÊÇ»¹±ØÐëÔÚ°²×°Ä¿Â¼ÏÂͨ³£ÊÇC:\oracle\ora90\network\ADMIN\tnsnames.oraÖÐÌí¼ÓÒ»¸öÁ¬½Ó£¬Èçϸñʽ£º DXS =
(DESCRIPTION =
......