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

OracleµÄORA 00604´íÎó°¸Àýѧϰ

ORA-00604 error occurred at recursive SQL level string
Cause:An error occurred while processing a recursive SQL statement (a statement applying to internal dictionary tables).
Action:If the situation described in the next error on the stack can be corrected, do so; otherwise contact Oracle Customer Support.
ORA-00604: µÝ¹éij¸öSQL ²ãʱ³öÏÖ´íÎó
Ô­Òò:ÔÚÔËÐÐÒ»ÌõµÝ¹éSQLÓï¾ä(¸ÃÓï¾ä½«Ó¦ÓÃÓÚ¶ÔÄÚ²¿±í»òÊý¾Ý×ÖµäµÄ²Ù×÷)ʱ£¬·¢Éú´íÎó¡£
·½°¸:Èç¹ûÉÏÊöÃèÊöµÄ´íÎóËùÔÚÕ»¿ÉÒÔ±»ÐÞ¸´£¬ÔòÐÞ¸´²¢¼ÌÐøÔËÐÐ;·ñÔò£¬ÇëÁªÏµOracle¿Í·þ¡£µ±È»£¬ÄÇÊÇOracle¹Ù·½µÄ½â¾ö°ì·¨¡£ÎÒÔø¾­¼ÇµÃÓиö¸ßÊÖ×ܽáÁ˹ØÓÚORA-00604/ORA-04031ÎÊÌâµÄ½â¾ö£º
ÐÞ¸ÄINIT.ora
Ìí¼Ó
_db_handles_cached = 0
 
²¢ÖØÐÂÆô¶¯Êý¾Ý¿â.
·ÖÎö:ORA-00604Õâ¸öÐÅÏ¢±íÃ÷£¬ÔÚÊý¾Ý¿âÖ´ÐÐÄÚ²¿SQLÓï¾äʱ£¬·¢ÉúÁË´íÎó¡£±ÈÈ磬ҪÍù±íÖвåÈëÒ»ÐÐÊý¾Ý£¬µ«Ã»ÓпÉÀ©Õ¹µÄ¿Õ¼ä¡£ORACLEÓÚÊÇÈ¥²éѰ£¬ÄĶù¿ÉÒÔ½¨Á¢ÏÂÒ»¸öÀ©Õ¹¿Õ¼ä£¬ËüÓжà´óС£¬µ«Ã»Óгɹ¦¡£Ò»°ãÔÚ·¢ÉúORA-00604´íÎóʱ£¬»¹°éËæ×ÅÆäËüµÄ´íÎó£¬ÀýÈç:ORA-1547µÈ¡£
Ê×ÏÈ£¬Ó¦µ±¼ì²é¾¯¸æÎļþalertSID.log£¬²éÕÒÓйØORA-600ÀàµÄÐÅÏ¢¡£
¸Ã´íÎó×î³£¼ûµÄÔ­ÒòÊÇÊý¾Ý¿âÎļþinitSID.oraÖеIJÎÊýOPEN_CURSORSֵ̫С¡£¿ÉÒÔÐÞ¸ÄinitSID.oraÎļþ£¬OPEN_CURSORSµÄÖµÒ»°ãΪ255¡£ÐÞ¸ÄÍêºó£¬å´ÏÂORACLE£¬ÔÙÖØÐÂÆô¶¯¡£
»¹¿ÉÒÔÉèÖò¢Æô¶¯Êý¾Ý¿âµÄʼþ¸ú×Ù¹¦ÄÜ¡£ÔÚinitSID.oraÖмÓÉÏÒ»ÐÐ:
event = "00604 trace name errorstack"
 
å´Ï²¢ÖØÐÂÆô¶¯ORACLE£¬Ê¹Õâ¸öʼþ¸ú×Ù²ÎÊýÆð×÷Óá£ÕâÑù£¬µ±ÔÙ·¢ÉúORA-604´íÎóʱ£¬ÓйØÐÅÏ¢¾Í±£´æÔÚTRACEÎļþÖС£
Ôì³ÉORA-604´íÎóµÄÆäËüÔ­Òò¿ÉÄÜÓÐ:
- initSID.oraÖУ¬²ÎÊýDC_FREE_EXTENTS»òROW_CACHE_ENQUEUESÌ«µÍ¡£¿ÉÒÔ¸ù¾Ý²Ù×÷ϵͳºÍÊý¾Ý¿âµÄÇé¿ö£¬Êʵ±Ôö¼ÓÕâÁ½¸ö²ÎÊýµÄÖµ£¬å´Ï²¢ÖØÐÂÆô¶¯ORACLE¡£
- ÔËÐг¬³ö¿Õ¼ä(°éËæORA-1547´íÎó)¡£Õâʱ£¬Òª¶Ô±í¿Õ¼äÌí¼ÓÐÂÎļþ£¬¼´Ôö¼Ó±í¿Õ¼äµÄ´óС¡£
- ´ïµ½ÁËMAX_EXTENTS(°éËæORA-1556´íÎó)¡£Èç¹ûÕâÑù£¬¾ÍÒªÐÞ¸Ä±í£¬ÔÊÐí¸ü¶àµÄÀ©Õ¹¡£Çë´Ó¼¼ÊõÊÖ²áÖвéÕÒMAX_EXTENTSµÄ×î´óÖµ¡£Èç¹ûÒѾ­´ïµ½ÁË×î´óÖµ£¬±ØÐëÓÃcompress extentsÑ¡Ï°Ñ±íж³ö(export)£¬ÔÙµ¼Èë(import)Êý¾Ý¿âÖС£
°¸ÀýÒ»:OracleÖ´Ðеݹé²éѯµÄʱºò³ö´í
ÎÊÌâÃèÊö:ÎÒ¾­³£Óöµ½ORA-00604 ºÍORA-01000(¿ªÆôÓαêÊýÁ¿´ïµ½×î´óÖµ)´íÎó¡£È»¶ø£¬µ±ÎÒ¼ì²é´úÂëµÄʱºò£¬ËùÓеĽá¹û¼¯ºÍÓï¾ä¶ÔÏó¶¼ÔÚ×îºó


Ïà¹ØÎĵµ£º

oracle ±í¿Õ¼ä²Ù×÷

oracle±í¿Õ¼ä²Ù×÷Ïê½â
  1
  2
  3×÷Õߣº   À´Ô´£º    ¸üÐÂÈÕÆÚ£º2006-01-04 
  5
  6 
  7½¨Á¢±í¿Õ¼ä
  8
  9CREATE TABLESPACE data01
 10DATAFILE '/ora ......

ʹÓÃOracle sql_trace ¹¤¾ß

ǰÑÔ£º
    sql_trace ÊÇÎÒÔÚ¹¤×÷Öо­³£ÒªÓõ½µÄµ÷ÓŹ¤¾ß£¬Ïà±È½Ïstatspack ÎÒ¸üÔ¸ÒâÓÃÕâ¸ö¹¤¾ß¡£
    ÒòΪÊý¾Ý¿âÂýÔ­ÒòµÄ85%ÒÔÉÏÊÇÓÉÓÚsqlÎÊÌâÔì³ÉµÄ£¬statspackûÓÐsqlµÄÖ´Ðмƻ®¡£ÏÔʾûÓÐËüÖ±¹Û£¬·½±ã£¬¶ÔÏëÒªÕë¶ÔÐÔ²»Ç¿£¬
    1£¬½éÉÜÊý¾Ý¿âµ÷ÓÅÐèÒª¾­³£»áÓõ½µÄ¹¤¾ß ......

oracleÊý¾Ý¿â±í½á¹¹µ¼³ö

½ñÌìÓÐͬÊ´òµç»°ÒªÇóÒª°Ñoracle¿âÀïµÄÒ»ÕűíµÄ¶¨Òåµ¼³ö¸ösqlÎļþ£¬µ±Ê±µÄµÚÒ»·´Ó¦¾ÍÊÇÒª½ÌËûÓÃexp/impÀ´»ñµÃ±í½á¹¹¶¨ÒåÎļþ£¬Ôڵ绰ÀïÃæËµÁ˰ëÌ컹ÊÇûÄ̻ܽáËû£¬Ö»ºÃÅÜÁËÒ»ÌË»ú·¿¡£Â·ÉϾÍÔÚÏ룬oracleÕæÊÇÌÖÑᣬΪʲô²»ÔÚÆóÒµ¹ÜÀíÆ÷ÀïÖ±½Ó¼ÓÉϸö±í½á¹¹µ¼³öµÄÑ¡Ï»¹Òªº¦ÎÒÕâôÅÜÒ»ÌË£¬ÕæÊÇ@@#!!@!#@@@@
ÎÊÁËÏÂÒªµ¼³öÄÄ ......

ÔÚoracleÖиıä×Ö¶ÎÔÚ±íÖеÄ˳Ðò

1.ÒÔsysÓû§µÇ¼oracle
2.²éÕÒÄãÒª¸ü¸ÄµÄ±í£¬ÎÒÃÇ“TEST”ÖеēAAA”±íΪÁУ¬×¢Ò⣬ÔÚoracleÖУ¬±íºÍ¿Õ¼ä¶¼ÊÇÒÔ´óд×ÖĸÏÔʾµÄ£¬ËùÒÔÕâÀï¶¼ÒªÓôó×Ö×Öĸ
Ö´ÐÐ
select object_id from all_objects where owner='TEST' and object_name='AAA';
»áµÃµ½Ò»¸öobject_id,Õâ¾ÍÊÇÎÒÃÇÐèÒª¸ü¸Ä±íµÄid£¬ÎÒÃÇÒ ......

ORACLE´æ´¢×Ó¾äµÄÓÅÏȼ¶

½ñÌìÔÚÊéÉÏ¿´µ½ÓÐÒ»¸öС½Ú½²´æ´¢×Ó¾äÓÅÏȼ¶µÄ£¬ËµÊµ»°£¬Æ½Ê±ÔÚ´´½¨¶ÔÏóµÄʱºò¼¸ºõ²»Ôõôָ¶¨´æ´¢×Ó¾äµÄ£¬Ò»°ã²ÉÓÃĬÈÏ¡£ºÇºÇ£¬¿ÉÄÜÊÇÒòΪ±È½ÏÀÁ°É£¬½ñÌì¼ÈÈ»¿´µ½ÁË£¬¾Í¼ÇÏÂÀ´£¬ÏàÐÅÒÔºó»áÓõõ½µÄ¡£
ORACLEÊý¾Ý¿âĬÈϵĴ洢²ÎÊý < ±í¿Õ¼äËù¶¨ÒåµÄ´æ´¢²ÎÊý < ¶ÎËù¶¨ÒåµÄ´æ´¢²ÎÊý
´æ´¢×Ó¾ä¿ÉÒÔÔÚ¶ÎÒ»¼¶ËµÃ÷ÒÔ¿ØÖÆÇø¶Î ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ