Oracle RACÈëÃÅ
=================================================================================
Oracle RAC ²úÆ·¸ÅÊö
Oracle Real Application Server£¬ÕæÕýÓ¦Óü¯Èº£¬¼ò³ÆOracle RAC £¬ÊÇOracleµÄ²¢Ðм¯Èº£¬Î»ÓÚ²»Í¬·þÎñÆ÷ϵͳµÄOracleʵÀýͬʱ·ÃÎÊͬһ¸öOracleÊý¾Ý¿â£¬½ÚµãÖ®¼äͨ¹ý˽ÓÐÍøÂç½øÐÐͨÐÅ£¬ËùÓеĿØÖÆÎļþ¡¢Áª»úÈÕÖ¾ºÍÊý¾ÝÎļþ´æ·ÅÔÚ¹²ÏíµÄÉ豸ÉÏ£¬Äܹ»±»¼¯ÈºÖеÄËùÓнڵãͬʱ¶Áд¡£Æäϵͳ¼Ü¹¹ÈçÏÂͼ£º
RACÌṩµÄºÃ´¦°üÀ¨£º
(1)¶à½Úµã¸ºÔؾùºâ;
(2)Ìṩ¸ß¿ÉÓ㺹ÊÕÏÈÝ´íºÍÎÞ·ìÇл»¹¦ÄÜ£¬½«Ó²¼þºÍÈí¼þ´íÎóÔì³ÉµÄÓ°Ïì×îС»¯£¬Ï±íÊÇRACÓ봫ͳµÄË«»úÈȱ¸·½Ê½Çл»Ê±¼äµÄ¶Ô±È£º
(3)ͨ¹ý²¢ÐÐÖ´Ðм¼ÊõÌá¸ßÊÂÎñÏìӦʱ¼ä----ͨ³£ÓÃÓÚÊý¾Ý·ÖÎöϵͳ;
(4)ͨ¹ýºáÏòÀ©Õ¹Ìá¸ßÿÃë½»Ò×ÊýºÍÁ¬½ÓÊý ;----ͨ³£¶ÔÓÚÁª»úÊÂÎñϵͳ;
(5)½ÚÔ¼Ó²¼þ³É±¾£¬¿ÉÒÔÓöà¸öÁ®¼ÛPC·þÎñÆ÷´úÌæ°º¹óµÄСÐÍ»ú»ò´óÐÍ»ú£¬Í¬Ê±½ÚÔ¼ÏàӦά»¤³É±¾;
(6)¿ÉÀ©Õ¹ÐԺ㬿ÉÒÔ·½±ãÌí¼Óɾ³ý½Úµã£¬À©Õ¹Ó²¼þ×ÊÔ´;
RACµÄȱµãÓУº
Ïà¶Ôµ¥»ú£¬¹ÜÀí¸ü¸´ÔÓ£¬ÒªÇó¸ü¸ß;
ÔÚϵͳ¹æ»®Éè¼Æ½Ï²îʱÐÔÄÜÉõÖÁ²»Èçµ¥½Úµã;
¿ÉÄÜ»áÔö¼ÓÈí¼þ³É±¾(Èç¹ûʹÓøßÅäÖõÄpc·þÎñÆ÷£¬OracleÒ»°ã°´ÕÕCPU¸öÊýÊÕ·Ñ)
ÔÚOracle9i֮ǰ£¬RACµÄÃû³ÆÊÇOPS (Oracle parallel Server)¡£RAC Óë OPS Ö®¼äµÄÒ»¸ö½Ï´óÇø±ðÊÇ£¬RAC²ÉÓÃÁËCache Fusion(¸ßËÙ»º´æºÏ²¢)¼¼Êõ¡£ÔÚ OPS ÖУ¬½Úµã¼äµÄÊý¾ÝÇëÇóÐèÒªÏȽ«Êý¾ÝдÈë´ÅÅÌ£¬È»ºó·¢³öÇëÇóµÄ½Úµã²Å¿ÉÒÔ¶ÁÈ¡¸ÃÊý¾Ý¡£Ê¹ÓÃCache fusionʱ£¬RACµÄ¸÷¸ö½ÚµãµÄÊý¾Ý»º³åÇøͨ¹ý¸ßËÙ¡¢µÍÑÓ³ÙµÄÄÚ²¿ÍøÂç½øÐÐÊý¾Ý¿éµÄ´«Êä¡£
Oracle RAC/ClusterwareµÄ½á¹¹ºÍ×é¼þ
Ò»¡¢RACÖ÷Òª×é¼þ, ÈíÓ²¼þÁ½²¿·Ö
(1) ·þÎñÆ÷ >= 2
(2) ²Ù×÷ϵͳ£¬ÍƼöʹÓÃOracleÈÏÖ¤µÄϵͳ;°æ±¾²»ÒªÌ«ÀÏ£¬Ò²²»ÒªÌ«ÐÂ
(3) CPU/ÄÚ´æ ¸ù¾ÝÒµÎñÐèÒª£¬ÄÚ´æÖÁÉÙ1G
(4) ±¾µØ´ÅÅ̿ռ䣬>=30G
(5) Íø¿¨ >=2 £¬ÍƼö4¸öÒÔÉÏǧÕ×Íø¿¨
(6) ˽ÓÐÒÔÌ«ÍøÂ磬ÍƼöǧÕ×½»»»»úÒÔÉÏ
(7) HBA¿¨ £¬Èç¹ûÊÇSAN£¬ÍƼö2¸öÈßÓàHBA
(8) ¹²Ïí´æ´¢É豸£¬ÍƼöSANÉ豸
(9) ´æ´¢¹ÜÀí£¬ ASM/Cluster LV/Âã·ÖÇø/CFS£¬²»ÍƼöÓÃOCFS£¬¾í¹ÜÀíÈí¼þ¡¢¶à·¾¶Èí¼þµÈ
(10) µÚÈý·½¼¯ÈºÈí¼þ: ¿ÉÑ¡
(11) Oracle Clusterware Èí¼þ
(12) Oracle RDBMS Èí¼þ
¶þ¡¢ClusterwareÖ÷Òª½ø³Ì
(1)crsd£º ¸ºÔð¹ÜÀí¼¯ÈºµÄ¸ß¿ÉÓòÙ×÷¡£¹ÜÀíµÄcrs×ÊÔ´°üÀ¨Êý¾Ý¿â¡¢ÊµÀý¡¢¼àÌý¡¢ÐéÄâIP£¬ons£¬gds»òÕßÆäËû£¬²Ù×÷°üÀ¨Æô¶¯¡¢¹Ø±Õ¡¢¼à¿Ø¼°¹ÊÕÏÇл»¡£¸Ä½ø³ÌÓÉrootÓÃ
Ïà¹ØÎĵµ£º
Êý¾Ý¿â´¥·¢Æ÷
´¥·¢Æ÷Óï¾ä
Öƶ¨´¥·¢Æ÷¶¨Ê±¡¢Ê¼þ¡¢±íÃû¼°ÀàÐÍ
´¥·¢Æ÷Ö÷Ìå
ÊÇpl/sql¿ì»ò¶Ô¹ý³ÌµÄµ÷ÓÃ
´¥·¢Æ÷ÏÞÖÆ
¿ÉÒÔͨ¹ýwhen×Ó¾äʵÏÖ
DML(insert update delete)
DDL(create alter drop)
Êý¾Ý¿â²Ù×÷(servererror logo ......
Êý¾ÝownerºÍÊý¾Ý²Ù×÷ÕßÒÔ¼°´úÂë·ÃÎÊʹÓò»Í¬µÄÓû§·ÃÎÊ£¬Ê¹ÓÃÊÚȨµÄ·½Ê½½øÐзÃÎÊ¡£
Êý¾Ý±í´´½¨Ê±Ê¹ÓÃͬÒå´Ê´´½¨
ÊÚȨʱ×îºÃ²»ÒªÊ¹ÓÃwith grant option
ÒÔÇ°²»Ì«Ã÷°×ͬÒå´ÊµÄʹÓã¬ÏÖÔÚÖªµÀÁË¡£±È½ÏºÃµÄÓ¦ÓþÍÊÇ´´½¨±íµÄ±ðÃû
create public ͬÒå´Ê tableName for owner.tableName
¸øÊÓͼÊÚȨ¿ÉÒÔʹµÃÓû§·ÃÎʲ»¾ß ......
1)µ¼ÈëoracleÊý¾Ý¿âÎļþ.dmpʱ³öÏÖ´íÎó
imp PERSONNEL_MANAGE/MWQ@MIS file=C:\personnel_manage.dmp fromuser=PERSONNEL_MANAGE ignore=y commit=y grants=y;
IMP-00058: Óöµ½ ORACLE ´íÎó 1017
ORA-01017: invalid username/password; logon denied̞:
¿ÚÁî:
IMP-00058: Óöµ½ ORACLE ´íÎó 1017
ORA-01017: in ......
²©ÑåÅàѵ²¿ÊÇÄ¿Ç°¹úÄÚΨһµÄ Oracle ¹Ù·½ÊÚȨ ERP ÈÏÖ¤Åàѵ»ú¹¹
Ä¿Ç°£¬Oracle Ó¦ÓÃϵͳÔÚÈ«Çò¿ç¹ú¹«Ë¾µÃµ½¹ã·ºÓ¦Óã¬ÖîÈçÖйúÒƶ¯¡¢ÉîÛÚ»ªÎª¡¢»ôÄáΤ¶û¡¢¿µÃ÷˹Öйú¡¢ÃÀ¹úÂÁÒµ¡¢DHL ºÍ±¦ÐÅÈí¼þµÈÖªÃû¹«Ë¾¡£Îª´Ë£¬Oracle ×Éѯ¹ËÎÊÊÇÈ«ÇòºÍÖйúÊг¡ÉÏ×î½ôȱµÄÈ˲ÅÖ®Ò»¡£Í¨¹ýOracle ÉÌÎñÌ×¼þÈÏÖ¤µÄ×Éѯ¹ËÎ ......