Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

Çë½ÌÒ»¸ö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]
ÒýÓ


Ïà¹ØÎÊ´ð£º

oracle·þÎñ״̬ÏÔʾ ¡°Í£Ö¹¡±

ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£
ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£
ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£

ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......

javaÔõôÁ¬½ÓOracle£¬¼±°¡ - Java / JavaÏà¹Ø

private static final String URL = "jdbc:oracle:thin:@localhost:1521:orcl";
private static final String USERNAME = "sys";
private static final String PASSWORD = "s ......

Windows 7 ÔõÑù°²×°Oracle - Oracle / »ù´¡ºÍ¹ÜÀí

¸÷λ´ó¸ç£¬°ï¸öæ¡£

ϸöOracle for vista °æ±¾µÄ°²×°ÊÔÊÔ
10GºÍ11GµÄ 
http://www.oracle.com/technology/software/products/database/index.html 
------------------------------------------- ......

oracle °²×° 01092 ´íÎó - Oracle / »ù´¡ºÍ¹ÜÀí

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 / ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ