Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

¹â»·¾¡Ê§ 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Áª»úÎĵµ)

Close a Database
When you close a database, Oracle writes all database data and recovery data in the SGA to the datafiles and redo log files, respectively. Next, Oracle closes all online datafiles and redo log files. (Any offline datafiles of any offline tablespaces have been closed already. If you ......

ORACLE ±¾µØ¹ÜÀí±í¿Õ¼äÓë×Öµä¹ÜÀí±í¿Õ¼äµÄ±È½Ï


±¾µØ¹ÜÀí±í¿Õ¼äÓë×Öµä¹ÜÀí±í¿Õ¼äÏà±È´ó´óÌá¸ßÁ˹ÜÀíЧÂʺÍÊý¾Ý¿âÐÔÄÜ£¬ÆäÓŵãÈçÏ£º
1.¼õÉÙÁ˵ݹé¿Õ¼ä¹ÜÀí
±¾µØ¹ÜÀí±í¿Õ¼äÊÇ×Ô¼º¹ÜÀí·ÖÅ䣬¶ø²»ÊÇÏó×Öµä¹ÜÀí±í¿Õ¼äÐèҪϵͳÀ´¹ÜÀí¿Õ¼ä·ÖÅ䣬±¾µØ±í¿Õ¼äÊÇͨ¹ýÔÚ±í¿Õ¼äµÄÿ¸öÊý¾ÝÎļþÖÐά³ÖÒ»¸öλͼÀ´¸ú×ÙÔÚ´ËÎļþÖпéµÄÊ£Óà¿Õ¼ä¼°Ê¹ÓÃÇé¿ö¡£²¢¼°Ê±×ö¸üС£ÕâÖÖ¸üÐÂÖ»¶Ô ......

Oracle³£¼û´íÎó——ORA 00054

ÈçºÎ½â¾ö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 ......

Oracle³£¼û´íÎó——ORA 00942


¸ù¾ÝǰЩÌìΪij´ó·É»ú¹«Ë¾µ¼Èëij´ó·É»úÉú²úÊý¾ÝµÄ¾­Àú£¬×¼±¸Ð´Æª¹ØÓÚOracleµ¼³öÎļþDMP¸ñʽµÄ·ÖÎö£¬½á¹ûÔÚ±¾»úµ¼³öÒ»×éÑÝʾÊý¾Ýʱºò£¬³öÏÖÁË´íÎó£¬Ë³±ã½â¾öÏ¡£
±¾»ú×°µÄÊÇOracle 11g 32bit(11.0.6)µÄClient£¬Ö÷ÒªÊÇΪÁËʹÓÃODT.Net 11.0.6.21£¬Ö§³ÖVS2008¡£µ«ÊDzÉÓÃEXPÃüÁîµ¼³öÊý¾Ý¿âµÄʱºò£¬³öÏÖÁËЩ¹îÒìµÄ´íÎó¡£
Ö´Ð ......

OracleÖÐÀûÓÃÒ»ÌõSQLÉú³É10ÍòÌõ¼Ç¼

  ×öÊý¾Ý¿â¿ª·¢»ò¹ÜÀíµÄÈ˾­³£Òª´´½¨´óÁ¿µÄ²âÊÔÊý¾Ý£¬¶¯²»¶¯¾ÍÐèÒªÉÏÍòÌõ£¬Èç¹ûÒ»ÌõÒ»ÌõµÄ¼È룬ÄÇ»áÀË·Ñ´óÁ¿µÄʱ¼ä£¬±¾ÎĽéÉÜÁËOracleÖÐÈçºÎͨ¹ýÒ»ÌõSQL¿ìËÙÉú³É´óÁ¿µÄ²âÊÔÊý¾ÝµÄ·½·¨¡£
²úÉú²âÊÔÊý¾ÝµÄSQLÈçÏ£º
SQL> select rownum as id,
  2         &nb ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ