ÈçºÎÐÞ¸Äoracle RAC VIPµØÖ·
ÓÐʱºòÍøÂç·¢Éú±ä¶¯£¬±ØÐëÊÖ¶¯ÐÞ¸ÄÒ»ÏÂRAC VIPµØÖ·£¬²»½öÊǵØÖ·£¬Ò²¿ÉÒÔÐÞ¸ÄVIPËùÔÚµÄÍø¿¨£¬ÔÔòÊÇVIPµØÖ·ÒªºÍPUBµØÖ·ÔÚͬһ¸öÍø¶ÎÄÚ£¬·½·¨ÆäʵÊDZȽϼòµ¥µÄ£¬ÓÐÈËÎʵ½£¬ÎÒ¸øÒ»¸öʾÀýÈçÏ£º
1¡¢¹Ø±ÕÊý¾Ý¿â
srvctl stop database -d db
2¡¢¹Ø±ÕNOTEAPPA
srvctl stop nodeapps -n db2
ÿ¸ö½ÚµãÉÏ·Ö±ðÒÔrootȨÏÞÖ´ÐУ¬Ò»¸ö½ÚµãÒ»¸ö½ÚµãÖ´ÐÐ
ÐÞ¸ÄÍê³Éºó£¬ÐÞ¸ÄÏàÓ¦µÄÿ¸ö½Úµã±¾µØµÄÕìÌýlister.oraºÍtnsname.oraÎļþ¶ÔÓ¦µÄIP,È»ºó¾ÍÊÇÐÞ¸ÄIPµØÖ·ÁË£¬ÏÂÃæµÄÀý×ÓÐ޸ĵ½VIP µ½ETH1É豸ÉÏ
db1#./srvctl modify nodeapps -n db1 -A 192.168.1.110/255.255.255.0/eth1
db2#./srvctl modify nodeapps -n db2 -A 192.168.1.210/255.255.255.0/eth1
3¡¢ÖØÐÂÆô¶¯RACÊý¾Ý¿â¾Í¿ÉÒÔÁË
»Ö¸´ÔÀ´µÄÍø¿¨ÉèÖÃ
/oracle/product/102/crs/bin/srvctl modify nodeapps -n db1 -A 192.168.1.110/255.255.255.0/eth0
/oracle/product/102/crs/bin/srvctl modify nodeapps -n db2 -A 192.168.1.210/255.255.255.0/eth0
Ïà¹ØÎĵµ£º
°²×°£º
ÔËÐÐG:\install\setup.exe°²×°Oracle£¬µ«²»´´½¨Æô¶¯Êý¾Ý¿â
´´½¨Êý¾Ý¿â(ʹÓÃConfiguration And Migration Tools->DataBase Configuration Assistant)
´´½¨¼àÌý³ÌÐò(ʹÓÃConfiguration And Migration Tools->NetManager»òÕß Configuration And Migration Tools->Net Configuration Assistant)
´´½¨·þÎñ ......
±¾ÒëÎIJÉÓÃ֪ʶ¹²ÏíÊðÃû-·ÇÉÌÒµÐÔʹÓÃ-Ïàͬ·½Ê½¹²Ïí 3.0 UnportedÐí¿ÉÐÒé·¢²¼£¬×ªÔØÇë±£Áô´ËÐÅÏ¢
ÒëÕߣºÂí³ÝÜÈ | Á´½Ó£ºhttp://www.dbabeta.com/2010/oracle-sql-server-comparison-i.html
×÷ÕߣºSadequl Hussain | ÔÎÄ£ºhttp://www.sql-server-performance.com/articles/dba/oracle_sql_server_comparison_p1.aspx
Ò» ......
ÏîÄ¿ÖÐÓÐÉæ¼°´æ´¢¹ý³Ì¶Ô×Ö·û´®µÄ´¦Àí£¬ËùÒԾͽ«ÔÚÍøÉϲéÕÒµ½µÄ×ÊÁÏ»ã×Ü£¬×öÒ»¸öÐÅϢƴ½ÓʽµÄ×ܽᡣ
ÒÔÏÂÐÅÏ¢¾ùÀ´×Ô»¥ÁªÍø£¬Ìù³öÀ´Ò»Ôò×Ô¼º±£´æÒÔ´ýÒÔºóʹÓã¬Ò»Ôò¹©´ó¼Ò·ÖÏí¡£
×Ö·ûº¯Êý——·µ»Ø×Ö·ûÖµ
ÕâЩº¯ÊýÈ«¶¼½ÓÊÕµÄÊÇ×Ö·û×åÀàÐ͵IJÎÊý(CHR³ýÍâ)²¢ÇÒ·µ»Ø×Ö·ûÖµ.
³ýÁËÌØ±ð˵Ã÷µÄÖ®Íâ,ÕâЩº¯Êý´ó²¿·Ö·µ» ......
´Óoracle8µ½oracle10£¬JDBCĿ¼ÏµÄÇý¶¯°ü¶¼¸÷Óв»Í¬¡£¿´ÁËÒ»ÏÂoracleµÄÎĵµËµÃ÷£¬Á˽âÁËÒ»ÏÂËüÃǵÄÓÃ;£¬ÏàÐÅ´ó¼ÒÓÐʱºòÒ²ºÜÃÔ»ó£¬Ð´³öÀ´¹²Ïíһϡ£
ÕâЩÊÇoracle10gϵÄÇý¶¯°üµÄÃû³ÆºÍËüÃǵÄ×÷Óã¬ÆäËû°æ±¾µÄoracle»ù±¾ÀàËÆ¡£
Ö§³ÖËùÓÐÆ½Ì¨µÄJDBC ThinÇý¶¯
classes12.jar (1,417,089 bytes) - JDK 1.2 ºÍ JDK 1.3ÏÂÊ¹Ó ......
×î½üæÓÚ¹«Ë¾µÄÏîÄ¿¿ª·¢£¬ºÜ¾ÃûÓÐÀ´csdnÁË¡£½ñÌìÎÞÊ£¬ÉÏÀ´Ð´µã¶«Î÷¡£¹©´ó¼Ò²Î¿¼£¬²»¶ÔµÄµØ·½»¹Ï£Íû´ó¼ÒÅúÆÀÖ¸Õý¡£
Ò»ÏÂÊǶÔoracleÊý¾Ý¿â±íµÄһЩ²Ù×÷Óï¾ä£º
ÒѾ½¨ºÃµÄ±íÌí¼Ó×Ö¶Î
alter table Tablename add(column1&nb ......