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µÄ¹Ø±ÕÁ¬½Ó²Ù×÷²»Æð×÷Ó㬾ÍÏñû¹Ø±ÕÒ»Ñù¡£
´ó¼Ò¸øµãÒâ¼û°É£¬Íò·Ö¸Ðл¡£
Ïà¹ØÎÊ´ð£º
±ÈÈçÎÒÓÐtestA¡¢testB¡¢testCÈý¸ö±í
ÎÒÏÖÔÚÐèҪдһ¸öÅú´¦Àí»òÕ߽ű¾¸ø±ðÈË ×÷ÓþÍÊÇÖ´ÐÐÕâ¶ÎÓï¾ä¿ÉÒÔÇå³ýÕâÈý¸ö±íÀïÃæµÄÊý¾Ý ¾ÍÊÇÒ»¸ö³õʼ»¯µÄÒâ˼
ÄÄλ¸ßÈ˰ïÖúϰ¡ Ò»¸öÊý¾Ý¿âС°×ÔÚ´ËÇó¾ÈÀ²
SQL code:
......
abnormal end of export file
IMP-00028: partial import of previous table rolled back: 3828 rows rolled back
ÓÐûÓÐÒ»ÖÖ·½·¨Èõ¼Èë¼ÌÐø½øÐжø²»Òì³£Ìø³ö»Ø¹ö£¿
ignore=y
Äã² ......
´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæµÄÔʼÎļþ,ÏÂÔØµ½±¾»úÁË.ÎÒÏëÔÚ±¾»ú·ÃÎÊÊý¾Ý¿âÔõôÉèÖð¡.ÊDz»ÊÇÀàËÆ¿ÉÒÔ½¨Á¢Ò»¸öʲôÐéÄâ·þÎñÆ÷À´ÊµÏÖ.Çë´ó¼Ò³ö³öÖ÷Òâ
ÒýÓÃ
´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæ ......
¸÷λoracle¸ßÊÖ£¬Çë½ÌÒ»ÏÂΪʲôoracle 10gÔÚ°²×°µ½°Ù·ÖÖ®°ËÊ®ÎåµÄʱºò¾Í±¨´í²»ÄܼÌÐø°²×°£¿
ÄÚ´æ¶à´ó£¿¡¡ÖØÐÂϸöÊý¾Ý¿â°²×°ÊÔÊÔ..
ÒýÓÃ
¸÷λoracle¸ßÊÖ£¬Çë½ÌÒ»ÏÂΪʲôoracle 10gÔÚ°²×°µ½°Ù·ÖÖ®°ËÊ®ÎåµÄʱ ......
ÔÚϵͳÔËÐеÄʱºò×ÜÊÇÓÐÒ»¿é´ÅÅÌʼÖÕÉÁºìµÆ£¬½øÈëϵͳºó
#topas²é¿´×ÜÊÇÓÐÒ»¿é´ÅÅÌ%BUSYΪ90%ÒÔÉÏ£¬
Êý¾Ý¿â°æ±¾£ºoracle 9.2.0.7
Êý¾ÝÎļþ¹ÒÔØµÄ½Úµã£º/oradata/pcs/ Âß¼¾íºÅlv04
#lslv -l lv04
......