/
[MIP-303] system fail ์‹œ ๋ฆฌ์†Œ์Šค restart๊ฐ€ ๋จผ์ € ๋˜์–ด system failover๊ฐ€ ์•ˆ๋˜๋Š” ํ˜„์ƒ

[MIP-303] system fail ์‹œ ๋ฆฌ์†Œ์Šค restart๊ฐ€ ๋จผ์ € ๋˜์–ด system failover๊ฐ€ ์•ˆ๋˜๋Š” ํ˜„์ƒ

Subject
system fail ์‹œ ๋ฆฌ์†Œ์Šค restart๊ฐ€ ๋จผ์ € ๋˜์–ด system failover๊ฐ€ ์•ˆ๋˜๋Š” ํ˜„์ƒ

APPLIES TO:
MCCS 3.1
Windows 2008 STD SP1




SYMPTOMS
1๋ฒˆ์„œ๋ฒ„์—์„œ 18:17:04 ์— ์‹œ์Šคํ…œ์˜ ์˜ˆ๊ธฐ์น˜ ์•Š์€ ์ข…๋ฃŒ๊ฐ€ ๋ฐœ์ƒํ–ˆ์—ˆ๊ณ (๋ธ”๋ฃจ์Šคํฌ๋ฆฐ), dumpํŒŒ์ผ ์ƒ์„ฑ๊นŒ์ง€ ๋˜์—ˆ์Šต๋‹ˆ๋‹ค.
ํ•ด๋‹นํ•˜๋Š” 1๋ฒˆ์„œ๋ฒ„์—์„œ ์•„๋ž˜์™€ ๊ฐ™์€ MCCS๋กœ๊ทธ๊ฐ€ ํ™•์ธ๋˜์—ˆ์œผ๋ฉฐ ์ด ์ง ํ›„ ์‹œ์Šคํ…œ์ด ๋ฆฌ๋ถ€ํŒ…๋˜์—ˆ์Šต๋‹ˆ๋‹ค.
์˜ค๋ผํด ์„œ๋น„์Šค๊ฐ€ ์žฌ์‹œ์ž‘๋œ ๊ฒƒ ๊ฐ™์€๋ฐ ์‹ค์ œ ํ•ด๋‹น์‹œ์ ์— 1๋ฒˆ์„œ๋ฒ„ Application log๋ฅผ ๋ณด๋ฉด ์˜ค๋ผํด์„œ๋น„์Šค๊ฐ€
์‹œ์ž‘๋˜์—ˆ๋‹ค๋Š” ๊ฒƒ์— ๋Œ€ํ•œ ๋กœ๊ทธ๊ฐ€ ์—†์Šต๋‹ˆ๋‹ค.




CAUSE

oracle์ด ์„œ๋น„์Šค๊ฐ€ ์ฃฝ์–ด์„œ MCCS๊ฐ€ ๋‹ค์‹œ ๋˜์‚ด๋ฆฌ๋ ค๋Š” ๊ฒƒ์ด ์•„๋‹ˆ๋ผ
oracle์€ ๋ฉ€์ฉกํ•œ๋ฐ mccs์˜ ๋ชจ๋‹ˆํ„ฐ๋ง์ด ์ž˜๋ชป๋˜์–ด์„œ ์ฃฝ์€ ๊ฒƒ์œผ๋กœ ์ฒ˜๋ฆฌ๋ฅผ ํ•ฉ๋‹ˆ๋‹ค.
๋”ฐ๋ผ์„œ oracle์ด ์‹คํ–‰๋˜์–ด ์žˆ๋Š”๋ฐ ๋˜ oracle์„ ์‹คํ–‰์‹œํ‚ค๋ ค๊ณ  ๋‚˜์˜จ ๊ฒƒ์ž…๋‹ˆ๋‹ค.
OracleService resource online result : 4294967290
์˜ ์˜๋ฏธ๋Š” ํŠน๋ณ„ํ•œ ์˜๋ฏธ๋Š” ์•„๋‹™๋‹ˆ๋‹ค. batch ํŒŒ์ผ ์‹คํ–‰ ๊ฒฐ๊ณผ๊ฐ’์„ ์‹ ๋ขฐํ•  ์ˆ˜ ์—†๋Š” ์ด์ƒํ•œ ๊ฐ’์ด ๋‚˜์˜ฌ๋•Œ ๋ฐœ์ƒํ•ฉ๋‹ˆ๋‹ค.
์—ฌ๊ธฐ์„œ batch๋Š” monitoring์„ ์œ„ํ•œ batch ํŒŒ์ผ์ž…๋‹ˆ๋‹ค.
MCCS ์ตœ์‹  ๋ฒ„์ „์œผ๋กœ update ํ•ด์ฃผ์‹œ๋ฉด ๋ฉ๋‹ˆ๋‹ค.



SOLUTION
MCCS ์ตœ์‹  ๋ฒ„์ „์œผ๋กœ update ํ•ด์ฃผ์‹œ๋ฉด ๋ฉ๋‹ˆ๋‹ค.
Fixed MCCS 3.2

ย 

Related content

[MIP-164] MCCS ๋…ธ๋“œ๊ฐ„ ์ƒํƒœํ™•์ธ ๋ถˆ๊ฐ€
[MIP-164] MCCS ๋…ธ๋“œ๊ฐ„ ์ƒํƒœํ™•์ธ ๋ถˆ๊ฐ€
More like this
[MIP-276] service failover๊ฐ€ ๋˜์ง€ ์•Š๋Š” ํ˜„์ƒ
[MIP-276] service failover๊ฐ€ ๋˜์ง€ ์•Š๋Š” ํ˜„์ƒ
More like this
[MIP-182] mccs์—์„œ ๋“ฑ๋ก๋œ process fail ํ›„ failover ๋ฅผ ํ•˜์ง€ ๋ชปํ•จ
[MIP-182] mccs์—์„œ ๋“ฑ๋ก๋œ process fail ํ›„ failover ๋ฅผ ํ•˜์ง€ ๋ชปํ•จ
More like this
[MIP-580] ์œˆ๋„์šฐ์ฆˆ ์„œ๋น„์Šค ์‹œ์ž‘ ์‹œ MCCS ์„œ๋ฒ„ ์ข…๋ฃŒ๋จ
[MIP-580] ์œˆ๋„์šฐ์ฆˆ ์„œ๋น„์Šค ์‹œ์ž‘ ์‹œ MCCS ์„œ๋ฒ„ ์ข…๋ฃŒ๋จ
More like this
[MIP-567] ์šด์˜์„œ๋ฒ„ ์žฌ ๋ถ€ํŒ…์‹œ Failover ์‹คํŒจ
[MIP-567] ์šด์˜์„œ๋ฒ„ ์žฌ ๋ถ€ํŒ…์‹œ Failover ์‹คํŒจ
More like this
[MIP-613] ํŽ˜์ผ์˜ค๋ฒ„ ์ค‘ ์žฅ์•  ๋ฆฌ์†Œ์Šค ์žฌ ์‹œ์ž‘์œผ๋กœ ์ธํ•œ ํŽ˜์ผ์˜ค๋ฒ„ ์‹คํŒจ
[MIP-613] ํŽ˜์ผ์˜ค๋ฒ„ ์ค‘ ์žฅ์•  ๋ฆฌ์†Œ์Šค ์žฌ ์‹œ์ž‘์œผ๋กœ ์ธํ•œ ํŽ˜์ผ์˜ค๋ฒ„ ์‹คํŒจ
More like this