Oracle 10.2.0.3 Patch°²×°Ö®BUGÏê½â
ORA-00704: bootstrap process failure
ORA-1092 signalled during: alter database open...
½øÐÐÈçϲÙ×÷ºóOK.
SQL>startup upgrade
For Windows
SQL>@d:\oracle\product\10.2.0\db_1/rdbms/admin/catupgrd.sql
For Linux
SQL>@/u01/app/oracle/product/10.2.0/db_1/rdbms/admin/catupgrd.sql
´ýcatupgrd.sql½Å±¾Ö´ÐÐÍê³É£¬shutdown immediate¹Ø±ÕÊý¾Ý¿â£»
startupÆô¶¯Êý¾Ý¿â£¬Ö´Ðнű¾
For Windows
SQL>@D:\oracle\product\10.2.0\db_1\RDBMS\ADMIN\utlrp.sql£»
For Linux
SQL>@/u01/app/oracle/product/10.2.0/db_1/RDBMS/ADMIN/utlrp.sql£»
Ö´ÐÐÍê±ÏºóÖ´ÐвéѯËùÓÐÖØÐ±àÒë´íÎó
SQL> select * from utl_recomp_errors;
δѡ¶¨ÐУ¨ÕâÀï˵Ã÷ûÓдíÎó£©
Ö´Ðмì²é£º
SQL> select name from v$databaseÈ·ÈÏORACLE_SIDÕýÈ·£¬ÎªRAC01
SQL> show userÈ·Èϵ±Ç°Ê¹ÓÃÕßΪSYS
SQL> select tablespace_name, bytes from dba_data_files¶Ôϵͳ±í¿Õ¼ä´óС½øÐÐÈ·ÈÏ¡£
For Windows
SQL>@d:\oracle\product\10.2.0\db_1/rdbms/admin/catupgrd.sql
For Linux
SQL>@/u01/app/oracle/product/10.2.0/db_1/rdbms/admin/catupgrd.sql
SQL>shutdown immediate
SQL>startup
Êý¾Ý¿âÆô¶¯³É¹¦
ǰÎijö´¦£ºhttp://blog.csdn.net/langcai1981/archive/2010/01/07/5148002.aspx
Ïà¹ØÎĵµ£º
¡¾IT168 ¼¼ÊõÎĵµ¡¿Ëæ×ÅÍøÂçÓ¦Óú͵ç×ÓÉÌÎñµÄ²»¶Ï·¢Õ¹£¬¸÷¸öÕ¾µãµÄ·ÃÎÊÁ¿Ô½À´Ô½´ó£¬ÈçºÎʹÓÐÏ޵ļÆËã»úϵͳ×ÊԴΪ¸ü¶àµÄÓû§·þÎñ£¿ÈçºÎ±£Ö¤Óû§µÄÏìÓ¦ËٶȺͷþÎñÖÊÁ¿£¿ÕâЩÎÊÌâ¶¼ÊôÓÚ·þÎñÆ÷ÐÔÄÜÓÅ»¯µÄ·¶³ë¡£×÷Ϊ½Ï³É¹¦µÄÊý¾Ý¿â³§ÉÌ£¬Oracle¹«Ë¾Êý¾Ý¿âµÄÐÔÄÜÓÅ»¯ÊÇÈçºÎ½øÐеÄ
¡¡¡¡ ÓÅ»¯²ßÂÔ
¡¡¡¡ ΪÁ˱£Ö¤OracleÊý ......
1.ÔÚAÓû§ÏÂÊÚȨ“ÉÌ»§ÐÅÏ¢±í”¸øBÓû§
grant all on TBL_INF_MCHNT_INF to B;
commit;
2.ÔÚBÓû§Ï½¨Á¢Í¬Òå´Ê
create synonym TBL_INF_MCHNT_INF for A.TBL_INF_MCHNT_INF;
3. ²éѯÊý¾Ý¿âËùÓÐͬÒå´Êselect * from sys.synonyms ......
¡¡¡¾IT168 ¼¼ÊõÎĵµ¡¿ÈκÎÊÂÇé¶¼ÓÐËüµÄÔ´Í·£¬Òª½â¾öÎÊÌ⣬ҲµÃ´ÓÔ´Í·¿ªÊ¼£¬Ó°ÏìORACLEÐÔÄܵÄÔ´Í··Ç³£¶à£¬Ö÷Òª°üÀ¨ÈçÏ·½Ã棺Êý¾Ý¿âµÄÓ²¼þÅäÖÃ:CPU¡¢ÄÚ´æ¡¢ÍøÂçÌõ¼þ¡£
¡¡¡¡1. CPU:ÔÚÈκλúÆ÷ÖÐCPUµÄÊý¾Ý´¦ÀíÄÜÁ¦ÍùÍùÊǺâÁ¿¼ÆËã»úÐÔÄܵÄÒ»¸ö±êÖ¾£¬²¢ÇÒORACLEÊÇÒ»¸öÌṩ²¢ÐÐÄÜÁ¦µÄÊý¾Ý¿âϵͳ£¬ÔÚCPU·½ÃæµÄÒªÇó¾Í¸ü¸ßÁË£¬Èç¹ûÔ ......
½éÉÜÍêOracleÈ«ÎÄË÷ÒýµÄFILTERÊôÐÔ£¬¼ÌÐø½éÉÜOracleµÄLEXERÊôÐÔ¡£
OracleÈ«ÎÄË÷ÒýµÄLEXERÊôÐÔÓÃÓÚ´¦Àí¸÷ÖÖ²»Í¬µÄÓïÑÔ¡£×î»ù±¾µÄÓ¢ÎÄʹÓÃBASE_FILTER£¬¶øÈç¹ûÐèҪʹÓÃÖÐÎÄÔò¿ÉÒÔʹÓÃCHINESE_VGRAM_LEXER»òCHINESE_LEXER¡£
ÕâÆªÎÄÕ¼òµ¥ËµÃ÷BASIC_LEXERÊôÐÔ¡£BASIC_LEXERÊôÐÔÖ§³Ö¶àÖÖÓïÑÔ£¬±ÈÈçÓ¢Óï¡¢µÂÓï¡¢ºÉÀ¼ÓŲ ......