From Dev.to Community
Tech Articles
Curated developer articles, tutorials, and guides โ auto-updated hourly
Ranjith Kumar KondojuMay 22, 2026 โข 13 min read
I Built an Oracle DBA That Lives in Telegram. It Cut a 500K-Row Scan to 5 โ After Asking Permission.
An AI agent that diagnoses slow Oracle queries, proposes index fixes, and asks before touching produ...
#hermeschallenge#hermesagent#agents#oracle
6 2
Rick HoulihanMay 26, 2026 โข 19 min read
You Cannot Outrun a Wave
How a small family business, an AI, and a weekend in the Hill Country ended up running...
#ai#cloud#infrastructure#oracle
0 0
Allan BontempoMay 27, 2026 โข 6 min read
Race-Condition: How a Single SQL Line Eliminated 100 Lines of Retry and Lock Code
hat "rare" bug that looks intermittent but is actually deterministic. It is just waiting for your...
#java#oracle#concurrency#backend
0 0
umzzil nngMay 29, 2026 โข 2 min read
Oracle ORA-00022 ์ค๋ฅ ์์ธ๊ณผ ํด๊ฒฐ ๋ฐฉ๋ฒ ์๋ฒฝ ๊ฐ์ด๋
ORA-00022 invalid session ID ๋? ORA-00022 ์๋ฌ๋ Oracle ๋ฐ์ดํฐ๋ฒ ์ด์ค์์ ์ธ์ ID๊ฐ ์ ํจํ์ง ์์ ๋ ๋ฐ์ํ๋ ์ค๋ฅ์ ๋๋ค....
#oracle#database#dba#sql
0 0
umzzil nngMay 24, 2026 โข 2 min read
ORA-00203 ์ค๋ฅ ์์ธ๊ณผ ํด๊ฒฐ ๋ฐฉ๋ฒ ์๋ฒฝ ๊ฐ์ด๋
ORA-00203: using the wrong control files ์๋ฒฝ ํด๊ฒฐ ๊ฐ์ด๋ ORA-00203๋? ORA-00203์...
#oracle#ora00203#ora#dba
0 0
FinnMay 26, 2026 โข 4 min read
Introducing Oracle Support in Dory
Introducing Oracle Support in Dory Dory now supports Oracle Database. If your team keeps...
#ai#database#sql#oracle
0 0
umzzil nngMay 24, 2026 โข 2 min read
ORA-00205 ์ค๋ฅ ์์ธ๊ณผ ํด๊ฒฐ ๋ฐฉ๋ฒ ์๋ฒฝ ๊ฐ์ด๋
ORA-00205๋? ORA-00205๋ Oracle ๋ฐ์ดํฐ๋ฒ ์ด์ค๊ฐ ์์(STARTUP) ๊ณผ์ ์์ ์ปจํธ๋กค ํ์ผ(Control File)์ ์๋ณํ๊ฑฐ๋ ์ด์ง ๋ชปํ ๋...
#oracle#ora00205#ora#dba
0 0
umzzil nngMay 24, 2026 โข 2 min read
ORA-00202 ์ค๋ฅ ์์ธ๊ณผ ํด๊ฒฐ ๋ฐฉ๋ฒ ์๋ฒฝ ๊ฐ์ด๋
ORA-00202๋? ORA-00202 ์๋ฌ๋ Oracle ๋ฐ์ดํฐ๋ฒ ์ด์ค๊ฐ ์ปจํธ๋กค ํ์ผ(Control File)์ ์ ๊ทผํ๋ ค๊ณ ํ ๋ ํด๋น ํ์ผ์ ์ฌ์ฉํ ์ ์๋...
#oracle#ora00202#ora#dba
0 0
umzzil nngMay 22, 2026 โข 2 min read
ORA-00057 ์ค๋ฅ ์์ธ๊ณผ ํด๊ฒฐ ๋ฐฉ๋ฒ ์๋ฒฝ ๊ฐ์ด๋
ORA-00057๋? ORA-00057์ Oracle ๋ฐ์ดํฐ๋ฒ ์ด์ค์์ ์์ ํ ์ด๋ธ(Temporary Table)์ ๋ํ ์ ๊ธ(Lock) ์๊ฐ ์์คํ ์์ ํ์ฉํ๋...
#oracle#ora00057#ora#dba
0 0
umzzil nngMay 25, 2026 โข 2 min read
ORA-00207 ์ค๋ฅ ์์ธ๊ณผ ํด๊ฒฐ ๋ฐฉ๋ฒ ์๋ฒฝ ๊ฐ์ด๋
ORA-00207: ์ค๋ฌด DBA๋ฅผ ์ํ ์๋ฒฝ ๊ฐ์ด๋ ORA-00207๋? ORA-00207์ Oracle ๋ฐ์ดํฐ๋ฒ ์ด์ค๊ฐ...
#oracle#ora00207#ora#dba
0 0
umzzil nngMay 22, 2026 โข 2 min read
ORA-00060 ์ค๋ฅ ์์ธ๊ณผ ํด๊ฒฐ ๋ฐฉ๋ฒ ์๋ฒฝ ๊ฐ์ด๋
ORA-00060๋? ORA-00060์ Oracle ๋ฐ์ดํฐ๋ฒ ์ด์ค์์ ๋ ๊ฐ ์ด์์ ์ธ์ ์ด ์๋ก ์๋๋ฐฉ์ด ๋ณด์ ํ ๋ฆฌ์์ค(์ฃผ๋ก ํ ์ด๋ธ ํ ์ ๊ธ)๋ฅผ ๊ธฐ๋ค๋ฆฌ๋ ๊ต์ฐฉ...
#oracle#ora00060#ora#dba
0 0
umzzil nngMay 26, 2026 โข 2 min read
ORA-00227 ์ค๋ฅ ์์ธ๊ณผ ํด๊ฒฐ ๋ฐฉ๋ฒ ์๋ฒฝ ๊ฐ์ด๋
ORA-00227๋? ORA-00227์ Oracle ๋ฐ์ดํฐ๋ฒ ์ด์ค๊ฐ ์ปจํธ๋กค ํ์ผ(Control File)์ ์ฝ๋ ๊ณผ์ ์์ ๋ธ๋ก ์์(Corruption)์...
#oracle#ora00227#ora#dba
0 0
umzzil nngMay 22, 2026 โข 2 min read
ORA-00064 ์ค๋ฅ ์์ธ๊ณผ ํด๊ฒฐ ๋ฐฉ๋ฒ ์๋ฒฝ ๊ฐ์ด๋
ORA-00064: object is too large to allocate on this OS 30๋ ๊ฒฝ๋ ฅ Oracle DBA์ ์ค๋ฌด ๊ฒฝํ์ ๋ฐํ์ผ๋ก ์์ฑํ...
#oracle#ora00064#ora#dba
0 0
umzzil nngMay 23, 2026 โข 2 min read
ORA-00201 ์ค๋ฅ ์์ธ๊ณผ ํด๊ฒฐ ๋ฐฉ๋ฒ ์๋ฒฝ ๊ฐ์ด๋
ORA-00201๋? ORA-00201 ์๋ฌ๋ "control file version incompatible with ORACLE version", ์ฆ ์ปจํธ๋กค...
#oracle#ora00201#ora#dba
0 0
umzzil nngMay 23, 2026 โข 2 min read
ORA-00072 ์ค๋ฅ ์์ธ๊ณผ ํด๊ฒฐ ๋ฐฉ๋ฒ ์๋ฒฝ ๊ฐ์ด๋
ORA-00072๋? ORA-00072 ์๋ฌ๋ "process is not active"๋ผ๋ ๋ฉ์์ง์ ํจ๊ป ๋ฐ์ํ๋ฉฐ, Oracle์ด ํน์ ํ๋ก์ธ์ค์ ์ ๊ทผํ๊ฑฐ๋...
#oracle#ora00072#ora#dba
0 0
umzzil nngMay 25, 2026 โข 2 min read
ORA-00211 ์ค๋ฅ ์์ธ๊ณผ ํด๊ฒฐ ๋ฐฉ๋ฒ ์๋ฒฝ ๊ฐ์ด๋
ORA-00211: control file does not match previous control files Oracle ๋ฐ์ดํฐ๋ฒ ์ด์ค ์ด์ ํ์ฅ์์ ๋ง์ฃผ์น๋ฉด...
#oracle#ora00211#ora#dba
0 0
Amaan Ul Haq SiddiquiMay 22, 2026 โข 3 min read
I Got Tired of Passing --profile on Every OCI CLI Command
This is a problem you only run into if you work for Oracle directly or you work at a Cloud/DevOps MS...
#cli#infrastructure#oracle#linux
0 0
umzzil nngMay 27, 2026 โข 2 min read
ORA-00250 ์ค๋ฅ ์์ธ๊ณผ ํด๊ฒฐ ๋ฐฉ๋ฒ ์๋ฒฝ ๊ฐ์ด๋
ORA-00250๋? ORA-00250 ์๋ฌ๋ Oracle ๋ฐ์ดํฐ๋ฒ ์ด์ค์์ ์์นด์ด๋ฒ(Archiver) ํ๋ก์ธ์ค๊ฐ ์์๋์ง ์์ ์ํ์์ ์์นด์ด๋ธ ๊ด๋ จ ์์ ์...
#oracle#ora00250#ora#dba
0 0
umzzil nngMay 26, 2026 โข 2 min read
ORA-00221 ์ค๋ฅ ์์ธ๊ณผ ํด๊ฒฐ ๋ฐฉ๋ฒ ์๋ฒฝ ๊ฐ์ด๋
ORA-00221๋? ORA-00221์ Oracle ๋ฐ์ดํฐ๋ฒ ์ด์ค๊ฐ ์ปจํธ๋กค ํ์ผ(Control File)์ ์ฐ๊ธฐ ์์ ์ ์ํํ๋ ๋์ค ์ค๋ฅ๊ฐ ๋ฐ์ํ์ ๋ ๋ํ๋๋...
#oracle#ora00221#ora#dba
0 0
umzzil nngMay 28, 2026 โข 2 min read
Oracle ORA-00020 ์ค๋ฅ ์์ธ๊ณผ ํด๊ฒฐ ๋ฐฉ๋ฒ ์๋ฒฝ ๊ฐ์ด๋
ORA-00020 maximum number of processes exceeded ๋? ORA-00020 ์๋ฌ๋ Oracle ๋ฐ์ดํฐ๋ฒ ์ด์ค ์ธ์คํด์ค์ ์ฐ๊ฒฐ ๊ฐ๋ฅํ...
#oracle#database#dba#sql
0 0
umzzil nngMay 27, 2026 โข 2 min read
ORA-00255 ์ค๋ฅ ์์ธ๊ณผ ํด๊ฒฐ ๋ฐฉ๋ฒ ์๋ฒฝ ๊ฐ์ด๋
ORA-00255๋? ORA-00255๋ Oracle ๋ฐ์ดํฐ๋ฒ ์ด์ค๊ฐ ์์นด์ด๋ธ ๋ก๊ทธ ํ์ผ์ ๊ธฐ๋กํ๋ ค๋ ๊ณผ์ ์์ ์คํจํ์ ๋ ๋ฐ์ํ๋ ์๋ฌ์ ๋๋ค. ARCHIVELOG...
#oracle#ora00255#ora#dba
0 0
umzzil nngMay 25, 2026 โข 2 min read
ORA-00206 ์ค๋ฅ ์์ธ๊ณผ ํด๊ฒฐ ๋ฐฉ๋ฒ ์๋ฒฝ ๊ฐ์ด๋
ORA-00206๋? ORA-00206์ Oracle ๋ฐ์ดํฐ๋ฒ ์ด์ค๊ฐ ์ปจํธ๋กค ํ์ผ(Control File)์ ๋ฐ์ดํฐ๋ฅผ ์ฐ๋ ๋์ค ์ค๋ฅ๊ฐ ๋ฐ์ํ์ ๋ ๋ํ๋๋...
#oracle#ora00206#ora#dba
0 0
umzzil nngMay 26, 2026 โข 2 min read
ORA-00215 ์ค๋ฅ ์์ธ๊ณผ ํด๊ฒฐ ๋ฐฉ๋ฒ ์๋ฒฝ ๊ฐ์ด๋
ORA-00215๋? ORA-00215 ์๋ฌ๋ Oracle ๋ฐ์ดํฐ๋ฒ ์ด์ค๊ฐ ์์(STARTUP) ๋๋ ๋ง์ดํธ(MOUNT) ๊ณผ์ ์์ ์ ํจํ ์ปจํธ๋กค ํ์ผ(Control...
#oracle#ora00215#ora#dba
0 0
umzzil nngMay 23, 2026 โข 2 min read
ORA-00200 ์ค๋ฅ ์์ธ๊ณผ ํด๊ฒฐ ๋ฐฉ๋ฒ ์๋ฒฝ ๊ฐ์ด๋
ORA-00200: Control File Could Not Be Created ์๋ฒฝ ํด๊ฒฐ ๊ฐ์ด๋ ...
#oracle#ora00200#ora#dba
0 0