Tweet
Tweet

Slide 1

Slide 1 text

ΦϯϓϨ to ΦϯϓϨͨ͠࿩ @blue_1617

Slide 2

Slide 2 text

ࢲ͸୭ʁ blue (@blue_1617) https://blue0513.github.io/show_room/ 2 ‣ ΨʔϦΟϨίʔυνϟϯωϧ ‣ ࠷ۙ΍ͬͯΔ͜ͱ / ϋϚ͍ͬͯΔ͜ͱ ‣ ϙέϞϯιʔυ&γʔϧυ ‣ Magic: The Gathering ‣ ࣍ʹ΍Γ͍ͨ͜ͱ ‣ Fall Guys

Slide 3

Slide 3 text

͜ͷൃද͸ʁ 3 ๭ࣾ๭ϓϩδΣΫτͷαʔόΛҠߦ͢Δ࿩ AWS GCP Terraform Cloud Azure Ansible Digdag MicroService ʢM3ͷάϧʔϓձࣾʣ

Slide 4

Slide 4 text

͜ͷൃද͸ʁ 4 ๭ࣾ๭ϓϩδΣΫτͷαʔόΛҠߦ͢Δ࿩ AWS GCP Terraform Cloud Azure Ansible Digdag MicroService ग़͖ͯ·ͤΜɻѱ͔͠Βͣ ʢM3ͷάϧʔϓձࣾʣ

Slide 5

Slide 5 text

͜ͷൃද͸ʁ 5 ๭ࣾ๭ϓϩδΣΫτͷαʔόΛҠߦ͢Δ࿩ ֎஫ઌ ΦϯϓϨ ֤छΞϓϦ ๭ࣾ ෺ཧ

Slide 6

Slide 6 text

͜ͷൃද͸ʁ 6 ๭ࣾ๭ϓϩδΣΫτͷαʔόΛҠߦ͢Δ࿩ ֎஫ઌ ΦϯϓϨ ΦϯϓϨ ๭ࣾ VM

Slide 7

Slide 7 text

7 ๭ࣾ๭ϓϩδΣΫτͷαʔόΛҠߦ͢Δ࿩ Batchॲཧαʔό ໊دͤॲཧαʔό Database ΞϓϦέʔγϣϯ Windows αʔό Oracle SE 11g Windows Forms .bat .exe = = = JP1 αʔό ͜ͷൃද͸ʁ

Slide 8

Slide 8 text

8 ๭ࣾ๭ϓϩδΣΫτͷαʔόΛҠߦ͢Δ࿩ ͜ͷൃද͸ʁ ֎஫ઌ ΦϯϓϨ ϓϩδΣΫτ։࢝: 4݄ Ϧϛοτ: 9݄ॳ० ओཁϝϯόʔ: 4ਓ Ϛωʔδϟ * 1 Πϯϑϥ * 1 ΞϓϦ * 2 Ҡߦͷརӹ: Nઍສԁ/೥

Slide 9

Slide 9 text

9 ͬ͘͟ΓΠϯϑϥߏ੒ਤ ຊ൪ ݕূ Batch ໊دͤ JP1 ڞ༗σΟϨΫτϦA ڞ༗σΟϨΫτϦB Batch ໊دͤ JP1 ΦϑΟε

Slide 10

Slide 10 text

10 ͬ͘͟ΓΠϯϑϥߏ੒ਤ ຊ൪ ݕূ Batch ໊دͤ JP1 ڞ༗σΟϨΫτϦA ڞ༗σΟϨΫτϦB Batch ໊دͤ JP1 ΦϑΟε

Slide 11

Slide 11 text

11 ͬ͘͟ΓΠϯϑϥߏ੒ਤ ຊ൪ ݕূ Batch ໊دͤ JP1 ڞ༗σΟϨΫτϦA Batch/DB ໊دͤ ΦϑΟε

Slide 12

Slide 12 text

࡞ઓ

Slide 13

Slide 13 text

13 ࡞ઓ 1. Զ͸ɺݕূ؀ڥΛɺࣺͯΔ 2. ωοτϫʔΫɺݽཱɺःஅͯ͠ 3. ͑ʂʁ /etc/hosts Λ͍ͬͯ͡ʂʁ 4. ੾Γସ͑౰೔ 5. ݱ࣮

Slide 14

Slide 14 text

1. Զ͸ɺݕূ؀ڥΛɺࣺͯΔ

Slide 15

Slide 15 text

15 1. Զ͸ɺݕূ؀ڥΛɺࣺͯΔ ݕূ؀ڥͱຊ൪؀ڥͰ ‣ αʔόͷ਺ ‣ αʔόͷछྨ ‣ ωοτϫʔΫ ͕ҟͳ͍ͬͯͨ 1. ݕূ؀ڥΛҠߦͯ͠ɺϊ΢ϋ΢ΛஷΊͯຊ൪΋Ҡߦ 2. ݕূ؀ڥΛຊ൪؀ڥͱಉ͡ߏ੒ʹ͔ͯ͠ΒҠߦ

Slide 16

Slide 16 text

16 1. Զ͸ɺݕূ؀ڥΛɺࣺͯΔ ݕূ؀ڥͱຊ൪؀ڥͰ ‣ αʔόͷ਺ ‣ αʔόͷछྨ ‣ ωοτϫʔΫ ͕ҟͳ͍ͬͯͨ ݕূ؀ڥͷҠߦϊ΢ϋ΢͸ຊ൪Ͱ໾ʹཱͨͳ͍ & Ҡߦʹ͔͚ΒΕΔ͕࣌ؒগͳ͍ ݕূ؀ڥ͸ஔ͍ͱ͍ͯɺຊ൪؀ڥ͔Β΍Δͧ

Slide 17

Slide 17 text

17 1. Զ͸ɺݕূ؀ڥΛɺࣺͯΔ clone ֤ͨ͠αʔόʔΛผ Host ໊ʹͯ͠ಈ࡞ݕূʢޙड़ʣ ͱ͸͍͑ɺຊ൪ҰൃΤΠϠͰ͸ͳ͍ ֎஫ઌ ΦϯϓϨ ΦϯϓϨ ๭ࣾ VM P2V ෺ཧ

Slide 18

Slide 18 text

2. ωοτϫʔΫɺݽཱɺःஅͯ͠

Slide 19

Slide 19 text

19 2. ωοτϫʔΫɺݽཱɺःஅͯ͠ ֎஫ઌ Batch ໊دͤ JP1 ΦϑΟε

Slide 20

Slide 20 text

20 2. ωοτϫʔΫɺݽཱɺःஅͯ͠ Batch ໊دͤ JP1 ΦϑΟε P2V ֎஫ઌ

Slide 21

Slide 21 text

21 2. ωοτϫʔΫɺݽཱɺःஅͯ͠ Batch ໊دͤ JP1 ΦϑΟε Batch ໊دͤ JP1 ֎஫ઌ

Slide 22

Slide 22 text

22 2. ωοτϫʔΫɺݽཱɺःஅͯ͠ Batch ໊دͤ JP1 ΦϑΟε Batch 2 ໊دͤ 2 JP1 2 DB 2 DB ϗετ໊Λมߋ ֎஫ઌ

Slide 23

Slide 23 text

23 2. ωοτϫʔΫɺݽཱɺःஅͯ͠ Batch εέδϡʔϦϯάδϣϒ: ͋Δ....͔΋͠Εͳ͍ʁ τϦΨʔ: ͋Δ....͔΋͠Εͳ͍ʁ JP1 ΋͋ͬͨ͠৔߹ɺՔಇதຊ൪DBʹมߋΛՃ͔͑Ͷͳ͍ Digdag ΍ Jenkins తͳΦʔτϝʔγϣϯπʔϧ Կ͕ಈ͍ͯΔ͔ਖ਼௚Θ͔ΒΜ....... ෳࡶͳδϣϒͨͪ Կ͕͍ͭಈ͍ͯΔ͔Θ͔ΒΜ http://itdoc.hitachi.co.jp/manuals/3020/30203S0933/AJSV0099.HTM

Slide 24

Slide 24 text

24 2. ωοτϫʔΫɺݽཱɺःஅͯ͠ Batch ໊دͤ JP1 Batch 2 ֎஫ઌ ΦϑΟε JP1 2

Slide 25

Slide 25 text

25 2. ωοτϫʔΫɺݽཱɺःஅͯ͠ https://www.rakuten.ne.jp/gold/trycycle/smart/basic06.html

Slide 26

Slide 26 text

26 2. ωοτϫʔΫɺݽཱɺःஅͯ͠ https://www.rakuten.ne.jp/gold/trycycle/smart/basic06.html αʔόʔΛਫʹ௜Ίͯ Ͳ͔͜Β௨৴͕࿙ΕͯΔ͔Λ ֬ೝ͢Δ

Slide 27

Slide 27 text

27 2. ωοτϫʔΫɺݽཱɺःஅͯ͠ Batch ໊دͤ JP1 Batch 2 ໊دͤ 2 JP1 2 DB 2 DB ωοτϫʔΫ͔Βݽཱͤ͞Δ

Slide 28

Slide 28 text

28 2. ωοτϫʔΫɺݽཱɺःஅͯ͠ http://www.pc2.jp/tips/err_log.html ֎ʹΞΫηε͠Α͏ͱ͢Δϓϩηε͸ɺΤϥʔϩάʹه࿥͞ΕΔ ด࠯ωοτʹ௜ΊͨΒΤϥʔϩάΛ֬ೝͯ҆͠શΛ֬ೝ ʢΤϥʔͰͯͳ͍͔ΒDBʹ΋ΞΫηε͠ͳ͍ żŢ!!ʣ

Slide 29

Slide 29 text

29 2. ωοτϫʔΫɺݽཱɺःஅͯ͠ Batch ໊دͤ JP1 Batch 2 ໊دͤ 2 JP1 2 DB 2 DB ֬ೝޙɺ੖ΕͯυϝΠϯࢀՃ

Slide 30

Slide 30 text

3. ͑ʂʁ /etc/hosts Λ͍ͬͯ͡ʂʁ

Slide 31

Slide 31 text

31 3. ͑ʂʁ /etc/hosts Λ͍ͬͯ͡ʂʁ Batch ໊دͤ JP1 Batch 2 ໊دͤ 2 JP1 2 DB 2 DB

Slide 32

Slide 32 text

32 3. ͑ʂʁ /etc/hosts Λ͍ͬͯ͡ʂʁ Batch ໊دͤ JP1 Batch 2 ໊دͤ 2 JP1 2 DB 2 DB https://www.itmedia.co.jp/enterprise/articles/0910/14/news003.html Host ໊Ͱδϣϒ࣮ߦ

Slide 33

Slide 33 text

33 3. ͑ʂʁ /etc/hosts Λ͍ͬͯ͡ʂʁ Batch ໊دͤ JP1 Batch 2 ໊دͤ 2 JP1 2 DB 2 DB SET DB_HOST = ຊ൪DB SET SERVER = ຊ൪SERVER DELETE * FROM FOO; # BT01002Batch.exe, .bat etc ؀ڥม਺௚ॻ͖

Slide 34

Slide 34 text

34 3. ͑ʂʁ /etc/hosts Λ͍ͬͯ͡ʂʁ Batch ໊دͤ JP1 Batch 2 ໊دͤ 2 JP1 2 DB 2 DB SET DB_HOST = ຊ൪DB SET SERVER = ຊ൪SERVER DELETE * FROM FOO; # BT01002Batch.exe, .bat etc ؀ڥม਺௚ॻ͖ Ͳͷ .exe Λୟ͘ͱຊ൪ʹӨڹ͋Δͷ͔Θ͔ΒΜɻ͜Θ͍

Slide 35

Slide 35 text

35 3. ͑ʂʁ /etc/hosts Λ͍ͬͯ͡ʂʁ C:\Windows\System32\drivers\etc\hosts http://www.obenri.com/_dnsserver/hosts_file.html

Slide 36

Slide 36 text

36 3. ͑ʂʁ /etc/hosts Λ͍ͬͯ͡ʂʁ C:\Windows\System32\drivers\etc\hosts http://www.obenri.com/_dnsserver/hosts_file.html 127.0.0.1 Քಇதຊ൪DB 127.0.0.1 Քಇதຊ൪Server1 127.0.0.1 Քಇதຊ൪Server2 127.0.0.1 Քಇதຊ൪Server3 ؔ܎αʔόʔΛ͢΂ͯϩʔΧϧϗετΛ޲͚ͯ͠·͏

Slide 37

Slide 37 text

37 3. ͑ʂʁ /etc/hosts Λ͍ͬͯ͡ʂʁ Batch ໊دͤ JP1 Batch 2 ໊دͤ 2 JP1 2 DB 2 DB https://www.itmedia.co.jp/enterprise/articles/0910/14/news003.html IP Λ͝·͔ͯ͠ΔͷͰ ϩʔΧϧϗετΛݟʹߦ͘

Slide 38

Slide 38 text

38 3. ͑ʂʁ /etc/hosts Λ͍ͬͯ͡ʂʁ Batch ໊دͤ JP1 Batch 2 ໊دͤ 2 JP1 2 DB 2 DB 127.0.0.1ͷน

Slide 39

Slide 39 text

39 3. ͑ʂʁ /etc/hosts Λ͍ͬͯ͡ʂʁ Batch 2 ໊دͤ 2 JP1 2 DB 2 127.0.0.1ͷน ૄ௨֬ೝ Ϣʔβݖݶ ੑೳࢼݧ ֤छ࣮ݧ DB exp/imp

Slide 40

Slide 40 text

4. ੾Γସ͑౰೔

Slide 41

Slide 41 text

41 4. ੾Γସ͑౰೔ Batch ໊دͤ JP1 Batch 2 ໊دͤ 2 JP1 2 DB 2 DB 127.0.0.1ͷน ωοτϫʔΫ੾Γ཭͠

Slide 42

Slide 42 text

42 4. ੾Γସ͑౰೔ Batch 2 ໊دͤ 2 JP1 2 DB 2 127.0.0.1ͷน

Slide 43

Slide 43 text

43 4. ੾Γସ͑౰೔ Batch ໊دͤ JP1 DB 127.0.0.1ͷน ϗετ໊मਖ਼

Slide 44

Slide 44 text

44 4. ੾Γସ͑౰೔ Batch ໊دͤ JP1 DB นͷఫഇ # 127.0.0.1 Քಇதຊ൪DB # 127.0.0.1 Քಇதຊ൪Server1 # 127.0.0.1 Քಇதຊ൪Server2 # 127.0.0.1 Քಇதຊ൪Server3

Slide 45

Slide 45 text

45 4. ੾Γସ͑౰೔ Batch ໊دͤ JP1 DB

Slide 46

Slide 46 text

46 4. ੾Γସ͑౰೔ ֎஫ઌ Batch ໊دͤ JP1 ΦϑΟε Batch ໊دͤ JP1 ֎஫ઌͷΦϯϓϨαʔόʔ͔Β ࣗࣾͷΦϯϓϨαʔόʔʹ੾Γସ͑ΒΕͨ

Slide 47

Slide 47 text

47 4. ੾Γସ͑౰೔ ׬ྃʂʂ

Slide 48

Slide 48 text

5. ݱ࣮

Slide 49

Slide 49 text

49 5. ݱ࣮ ‣ ݕূதʹຊ൪DBʹରͯ͠δϣϒ࣮ߦͪ͠Όͬͨ ‣ Ҡߦޙॳ೔ɺDBͷҰҙΩʔ੍໿Ͱ Error ‣ Ҡߦޙॳ೔ɺFTPΫϥΠΞϯτͷόάͰग़ྗ 0 ‣ ݕূ؀ڥ·ͩҠߦͯ͠ͳ͍ and more ..... JP1ͰεέδϡʔϦϯάδϣϒͷର৅αʔό: null ʹઃఆ ର৅αʔό: null == JP1αʔόʔࣗ਎ ͳͷͰɺࣗ෼ʹରͯ͠δϣϒൃߦ ڞ༗αʔόͷ exe Λୟ͍ͯຊ൪DBͷεΩʔϚ Drop ͠Α͏ͱͯͨ͠ʢfail ͨ͠ʣ Oracle ७ਖ਼ͷ export/import πʔϧͰ DB ΛϑϧϦετΞ SequenceObject Λ Overwrite Ͱ͖ͣɺݹ͍ Sequence ͕࢒Δ next val Ͱࢦఆ͞ΕΔ id ʹ͸͢ͰʹϨίʔυ͕ଘࡏͯ͠Δʢखಈ inc ͨ͠ʣ Windows ଆͷόάɻύονΛ౰ͯΔͱ௚ͬͨɻ͔ͦ͜Α

Slide 50

Slide 50 text

ৼΓฦΓ

Slide 51

Slide 51 text

51 ৼΓฦΓ ‣ ຊ൪ͱΠϯϑϥߏ੒Λἧ͑ͨݕূ؀ڥΛ༻ҙ͢Δ ‣ ࣗಈςετΛ࡞Δ ‣ JP1 Λ΍ΊΔ ‣ ࠷ॳ͔Βผ෦ॺͷਓؒΛר͖ࠐΜͰҠߦΛਐΊΔ ‣ ຊ൪؀ڥͰӨڹൣғʹؾΛ͚ͭͳ͕Β࡞ۀ͢Δͷ͸ຊ౰ʹ͖͍ͭ ‣ υϝΠϯ஌͕ࣝͳ͍ঢ়ଶͰಈ͔͢ͱຊ౰ʹ͙͢ʹো֐ʹͳΔ ‣ ҰݸҰݸख࡞ۀͰ֬ೝ͢Δͷ͸ຊ౰ʹਫ਼ਆతʹͭΒ͍ ‣ ୀ۶ͳ͜ͱ͸ίϯϐϡʔλʹ΍ΒͤΕ͹ΑΖ͍͠ ‣ ͳΜ΋Θ͔ΒΜ ‣ ԿΛීஈͷۀ຿Ͱಈ͔ͯ͠ɺͲ͏֬ೝ͢Ε͹͍͍ͷ͔Θ͔ΒΜ ‣ ౰ࣄऀΛר͖ࠐΜͰQAͳΓܭըͳΓ࿈བྷͳΓऔͬͨํ͕ૣ͍

Slide 52

Slide 52 text

52 ৼΓฦΓ ‣ υϝΠϯ஌ࣝΛ͖ͪΜͱ͚ͭΔ ‣ ؔΘͬͯ͘Εͨօ͞Μʹ͸ײँ͔͠ͳ͍ ‣ υϝΠϯ஌͕ࣝͳ͍ঢ়ଶͰಈ͔͢ͱຊ౰ʹ͙͢ʹো֐ʹͳΔ ‣ αʔόʔͷಈ࡞֬ೝ΍ܭըΛϝΠϯͰ୲౰͚ͨ͠ͲɺΠϯϑϥͷ ํͷര଎࡞ۀ΍ϚωʔδϟͷํͷυϝΠϯ஌ࣝɺϕςϥϯEngͷ ΞυόΠεʹ͸ຊ౰ʹॿ͚ΒΕ·ͨ͠ ‣ Πϯϑϥ as ίʔυ is ΊͬͪΌ important ‣ ͜ͷαʔόͰԿ͕ಈ͘ͷ͔Βͷௐࠪ͸ຊ౰ʹେม ‣ ख࡞ۀͰ /etc/hosts ॻ͖׵͑ͨΓ tnsnames.ora ॻ͖׵͑ͨΓ config ॻ͖׵͑ͨΓωοτϫʔΫ͍ͬͨ͡Γ͸ຊ౰ʹ͖͍ͭ ‣ ϨϏϡʔͰ͖Δɺঢ়ଶ͕ݟ͑Δঢ়ଶͰ࢒Δɺຊ౰ʹେࣄ

Slide 53

Slide 53 text

53 to be continued .....