oracle startup shutdownÃüÁî
дЩ»ù´¡µÄ! ¶Ô×Ô¼º»¹ÊÇÓкô¦µÄ.
shutdownÓÐËĸö²ÎÊý£ºnormal¡¢transactional¡¢immediate¡¢abort¡£È±Ê¡²»´øÈκβÎÊýʱ±íʾÊÇnormal
Ò»:
shutdown normal:
²»¶Ï¿ªÏÖÔÚÁ¬½ÓµÄÓû§,×èÖ¹ÈκÎÓû§½¨Á¢ÐµÄÁ¬½Ó£¬°üÀ¨¹ÜÀíÔ±ÔÚÄÚ¡£ÒѾÁ¬½ÓµÄÓû§Äܹ»¼ÌÐøËûÃǵ±Ç°µÄ¹¤×÷,ÈçµÝ½»ÐµĸüÐÂÊÂÎñ,Ö±µ½´ËÓû§×ÔÐжϿªÁ¬½Ó.ÕâÑùÐèÒªµÈ´ýµÄʱ¼ä³¤,¿ÉÒÔ²é³öÏÖÁ¬Óû§,ÔÙ֪ͨÆä×ÔÐжϿª.
ËùÓеÄÓû§¶¼¶Ï¿ªÁ¬½Ó£¬Êý¾Ý¿â²Å½øÐйرղÙ×÷£¬¼´¹Ø±ÕÊý¾Ý¿â¡¢Ð¶ÔØÊý¾Ý¿â¡¢ÖÕÖ¹Àý³Ì¡£ÔÚÕâÖÖÇé¿öϹرյÄÊý¾Ý¿âÔÚÖØÐÂÆô¶¯ºó£¬²»»á³öÏÖÎÊÌâ¡£Æô¶¯Ê±²»ÐèҪʵÀý»Ö¸´¡£
¶þ:
shutdown transactional
×èÖ¹ÈκÎÓû§½¨Á¢ÐµÄÁ¬½Ó¡£µÈ´ýËùÓе±Ç°Á¬½ÓÓû§µÄδµÝ½»µÄ»î¶¯ÊÂÎñÌá½»Íê±Ï£¬È»ºóÁ¢¼´¶Ï¿ªÓû§µÄÁ¬½Ó¡£ËùÓеÄÓû§¶¼¶Ï¿ªÁ¬½ÓÔòÁ¢¼´¹Ø±ÕÊý¾Ý¿â£¬½øÐйرÕÊý¾Ý¿â¡¢Ð¶ÔØÊý¾Ý¿â¡¢ÖÕÖ¹½ø³ÌµÈ²Ù×÷¡£ÕâÖÖ·½Ê½,Óû§ÓпÉÄÜÕýÔÚËãÕË,×ö¸´ÔÓ±¨±í!Ò»´ÎÊý¾Ý¿â²Ù×÷×ö²»ÍêµÄ,ÔÚ¸Õ×öÁËÒ»´ÎÊý¾Ý¿â²Ù×÷ºó,½«±»¶Ï¿ª,ÕâÑù¶ÔÓû§ÓÐÒ»¶¨Ó°Ïì.Æô¶¯Ê±²»ÐèҪʵÀý»Ö¸´¡£
Èý:
shutdown immediate
×èÖ¹ÈκÎÓû§ÐµÄÁ¬½Ó£¬Í¬Ê±ÏÞÖƵ±Ç°Á¬½ÓÓû§¿ªÊ¼ÐµÄÊÂÎñ¡£Èç¹ûÒÑÁ¬½ÓÓû§ÓÐδÍê³ÉµÄÊÂÎñ£¬ÔòÊý¾Ý¿âϵͳ²»»áµÈ´ýËûÃÇÍê³É£¬¶øÊÇÖ±½Ó°Ñµ±Ç°Î´µÝ½»µÄÊÂÎñ»ØÍË¡£Êý¾Ý¿âϵͳ²»ÔٵȴýÓû§Ö÷¶¯¶Ï¿ªÁ¬½Ó£¬µ±Î´µÝ½»µÄÊÂÎñ»ØÍ˳ɹ¦ºó£¬ÏµÍ³»áÖ±½Ó¹Ø±Õ¡¢Ð¶ÔØÊý¾Ý¿â£¬²¢ÖÕÖ¹Êý¾Ý¿â½ø³Ì¡£Æô¶¯Ê±²»ÐèҪʵÀý»Ö¸´¡£
ËÄ:
shutdown abort
µ±Êý¾Ý¿â³öÏÖ¹ÊÕÏʱ£¬¿ÉÄÜÒÔÉÏÈýÖÖ·½Ê½¶¼ÎÞ·¨Õý³£¹Ø±ÕÊý¾Ý¿â,ÔòʹÓÃÕâÖÖ·½·¨.Ç¿ÖƽáÊøµ±Ç°ÕýÔÚÖ´ÐеÄSQLÓï¾ä;ÈκÎδµÝ½»µÄÊÂÎñ¶¼²»±»»ØÍË! ÕâÖÖ·½·¨»ù±¾Éϲ»»á¶Ô¿ØÖÆÎļþ»òÕß²ÎÊýÎļþÔì³ÉÆÆ»µ¡£Õâ±ÈÇ¿ÖƹػúÒªºÃÒ»µã(ÔÚÎÞ·¨Õý³£¹Ø±ÕÊý¾Ý¿âµÄʱºò).Æô¶¯Ê±×Ô¶¯½øÐÐʵÀý»Ö¸´¡£
¶ÔÓÚnormal¡¢transactional¡¢immediate£¬db bUFFER cACHEµÄÄÚÈÝдÈëÁËÊý¾ÝÎļþ£¬Ã»ÓÐÌá½»µÄÊÂÎñ±»»Ø¹ö£¬ËùÓеÄ×ÊÔ´±»ÊÍ·Å£¬Êý¾Ý¿â±»“¸É¾»”µÄ¹Ø±Õ¡£
¶ÔÓÚabort£¬db bUFFER cACHEµÄÄÚÈÝûÓÐдÈëÊý¾ÝÎļþ£¬Ã»ÓÐÌá½»µÄÊÂÎñҲûÓлعö¡£Êý¾Ý¿âûÓÐDISMOUNTºÍ¹Ø±Õ£¬Êý¾ÝÎļþҲûÓйرա£µ±Êý¾Ý¿âÆô¶¯Ê±£¬ÐèҪͨ¹ýREDO LOG»Ö¸´Êý¾Ý£¬Í¨¹ý»Ø¹ö¶Î¶ÔÊÂÎñ»Ø¹ö£¬¶Ô×ÊÔ´½øÐÐÊÍ·Å¡£
²âÊÔʱ·¢ÏÖÈçÏÂÎÊÌâ(ÓÃsysdbaµÇ½)
ORA-00106: ÎÞ·¨ÔÚÁ¬½Óµ½µ÷¶È³ÌÐòʱÆô¶¯/¹Ø±ÕÊý¾Ý¿â
½â¾ö·½·¨
&nb
Ïà¹ØÎĵµ£º
•±í·ÖÇø¼¼ÊõÊÇÔÚ³¬´óÐÍÊý¾Ý¿â(VLDB)Öн«´ó±í¼°ÆäË÷Òýͨ¹ý·ÖÇø£¨patition£©µÄÐÎʽ·Ö¸îΪÈô¸É½ÏС¡¢¿É¹ÜÀíµÄС¿é£¬²¢ÇÒÿһ·ÖÇø¿É½øÒ»²½»®·ÖΪ¸üСµÄ×Ó·ÖÇø£¨sub partition£©
•Í¨¹ý¶Ô±í½øÐзÖÇø£¬¿ÉÒÔ»ñµÃÒÔϵĺô¦
–¼õÉÙÊý¾ÝË𻵵ĿÉÄÜÐÔ
–¸÷·ÖÇø¿ÉÒÔ¶ÀÁ¢±¸·ÝºÍ»Ö¸´£¬ÔöÇ¿ÁËÊý¾Ý¿âµÄ¿É¹ÜÀíÐÔ
......
ÇëÑéÖ¤Ò»ÏÂsolarisºÍoracleµÄ°æ±¾ÐÅÏ¢£¬Èç¹û°æ±¾ºÅ²»¶Ô£¬¿ÉÄܻᰲװʧ°Ü
solaris°æ±¾£ºSunOs 5.10
oracle°æ±¾£º Oracle Database 10g Release 2 (10.2.0.2) for Solaris Operating System (x86)
**Èç¹û²»ÖªµÀsolarisµÄ°æ±¾£¬¿ÉÒÔÔÚÃüÁî´°¿ÚÊäÈë:uname -a
µÚÒ»²½:ÒÔROOTÉí·ÝµÇ½ϵͳ
µÚ¶þ²½:´´½¨Óû§ºÍ×é:
#groupadd ......
ÔÚѧϰoracleµÄʱºòÓöµ½ÁËÒ»¸öÎÊÌ⣬µ±ÎҵǼscottÓû§µÄʱºòÔõô¾ÍÊÇÁ´½Ó²»ÉÏ£¬³öÏÖÁËÒÔÏ´íÎóÌáʾ£¬the account is locked,˵Ã÷scottÓû§±»ËøסÁË£¬ÎҾͽøÐÐÁ˽âËø£¬Óï¾äÈçÏ£ºalter user soctt account unlock;Ö´ÐÐÍêÒÔºó·¢ÏÖÓÖÌáʾÁËÒ»¸ö´íÎóÐÅÏ¢£¬No Connect
ÎÞ·¨Á´½Ó£¬ºóÀ´ÔÚÍøÉϲéÁ˲飬ÖÕÓÚÕÒµ ......
¡¡¡¡select * from perexl order by nlssort(danwei,'NLS_SORT=SCHINESE_PINYIN_M');
¡¡¡¡-- °´²¿Ê×ÅÅÐò
¡¡¡¡select * from perexl order by nlssort(danwei,'NLS_SORT=SCHINESE_STROKE_M');
¡¡¡¡-- °´±Ê»ÅÅÐò
¡¡¡¡select * from perexl order by nlssort(danwei,'NLS_SORT=SCHINESE_RADICAL_M');
¡¡¡¡--ÅÅÐòºó»ñÈ¡µÚ ......
36.ADD_MONTHS
¡¡¡¡Ôö¼Ó»ò¼õÈ¥Ô·Ý
¡¡¡¡SQL> select to_char(add_months(to_date(199912,yyyymm),2),yyyymm) from dual;
¡¡¡¡TO_CHA
¡¡¡¡------
¡¡¡¡200002
¡¡¡¡SQL> select to_char(add_months(to_date(199912,yyyymm),-2),yyyymm) from dual;
¡¡¡¡TO_CHA
¡¡¡¡------
¡¡¡¡199910
¡¡¡¡37.LAST_DAY
¡¡¡¡·µ» ......