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±í¿Õ¼ä²Ù×÷Ïê½â
1
2
3×÷Õߣº À´Ô´£º ¸üÐÂÈÕÆÚ£º2006-01-04
5
6
7½¨Á¢±í¿Õ¼ä
8
9CREATE TABLESPACE data01
10DATAFILE '/ora ......
ǰÑÔ£º
sql_trace ÊÇÎÒÔÚ¹¤×÷Öо³£ÒªÓõ½µÄµ÷ÓŹ¤¾ß£¬Ïà±È½Ïstatspack ÎÒ¸üÔ¸ÒâÓÃÕâ¸ö¹¤¾ß¡£
ÒòΪÊý¾Ý¿âÂýÔÒòµÄ85%ÒÔÉÏÊÇÓÉÓÚsqlÎÊÌâÔì³ÉµÄ£¬statspackûÓÐsqlµÄÖ´Ðмƻ®¡£ÏÔʾûÓÐËüÖ±¹Û£¬·½±ã£¬¶ÔÏëÒªÕë¶ÔÐÔ²»Ç¿£¬
1£¬½éÉÜÊý¾Ý¿âµ÷ÓÅÐèÒª¾³£»áÓõ½µÄ¹¤¾ß ......
½ñÌìÓÐͬÊ´òµç»°ÒªÇóÒª°Ñoracle¿âÀïµÄÒ»ÕűíµÄ¶¨Òåµ¼³ö¸ösqlÎļþ£¬µ±Ê±µÄµÚÒ»·´Ó¦¾ÍÊÇÒª½ÌËûÓÃexp/impÀ´»ñµÃ±í½á¹¹¶¨ÒåÎļþ£¬Ôڵ绰ÀïÃæËµÁ˰ëÌ컹ÊÇûÄ̻ܽáËû£¬Ö»ºÃÅÜÁËÒ»ÌË»ú·¿¡£Â·ÉϾÍÔÚÏ룬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Êý¾Ý¿âĬÈϵĴ洢²ÎÊý < ±í¿Õ¼äËù¶¨ÒåµÄ´æ´¢²ÎÊý < ¶ÎËù¶¨ÒåµÄ´æ´¢²ÎÊý
´æ´¢×Ó¾ä¿ÉÒÔÔÚ¶ÎÒ»¼¶ËµÃ÷ÒÔ¿ØÖÆÇø¶Î ......