Oracle ¿Í»§¶Ë C# Á¬½Ó
Ò»¸öÈí¼þ£¬°²×°ÁËoracle¿Í»§¶Ë£¬ÅäÖÃÐÅÏ¢ÈçÏÂ
service identification
servce name: MYSYS
sid »ÒÉ«
connection type: database default
use oracle8i ... ûÓÐÑ¡ÖÐ
address configureation
address1
protocol: tcp/ip
hostname 10.3.1.1
port: 1425
ÁíÍâ²Î¼ûÎÒÕâ¸öÌû×Ó£¬Ñ°ÕÒÁ¬½ÓÊý¾ÝµÄÓû§ÃûºÍÃÜÂ벿·Ö
http://topic.csdn.net/u/20100112/10/98222f13-6906-4282-97e4-5e87333d1160.html
ÎÒÔÚ°²×°Ä¿Â¼ÏÂÕÒµ½Ò»¸öxmlÎļþÓÐÈçϵIJ¿·ÖÃèÊöÊý¾ÝÁ¬½ÓµÄ
<configuration>
<appSettings>
<add key ="OracleConnectionString" value="Password=Xmy10%cam;User ID=mytest;Data Source=MYTEST"> </add>
.... </appSettings>
</configuration>
²»ÖªµÀÊDz»ÊÇ£¬ÓÐÈçÉÏÐÅÏ¢£¬ÎÒÒªÈçºÎ²ÅÄÜÁ¬½ÓÊý¾Ý¿â£¬²éѯÊý¾ÝÄØ£¬Ð»Ð»¡£
Ôõô´ò¿ªÁ¬½ÓÄØ£¿ÎÒ¶Ôoracle²»¶®£¬µ«ÎÒ¶®µãsql
Ïà¹ØÎÊ´ð£º
¸÷λoracle¸ßÊÖ£¬Çë½ÌÒ»ÏÂΪʲôoracle 10gÔÚ°²×°µ½°Ù·ÖÖ®°ËÊ®ÎåµÄʱºò¾Í±¨´í²»ÄܼÌÐø°²×°£¿
ÄÚ´æ¶à´ó£¿¡¡ÖØÐÂϸöÊý¾Ý¿â°²×°ÊÔÊÔ..
ÒýÓÃ
¸÷λoracle¸ßÊÖ£¬Çë½ÌÒ»ÏÂΪʲôoracle 10gÔÚ°²×°µ½°Ù·ÖÖ®°ËÊ®ÎåµÄʱ ......
ÔÚϵͳÔËÐеÄʱºò×ÜÊÇÓÐÒ»¿é´ÅÅÌʼÖÕÉÁºìµÆ£¬½øÈëϵͳºó
#topas²é¿´×ÜÊÇÓÐÒ»¿é´ÅÅÌ%BUSYΪ90%ÒÔÉÏ£¬
Êý¾Ý¿â°æ±¾£ºoracle 9.2.0.7
Êý¾ÝÎļþ¹ÒÔØµÄ½Úµã£º/oradata/pcs/ Âß¼¾íºÅlv04
#lslv -l lv04
......
²éÁËÒ»ÌìµÄblob£¬»¹ÊÇûÀí½âµ½£¬ÎÒÏëÔÚVCÏ´æÈ¡¶þ½øÖƵÄÎļþ£¬Ê¹ÓõÄÊÇoo4o£¬ÕÕ×ŰïÖúÎĵµÉÏÃæµÄдÁËдÈëÊý¾Ý¿âµÄ´úÂ룬»¹ÊÇûд¶Ô£¬´íÎóÌáʾÊÇthis operation is not permitted on a empty LOB£¬ÕâÊÇʲôÒâ˼°¡£¿ÕÕ ......
ÎÒÓÐÒ»¸öserver 2000ÀïµÄÊý¾Ý,ÏÖÔÚÏëתµ½oracleÊý¾Ý¿âÉÏÓÃ,²»ÖªµÀÓÐûÓиßÊÖÓмòµ¥ÓÖ¿ì½ÝµÄ·½·¨,ǰÌáÊDz»ÄܸÄÔÀ´oracleÀïµÄÔÓеÄÊý¾Ý¿â,Ö»ÄÜн¨
ÒýÓÃ
°²×°£Ï£Ò£Á£Ã£Ì£ÅµÄ£Ï£Ä£Â£Ã£¬È»ºóÓãӣѣ̡¡£Ó£Å£Ò£Ö£Å£ ......
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 / ......