基于Vmware部署Oracle数据库最佳实践指南
合集下载
相关主题
- 1、下载文档前请自行甄别文档内容的完整性，平台不提供额外的编辑、内容补充、找答案等附加服务。
- 2、"仅部分预览"的文档,不可在线预览部分如存在完整性等问题,可反馈申请退款(可完整预览的文档不适用该条件!)。
- 3、如文档侵犯您的权益，请联系客服反馈,我们会尽快为您处理(人工客服工作时间：9:00-18:30)。
6. ᠓络连ࢦ导ݪ则 ............................................................................21 7. vSphere ੑೳ监߇ ............................................................................22 8. ڏ拟ص计时 .......................................................................................24 9. 汇总..................................................................................................25 10. ࢀߟ资ྉ ......................................................................................25 ෟ录 A. ڏ拟صଘ设ஔ ..........................................................................27
4.1 Ұൠݪ则 ........................................................................................................................6 4.2 ଘ .............................................................................................................................10 4.3 ڏ拟 CPU.....................................................................................................................12
෦ॺຊɻ • Մཧੑ – ௨过༻ VMware vMotion™ɼڏ拟صՄࡏ务ث೭间དྷճҠ动ࣕᏠधఀصɼ这ՄҎ简Խߗ
݅维护ৗੑૢ࡞ኂ减গ计划ఀص时间ɻ • Մ༻ੑ – Ռग़现计划֎ߗ݅ނোɼVMware High Availability (HA) কࡏ VMware ू܈தత另Ұओص
VMware, Inc 3401 Hillview Ave Palo Alto, CA 94304 www.vmware.com ژ办ެࣨ ࢢژւཎ۠ՊֶӃೆ࿏ 2 ߸༥Պ资讯த৺ C ࠲ 8 层 邮编ɿ100190 电话ɿ +86-400-816-0688 / +86-800-915-1919 ҃ +86-10-5993-4200 ্ւ办ެࣨ ্ւࢢঃ汇۠ᕋւத࿏ 1010 ߸Յ华த৺ 27 ࿖ 2720-2721 ࣨ 邮编ɿ200031 电话ɿ+86-21-6103-1234 ኅभ办ެࣨ ኅभࢢఱՏ࿏ 233 ߸த৴ኅ场 7401 ࣨ 邮编ɿ510613 电话ɿ+86-20-3877-1938
ڏ拟ج础Ս构运ߦత Oracle 产ఏग़తࢧ࣋请ٻɻ这ॏཁʂՌ您运ߦ 9iɺ10g ҃ଖଞ产ቮ经༗ 长时间ྃɼ您త运ᔂձɼҼ为ࡏࠑႎԼ Oracle ࡏ೭લबቮ经发现ྃ您త问题ɻՌଞ们ቮ۰ ౸过ࠑ问题ɼଞ们बձड针对ሏతࢧ࣋请ٻɻ • ৽问题 – Oracle ࢧ࣋෦门อཹཁٻ٬户ఏڙ证໌该l৽问题z归Ҽဋ Oracle ࣕෆੋ应༻ఔংඃڏ拟Խత 结Ռత权རɻฏ৺ࣕ论ɼଖଞ ISV ձ༗૬ಉతࡦɼੋఔෆಉࣕቮɻ关键ੋ Oracle ࢧ࣋෦ 门Ҏԟ对l৽问题zੋԿ处ཧతɻ • 认证 – VMware vSphere ੋҰ项ࡏ经认证త Oracle 产ମܥ೭Լ༻తٕ术ʢෆಉဋଖଞձվ变ૢ࡞ܥ 统ࠑٴ产ମܥதతଖଞݩૉతڏ拟Խٕ术ʣɻҼࠑɼOracle Ꮰ๏认证 VMware ڏ拟ج础Ս构ɻෆ过ब ࠑࣕݴɼVMware ༩ x86 务ثෆଘࡏࠩ别 – Oracle ༗认证 DellɺHPɺIBM Sun x86 务ثɻ VMware ݐ议٬户ࡃऔ߹ཧతํ๏ɼኂ测试 Oracle తࢧ࣋໌ɻဓੜ产લܥ统开࢝ɼࡏ۰౸问题ኂఏަࢧ ࣋报ࠂɼ᪑᪨ Oracle త响应ɻࡏզ们དྷɼOracle ࢧ࣋෦门对֤种ࣄ务త响应Ꮰ论ࡏ质ྔ还ੋٴ时ੑ্ ༗ࠩ别ɻ
© 2010 VMware, Inc. อཹॴ༗权རɻ ୈ 2 页ɼ ڞ27 页
جဋ VMware ෦ॺ Oracle ਾ库 ࠷Ղ实ફࢦೆ
录
1. 简հ....................................................................................................4 2. VMware vSphere ...............................................................................4 3. 对جဋ vSphere ෦ॺత Oracle ਾ库తੜ产ࢧ࣋ ............................5 4. ESX ओࢦص导ݪ则 .............................................................................6
جဋ VMware ෦ॺ Oracle ਾ库 ࠷Ղ实ફࢦೆ
3. 对جဋ vSphere ෦ॺత Oracle ਾ库తੜ产ࢧ࣋
Oracle ༗Ұ份针对 VMware 产తࢧ࣋໌ɼࠑ໌ࡏશੈքᣂ围赢ಘྃ赞༪ɻਚਓ们बࣗॴݾ认 త Oracle 对 VMware ڏ拟Խతࢧ࣋࢟态开లྃେྔతެ开讨论ɼୠबզ们དྷɼOracle ࢧ࣋෦门࢝终 ৴कࣗݾ对٬户తঝ诺ɼแׅಹࠣক VMware ڏ拟Խٕ术༩ Oracle 产结߹ࡏҰ༻ىత٬户ɻ VMware ੋ Oracle తҰ٬户ʀզ们త E-Business Suite Siebel 实ྫቮڏ拟Խʀࣕ对ဋجဋ VMware ڏ拟ج础Ս构运ߦత Oracle ॴ发ੜత问题ɼVMware Ұࡏরৗఏަࢧ࣋请ٻኂ获ಘ帮ॿɻ MyOracleSupport Metalink จᑆ ID #249212.1 தఏ ྃڙOracle 对 VMware తࢧ࣋ঝ诺త۩ମ༰ɻ GartnerɺIDC ଖଞެ࢘为ଞ们త订购༻户ఏྃڙ专门针对该ࡦతจᑆɻਚࠑࡏࢭې处复ड़ࠑจᑆ త༰ɼୠҎԼ֓ཁհ绍ྃ༗关 Oracle ࢧ࣋෦门తҰࠣॏཁࣄ实ɿ • ቮ为 11.2.0.2 ߋߴ൛ຊఏ ྃڙOracle RAC ࢧ࣋ɻ • ቮ问题 – Ռॴ报ࠂత问题ੋ Oracle ቮత问题ɼOracle ࢧ࣋෦门কड٬户针对جဋ VMware
5. ଘ储ࢦ导ݪ则 ..............................ห้องสมุดไป่ตู้....................................................14
5.1 ଘ储ڏ拟Խ֓೦ ...........................................................................................................16 5.2 ଘ储协议ޭೳ ...............................................................................................................16 5.3 ਾ库ہҙࣄ项 ....................................................................................................17 5.4 VMFS ༩ RDM త对ൺ .................................................................................................19 5.5 Ұൠݪ则 ......................................................................................................................20
2. VMware vSphere
VMware ڏ拟ԽղႊํҊ为 DBA ཧ员ఏྃڙଟ处ɻVMware ڏ拟Խࡏ应༻ఔংૢ࡞ܥ统ॴधత资 ݯҎٴఏڙ这ࠣ资ݯతఈ层ߗ݅೭间创ྃݐҰந层ɻ该ந层ՄఏڙҎԼလ值ɿ • ߹ – VMware ٕ术Ҹ许কଟ应༻务ث߹౸Ұཧ务ثதɼࣕ对ମੑೳ႓ݷ༗Ө响ɻ • ศဋ调 – VMware ڏ拟ԽՄক应༻ఔং෧Մඃ复੍҃Ҡ动తө૾ɼဓࣕେ෯߱应༻ఔংత调
্ॏ启डӨ响తڏ拟صɻ௨过 HAɼ您ՄҎ减গ计划֎ఀص时间ɼኂ为应༻ఔংఏߴߋڙత务级别ɻ VMware Fault Tolerance (FT) ۩༗ྵఀصྵਾ丢ࣦతಛੑɼՄࡏ发ੜ务ނ݅ߗثো时ɼ为ڏ拟 صத运ߦతԿ应༻ఔংఏ࣋ڙ续Մ༻ੑɻ
© 2010 VMware, Inc. อཹॴ༗权རɻ ୈ 4 页ɼ ڞ27 页
Oracle Databases on VMware: Best Practices Guide
جဋ VMware ෦ॺ Oracle ਾ库 ࠷Ղ实ફࢦೆ
جဋ VMware ෦ॺ Oracle ਾ库 ࠷Ղ实ફࢦೆ
൛权ॴ༗ © 2010 VMware, Inc. อཹॴ༗权རɻࠑ产डඒࠃࠃ际൛权ٴ识产权๏อ护ɻࠑ产拥༗ҎԼ᠓ ᅿதྻग़తҰ项҃ଟ项专རɿhttp://www.vmware.com/cn/download/patents.htmlɻ VMware ੋ VMware, Inc. ࡏඒࠃ/҃ଖଞ๏辖۠తၽ标҃标ɻࠑ处ఏ౸తॴ༗ଖଞ标ࢤ໊শ别ੋ ଖ֤ࣗެ࢘త标ɻ
© 2010 VMware, Inc. อཹॴ༗权རɻ ୈ 3 页ɼ ڞ27 页
جဋ VMware ෦ॺ Oracle ਾ库 ࠷Ղ实ફࢦೆ
1. 简հ
这ຊʬجဋ VMware ෦ॺ Oracle ਾ库࠷Ղ实ફࢦೆʭఏجྃڙဋ VMware vSphere ෦ॺ Oracle ਾ库 త࠷Ղ实ફࢦೆɻຊࢦೆதతݐ议ෆݶဋԿಛఆతߗ݅҃Կ规ᣂ围తಛఆ Oracle ਾ库实ࢪɻ ຊࢦೆதతࣔྫҙࣄ项ఏڙతੋࢦ导ੑݐ议ɼࣕෆද严֨త设计ཁٻɻ جဋ VMware vSphere™ ޭ෦ॺ Oracle ༩ࡏཧ务্ث෦ॺ Oracle ༗显ஶ۠别ɻਾ库ཧ员Մ ࡏॆར༻ଞ们લٕ术组߹తಉ时ɼ实现ڏ拟Խ带དྷతॴ༗优势ɻ আຊࢦೆҎ֎ɼVMware 还为ଘ储ɺ᠓络连ੑೳ别创࠷ྃݐՂ实ફจᑆɻզ们还ఏྃڙʬجဋ VMware vSphere ෦ॺ Oracle ਾ库తجຊٕʭനൽ书ɼ૬关৴ଉቮ经แࡏؚຊʬ࠷Ղ实ફࢦೆʭதɻ༗ 关Մ帮ॿ您جဋ VMware vSphere ޭ෦ॺ Oracle తଖଞจᑆྻදɼ请ࢀ见lࢀߟ资ྉz෦ʢୈ 10 节ʣɻ
4.1 Ұൠݪ则 ........................................................................................................................6 4.2 ଘ .............................................................................................................................10 4.3 ڏ拟 CPU.....................................................................................................................12
෦ॺຊɻ • Մཧੑ – ௨过༻ VMware vMotion™ɼڏ拟صՄࡏ务ث೭间དྷճҠ动ࣕᏠधఀصɼ这ՄҎ简Խߗ
݅维护ৗੑૢ࡞ኂ减গ计划ఀص时间ɻ • Մ༻ੑ – Ռग़现计划֎ߗ݅ނোɼVMware High Availability (HA) কࡏ VMware ू܈தత另Ұओص
VMware, Inc 3401 Hillview Ave Palo Alto, CA 94304 www.vmware.com ژ办ެࣨ ࢢژւཎ۠ՊֶӃೆ࿏ 2 ߸༥Պ资讯த৺ C ࠲ 8 层 邮编ɿ100190 电话ɿ +86-400-816-0688 / +86-800-915-1919 ҃ +86-10-5993-4200 ্ւ办ެࣨ ্ւࢢঃ汇۠ᕋւத࿏ 1010 ߸Յ华த৺ 27 ࿖ 2720-2721 ࣨ 邮编ɿ200031 电话ɿ+86-21-6103-1234 ኅभ办ެࣨ ኅभࢢఱՏ࿏ 233 ߸த৴ኅ场 7401 ࣨ 邮编ɿ510613 电话ɿ+86-20-3877-1938
ڏ拟ج础Ս构运ߦత Oracle 产ఏग़తࢧ࣋请ٻɻ这ॏཁʂՌ您运ߦ 9iɺ10g ҃ଖଞ产ቮ经༗ 长时间ྃɼ您త运ᔂձɼҼ为ࡏࠑႎԼ Oracle ࡏ೭લबቮ经发现ྃ您త问题ɻՌଞ们ቮ۰ ౸过ࠑ问题ɼଞ们बձड针对ሏతࢧ࣋请ٻɻ • ৽问题 – Oracle ࢧ࣋෦门อཹཁٻ٬户ఏڙ证໌该l৽问题z归Ҽဋ Oracle ࣕෆੋ应༻ఔংඃڏ拟Խత 结Ռత权རɻฏ৺ࣕ论ɼଖଞ ISV ձ༗૬ಉతࡦɼੋఔෆಉࣕቮɻ关键ੋ Oracle ࢧ࣋෦ 门Ҏԟ对l৽问题zੋԿ处ཧతɻ • 认证 – VMware vSphere ੋҰ项ࡏ经认证త Oracle 产ମܥ೭Լ༻తٕ术ʢෆಉဋଖଞձվ变ૢ࡞ܥ 统ࠑٴ产ମܥதతଖଞݩૉతڏ拟Խٕ术ʣɻҼࠑɼOracle Ꮰ๏认证 VMware ڏ拟ج础Ս构ɻෆ过ब ࠑࣕݴɼVMware ༩ x86 务ثෆଘࡏࠩ别 – Oracle ༗认证 DellɺHPɺIBM Sun x86 务ثɻ VMware ݐ议٬户ࡃऔ߹ཧతํ๏ɼኂ测试 Oracle తࢧ࣋໌ɻဓੜ产લܥ统开࢝ɼࡏ۰౸问题ኂఏަࢧ ࣋报ࠂɼ᪑᪨ Oracle త响应ɻࡏզ们དྷɼOracle ࢧ࣋෦门对֤种ࣄ务త响应Ꮰ论ࡏ质ྔ还ੋٴ时ੑ্ ༗ࠩ别ɻ
© 2010 VMware, Inc. อཹॴ༗权རɻ ୈ 2 页ɼ ڞ27 页
جဋ VMware ෦ॺ Oracle ਾ库 ࠷Ղ实ફࢦೆ
录
1. 简հ....................................................................................................4 2. VMware vSphere ...............................................................................4 3. 对جဋ vSphere ෦ॺత Oracle ਾ库తੜ产ࢧ࣋ ............................5 4. ESX ओࢦص导ݪ则 .............................................................................6
جဋ VMware ෦ॺ Oracle ਾ库 ࠷Ղ实ફࢦೆ
3. 对جဋ vSphere ෦ॺత Oracle ਾ库తੜ产ࢧ࣋
Oracle ༗Ұ份针对 VMware 产తࢧ࣋໌ɼࠑ໌ࡏશੈքᣂ围赢ಘྃ赞༪ɻਚਓ们बࣗॴݾ认 త Oracle 对 VMware ڏ拟Խతࢧ࣋࢟态开లྃେྔతެ开讨论ɼୠबզ们དྷɼOracle ࢧ࣋෦门࢝终 ৴कࣗݾ对٬户తঝ诺ɼแׅಹࠣক VMware ڏ拟Խٕ术༩ Oracle 产结߹ࡏҰ༻ىత٬户ɻ VMware ੋ Oracle తҰ٬户ʀզ们త E-Business Suite Siebel 实ྫቮڏ拟Խʀࣕ对ဋجဋ VMware ڏ拟ج础Ս构运ߦత Oracle ॴ发ੜత问题ɼVMware Ұࡏরৗఏަࢧ࣋请ٻኂ获ಘ帮ॿɻ MyOracleSupport Metalink จᑆ ID #249212.1 தఏ ྃڙOracle 对 VMware తࢧ࣋ঝ诺త۩ମ༰ɻ GartnerɺIDC ଖଞެ࢘为ଞ们త订购༻户ఏྃڙ专门针对该ࡦతจᑆɻਚࠑࡏࢭې处复ड़ࠑจᑆ త༰ɼୠҎԼ֓ཁհ绍ྃ༗关 Oracle ࢧ࣋෦门తҰࠣॏཁࣄ实ɿ • ቮ为 11.2.0.2 ߋߴ൛ຊఏ ྃڙOracle RAC ࢧ࣋ɻ • ቮ问题 – Ռॴ报ࠂత问题ੋ Oracle ቮత问题ɼOracle ࢧ࣋෦门কड٬户针对جဋ VMware
5. ଘ储ࢦ导ݪ则 ..............................ห้องสมุดไป่ตู้....................................................14
5.1 ଘ储ڏ拟Խ֓೦ ...........................................................................................................16 5.2 ଘ储协议ޭೳ ...............................................................................................................16 5.3 ਾ库ہҙࣄ项 ....................................................................................................17 5.4 VMFS ༩ RDM త对ൺ .................................................................................................19 5.5 Ұൠݪ则 ......................................................................................................................20
2. VMware vSphere
VMware ڏ拟ԽղႊํҊ为 DBA ཧ员ఏྃڙଟ处ɻVMware ڏ拟Խࡏ应༻ఔংૢ࡞ܥ统ॴधత资 ݯҎٴఏڙ这ࠣ资ݯతఈ层ߗ݅೭间创ྃݐҰந层ɻ该ந层ՄఏڙҎԼလ值ɿ • ߹ – VMware ٕ术Ҹ许কଟ应༻务ث߹౸Ұཧ务ثதɼࣕ对ମੑೳ႓ݷ༗Ө响ɻ • ศဋ调 – VMware ڏ拟ԽՄক应༻ఔং෧Մඃ复੍҃Ҡ动తө૾ɼဓࣕେ෯߱应༻ఔংత调
্ॏ启डӨ响తڏ拟صɻ௨过 HAɼ您ՄҎ减গ计划֎ఀص时间ɼኂ为应༻ఔংఏߴߋڙత务级别ɻ VMware Fault Tolerance (FT) ۩༗ྵఀصྵਾ丢ࣦతಛੑɼՄࡏ发ੜ务ނ݅ߗثো时ɼ为ڏ拟 صத运ߦతԿ应༻ఔংఏ࣋ڙ续Մ༻ੑɻ
© 2010 VMware, Inc. อཹॴ༗权རɻ ୈ 4 页ɼ ڞ27 页
Oracle Databases on VMware: Best Practices Guide
جဋ VMware ෦ॺ Oracle ਾ库 ࠷Ղ实ફࢦೆ
جဋ VMware ෦ॺ Oracle ਾ库 ࠷Ղ实ફࢦೆ
൛权ॴ༗ © 2010 VMware, Inc. อཹॴ༗权རɻࠑ产डඒࠃࠃ际൛权ٴ识产权๏อ护ɻࠑ产拥༗ҎԼ᠓ ᅿதྻग़తҰ项҃ଟ项专རɿhttp://www.vmware.com/cn/download/patents.htmlɻ VMware ੋ VMware, Inc. ࡏඒࠃ/҃ଖଞ๏辖۠తၽ标҃标ɻࠑ处ఏ౸తॴ༗ଖଞ标ࢤ໊শ别ੋ ଖ֤ࣗެ࢘త标ɻ
© 2010 VMware, Inc. อཹॴ༗权རɻ ୈ 3 页ɼ ڞ27 页
جဋ VMware ෦ॺ Oracle ਾ库 ࠷Ղ实ફࢦೆ
1. 简հ
这ຊʬجဋ VMware ෦ॺ Oracle ਾ库࠷Ղ实ફࢦೆʭఏجྃڙဋ VMware vSphere ෦ॺ Oracle ਾ库 త࠷Ղ实ફࢦೆɻຊࢦೆதతݐ议ෆݶဋԿಛఆతߗ݅҃Կ规ᣂ围తಛఆ Oracle ਾ库实ࢪɻ ຊࢦೆதతࣔྫҙࣄ项ఏڙతੋࢦ导ੑݐ议ɼࣕෆද严֨త设计ཁٻɻ جဋ VMware vSphere™ ޭ෦ॺ Oracle ༩ࡏཧ务্ث෦ॺ Oracle ༗显ஶ۠别ɻਾ库ཧ员Մ ࡏॆར༻ଞ们લٕ术组߹తಉ时ɼ实现ڏ拟Խ带དྷతॴ༗优势ɻ আຊࢦೆҎ֎ɼVMware 还为ଘ储ɺ᠓络连ੑೳ别创࠷ྃݐՂ实ફจᑆɻզ们还ఏྃڙʬجဋ VMware vSphere ෦ॺ Oracle ਾ库తجຊٕʭനൽ书ɼ૬关৴ଉቮ经แࡏؚຊʬ࠷Ղ实ફࢦೆʭதɻ༗ 关Մ帮ॿ您جဋ VMware vSphere ޭ෦ॺ Oracle తଖଞจᑆྻදɼ请ࢀ见lࢀߟ资ྉz෦ʢୈ 10 节ʣɻ