Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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Öе¼ÈëdmpÊý¾Ý¿âÎļþ£¨×ª£©

ÈçºÎÔÚoracleÖе¼ÈëdmpÊý¾Ý¿âÎļþ
 OracleÊý¾Ýµ¼Èëµ¼³öimp/exp¾ÍÏ൱ÓÚoracleÊý¾Ý»¹Ô­Ó뱸·Ý¡£expÃüÁî¿ÉÒÔ°ÑÊý¾Ý´ÓÔ¶³ÌÊý¾Ý¿â·þÎñÆ÷µ¼³öµ½±¾µØµÄdmpÎļþ£¬impÃüÁî¿ÉÒÔ°ÑdmpÎļþ´Ó±¾µØµ¼Èëµ½Ô¶´¦µÄÊý¾Ý¿â·þÎñÆ÷ÖС£ ÀûÓÃÕâ¸ö¹¦ÄÜ¿ÉÒÔ¹¹½¨Á½¸öÏàͬµÄÊý¾Ý¿â£¬Ò»¸öÓÃÀ´²âÊÔ£¬Ò»¸öÓÃÀ´ÕýʽʹÓá£
 
 
Ö´Ðл·¾ ......

ORACLE Schema µÄÀí½â

¿´À´ÓеÄÈË»¹ÊǶÔschemaµÄÕæÕýº¬Ò岻̫Àí½â£¬ÏÖÔÚÎÒÔÙ´ÎÕûÀíÁËһϣ¬Ï£Íû¶Ô´ó¼ÒÓÐËù°ïÖú¡£
ÎÒÃÇÏÈÀ´¿´Ò»ÏÂËûÃǵ͍Ò壺
A schema is a collection of database objects (used by a user.).
Schema objects are the logical structures that directly refer to the database’s data.
A user is a name defined in ......

Oracle Êý¾Ý¿â°²È«»ù´¡ÖªÊ¶

Ëæ×żÆËã»úµÄÆÕ¼°ÒÔ¼°ÍøÂçµÄ·¢Õ¹£¬Êý¾Ý¿âÒѾ­²»ÔÙ½ö½öÊÇÄÇЩ³ÌÐòÔ±ËùרÓеϰÌâ¡£¶øOracleÊý¾Ý¿â¸üÊÇÆ¾½èÆäÐÔÄÜ׿Խ£¬²Ù×÷·½±ãÁé»îµÄÌØµã£¬ÔÚÊý¾Ý¿âµÄÊг¡ÖÐÒѾ­Õ¼¾ÝÁËһϯ֮µØ¡£µ«ÊÇͬÑùËæ×ÅÍøÂç¼¼ÊõµÄ²»¶Ï½ø²½£¬Êý¾ÝÐÅÏ¢µÄ²»¶ÏÔö¼Ó£¬Êý¾Ý°²È«ÒѾ­²»ÔÙÊÇÒÔǰµÄ“ÀÏÉú³¤Ì¸”£¬Ò²¸ü²»ÊÇÒÔǰÊé±¾ÉÏÄÇЩ“¿ÉÍû² ......

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

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

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

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