ÇóÖúOracle XeÏà¹ØÎÊÌâ - MS-SQL Server / ·Ç¼¼Êõ°æ
ÎÒµÄOracle XeÕâ¸öÈí¼þ²»ÄÜÓÃÁË£¬È»ºóÐ¶ÔØÁË£¬ÎÒÖØÐ°²×°£¬¿ÉÊǵçÄÔÌáʾϵͳÉÏÓÐÁË´Ë·þÎñ£¬ÕâÊÇÔõô»ØÊ°¡£¿
Ð¶ÔØ²»ÍêÈ«£¿
²»Ã÷ ÓÑÇéUP
Ð¶ÔØ²»ÍêÈ«,ÐèÒªµ½×¢²á±íÖÐȥɾ³ýÈçϵÄÄÚÈÝ.
1.
hkey_local_machine\softwareÏÂ,oracleĿ¼.
hkey_local_machine\system\controlset001\servicesÏÂ,ËùÓÐoracleÏî.
hkey_local_machine\system\controlset002\servicesÏÂ,ËùÓÐoracleÏî.
hkey_local_machine\system\currentcontrolset\servicesÏÂ,ËùÓÐoracleÏî.
hkey_classs_rootÏÂ,ËùÓÐoracleÏî.
2.
ɾ³ýoracle°²×°Îļþ.
ϵͳĿ¼ÏÂ,program filesÎļþ¼ÐÖеÄoracleÎļþ.
3.ÖØÐ°²×°.
ллඣ¬ÒѾ°²×°³É¹¦
Ïà¹ØÎÊ´ð£º
type Exception report
message
description The server encountered an internal error () that prevented it from fulfilling this request.
exception
org.apache.jas ......
ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£
ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£
ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£
ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......
´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæµÄÔʼÎļþ,ÏÂÔØµ½±¾»úÁË.ÎÒÏëÔÚ±¾»ú·ÃÎÊÊý¾Ý¿âÔõôÉèÖð¡.ÊDz»ÊÇÀàËÆ¿ÉÒÔ½¨Á¢Ò»¸öʲôÐéÄâ·þÎñÆ÷À´ÊµÏÖ.Çë´ó¼Ò³ö³öÖ÷Òâ
ÒýÓÃ
´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæ ......
ÏÖÔÚÓÐÁ½ÕÅ±í£ºÎÄÕÂÖ÷±íA(articleId,articleTitle)£¬ÎÄÕÂÆÀÂÛ±íB(commentId,articleId,commentTitle)
ÏÖÔÚÎÒÏëʵÏÖÕâÑùµÄ¹¦ÄÜ£ºÁгöÎÄÕÂÁÐ±í£¬ÆäÖÐÿƪÎÄÕ±êÌâÏÂÃæÁгö´ËÎÄÕµÄǰ2¸öÎÄÕÂÆÀÂÛ£¬ÇëÎÊsqlÓï¾äÔõôд°¡ ......
1¡£ÔõÑùʹxp_cmdshellÄÜÍêÕûÊä³ö³¬¹ý255¸ö×Ö·ûµÄ×Ö·û´®¡£
2¡£select ʱ£¬¼ìË÷ËÙ¶ÈÊÇÓëfromºóµÄ TABLE˳ÐòÓйأ¬»¹ÊÇÓëwhereÌõ¼þµÄ˳ÐòÓйØ(TABLEÊý¾Ý¶àÉÙ )
ÔÚϵͳÊôÐÔÉ趨ÀïÓиöÑ¡Ïî,¿ÉÒÔÐ޸ĵ¥×Ö¶ÎÊä³ö×ÖÊýÏÞÖÆ. ......