๋ณธ๋ฌธ ๋ฐ”๋กœ๊ฐ€๊ธฐ

Oracle2

[์˜ค๋ผํด ํด๋ผ์šฐ๋“œ] (2) m1์—์„œ oracle์„ ์‚ฌ์šฉํ•˜์ž - DBeaver ์ž ์ด์ œ ์˜ค๋ผํด ํด๋ผ์šฐ๋“œ๋กœ DB์„œ๋ฒ„๋ฅผ ์ƒ์„ฑํ–ˆ์œผ๋‹ˆ! ์„œ๋ฒ„์— ์—ฐ๊ฒฐ์ด ๋˜๋Š”์ง€ ํ™•์ธํ•˜๊ธฐ ์œ„ํ•ด DBeaver ํˆด์„ ์ด์šฉํ•ด๋ด…์‹œ๋‹ค. ๋ฌผ๋ก  sqlDeveloper๋ฅผ ์‚ฌ์šฉํ•ด๋„ ๋ฉ๋‹ˆ๋‹ค. (๊ทผ๋ฐ ์ €๋Š” ๋„ˆ๋ฌด ๋งŽ์ด ํŠ•๊ฒจ์„œ ๊ทธ๋ƒฅ ํฌ๊ธฐํ•˜๊ณ  DBeaver ์‚ฌ์šฉํ•ฉ๋‹ˆ๋‹ค...) 1. OJDBC ์„ค์น˜ https://www.oracle.com/kr/database/technologies/appdev/jdbc-downloads.html ์ƒ๊ธฐ์˜ ๋งํฌ์— ์ ‘์†ํ•ด์„œ OJDBC๋ฅผ ์„ค์น˜ํ•˜๊ณ  ์••์ถ•์„ ํ•ด์ œํ•ด์ค๋‹ˆ๋‹ค. ์ €๋ฒˆ ํฌ์ŠคํŒ…์—์„œ ์„ค์น˜ํ•œ ์˜ค๋ผํด ๋ฒ„์ „์ด 19c์ด๊ธฐ ๋•Œ๋ฌธ์— ์ €๋Š” 19.3drivers์˜ ojdbc10-full.tar.gz๋ฅผ ์„ค์น˜ํ–ˆ์Šต๋‹ˆ๋‹ค. 2. DBeaver ์„ค์น˜ https://dbeaver.io/download/ Download | DBeaver.. 2021. 7. 31.
[์˜ค๋ผํด ํด๋ผ์šฐ๋“œ] (1) m1์—์„œ oracle์„ ์‚ฌ์šฉํ•˜์ž - ATP ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค ์ƒ์„ฑ *๋ณธ ํฌ์ŠคํŒ…์€ m1์นฉ mac์„ ์‚ฌ์šฉํ•˜์—ฌ ์ž‘์„ฑ๋˜์—ˆ์Šต๋‹ˆ๋‹ค. ์ฐธ๊ณ  ๋ถ€ํƒ๋“œ๋ฆฝ๋‹ˆ๋‹ค! *๋‹ค์‹œ ์ƒ์„ฑํ•  ๋•Œ ๊นœ๋นกํ• ๊นŒ๋ด ๋ณต๊ธฐ์šฉ์œผ๋กœ ์ž‘์„ฑํ•œ ํฌ์ŠคํŒ…์ž…๋‹ˆ๋‹ค์š”... ์šฐ์„  ์˜ค๋ผํด ํด๋ผ์šฐ๋“œ๋ฅผ ์‚ฌ์šฉํ•˜๊ธฐ ์ „์— ๋จผ์ € ์•„๋ž˜ ๋งํฌ๋ฅผ ๋“ค์–ด๊ฐ„ ๋’ค ๐ŸŒŸํšŒ์›๊ฐ€์ž…๐ŸŒŸ ๋ถ€ํ„ฐ ํ•ด์ฃผ์„ธ์š”!! https://cloud.oracle.com/ Oracle Cloud Infrastructure cloud.oracle.com ๊ฒ€์ƒ‰ํ•ด๋ณด๋‹ˆ 1. VM์ธ์Šคํ„ด์Šค๋ฅผ ์ถ”๊ฐ€ํ•ด์„œ ๋ฆฌ๋ˆ…์Šค ์„œ๋ฒ„ ์œ„์— ์ง์ ‘ DB๋ฅผ ์„ค์น˜ํ•˜๋Š” ๋ฐฉ๋ฒ• 2. ์˜ค๋ผํด ํด๋ผ์šฐ๋“œ์—์„œ ์ž์œจ์šด์˜ ํŠธ๋žœ์žญ์…˜ ์ฒ˜๋ฆฌ(ATP)๋ฅผ ์ƒ์„ฑํ•˜๋Š” ๋ฐฉ๋ฒ• ์ด ์žˆ์—ˆ๋Š”๋ฐ, ์ €๋Š” ๋” ์‰ฌ์šด ๋ฐฉ๋ฒ•์ธ 2๋ฒˆ์„ ์„ ํƒํ–ˆ์Šต๋‹ˆ๋‹ค!! ๋”ฐ๋ผ์„œ ๊ตฌํš ๋‚˜๋ˆ„๊ธฐ ๋“ฑ์€ ํ•˜์ง€ ์•Š๊ณ  ๋ฐ”๋กœ ์ง„ํ–‰ํ•˜๋Š” ํฌ์ŠคํŒ…์ž…๋‹ˆ๋‹ค. 1. ์˜ค๋ผํด ํด๋ผ์šฐ๋“œ ์–ธ์–ด ์„ค์ • ์šฐ์ธก ์ƒ๋‹จ์— ์žˆ๋Š” ์ง€๊ตฌ๋ณธ ๋ชจ์–‘์„ ํด.. 2021. 7. 31.