Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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 °ó¶¨±äÁ¿

1¡¢¶¨ÒåÒ»¸ö°ó¶¨±äÁ¿
VAR[IABLE] [variable [NUMBER|CHAR|CHAR (n)|NCHAR|NCHAR (n) |VARCHAR2 (n)|NVARCHAR2 (n)|CLOB|NCLOB|REFCURSOR]]
¶¨ÒåÒ»¸ö°ó¶¨±äÁ¿£¬¸Ã±äÁ¿¿ÉÒÔÔÚpl/sqlÖÐÒýÓá£
¿ÉÒÔÓÃprintÃüÁîÏÔʾ¸Ã°ó¶¨±äÁ¿µÄÐÅÏ¢¡£
2¡¢oracle ÖУ¬¶ÔÓÚÒ»¸öÌá½»µÄsqlÓï¾ä,´æÔÚÁ½ÖÖ¿ÉÑ¡µÄ½âÎö¹ý³Ì, Ò»ÖÖ½Ð×öÓ²½âÎö,Ò»ÖÖ½Ð×ö ......

windows7 °²×°Oracle 10g¿Í»§¶Ë

ÕâÁ½ÌìÔÚwindows7Éϰ²×°OracleÅöµ½Á˵ãÎÊÌâ,Ê×ÏÈÄÃOracle 10g32λµÄ°²×°°üÈ¥×°£¬½á¹ûÒ»Çж¼Õý³££¬PL/SQLÁ¬½Ó·þÎñÆ÷Êý¾Ý¿âÕý³££¬
µ«ÊÇÖ´ÐÐÎҵijÌÐòʱ×ÜÊDZ¨ÎÞ·¨½âÎöÁ¬½Ó±êʶ·û¡£¡£ºóÀ´ÓÐͬÊÂ˵¿ÉÄÜÊÇwindows7 ÊÇ64λµÄϵͳµÄÔ­Òò¡£½ÓמÍÏÂÔØÁË64λµÄOracle
10g °æ±¾µÄ¡£¡£µ«ÔÚ°²×°Ê±£¬Ìáʾϵͳ²Ù×÷°æ±¾¹ý¸ß£ºÖ»Ö§³Ö4.1£¬ ......

ÈçºÎ¿ª·¢ORACLE´æ´¢¹ý³Ì

¡¡¡¡Ò». ¸ÅÊö
¡¡¡¡Oracle´æ´¢¹ý³Ì¿ª·¢µÄÒªµãÊÇ£º
¡¡¡¡• ʹÓÃNotepadÎı¾±à¼­Æ÷£¬ÓÃOracle PL/SQL±à³ÌÓïÑÔдһ¸ö´æ´¢¹ý³Ì;
¡¡¡¡• ÔÚOracleÊý¾Ý¿âÖд´½¨Ò»¸ö´æ´¢¹ý³Ì;
¡¡¡¡• ÔÚOracleÊý¾Ý¿âÖÐʹÓÃSQL*Plus¹¤¾ßÔËÐд洢¹ý³Ì;
¡¡¡¡• ÔÚOracleÊý¾Ý¿âÖÐÐ޸Ĵ洢¹ý³Ì;
¡¡¡¡• ͨ¹ý±àÒë´íÎóµ÷ÊÔ´æ´¢¹ ......

ORACLE»¹Ô­¶ÎµÄÀàÐÍ

ϵͳ»¹Ô­¶Î
½öΪϵͳ±í¿Õ¼äÖеĶÔÏó±ä»¯ËùÓá£ËüÊÇÔÚÊý¾Ý¿â´´½¨Ê±ÔÚϵͳ±í¿Õ¼äÖд´½¨µÄ¡£ÏµÍ³»¹Ô­¶Î¼È¿ÉÒÔ´æÔÚ²¢¹¤×÷ÔÚ×Ô¶¯Ä£Ê½Ï£¬Ò²¿ÉÒÔ´æÔÚ²¢¹¤×÷ÔÚÊÖ¶¯Ä£Ê½Ï¡£
·Çϵͳ»¹Ô­¶Î
ΪÆäËû±í¿Õ¼äÖжÔÏóµÄ±ä»¯ËùʹÓᣵ±Ò»¸öÊý¾Ý¿â¾ßÓжà¸ö±í¿Õ¼äʱ¾ÍÐèÒªÖÁÉÙÒ»¸öÊÖ¶¯µÄ·Çϵͳ»¹Ô­¶Î»òÒ»¸ö×Ô¶¯¹ÜÀíµÄ»¹Ô­±í¿Õ¼ä¡£
×Ô¶¯Ä£Ê½ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ