OracleÊý¾Ý¿âÁ¬½Ó²âÊÔÎÊÌâ - .NET¼¼Êõ / C#
¾Í¼òµ¥Ê¾ÒâÏÂÎÒдµÄ´úÂ룬µ«ÊÇÕâÑùÐèÒªÅäÖÃOracleÊý¾Ý¿â·þÎñµÈ£¨ÎҵijÌÐòĿǰûÓгɹ¦£©£¬¸Ð¾õʵ¼ÊÔËÓúÜÂé·³£¬²»¿ÉÐÐ
ÏñVisual StudioÖУ¬Ö±½ÓÁ¬½ÓÊý¾Ý¿â£¬É¶Ò²²»ÓÃÅäÖ㬾ÍÄܲâÊÔÕâ¸öÁ¬½ÓÓÐûÓÐÓÐЧ
public string CheckConnection(string ConnStr)
{
try
{
OracleConnection OraConn = new OracleConnection(ConnStr);
OraConn.Open();
OraConn.Close();
Message = "Á¬½Ó³É¹¦";
}
catch(System.Exception e)
{
Message = "Á¬½Óʧ°Ü";
}
return Message;
}
ÏÖÔÚÎÒÏëÖªµÀµÄÊÇ£¬ÓÐûÓÐʲôÇÐʵÓÐЧµÄ·½·¨ÊµÏÖOracleÊý¾Ý¿âµÄÁ¬½Ó²âÊÔ£¬»òÕßVS×Ô´ø¿Ø¼þ
¸÷λ´ó¸ç°ïæ°¡¡£¡£¡£
Õâ¸öÓ¦¸ÃÊÇOracleµÄÎÊÌâ,´úÂëÎÒÈÏΪÊÇûÎÊÌâµÄ
¶÷£¬ÎÒÒ²¾õµÃÕâ¸ö˼·ʵÏÖÊý¾Ý¿âÁ¬½Ó£¬ÔÚ´úÂëÉÏûÎÊÌ⣬µ«ÊÇÏÖÔÚÎÒ¾õµÄ°Ñ»·¾³ÅäÖÃÆðÀ´Ì«Âé·³ÁË£¬ÕæÕýÔËÓõ½ÏÖʵÖв»Ì«¿ÉÐУ¬ÓÐûÓÐÆäËû·½Ê½¿ÉÒÔÁ¬½Óµ½OracleÊý¾Ý¿â
ÄãÊÇÒªÁ¬½ÓÊý¾Ý¿â »¹ÊDzâÊÔÁ¬½ÓÊý¾Ý¿â£¿
²âÊÔÁ¬½ÓÊý¾Ý¿â
ÓиöÎÊÌâ. ÄãΪʲô²»×Ô¼ºÔÚ pl/sql ÀïÃæÅäÔòÅäÖòâÊÔ£¿
ÄãÏÖÔÚËù×öµÄ²Ù×÷ÎÞ·ÇÊÇÏëÖ¤Ã÷ ÄãµÄ»úÆ÷Óëoracle·þÎñÆ÷ ÊÇ·ñÁ¬½ÓÉÏÁË
ÄÇô pl/sql ÀïÃæµÄÅäÖùÜÀíÆ÷ ºÜÈÝÒ×ʵÏÖÕâ¸ö²Ù×÷ д´úÂë²âÊÔ Äã²»¾õµÃ¹ýÓÚÂé·³...
pl/sql¿ÉÒÔÁ¬µ½°¡£¬ÎÒÏÖÔÚÊÇ×öÒ»¸öÏîÄ¿£¬ÀïÃæÓиö¹¦ÄÜÐèÒª²âÊÔÓû§ÊäÈëµÄÊý¾Ý¿âÁ¬½ÓÐÅÏ¢ÊÇ·ñÓÐЧ£¬so¡£¡£¡£
Ŷ ÕâÑùµÄ°¡
http://support.microsoft.com/kb/965022/zh-cn
¸øÄã²Î¿¼
˵ʵ»° ºÜ¶àÈ˶¼ÊDzÉÓõÚÈý·½¹¤¾ßÀ´ÊµÏÖÕâ¸ö ²»¹ýÄãÕâÏîÄ¿ÀïÃ
Ïà¹ØÎÊ´ð£º
ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£
ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£
ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£
ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......
ÔÚÖ´ÐаüµÄʱºòÒýÓÃoracle spatial¿Õ¼äº¯Êý³ö´í£¬³ö´íÇé¿öÈçÏÂ
Errors in file
/user/oracle/app/oracle/admin/grid/udump/grid1_ora_143768.trc: ORA-29902:
error in executing ODCIIndexStart() routine ORA-0 ......
ÔÚϵͳÔËÐеÄʱºò×ÜÊÇÓÐÒ»¿é´ÅÅÌʼÖÕÉÁºìµÆ£¬½øÈëϵͳºó
#topas²é¿´×ÜÊÇÓÐÒ»¿é´ÅÅÌ%BUSYΪ90%ÒÔÉÏ£¬
Êý¾Ý¿â°æ±¾£ºoracle 9.2.0.7
Êý¾ÝÎļþ¹ÒÔØµÄ½Úµã£º/oradata/pcs/ Âß¼¾íºÅlv04
#lslv -l lv04
......
¼ÙÉètable01 ÖÐÓÐ ÒÔÏÂ×ÊÁÏ
emp_no emp_name
------- ------------
0001 TOM
0002 JOHN
0003 MARY
³£Óõ绰
¶øÎÒÃÇÒªµÃµ½ÒÔϵÄOUTPUT (»òÊǸ÷ÖÖÆäËûµÄoutput)
0001,TOM
0002,JOHN
......
¹«Ë¾¿ª·¢Ò»¸ö´¥ÃþÆÁ³ÌÐò£¬ÎÒ¸ºÔðµÄÒ»¿é£¬ÊµÏÖÕâÑùÒ»¸ö¹¦ÄÜ£¬µ±Êó±êµã»÷´°¿ÚÖÐͼƬ£¨Ò»ÕÅͼ·Ö³É¼¸²¿·Ö£©µÄÆäÖÐÒ»²¿·Öʱ£¬½«Õⲿ·ÖͼƬ½ØÈ¡³öÀ´£¬µ¯³öеĴ°¿Ú£¬½«½ØÈ¡³öµÄͼƬÏÔʾ³öÀ´¡£ÎÒʹÓÃRectangeÀà¿ØÖÆÁË·µ»Ø£¬ ......