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
Ïà¹ØÎĵµ£º
select i.sid,i.sname,i.birthday,i.schooltime,i.sphone,c.classname,a.assnname,sum(decode(subject,'ÓïÎÄ',s.score,0)) as chin,
......
OracleÖÐDecode()º¯ÊýʹÓü¼ÇÉ
¡¡¡¡decode()º¯ÊýÊÇORACLE PL/SQLÊǹ¦ÄÜÇ¿´óµÄº¯ÊýÖ®Ò»£¬Ä¿Ç°»¹Ö»ÓÐORACLE¹«Ë¾µÄSQLÌṩÁ˴˺¯Êý£¬ÆäËûÊý¾Ý¿â³§É̵ÄSQLʵÏÖ»¹Ã»Óд˹¦ÄÜ¡£
DECODEº¯ÊýÊÇORACLE PL/SQLÊǹ¦ÄÜÇ¿´óµÄº¯ÊýÖ®Ò»£¬Ä¿Ç°»¹Ö»ÓÐORACLE¹«Ë¾µÄSQLÌṩÁ˴˺¯Êý£¬ÆäËûÊý¾Ý¿â³§É̵ÄSQLÊµÏ ......
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
µÄ¿Í»§¶ËÈí¼þ£¬Î¨Ò»µÄÀýÍâ¾ÍÊÇ
java
Á¬½ÓÊý¾Ý¿âµÄʱºò£¬¿ÉÒÔÓÃ
jdbc thin
ģʽ£¬²»ÓÃ×°
oracle
µÄ¿Í»§¶ËÈí¼þ¡£¼ÓÈëÄãÔÚ»úÆ÷ÉÏ×°ÁË
oracle
Êý¾Ý¿â£¬¾Í²»ÐèÒªÔÚµ¥¶ÀÔڸûúÆ÷ÉÏ°²×°
oracle
¿Í»§¶ËÁË£¬ÒòΪװ
oracle
Êý¾Ý¿âµÄʱºò»á×Ô¶ ......
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 ......