ÓÐËÓùýOracle FCF
ÓÃJava JDBC Thinµ÷ÓÃORACLE FAST CONNECTION FAILOVERʱ£¬¸ÃÈçºÎÔÚ´úÂëÀïÖ¸¶¨×Ô¶¯ÖØÐÂCONNECT£¬µ±CONNECTION¶ªÊ§µÄʱºò¡£
ûÓùý£¬°ï¶¥ JDBC URL×Ö·û´®¼ÓÉÏautoReconnect=true ²»±£Ö¤ÓÐЧ£¬ÕâÖ»Êǹ淶£¬ÐèÒªÊý¾Ý¿âÖ§³Ö Êý¾ÝÁ¬½Ó³ØÖ±½ÓÉèÖÃÀàËÆÊôÐÔautoReconnect=true »ù±¾µÄ²ÎÊýÉèÖÿ϶¨ÓУ¬µ«Êµ¼ÊЧ¹ûÓëÔ¤ÆÚ²î±ð±È½Ï´ó£¬Ã»ÓÐÈË×ö¹ýÂð ·¹ý£¬²»ÖªµÀÄܲ»ÄÜÅ䣬¹Ù·½ÎĵµÔÚ´Ë£º http://www.oracle86.com/ora_doc/java.111/b31224/fstconfo.htmÒýÓà ·¹ý£¬²»ÖªµÀÄܲ»ÄÜÅ䣬¹Ù·½ÎĵµÔÚ´Ë£º http://www.oracle86.com/ora_doc/java.111/b31224/fstconfo.htm ²Î¿¼²Î¿¼¹Ù·½Îĵµ Æäʵ£¬ÎÒ¾ÍÊÇÓÃ2¸ö¶ÀÁ¢µÄDB£¬°Ñservice_name¸Ä³ÉÒ»Ñù£¬Ä£·ÂRAC FCF ÊÇʲô£¿ ûÓùý£¬°ï¶¥ÒýÓà ÒýÓà 6 Â¥ yxsalj µÄ»Ø¸´: Æäʵ£¬ÎÒ¾ÍÊÇÓÃ2¸ö¶ÀÁ¢µÄDB£¬°Ñservice_name¸Ä³ÉÒ»Ñù£¬Ä£·ÂRAC Ðֵܣ¬Èç¹ûÊÇ´¿JDBCµÄ»°£¬¶ÏÏßÖØÁ¬£¬ÊÇÐèÒªÄã×Ô¼ºÊµÏֵġ£ JDBCûÓжÏÏßÖØÁ¬»úÖÆµÄ¡£ ÔÚcatchÀïÃære-connect¾Í¿ÉÒÔÁË¡£
Ïà¹ØÎÊ´ð£º
´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæµÄÔʼÎļþ,ÏÂÔØµ½±¾»úÁË.ÎÒÏëÔÚ±¾»ú·ÃÎÊÊý¾Ý¿âÔõôÉèÖð¡.ÊDz»ÊÇÀàËÆ¿ÉÒÔ½¨Á¢Ò»¸öʲôÐéÄâ·þÎñÆ÷À´ÊµÏÖ.Çë´ó¼Ò³ö³öÖ÷Òâ ÒýÓà ´ó¼ÒºÃ,ÎÒÏÖÔÚ°Ñoracle·þÎñÆ÷ÉÏÃæ ......
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ÀïµÄÔÓеÄÊý¾Ý¿â,Ö»ÄÜн¨ ÒýÓà °²×°£Ï£Ò£Á£Ã£Ì£ÅµÄ£Ï£Ä£Â£Ã£¬È»ºóÓãӣѣ̡¡£Ó£Å£Ò£Ö£Å£ ......
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 / ......