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 Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
SQL> select file_name from dba_data_files;
FILE_NAME
--------------------------------------------------------------------------------
D:\ORACLE\ORADATA\ORCL\USERS01.DBF
D:\ORACLE\ORADATA\ORCL\SYSAUX01.DBF
D:\ORACLE\ORADATA\ORCL\UNDOTBS01.DBF
D:\ORACLE\ORADATA\ORCL\SYSTEM01.DBF
D:\ORACLE\ORADATA\ORCL\EXAMPLE01.DBF
SQL> create tablespace test;
//ÓÉÓÚÎÒʹÓÃÁËOMF¹¦ÄÜ ËùÒÔ´Ë´¦ORACLE»á×Ô¶¯Ö¸¶¨Êý¾ÝÎļþÃû¡¢´óСÓë·¾¶
Tablespace created.
SQL> select file_name from dba_data_files;
FILE_NAME
--------------------------------------------------------------------------------
......
½ñÌìÔÚÊéÉÏ¿´µ½ÓÐÒ»¸öС½Ú½²´æ´¢×Ó¾äÓÅÏȼ¶µÄ£¬ËµÊµ»°£¬Æ½Ê±ÔÚ´´½¨¶ÔÏóµÄʱºò¼¸ºõ²»Ôõôָ¶¨´æ´¢×Ó¾äµÄ£¬Ò»°ã²ÉÓÃĬÈÏ¡£ºÇºÇ£¬¿ÉÄÜÊÇÒòΪ±È½ÏÀÁ°É£¬½ñÌì¼ÈÈ»¿´µ½ÁË£¬¾Í¼ÇÏÂÀ´£¬ÏàÐÅÒÔºó»áÓõõ½µÄ¡£
ORACLEÊý¾Ý¿âĬÈϵĴ洢²ÎÊý < ±í¿Õ¼äËù¶¨ÒåµÄ´æ´¢²ÎÊý < ¶ÎËù¶¨ÒåµÄ´æ´¢²ÎÊý
´æ´¢×Ó¾ä¿ÉÒÔÔÚ¶ÎÒ»¼¶ËµÃ÷ÒÔ¿ØÖÆÇø¶Î(EXTENT)ÔÚ¶ÎÖÐÊÇÈçºÎ·ÖÅäµÄ¡£Æä·ÖÅäÔÔòÈçÏ£º
ÈκÎÔÚ¶ÎÒ»¼¶ËµÃ÷µÄ´æ´¢²ÎÊý½«¸²¸ÇÔÚ±í¿Õ¼äÒ»¼¶Ëù¶ÔÓ¦µÄÑ¡ÏîÉèÖ㬵«ÊDZí¿Õ¼äÒ»¼¶µÄ²ÎÊýMINIMUM EXTENT»òUNIFORM SIZE³ýÍâ¡£
µ±´æ´¢²ÎÊýÔÚ¶ÎÒ»¼¶Ã»ÓÐÏÔʾµÄ¶¨Òåʱ£¬ËüÃÇĬÈÏΪ±í¿Õ¼äÒ»¼¶Ëù¶¨ÒåµÄ²ÎÊýÖµ¡£
µ±´æ´¢²ÎÊýÔÚ±í¿Õ¼äÒ»¼¶Ã»ÓÐÏÔʾµÄ¶¨Òåʱ£¬ORACLEÊý¾Ý¿âϵͳµÄĬÈϲÎÊýÖµ½«±»Ê¹Óá£
Èç¹ûÔÚ±í¿Õ¼äÒ»¼¶ÒѾ¶¨ÒåÁËMINIMUM EXTENTµÄ´óС£¬Ëü½«Ó¦ÓÃÓڸñí¿Õ¼äÖн«À´ËùÓжεÄÇø¶Î(EXTENT)µÄ·ÖÅä¡£
ijЩ´æ´¢²ÎÊý²»ÄÜÔÚ±í¿Õ¼äÒ»¼¶¶¨Ò壬ÕâЩ´æ´¢²ÎÊýÖ»ÄÜÔÚ¶ÎÒ»¼¶ËµÃ÷¡£
Èç¹û¶Ô´æ´¢²ÎÊý½øÐÐÁËÐ޸ģ¬ÐµĴ洢²ÎÊýÖ»ÊÊÓÃÓÚ»¹Ã»ÓзÖÅäµÄÇø¶Î(EXTENT)¡£
......
ϵͳ»¹Ô¶Î
½öΪϵͳ±í¿Õ¼äÖеĶÔÏó±ä»¯ËùÓá£ËüÊÇÔÚÊý¾Ý¿â´´½¨Ê±ÔÚϵͳ±í¿Õ¼äÖд´½¨µÄ¡£ÏµÍ³»¹Ô¶Î¼È¿ÉÒÔ´æÔÚ²¢¹¤×÷ÔÚ×Ô¶¯Ä£Ê½Ï£¬Ò²¿ÉÒÔ´æÔÚ²¢¹¤×÷ÔÚÊÖ¶¯Ä£Ê½Ï¡£
·Çϵͳ»¹Ô¶Î
ΪÆäËû±í¿Õ¼äÖжÔÏóµÄ±ä»¯ËùʹÓᣵ±Ò»¸öÊý¾Ý¿â¾ßÓжà¸ö±í¿Õ¼äʱ¾ÍÐèÒªÖÁÉÙÒ»¸öÊÖ¶¯µÄ·Çϵͳ»¹Ô¶Î»òÒ»¸ö×Ô¶¯¹ÜÀíµÄ»¹Ô±í¿Õ¼ä¡£
×Ô¶¯Ä£Ê½£ºÐèÒªÒ»¸ö»¹Ô±í¿Õ¼ä£¬ORACLE·þÎñÆ÷½«×Ô¶¯Î¬»¤»¹Ô±í¿Õ¼äÖеϹÔÊý¾Ý¡£
ÊÖ¶¯Ä£Ê½£ºÊý¾Ý¿â¹ÜÀíÔ±¸ºÔð´´½¨·Çϵͳ»¹Ô¶Î£¬ËùÓзÇϵͳ±í¿Õ¼äÖеĶÔÏóµÄ±ä»¯¶¼½«Ê¹ÓÃÕâÑùµÄ·Çϵͳ»¹Ô¶Î¡£ÔÚORACLEϵͳÖаüÀ¨ÁËÈçÏÂÁ½Àà·Çϵͳ»¹Ô¶Î£º
˽Óл¹Ô¶Î£ºÎªÒ»¸öʵÀýËùÓá£
¹«Óл¹Ô¶Î£ºÎªÈκÎÒ»¸öʵÀýËùÓá£ËüÃÇͨ³£ÊÇÔÚORACLE RACÖÐʹÓá£
ÑÓ³Ù»¹Ô¶Î
µ±Ò»¸ö±í¿Õ¼ä±»ÉèÖÃΪÍÑ»úʱ£¬Èç¹ûÐèÒª£¬ÓÉORACLEϵͳ×Ô¶¯´´½¨¡£ÑÓ³Ù»¹Ô¶Î±»ÓÃÀ´Ôڸñí¿Õ¼äÖØÐÂÉèΪÁª»úʱ»Ø¹öÊÂÎñ¡£µ±²»ÐèÒªËüÃÇʱ£¬ÏµÍ³»á×Ô¶¯½«ËüÃÇɾ³ý¡£ ......
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ÀàµÄÐÅÏ¢¡£
¸Ã´íÎó×î³ ......
ÔںܶàÆóÒµ¼¶°²×°Êý¾Ý¿âʱ£¬³£³£Óдó¹æÄ£µÄ°²×°ÈÎÎñ£¬ÕâʱʹÓÃÏìÓ¦ÎļþÀ´ÅúÁ¿°²×°¿ÉÒÔÌá¸ß¹¤×÷ЧÂÊ£¬ÏÂÃæ½éÉÜÊý¾Ý¿âÈí¼þµÄ¾²Ä¬°²×°·½Ê½¡£
Ò»¡¢Êý¾Ý¿â·þÎñÆ÷¶Ë°²×°
1. Éú³É°²×°ÏìÓ¦Îļþ
$./runInstaller -record -destinationFile /tmp/install_database_10g.rsp
Õâʱ»áÆô¶¯Í¼ÐνçÃæÀ´Â¼ÖÆÎÒÃÇÐèÒªµÄÏìÓ¦Îļþ¡£
×¢Ò⣺
µ±°²×°½çÃæµ½´ï×îºóÒ»²½Ê±Ñ¡Ôñcancel
µÃµ½Õâ¸öÏìÓ¦ÎļþÎÒÃǾͿÉÒÔ¾²Ä¬°²×°oracleÁË
install_database.rspÎļþÊÇÓɺܶà²ÎÊý×é³ÉµÄ£¬²¢ÇÒÓÐÏêϸµÄ˵Ã÷£º
Ò»°ãÎÒÃÇÐèҪעÒâµÄ²ÎÊýÓУº
2 .ÐÞ¸ÄÏìÓ¦ÎļþµÄÏà¹Ø²ÎÊý
UNIX_GROUP_NAME="oinstall" ----°²×°Óû§×é
from_LOCATION="/software/db/10g/Disk1/stage/products.xml" –-°²×°Ô´ÎļþµØÖ·
ORACLE_HOME="/u01/oracle/product/db10gr2" ---ORACLE_HOME
ORACLE_HOME_NAME="db10gr2" ---- ORACLE_HOME_NAME
SELECTED_LANGUAGES={"en","zh_CN","zh_TW"} ----ÓïÑÔ
COMPONENT_LANGUAGES={"en","zh_CN","zh_TW"} ----ÓïÑÔ
INSTALL_TYPE="Enterprise Edition" --ÆóÒµ°æ
3.¾²Ä¬°²×°Êý¾Ý¿âÈí¼þ
$./runInstaller -silent -responseFile /tmp/install_database_10g.rsp
4. ¾²Ä¬Éý¼¶
½âѹorac ......
¡¶¸£²¼Ë¹¡·ÍøÕ¾½üÈÕ·¢±íÎÄÕ³ƣ¬Èç¹û¼×¹ÇÎÄ74ÒÚÃÀÔªÊÕ¹ºSunµÄ¼Æ»®ÓÉÓÚÅ·Ã˵Ä×èÄÓ¶øÒÔʧ°Ü¸æÖÕ£¬Õâ²¢²»»á¸ø¼×¹ÇÎÄ´øÀ´Ì«´óËðʧ£¬µ«È´»áÁîSunÔâÊÜÖØ´´¡£
¼×¹ÇÎÄÊÕ¹ºSunµÄ½»Ò×ÈÔδ»ñµÃÅ·ÃËίԱ»áµÄÅú×¼¡£
Å·ÃË·´Â¢¶Ï¼à¹Ü²¿Ãŵ£ÐÄ£¬¼×¹ÇÎÄÊÕ¹ºSun½«¶ÔSunµÄ¿ªÔ´Êý¾Ý¿âÒµÎñMySQLÔì³É²»ÀûÓ°Ïì¡£¼×¹ÇÎÄÃæ¶ÔÅ·Ã˵ÄÒÉÂDz¢²»Ô¸×ö³öÈò½£¬¿ÉÄܻᵼÖÂÅ·ÃË·´¶ÔÕâÒ»½»Òס£
½ØÖÁĿǰ£¬¼×¹ÇÎÄÓëSunµÄ·¢ÑÔÈ˶¼¶Ô´ËδÖÿɷñ¡£´ËÇ°ÔøÓб¨µÀ³Æ£¬IBMÒÔ9.10ÃÀԪÿ¹ÉÊÕ¹ºSunµÄ½»Ò×Òѵ½ÁË×îºó½×¶Î£¬µ«ÓÉÓÚµ£ÐĽ»Ò×Òý·¢·´Â¢¶Ï¼à¹Ü²¿Ãŵĵ÷²é£¬ÒÔ¼°SunÏ£ÍûÒÔ¸ü¸ßµÄ¼Û¸ñ³öÊÛ¹«Ë¾£¬µ¼ÖÂIBM×îÖÕÀ뿪ÁËÕâÒ»½»Òס£µ«ÊÇÈç¹û×îÖÕ¼×¹ÇÎÄÊÕ¹ºSunʧ°ÜµÄ»°£¬Ãæ¶ÔÕâÑùÒ»¸ö¾ÖÃæIBM»á²»»áÖØÐÂÅ׳öéÏéÖ¦?Èç¹û´ËʱIBM½éÈëµÄ»°£¬²»½öÊÕ¹º³É±¾½øÒ»²½½µµÍ£¬¶øÇÒ»¹¶Ô¼×¹ÇÎÄÔì³É¸üÓÐÍþÉåÁ¦µÄ³å»÷¡£ÄÇÑùµÄ»°IT½çÓÖÊÇÒ»·¬·çÔÆ±ä»ÃÁË¡£
¼×¹ÇÎÄÊÕ¹ºSunµÄ½»Ò×ÈÔδ»ñµÃÅ·ÃËίԱ»áµÄÅú×¼¡£
Å·ÃË·´Â¢¶Ï¼à¹Ü²¿Ãŵ£ÐÄ£¬¼×¹ÇÎÄÊÕ¹ºSun½«¶ÔSunµÄ¿ªÔ´Êý¾Ý¿âÒµÎñMySQLÔì³É²»ÀûÓ°Ïì¡£¼×¹ÇÎÄÃæ¶ÔÅ·Ã˵ÄÒÉÂDz¢²»Ô¸×ö³öÈò½£¬¿ÉÄܻᵼÖÂÅ·ÃË·´¶ÔÕâÒ»½»Òס£
½ØÖÁĿǰ£¬¼×¹ÇÎÄÓëSunµÄ·¢ÑÔÈ˶¼¶Ô´ËδÖÿɷñ¡£´ËÇ°ÔøÓб¨µÀ³Æ£¬IBMÒÔ9.10ÃÀԪÿ¹ ......