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

×ÜÀÀ
ÓÃiptables -ADC À´Ö¸¶¨Á´µÄ¹æ
Ôò
£¬-AÌí¼Ó -Dɾ³ý -C ÐÞ¸Ä
iptables - [RI] chain rule num rule-specification[option]
ÓÃiptables - RI ͨ¹ý¹æÔòµÄ˳ÐòÖ¸¶¨
iptables -D chain rule num[option]
ɾ³ýÖ¸¶¨¹æÔò
iptables -[LFZ] [chain][option]
ÓÃiptables -LFZ Á´Ãû [Ñ¡Ïî]
iptables -[NX] chain
ÓÃ -NX ......

Oracle trunc º¯ÊýµÄʹÓÃ

OracleµÄtrunc º¯ÊýÒ»°ãÓÃÀ´ ¶ÔÈÕÆÚºÍʱ¼ä½øÐнØÈ¡¡£
 
1¡¢Êý×Ö´¦Àí ¡£½ØÈ¡
 
 select trunc(5.75),trunc(5.75,1),trunc(5.75,-1),trunc(556.234,-2) from dual;
 
 
Êä³ö:
TRUNC(5.75) TRUNC(5.75,1) TRUNC(5.75,-1) TRUNC(556.234,-2)
----------- ------------- -------------- ----- ......

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ÖÐDecode()º¯ÊýʹÓü¼ÇÉ

OracleÖÐDecode()º¯ÊýʹÓü¼ÇÉ
¡¡¡¡decode()º¯ÊýÊÇORACLE PL/SQLÊǹ¦ÄÜÇ¿´óµÄº¯ÊýÖ®Ò»£¬Ä¿Ç°»¹Ö»ÓÐORACLE¹«Ë¾µÄSQLÌṩÁ˴˺¯Êý£¬ÆäËûÊý¾Ý¿â³§É̵ÄSQLʵÏÖ»¹Ã»Óд˹¦ÄÜ¡£
      DECODEº¯ÊýÊÇORACLE PL/SQLÊǹ¦ÄÜÇ¿´óµÄº¯ÊýÖ®Ò»£¬Ä¿Ç°»¹Ö»ÓÐORACLE¹«Ë¾µÄSQLÌṩÁ˴˺¯Êý£¬ÆäËûÊý¾Ý¿â³§É̵ÄSQLÊµÏ ......

GNU/Linux ¿ª·¢»·¾³ £¨1£©

¼¸ÖÜÒÔÇ°£¬ÎÞÒâÖп´ÁËÎÒ¿ª·¢Linux·þÎñ³ÌÐòµÄ¹¤×÷»·¾³´îÅäÕâƪÎÄÕ£¬È̲»×¡ÅÄÁËש£¬½á¹û×÷ÕßÔڻظ´Öм¤ÎÒ£¬ÒªÎÒд¸ö¿´¿´¡£Æäʵ¿´²»¹ßºÜ¶àÈËΧÈÆM$µÄÏ°¹ß£¬ÔçÒÑÓÐдµãʲôµÄÏë·¨£¬¿ÉÊÇûʲôʱ¼ä£¬Ò²µ£ÐIJ»Í¬µÄÏë·¨ºÍ×Ô¼ºÍ˲½Á˺ܶàµÄÖÐÎÄ»áÃÔ»óÓÐLinuxѧϰÈÈÇéµÄͬÐУ¬¸ü²»ÓÃ˵û׼»¹»áÏÅÅܱðÈË¡£ÎªÁ˱íʾÎÒÊÇ´ÓÀ´²»³Ô¼¤½«·¨ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ