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
Ïà¹ØÎÊ´ð£º
private static final String URL = "jdbc:oracle:thin:@localhost:1521:orcl";
private static final String USERNAME = "sys";
private static final String PASSWORD = "s ......
ÓÃPL/SQL µÇ½ʱµ¯³ö±¨´í´°¿Ú£¬´íÎóÈçÏ£¡
ORA-01034:ORACLE not available
ORA-27101:shared memory realm does not exist
ÇëÎÊ£¬ÓÐûÓÐÈËÓöµ½ÕâÖÖÇé¿ö£¬Ôõô½â¾ö£¿Ð»Ð»£¡
1. Oracle sid ÕýÈ ......
²éÁËÒ»ÌìµÄblob£¬»¹ÊÇûÀí½âµ½£¬ÎÒÏëÔÚVCÏ´æÈ¡¶þ½øÖƵÄÎļþ£¬Ê¹ÓõÄÊÇoo4o£¬ÕÕ×ŰïÖúÎĵµÉÏÃæµÄдÁËдÈëÊý¾Ý¿âµÄ´úÂ룬»¹ÊÇûд¶Ô£¬´íÎóÌáʾÊÇthis operation is not permitted on a empty LOB£¬ÕâÊÇʲôÒâ˼°¡£¿ÕÕ ......
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 / ......
ÏÖÔÚÊý¾Ý¿â·þÎñÆ÷ÉÏ£¬ÓÐ3¸öÓû§£¬·Ö±ðÓÃÓÚ²»Í¨µÄϵͳ£¬ÏÖÔÚÎÒÐèÒª°ÑÕâÈý¸öϵͳµÄÊý¾Ý¿â·ÖÀ뿪À´£¬×°ÔÚ²»Í¬µÄ·þÎñÆ÷ÉÏ¡£ÓÐŪ¹ýµÄÅóÓÑÇë¸øµãÒâ¼û¡£
²»Í¬ÏµÍ³Ö®¼äÓÐÁªÏµ?
ûÓÐÁªÏµµÄ
exp, imp
ÎÒÒª°ÑÆäÖеÄÁ½ ......