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

oracle3

(ORA-01109) ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค๊ฐ€ ๊ฐœ๋ฐฉ๋˜์ง€ ์•Š์Šต๋‹ˆ๋‹ค. ๐Ÿถ ์—๋Ÿฌ ๐Ÿถ ๋‚ด์šฉ๐Ÿฅต ์ธ์Šคํ„ด์Šค๋Š” ์‹œ์ž‘๋˜์—ˆ์ง€๋งŒ ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค๊ฐ€ ์•„์ง open๋˜์ง€ ์•Š์•˜๊ธฐ ๋•Œ๋ฌธ์— SQL์„ ์ˆ˜ํ–‰ํ•  ์ˆ˜ ์—†๋Š” ์ƒํƒœ์ธ์Šคํ„ด์Šค๋Š” ์‹œ์ž‘๋˜์–ด ์žˆ์Œํ•˜์ง€๋งŒ DB๋Š” MOUNT ๋‹จ๊ณ„OPEN ๋ช…๋ น์„ ์•ˆ ํ•ด์„œ ์‚ฌ์šฉ ๋ถˆ๊ฐ€ ์ƒํƒœ ๐Ÿถ ์กฐ์น˜๐Ÿšฉ sqlplus / as sysdba โœ”๏ธ ๋‹จ์ผ ์ธ์Šคํ„ด์Šค ์ƒํƒœ ์กฐํšŒ (OPEN ์ƒํƒœ)SQL > SELECT status FROM v$instance;SQL > ALTER DATABASE OPEN; โœ”๏ธ (PDB) ์ƒํƒœ ์กฐํšŒ (ORCLPDB - MOUNT ์ƒํƒœ)SQL > SELECT name, open_mode, restricted FROM v$pdbs;SQL > ALTER PLUGGABLE DATABASE ORCLPDB OPEN; ๐Ÿšฉ ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค OPEN ํ™•์ธ 2025. 5. 30.
(ORA-12560) TNS:ํ”„๋กœํ† ์ฝœ ์–ด๋Œ‘ํ„ฐ ์˜ค๋ฅ˜ ๐Ÿถ ์—๋Ÿฌ ๐Ÿถ ๋‚ด์šฉ๐Ÿฅต sqlplus ์ ‘์† ์‹œ ์—๋Ÿฌ ๋ฐœ์ƒ ( sqlplus / as sysdba ) Oracle ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค์— ์ ‘์† ์‹œ๋„ ์ค‘ ๋ฐœ์ƒํ•˜๋Š” ๋„คํŠธ์›Œํฌ ๊ณ„์ธต์˜ ๋ฌธ์ œ ์ฃผ๋กœ ํด๋ผ์ด์–ธํŠธ๊ฐ€ ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค ์„œ๋ฒ„์— ์ ‘์†ํ•˜์ง€ ๋ชปํ–ˆ์„ ๋•Œ ๋ฐœ์ƒ Windows์—์„œ Oracle์„ ์‚ฌ์šฉ ์ค‘์ด๋ผ๋ฉด, OracleService๊ณผ TNS Listener๊ฐ€ ์‹คํ–‰ ์ค‘์ด์–ด์•ผ ํ•œ๋‹ค.โœ”๏ธ ํ™•์ธํ•ด ๋ณธ ๊ฒฐ๊ณผ ํ•ด๋‹น 2๊ฐœ์˜ ์„œ๋น„์Šค๊ฐ€ ์‹คํ–‰๋˜์ง€ ์•Š๊ณ  ์žˆ์—ˆ๋‹ค. ๐Ÿถ ์กฐ์น˜๐Ÿšฉ ์„œ๋น„์Šค ์‹คํ–‰ 11. ๊ฒ€์ƒ‰ > services.msc ์ž…๋ ฅ2. OracleServiceORCL๊ณผ OracleOraDB19Home1TNSListener๋ฅผ ์‹œ์ž‘ ๐Ÿšฉ ์„œ๋น„์Šค ์‹คํ–‰ 2CMD > net start OracleServiceORCLCMD > net start Ora.. 2025. 5. 30.
(ORA-01741) ๊ธธ์ด๊ฐ€ 0์ธ ์‹๋ณ„์ž๋Š” ๋ถ€์ ํ•ฉํ•ฉ๋‹ˆ๋‹ค. ๐Ÿถ ์—๋Ÿฌ ORA-01741 : ๊ธธ์ด๊ฐ€ 0์ธ ์‹๋ณ„์ž๋Š” ๋ถ€์ ํ•ฉํ•ฉ๋‹ˆ๋‹ค.  ๐Ÿถ ๋‚ด์šฉ ๊ณต๋ฐฑ ๊ฐ’์„ ์Œ๋”ฐ์˜ดํ‘œ("")๋กœ ์ง€์ •ํ•˜์—ฌ ์ปฌ๋Ÿผ์„ ์กฐํšŒํ•  ๋•Œ ๋ฐœ์ƒ  ๐Ÿถ ์กฐ์น˜ ์‹ฑ๊ธ€์ฟผํ„ฐ('')๋กœ ์ˆ˜์ •ํ•˜์—ฌ ์กฐํšŒํ•œ๋‹ค. ์—๋Ÿฌ : SELECT "" AS TEMP_COL FROM DUAL์กฐ์น˜ : SELECT '' AS TEMP_COL FROM DUAL 2024. 11. 24.

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