今から始めるOracleDatabase

2018/02/20 インフラ勉強会登壇資料

Transcript

1. ࠓ͔Β࢝ΊΔ
   0SBDMF
   %BUBCBTF JOΠϯϑϥษڧձ 1
2. ࣄނ঺հ w Ώ͍ͳʢˏZVJOB@Jʣ
   w Ѫ஌Ͱंࡌˠۀ຿ܥˠंࡌͷ։ൃͯ͠·͢
   w ڵຯͷ͋Δ͜ͱΛͭ·Έ৯͍ͯ͠ΔͷͰ໎૸த
   w 0SBDMF
   .BTUFS͸̐೥લ͔Β#SPO[Fࢭ·Γ
   w ॳ-5ͳͷͰੜஆ͔͍໨Ͱݟक͍ͬͯͩ͘͞ 2
3. 0SBDMF%BUB#BTF
   ஌ͬͯΔਓʂ 3
4. ͓஋ஈߴ͍%#ͬͯҎ֎
   ਖ਼௚Α͘Θ͔ΒΜɻ 4
5. ΞδΣϯμ w0SBDMF%BUB#BTFͱ͸ͳΜͧ΍ʁ
   wͲΜͳߏ଄ʹͳͬͯΜͷʁ
   wଞͷ3%#.4ͱԿ͕ҧ͏Μʁ 5
6. 0SBDMF
   %BUBCBTF
   ͱ͸ͳΜͧ΍ʁ 6
7. 0SBDMF
   %BUBCBTFͱ͸ w ΞϝϦΧͷ0SBDMF͕ࣾ։ൃɺൢച͍ͯ͠Δ
 ؔ܎σʔλϕʔε؅ཧγεςϜʢ3%#.4ʣɻ
   w ੈքॳͷ঎༻3%#.4Β͍͠ɻ஌ΒΜ͚Ͳɻ
   w ݱࡏͷ࠷৽όʔδϣϯ͸
   lD
   3FMFBTF
   
    z
   w Dͬͯͷ͕ൃද͞Ε͍ͯΔ͚ΕͲΫϥ΢υϕʔε͔ͩΒ
 Α͘Θ͔ΒΜɻ 7
8. 0SBDMF
   %BUBCBTFͱ͸ w ϥΠηϯεྉۚΫιߴ͍ɻ
 άάͬͨΒ࠷҆Ͱ ԁ 1FSTPOBM
   &EJUJPO
   w Ͱ΋ࢼ༻΍ֶश໨తͷݸਓར༻ͳΒ
 શ෦ೖΓͷ&OUFSQSJTF&EJUJPO΋ແྉͰ࢖͑Δɻ
   w ͱΓ͋͑ͣؾʹͳͬͨΒߏங͢Ε͹͍͍Μ͡Όͳ͍͔ͳɻ
 ʢͦͷ͏ͪ΍Δ͔΋͠Εͳ͍ʣ 8
9. ͲΜͳߏ଄ʹ
   ͳͬͯΔΜʁ 9
10. 0SBDMF%BUBCBTFͷத਎ͬͯ͜Μͳײ͡
    ʢ؆қ൛ʣ 10 Ç㲋 ετϨʔδ Ç㲋 ϝϞϦ αʔόʔ ϓϩηε Ϧεφʔ ϓϩηε 0SBDMF
    %#
    αʔόʔ σʔλϑΝΠϧ
    ʢςʔϒϧ٧ΊࠐΜͰΔͱ͜ʣ ϩάϑΝΠϧ ετϨʔδ͔Β
    Ωϟογϡͨ͠
    σʔλςʔϒϧ όοΫάϥ΢ϯυϓϩηε τϥϯβΫγϣϯ
    ͷϩά
11. ଞͷ3%#.4ͱ
    Կ͕ҧ͏Μʁ 11
12. 3%#.4ͱݴͬͨΒ
    ԿΛࢥ͍ු͔΂·͔͢ʁ 12
13. ଞͷ3%#.4ͱͷҧ͍ w 0SBDMF
    %BUBCBTF
    w 42-4FSWFS
    w 1PTUHSF42-
    w .Z42-ʢΈΜͳେ޷͖.BSJBͪΌΜ΋ಉ͔͡ͱʣ 13 ҎԼͷ%#Λൺֱͯ͠ΈΔɻ
14. ଞͷ3%#.4ͱͷҧ͍
    ʢτϥϯβΫγϣϯฤʣ w 0SBDMF
    %BUBCBTF
 ˠࣗಈίϛοτͯ͘͠Εͳ͍ʂ

    
    
    %.-࣮ߦޙʹ໌ࣔతʹίϛοτ͢ΔͨΊͷίϚϯυΛ

    
    
    ଧͨͳ͍ͱͩΊɻ
    w 42-4FSWFS
    w 1PTUHSF42-
    w .Z42-ʢΈΜͳେ޷͖.BSJBͪΌΜʣ
 ˠ̍ΫΤϦ࣮ߦ͝ͱʹࣗಈίϛοτͯ͘͠ΕΔʂ

    
    
    τϥϯβΫγϣϯͰಈ͔͍ͨ͠৔߹͸໌ࣔతʹ։࢝ɺίϛοτͷ

    
    
    ίϚϯυΛߦ͏ඞཁ͕͋Δɻ 14 VQEBUFଞ %.- Λ࣮ߦͨ͠ࡍͷτϥϯβΫγϣϯॲཧ
15. ଞͷ3%#.4ͱͷҧ͍
    ʢτϥϯβΫγϣϯฤʣ w 0SBDMF
    %BUBCBTF
    w 42-4FSWFS
 ˠ̍ΫΤϦ࣮ߦ͝ͱʹࣗಈίϛοτͯ͘͠ΕΔʂ

    
    
    τϥϯβΫγϣϯͰಈ͔͍ͨ͠৔߹͸໌ࣔతʹ։࢝ɺίϛοτͷ

    
    
    ίϚϯυΛߦ͏ඞཁ͕͋Δɻ
    w 1PTUHSF42-
 ˠࣗಈίϛοτͯ͘͠Εͳ͍ʂ

    
    
    %.-࣮ߦޙʹ໌ࣔతʹίϛοτ͢ΔͨΊͷίϚϯυΛଧͨͳ͍ͱͩΊɻ
    w .Z42-ʢΈΜͳେ޷͖.BSJBͪΌΜʣ
 ˠ̍ΫΤϦ࣮ߦ͝ͱʹࣗಈίϛοτͯ͘͠ΕΔʂ

    
    
    %.-࣮ߦޙʹ໌ࣔతʹίϛοτ͢ΔͨΊͷίϚϯυΛ

    
    
    ଧͨͳ͍ͱͩΊɻ%%-จ͸҉໧తίϛοτͯ͠͠·͏ͨΊɺτϥϯβΫγϣϯॲཧ͢Β

    
    
    ͤͯ͞΋Β͑ͳ͍ɾɾɾ 15 $SFBUF5BCMFଞ %%- Λ࣮ߦͨ͠ࡍͷτϥϯβΫγϣϯॲཧ
16. ଞͷ3%#.4ͱͷҧ͍
    ʢ42-ΫΤϦฤʣ w 0SBDMF
    %BUBCBTF
 ˠͦ΋ͦ΋ͦΜͳ͜ͱͰ͖ͳ͍ʂ8)&3&۟Ͱબ୒͢Δඞཁ͋Γɻ

    
    
    ྫɿʮ4&-&$5
    ˎ
    '30.
    &.1-0&&4
    8)&3&
    SPXOVN
    
    ʯ
    w 42-4FSWFS
 ˠ501۟Λ࢖͏ɻ

    
    
    ྫɿʮ4&-&$5
    501
    ˎ
    '30.
    &.1-0:&&4ʯ
    w 1PTUHSF42-
    w .Z42-ʢΈΜͳେ޷͖.BSJBͪΌΜʣ
 ˠ-*.*5۟Λ࢖͏ɻ

    
    
    ྫɿʮ4&-&$5
    ˎ
    '30.
    &.1-0:&&4
    -*.*5
    ʯ 16 ݕࡧ৚݅ࢦఆͷΫΤϦͷॻ͖ํ
17. ݁ہ0SBDMFͷ
    Կ͕͍͍ͷʁ 17
18. 0SBDMF%BUBCBTFͷར఺ w ̍Πϯελϯεʹ̍σʔλϕʔε͔͠࡞Εͳ͍ͨΊɺ
 ΠϯελϯεΛఀࢭͯ͠΋ଞͷ%#ʹӨڹ͕ग़ͳ͍ɻ
 ˠ%#Πϯελϯεͷো֐ʹڧ͍ɻ
    w ࣗಈͰτϥϯβΫγϣϯΛ։࢝ͯ͘͠ΕΔͨΊɺ
 %.- 6QEBUFจͳͲ Λϛεͯ͠΋ϩʔϧόοΫՄೳɻ
 ˠଞͷ3%#ͩͱɺτϥϯβΫγϣϯΛ։࢝͠๨ΕͨΒ

    
    
    ඞࢮʹΫΤϦॻ͔ͳ͍ͱ໭Βͳ͍ɻ
    w ಡΈऔΓҰ؏ੑ͕͋ΔͨΊɺόονॲཧ͕૸͍ͬͯΔ్தͰ΋ɺ
 ࢀর͢Δ͚ͩͳΒ໰୊ͳ͘࢖༻Մೳɻ
    w ॲཧঢ়گʹΑͬͯϝϞϦͷׂ౰Λಈతʹม͑ͯ͘ΕΔɻ
 18
19. ·ͱΊ 19
20. w 0SBDMF%#Ͱ༡Ϳ͚ͩͳΒλμ͔ͩΒͱΓ͋͑ͣ༡΅͏ɻ
    w ଞͷ3%#ΑΓ΋ো֐ʹڧ͍Αʂ
    w ݎ෺͚ͩͲσϨΔͱ͔Θ͍͍%# 20
21. ͓ΘΓ 21