ÈçºÎÐÞ¸Ä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
Ïà¹ØÎĵµ£º
Ò» ǰÌá
Ï£Íû×îеļͼÔÚ¿ªÍ·¸øÄãµÄ±í½¨Á¢²éѯ£º
񡜧mytable
²éѯ£ºcreate or replace view as mytable_view from mytable order by id desc ÆäÖУ¬×îºÃʹÓÃÐòÁкÅcreate sequence mytable_sequence À´×Ô¶¯Ôö¼ÓÄãµÄ¼ ......
ÏîÄ¿ÖÐÓÐÉæ¼°´æ´¢¹ý³Ì¶Ô×Ö·û´®µÄ´¦Àí£¬ËùÒԾͽ«ÔÚÍøÉϲéÕÒµ½µÄ×ÊÁÏ»ã×Ü£¬×öÒ»¸öÐÅϢƴ½ÓʽµÄ×ܽᡣ
ÒÔÏÂÐÅÏ¢¾ùÀ´×Ô»¥ÁªÍø£¬Ìù³öÀ´Ò»Ôò×Ô¼º±£´æÒÔ´ýÒÔºóʹÓã¬Ò»Ôò¹©´ó¼Ò·ÖÏí¡£
×Ö·ûº¯Êý——·µ»Ø×Ö·ûÖµ
ÕâЩº¯ÊýÈ«¶¼½ÓÊÕµÄÊÇ×Ö·û×åÀàÐ͵IJÎÊý(CHR³ýÍâ)²¢ÇÒ·µ»Ø×Ö·ûÖµ.
³ýÁËÌØ±ð˵Ã÷µÄÖ®Íâ,ÕâЩº¯Êý´ó²¿·Ö·µ» ......
1¡¢Í¨¹ýToad½«Êý¾Ý¿É½á¹¹Éú³ÉSQL£¨×¢ÒâÓû§£©¡£
[DataBase] [Export] [GenerateSchmaScript]
2¡¢´´½¨DBLink.
DROP PUBLIC DATABASE LINK "ROOT.US.ORACLE.COM";
CREATE PUBLIC DATABASE LINK "ROOT.US.ORACLE.COM"
&nb ......
ORACLEÈÕÆÚʱ¼äº¯Êý´óÈ«
TO_DATE¸ñʽ(ÒÔʱ¼ä:2007-11-02 13:45:25ΪÀý)
Year:
yy two digits Á½Î»Äê   ......
ÊÓͼ(view)£¬Ò²³ÆÐé±í, ²»Õ¼ÓÃÎïÀí¿Õ¼ä£¬Õâ¸öÒ²ÊÇÏà¶Ô¸ÅÄÒòΪÊÓͼ±¾ÉíµÄ¶¨ÒåÓï¾ä»¹ÊÇÒª´æ´¢ÔÚÊý¾Ý×ÖµäÀïµÄ¡£ÊÓͼֻÓÐÂß¼¶¨Ò塣ÿ´ÎʹÓõÄʱºò, Ö»ÊÇÖØÐÂÖ´ÐÐSQL.
»¹ÓÐÒ»ÖÖÊÓͼ£ºÎﻯÊÓͼ£¨MATERIALIZED VIEW £©£¬Ò²³ÆÊµÌ廯ÊÓͼ£¬¿ìÕÕ £¨8i ÒÔǰµÄ˵·¨£© £¬ËüÊǺ¬ÓÐÊý¾ÝµÄ£¬Õ¼Óà ......