oracle10g͸Ã÷Íø¹Øfor SqlServer ·Ö²¼Ê½ÊÂÎñ
һ̨SqlServer·þÎñÆ÷ winxp
һ̨oracle·þÎñÆ÷ windows 2003
ÏëÔÚoracle·þÎñÆ÷ÀûÓÃ͸Ã÷Íø¹ØÁ¬½Óµ½SqlServer¡£
ÅäÖÃ͸Ã÷Íø¹ØµÄ²ÎÊýÎļþinitXXXXX.oraµÄʱºò£¬
1¡¢ÉèÖà HS_FDS_TRANSACTION_MODEL = TWO_PHASE_COMMIT
SQL>select * from tt@msql;
Ö´ÐÐselectÓï¾äʱ±¨´í£ºora-28500 ora-02063
£¨Èç¹ûoracleºÍSqlServerͬÔÚһ̨»úÆ÷ÉÏ£¬Ò»ÇÐÕý³££¡£¡£¡£©
2¡¢½«HS_FDS_TRANSACTION_MODEL = TWO_PHASE_COMMITÕâ¾ä×¢Ê͵ô
Ò»ÇÐÕý³££¡£¡£¡
¿´Á˺ܶàÎĵµ£¬»¹ÊÇûÄܽâ¾öÕâ¸öÎÊÌâ¡£Íû¸÷λ´óÏÀ°ï棡£¡
ÎÊÌâ½â¾öÁË£¬¹ûÈ»ÊÇÊÂÎñ¹ÜÀíÆ÷·½ÃæµÄÎÊÌâ¡£
ÔÀ´ÎÒµÄwindows 2003ÉÏûÓдòSP2µÄ²¹¶¡£¬
´òÉϲ¹¶¡£¬ÅäÖÃÒ»ÏÂMSDTC¾Í¿ÉÒÔÁË¡£
´ò²¹¶¡Ö®Ç°ÎÞÂÛÔõôÅäÖÃMSDTCÒ²²»ÐС£
лл inthirties¡¢crazylaa
Ïà¹ØÎÊ´ð£º
°²×°ÁËOracle 10g£¬Ä¬ÈÏ°²×°ÁËorclÊý¾Ý¿â£¬Õâ¸öÊý¾Ý¿âÄܲ»ÄÜɾ³ý°¡£¬»¹ÓÐÎÒÈç¹ûн¨ÁËÆäËûÊý¾Ý¿â£¬Ôõô֪µÀÔÚwebÖеǽ²»Í¬Êý¾Ý¿âµÄµØÖ·°¡£¿
1
¿ÉÒÔɾ³ý
2
ÔÚWEBµØÖ·À¸ÖÐÊäÈëµØÖ·µÄʱºòÖ¸¶¨Ð´´½¨µÄÊý¾Ý¿âµÄIP ......
ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£
ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£
ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£
ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......
ÓÃPL/SQL µÇ½ʱµ¯³ö±¨´í´°¿Ú£¬´íÎóÈçÏ£¡
ORA-01034:ORACLE not available
ORA-27101:shared memory realm does not exist
ÇëÎÊ£¬ÓÐûÓÐÈËÓöµ½ÕâÖÖÇé¿ö£¬Ôõô½â¾ö£¿Ð»Ð»£¡
1. Oracle sid ÕýÈ ......
sqlserver2005 ½¨Á¢µÄÊý¾Ý¿â£¬ÓëÊÖ³Öpda´«ÊäÊý¾Ý£¬×î½üͻȻ³öÏÖÎÞ·¨´«µÝÊý¾ÝµÄÎÊÌ⣬pda¶ËÌáʾµÄ´íÎóʱoutofmemoryexception£¬µ«ÊÇpdaÉÏÃæµÄÈÝÁ¿Ã»ÓÐÎÊÌ⣬
sqlserverµÄÈÕ×ÓÉϵĴíÎóÈçÏ£º
ÈÕÆÚ 2010-1-25 14:45: ......