¹â»·¾¡Ê§ OracleÔÚÖйúÈ«ÃæÔâÓö¡°»¬Ìú¬¡±
¼Ì9Ô·ݹúÄÚÄ³ÖØÒªITÃÅ»§ÍøÕ¾±¬³ö¡¶520ÍòOracle ERPÏîĿʧ°ÜÖ®ÃÕ¡·µÄ“Ìì¼Û·ç²¨”Ö®ºó£¬11Ô·ݣ¬¹úÄÚijӰÏì×î´óµÄITרҵƽýÔÙ±¬¡¶¼×¹ÇÎÄÅöײ±ùɽ£º²¢¹ºSun½øÍËÁ½ÄÑ¡·¡£Á½Æª±¨µÀ´Ó²»Í¬½Ç¶È½Ò¶ÁËOracleÔÚÖйúµÄ¼Û¸ñ“Òþ˽”¡¢ÇþµÀÂÒÏ󡢿ͻ§Á÷ʧµÈ¾½Ïà¡£×ÅʵÈÃOracleÖйú¹«Ë¾µÄ¹«¹ØÃÇæ»îÁ˺ÃÒ»Õó¡£
ÑÛ¿´×ÅÀë2009ÄêÄêÖÕÒÑûÓм¸Ì죬¹ØÓÚOracleµÄ¸÷ÖÖ·ç²¨Ò²ËÆºõ½¥½¥Æ½Ï¢£¬ÕûÈÕæÓÚËÄ´¦¾È»ðµÄOracleÖйú¹«Ë¾µÄÊг¡Ó빫¹ØÈËÔ±£¬»òÐíÕý×¼±¸°ÑÐÄ·ÅÏ¡¢ºÃºÃÐÝÏ¢¼¸Ì죬ÒÔ±¸Ã÷Äê“ÖØÕûɽºÓ”¡£¶ø¾ÍÔÚ´Ëʱ£¬12ÔÂ14ÈÕ£¬Öйú×îÓÐÓ°ÏìµÄרҵITýÌå——¡¶Öйú¼ÆËã»ú±¨¡·ÓÖÒÔһƪÑóÑóÒ»Íò¶àÑԵķâÃæ´ó¸å——¡¶¼×¹ÇÎÄÖйúÂÒÏó¡·£¬´Ó°¸Àý¡¢²úÆ·¡¢ÇþµÀ¡¢·þÎñ¡¢±¾ÍÁ»¯¡¢°²È«ÎÊÌâµÈÖî¶à·½Ãæ£¬È«Ãæ¡¢³¹µ×µØ½Ò¿ªÁ˼׹ÇÎÄÔÚÖйúµÄÉñÃØÃæÉ´£¬ÁîÆä¹â»·¾¡Ê§——Óɴ˿ɿ´³ö£¬OracleÔÚÖйúÒÑÈ«ÃæÔâÓö“»¬Ìú¬”¡£
ÕýÈç¸ÃÆÚµÄ¡¶Öйú¼ÆËã»ú±¨¡·µÄ·âÃæÕªÒªËù˵£¬Oracle ÔÚÖйú“¿Í»§ÊýÁ¿ÖÚ¶à±³ºóµÄÕæÊµÇé¿öÊÇ£¬ºÜ¶àCIOÃæ¶ÔÇ¿ÊÆ¼×¹ÇÎÄÓпàÄÑÑÔ£ºÊÛºó·þÎñ·ÑÓøߡ¢²»ÄÜÌṩÏÖ³¡·þÎñ¡¢²úÆ·²»¹»±¾µØ»¯¡¢Õë¶Ô¹úÄÚÐèÇóÎÞÈκÎÖ§³Ö……±íÃæ¹âÏʸ¡»ªµÄ¼×¹ÇÎÄ£¬ÔÚÖйúÆäʵÒÑÈ»ÂÒÏó´ÔÉú¡£”
ÎÄÕÂÒÔÏêʵµÄ°¸ÀýÓëÊý¾Ý£¬Ò»Ò»ÁоÙÁËOracleÔÚÖйúÖî¶à²»ÎªÈËÖªµÄʧ°Ü°¸Àý£¬ÓÈÆäÊÇOracleÊÓΪ×îÖØÒªÒ²×ÔÊÓ×î³É¹¦µÄ½ðÈÚÐÐÒµ£¬¼ÇÕßͨ¹ý¶à·½Î»µ÷²é£¬¾º“ÍÚ”³öÁ˰üÀ¨ÖйúÒøÐÐÔÚÄÚµÄ10¼ÒÒøÐкÍ1¼Ò֤ȯ¹«Ë¾µÄOracle ERPϵͳʵʩÓëÓ¦ÓõÄÖî¶à²»³É¹¦Ö®´¦——ËäÈ»¼ÇÕßûÓÐÖ±½Ó˵Ã÷ÕâЩ°¸ÀýÍêȫʧ°Ü£¬µ«´Ó¼ÇÕßËùÒýÊöµÄ¹úÄÚÍâ¶ÔÓÚERPʧ°ÜµÄ½ç¶¨±ê×¼À´¿´£¬ÕâЩ°¸ÀýÏÔÈ»ÊÇʧ°ÜµÄ——³¬Ô¤Ëã¡¢³¬Ê±¼ä¡¢Î´ÄÜ´ïµ½Óû§ÊµÊ©Ô¤ÆÚ£¬Î´ÄÜÓÐЧµØÊ¹ÓÃIT¼¼Êõ¼¯³ÉÈ«²¿ÒµÎñÁ÷³Ì£¬Ã»ÓÐÄõ½Óû§µÄÏîĿʵʩ³É¹¦ÑéÊÕ±¨¸æ……
¶ø³ý´ËÖ®Í⣬¼ÇÕß»¹ÒýÊöÁ˹úÄÚ×î´óµÄijIT¼¼ÊõÉçÇøÖÐÍøÓÑÁоٵİüÀ¨±±¾©¶àÔªµçÆ÷¡¢Öк£ÓÍ¡¢Èý½ÇÂÖÌ¥¡¢´óÁ¬ÊµµÂ¡¢¹þÒ©¼¯ÍÅ¡¢É³¸ÖµÈÔÚÄÚµÄÖî¶àOracleÔÚÖйúµÄÔø¾µÄʧ°Ü°¸Àý¡£
Èç´ËÖ®¶àµÄ²»³É¹¦°¸Àý£¬»òÐíÕýÈçÎÄÖÐËù˵µÄ“±ùɽһ½Ç”£¬ÓÉÓÚÎÄÕÂÖÐËù˵µÄÓû§¸÷ÖÖ²»Ô¸Òâ³ÐÈÏERPÏîĿʵʩʧ°ÜµÄÔÒò£¬Oracle Õâ¸öºÅ³Æ“È«Çò×î´óµÄÆóÒµÈí¼þ¹«Ë¾”ºÍ“ÊÀ½çµÚ¶þ´ó¹ÜÀíÈí¼þ¹©Ó¦ÉÌ”£¬ÔÚÆäÖй
Ïà¹ØÎĵµ£º
oracle±í¿Õ¼ä²Ù×÷Ïê½â
1
2
3×÷Õߣº À´Ô´£º ¸üÐÂÈÕÆÚ£º2006-01-04
5
6
7½¨Á¢±í¿Õ¼ä
8
9CREATE TABLESPACE data01
10DATAFILE '/ora ......
analyze table tablename compute statistics;
analyze index indexname compute statistics;
¶ÔÓÚʹÓÃCBOºÜÓкô¦£¬¿ÉÒÔʹÓøü¿É¿¿µÄtableÐÅÏ¢£¬´Ó¶øÖ´Ðмƻ®Ò²¿ÉÒÔ¸ü׼ȷһЩ£¬ÔÚ10g»á×Ô¶¯analyze£¬Ö®Ç°µÄ°æ±¾ÐèÒªÊÖ¶¯¶¨ÆÚ
Éú³Éͳ¼ÆÐÅÏ¢,,Ñ¡ÔñºÏÀíµÄÖ´Ðмƻ®..
OracleµÄonline documentÕâÑùÃèÊöanalyzeµÄ×÷Óãº
Use ......
OracleÌṩÁË·ÖÇø¼¼ÊõÒÔÖ§³ÖVLDB(Very Large DataBase)¡£·ÖÇø±íͨ¹ý¶Ô·ÖÇøÁеÄÅжϣ¬°Ñ·ÖÇøÁв»Í¬µÄ¼Ç¼£¬·Åµ½²»Í¬µÄ·ÖÇøÖС£·ÖÇøÍêÈ«¶ÔÓ¦ÓÃ͸Ã÷¡£
OracleµÄ·ÖÇø±í¿ÉÒÔ°üÀ¨¶à¸ö·ÖÇø£¬Ã¿¸ö·ÖÇø¶¼ÊÇÒ»¸ö¶ÀÁ¢µÄ¶Î£¨SEGMENT£©£¬¿ÉÒÔ´æ·Åµ½²»Í¬µÄ±í¿Õ¼äÖС£²éѯʱ¿ÉÒÔͨ¹ý²éѯ±íÀ´·ÃÎʸ÷¸ö·ÖÇøÖеÄÊý¾Ý£¬Ò²¿ÉÒÔͨ¹ýÔÚ²éѯ ......
ǰÑÔ
ÿһ¸öDBAÔÚ½øÐÐÊý¾Ý¿â¹ÜÀíµÄ¹ý³ÌÖв»¿É±ÜÃâµÄÒªÓöµ½ÐÎÐÎɫɫµÄ´íÎó(ORA-1547 ,ORA-904,ORA-1578 ......)¡£ÓÐЩ´íÎóÓÉÓÚÆµ·±³öÏÖ¡¢ÔÒò¸´ÔÓ¶ø±» Oracle DBA ÃÇÏ·³ÆÖ®Îª"¾µäµÄ´íÎó"¡£ÆäÖÐORA-3113 "end of file on communication channel" ¾ÍÊÇÕâÑùµÄÒ»¸ö¡£
ÎÒÃÇ¿ÉÒÔ¼òµ¥µÄ°ÑÕâ¸ö´íÎóÀí½âΪOracle¿Í»§¶Ë½ø³ÌºÍÊý¾Ý¿ ......