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 spatial¿Õ¼äº¯Êý³ö´í£¬³ö´íÇé¿öÈçÏ Errors in file /user/oracle/app/oracle/admin/grid/udump/grid1_ora_143768.trc: ORA-29902: error in executing ODCIIndexStart() routine ORA-0 ......
ÓÃPL/SQL µÇ½ʱµ¯³ö±¨´í´°¿Ú£¬´íÎóÈçÏ£¡ ORA-01034:ORACLE not available ORA-27101:shared memory realm does not exist ÇëÎÊ£¬ÓÐûÓÐÈËÓöµ½ÕâÖÖÇé¿ö£¬Ôõô½â¾ö£¿Ð»Ð»£¡ 1. Oracle sid ÕýÈ ......
×öÍædata guard ºó ÔÚPrimary·þÎñÆ÷ Ö´ÐÐ SQL>SELECT SEQUENCE#,APPLIED from V$ARCHIVED_LOG ORDER BY SEQUENCE#; SEQUENCE# APP ---------- --- 13 NO 13 YES ......
oracle ͨ¹ýBDlink Á¬½Óµ½Ò»Ì¨MS SQL,²éѯ¶¼¿ÉÒÔ,µ«ÊDz»ÖªµÀÈçºÎÔÚoracleͨ¹ýDBLinkµ÷ÓÃMS SQLµÄ´æ´¢¹ý³Ì,Çó½â~лл~ ÒýÓà oracle ͨ¹ýBDlink Á¬½Óµ½Ò»Ì¨MS SQL,²éѯ¶¼¿ÉÒÔ,µ«ÊDz»ÖªµÀÈçºÎÔÚoracleͨ¹ýDBLinkµ÷ÓÃM ......
ÎÒÔÚ³ÌÐòÖн«oracleÊý¾Ý¿âµÄ¶«Î÷select³öÀ´ ÔÙ²åÈëµ½MDBÖÐ £¬È»ºóÔÙMDBÖв鿴µÄʱºò·¢ÏÖÓкܶà×Ö¶ÎÖµ¶¼Ëð»µÁËÎÞ·¨ÏÔʾ£¬ÔÚµ¼³ö¹ý³ÌÖÐûÓгöÏÖ´íÎ󣬲»ÖªµÀÊÇʲôÔÒòÔì³ÉµÄ°¡£¿ ÀàÐÍ¿ÉÊÇÒ»Öµģ¿ ÒýÓà ÀàÐÍ¿É ......