์˜ค๋ฅ˜๋“ค ๐Ÿ˜ค 12

This Kernel requires an x86-64 CPU, but only detected an i686 CPU.

[VirtualBox CentOS ์„ค์น˜ ์ค‘ ์˜ค๋ฅ˜] ์ •์‹ ์—†๋‹คใ…ใ…22 This Kernel requires an x86-64 CPU, but only detected an i686 CPU This processor is not supported in this version of CentOS Linux ํœด ์ฒ˜์Œ์— CentOS ์„ค์น˜ํ• ๋•Œ 32 ๋น„ํŠธ๋กœ ์„ค์ •ํ•œ ๊ฒƒ ๊ฐ™๋‹ค. Red hat 32 ๋น„ํŠธ ์•ˆ๋งž๋Š”๋‹ค๊ณ  ๋‚˜์˜ค๋Š” ์„ค์ •์ด๋ผ 64 ๋น„ํŠธ๋กœ ๋ฐ”๊ฟ”์ฃผ๊ธฐ๋กœ. ๊ฐ„๋‹จํ•˜๊ฒŒ ์„ค์ • > ์ผ๋ฐ˜ ์—์„œ ๋ฐ”๊ฟ”์ค„ ์ˆ˜ ์žˆ๋‹ค. ๊ทธ ํ›„์—๋Š” ์ •์ƒ ์ž‘๋™ํ•จ!

Call to NEMR0InitVMPart2 failed: VERR_NEM_INIT_FAILED (VERR_NEM_VM_CREATE_FAILED

VIrtualBox ์˜ค๋ฅ˜ ํ—˜๋‚œํ•œ ์—๋Ÿฌ๊ธธ2222 ๊ฐ€์ƒ๋จธ์‹  ๋งŒ๋“ค๊ณ , ์‹คํ–‰ํ•˜์˜€์„ ๋•Œ ์•„๋ž˜์™€ ๊ฐ™์€ ์—๋Ÿฌ๊ฐ€ ๋ฐœ์ƒํ–ˆ๋‹ค. Call to NEMR0InitVMPart2 failed: VERR_NEM_INIT_FAILED (VERR_NEM_VM_CREATE_FAILED) ์ง„์งœ ๋นจ๊ฐ„์ƒ‰ ์—๋Ÿฌ ๋…ธ์ด๋กœ์ œ ๊ฑธ๋ฆด ๊ฒƒ ๊ฐ™๋‹ค. (ํ•œ๊ตญ ์ฃผ์‹์—์„œ ๋‚˜์™€ ์ œ๋ฐœ ์—ฌ๊ธฐ์„œ ์ด๋Ÿฌ์ง€ ๋งˆ์„ธ์š”) ์—ฌ๋Ÿฌ ๊ตฌ๊ธ€๋ง ํ•œ ๊ฒฐ๊ณผ ๐Ÿคฆโ€โ™‚๏ธHyper- V ๋ฅผ ๋นผ์ค˜์•ผํ•œ๋‹ค๊ณ ! ์ € ๊ธฐ๋Šฅ์ด ๋”ฐ๋ฅธ ์—๋Ÿฌ๋ž‘ ์ƒ์ถฉ๋ฌ๋Š”๋ฐ, ๊ทธ๊ฑด ๋‹ค์Œ์— ์˜ฌ๋ฆฌ๊ธฐ๋กœ.. ๐Ÿ˜’ ๋ฐฉ๋ฒ• 1 : ์ œ์–ดํŒ์—์„œ ๊ธฐ๋Šฅ ํ•ด์ œ ์ œ์–ดํŒ > ํ”„๋กœ๊ทธ๋žจ ๊ธฐ๋Šฅ > Windws ๊ธฐ๋Šฅ ์ผœ๊ธฐ/๋„๊ธฐ Hyper-V ์ฒดํฌ ํ•ด์ œํ•ด์คŒ. ๋”ด์‚ฌ๋žŒ๋“ค์€ ๋œ๋‹ค๋Š”๋ฐ, ๋‚˜๋Š” ์œˆ๋„์šฐ ์žฌ์‹œ์ž‘ ํ•ด๋„ ์•ˆ๋จ...๐Ÿคฆโ€โ™‚๏ธ ๋ช…๋ น์–ด๋กœ ์น˜๊ธฐ๋กœ. ๋ฐฉ๋ฒ• 2: ๋ช…๋ น์–ด ์ปค๋งจ๋“œ๋กœ ์‹คํ–‰ ..

postgres, SSL ์ค‘์ง€ ์—ฐ๊ฒฐ์— ๋Œ€ํ•œ ์„ค์ •์ด pg_hba.conf ํŒŒ์ผ์— ์—†์Šต๋‹ˆ๋‹ค.

์˜ค๋žœ๋งŒ์— ์˜ค๋ฅ˜ ๋‚ฌ๋‹ค ใ…œใ…œ ๋ชฐ๋ผ์„œ ์—„์ฒญ ๊ตฌ๊ธ€๋งํ–ˆ๋‹ค. ์‚ฌ์‹ค ์•„์ง๋„ ์ž˜ ๋ชจ๋ฅด๊ฒ ๋‹ค(?) ๊ทธ๋ž˜๋„ ์ฐพ์•„์„œ ํ•ด๊ฒฐํ•œ ๋ฐฉ๋ฒ•์€, pg_hba.conf ํŒŒ์ผ # TYPE DATABASE USER ADDRESS METHOD # IPv4 local connections: host all all 127.0.0.1/32 md5 # IPv6 local connections: host all all ::1/128 md5 # Allow replication connections from localhost, by a user with the # replication privilege. host replication all 127.0.0.1/32 md5 host replication all ::1/128 md5 ์— host all all ..

oracle csv ํ•œ๊ธ€๊นจ์ง

์˜ค๋ผํด์— ์—‘์…€์„ ๋„ฃ์–ด ์ฃผ๊ธฐ๋กœ ํ•˜์˜€๋‹ค...! (dbeaver ์—์„œ ์‚ฌ์šฉ!) ์—‘์…€ ํŒŒ์ผ ๋„ฃ์–ด์ฃผ๊ธฐ๋งŒ ํ•˜๋ฉด ํ•œ๊ธ€์ด ์ด๋ ‡๊ฒŒ ๊นจ์ง€๋Š” ํ˜„์ƒ ๋ฐœ๊ฒฌ.... ใ…œ0ใ…œ ์ด๋ฆฌ์ €๋ฆฌ ์ฐพ์•„๋ณด์•˜๋‹ค. ์šฐ์„  ๋‚˜ํ•œํ…Œ (๋‚ด๊ฐ€ ์ž‘์—…ํ•ด์•ผํ•˜๋Š”) ๋งž๋Š” ๋ถ€๋ถ„์€ ์—‘์…€์˜ ๋ฒ„์ „์— ๋”ฐ๋ฅธ ์ธ์ฝ”๋”ฉ์ด ๋‹ค๋ฅธ ์˜ค๋ฅ˜! ๋ฐ์ดํ„ฐ ๋กœ๋“œํ•˜๊ณ  ์‹ถ์€ ํŒŒ์ผ์„ ์ฐพ์•„๊ฐ€์„œ ๋‹ค๋ฅธ ์ด๋ฆ„์œผ๋กœ ์ €์žฅ ํŒŒ์ผํ˜•์‹csv๋กœ ์ €์žฅ์„ ๋ˆŒ๋Ÿฌ์•ผํ•˜๋Š”๋ฐ, ์ด๊ฑฐ ํ•˜๋‚˜ ๋ฐ–์— ์—†๋‹ค... csv (utf-8 ๋กœ ์ €์žฅ) ์ด ์žˆ์–ด์•ผํ•จ...! ์—‘์…€ ๋ฒ„์ „ 2013 ์ด๋ผ ๋‚ฎ์•„์„œ ์—†๋Š” ๋“ฏ ํ•ด๊ฒฐ๋ฐฉ์•ˆ!! ์ € ์—‘์…€ ํŒŒ์ผ์„ ๋ฉ”๋ชจ์žฅ์œผ๋กœ ๋“œ๋ž˜๊ทธํ•˜์—ฌ ๋ฉ”๋ชจ์žฅ์—์„œ ์—ด์–ด์ค๋‹ˆ๋‹ค. ๋ฉ”๋ชจ์žฅ ํŒŒ์ผ ์—ด๊ณ , ์ด๋ ‡๊ฒŒ ํ•˜์—ฌ ๋‹ค์‹œ ์—‘์…€๋กœ ์ €์žฅ ! ์ธ์ฝ”๋”ฉ์—์„œ UTF-8 ์„ ํƒํ•ด์คŒ! ๊ทธ๋Ÿฌ๋ฉด ๊ธ€์ž๊ฐ€ ๊นจ์ง€์ง€ ์•Š๊ณ  ์ด์˜๊ฒŒ ๋“ค์–ด๊ฐ‘๋‹ˆ๋‹ค!0!0!0! ๐Ÿ™Œ๐Ÿ™Œ๐Ÿ™Œ๐Ÿ™Œ๐Ÿ™Œ

python -์ฃผํ”ผํ„ฐ ์˜ค๋ฅ˜๋ฐœ์ƒ ใ…œ

ํŒŒ์ด์ฌ ๊ณต๋ถ€์ข€ ํ•ด๋ณผ๊นŒ... ํ•ด์„œ ์ฃผํ”ผํ„ฐ๋ฅผ ํ‹€์—ˆ๋‹ค. ์ƒˆ๋กœ์šด ์ฐฝ ๋งŒ๋“ค๋ ค๊ณ  ํ•˜๋‹ˆ ์ฃผํ”ผํ„ฐ๊ฐ€ ๋‚  ๋ฒ„๋ ธ๋‹ค. ์™œ...? ๋น„์ฃผ์–ผ ์ŠคํŠœ๋””์˜ค ๊น”์•„์„œ ๊ทธ๋ž˜...? ๐Ÿ˜น ใ…‹ใ…‹ใ…‹ใ…‹... ์šฐ๊ธฐ๊ธฐ python ๋ฒ„์ „์ด ์•ˆ๋งž์•„์„œ ๊ทธ๋Ÿฌ๋‚˜ ๋ณด๋‹ค... ์ €๋ฒˆ์— ํ…์„œํ”Œ๋กœ์šฐ ์˜€๋‚˜,,, ์ผ€๋ผ์Šค ์˜€๋‚˜.... ์ฃผํ”ผํ„ฐ์—์„œ ํ•˜๊ณ  ์‹ถ์–ด์„œ ๋‚œ๋ฆฌ์น˜๋‹ค๊ฐ€ ์—…๋ฐ์ดํŠธ ํ•ด์„œ ์‹คํ–‰ ์•ˆ๋˜๋Š” ๊ฒƒ์ผ๊นŒ? ํฅ, ๊ตฌ๊ธ€์ฝ”๋žฉ ์ตœ๊ณ ๋‹ค. ๋”ฐ๋กœ ์•ˆํ•˜๊ณ  import ๋งŒ ํ•˜๋ฉด ์‚ฌ์šฉ๊ฐ€๋Šฅํ•ด. //// ๊ฒฐ๊ตญ ๊ตฌ๊ธ€ ์ฝ”๋žฉ ์‚ฌ์šฉํ•œ๋‹ค... ํ˜ธ์˜ฟใ„บํ˜ธ์˜ฅใ„นํ™๋ก

ORA-00979: not a GROUP BY expression

SQL Error [979] [42000]: ORA-00979: not a GROUP BY expression ์ด๋ ‡๊ฒŒ ์˜ค๋ฅ˜ ๋‚ฌ์„ ๊ฒฝ์šฐ? group by ๊ตฌ๋ฌธ์— ๊ทธ๋ฃน ํ•จ์ˆ˜ ์™ธ์— ์กฐํšŒํ•˜๋Š” column ๋ฅผ ๋ชจ๋‘ ํ‘œ์‹œํ•ด์•ผ! ์ฆ‰, select ์ ˆ์˜ ์ปฌ๋Ÿผ๊ณผ group by ์ ˆ์˜ ์ปฌ๋Ÿผ์ด ๊ฐ™์ง€ ์•Š์•„์„œ!

ORA-00920: invalid relational operator

๊ด€๊ณ„ ์—ฐ์‚ฐ์ž๊ฐ€ ๋ถ€์ ํ•ฉํ•˜๋‹ค๋Š” ์˜ค๋ฅ˜, SELECT first_name, last_name, salary FROM EMPLOYEES WHERE salary betweeen 4000 AND 8000; ์ด๋ ‡๊ฒŒ ์ž‘์„ฑํ•˜์˜€๋Š”๋ฐ, between ์„ ์ธ์‹ ๋ชปํ•œ๋“ฏ ํ•˜์—ฌ ์ง€์šฐ๊ณ  ๋‹ค์‹œ ์ž‘์„ฑํ•˜์˜€๋‹ค. between ์ƒ‰๊น” ์ง„ํ•ด์ง€๋ฉฐ, ์ธ์‹ ์ž˜ ๋œ ๋“ฏ ํ•จ. ์ž˜๋Œ์•„๊ฐ.

ORA-12514 ์˜ค๋ฅ˜ ๋ฐœ์ƒ

dbeaver ๋น„๋ฒ„๋ž‘ oracle์˜ hr์œ ์ €๋ž‘ ์—ฐ๊ฒฐํ•˜๋Š” ๋„์ค‘ ๋ฐœ์ƒํ•œ. ์•„๋งˆ๋„, listener๊ฐ€ ์ œ๋Œ€๋กœ ์ž‘๋™ํ•˜์ง€ ์•Š๋Š”๋‹ค๋Š”... ์ด ์นœ๊ตฌ ์ €๋ฒˆ์—๋„ ๋ดค์—ˆ๋Š”๋ฐ,,,, ๊ทธ๋•Œ ํ•ด๊ฒฐ ์–ด๋–ป๊ฒŒ ํ–ˆ์—ˆ๋”๋ผ? ๋‹ต๋‹ตํ•˜๋‹ค ์ฆ๋ง~ โ• ๋ฐฉ๋ฒ• 1 ์„œ๋น„์Šค ์˜ค๋ผํด listener ์žฌ์‹œ๋™ ํ•˜๊ธฐ ๋‹ค์‹œ ์‹œ์ž‘ ํ•˜๋ฉด ์ •์ƒ ์ž‘๋™ ์ด ๋  ์ˆ˜ ๋„ ์žˆ๋‹ค! โ• ๋ฐฉ๋ฒ• 2 lsnrctl์ด ์ •์ƒ ์ž‘๋™์ธ์ง€ ํ™•์ธ cmd> lsnrctl services cmd> lsnrctl status ๋‘˜๋‹ค ์ •์ƒ ์ž‘๋™... โ• ๋ฐฉ๋ฒ• 3 tnsnames.ora listener.ora ํ™•์ธํ•˜๊ธฐ ์‚ฌ์‹ค ์ œ์ผ ์œ ๋ ฅํ•˜๋‹ค... ์—ฌ๊ธฐ oracle์— ๋‹ค๋ฅธ ๊ฒƒ ๋ถ™์—ฌ๋ณด๊ฒ ๋‹ค๊ณ  ์ด๊ฑฐ ์ˆ˜์ •ํ–ˆ๋˜ ๊ธฐ์–ต์ด ๋‚œ๋‹ค ๐Ÿคฆโ€โ™‚๏ธ๐Ÿคฆโ€โ™‚๏ธ ๋‚˜์˜ ๊ฒฝ๋กœ : C:\oraclexe\app\oracle\product\11.2.0..

[filezila] ์—ฐ๊ฒฐ ์ „์†ก ์˜ค๋ฅ˜ ๋ฐฉํ™”๋ฒฝ ์—ด์–ด์ฃผ๊ธฐ

์ง€๊ฒจ์šด filezila ๋‚˜ํ•œํ…Œ ์›ํ•˜๋Š”๊ฒŒ ๋ญ๋ƒ ใ…  ๋ฐฉํ™”๋ฒฝ ํฌํŠธ๋„ 20,21 ์—ด์–ด ์ฃผ์—ˆ๊ณ , ํ˜น์‹œ ๋ชฐ๋ผ ftp.exe ํŒŒ์ผ๋„ ์—ด์–ด์ค€๋‹ค! ์ƒˆ๊ทœ์น™>ํ”„๋กœ๊ทธ๋žจ > ftp.exe ์„ค์ •. ์ œ๋ฐœ plz.. ์šฐ๋ฆฌ ์นœํ•˜๊ฒŒ ์ง€๋‚ด์ž! ํŒŒ์ผ์งˆ๋ผ์•ผ!