ÈçºÎÐÞ¸Ä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
Ïà¹ØÎĵµ£º
±¾ÒëÎ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
Ò» ......
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 ......
1¡¢ÔÚ±¾»ú69ÉÏ´´½¨Êý¾Ý¿âorcl £¬global_name=orcl£¬Ê¹ÓÃÓï¾ä
alter database rename global_name to orcl.us.oracle.com ÐÞ¸ÄÊý¾Ý¿âµÄÈ«¾ÖÊý¾Ý¿âÃûΪorcl.us.oracle.com
2¡¢ÔÚÐé»ú188ÉÏ´´½¨Êý¾Ý¿âviotest£¬global_name=viotest£¬Ê¹ÓÃÓï¾ä
alter database rename global_name to viotest.us.oracle.com ÐÞ¸ÄÊý¾Ý¿âµÄÈ«¾ÖÊ ......
ÈçºÎͨ¹ýSqlplus´´½¨Ò»¸öoracleµÄuser
1£¬Í¨¹ýsystem¹ÜÀíÔ±Á¬½Óµ½ÒªÌí¼ÓUSERµÄDB
»òÕßͨ¹ýÒÔÏÂÃüÁ Connect system/manager@user_datebase AS SYSDBA ;ÒÔSYSµÇ½ȥ´´½¨Óû§
2,´´½¨Óû§²¢·ÖÅäȨÏÞ
drop user asset cascade; ɾ³ ......
ÊÓͼ(view)£¬Ò²³ÆÐé±í, ²»Õ¼ÓÃÎïÀí¿Õ¼ä£¬Õâ¸öÒ²ÊÇÏà¶Ô¸ÅÄÒòΪÊÓͼ±¾ÉíµÄ¶¨ÒåÓï¾ä»¹ÊÇÒª´æ´¢ÔÚÊý¾Ý×ÖµäÀïµÄ¡£ÊÓͼֻÓÐÂß¼¶¨Ò塣ÿ´ÎʹÓõÄʱºò, Ö»ÊÇÖØÐÂÖ´ÐÐSQL.
»¹ÓÐÒ»ÖÖÊÓͼ£ºÎﻯÊÓͼ£¨MATERIALIZED VIEW £©£¬Ò²³ÆÊµÌ廯ÊÓͼ£¬¿ìÕÕ £¨8i ÒÔǰµÄ˵·¨£© £¬ËüÊǺ¬ÓÐÊý¾ÝµÄ£¬Õ¼Óà ......