oracle 10gÈÕÖ¾²é¿´·½·¨ - Oracle / ¿ª·¢
ÏêϸµÄ²½Öè¡£¡£ ÍùÉÏÕҵͼÊDZðÈ˵½´¦¿½±´µÄ¡£¡£ ÎÒµÄoracle°æ±¾Îª10g Êý¾ÝÎļþ£¬¿ØÖÆÎļþ£¬ÈÕÖ¾ÎļþµÄµØÖ·Îª£ºE:\oracle\product\10.2.0\oradata\orcl ²ÎÊýÎļþÔÚ E:\oracle\product\10.2.0\admin\orcl\pfile ллÁË¡£¡£ ¾±¾ÈËÈ·ÈϺó½áÌù¸ø·Ö¡£¡£
http://blog.csdn.net/tianlesoftware/archive/2010/05/19/5604497.aspx ÎÒÏàÐÅËûµÄBOLG....Äã¿´¿´ÄÇ..ÓÐÎÊÌâ¿ÉÒÔÎÊËû... 1¡¢ Èç¹ûÂ¥Ö÷ÏëÒª²é¿´µÄÊDZ¨¾¯ÈÕÖ¾£¨alert log£©µÄ»° ¿ÉÒÔÔÚÈçÏ·¾¶²é¿´ Ö±½ÓÓÃÎı¾±à¼Æ÷¾Í¿ÉÒÔ´ò¿ª E:\oracle\product\10.2.0\admin\orcl\bdump ÀïÃæÓ¦¸ÃÓиöalert_orcl.log 2¡¢ Èç¹ûÂ¥Ö÷Ïë²é¿´µÄÊÇÁª»úÖØ×öÈÕÖ¾£¨online redo log£©µÄ»° ¿ÉÒÔʹÓÃlogminerÈ¥²é¿´ ʹÓ÷½·¨ÍøÉϺܶà Ëæ±ãËÑһϾÍÓÐ ÕâλÈÊÐֵIJ©¿Í¹ûÈ»²»´í!ÒýÓà http://blog.csdn.net/tianlesoftware/archive/2010/05/19/5604497.aspx ÎÒÏàÐÅËûµÄBOLG....Äã¿´¿´ÄÇ..ÓÐÎÊÌâ¿ÉÒÔÎÊËû... û´íû´í ÎÒ¾ÍÒª¿´redolog ¾ÍÏëÓÃlogminer Õâ¸ö¡£ ѧϰÁË 1¡¢ Èç¹ûÂ¥Ö÷ÏëÒª²é¿´µÄÊDZ¨¾¯ÈÕÖ¾£¨alert log£©µÄ»° ¿ÉÒÔÔÚÈçÏ·¾¶²é¿´ Ö±½ÓÓÃÎı¾±à¼Æ÷¾Í¿ÉÒÔ´ò¿ª E:\oracle\product\10.2.0\admin\orcl\bdump ÀïÃæÓ¦¸ÃÓиöalert_orcl.log 2¡¢ Èç¹ûÂ¥Ö÷Ïë²é¿´µÄÊÇÁª»úÖØ×öÈÕÖ¾£¨online redo log£©µÄ»° ¿ÉÒÔʹÓÃlogminerÈ¥²é¿´ ʹÓ÷½·¨ÍøÉϺܶà Ëæ±ãËÑһϾÍÓÐ LogMinerµÄʹÓà : ÎÒǰ²»¾Ã²Åʱ¼äʵÑéºó×ܽáµÄ,Äã¿´¿´°É: http://blog.sina.com.cn/s/blog_3fb41b900100h497.html
Ïà¹ØÎÊ´ð£º
ÎÒÔÚ¿ª·¢µÄÕâ¸öÓ¦Óò¢·¢ÐԱȽϸߣ¬oracle¸üÐÂÊý¾ÝʱºòÈçºÎ´¦Àí²¢·¢´¦ÀíÄØ£¿¸÷λ´óÏÀ·¢±íºÃµÄ¹Ûµã°¡£¬ÔÚÏߵȴý£¡ oracleÊý¾Ý¸üÐÂʱ£¬»á×Ô¶¯Ä¬ÈÏÐÐËø¶¨£¬Â¥Ö÷²»Òª²ÙÐÄ£¬Oracle¶Ô²¢Ðд¦ÀíÒѾºÜ³ÉÊìÁË ÒýÓà oracle ......
ÓÃPL/SQL µÇ½ʱµ¯³ö±¨´í´°¿Ú£¬´íÎóÈçÏ£¡ ORA-01034:ORACLE not available ORA-27101:shared memory realm does not exist ÇëÎÊ£¬ÓÐûÓÐÈËÓöµ½ÕâÖÖÇé¿ö£¬Ôõô½â¾ö£¿Ð»Ð»£¡ 1. Oracle sid ÕýÈ ......