ÔÚ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ϵÁУºLOB´ó¶ÔÏó´¦Àí
Ö÷ÒªÊÇÓÃÀ´´æ´¢´óÁ¿Êý¾ÝµÄÊý¾Ý¿â×ֶΣ¬×î´ó¿ÉÒÔ´æ´¢4G×ֽڵķǽṹ»¯Êý¾Ý¡£
Ö÷Òª½éÉÜ×Ö·ûÀàÐͺͶþ½øÖÆÎļþÀàÐÍLOBÊý¾ÝµÄ´æ´¢£¬µ¥¶À½éÉܶþ½øÖÆÀàÐÍLOBÊý¾ÝµÄ´æ´¢¡£
Ò»£¬OracleÖеÄLOBÊý¾ÝÀàÐÍ·ÖÀà
1£¬°´´æ´¢Êý¾ÝµÄÀàÐÍ·Ö£º
¢Ù×Ö·ûÀàÐÍ£º
&nbs ......
Oracle ÈýÖÖ¼¯ºÏÊý¾ÝÀàÐ͵ıȽÏ:
PL/SQLÖÐûÓÐÊý×éµÄ¸ÅÄËûµÄ¼¯ºÏÊý¾ÝÀàÐͺÍÊý×éÊÇÏàËƵġ£ÔÚ7.3ÒÔÇ°µÄ°æ±¾ÖÐÖ»ÓÐÒ»ÖÖ¼¯ºÏ£¬³ÆΪPL/SQL±í£¬ÔÚÕâÖ®ºóÓÖÓÐÁ½ÖÖ¼¯ºÏÊý¾ÝÀàÐÍ:ǶÌ×±íºÍvarray¡£ÆäÖÐvarray¼¯ºÏÖеÄÔªËØÊÇÓÐÊýÁ¿ÏÞÖƵģ¬index_by±íºÍǶÌ×±íÊÇûÓÐÕâ¸öÏÞÖƵġ£index-by±íÊÇÏ¡ÊèµÄ£¬Ò²¾ÍÊÇ˵ϱê¿ÉÒÔ²»Á¬Ðø ......
RMAN> startup nomount;
RMAN> sql 'alter session set nls_date_format=''yyyy-mm-dd hh24:mi:ss''";
--ÒòΪrmanĬÈÏÒÔ»·¾³±äÁ¿À´¶Áȡʱ¼ä¸ñʽ£¬ÓësqlplusµÄ¹Ì¶¨¸ñʽ²»Í¬£¬ËùÒÔ£¬´Ë´¦ÒªÉ趨ʱ¼ä¸ñʽ±äÁ¿¡£
RMAN> restore controlfile from autobackup until time '2009-03-10 18:15:00';
×¢Ò⣬ÈÔÈ»ÐèÒªÊʵ±µ ......
Ô´´ÓÚ2007Äê04ÔÂ12ÈÕ£¬2009Äê10ÔÂ15ÈÕǨÒÆÖÁ´Ë¡£
windows xp£¬Êý¾Ý¿âoracle 10.2.0¡£1
ûÓб¸·Ý£¬»ù±¾ÉÏÊÇĬÈÏ°²×°£¬ºÃÏñ»¹²»Êǹ鵵ģʽ
Ö¢×´£ºsqlplusÖ»ÓÐsysdbaÓû§ÄܽøÈ¥£¬ÆäËûÓû§½øÈ¥Ò»¸Å±¨£ºora-01033£ºoracleÕýÔÚ³õʼ»¯»ò¹Ø±Õ
¶øÇÒsysdbaÓû§½øÈ¥Ö®ºóÄÜÖ´ÐÐselect sysdate from dual£¬µ«ÊÇÖ´ÐÐselect use ......
Ç°¼¸ÌìÃæÊÔµÄʱºòÃæÊÔ¹Ù²ÅÎʹýÎÒORACLEµÄÌåϵ½á¹¹£¬ÈÃÎÒÔÚÒ»ÕÅ°×Ö½ÉÏ»³öÀ´¡£»ØÍ·ÏëÏ뵱ʱ´ðµÃ»¹²»´í£¬´ó²¿·ÖÄÚÈݶ¼ÃèÊö³öÀ´ÁË£¬ºÇºÇ£¬¸Õ²ÅÔÚÍøÉÏ¿´µ½Ò»Æª½²½âORACLEÌåϵ½á¹¹µÄÎÄÕ£¬¾õµÃ²»´í£¬×ª¹ýÀ´´æ×Å£¬½«À´¿ÉÄÜ»áÓõ½¡£
=================================================================================
ÔÚ±¾ÎÄÀ ......