Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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


Ïà¹ØÎĵµ£º

LinuxÄÚºËÅäÖÃÎĵµ(make menuconfig)

Ò»¡¢ÒýÑÔ£º
    ±¾ÎĵµµÄÄÚÈݴ󲿷ÝÄÚÈݶ¼ÊÇ´ÓÍøÉÏÊÕ¼¯¶øÀ´£¬È»ºóÅäºÏһЩеĽØÍ¼£¨Äں˰汾£ºV2.4.19£©¡£ÔÚÿһÅäÖÃÏîºó»áÓÐÒ»¸öÑ¡ÔñÖ¸ÄϵIJ¿·Ý£¬ÓÃÀ´Ö¸µ¼´ó¼ÒÔõôÑù¸ù¾Ý×Ô¼ºµÄÇé¿öÀ´×öÏàÓ¦µÄÑ¡Ôñ£»»¹ÓÐÔÚÿһ¸ö´óÏîºÍÎĵµµÄ×îºó»áÓÐÒ»¸ö¾­Ñé̸£¬ËüÊÇһЩ¸ßÊÖÃÇÔÚÓ¦¶ÔÎÊÌâºÍ´¦ÀíÌØÓÐÓ²¼þʱµÄһЩ¾­Ñ飨Õâ¸ö»¹µ ......

Oracle±í¿Õ¼ä³£ÓòÙ×÷

1. ²é¿´Oracle´´½¨¹ýÄÄЩÓû§
   >select username from all_users;
2. ²é¿´Oracle´´½¨¹ýÄÄЩ±í¿Õ¼ä£¬±í¿Õ¼äµÄÃû×ֺʹóС
   >select t.tablespace_name, round(sum(bytes/(1024*1024)),0) ts_size
    from dba_tablespaces t, dba_data_files d
    wher ......

oracleÐÐתÁÐ

select i.sid,i.sname,i.birthday,i.schooltime,i.sphone,c.classname,a.assnname,sum(decode(subject,'ÓïÎÄ',s.score,0)) as chin,
                              ......

ÈçºÎÅäÖòÅÄÜʹ¿Í»§¶ËÁ¬µ½oracleÊý¾Ý¿â

Ҫʹһ¸ö¿Í»§¶Ë»úÆ÷ÄÜÁ¬½Ó
oracle
Êý¾Ý¿â£¬ÐèÒªÔÚ¿Í»§¶Ë»úÆ÷Éϰ²×°
oracle
µÄ¿Í»§¶ËÈí¼þ£¬Î¨Ò»µÄÀýÍâ¾ÍÊÇ
java
Á¬½ÓÊý¾Ý¿âµÄʱºò£¬¿ÉÒÔÓÃ
jdbc thin
ģʽ£¬²»ÓÃ×°
oracle
µÄ¿Í»§¶ËÈí¼þ¡£¼ÓÈëÄãÔÚ»úÆ÷ÉÏ×°ÁË
oracle
Êý¾Ý¿â£¬¾Í²»ÐèÒªÔÚµ¥¶ÀÔڸûúÆ÷Éϰ²×°
oracle
¿Í»§¶ËÁË£¬ÒòΪװ
oracle
Êý¾Ý¿âµÄʱºò»á×Ô¶ ......

¡¾Nutch¡¿LinuxÏÂÓ¦ÓÃnutch 1.0 Webǰ¶ËʵÏÖµ¥»ú¼ìË÷

nutchµÄÅÀ³æºÍËÑË÷¿ÉÒÔ˵ÊÇ·ÖÀëµÄÁ½¿é£¬ÅÀ³æ¿ÉÒÔÊÇM/R×÷Òµ£¬µ«ËÑË÷²»ÊÇM/R×÷Òµ¡£ËÑË÷ÓÐÁ½ÖÖ·½Ê½£ºÒ»Êǽ«ÅÀ³æÊý¾Ý(»òÕß³ÆË÷ÒýÊý¾Ý)·ÅÔÚ±¾µØÓ²ÅÌ£¬½øÐÐËÑË÷¡£¶þÊÇÖ±½ÓËÑË÷HDFSÖеÄÅÀ³æÊý¾Ý¡£
ÕâÀï½éÉÜÈçºÎʹÓÃnutch-1.0µÄWEBǰ¶Ë¼ìË÷±¾µØÅÀ³æÊý¾Ý£º
(1)NutchµÄËÑË÷¿ÉÒÔ¶ÀÁ¢ÓÚhadoop¼¯Èº£¬Ö»Òª½«ÅÀ³æÏÂÀ´µÄÊý¾Ýcopyµ½ÈκλúÆ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ