oracle uptimeµÄbug
Ö¢×´£ºoracle sqlplusû·´Ó¦
oracle10gµÄÓÐÊ®¼¸¸ö»úÆ÷¿Í»§¶Ë10.2.0.1.0£¬Ö´ÐÐsqlplusÕâ¸öÃüÁîû·´Ó³¡£´ËʱcpuʹÓÃΪ99.9%£¬¹Û²ìÁËÒ»»á£¬²»ÊÍ·Å¡£
oracleÆäËûÃüÁî¶¼ºÃʹ¡£
»·¾³±äÁ¿¡¢ping tnsnameµÈ¶¼Ã»ÎÊÌâ¡£¡£ÇÒÕâЩ»úÆ÷¶¼ÊÇÖÁÉÙÔËÐÐÁË200¶àÌì×óÓÒ£¬
µ«Ò»µ©ÖØÆôOS¾ÍºÃʹÁË¡£¡£
»òÕß²»ÖØÆôOS£¬»»³É9iµÄ¿Í»§¶Ë£¬sqlplusÃüÁîÒ²ºÃʹ¡£
alertÈÕ־ûÓÐʲôÃ÷ÏԵı¨¾¯ÐÅÏ¢£¬¿Í»§¶ËµÄsqlnet.logΪ¿Õ¡£
ÓÃstrace¸ú×ÙÁËһϿͻ§¶Ë10µÄsqlplusÃüÁ³öÏÖ£º
--- SIGSTOP (Stopped (signal)) @ 0 (0) ---
--- SIGSTOP (Stopped (signal)) @ 0 (0) ---
times(NULL) = -2064519321
times(NULL) = -2064519321
times(NULL) = -2064519321
……
ËùÓпͻ§¶ËÅäÖÃÒ»Ñù£¬ÏµÍ³ÐÅÏ¢£º
Red Hat Enterprise Linux AS release 4 (Nahant Update 2)
2.6.9-22.ELsmp #1 SMP
¿Í»§¶ËÓ²¼þҪôÁªÏëͬһÐͺŻúÆ÷£¬ÒªÃ´¾ÍÊÇHPͬÒÔÐͺŻúÆ÷¡£
ÊDz»ÊÇÓÐʲô²¹¶¡Ã»´ò£¬»òÕߺÍOSʲôÅäÖÃÓйأ¿
ϵͳÐÅÏ¢ÀàËÆÒ»Ï£º
sar -u ºó%idleΪ0£¬
µ«sar -A ²é¿´%idleΪ99.70µÈ°Ù·ÖÖ®¾ÅÊ®¶à×óÓÒ£¬
È»ºóÊÇ%user %system %iowaitÖ®¼ä»¥Ïà±ä»¯¡£
solution:
ÒòΪoracleÓÐbug£¬ÏµÍ³¿ª»úÌ«³¤£¬ÏµÍ³»áhang
ËùÒÔÒª²é¿´osÃüÁîuptimeÀ´¿´ÏµÍ³Æô¶¯¶à³¤Ê±¼äÁË£¬
Ò»°ãÖØÆô»á½â¾öÎÊÌ⣬ͨ¹ýÉý¼¶Ò²¿ÉÒÔ½â¾ö
ÎÊÌâ»ù±¾¶¨Î»ÎªORACLE¿Í»§¶ËÈí¼þµÄBUG£¬
Éæ¼°µÄ°æ±¾£ºORACLE 10.2.0.1.0
ÏÖÏó¾ÍÊÇUPTIME>50Ì죬¼´ÓпÉÄܳöÏÖÔËÐÐSQLPLUSºóÎÞ·´Ó¦µÄÏÖÏó£¬Ö÷ÒªÔÒòÊÇʱ¼äÒç³ö´íÎó
½â¾ö°ì·¨£ºÉý¼¶ORACLE¿Í»§¶Ëµ½10.2.0.2.0,¹ÙÍøÒѾ¹«²¼ÔÚÕâ¸ö°æ±¾½â¾öÁË´ËÎÊÌâ
£¨»ò½µ¼¶µ½9I,9I¾ø¶Ô²»»á³öÏÖÕâ¸öÎÊÌ⣻»ò½µ¼¶µ½10.1.0.4°æ±¾£¬Õâ¸öûÓо¹ýÈ«Ãæ²âÊÔ£©
½ÓÏÂÀ´¾ÍÊÇÉý¼¶ÊÔÊÔ¿´ÁË¡£
Óм¸ÖÖÇé¿ö£¬»ù±¾ÊÇoracleÄÚ²¿¶¨Ê±Æ÷¼ÆËãÓÐÎ󣬻¹ÓÐdays>24,»òÕßdays>240+µÄÇé¿ö
ÒÔǰÓÐOracle hang after 240+ da
Ïà¹ØÎĵµ£º
¹ØÓÚOracleÀïÃæµÄһЩСº¯Êý
ÒªÇó£ºA.Êý¾Ý¿â±íÖеÄÒ»¸ö×Ö·û´® ¿ÉÄܺ¬ÓÐ"+" Àý£ºORC+001
Ò²¿ÉÄܲ»º¬“+”
B.ÒªÇóÈç¹û¸Ã×Ö·û´®º¬ÓГ+”£¬ÔòÈ¡“+”֮ǰµÄ×Ö·û Àý£ºORC+001 È¡ORC
  ......
£££££¹ØÓÚ·Ö×éºó×Ö¶ÎÆ´½ÓµÄÎÊÌâ
À´×Ô:www.itpub.net
×î½üÔÚÂÛ̳ÉÏ£¬¾³£»á¿´µ½¹ØÓÚ·Ö×éºó×Ö¶ÎÆ´½ÓµÄÎÊÌ⣬
´ó¸ÅÊÇÀàËÆÏÂÁеÄÇéÐΣº
SQL> select no,q from test
2 /
NO Q
---------- ------------------------------
001 n1
001 n2
001 n3
001 n4
001 n5
002 m1
003 t1
003 t2
003 t3
003 ......
oracleÊý¾Ý¿âµÄ±¸·ÝÓë»Ö¸´
---- µ±ÎÒÃÇʹÓÃÒ»¸öÊý¾Ý¿âʱ£¬×ÜÏ£ÍûÊý¾Ý¿âµÄÄÚÈÝÊǿɿ¿µÄ¡¢ÕýÈ·µÄ£¬µ«ÓÉÓÚ¼ÆËã»úϵͳµÄ¹ÊÕÏ£¨°üÀ¨»úÆ÷¹ÊÕÏ¡¢½éÖʹÊÕÏ¡¢Îó²Ù×÷µÈ£©£¬Êý¾Ý¿âÓÐʱҲ¿ÉÄÜÔâµ½ÆÆ»µ£¬ÕâʱÈçºÎ¾¡¿ì»Ö¸´Êý¾Ý¾Í³ÉΪµ±ÎñÖ®¼±¡£Èç¹ûƽʱ¶ÔÊý¾Ý¿â×öÁ˱¸·Ý£¬ÄÇô´Ëʱ»Ö¸´Êý¾Ý¾ÍÏԵúÜÈÝÒס£Óɴ˿ɼû£¬×öºÃÊý¾Ý¿âµÄ±¸·ÝÊǶ ......
1.asp.netÁ¬½Óoracle·þÎñÆ÷ÐèÒªÌí¼ÓSytem.Data.OracleClientÃüÃû¿Õ¼ä£¬½«System.Data.OracleClient.dll¼ÓÈëµ½ÏîÄ¿ÖС£
2.Á¬½ÓʱÐèÒªConnectionString×Ö·û´®£¬³öÏÖÔÚweb.configÎļþÖУ¬ÈçÏÂËùʾ£º
<connectionStrings>
<add name="ConnectionString" connectionString="Data Source=(DESCRIPTION=( ......
OracleÖ´ÐÐÍⲿÎļþ£º
c:>sqlplus user/pwd@db
sql>@new.sql
Ö´Ðжà¸ösqlÎļþ:
1.°ÑËùÓеÄÎļþ¶¼·ÅÔÚͬһ¸öĿ¼Ï£¬È»ºóÔÚÃüÁîÐÐÀïÖ´ÐÐÃüÁ
c:>dir/b > d:\1.sql
»á°ÑËùÓеÄsqlÎļþÃû¶¼Êä³öµ½Ò»¸ösqlÎļþÖС£
2.ÓÃUltraEdit´ò¿ªÉú³ÉµÄ ......