Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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ÐÂÍÆ³öµÄÒ»¸öÌØÐÔ¡£Æä±¾ÖÊÄ¿µÄÊÇΪ


Ïà¹ØÎĵµ£º

RedHatAs5ÏÂOracleË«»úÈȱ¸£¨1£©

    ×î½üÒ»¸öÏîÄ¿µÄʵʩÐèÒªÓõ½
RedHatAs5.0
²Ù×÷ϵͳϵÄ
Oracle
Ë«»úÈȱ¸ÅäÖã¬Ô­ÒÔΪÓÐÉ豸³§ÉÌÒÔ¼°¹«Ë¾ÏµÍ³ÍøÂ粿µÄ¼¼ÊõÖ§³Ö£¬Ë«»úÈȱ¸¾ÍÊÇСÒâ˼£¬Ã»Ï뵽ʵʩ¹ý³ÌÖÐÅöµ½ÁËÐí¶àÆæ¹ÖµÄÎÊÌâ¡£¾­¹ý¶àÌìµÄ¹¥¹Ø£¬ÖÕÓÚÅäÖóɹ¦ÁË£¬¸Ð¾õÐÄÇéÌØ±ðÇáËÉ¡£¾­¹ýÁ½ÖܵÄʵʩ£¬ÎÒÒÔÒ»¸ö
Linux
²ËÄñµÄÉí·Ý£¬³õ²½Á ......

groovy oracle date

There are lots of problems with Oracle DATE & TIMESTAMP and their
          counterpart Java classes since they do not directly compare. DATE fields
          in Oracle will give date & time where a ......

Oracleѧϰ±Ê¼Ç

ȨÏÞ¹ÜÀí
Oracle 9i
3¸öĬÈÏÓû§
sys(³¬¼¶¹ÜÀíÔ±)       ĬÈÏÃÜÂ룺change_on_install
system£¨ÆÕͨ¹ÜÀíÔ±£©
ĬÈÏÃÜÂ룺manager
scott£¨ÆÕͨÓû§£©       ĬÈÏÃÜÂ룺tiger
Oracle 10g
sys£¨ÃÜÂëÔÚ°²×°Ê±ÉèÖã©
system£¨ÃÜÂëÔÚ°²×°Ê±ÉèÖã©
scott(ĬÈÏËø¶¨£¬ÏëÓõýâËø)
Æô¶¯Windo ......

½â¶ÁOracleÖ®Ò»£º°²×°Oracle

°²×°¸ÅÊö
±¾Æª½éÉÜÈçºÎ°²×°OracleÈí¼þ£¬Òª°²×°OracleÈí¼þÍÆ¼öʹÓÃOracleͨÓð²×°¡£OracleͨÓð²×°³ÌÐòÊÇÒ»¸öͼÐÎÓû§½çÃæ£¨GUI£©¹¤¾ß£¬Ê¹Äú¿ÉÒԲ鿴OracleÈí¼þÒÑÔÚ¼ÆËã»úÉϰ²×°»ò°²×°ÐµÄOracleÈí¼þ£¬²¢Ð¶ÔØOracleÈí¼þ£¬ÒÔϽ«Ð­ÖúÄúÍê³É°²×°¹ý³Ì¡£
¼ì²éÏȾöÌõ¼þ
°²×°³ÌÐò֮ǰ£¬Oracle¹«Ë¾Ö´ÐÐÒ»¸öÏȾöÌõ¼þ¼ì²éµÄ×Ô¶¯±àº ......

Oracle±£Áô×Ö

²»¿ÉÒÔÓñ£Áô×Ö×öΪ±íÃû£¬×Ö¶ÎÃûµÄ¡£
Èç¹ûÓõ¥¸öÓ¢Óïµ¥´Ê»ò´Ê×éÀ´±íʾ±íÃû»ò×Ö¶ÎÃû¡£Õâ±È½ÏÈÝÒ׺ͱ£Áô×Ö³åÍ»¡£ÈçºÎÖªµÀOracleÓÃÁËÄÄЩ±£Áô×ÖÄØ£¿
ϵͳ±ív$reserved_wordsÖдæ·ÅÁËËùÓеı£Áô×Ö¡£
select * from v$reserved_words;
 OracleÓÐ500¸ö±£Áô×Ö£¬¼ÇסËùÓеı£Áô×ÖÓеãÀ§ÄÑ£¬Ã¿´Î¶¼²éÕÒ»áÓ°Ïìµ½¿ª·¢ËÙ¶È£¬Èç ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ