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

Oracle RAC °²×°Îĵµ


Ò». ÓйØRACµÄÏà¹Ø¸ÅÄî
RAC:È«³ÆÊÇReal Application Cluster¡£RAC²¢·ÇÊǸöм¼Êõ£¬ÆäÇ°Éí½ÐOPS(Oracle Parallel Server)£¬´Ó9i¿ªÊ¼²Å¸ÄÃû½ÐRAC,oracle Data GuardÔÚ9i֮ǰ½Ð×öStandby
¸ÃÌåϵʵÏÖÁ˶à¸öʵÀýͬʱ·ÃÎʺ͹ÜÀíͬһÊý¾Ý¿â£¬¶à¸öʵÀý¿ÉÒÔ´æÔÚÓÚ²»Í¬½Úµã£¬Ò²¿ÉÒÔÔÚÏàͬµÄ½ÚµãÉÏ(´ÓÌáÉýÐÔÄܵĽǶÈÀ´¿´£¬²¢²»ÍƼöÕâÑù)£¬±Ë´Ëͨ¹ýÄÚÍøÁ¬½Ó½»»»Êý¾Ý£¬²¢ÇÒÄܹ»×Ô¶¯Æ½ºâ¸ºÔØ£¬Èç¹ûÆäÖÐij¸ö½Úµã·¢Éú¹ÊÕÏ£¬RACÄܹ»Í¨¹ýºǫ́µÄ¼à¿Ø½ø³Ì½«Á¬½Ó×Ô¶¯Çл»µ½ÁíÍâÒ»¸ö»ò¶à¸ö½ÚµãÉÏ£¬´Ó¶øʵÏÖÓ¦ÓõÄÎÞ·ìÇл»£¬¶ÔʵÀýµÄ¸ß¿ÉÓÃÌṩ±£»¤¡£
RAC±£»¤µÄÊÇʵÀý£¬¶ø²¢·ÇÊý¾Ý(¶ÔÊý¾Ý½øÐÐÈßÓàµÄÌØÐÔÔÚoracleÖнÐData guard)¡£
CRS:Cluster Ready ServiceÊÇoracle¼¯Èº¼þµÄÈí¼þ¼Ü¹¹
CVU:È«³ÆCluster Verification Utility£¬CVUÊÇoracleרÃÅΪRACÌṩµÄÒ»¸ö¼ì²é¹¤¾ß£¬Ä¿µÄÊÇÆÚÍûÔÚ°²×°Ç°¾ÍÄãµÄ°²×°»·¾³½øÐмì²é£¬¿´¿´ÈíÓ²¼þ»·¾³ÊÇ·ñÒѾÍÐ÷£¬¸Ã¹¤¾ß¹¦Äܷdz£Ç¿´ó£¬Í¨¹ý´îÅ䲻ͬ²ÎÊý¿ÉÒÔ¼ì²é°²×°RACËùÐè»·¾³µÄ·½·½ÃæÃæ²»¹ý£¬¸Ã¹¤¾ßËùÏÔʾµÄ¼ì²é½á¹ûÒ²½ö¹©²Î¿¼£¬¾ßÌåÇé¿öÐèÒª¾ßÌå·ÖÎö£¬²¢·Ç˵Æä¼ì²é±¨´í£¬Äã¾Í²»Äܳɹ¦ÅäÖÃRACÁË¡£ÁíÍâÓÉÓÚoracle×ÔÉíµÄһЩbugµÈÔ­Òò£¬¿ÉÄÜÒ²»áÔì³ÉCVU¸ø³ö´íÎóµÄÐÅÏ¢¡£
OUI:ÆäÈ«³ÆÊÇOracle Universal Installer£¬¾ÍÊÇͼÐλ¯µÄ°²×°ÖúÊÖ
ASM:×öΪoracleµ±Ç°Ö÷ÍƵÄÒ»ÖÖ´æ´¢ÌØÐÔ£¬ÆäÈ«³ÆÊÇ£ºAutomatic Storage Management¡£
OMF:Oracle Manage File µÄ¼òд£¬Ò»°ãÔÚ´´½¨Êý¾Ý¿â-Ö¸¶¨Êý¾ÝÎļþ·¾¶Ê±Äã»á¼ûµ½ËüµÄÉíÓ°¡£Ò»µ©ÄãÑ¡ÔñÁ˸ÃÖÖ·¾¶·½Ê½£¬ÔÚ´´½¨±í¿Õ¼ä£¬¿ØÖÆÎļþ£¬ÈÕÖ¾Îļþʱ¾Í²»ÐèÒªÖ¸¶¨Î»ÖúÍÎļþÃûÁË£¬Oracle»á¸ù¾ÝһЩ³õʼ»¯²ÎÊýµÄÉèÖÃ×Ô¶¯·ÖÅäºÍÃüÃû£¬Æäͨ³£ÓëASM´îÅäʹÓá£
OCR:Oracle Cluster RegistryÓÃÓÚ±£´æ¼¯ÈººÍÊý¾Ý¿âµÄÅäÖÃÐÅÏ¢£¬×öΪCRSµÄ¹Ø¼ü×é¼þ£¬£¬Òò´Ë£¬OCR±ØÐë±£´æÓÚ¹²Ïí´ÅÅÌ(µ«²»ÄÜÊÇASM£¬asm±Ï¾¹Ö»ÊÇÒ»¸öÈí¼þʵÏֵļ¯ÈºÎļþϵͳ£¬ÔÚ¶ÁÈ¡¼¯ÈºÐÅϢʱ£¬¿ÉÄÜÁ¬asmʵÀý¶¼»¹Ã»Æô¶¯ÄØ)£¬´ó¸ÅÐèÒª100M×óÓҵĿռ䡣ÓÃÓÚ½â¾ö½¡ÍüÎÊÌâ¡£
Voting Disk:ÓÃÓÚ±£´æ¼¯ÈºÖи÷½ÚµãÐÅÏ¢²¢È·±£¸÷½ÚµãµÄÒ»ÖÁÐÔ״̬£¬Í¬ÑùÒ²±ØÐë±£´æÓÚ¹²Ïí´ÅÅÌ(Ò²²»ÄÜÊÇasm)£¬´ó¸ÅÐèÒª20M×óÓҵĿռ䡣ÓÃÓÚ½â¾öÄÔÁÑÎÊÌâ¡£
VIP:¼´ÐéÄâIP£¬OracleÍƼö¿Í»§¶ËÁ¬½Óʱͨ¹ýÖ¸¶¨µÄÐéÄâIPÁ¬½Ó£¬ÕâÒ²ÊÇOracle10gÐÂÍƳöµÄÒ»¸öÌØÐÔ¡£Æä±¾ÖÊÄ¿µÄÊÇΪ


Ïà¹ØÎĵµ£º

Oracle ´´½¨³ÌÐò°ü


´Ó¸ÅÄʾÀý—Oracle´´½¨³ÌÐò°ü
Ò»¡¢³ÌÐò°üµÄÏà¹Ø֪ʶ
1.¶¨ÒåÓë˵Ã÷
  a. Ïà¹Ø¶ÔÏóµÄ·â×°
  b. ³ÌÐò°üµÄ¸÷²¿·Ö
    - ³ÌÐò°ü¹æ¸ñ˵Ã÷
          ÉùÃ÷×Ó³ÌÐò
   - ³ÌÐò°üÖ÷Ìå
        ......

Oracle Parameter

ÔÚʵ¼Ê¿ª·¢ÖУ¬¾­³£»áÐèÒª¶ÔÊý¾Ý¿â½øÐзÃÎÊ£¬×î³£¼ûµÄ¿ª·¢·½·¨¾ÍÀàËÆ£º
¡¡¡¡string sql = "select * from table1 where name = '" + name + "'";
¡¡¡¡ÕâÖÖ·½Ê½Óб»×¢Èë¹¥»÷µÄΣÏÕ
¡¡¡¡ËùÒÔ½â¾ö·½°¸ÓÐ2ÖÖ£º
¡¡¡¡1¡¢¸Ä³É£ºstring sql = "select * from table1 where name = '" + name.Replace("'","''") + "'"; // Ìæ»»Ò» ......

Oracle³õѧÕß±ØÖªµÄ100¸öÒÉÎÊ

1. Oracle°²×°Íê³ÉºóµÄԭʼ¿ÚÁ
¡¡internal/oracle
¡¡¡¡sys/change_on_install
¡¡¡¡system/manager
¡¡¡¡scott/tiger
¡¡¡¡sysman/oem_temp
2. ORACLE9IAS WEB CACHEµÄԭʼĬÈÏÓû§ºÍÃÜÂ룿
administrator/administrator
3. oracle 8.0.5ÈçºÎ½¨Á¢Êý¾Ý¿â£¿
ÓÃorainst¡£¼ÙÈçÓÐmotif½çÃ棬Äܹ»ÓÃorainst /m¡ ......

oracle¼ÓÃܺ¯Êý

http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14258/d_crypto.htm
oracle×Ô´øÎĵµÐ´µÄ±È½ÏÇå³þ
24

DBMS_CRYPTO
DBMS_CRYPTO
provides an interface to encrypt and
decrypt stored data, and can be used in conjunction with PL/SQL
programs running network communications. It provides suppo ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ