Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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¸´Ï°£¨Ò»£© Ö®OracleÌåϵ½á¹¹

      ѧϰOracle DBAÒ²°ë¸ö¶àѧÆÚÁË£¬½ñÌìÃÍÈ»²Å·¢ÏÖ£¬Ô­À´ÎÒµÄÊ黹ÊǺÜеģ¬ÉϿβÙ×÷ʱºòÒ²Ö»ÊÇÖªµÀ´ó¸ÅÔõô×ö£¬µ«ÊÇÒªÕæµÄÈ«²¿×Ô¼º×ö£¬¶ø²»È¥·­Ê黹ÊÇÓÐÒ»¶¨µÄÄѶȵģ¬ËùÒÔÄØ£¬½ñÌ쿪ʼ½«DBA´ÓÍ·¸´Ï°Ò»±é£¬Í¬Ê±ÔÙ²Ù×÷Ò»±é¡£
      µÚÒ»Õ£¬Ñ§µÄÊÇ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£¬ÎÒÃÇÒ ......

Java+OracleÓ¦Óÿª·¢µÄ¼¸¸öÎÊÌâ


ÎÊÌâÒ»£ºÈç±£¼ÓÔØJDBCÇý¶¯³ÌÐò£º
¡¡¡¡Õý³£ÎÒÃǼÓÔØÇý¶¯³ÌÐòÓÐÈý¸ö;¾¶£º
¡¡¡¡1£©Class.forName(String)ÕâÏëµ±ÓÚclassLoaderÒ»¸öStringÖ¸¶¨µÄÀ࣬ÔÚ×°ÔØʱ°Ñ¸ÃÇý¶¯³ÌÐòµÄ¾²Ì¬ÄÚÈݶ¼³õʼ»¯£¬ÆäʵÕâʱÇý¶¯³ÌÐòÀàµ÷ÓÃÁËDriverManager.registerDriver(driver)·½·¨
¡¡¡¡2£©Ê¹ÓÃϵͳÊôÐÔ£ºSystem.getProperty().load(new Fil ......

Oracle ÐÞ¸ÄÊý¾ÝÎļþµÄ·¾¶ºÍÃû³Æ

Microsoft Windows XP [°æ±¾ 5.1.2600]
(C) °æȨËùÓÐ 1985-2001 Microsoft Corp.
C:\Documents and Settings\Admin>sqlplus "/ as sysdba"
SQL*Plus: Release 10.2.0.1.0 - Production on Fri Nov 20 19:31:44 2009
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:
Oracle Database 10g E ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ