M3 techtalk https://m3-engineer.connpass.com/event/186277/
ΦϯϓϨ to ΦϯϓϨͨ͠@blue_1617
View Slide
ࢲ୭ʁblue (@blue_1617)https://blue0513.github.io/show_room/2‣ ΨʔϦΟϨίʔυνϟϯωϧ‣ ࠷ۙͬͯΔ͜ͱ / ϋϚ͍ͬͯΔ͜ͱ‣ ϙέϞϯιʔυ&γʔϧυ‣ Magic: The Gathering‣ ࣍ʹΓ͍ͨ͜ͱ‣ Fall Guys
͜ͷൃදʁ 3ࣾϓϩδΣΫτͷαʔόΛҠߦ͢ΔAWSGCPTerraformCloudAzureAnsibleDigdagMicroServiceʢM3ͷάϧʔϓձࣾʣ
͜ͷൃදʁ 4ࣾϓϩδΣΫτͷαʔόΛҠߦ͢ΔAWSGCPTerraformCloudAzureAnsibleDigdagMicroServiceग़͖ͯ·ͤΜɻѱ͔͠ΒͣʢM3ͷάϧʔϓձࣾʣ
͜ͷൃදʁ 5ࣾϓϩδΣΫτͷαʔόΛҠߦ͢Δ֎ઌΦϯϓϨ֤छΞϓϦࣾཧ
͜ͷൃදʁ 6ࣾϓϩδΣΫτͷαʔόΛҠߦ͢Δ֎ઌΦϯϓϨΦϯϓϨࣾVM
7ࣾϓϩδΣΫτͷαʔόΛҠߦ͢ΔBatchॲཧαʔό໊دͤॲཧαʔόDatabaseΞϓϦέʔγϣϯWindows αʔόOracle SE 11gWindows Forms.bat .exe===JP1 αʔό͜ͷൃදʁ
8ࣾϓϩδΣΫτͷαʔόΛҠߦ͢Δ͜ͷൃදʁ֎ઌΦϯϓϨϓϩδΣΫτ։࢝: 4݄Ϧϛοτ: 9݄ॳ०ओཁϝϯόʔ: 4ਓϚωʔδϟ * 1Πϯϑϥ * 1ΞϓϦ * 2Ҡߦͷརӹ: Nઍສԁ/
9ͬ͘͟ΓΠϯϑϥߏਤຊ൪ ݕূBatch ໊دͤ JP1ڞ༗σΟϨΫτϦA ڞ༗σΟϨΫτϦBBatch ໊دͤ JP1ΦϑΟε
10ͬ͘͟ΓΠϯϑϥߏਤຊ൪ ݕূBatch ໊دͤ JP1ڞ༗σΟϨΫτϦA ڞ༗σΟϨΫτϦBBatch ໊دͤ JP1ΦϑΟε
11ͬ͘͟ΓΠϯϑϥߏਤຊ൪ ݕূBatch ໊دͤ JP1ڞ༗σΟϨΫτϦABatch/DB ໊دͤΦϑΟε
࡞ઓ
13࡞ઓ1. ԶɺݕূڥΛɺࣺͯΔ2. ωοτϫʔΫɺݽཱɺःஅͯ͠3. ͑ʂʁ /etc/hosts Λ͍ͬͯ͡ʂʁ4. Γସ͑5. ݱ࣮
1. ԶɺݕূڥΛɺࣺͯΔ
151. ԶɺݕূڥΛɺࣺͯΔݕূڥͱຊ൪ڥͰ‣ αʔόͷ‣ αʔόͷछྨ‣ ωοτϫʔΫ͕ҟͳ͍ͬͯͨ1. ݕূڥΛҠߦͯ͠ɺϊϋΛஷΊͯຊ൪Ҡߦ2. ݕূڥΛຊ൪ڥͱಉ͡ߏʹ͔ͯ͠ΒҠߦ
161. ԶɺݕূڥΛɺࣺͯΔݕূڥͱຊ൪ڥͰ‣ αʔόͷ‣ αʔόͷछྨ‣ ωοτϫʔΫ͕ҟͳ͍ͬͯͨݕূڥͷҠߦϊϋຊ൪Ͱʹཱͨͳ͍ &Ҡߦʹ͔͚ΒΕΔ͕࣌ؒগͳ͍ݕূڥஔ͍ͱ͍ͯɺຊ൪ڥ͔ΒΔͧ
171. ԶɺݕূڥΛɺࣺͯΔclone ֤ͨ͠αʔόʔΛผ Host ໊ʹͯ͠ಈ࡞ݕূʢޙड़ʣͱ͍͑ɺຊ൪ҰൃΤΠϠͰͳ͍֎ઌΦϯϓϨΦϯϓϨࣾVM P2V ཧ
2. ωοτϫʔΫɺݽཱɺःஅͯ͠
192. ωοτϫʔΫɺݽཱɺःஅͯ͠֎ઌBatch ໊دͤ JP1ΦϑΟε
202. ωοτϫʔΫɺݽཱɺःஅͯ͠Batch ໊دͤ JP1ΦϑΟεP2V֎ઌ
212. ωοτϫʔΫɺݽཱɺःஅͯ͠Batch ໊دͤ JP1ΦϑΟεBatch ໊دͤ JP1֎ઌ
222. ωοτϫʔΫɺݽཱɺःஅͯ͠Batch ໊دͤ JP1ΦϑΟεBatch 2 ໊دͤ 2 JP1 2DB 2 DBϗετ໊Λมߋ֎ઌ
232. ωοτϫʔΫɺݽཱɺःஅͯ͠BatchεέδϡʔϦϯάδϣϒ: ͋Δ....͔͠Εͳ͍ʁτϦΨʔ: ͋Δ....͔͠Εͳ͍ʁJP1͋ͬͨ͠߹ɺՔಇதຊ൪DBʹมߋΛՃ͔͑Ͷͳ͍Digdag Jenkins తͳΦʔτϝʔγϣϯπʔϧԿ͕ಈ͍ͯΔ͔ਖ਼Θ͔ΒΜ.......ෳࡶͳδϣϒͨͪԿ͕͍ͭಈ͍ͯΔ͔Θ͔ΒΜhttp://itdoc.hitachi.co.jp/manuals/3020/30203S0933/AJSV0099.HTM
242. ωοτϫʔΫɺݽཱɺःஅͯ͠Batch ໊دͤ JP1Batch 2֎ઌΦϑΟεJP1 2
252. ωοτϫʔΫɺݽཱɺःஅͯ͠https://www.rakuten.ne.jp/gold/trycycle/smart/basic06.html
262. ωοτϫʔΫɺݽཱɺःஅͯ͠https://www.rakuten.ne.jp/gold/trycycle/smart/basic06.htmlαʔόʔΛਫʹΊͯͲ͔͜Β௨৴͕࿙ΕͯΔ͔Λ֬ೝ͢Δ
272. ωοτϫʔΫɺݽཱɺःஅͯ͠Batch ໊دͤ JP1Batch 2໊دͤ 2JP1 2DB 2DBωοτϫʔΫ͔Βݽཱͤ͞Δ
282. ωοτϫʔΫɺݽཱɺःஅͯ͠http://www.pc2.jp/tips/err_log.html֎ʹΞΫηε͠Α͏ͱ͢ΔϓϩηεɺΤϥʔϩάʹه͞ΕΔดωοτʹΊͨΒΤϥʔϩάΛ֬ೝͯ҆͠શΛ֬ೝʢΤϥʔͰͯͳ͍͔ΒDBʹΞΫηε͠ͳ͍ żŢ!!ʣ
292. ωοτϫʔΫɺݽཱɺःஅͯ͠Batch ໊دͤ JP1Batch 2 ໊دͤ 2 JP1 2DB 2 DB֬ೝޙɺΕͯυϝΠϯࢀՃ
3. ͑ʂʁ /etc/hosts Λ͍ͬͯ͡ʂʁ
313. ͑ʂʁ /etc/hosts Λ͍ͬͯ͡ʂʁBatch ໊دͤ JP1Batch 2 ໊دͤ 2 JP1 2DB 2 DB
323. ͑ʂʁ /etc/hosts Λ͍ͬͯ͡ʂʁBatch ໊دͤ JP1Batch 2 ໊دͤ 2 JP1 2DB 2 DBhttps://www.itmedia.co.jp/enterprise/articles/0910/14/news003.htmlHost ໊Ͱδϣϒ࣮ߦ
333. ͑ʂʁ /etc/hosts Λ͍ͬͯ͡ʂʁBatch ໊دͤ JP1Batch 2 ໊دͤ 2 JP1 2DB 2 DBSET DB_HOST = ຊ൪DBSET SERVER = ຊ൪SERVERDELETE * FROM FOO;# BT01002Batch.exe, .bat etcڥมॻ͖
343. ͑ʂʁ /etc/hosts Λ͍ͬͯ͡ʂʁBatch ໊دͤ JP1Batch 2 ໊دͤ 2 JP1 2DB 2 DBSET DB_HOST = ຊ൪DBSET SERVER = ຊ൪SERVERDELETE * FROM FOO;# BT01002Batch.exe, .bat etcڥมॻ͖Ͳͷ .exe Λୟ͘ͱຊ൪ʹӨڹ͋Δͷ͔Θ͔ΒΜɻ͜Θ͍
353. ͑ʂʁ /etc/hosts Λ͍ͬͯ͡ʂʁC:\Windows\System32\drivers\etc\hostshttp://www.obenri.com/_dnsserver/hosts_file.html
363. ͑ʂʁ /etc/hosts Λ͍ͬͯ͡ʂʁC:\Windows\System32\drivers\etc\hostshttp://www.obenri.com/_dnsserver/hosts_file.html127.0.0.1 Քಇதຊ൪DB127.0.0.1 Քಇதຊ൪Server1127.0.0.1 Քಇதຊ൪Server2127.0.0.1 Քಇதຊ൪Server3ؔαʔόʔΛͯ͢ϩʔΧϧϗετΛ͚ͯ͠·͏
373. ͑ʂʁ /etc/hosts Λ͍ͬͯ͡ʂʁBatch ໊دͤ JP1Batch 2 ໊دͤ 2 JP1 2DB 2 DBhttps://www.itmedia.co.jp/enterprise/articles/0910/14/news003.htmlIP Λ͝·͔ͯ͠ΔͷͰϩʔΧϧϗετΛݟʹߦ͘
383. ͑ʂʁ /etc/hosts Λ͍ͬͯ͡ʂʁBatch ໊دͤ JP1Batch 2 ໊دͤ 2 JP1 2DB 2 DB127.0.0.1ͷน
393. ͑ʂʁ /etc/hosts Λ͍ͬͯ͡ʂʁBatch 2 ໊دͤ 2 JP1 2DB 2127.0.0.1ͷนૄ௨֬ೝϢʔβݖݶੑೳࢼݧ֤छ࣮ݧDB exp/imp
4. Γସ͑
414. Γସ͑Batch ໊دͤ JP1Batch 2 ໊دͤ 2 JP1 2DB 2 DB127.0.0.1ͷนωοτϫʔΫΓ͠
424. Γସ͑Batch 2 ໊دͤ 2 JP1 2DB 2127.0.0.1ͷน
434. Γସ͑Batch ໊دͤ JP1DB127.0.0.1ͷนϗετ໊मਖ਼
444. Γସ͑Batch ໊دͤ JP1DBนͷఫഇ# 127.0.0.1 Քಇதຊ൪DB# 127.0.0.1 Քಇதຊ൪Server1# 127.0.0.1 Քಇதຊ൪Server2# 127.0.0.1 Քಇதຊ൪Server3
454. Γସ͑Batch ໊دͤ JP1DB
464. Γସ͑֎ઌBatch ໊دͤ JP1ΦϑΟεBatch ໊دͤ JP1֎ઌͷΦϯϓϨαʔόʔ͔ΒࣗࣾͷΦϯϓϨαʔόʔʹΓସ͑ΒΕͨ
474. Γସ͑ྃʂʂ
5. ݱ࣮
495. ݱ࣮‣ ݕূதʹຊ൪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 ଆͷόάɻύονΛͯΔͱͬͨɻ͔ͦ͜Α
ৼΓฦΓ
51ৼΓฦΓ‣ ຊ൪ͱΠϯϑϥߏΛἧ͑ͨݕূڥΛ༻ҙ͢Δ‣ ࣗಈςετΛ࡞Δ‣ JP1 ΛΊΔ‣ ࠷ॳ͔Βผ෦ॺͷਓؒΛר͖ࠐΜͰҠߦΛਐΊΔ‣ ຊ൪ڥͰӨڹൣғʹؾΛ͚ͭͳ͕Β࡞ۀ͢Δͷຊʹ͖͍ͭ‣ υϝΠϯ͕ࣝͳ͍ঢ়ଶͰಈ͔͢ͱຊʹ͙͢ʹোʹͳΔ‣ ҰݸҰݸख࡞ۀͰ֬ೝ͢Δͷຊʹਫ਼ਆతʹͭΒ͍‣ ୀ۶ͳ͜ͱίϯϐϡʔλʹΒͤΕΑΖ͍͠‣ ͳΜΘ͔ΒΜ‣ ԿΛීஈͷۀͰಈ͔ͯ͠ɺͲ͏֬ೝ͢Ε͍͍ͷ͔Θ͔ΒΜ‣ ࣄऀΛר͖ࠐΜͰQAͳΓܭըͳΓ࿈བྷͳΓऔͬͨํ͕ૣ͍
52ৼΓฦΓ‣ υϝΠϯࣝΛ͖ͪΜͱ͚ͭΔ‣ ؔΘͬͯ͘Εͨօ͞Μʹײँ͔͠ͳ͍‣ υϝΠϯ͕ࣝͳ͍ঢ়ଶͰಈ͔͢ͱຊʹ͙͢ʹোʹͳΔ‣ αʔόʔͷಈ࡞֬ೝܭըΛϝΠϯͰ୲͚ͨ͠ͲɺΠϯϑϥͷํͷര࡞ۀϚωʔδϟͷํͷυϝΠϯࣝɺϕςϥϯEngͷΞυόΠεʹຊʹॿ͚ΒΕ·ͨ͠‣ Πϯϑϥ as ίʔυ is ΊͬͪΌ important‣ ͜ͷαʔόͰԿ͕ಈ͘ͷ͔Βͷௐࠪຊʹେม‣ ख࡞ۀͰ /etc/hosts ॻ͖͑ͨΓ tnsnames.ora ॻ͖͑ͨΓconfig ॻ͖͑ͨΓωοτϫʔΫ͍ͬͨ͡Γຊʹ͖͍ͭ‣ ϨϏϡʔͰ͖Δɺঢ়ଶ͕ݟ͑Δঢ়ଶͰΔɺຊʹେࣄ
53to be continued .....
blue0513
yahiru
codehex
parttimenerd
zerebom
ivargrimstad
kinocoboy2
niftycorp
atinfinity
takefumiyoshii
rmatsuoka
mot_techtalk
mipypf
nonsquared
bluesmoon
skipperchong
moore
jcasabona
deanohume
bkeepers
cromwellryan
scottboms
sachag
denniskardys
jonyablonski