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

ÓÐË­Óùý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ÀëÏß·ÃÎÊ---ÇóÖú - Oracle / »ù´¡ºÍ¹ÜÀí

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

javaÔõôÁ¬½ÓOracle£¬¼±°¡ - Java / JavaÏà¹Ø

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 - Oracle / »ù´¡ºÍ¹ÜÀí

ÎÒÓÐÒ»¸öserver 2000ÀïµÄÊý¾Ý,ÏÖÔÚÏëתµ½oracleÊý¾Ý¿âÉÏÓÃ,²»ÖªµÀÓÐûÓиßÊÖÓмòµ¥ÓÖ¿ì½ÝµÄ·½·¨,ǰÌáÊDz»ÄܸÄÔ­À´oracleÀïµÄÔ­ÓеÄÊý¾Ý¿â,Ö»ÄÜн¨

ÒýÓÃ
°²×°£Ï£Ò£Á£Ã£Ì£ÅµÄ£Ï£Ä£Â£Ã£¬È»ºóÓãӣѣ̡¡£Ó£Å£Ò£Ö£Å£ ......

oracle °²×° 01092 ´íÎó - 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 / ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ