¹â»·¾¡Ê§ 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 DBAÒ²°ë¸ö¶àѧÆÚÁË£¬½ñÌìÃÍÈ»²Å·¢ÏÖ£¬ÔÀ´ÎÒµÄÊ黹ÊǺÜеģ¬ÉϿβÙ×÷ʱºòÒ²Ö»ÊÇÖªµÀ´ó¸ÅÔõô×ö£¬µ«ÊÇÒªÕæµÄÈ«²¿×Ô¼º×ö£¬¶ø²»È¥·Ê黹ÊÇÓÐÒ»¶¨µÄÄѶȵģ¬ËùÒÔÄØ£¬½ñÌ쿪ʼ½«DBA´ÓÍ·¸´Ï°Ò»±é£¬Í¬Ê±ÔÙ²Ù×÷Ò»±é¡£
µÚÒ»Õ£¬Ñ§µÄÊÇOracleµÄÌåϵ½á¹¹£ ......
ÈçºÎ½â¾öORA-00054×ÊÔ´Õý棬ҪÇóÖ¸¶¨NOWAIT£¿
²éÔÄ´íÎó´úÂëÖ¸ÄϺóÓÐÈçÏÂÌáʾ£º
ORA-00054 resource busy and acquire with NOWAIT specified
Cause: The NOWAIT keyword forced a return to the command prompt because a resource was unavailable for a LOCK TABLE or SELECT FOR UPDATE command.
Action: Tr ......
ǰÑÔ
ÿһ¸öDBAÔÚ½øÐÐÊý¾Ý¿â¹ÜÀíµÄ¹ý³ÌÖв»¿É±ÜÃâµÄÒªÓöµ½ÐÎÐÎɫɫµÄ´íÎó(ORA-1547 ,ORA-904,ORA-1578 ......)¡£ÓÐЩ´íÎóÓÉÓÚÆµ·±³öÏÖ¡¢ÔÒò¸´ÔÓ¶ø±» Oracle DBA ÃÇÏ·³ÆÖ®Îª"¾µäµÄ´íÎó"¡£ÆäÖÐORA-3113 "end of file on communication channel" ¾ÍÊÇÕâÑùµÄÒ»¸ö¡£
ÎÒÃÇ¿ÉÒÔ¼òµ¥µÄ°ÑÕâ¸ö´íÎóÀí½âΪOracle¿Í»§¶Ë½ø³ÌºÍÊý¾Ý¿ ......
oracleÊý¾Ý¿âÖÐsql»ù´¡
×÷ÕߣºØýÃû תÌù×Ô£º±¾Õ¾Ô´´ ä¯ÀÀ´ÎÊý£º21 ÎÄÕ¼È룺admin
Ò»¡¢¹ØÏµÊý¾Ý¿âµÄһЩ¸ÅÄî
¡¡¡¡
¡¡¡¡1¡¢Ö÷¼üµÄÖµÒ»°ã²»¿ÉÒԸıä
¡¡¡¡
¡¡¡¡2¡¢Íâ¼ü£ºÖ¸ÏòÁíÒ»¸ö±í»ò±¾±íµÄÖ÷¼ü»òΨһ¼üµÄ×ֶΡ£Íâ¼üµÄÖµÒ»¶¨ÒªºÍijһÖ÷¼üÏàͬ ......
×öÊý¾Ý¿â¿ª·¢»ò¹ÜÀíµÄÈ˾³£Òª´´½¨´óÁ¿µÄ²âÊÔÊý¾Ý£¬¶¯²»¶¯¾ÍÐèÒªÉÏÍòÌõ£¬Èç¹ûÒ»ÌõÒ»ÌõµÄ¼È룬ÄÇ»áÀË·Ñ´óÁ¿µÄʱ¼ä£¬±¾ÎĽéÉÜÁËOracleÖÐÈçºÎͨ¹ýÒ»ÌõSQL¿ìËÙÉú³É´óÁ¿µÄ²âÊÔÊý¾ÝµÄ·½·¨¡£
²úÉú²âÊÔÊý¾ÝµÄSQLÈçÏ£º
SQL> select rownum as id,
2 &nb ......