ÔõÑùÉó²éoracle׼ʱʹÃüÈÕÖ¾
oracle ׼ʱʹÃüÈÕ־ͨ³£´æ´¢ÔÚ /u01/app/oracle/diag/rdbms//scheduler/ Ŀ¼ÖУ¬¿ÉÒÔͨ¹ýÒÔÏ°취Éó²é£º1. µÇ¼ oracle ЧÀÍÆ÷¡£2. µ¼º½µ½¸ÃĿ¼¡£3. Éó²éÈÕÖ¾ÎļþÁÐ±í¡£4. ʹÓÃÎı¾±à¼Æ÷·¿ªÈÕÖ¾Îļþ¡£
ÔõÑùÉó²é Oracle ׼ʱʹÃüÈÕÖ¾
Oracle ׼ʱʹÃüµÄÈÕ־ͨ³£´æ´¢ÔÚÒÔÏÂλÖãº
/u01/app/oracle/diag/rdbms/<oracle_sid>/scheduler/<scheduler_name></scheduler_name></oracle_sid>
µÇ¼ºó¸´ÖÆ
ÆäÖУº
ÊÇ Oracle ʵÀýµÄ SID¡£
ÊÇ׼ʱʹÃüµÄÃû³Æ¡£
ÒªÉó²é׼ʱʹÃüÈÕÖ¾£¬ÇëʹÓÃÒÔÏ°취£º
1. µÇ¼µ½ Oracle ЧÀÍÆ÷
ʹÓþßÓÐ×㹻ȨÏÞµÄÕÊ»§µÇ¼µ½ÔËÐÐ Oracle Êý¾Ý¿âµÄЧÀÍÆ÷¡£
2. µ¼º½µ½ÈÕ־Ŀ¼
ʹÓÃÒÔÏÂÏÂÁîµ¼º½µ½×¼Ê±Ê¹ÃüÈÕ־Ŀ¼£º
cd /u01/app/oracle/diag/rdbms/<oracle_sid>/scheduler/<scheduler_name></scheduler_name></oracle_sid>
µÇ¼ºó¸´ÖÆ
3. Éó²éÈÕÖ¾Îļþ
¸ÃĿ¼Öн«°üÀ¨¶à¸öÈÕÖ¾Îļþ£¬Í¨³£ÃüÃûΪÒÔÏÂÐÎʽ£º
scheduler_<scheduler_name>_*.log</scheduler_name>
µÇ¼ºó¸´ÖÆ
ÿ¸öÈÕÖ¾Îļþ¶ÔÓ¦ÓÚ²î±ðµÄʱ¼ä¶Î¡£Äú¿ÉÒÔʹÓà ls ÏÂÁîÉó²éÈÕÖ¾ÎļþÁÐ±í£º
ls -l
µÇ¼ºó¸´ÖÆ
4. ʹÓÃÎı¾±à¼Æ÷·¿ªÈÕÖ¾Îļþ
ʹÓÃÎı¾±à¼Æ÷£¨Èç vi¡¢nano »ò more£©·¿ªÒªÉó²éµÄÈÕÖ¾Îļþ£º
vi scheduler_<scheduler_name>_*.log</scheduler_name>
µÇ¼ºó¸´ÖÆ
ÈÕÖ¾Îļþ½«ÏÔʾÓйØ׼ʱʹÃüÖ´ÐеÄÐÅÏ¢£¬°üÀ¨Ö´ÐÐʱ¼ä¡¢×´Ì¬¡¢ÔËÐеÄ×÷ÒµÒÔ¼°Óöµ½µÄÈκιýʧ¡£
ÒÔÉϾÍÊÇÔõÑùÉó²éoracle׼ʱʹÃüÈÕÖ¾µÄÏêϸÄÚÈÝ£¬¸ü¶àÇë¹Ø×¢±¾ÍøÄÚÆäËüÏà¹ØÎÄÕ£¡