oracleÓë.netʱºò±¨´í
ÎÒÈ·¶¨£¬ÎÒoracleÀïÃæµÄÅäÖö¼ÊÇÕýÈ·µÄ£¨ÒòΪÎÒÓÃpb£¬plsql¶¼¿ÉÒÔÁ¬½ÓoracleÊý¾Ý¿â£©
µ«ÊÇÎÒÏë.netÀïÃæÁ¬½ÓoracleÊý¾Ý¿âµÄʱºò¾ÍÊDZ¨´í
ÎÒµÄÁ¬½ÓÎļþÊÇÕâÑùдÁ˵ģºProvider=OraOLEDB.Oracle;User ID=hwuser;Password=hw2001;Data Source=ora8;
ÎÒÊÇÕâÑùЩµÄ·ÃÎÊÊý¾Ý¿â·½·¨
static string oraConStr = ConfigurationSettings.AppSettings["oreConnection"];
/**
* Êý¾Ý¿âÖвéѯÓï¾äÖ´ÐÐ
*/
public DataSet QueryInfo(string sql)
{
DataSet ds = new DataSet ();
OleDbConnection olecon = new OleDbConnection(oraConStr);
OleDbDataAdapter oledba = new OleDbDataAdapter(sql, olecon);
oledba.Fill(ds);
return ds;
}
µ«ÊÇÔÚÎÒÖ´ÐÐ oledba.Fill(ds);µÄʱºò¾Í±¨´í:Óû§´úÂëδ´¦Àí£ºInvalidOperationException¡°Î´ÔÚ±¾µØ¼ÆËã»úÉÏ×¢²á¡°OraOLEDB.Oracle¡±Ìṩ³ÌÐò¡£¡±
Çë¸ßÊÖ°ïÖúÒ»ÏÂÈü£¬Ð»ÁË£¡£¡£¡
oracle¿Í»§¶Ë×°ÁËû£¿»¹ÓÐtnsname.oraÓÐûÓÐÕýÈ·µÄ·ÅÖÃÔÚÖ¸¶¨µÄλÖã¿
Data Source = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS =(PROTOCOL = TCP)(HOST =·þÎñÆ÷Ãû)(PORT = ¶Ë¿ÚºÅ)))(CONNECT_DATA = (SERVER = DEDICATED)(SERVICE_NAME = Êý¾Ý¿âÃû))); User Id = Óû§Ãû; &nbs
Ïà¹ØÎÊ´ð£º
ÎÒÊÇÓÃÔ¶³Ì×ÀÃæÁ¬²Ù×÷·þÎñÆ÷ÉϵÄÊý¾Ý¿â¡£
ÔÚ´´½¨Ò»¸öÓû§Ö®ºó£¬ÔÙÓÃPLSQLµÇ¼£¬ÔòPLSQLËÀµôÁË¡£
ÎҹصôPLSQLÖ®ºó£¬ÓÃÆäËûÓû§Ò²²»ÄܵǼ¡£
ÎÒ°ÑoracleµÄ·þÎñÍ£Ö¹£¬½á¹û¾ÍÊÇoracleµÄ·þÎñ״̬¾ÍÍ£ÁôÔÚ¡°Í ......
¸÷λ´ó¸ç£¬°ï¸öæ¡£
ϸöOracle for vista °æ±¾µÄ°²×°ÊÔÊÔ
10GºÍ11GµÄ
http://www.oracle.com/technology/software/products/database/index.html
------------------------------------------- ......
ÔÚϵͳÔËÐеÄʱºò×ÜÊÇÓÐÒ»¿é´ÅÅÌʼÖÕÉÁºìµÆ£¬½øÈëϵͳºó
#topas²é¿´×ÜÊÇÓÐÒ»¿é´ÅÅÌ%BUSYΪ90%ÒÔÉÏ£¬
Êý¾Ý¿â°æ±¾£ºoracle 9.2.0.7
Êý¾ÝÎļþ¹ÒÔØµÄ½Úµã£º/oradata/pcs/ Âß¼¾íºÅlv04
#lslv -l lv04
......
oracle 11g °²×° 01092 ´íÎó,
ÈÕÖ¾ÐÅÏ¢£º
[oracle@linux trace]$ vi alert_orcl.log
MMON started with pid=14, OS id=9089
RESETLOGS after incomplete recovery UNTIL CHANGE 522752
Errors in file / ......