Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

jdbcÑ­»·Á¬½Ó¡¢¶Ï¿ªoracleµÄ¹îÒìÎÊÌ⣬Çë½Ì´ó¼Ò

½ñÌìÓöµ½Ò»¸öÆæ¹ÖµÄÎÊÌ⣬OralceÊý¾Ý¿â£¬Öظ´»ñÈ¡jdbcÁ¬½Ó¡¢ÔÙÁ¢¿Ì¹Ø±Õ£¬Ñ­»·200´Î×óÓÒ£¬¼´Å׳öÒì³£:

Exception in thread "main" java.sql.SQLException: Listener refused the connection with the following error:
ORA-12519, TNS:no appropriate service handler found
The Connection descriptor used by the client was:
10.72.4.190:1521:orcl

ÒÑ»»OracleµÄjdbcÇý¶¯£¬½á¹û»¹ÊÇÒ»Ñù£¬¶¼Å׳öÀàËÆµÄÒì³£¡£ÆÚ¼ä£¬Ò²µ÷ÕûÁËoracleµÄprocessÊýÄ¿£¬µ«²»Æð×÷Óã¬ÒòΪÎÒʵ¼ÊÊÇÔÚµ¥Ï̻߳·¾³ÖнøÐеIJâÊÔ¡£

ÏÖÔÚµÄÒÉÎÊ£º
1.ΪʲôOralce jdbc¹Ø±ÕÁ¬½ÓµÄ·½·¨£¬²¢Ã»ÓÐÕæÕý¹Ø±ÕµôÁ¬½Ó¡£
2.ÔÚµ¥Ïß³ÌÖУ¬Ó¦¸ÃÔõô×ö£¬²ÅÄܳ¹µ×¹Ø±ÕjdbcÁ¬½Ó¡£


¿ÒÇë¸÷λ´ïÈ˰ïæ½â»ó£¬Ð»Ð»¡£¡£¡£


¸½£º²âÊÔ´úÂë

int i = 0;
Class.forName("oracle.jdbc.driver.OracleDriver");

while (true)
{
  Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@10.72.4.190:1521:orcl", "SYSTEM", "abc");
  conn.close();
  i++;
}


¶¥

¿ÒÇë¸ßÊÖ½â´ð£¬¹òл¡£¡£¡£

¶¥

²»¶®¡£¡£¡£
Â¥Ö÷Õâô×öµÄÄ¿µÄÊÇʲô°¡¡£

ÔÚ²»Ê¹ÓÃÁ¬½Ó³ØµÄÇé¿öÏ£¬ÓпÉÄܷdz£Æµ·±µØÈ¡Á¬½Ó¡¢¹Ø±ÕÁ¬½Ó¡£ÎÒ¾õµÃÕâÊǺÜÕý³£µÄÓ¦Óã¬Õâ²»¹ýÎÒÄ£ÄâÁËһϼ«ÏÞÇé¿ö¡£

ÏÖÔÚ¾ÍÊǸ㲻¶®£¬ÎªÊ²Ã´oracle jdbcµÄ¹Ø±ÕÁ¬½Ó²Ù×÷²»Æð×÷Ó㬾ÍÏñû¹Ø±ÕÒ»Ñù¡£


´ó¼Ò¸øµãÒâ¼û°É£¬Íò·Ö¸Ðл¡£



Ïà¹ØÎÊ´ð£º

ÇóÖúORACLEÅúÁ¿Çå³ý±íÊý¾ÝµÄÎÊÌâ - Oracle / ¿ª·¢

±ÈÈçÎÒÓÐtestA¡¢testB¡¢testCÈý¸ö±í
ÎÒÏÖÔÚÐèҪдһ¸öÅú´¦Àí»òÕ߽ű¾¸ø±ðÈË ×÷ÓþÍÊÇÖ´ÐÐÕâ¶ÎÓï¾ä¿ÉÒÔÇå³ýÕâÈý¸ö±íÀïÃæµÄÊý¾Ý ¾ÍÊÇÒ»¸ö³õʼ»¯µÄÒâ˼
ÄÄλ¸ßÈ˰ïÖúϰ¡ Ò»¸öÊý¾Ý¿âС°×ÔÚ´ËÇó¾ÈÀ²
SQL code:
......

oracleµ¼Èë»Ø¹ö - Oracle / ¿ª·¢

abnormal end of export file
IMP-00028: partial import of previous table rolled back: 3828 rows rolled back
  
ÓÐûÓÐÒ»ÖÖ·½·¨Èõ¼Èë¼ÌÐø½øÐжø²»Òì³£Ìø³ö»Ø¹ö£¿
ignore=y

Äã² ......

OracleÀëÏß·ÃÎÊ---ÇóÖú - Oracle / »ù´¡ºÍ¹ÜÀí

´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæµÄԭʼÎļþ,ÏÂÔØµ½±¾»úÁË.ÎÒÏëÔÚ±¾»ú·ÃÎÊÊý¾Ý¿âÔõôÉèÖð¡.ÊDz»ÊÇÀàËÆ¿ÉÒÔ½¨Á¢Ò»¸öʲôÐéÄâ·þÎñÆ÷À´ÊµÏÖ.Çë´ó¼Ò³ö³öÖ÷Òâ
ÒýÓÃ
    ´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæ ......

oracle 10g°²×°µ½85%ʱ±¨´í

¸÷λoracle¸ßÊÖ£¬Çë½ÌÒ»ÏÂΪʲôoracle 10gÔÚ°²×°µ½°Ù·ÖÖ®°ËÊ®ÎåµÄʱºò¾Í±¨´í²»ÄܼÌÐø°²×°£¿

ÄÚ´æ¶à´ó£¿¡¡ÖØÐÂϸöÊý¾Ý¿â°²×°ÊÔÊÔ..

ÒýÓÃ
¸÷λoracle¸ßÊÖ£¬Çë½ÌÒ»ÏÂΪʲôoracle 10gÔÚ°²×°µ½°Ù·ÖÖ®°ËÊ®ÎåµÄʱ ......

oracleÓëaix - Oracle / ¸ß¼¶¼¼Êõ

ÔÚϵͳÔËÐеÄʱºò×ÜÊÇÓÐÒ»¿é´ÅÅÌʼÖÕÉÁºìµÆ£¬½øÈëϵͳºó
#topas²é¿´×ÜÊÇÓÐÒ»¿é´ÅÅÌ%BUSYΪ90%ÒÔÉÏ£¬
Êý¾Ý¿â°æ±¾£ºoracle 9.2.0.7 
Êý¾ÝÎļþ¹ÒÔØµÄ½Úµã£º/oradata/pcs/ Âß¼­¾íºÅlv04 
#lslv -l lv04 ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ