Çë½ÌÒ»¸öoracle¹ÜÀíµÄÎÊÌ⣡ - Oracle / »ù´¡ºÍ¹ÜÀí
·þÎñÆ÷ºǫ́µÄÊý¾Ý¿âÊÇoracle£¬ÔÚ½ñÌìϵͳµÇ¼µÄʱºò±¨¡°µÇ¼²»ÁËÊý¾Ý¿â£¬IOÒì³£¡±£¬½á¹ûÊÇÈ«¹«Ë¾¶¼µÇ²»ÉÏÈ¥£¬ÎÒÖØÆôÁËһϷþÎñÆ÷²ÅºÃÁË£¬ÎÒÏë¿ÉÄÜÊÇÓû§²¢·¢Á¿Ì«´óµÄÔµ¹Ê£¬²»ÖªµÀ¸÷λ´óϺÈÏͬ²»£¿ÓÐʲô½â¾ö°ì·¨Ã»£¿Ã»·ÖÁË£¬ÇëÔÁ£¡
°ÑalertÈÕÖ¾·ÅÉÏÀ´¿´¿´ ¶Ô²»ÄÜ¿¿²ÂµÎ£¬ ²é¿´Ò»ÏÂÊý¾Ý¿âalter<sid>.logÈÕÖ¾£¬È·ÈÏÊÇ·ñÊÇÊý¾Ý¿âÎÊÌâ¡£ÒýÓà ·þÎñÆ÷ºǫ́µÄÊý¾Ý¿âÊÇoracle£¬ÔÚ½ñÌìϵͳµÇ¼µÄʱºò±¨¡°µÇ¼²»ÁËÊý¾Ý¿â£¬IOÒì³£¡±£¬½á¹ûÊÇÈ«¹«Ë¾¶¼µÇ²»ÉÏÈ¥£¬ÎÒÖØÆôÁËһϷþÎñÆ÷²ÅºÃÁË£¬ÎÒÏë¿ÉÄÜÊÇÓû§²¢·¢Á¿Ì«´óµÄÔµ¹Ê£¬²»ÖªµÀ¸÷λ´óϺÈÏͬ²»£¿ÓÐʲô½â¾ö°ì·¨Ã»£¿Ã»·ÖÁË£¬ÇëÔÁ£¡ »¹ÊÇÒª¿´¿´alertÈÕÖ¾Îļþ£¬Àï±ßÓ¦¸ÃÄÜÕÒµ½Ò»Ð©Òì³£Çé¿ö¡£ ºÃµÄ£¬Ð»Ð»¸÷λ´óϺ£¬ÎÒÈ¥¹«Ë¾ÕÒÒ»ÏÂÈÕÖ¾£¡ ÒòΪ̫´ó£¬·Åµ½ÎҵIJ©¿ÍÀïµÄÁ½ÆªÎÄÕ£¬ÒòΪ³õѧoracle£¬ËùÒÔÇë¸÷λ¶à¶à°ïÖú£¬Á´½ÓÓÐÁ½¸ö£º Ò»¸öÊÇhttp://blog.csdn.net/xzb_99/archive/2010/04/29/5544316.aspx ÁíÍâÒ»¸öÊÇhttp://blog.csdn.net/xzb_99/archive/2010/04/29/5544287.aspx ·þÎñÆ÷ÊÇ windows 2003server 64λ oracleÊÇ oracle10g 64λ Çë½Ì¸÷λ´óϺ£¡ alertÈÕÖ¾ÖÐÖ»·¢ÏÖÒ»¸öJOBÖ´ÐÐʧ°Ü£¬ÎÞÆäËüÒì³£¡£ ÊÇɶOS£¿ ¼ÙÈçÊÇWINDWOS£¬¿ÉÒÔÔÙ¿´¿´WINDOWSµÄʼþ¹ÜÀíÆ÷¡£ ÁíÍ⣬ select * from v$resource_limit where resource_name in ('processes', 'sessions'); ´ÓÕâ¸öSQLÖвéһϣ¬ÊÇ·ñÓдﵽLIMITµÄÏÞÖÆ End_rbody_65101420//--> ¸Ã»Ø¸´ÓÚ2010-04-30 16:05:27±»¹ÜÀíԱɾ³ý ¶ÔÎÒÓÐÓÃ[0] ¶ª¸ö°åש[0] ÒýÓ
Ïà¹ØÎÊ´ð£º
ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£ ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£ ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£ ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......
private static final String URL = "jdbc:oracle:thin:@localhost:1521:orcl"; private static final String USERNAME = "sys"; private static final String PASSWORD = "s ......
¸÷λ´ó¸ç£¬°ï¸öæ¡£ ϸöOracle for vista °æ±¾µÄ°²×°ÊÔÊÔ 10GºÍ11GµÄ http://www.oracle.com/technology/software/products/database/index.html ------------------------------------------- ......
oracle 11g °²×° 01092 ´íÎó, ÈÕÖ¾ÐÅÏ¢£º [oracle@linux trace]$ vi alert_orcl.log MMON started with pid=14, OS id=9089 RESETLOGS after incomplete recovery UNTIL CHANGE 522752 Errors in file / ......