oracle ²»ÄÜÔ¶³Ì·ÃÎÊ
·þÎñÆ÷Ϊoracle9i ϵͳΪwindows xp ipµØÖ·Îª222.31.64.211 ·þÎñ½Ðsg196nd ¿ÉÊǿͻ§¶Ë²»ÄÜ·ÃÎÊ ´íÎó tns´íÎó 12535 ±È½Ï¼± ÇëÎÊ´ó¼Ò´ó¸ÅÊÇÄÄÀïÅäÖôíÎóô
×°·þÎñÆ÷ʱÓÐЩÅäÖù¤¾ßʧ°Ü µ«ÊÇÎļþ¼ÐΪF:\oracle ûÓпոñºÍºº×ÖºÜÊÇÆæ¹Ö
ping 222.31.64.211 µÄ½á¹ûÊÇʲô£¿
tnsping sg196nd ½á¹ûÊÇʲô£¿
ÄãµÄtnsname.ora ÖÐÊÇÈçºÎÉèÖõģ¿
ÏòÂ¥ÉÏ˵µÄÄÇÑùpingһϣº
tnsping ʵÀýÃû;
·þÎñÆ÷¶Ë±¾Éí¿ÉÒÔÁ¬½ÓÂð£¬
Èç¹û·þÎñÆ÷±¾Éí¿ÉÒÔÁ¬½Ó£¬²é¿´·þÎñÆ÷ÓÐûÓпªÆô·À»ðǽ
Èç¹ûÓУ¬Òª´ò¿ªÏàÓ¦µÄ¶Ë¿Ú£¬Èç1521
°Ñ·þÎñÆ÷ÉϵķÀ»ðǽ¹ØÁË¡£
ͬÒ⣬windowÉÏÒª¹Ø±Õ·À»ðǽ£¬»òÕßshared socket
Ïà¹ØÎÊ´ð£º
´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæµÄÔʼÎļþ,ÏÂÔØµ½±¾»úÁË.ÎÒÏëÔÚ±¾»ú·ÃÎÊÊý¾Ý¿âÔõôÉèÖð¡.ÊDz»ÊÇÀàËÆ¿ÉÒÔ½¨Á¢Ò»¸öʲôÐéÄâ·þÎñÆ÷À´ÊµÏÖ.Çë´ó¼Ò³ö³öÖ÷Òâ
ÒýÓÃ
´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæ ......
¸÷λoracle¸ßÊÖ£¬Çë½ÌÒ»ÏÂΪʲôoracle 10gÔÚ°²×°µ½°Ù·ÖÖ®°ËÊ®ÎåµÄʱºò¾Í±¨´í²»ÄܼÌÐø°²×°£¿
ÄÚ´æ¶à´ó£¿¡¡ÖØÐÂϸöÊý¾Ý¿â°²×°ÊÔÊÔ..
ÒýÓÃ
¸÷λoracle¸ßÊÖ£¬Çë½ÌÒ»ÏÂΪʲôoracle 10gÔÚ°²×°µ½°Ù·ÖÖ®°ËÊ®ÎåµÄʱ ......
private static final String URL = "jdbc:oracle:thin:@localhost:1521:orcl";
private static final String USERNAME = "sys";
private static final String PASSWORD = "s ......
ÎÒÓÐÒ»¸öserver 2000ÀïµÄÊý¾Ý,ÏÖÔÚÏëתµ½oracleÊý¾Ý¿âÉÏÓÃ,²»ÖªµÀÓÐûÓиßÊÖÓмòµ¥ÓÖ¿ì½ÝµÄ·½·¨,ǰÌáÊDz»ÄܸÄÔÀ´oracleÀïµÄÔÓеÄÊý¾Ý¿â,Ö»ÄÜн¨
ÒýÓÃ
°²×°£Ï£Ò£Á£Ã£Ì£ÅµÄ£Ï£Ä£Â£Ã£¬È»ºóÓãӣѣ̡¡£Ó£Å£Ò£Ö£Å£ ......