20180418 ์˜ค๋ผํด ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค ์ ‘์† ์—๋Ÿฌ

๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค 2018. 4. 18. 08:26
  1. IO ์˜ˆ์™ธ ์ƒํ™ฉ : The Network Adapter could not establish the connection ์—…์ฒด์ฝ”๋“œ 17002
    1. ํ•ด๊ฒฐ๋งํฌ ํด๋ฆญ
  2. Listener refused the connection with the following error : ORA-12505, TNS: listener does not currently know of SID given in connect descriptor
    1. ํ•ด๊ฒฐ๋งํฌ ํด๋ฆญ


1๋ฒˆ์˜ ๋ฌธ์ œ๋Š” ์‹คํ–‰์ฐฝ์—์„œ services.msc ๋ฅผ ์‹คํ–‰ํ•˜์—ฌ ๋กœ์ปฌ ์„œ๋น„์Šค ํ”„๋กœ๊ทธ๋žจ์—์„œ ๋‘ ๊ฐ€์ง€๊ฐ€ ์‹คํ–‰์ด ๋˜์ง€ ์•Š์•˜๊ธฐ ๋•Œ๋ฌธ์— ๋ฐœ์ƒํ•˜๋Š” ๋ฌธ์ œ์ด๋‹ค.

  • OracleServiceXE ์„œ๋น„์Šค ์‹œ์ž‘
  • OracleXETNSListener ์„œ๋น„์Šค ์‹œ์ž‘
2๋ฒˆ์˜ ๋ฌธ์ œ๋Š” ๋ฆฌ์Šค๋„ˆ ์ ‘๊ทผ ๊ฑฐ๋ถ€ ์—๋Ÿฌ์ด๋‹ค. cmd ์ฐฝ์„ ํ‚ค๊ณ  lsnrctl services ๋ฅผ ์ž…๋ ฅ. ์ž์„ธํ•œ ์‚ฌํ•ญ์€ ํ•ด๊ฒฐ๋ฆฌํฌ ์ฐธ์กฐ.


์ €์ž‘์žํ‘œ์‹œ ๋น„์˜๋ฆฌ ๋ณ€๊ฒฝ๊ธˆ์ง€

'๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค' ์นดํ…Œ๊ณ ๋ฆฌ์˜ ๋‹ค๋ฅธ ๊ธ€

20180702 Oracle 11g ์„ค์น˜๊ด€๋ จ ์ด์Šˆ  (4) 2018.07.02
20180520 MySQL : DB ๋ฐ ์‚ฌ์šฉ์ž ์ƒ์„ฑ, ๊ถŒํ•œ์„ค์ •  (0) 2018.05.20
20180308 ์˜ค๋ผํด ๋ฒ„์ „ ํ™•์ธ, ์˜ตํ‹ฐ๋งˆ์ด์ € ์ ‘๊ทผ ๊ฒฝ๋กœ (Scan ์ข…๋ฅ˜)  (0) 2018.03.08
20180227 ์˜ค๋ผํด ์ €์žฅ ๊ณ„์ธต ๊ตฌ์กฐ  (0) 2018.02.27
20180226 Fetch Call  (0) 2018.02.26
Posted by doubler
,

ํ‹ฐ์Šคํ† ๋ฆฌํˆด๋ฐ”