Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

linux×Ô¶¯Æô¶¯ oracle½Å±¾

×î½ü£¬ORACLEϵͳ»ù±¾µ÷ÊÔͨ¹ý£¬ÊÇʱºòÉèÖÃORACLEËæRHEL×Ô¶¯Æô¶¯Óë¹Ø±Õ·þÎñµÄʱºòÁË£¬Ö®ËùÒÔ°ÑÕâ¸öÈÎÎñ·ÅÔÚ×îºóÀ´×ö£¬ÊÇÒòΪÎÒ¾õµÃÕâ¸öÓ¦¸Ã²»»áºÜÄÑ£¬µ«ÕæÕýʵʩÆðÀ´£¬»¹ÊÇÓöµ½Á˸ö²»Ð¡µÄÕÏ°­
дºÃ½Å±¾£¬×¢²áºÃ·þÎñÖ®ºó£¬¾­²âÊÔ£¬ORACLE¿ÉÒÔËæRHELÆô¶¯¶øÆô¶¯£¬µ«²»ÄÜËæϵͳ¹Ø±Õ¶ø¹Ø±Õ¡£ÔÚÍøÉÏÕҴ𰸣¬·¢ÏÖ¼¸ºõËùÓеÄÉèÖùý³ÌÌû×Ó¶¼ÊÇ´ÓͬһƪԭÑùÕÕ³­¹ýÀ´µÄ£¬¸ù±¾¾ÍÐв»Í¨¡£ÌìÏÂÎÄÕÂÒ»´ó³­¡£ÇóÖúËûÈË£¬Ã»Óеõ½Ò»¸öºÃµÄ½â¾ö·½°¸¡£ÎÞÄΣ¬×Ô¼º¾²ÏÂÐÄÀ´ÂýÂýÑо¿·ÖÎö£¬×ÜËãÕÒµ½ÁËÎÊÌâµÄ¹Ø¼üÔ­ÒòËùÔÚ¡£
ÏÖÔھͰÑÎÒµÄÕû¸ö³É¹¦ÉèÖõĹý³ÌÌù³öÀ´£¬¹©´ó¼Ò²Î¿¼£¬ÒÔÆÚ´ó¼ÒÄÜÉÙ×ßÍä·£»ÁíÍ⻹ÊÇÒª¸øÆäËûÈËÒ»¸ö½¨Ò飺ÇÐĪÉúÓ²Õհᣬ¶ÏÕÂÈ¡Ò壬·ñÔòÆ亦´óÑÉ£¡£¡
Ê×ÏÈ£¬ÒªÔÚRHELÖÐÉèÖÃÔÊÐíORACLEϵͳ×Ô¶¯Æô¶¯£¬ÒòΪĬÈÏÇé¿öÏÂÊÇÉèÖÃΪ²»ÔÊÐíµÄ¡£²Ù×÷ÈçÏ£º
ÔÚrootÕË»§ÏÂÐÞ¸Ä /etc/oratab Îļþ£º
# vi /etc/oratab
ÕÒµ½orcl=/db/app/oracle/product /11.1.0/db_1 :NÕâÒ»ÐÐ
¸ÄΪ£º
orcl=/db/app/oracle/product/11.1.0/db_1 :Y
Ò²¾ÍÊǽ«×îºóµÄN¸ÄΪY£¬Òâ˼Êǽ«²»ÔÊÐí×Ô¶¯Æô¶¯¸ÄΪÔÊÐí×Ô¶¯Æô¶¯¡£
È»ºó£¬ÊÇÐÞ¸ÄORACLE×Ô´øµÄÆô¶¯Óë¹Ø±Õ½Å±¾£¬·Ö±ðÊÇ dbstartºÍdbshut¡£Ö´ÐÐÕâÁ½¸ö½Å±¾¾Í¿ÉÒÔʵÏÖORACLE½Å±¾µÄÆô¶¯Óë¹Ø±Õ¡£
ÔÚoracleÕË»§ÏÂÐÞ¸Ä$ORACLE_HOME/bin/dbstartÎļþ£º
¸´ÖÆ´úÂë ´úÂëÈçÏÂ:
# su - ORACLE
$ cd $ORACLE_HOME/bin
$ vi dbstart
ÕÒµ½ ORACLE_HOME_LISTNER=$1ÕâÒ»ÐÐ
¸ÄΪ£º
ORACLE_HOME_LISTNER=$ORACLE_HOME
Ö®ËùÒÔ×öÕâÒ»²½£¬ÊÇÒòΪÔÚÕâ¸ö½Å±¾×Ô¶¯Éú³ÉµÄʱºò£¬Ò²¾ÍÊÇORACLE±»°²×°½øRHELµÄʱºò£¬Õâ¸ö½Å±¾²¢²»ÖªµÀÄãµÄ
ORACLE_HOME_LISTNER ÊÇʲô£¬ÏÖÔÚÒª½«Õâ¸ö²ÎÊýÏÔʾµÄдÃ÷£¬ÕâÑù¾Í²»»áÔÚÖ´ÐÐÕâ¸ö½Å±¾µÄʱºò±¨
ORACLE_HOME_LISTNERûÓб»Ö¸¶¨µÄ´íÎóÁË¡£×¢Ò⣺dbstartºÍdbshut½Å±¾ÔÚ10gÖ®ºó¾ÍÒѾ­½«¼àÌýÆ÷µÄÆô¶¯Óë¹Ø±ÕºÏ²¢½øÊý
¾Ý¿âʵÀýµÄÆô¶¯Óë¹Ø±Õ½Å±¾ÀïÃæÁË¡£¶ø²»ÔÙÊǵ¥¶À·Ö¿ªµÄÁË¡£
ͬÑùµÄ·½Ê½£¬ÎÒÃÇÒ²ÒªÐÞ¸ÄdbshutµÄÕâ¸ö²ÎÊý¡£ÕâÀï¾Í²»ÔÙÏêϸд³öÁË£¬ËûÃÇÔÚͬһ¸öĿ¼Ï¡£
ÔٴΣ¬¾ÍÊÇдһ¸ö½Å±¾£¬°ÑËü×¢²áΪһ¸öϵͳ·þÎñ£¬ÈÃËüÔÚ¿ª»úÓë¹Ø»úµÄʱºòÔËÐС£ËüµÄ×÷ÓþÍÊǵ÷Óò¢Ö´ÐÐdbstartºÍdbshut¡£ÕâÑù²»
¾ÍʵÏÖÁËÊý¾Ý¿âÆô¶¯Óë¹Ø±ÕÁËÂ𣿣¡Õâ¸ö½Å±¾±»·ÅÔÚ/etc/init.dĿ¼ÖУ¬½Å±¾µÄÃû×ÖÊÇoracle11
½Å±¾ÈçÏ£º
¸´ÖÆ´úÂë ´úÂëÈçÏÂ:
#!/bin/bash
# chkconfig: 2345 99 10
# description: Startup Script for oracle Databas


Ïà¹ØÎĵµ£º

oracleÉèÖÃSGA

Ê×ÏÈÒÔsysdbaÉí·ÝµÇ¼
sqlplus connect system/orcl as sysdba;
È»ºóÐ޸IJÎÊý
1.sga_target²»ÄÜ´óÓÚsga_max_size£¬¿ÉÒÔÉèÖÃΪÏàµÈ¡£
2.SGA¼ÓÉÏPGAµÈÆäËû½ø³ÌÕ¼ÓõÄÄÚ´æ×ÜÊý±ØÐëСÓÚ²Ù×÷ϵͳµÄÎïÀíÄÚ´æ¡£
alter system set sga_target=150M scope=spfile;
alter system set sga_max_size=150M scope=spfile;
//Êý¾Ý¿â ......

ORACLEµÝ¹éͳ¼ÆËùÓÐ×ÓËï»ú¹¹£¡

select bid from t_branch c start with c.upbid  ='11000000'  connect by prior c.bid=c.upbid
˵Ã÷£º
1¡¢Í³¼Æij¸ö»ú¹¹ÏÂËùÓеÄ×ÓËï»ú¹¹¡£Èçͳ¼Æ±±¾©»ú¹¹ÏµÄ×ÓËï»ú¹¹£¬°üÀ¨£º³¯ÑôÇø»ú¹¹¡¢º£µíÓªÏú»ú¹¹¡¢¡¢¡¢ÇàÁúÇÅÏç»ú¹¹¡¢¡¢¡¢¡¢Ò»Ö±µ½×îµ×²ãµÄ»ú¹¹¡£
2¡¢upbidÊÇÖ¸Éϼ¶»ú¹¹µÄID¡£º£µíÇø»ú¹¹ID(bid)µÄÉϼ¶»ú ......

×Ô¶¯Íê³ÉOracle¿Í»§¶ËµÄ°²×°¼°ÆäÅäÖÃ


¡¡¡¡Ò»¡¢ÎÊÌâµÄÌá³ö
¡¡¡¡Ä¿Ç°µÄºÜ¶àÊý¾Ý¿âÓ¦ÓóÌÐòÊÇʹÓÃORACLEÊý¾Ý¿â¿ª·¢µÄclient/serverģʽ¡£ÖÚËùÖÜ
Öª£¬Ê¹ÓôËÖÖģʽÐèÒªÔÚÖÕ¶ËÉÏ°²×°ORACLE¿Í»§¶ËÈí¼þ¡£Ó¦ÓóÌÐò¿ÉÒÔʹÓÃInstallShieldÈí¼þ´ò°ü³É°²×°³ÌÐò£¬ÓÉÓû§×ÔÐа²×°¡£µ«
ORACLE¿Í»§¶ËÈí¼þÒ»°ãÐèÒªÓо­ÑéµÄ¿ª·¢ÈËԱͨ¹ýÈË»ú½»»¥µÄ·½·¨°²×°£¬°²×°Íê³Éºó»¹ÐèÔ ......

¡¾Nutch¡¿Linuxϵ¥»úÅäÖÃNutch

Linuxϵ¥»úÅäÖÃNutch
 
1.»·¾³½éÉÜ
²Ù×÷ϵͳ£ºRed hat linux 9
Nutch°æ±¾£ºnutch-0.9,ÏÂÔØ£ºhttp://apache.etoak.com/lucene/nutch/
JDK°æ±¾£ºJDK 1.6
Apache Tomcat°æ±¾£ºapache-tomcat-6.0.18
http://apache.etoak.com/tomcat/tomcat-6/v6.0.18/bin/apache-tomcat-6.0.18.tar.gz
2.ÅäÖÃÇ°Ìá
2.1 °²×°jdk ......

LinuxѹËõÓë½âѹËõ²ÎÊý˵Ã÷

tarÃüÁ tar [-cxtzjvfpPN] ÎļþÓëĿ¼ ....
# f+ E' `# d' W( {²ÎÊý£º & e( U# Y4 x; c$ b2 O; j/ p
-c £º½¨Á¢Ò»¸öѹËõÎļþµÄ²ÎÊýÖ¸Áî(create µÄÒâ˼)£»
. E' {. v5 ^  \' v3 O5 H, C' @- p& ^-x £º½â¿ªÒ»¸öѹËõÎļþµÄ²ÎÊýÖ¸Á 3 |& u2 z: k( A# ?% c
-t £º²é¿´ tarfile ÀïÃæµÄÎļþ£¡
9 ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ