_๋Œ€๋ฌธ | ๋ฐฉ๋ช…๋ก | ์ตœ๊ทผ๊ธ€ | ํ™ˆํ”ผ์†Œ๊ฐœ | ์ฃผ์ธ๋†ˆ
FrontPage › ์˜ค๋ฅ˜์—๋Œ€ํ•œ์›์ธ๋ฐ์กฐ์น˜๋ฐฉ๋ฒ•
>oerr ora n 

----- 
ํ˜„์ƒ : Oracle Stored Procedure ํ˜ธ์ถœ์ด ์ œ๋Œ€๋กœ ๋˜์ง€ ์•Š์Œ 
์›์ธ : Stored Procedure์— ์ž…์ถœ๋ ฅ๋˜๋Š” VARCHAR ๋ณ€์ˆ˜์˜ ์ดˆ๊ธฐํ™”๊ฐ€ ๋˜์ง€ ์•Š์Œ 
์กฐ์น˜ : Stored Procedure ์ž…๋ ฅ, ์ถœ๋ ฅ VARCHAR ๋ณ€์ˆ˜์˜ Length๋ฅผ ๋ฐ˜๋“œ์‹œ ์„ค์ • 
(TMS์— ๋ฌธ์ œ๋ฅผ ์ผ์œผํ‚ค๋Š” ๊ฒƒ์œผ๋กœ ๋ณด์ž„) 
----- 
ํ˜„์ƒ : exec TMS_ORACLE7 -A: Failed. 
์›์ธ : ORACLE์—์„œ DB ์‚ฌ์šฉ์ž์—๊ฒŒ GRANT(์‚ฌ์šฉํ—ˆ๊ฐ€๊ถŒ)๊ฐ€ ์—†์–ด์„œ ๋ฐœ์ƒํ•˜๋Š” ๋ฌธ์ œ์ž„. 
ORACLE LIB์—์„œ ๋ฌธ์ œ๊ฐ€ ์ƒ๊ธธ ์ˆ˜๋„ ์žˆ๋‹ค. 
์กฐ์น˜ : ORACLE์˜ VIEW์ค‘์— V$XATRANS$๋ผ๋Š” VIEW๋ฅผ GRANT์‹œ์ผœ์ฃผ๋ฉด ์กฐ์น˜๋จ. 
ORACLE์˜ DBA๊ถŒํ•œ์—์„œ ์‹คํ–‰๊ฐ€๋Šฅํ•จ. 
๋ฐฉ๋ฒ•: grant all on V$XATRANS$ TO SCRJPCS 
์—ฌ๊ธฐ์„œ SCRJPCS๋Š” DB USER-ID์ž„. 
----- 
ํ˜„์ƒ : DataBase์— ์—ฐ๊ฒฐํ•˜์ง€ ๋ชปํ•œ๋‹ค. 
์›์ธ : 1.ํ•ด๋‹น DataBase์— ํ•„์š”ํ•œ ํ™˜๊ฒฝ ์„ค์ •์ด ์ž˜๋ชป๋˜์–ด ์žˆ๋‹ค.(INVAL Error๋ฐœ์ƒ) 
2.ํ™˜๊ฒฝ ํŒŒ์ผ์— ํ™˜๊ฒฝ ์„ค์ •์ด ์ž˜๋ชป๋˜์–ด ์žˆ๋‹ค.(INVAL Error) 
3.DataBase์— ๊ถŒํ•œ์ด ์—†๋‹ค. 
4.DataBase๊ฐ€ ๊ธฐ๋™๋˜์ง€ ์•Š์•˜๋‹ค. 
์กฐ์น˜ : 1.set ๋ช…๋ น์œผ๋กœ ํ•„์š”ํ•œ ํ™˜๊ฒฝ๋ณ€์ˆ˜ ์„ค์ •์„ ํ™•์ธํ•œ๋‹ค. 
- Oracle : ORACLE_HOME, ORACLE_SID, ORA_NLS 
- Informix : INFORMIXDIR, INFORMIXSERVER 
2.๊ตฌ์„ฑํŒŒ์ผ์— ์„ค์ •๋˜์–ด ์žˆ๋Š” ENVFILE์„ ํ™•์ธํ•œ๋‹ค. 
3.ํ•ด๋‹น User์—๊ฒŒ DataBase ๊ถŒํ•œ์„ ๋ถ€์—ฌํ•œ๋‹ค. 
- ORACLE : "v$xatrans$"๋ผ๋Š” VIEW์— ๋Œ€ํ•˜์—ฌ ํ•ด๋‹น User์—๊ฒŒ ๊ถŒํ•œ์„ ๋ถ€์—ฌํ•œ๋‹ค. 
- INFORMIN : ํ•ด๋‹น DB๋ฅผ ์‚ฌ์šฉํ•  ์ˆ˜ ์žˆ๋Š” ๊ถŒํ•œ์„ User์—๊ฒŒ ๋ถ€์—ฌํ•œ๋‹ค. 
4.DataBase๋ฅผ ๊ธฐ๋™ํ•˜๊ณ  Server๋ฅผ ์ƒˆ๋กœ ๋„์šด๋‹ค. 
----- 
ํ˜„์ƒ : LINE/COL ERROR 
-------- ----------------------------------------------------------------- 
0/0 PLS-00801: Message 801 not found; product=PLSQL; facility=PCM 
22/9 PL/SQL: SQL Statement ignored 
28/17 PLS-00201: identifier 'JWONRYO.JWONMAS' must be declared 
62/9 PL/SQL: SQL Statement ignored 
์›์ธ : ํ˜„ Database์˜ Domain ๋ฐ–์— ์žˆ๋Š” Table์„ Handlingํ•˜๋Š” ๊ฒฝ์šฐ์— ๊ถŒํ•œ์ด ์—†๋Š” 
๊ฒฝ์šฐ์— ๋ฐœ์ƒ 
์กฐ์น˜ : ์ ‘๊ทผํ•  ์ˆ˜ ์žˆ๋Š” ๊ถŒํ•œ์„ ๋ถ€์—ฌํ•œ๋‹ค. 
----- 
ํ˜„์ƒ : LINE/COL ERROR 
-------- ----------------------------------------------------------------- 
135/5 PL/SQL: Statement ignored 
135/9 PLS-00365: 'AVSQLCODE' is an OUT parameter and cannot be read 
์›์ธ : OUT parameter๋ฅผ IN parameter๋กœ ์‚ฌ์šฉํ•˜๊ณ  ๊ทธ ๊ฐ’์„ ์ฝ์€ ๊ฒฝ์šฐ. 
์กฐ์น˜ : OUT parameter๋ฅผ IN OUT parameter๋กœ ์„ ์–ธ. 
----- 
ํ˜„์ƒ : ORA-0020 
์›์ธ : ํ”„๋กœ์„ธ์Šค ์ˆ˜๋ฅผ ํ”„๋กœ์„ธ์Šค๋ฅผ ์ดˆ๊ณผํ•œ ๊ฒฝ์šฐ. 
์กฐ์น˜ : ํ”„๋กœ์„ธ์Šค ์ˆ˜๋ฅผ ๋“ค์—ฌ์คŒ. 
----- 
ํ˜„์ƒ : ORA-00023: session references process's private memory; cannot detach session 
์›์ธ : XA library๋ฅผ ์‚ฌ์šฉํ•˜๋Š”๋ฐ Oracle์ด dedicator server๋กœ ์„ค์น˜๋œ ๊ฒฝ์šฐ ๋ฐœ์ƒ 
์กฐ์น˜ : XA library๋ฅผ ์‚ฌ์šฉํ• ๋ ค๋ฉด Oracle์„ MTS mode๋กœ ์„ค์น˜๋˜์–ด์•ผ ํ•œ๋‹ค. 
----- 
ํ˜„์ƒ : 1.ORA-0054 resource busy and acquire with NOWAIT specified 
2.ORA-0054 WHEN DROP A TABLE(SESSION KILL) 
์›์ธ : 1.Oracle ์‚ฌ์šฉ์ž๊ฐ€ ์–ด๋–ค Row์„ Lock๋ฅผ ํ–ˆ๋Š”๋ฐ, ๋‹ค๋ฅธ Oracle ์‚ฌ์šฉ์ž๊ฐ€ NOWAIT๋ฌธ์„ ์ด์šฉํ•˜์—ฌ 
๋™์ผํ•œ Row๋ฅผ Lock๋ฅผ ํ•œ ๊ฒฝ์šฐ์— ๋ฐœ์ƒ 
2.TABLE์— LOCK์ด ๊ฑธ๋ ค DML ๋ฐ DDL ๋ช…๋ น ์‚ฌ์šฉ์‹œ 
์กฐ์น˜ : LOCK์„ ๊ฑธ๊ณ ์žˆ๋Š” SESSION๋“ค์„ KILL 
----- 
ํ˜„์ƒ : ORA-0059 
์›์ธ : DB_FILES ๊ฐ’์— ๋„๋‹ฌํ•œ ๊ฒฝ์šฐ 
์กฐ์น˜ : init.ora ์˜ DB_FILES ๋ฅผ ๋Š˜๋ ค์ฃผ๊ณ  DB ๋ฅผ Restartup ํ•˜๋ฉด ํ•ด๊ฒฐ 
----- 
ํ˜„์ƒ : ORA-00210: cannot open control file '/dev/vx/rdsk/oracle/v_ctl1' 
ORA-07368: sfofi: open error, unable to open database file. 
์›์ธ : Sequent Symmetry or NUMA-Q platform์ด very large file (O/S์—์„œ 2GB 
์ด์ƒ์˜ file system ์ง€์›)์„ ์ง€์›ํ•˜๊ธฐ ์œ„ํ•ด VLFS patch๋ฅผ ์ ์šฉํ–ˆ๊ฑฐ๋‚˜ 
VLFS๋ฅผ ์ด๋ฏธ ์ง€์›ํ•˜๋Š” O/S Version์ผ ๊ฒฝ์šฐ ์˜ค๋ผํด master node๊ฐ€ ์ •์ƒ์ ์œผ๋กœ 
startup ๋˜๊ณ  ๋‚˜์„œ ๋‹ค๋ฅธ node๊ฐ€ startup parallel์ด ๋  ๋•Œ ๋จผ์ € startup ๋œ 
master node๊ฐ€ shared disk ์˜ ๋ชจ๋“  ์˜ค๋ผํด ๊ด€๋ จ file์„ 
none-shared mode๋กœ open ํ•˜๊ธฐ ๋•Œ๋ฌธ์— ์œ„์˜ ํ˜„์ƒ์ด ๋ฐœ์ƒ๋จ. 
์กฐ์น˜ : 1.PTX/Cluster V1.3.2์ผ ๊ฒฝ์šฐ 
* Oracle V7.3.x : O/S์ƒ์—์„œ VLFS patch์ ์šฉํ•˜์ง€ ์•Š์•˜์„ ๊ฒฝ์šฐ๋Š” ๊ด€๊ณ„ 
์—†์œผ๋‚˜, ์ด๋ฏธ ์ ์šฉ๋˜์—ˆ๋‹ค๋ฉด ์ถ”๊ฐ€์ ์œผ๋กœ O/S patch FP#23373 
์ ์šฉํ•˜์—ฌ์•ผ ํ•จ 
2.PTX/Cluster running DYNIX/PTX 4.4.x ์ผ ๊ฒฝ์šฐ 
* Oracle V7.3.3 : ํ˜„์žฌ fix๋œ patch๋Š” ์—†์œผ๋ฉฐ ๋‹ค์Œ๊ณผ ๊ฐ™์€ 
workaround ๋ฐฉ๋ฒ•์œผ๋กœ ํ•ด๊ฒฐ์ด ๊ฐ€๋Šฅํ•จ. 

Workaround) 
--- $ORACLE_HOME/rdbms/lib/ins_rdbms.mk file์— ์•„๋ž˜์˜ ์ถ”๊ฐ€๋œ ๋ถ€๋ถ„๋งŒ 
์‚ฝ์ž…ํ•˜์—ฌ ์˜ค๋ผํด kernel relink ์‹ค์‹œ 
(์˜ˆ:make -f ins_rdbms ioracle) 
oracle: $(ORALIBD) $(CORELIBD) $(NETLIBD) $(KSMS) $(CONFIG) 
$(PSOLIBLIST) opimai.o @$(ECHO) $(LINK) -o $@ $(LDFLAGS) 
$(LDFLAGS_ORA) opimai.o $(CONFIG) \ 
-llkseqora \ ---> ์ถ”๊ฐ€๋œ ๋ถ€๋ถ„ 
$(LLIBSERVER) $(LLIBORA) $(LLIBKNLOPT) $(LLIBSLAX) 
$(LLIBPLSQL) \ 
$(LLIBSICX) $(LLIBSOWSUTL) \ 
$(LLIBSICX) $(LLIBSOWSUTL) \ 

........... 
........... 

* Oracle V7.3.4 : 
Oracle V7.3.4 ์ผ ๊ฒฝ์šฐ๋Š” ๋ฌธ์ œ๊ฐ€ ์—†์œผ๋‚˜ patchset์„ ์ ์šฉํ•  ๊ฒฝ์šฐ 
V7.3.4.2์—์„œ๋Š” V7.3.3๊ณผ ๊ฐ™์€ ๋ฐฉ๋ฒ•์œผ๋กœ oracle kernel์„ relinkํ•˜๋ฉด 
๋ฌธ์ œ๊ฐ€ ํ•ด๊ฒฐ๋จ. 
----- 
ํ˜„์ƒ : ORA-0376 : file %s cannot be read at this time 
์›์ธ : DBF๊ฐ€ ํŒŒ์†๋จ. 
์กฐ์น˜ : Check the state of the file. Bring it online 
----- 
ํ˜„์ƒ : ORA-00376: file 29 cannot be read at this time 
ORA-01110: data file 29: '/db/GICORP_4/axix01.dbf' 
์›์ธ : datafile์˜ size๊ฐ€ os์—์„œ ํ—ˆ์šฉํ•˜๋Š” filesize๋ฅผ ์ดˆ๊ณผํ•ด์„œ ๋ฐœ์ƒ. 
์กฐ์น˜ : unix์˜ ulimit filesize๋ฅผ ํ™•์ธํ•ด ๋ณด์‹œ๊ธฐ ๋ฐ”๋ž๋‹ˆ๋‹ค. 
๊ทธ๋ฆฌ๊ณ  datafile size ๋ณด๋‹ค ํฌ๋„๋ก ์ˆ˜์ •ํ•ด ์ฃผ์–ด์•ผ ํ•ฉ๋‹ˆ๋‹ค. 
1.unix ulimit filesize๋ฅผ ์ฆ๊ฐ€ ์‹œํ‚จ๋‹ค 
C shell์ธ ๊ฒฝ์šฐ 
% limit filesize <number> 
Bourne ์ด๋‚˜ Korn shell ์ธ ๊ฒฝ์šฐ 
$ ulimit -f <number> 
2.archivelog mode์ธ์ง€ ํ™•์ธํ•ฉ๋‹ˆ๋‹ค 
SVRMGR> select * from v$database; 

NAME CREATED LOG_MODE CHECKPOINT ARCHIVE_CH 
--------- -------------------- ------------ ---------- ---------- 
GICORP 05/17/00 13:44:56 ARCHIVELOG 36290290 36284249 
1 row selected. 
3.media recovery๊ฐ€ ํ•„์š”ํ•œ datafiles๋ฅผ ์ฐพ์Šต๋‹ˆ๋‹ค 
SVRMGR> select * from v$recover_file; 

FILE# ONLINE ERROR CHANGE# TIME 
---------- ------- ------------------ ---------- -------------------- 
9 OFFLINE 36287415 12/20/00 23:30:55 
23 OFFLINE 36289350 12/21/00 08:40:54 
28 OFFLINE 36287415 12/20/00 23:30:55 
29 OFFLINE 36287415 12/20/00 23:30:55 
37 OFFLINE 36287415 12/20/00 23:30:55 
5 rows selected. 
4.๊ฐ๊ฐ์˜ datafile์— ๋Œ€ํ•ด์„œ ๋‹ค์Œ์„ ์‹คํ–‰ํ•ด ์ค๋‹ˆ๋‹ค 
SVRMGR> recover datafile '/db/GICORP_4/axix01.dbf'; 

Media recovery complete. 

SVRMGR> alter database datafile '/db/GICORP_4/axix01.dbf' ONLINE; 
Statement processed. 

5.database๋ฅผ restartํ•ฉ๋‹ˆ๋‹ค 

SVRMGR> shutdown 
Database closed. 
Database dismounted. 
ORACLE instance shut down. 
SVRMGR> startup 
ORACLE instance started. 
Total System Global Area 54578916 bytes 
Fixed Size 69348 bytes 
Variable Size 20783104 bytes 
Database Buffers 33554432 bytes 
Redo Buffers 172032 bytes 
Database mounted. 
Database opened. 
SVRMGR> 
----- 
ํ˜„์ƒ : ORA-0312,0313 ์—๋Ÿฌ(ONLINE LOG CRASH) 
์›์ธ : 1.๋ฐ์ดํƒ€๋ฒ ์ด์Šค STARTUP ์‹œ ๋ฐœ์ƒ 
์กฐ์น˜ : [ ONLINE LOG ๊ฐ€ ์†์ƒ๋˜์—ˆ์„๋•Œ DB์— OPERATION ์ด ์—†์—ˆ๋˜ ๊ฒฝ์šฐ๋Š” ๋‹ค์Œ๊ณผ ๊ฐ™์€ ์ ˆ์ฐจ๋กœ DB์„ 
OPEN ํ• ์ˆ˜์žˆ๋‹ค - ํ™•๋ฅ  70% ] 

1.CONTROLFILE ์ƒ์„ฑ 
-. ์†์ƒ๋œ online log ๋Š” ํฌํ•จ์‹œํ‚ค์ง€ ์•Š๋Š”๋‹ค. 
-.resetlogs option ์œผ๋กœ ์ƒ์„ฑํ•œ๋‹ค. 
-.reuse option ์€ ์ƒ๋žตํ•˜๊ณ  ๊ธฐ์กด controlfile ์€ ๋‹ค๋ฅธ์ด๋ฆ„์œผ๋กœ move ์‹œํ‚ด. 

<V7 ์—์„œ CONTROLFILE ์ƒ์„ฑํ•˜๋Š” ๋ฐฉ๋ฒ• > 
sqldba> startup mount 
sqldba> alter database backup controlfile to trace; 

์œ„์™€ ๊ฐ™์ด ๋ช…๋ น์„ ์ž…๋ ฅํ•˜๋ฉด ORACLE_HOME/rdbms/log ๋””๋ ‰ํ† ๋ฆฌ์— ํŠธ๋ ˆ์ด์Šค ํ™”์ผ์ด 
์ƒ๊ธด๋‹ค. ๊ทธ ํŠธ๋ ˆ์ด์Šค ํ™”์ผ์—์„œ create controlfile ๋ช…๋ น๋ถ€๋ถ„์„ ๋‚จ๊ธฐ๊ณ  ์‚ญ์ œํ•œ๋‹ค. 
์ฝ˜ํŠธ๋กคํ™”์ผ ์ƒ์„ฑ ๋ฌธ์žฅ ์˜ˆ - <cnt.sql> : GROUP 1 ์ด ONLINE LOG ๋ผ๊ณ  ๊ฐ€์ • 
--------------------------------------------------------------------- 
CREATE CONTROLFILE DATABASE "RC722" RESETLOGS NOARCHIVELOG 
MAXLOGFILES 32 ******** 
MAXLOGMEMBERS 2 
MAXDATAFILES 30 
MAXINSTANCES 8 
MAXLOGHISTORY 800 
LOGFILE 
GROUP 2 '/oracle/oracle/dbs/log2RC722.dbf' SIZE 5M, 
GROUP 3 '/oracle/oracle/dbs/log3RC722.dbf' SIZE 5M 
DATAFILE 
'/oracle/oracle/dbs/systRC722.dbf', 
'/oracle/oracle/dbs/rbsRC722.dbf', 
'/oracle/oracle/dbs/toolRC722.dbf', 
'/oracle/oracle/dbs/usrRC722.dbf', 
'/oracle/oracle/dbs/tempRC722.dbf', 
'/oracle/oracle/rcdata.dbf' 
; 
2.์ ˆ์ฐจ 
$ sqldba lmode=y 
SQLDBA> connect internal 
SQLDBA> shutdown abort 
SQLDBA> startup nomount 
statement processed 
SQLDBA> @cnt 
SQLDBA> recover database using backup controlfile until cancel; 
.... 
... 
CANCEL (Return) 
Recovery canceled 
SQLDBA> alter database open resetlogs; 

: ๋งŒ์ผ ์ •์ƒ์ ์œผ๋กœ open ๋˜๋ฉด log file ์ถ”๊ฐ€ 
SQLDBA> alter database add logfile '?/dbs/log1ORA722.dbf' size 1M; 
: ์ •์ƒ์ ์œผ๋กœ open ์•ˆ๋˜๋ฉด RC์— ๋‹ค์‹œ ์—ฐ๋ฝ 
----- 
ํ˜„์ƒ : ORA-0439 
์›์ธ : BITMAP INDEXES ์ƒ์„ฑ ์‹œ option ์ด ์ธ์Šคํ†จ๋˜์ง€ ์•Š์•„์„œ ๋ฐœ์ƒ 
์กฐ์น˜ : ๋ฐ˜๋“œ์‹œ Oracle 8 Enterprise Edition ์—์„œ๋งŒ ์‚ฌ์šฉ์ด ๊ฐ€๋Šฅํ•˜๋‹ค. 
Oracle 8i ์—์„œ๋„ ๋™์ผํ•˜๊ฒŒ ์ ์šฉ๋œ๋‹ค. 
----- 
ํ˜„์ƒ : ORA-0600[3339] DATA BLOCK CORRUPTION DETECTION 
[3339] [arg1] [arg2] [] [] [] [] 
ORA-1578 : Data block corrupted in file # block # 
์›์ธ : 1.ORACLE์ด ์ง์ ‘ ๋ฒ„ํผ๋กœ ๋ฐ์ดํƒ€๋ฅผ ์ฝ์–ด๋“ค์ผ ๋•Œ ์ฝ์€ ๋ธ”๋Ÿญ์˜ DBA(Data Block Address)๊ฐ€ ์ž˜๋ชป 
๋˜์—ˆ์Œ(INVALID)์„ ์˜๋ฏธ 
2.ORACLE์˜ ๋ฌธ์ œ๊ฐ€ ์•„๋‹ˆ๋ผ OS๋‚˜ HW์˜ ๋ฌธ์ œ์ธ ๊ฒฝ์šฐ๊ฐ€ ๋งŽ๋‹ค. 
----- 
ํ˜„์ƒ : ORA-0604: error occurred at recursive SQL level %s 
์›์ธ : 1.๋‚ด๋ถ€์ ์œผ๋กœ SQL๋ช…๋ น์ด ์‹คํ–‰๋  ๋•Œ ๋ฐœ์ƒ(ํ˜„์žฌ ํ• ๋‹น๋œ ์ต์Šคํ…ํŠธ๊ฐ€ ๊ฐ€๋“ ์ฐจ์„œ ๋‹ค์Œ ์ต์Šคํ…ํŠธ๋ฅผ 
ํ• ๋‹น ๋ฐ›์œผ๋ ค๊ณ  ํ•  ๋•Œ ์˜ค๋ผํด์ด ๋‹ค์Œ ์ต์Šคํ…ํŠธ์˜ ํฌ๊ธฐ์™€ ์œ„์น˜๋ฅผ ๊ฒฐ์ •ํ•˜๊ธฐ ์œ„ํ•˜์—ฌ SELECT 
๋ช…๋ น์„ ๋‚ด๋ฆฌ๊ฒŒ ๋˜๋Š” ๊ฒƒ๊ณผ ๊ฐ™์€ ๊ฒฝ์šฐ) 
2.init.ora ํ™”์ผ์˜ ํŒŒ๋ผ๋ฏธํ„ฐ ๊ฐ€์šด๋ฐ DC_FREE_EXTENTS ๋‚˜ ROW_CACHE_ENQUEUES ์˜ ๊ฐ’์ด ๋„ˆ๋ฌด 
์ž‘๊ฒŒ ์„ค์ • 
3.ํ…Œ์ด๋ธ” ์ŠคํŽ˜์ด์Šค๊ฐ€ ๊ฐ€๋“ ์ฐจ๊ฑฐ๋‚˜ Extent ๊ฐฏ์ˆ˜์˜ ์ตœ๋Œ€ ํ—ˆ์šฉ๊ฐ’์„ ์ดˆ๊ณผํ•ด์„œ ์—๋Ÿฌ๊ฐ€ ๋ฐœ์ƒํ•˜๋Š” 
๊ฒฝ์šฐ ORA-604 ์—๋Ÿฌ๊ฐ€ ํ•จ๊ป˜ ๋ฐœ์ƒ 
์กฐ์น˜ : 1.?/dbs/init<SID>.ora ํ™”์ผ์— ์ง€์ •๋œ open_cursors ์˜ ํฌ๊ธฐ๋ฅผ ์•Œ์•„๋ณด๋Š” ๊ฒƒ์ด๋‹ค. ์ด ๊ฐ’์ด 
์„ค์ •์ด ์•ˆ๋˜์–ด ์žˆ์œผ๋ฉด Default๊ฐ€ 50์ด๋ฏ€๋กœ 
open_cursors=255 
---------------- 
2.DC_FREE_EXTENTS ๋‚˜ ROW_CACHE_ENQUEUES๋“ค์˜ ๊ฐ’์„ ํฌ๊ฒŒ ์„ค์ • 
3.์—๋Ÿฌ์˜ ์›์ธ์„ ์ฐพ๊ธฐ ์œ„ํ•ด์„œ init.ora ํ™”์ผ์— ๋‹ค์Œ๊ณผ ๊ฐ™์€ ๋ผ์ธ์„ ์ถ”๊ฐ€ํ•œ๋‹ค. 
events = "604 trace name errorstack" 
์ด๋ ‡๊ฒŒ init.ora๋ฅผ ๋ณ€๊ฒฝํ•˜๊ณ  DB๋ฅผ Shutdown ํ•˜๊ณ  Startup ํ•˜๋ฉด ORA-0604 ์—๋Ÿฌ๊ฐ€ ๋ฐœ์ƒํ•˜๋Š” 
๊ฒฝ์šฐ์— ์ž์„ธํ•œ ์ •๋ณด๋ฅผ Trace ํ™”์ผ์— ๊ธฐ๋กํ•ด ์ฃผ๋ฏ€๋กœ ์ด ํ™”์ผ์„ ๊ฒ€์‚ฌํ•˜์—ฌ ์—๋Ÿฌ์˜ ์›์ธ์„ 
์ฐพ์„ ์ˆ˜ ์žˆ๋‹ค. 
----- 
ํ˜„์ƒ : ORA-0901 invalid CREATE command 
์›์ธ : CREATE ๋’ค์— ์˜ค๋Š” KeyWord๋ฅผ ์‹๋ณ„ํ•˜์ง€ ๋ชปํ•œ ๊ฒฝ์šฐ 
----- 
ํ˜„์ƒ : ORA-0902 invalid dadatype 
์›์ธ : Oracle์—์„œ ์ œ๊ณต๋˜์ง€ ์•Š์€ datatype๋ฅผ ์‚ฌ์šฉํ•œ ๊ฒฝ์šฐ 
----- 
ํ˜„์ƒ : ORA-0903 invalid table name 
์›์ธ : ํ…Œ์ด๋ธ”์˜ ์ด๋ฆ„์ด Oracle object ๋ช…๋ช…์— ๋Œ€ํ•œ ํ•„์š”์กฐ๊ฑด์„ ๋งŒ์กฑ์‹œํ‚ค์ง€ ๋ชปํ•œ ๊ฒฝ์šฐ 
----- 
ํ˜„์ƒ : ORA-0904 ์—ด๋ช…์ด ๋ถ€์ ํ•ฉํ•ฉ๋‹ˆ๋‹ค. 
์›์ธ : ์ปฌ๋Ÿผ์ด ํ…Œ์ด๋ธ”์— ์กด์žฌํ•˜์ง€ ์ปฌ๋Ÿผ์„ ์‚ฌ์šฉํ•œ ๊ฒฝ์šฐ 
----- 
ํ˜„์ƒ : 083147.gold!stmkdjc.22031: LIBTUX_CAT:522: INFO: Default tpsvrdone() function 
used 
ORA-0904 : invalid column name 
ORA-1003 : no statement parsed 
์›์ธ : 1.ํ•ด๋‹น Table์— ์กด์žฌํ•˜์ง€ ์•Š์€ Field๋ฅผ ์‚ฌ์šฉํ•œ ๊ฒฝ์šฐ 
2.Host Variable ์•ž์— ":"๋ฅผ ๋ง๋ถ™์ง€์ง€ ์•Š์€ ๊ฒฝ์šฐ 
3.ํ•ด๋‹น Table๋ฅผ ๋ณ€๊ฒฝํ•˜๊ณ  ๊ด€๋ จ๋œ ํ”„๋กœ๊ทธ๋žจ์„ ์ปดํŒŒ์ผํ•˜์ง€ ์•Š์€ ๊ฒฝ์šฐ 
์กฐ์น˜ : 1.ํ•ด๋‹น Table์— Column์ด ์กด์žฌํ•˜๋Š”์ง€ ํ™•์ธ 
2.Host Variable ์•ž์— ":"๋ฅผ ๋ง๋ถ™์ธ๋‹ค. 
3.ํ•ด๋‹น Table์— ๊ด€๋ จ๋œ ํ”„๋กœ๊ทธ๋žจ๋ฅผ ์ปดํŒŒ์ผํ•œ๋‹ค. 
----- 
ํ˜„์ƒ : ORA-0906 missing left parenthesis 
์›์ธ : ์™ผ์ชฝ ๊ด„ํ˜ธ๋ฅผ ์ฐพ์ง€ ๋ชปํ•œ ๊ฒฝ์šฐ์— ๋ฐœ์ƒ 
----- 
ํ˜„์ƒ : ORA-0907 missing right parenthesis 
์›์ธ : ์˜ค๋ฅธ์ชฝ ๊ด„ํ˜ธ๋ฅผ ์ฐพ์ง€ ๋ชปํ•œ ๊ฒฝ์šฐ์— ๋ฐœ์ƒ 
----- 
ํ˜„์ƒ : ORA-0910 specified legth too long for its datatype 
์›์ธ : ํŠน์ • datatype์˜ ๊ธธ์ด๊ฐ€ ํ—ˆ์šฉ ์ตœ๋Œ€ ๊ธธ์ด๋ฅผ ์ดˆ๊ณผํ•œ ๊ฒฝ์šฐ 
----- 
ํ˜„์ƒ : ORA-0911 invalid character 
์›์ธ : Oracle์ด ๋ฎคํšจ ๋ฌธ์ž๋ผ๊ณ  ๊ฐ„์ฃผํ•˜๋Š” ๊ฒƒ์„ ๋งŒ๋‚  ๋•Œ ๋ฐœ์ƒํ•œ ์—๋Ÿฌ๋กœ ์‹ค์ œ๋ฌธ์ œ๋Š” ์—†์–ด์ง„ ๋ฌธ์ž๋•Œ๋ฌธ 
----- 
ํ˜„์ƒ : ORA-0913 too many value 
์›์ธ : INSERT๋ฌธ์—์„œ ์ง€์ •๋œ ์—ด์˜ ์ˆ˜๋ณด๋‹ค ์—ด ๊ฐ’์˜ ์ˆ˜๊ฐ€ ์ ์œผ๋ฉด ๋ฐœ์ƒ 
----- 
ํ˜„์ƒ : ORA-0917 missing comma 
์›์ธ : 1.Comma๋ฅผ ๊ธฐ๋Œ€ํ•˜๊ณ  ์žˆ๋Š” SQL๋ฌธ์— comma๊ฐ€ ์—†๋Š” ๊ฒฝ์šฐ 
2.์˜ค๋ฅธ์ชฝ ๊ด„ํ˜ธ๊ฐ€ ์—†๋Š” ๊ฒฝ์šฐ์—๋„ ๋ฐœ์ƒ 
----- 
ํ˜„์ƒ : ORA-0918 column ambiguously defined 
์›์ธ : 1.๋‘˜ ์ด์ƒ์˜ ํ…Œ์ด๋ธ”์ด ํ•œ SQL๋ฌธ์—์„œ ์ฐธ์กฐ๋  ๋•Œ ๋ฐœ์ƒ 
2.ํ•œ๊ฐœ ์ด์ƒ์˜ ์ง€์ •๋œ ํ…Œ์ด๋ธ”์— ์กด์žฌํ•˜๋Š” ์–ด๋–ค ์—ด์ด ํ•ด๋‹น ํ…Œ์ด๋ธ”๋กœ ํ•œ์ •๋ฐ›์ง€ ๋ชปํ•œ ๊ฒฝ์šฐ 
----- 
ํ˜„์ƒ : ORA-0920 invalid relational operator 
์›์ธ : ๊ด€๊ณ„ ์—ฐ์‚ฐ์ž๋ฅผ ์‹๋ณ„ํ•˜์ง€ ๋ชปํ•œ ๊ฒฝ์šฐ 
----- 
ํ˜„์ƒ : ORA-0921 unexpected end of SQL command 
์›์ธ : ๋ถˆ์™„์ „ํ•œ SQL๋ฌธ์ผ ๊ฒฝ์šฐ์— ๋ฐœ์ƒ 
----- 
ํ˜„์ƒ : ORA-0922 missing or invalid option 
์›์ธ : option์— ์ž„์˜์˜ ๋ฌธ์ž๊ฐ€ ์‚ฝ์ž…๋จ(์˜ˆ:NOT NULL --> NOT_NULL) 
----- 
ํ˜„์ƒ : ORA-0932 inconsistent datatype 
์›์ธ : 1.์–ด๋–ค ์—ฐ์‚ฐ์ž๋ฅผ ์–ด๋–ค ์—ด์— ์ ์šฉ์‹œํ‚ค๋ ค๊ณ  ํ•˜๋Š”๋ฐ ๊ทธ๊ฒƒ์˜ datatype์„ ์—ฐ์‚ฐ์ž์™€ ํ•จ๊ป˜ ์‚ฌ์šฉํ•œ ๊ฒฝ์šฐ 
2.ORA-0997 illegal use of LONG datatype์„ ๋ณต๊ท€์‹œํ‚ฌ ๊ฐ€๋Šฅ์„ฑ 
----- 
ํ˜„์ƒ : ORA-00933: SQL command not properly ended 
์›์ธ: 
----- 
ํ˜„์ƒ : ORA-0934 group function is not allowed here 
์›์ธ : SQL๋ฌธ์˜ WHERE๊ตฌ๋‚˜ GROUP BY๊ตฌ์—์„œ Group function๋ฅผ ์‚ฌ์šฉํ•œ ๊ฒฝ์šฐ 
----- 
ํ˜„์ƒ : ORA-0936 missing expression 
์›์ธ : 1.Comma ๊ธฐ์ˆ  ๋’ค์— ์—ด์ด๋‚˜ ํ‘œํ˜„์‹์ด ์กด์žฌํ•˜์ง€ ์•Š์€ ๊ฒฝ์šฐ์— ๋ฐœ์ƒ 
2.ORA-0917 missing comma์„ ๋ณต๊ท€์‹œํ‚ฌ ๊ฐ€๋Šฅ์„ฑ 
----- 
ํ˜„์ƒ : ORA-0937 not a single-group group function 
์›์ธ : ์–ด๋–ค SQL๋ฌธ์˜ ์„ ํƒ list๋Š” ์–ด๋–ค ์—ด์ด GROUP BY๊ตฌ์—์„œ ์ฐธ์กฐ๋˜์ง€ ์•Š์œผ๋ฉด ๊ทธ์—ด๊ณผ Group function๋ฅผ 
ํฌํ•จํ•  ์ˆ˜ ์—†๋‹ค. 
----- 
ํ˜„์ƒ : ORA-0938 not enough arguments for function 
์›์ธ : SQL๋ฌธ์ด ๋ถˆ์ถฉ๋ถ„ํ•œ ์ˆ˜์˜ ์ธ์ˆ˜๋กœ ํ•จ์ˆ˜๋ฅผ ํ˜ธ์ถœํ•œ ๊ฒฝ์šฐ์— ๋ฐœ์ƒ 
----- 
ํ˜„์ƒ : ORA-0942 : table or view does not exist(ํ…Œ์ด๋ธ” ๋˜๋Š” ๋ทฐ๊ฐ€ ์กด์žฌํ•˜์ง€ ์•Š์Šต๋‹ˆ๋‹ค.) 
์›์ธ : Oracle์€ ํ…Œ์ด๋ธ”์ด๋‚˜ ๋ทฐ๊ฐ€ ์กด์žฌํ•˜์ง€๋งŒ ์‚ฌ์šฉ์ž๊ฐ€ ํ…Œ์ด๋ธ”์ด๋‚˜ ๋ทฐ๋ฅผ ์œ„ํ•œ ์˜ค๋ธŒ์ ํŠธ ํŠน๊ถŒ(Grant)์„ ๋ถ€์—ฌํ•˜์ง€ ์•Š์Œ 
์กฐ์น˜ : Table ์ƒ์„ฑ ๋ฐ ๊ถŒํ•œ๋ถ€์—ฌ 
----- 
ํ˜„์ƒ : ORA-0947 not enough values 
์›์ธ : INSERT๋ฌธ์—์„œ ์ง€์ •๋œ ์—ด์˜ ์ˆ˜๊ฐ€ ์—ด ๊ฐ’์˜ ์ˆ˜๋ณด๋‹ค ํด๋•Œ ๋ฐœ์ƒ 
----- 
ํ˜„์ƒ : ORA-0979 not GROUP BY expression 
์›์ธ : ์–ด๋–ค query์˜ ์„ ํƒ list ์•ˆ์˜ ํ•œ ์—ด์ด GROUP BY๊ตฌ์— ๋“ค์–ด์žˆ๊ณ  ๋‹ค๋ฅธ ์—ด์€ ๋“ค์–ด์žˆ์ง€ ์•Š์€ ๊ฒฝ์šฐ์— ๋ฐœ์ƒ 
----- 
ํ˜„์ƒ : ORA-0997 illegal use of LONG datatype 
์›์ธ : 1.์–ด๋–ค ๊ธฐ๋Šฅ๋“ค์€ datatype์ด LONG์ธ ์—ด์—์„œ ์ˆ˜ํ–‰๋˜์ง€ ์•Š๋Š”๋‹ค. 
2.Long column์€ 2G๊นŒ์ง€ ์ง€์›์„ ํ•˜์ง€๋งŒ, 
SQL*Plus์—์„œ insert into ๋ฌธ์žฅ์„ ์ด์šฉํ•˜์—ฌ long column์— ๋„ฃ์„ ๋ฌธ์ž์—ด์„ 
single quote(') ์•ˆ์— ๊ธฐ์ˆ  ์‹œ, 2000 characters๊ฐ€ ๋„˜์œผ๋ฉด ora-1704 ์—๋Ÿฌ๊ฐ€ ๋‚œ๋‹ค. 
์กฐ์น˜ : 1.TABLE์˜ COPY๋Š” ๊ฐ€๋Šฅํ•˜์ง€ ์•Š์œผ๋ฏ€๋กœ,LONG COLUMN์„ ๊ฐ€์ง„ ํ…Œ์ด๋ธ”์„ COPYํ•˜๊ณ ์ž ํ•  ๋•Œ, 
32KBytes ์ดํ•˜์˜ size๋ผ๋ฉด ๋‹ค์Œ์˜ PL/SQL์„ ์‚ฌ์šฉํ•˜๋ฉด ๊ฐ€๋Šฅํ•˜๋‹ค. 
2.PL/SQL์„ ์ด์šฉํ•ด์•ผ ํ•˜๋ฉฐ, ๊ฒฝ์šฐ์— ๋”ฐ๋ผ Pro*C, SQL*Loader ๋“ฑ์„ ์ด์šฉํ•˜์—ฌ insertํ•ด์•ผ๋งŒ ํ•œ๋‹ค. 
----- 
ํ˜„์ƒ : ORA-1001 Invalid Cursor 
์›์ธ : Typing ์—๋Ÿฌ, ์ž˜๋ชป๋œ ๋ฉ”๋ชจ๋ฆฌ ๊ด€๋ฆฌ ๋“ฑ์˜ ์—ฌ๋Ÿฌ๊ฐ€์ง€ ์›์ธ์— ์˜ํ•ด์„œ ๋ฐœ์ƒ. 
์กฐ์น˜ : 1.ํ™˜๊ฒฝ์—์„œ ์กฐ์น˜ํ•  ์‚ฌํ•ญ 
- PRECOMPILE ์˜ต์…˜ ๊ฐ€์šด๋ฐ MAXOPENCURSORS ๋ฅผ ๋Š˜๋ ค์ค€๋‹ค. 
- init<SID>.ora ํ™”์ผ์—์„œ OPEN_CURSORS ํŒŒ๋ผ๋ฏธํ„ฐ ๊ฐ’์„ ๋Š˜๋ ค์ค€๋‹ค. 
- ์‚ฌ์šฉ๋˜์ง€ ์•Š๋Š” CURSOR๋Š” OPEN ์ƒํƒœ๋กœ ๋‘์ง€ ๋ง๊ณ  CLOSE ์‹œ์ผœ์ค€๋‹ค. 
- ์ง€๊ธˆ์€ ๊ฑฐ์˜ ์‚ฌ์šฉ๋˜์ง€ ์•Š์ง€๋งŒ ORACLE V6 ๋ฅผ ์‚ฌ์šฉํ•œ๋‹ค๋ฉด PRECOMPILE ์˜ต์…˜ ๊ฐ€์šด๋ฐ 
AREASIZE๋ฅผ 512K ์ •๋„๋กœ ํฌ๊ฒŒ ๋Š˜๋ ค์ฃผ๋„๋ก ํ•œ๋‹ค. ๊ทธ๋ฆฌ๊ณ  init<SID>.ora ์—์„œ 
CONTEXT_AREA ๊ฐ’๋„ ๋Š˜๋ ค์ค€๋‹ค . 
- TRACE FILE์„ ์ด์šฉํ•˜๋ฉด ๋ฌธ์ œ์˜ ์›์ธ์„ ์ฐพ๋Š”๋ฐ ์žˆ์–ด ์œ ์šฉํ•  ๋•Œ๊ฐ€ ์žˆ๋‹ค. 
2.๊ทธ ๋ฐ–์˜ ๊ฒฝ์šฐ 
- OPEN ๋˜์ง€ ์•Š์€ CURSOR ์— ๋Œ€ํ•ด์„œ ์ž‘์—…์„ ํ•  ๋•Œ 
- ์กด์žฌํ•˜์ง€ ์•Š๋Š” OBJECT์— ๋Œ€ํ•ด์„œ SQL ๋ช…๋ น์„ ์‹คํ–‰ํ•  ๋•Œ 
- CURSOR CACHE๋กœ๋ถ€ํ„ฐ ์‚ญ์ œ๋œ ๊ฒฝ์šฐ 
- CURSOR CACHE๋กœ๋ถ€ํ„ฐ ์‚ญ์ œ๋œ ๋˜๋‹ค๋ฅธ ๊ฒฝ์šฐ 
PRECOMPILE ์˜ต์…˜ ๊ฐ€์šด๋ฐ์—์„œ MAXOPENCUSORS ๋ฅผ ๋Š˜๋ ค์ฃผ๊ฑฐ๋‚˜ 
HOLD_CURSOR=YES, RELEASE_CURSOR=NO ๋กœ ์„ค์ • 
- XA/TUXEDO ํ™˜๊ฒฝ์—์„œ ORA-1001 ์—๋Ÿฌ๊ฐ€ ๋ฐœ์ƒํ•˜๋Š” ๊ฒฝ์šฐ(์ผ๋ถ€ ORACLE ๋ฒ„์ ผ์—์„œ ๋ฐœ์ƒ) 
----- 
ํ˜„์ƒ : ORA-1002 FETCH OUT OF SEQUENCE IN PRO*C(stop[<fltmsjaud>]:๋ฆฌ์Šค๋„ˆ๋ฅผ ์ค‘๋‹จํ•ฉ๋‹ˆ๋‹ค. 
์›์ธ : 1.user๊ฐ€ ๋”์ด์ƒ ์œ ํšจํ•˜์ง€ ์•Š์€ cursor๋กœ๋ถ€ํ„ฐ fetch๋ฅผ ํ•˜๋ ค๊ณ  ํ•˜๊ธฐ ๋•Œ๋ฌธ 
2.ORA-1403 ๋“ฑ๊ณผ ๊ฐ™์ด NO DATA FOUND๋ฅผ returnํ•˜๋Š” fetch์ž‘์—…์„ ์ˆ˜ํ–‰ํ• ๋•Œ 
3.SELECT FOR UPDATE๋ฅผ ๊ฐ€์ง„ cursor ์˜ fetch์ž‘์—…๋‚ด์— commit์ด ์žˆ๋Š” ๊ฒฝ์šฐ 
์กฐ์น˜ : 3.commit์„ fetch loop์˜ ๋ฐ”๊นฅ์ชฝ์œผ๋กœ ๋นผ๊ฑฐ๋‚˜ select for update๋ฌธ์„ ์‚ฌ์šฉํ•˜์ง€ ์•Š์•„์•ผ ํ•œ๋‹ค. 
----- 
ํ˜„์ƒ : ORA-1012 Error( not logged on )๊ฐ€ ๋ฐœ์ƒ 
์›์ธ : 1.tpbegin()์ด ๋˜์–ด ์žˆ์ง€ ์•Š์Œ 
2.PC์ชฝ์—์„œ NOTRAN Mode๋กœ Service๋ฅผ ํ˜ธ์ถœ 
์กฐ์น˜ : 1.Program์„ ํ™•์ธํ•œ๋‹ค. 
2.flag๋ฅผ 0์œผ๋กœ Settingํ•œ๋‹ค.(TRAN Mode๋กœ Service ํ˜ธ์ถœ) 
3.Service์ ˆ์— Default์— AUTOTRAN์„ "Y"๋กœ ์„ค์ •ํ•˜๊ณ  ํ•ด๋‹น Service๋ช…์„ ๊ธฐ์ˆ ํ•œ๋‹ค. 
----- 
ํ˜„์ƒ : ORA-1027 bind variables not allowed for data definition operations 
์›์ธ : WHERE์— BIND_VAR ๋ฅผ ์ด์šฉํ•œ CREATE VIEW ๋Š” ๋ถˆ๊ฐ€๋Šฅ 
์กฐ์น˜ : ์ด ๊ฒฝ์šฐ EXEC SQL CREATE TABLE IMAGE 
(EMPNO NUMBER(4) NOT NULL, BITMAP LONG RAW) 
END-EXEC. 
์ด ์ฒ˜๋Ÿผ create ํ•ด์•ผ ํ•œ๋‹ค. 
----- 
ํ˜„์ƒ : ORA-1031 insufficient privileges 
์›์ธ : ์‚ฌ์šฉ์ž๊ฐ€ ํ…Œ์ด๋ธ”์ด๋‚˜ ๋ทฐ์™€ ์—ฐ๊ด€๋œ ์ ์–ด๋„ ํ•œ ๊ฐœ์˜ object ํŠน๊ถŒ์„ ๋ถ€์—ฌ๋ฐ›์•˜์ง€๋งŒ SQL๋ฌธ์—์„œ ์ง€์ •๋œ 
ํŠน๊ถŒ์„ ๋ถ€์—ฌ๋ฐ›์ง€ ์•Š์•˜์„ ๋•Œ ๋ฐœ์ƒ 
1.ORACLE์˜ SYSTEM ์œ ์ €์— POWERBUILDER์˜ BASE TABLE 5๊ฐœ๊ฐ€ ์ƒ์„ฑ์ด ๋˜์–ด ์žˆ์ง€ 
์•Š์€ ๊ฒฝ์šฐ 
2.SYSTEM ์œ ์ €๋กœ ์ ‘์†ํ•œ ํ›„์—๋„ ์ผ๋ฐ˜ ์œ ์ €๊ฐ€ ์ ‘์†์ด ๋˜์ง€ ์•Š์„ ๊ฒฝ์šฐ 
์กฐ์น˜ : 1.5๊ฐœ base table(pbcatcol, pbcattbl, pbcatfmt, pbcatvld, pbcatedt)์„ 
dropํ•œ ๋‹ค์Œ system ์œ ์ €๋กœ ์ ‘์†์„ ํ•˜๊ณ , ๋‹ค์‹œ ์ผ๋ฐ˜ ์œ ์ €๋กœ ์ ‘์†ํ•˜๋Š” ๋ฐฉ๋ฒ•. 
2.system ์œ ์ €๋กœ ๋“ค์–ด๊ฐ€์„œ 5๊ฐœ base table์— ๋Œ€ํ•œ ์‚ฌ์šฉ ๊ถŒํ•œ์„ 
์ผ๋ฐ˜ ์œ ์ €์—๊ฒŒ ์ฃผ๋Š” ๋ฐฉ๋ฒ•. 
$sqlplus system/manager 

SQL>grant all on pbcatcol to public; 
SQL>grant all on pbcatedt to public; 
SQL>grant all on pbcatfmt to public; 
SQL>grant all on pbcattbl to public; 
SQL>grant all on pbcatvld to public; 
----- 
ํ˜„์ƒ : ORA-1034, "ORACLE not available" 
ORA-7320, "smsget: shmat error when trying to attach sga." 
ORA-7429, "smsgsg: shmget() failed to get segment." 
์›์ธ : ORACLE DBA ์‚ฌ์šฉ์ž๋งŒ ๋ฐ์ดํƒ€๋ฒ ์ด์Šค๋ฅผ ACESSํ• ์ˆ˜ ์žˆ๊ณ  ๋‹ค๋ฅธ ์‚ฌ์šฉ์ž๋Š” SQL*PLUS ๋“ฑ์„ ํ†ตํ•˜์—ฌ 
CONNECT๋ฅผ ํ•˜๋ ค๊ณ  ํ• ๋•Œ ๋‹ค์Œ ์—๋Ÿฌ๊ฐ€ ๋ฐœ์ƒ ํ• ๊ฒฝ์šฐ 
----- 
ํ˜„์ƒ : TPFAILED ...................... 
sqlca.sqlcode ==> -1036 
ORACLE์—์„œ ๋‹จ๋…์œผ๋กœ ์‹คํ–‰ํ•˜๋ฉด ๋ฌธ์ œ๊ฐ€ ๋ฐœ์ƒ๋˜์ง€ ์•Š๊ณ  OUTPUT์„ ์ •ํ™•ํ•˜๊ฒŒ ์ถœ๋ ฅํ•˜์ง€๋งŒ 
TP/M์™€ ํ•จ๊ป˜ ์‹คํ–‰์ด ๋˜๋ฉด SQL SELECT๋ฌธ์„ ์ˆ˜ํ–‰ํ•˜์ง€ ๋ชปํ•˜๊ณ  sqlca.sqlcode ==> -1036์˜ 
MESSAGE๋ฅผ ๋ฟŒ๋ฆฌ๊ณ  ์‹คํ–‰์„ ๋ฉˆ์ถ˜๋‹ค. 
์›์ธ : ORACLE์—์„œ Version๊ฐ„์˜ Segment ์ •์˜๋ถ€๋ถ„์ด ๋‹ค๋ฅด๊ธฐ ๋•Œ๋ฌธ 
์กฐ์น˜ : makefile ํ˜น์€ proc.mk file์—์„œ 
sqlcheck=semantic userid=scrjpcs/scrjpcs๋ฅผ ํฌํ•จ์‹œํ‚จ๋‹ค. 
----- 
ํ˜„์ƒ : ORA-1039: insufficient privileges on underlying objects of the view. 
์›์ธ : SYS user๊ฐ€ ์•„๋‹Œ ๋‹ค๋ฅธ user๋กœ SQL Analyze์— ๋กœ๊ทธ์ธํ•˜์—ฌ SQL statement์— ๋Œ€ํ•œ explain plan ์˜ต์…˜์„ ์‚ฌ์šฉํ•  ๋•Œ ๋‹ค์Œ๊ณผ ๊ฐ™์€ ์—๋Ÿฌ๊ฐ€ ๋ฐœ์ƒ 
์กฐ์น˜ : 1.dictionary table/view๋“ค์„ validate์‹œ์ผœ ๋†“์œผ๋ ค๋ฉด dba๊ฐ€ read ๊ถŒํ•œ๋งŒ SQL Analyze๋ฅผ ์ˆ˜ํ–‰ํ•˜๋Š” user์—๊ฒŒ grantํ•˜๋ฉด ์ถฉ๋ถ„ํ•˜๋‹ค. 
2.SYS user๋กœ์„œ SQL explaining์„ ์ˆ˜ํ–‰ํ•˜๋Š” ๊ฒƒ์ด๋‹ค. 
----- 
ํ˜„์ƒ : ORA-9992 scumnt: failed to open <FILENAME> 
ORA-9993 scumnt: failed to lock <FILENAME> 
ORA-1102 cannot mount database in exclusive mode 
์›์ธ : ์„œ๋กœ ๋…๋ฆฝ์ ์ธ ๋‘๊ฐœ์˜ instance๊ฐ€ ๋™์ผํ•œ database file๋“ค์„ ๋™๊ธฐํ™” (synchronisation)์—†์ด accessํ•  ์ˆ˜ ์žˆ๊ธฐ ๋•Œ๋ฌธ์— database corruption์„ ์œ ๋ฐœ์‹œํ‚ฌ ์ˆ˜ ์žˆ์—ˆ๋‹ค. 
์กฐ์น˜ : database์˜ db_name์ด ๋ณ€๊ฒฝ๋˜๋ฉด ๊ฐ๊ฐ์˜ lk<DB_NAME> file์„ ์ƒ์„ฑ. 
----- 
ํ˜„์ƒ : ORA-01118: cannot add any more database files: limit of XXX exceeded 
์›์ธ : ๋ฐ์ดํƒ€ ํ™”์ผ์˜ ๊ฐฏ์ˆ˜๊ฐ€ MAXDATAFILES ๊ฐ’์— ๋„๋‹ฌํ•œ ๊ฒฝ์šฐ ๋ฐœ์ƒ 
์กฐ์น˜ : MAXDATAFILES๋ฅผ ๋Š˜๋ฆฌ๊ธฐ ์œ„ํ•ด์„œ๋Š” DB๋ฅผ ์ƒˆ๋กœ ๋งŒ๋“ค์–ด์•ผ ํ•˜๋ฉฐ ๊ทธ ์ดํ›„ ๋ฒ„์ ผ์„ ์‚ฌ์šฉ์ค‘์ด๋ผ๋ฉด ์ฝ˜ํŠธ๋กค 
ํ™”์ผ์„ ์ƒˆ๋กœ ๋งŒ๋“ค์–ด์„œ MAXDATAFILES๋ฅผ ๋Š˜๋ฆด ์ˆ˜ ์žˆ๋‹ค 
----- 
ํ˜„์ƒ : ORA-1157 : cannot identify data file 11 - file not found 
ORA-1110 : data file 11 : '/user1/oracle7/dbs/user2.dbf' 
์›์ธ : OS ๋ช…๋ น์œผ๋กœ DATA FILE ์„ ์‚ญ์ œํ•œ ๊ฒฝ์šฐ 
์กฐ์น˜ : DATABASE STARTUP์‹œ STARTUP MOUNT ๋‹จ๊ณ„๊นŒ์ง€ ์‹คํ–‰ํ•œ ํ›„, ๋ฌธ์ œ์˜ ๋ฐ์ดํƒ€ ํ™”์ผ์„ OFFLINE ์‹œํ‚จ๋‹ค. 
๋ฐ์ดํƒ€๋ฒ ์ด์Šค๋ฅผ ์˜คํ”ˆํ•œ๋‹ค. ๋‹จ ๋ฐ์ดํƒ€๋ฒ ์ด์Šค ์˜คํ”ˆ์ด ์ •์ƒ์ ์œผ๋กœ ์ˆ˜ํ–‰๋˜๋ฉด ๋ฌธ์ œ๊ฐ€ ๋ฐœ์ƒํ•œ ๋ฐ์ดํƒ€ 
ํ™”์ผ์„ ํฌํ•จํ•˜๊ณ  ์žˆ๋Š” TABLESPACE๋ฅผ DROPํ•˜์ง€ ์•Š์„ ๊ฒฝ์šฐ์—๋Š” DATABASE STARTUP์‹œ ํ•ญ์ƒ ๋ฐ์ดํƒ€ 
ํ™”์ผ์˜ ์˜คํ”ˆ ๋‹จ๊ณ„์—์„œ ์—๋Ÿฌ๊ฐ€ ๋ฐœ์ƒ๋œ๋‹ค. ๋”ฐ๋ผ์„œ, ๋ฌธ์ œ์˜ ๋ฐ์ดํƒ€ ํ™”์ผ์˜ OFFLINE๊ณผ TABLESPACE์˜ 
DROP์ „์— ๋ฐ˜๋“œ์‹œ ํ•ด๋‹น TABLESPACE๋ฅผ ์‚ฌ์šฉํ•˜๊ณ  ์žˆ๋Š” USER์˜ ๋ฐ์ดํƒ€ ๋ฐฑ์—…์„ ์ˆ˜ํ–‰ํ•ด์•ผ ํ•œ๋‹ค. 

๋ฐ์ดํƒ€ ํ™”์ผ์˜ OFFLINE๊ณผ ๊ด€๋ จ๋œ ๋ช…๋ น์€ ๋‹ค์Œ๊ณผ ๊ฐ™๋‹ค. 
SQLDBA๋ฅผ COMMAND LINE MODE๋กœ ๊ธฐ๋™์‹œํ‚จ๋‹ค. 

$ sqldba lmode=y 
SQLDBA> CONNECT INTERNAL; 
SQLDBA> STARTUP MOUNT; 
ORACLE instance started. 
Database mounted. 
SQLDBA> ALTER DATABASE DATAFILE '/user1/oracle7/dbs/user2.dbf' 
OFFLINE DROP; 
Statement processed. 
SQLDBA> ALTER DATABASE OPEN; 
Statement processed. 
SQLDBA> DROP TABLESPACE tablespace_name INCLUDING CONTENTS; 
Statement 
----- 
ํ˜„์ƒ : ORA-01237 cannot extend datafile %s 
์›์ธ : O/S ๋ ˆ๋ฒจ์—์„œ๋Š” file size๋ฅผ 1TB ์ด์ƒ ์ง€์›ํ•œ๋‹ค๊ณ  ํ•˜๋Š”๋ฐ, oracle datafile์„ 2G ์ด์ƒ์œผ๋กœ resizeํ•˜๋ ค๊ณ  ํ•œ๋‹ค๊ฑฐ๋‚˜ tablespace์— datafile์„ ์ถ”๊ฐ€ํ•˜๊ฑฐ๋‚˜ ์ƒ์„ฑํ•  ๋•Œ, 2G ์ด์ƒ ์ฃผ๋ฉด file size limit์— ๊ฑธ๋ฆฌ๋Š” ํ˜„์ƒ ๋ฐœ์ƒ 
์กฐ์น˜ : ํ™”์ผ ์‹œ์Šคํ…œ์—์„œ large file์„ ์‚ฌ์šฉํ•˜๊ธฐ ์œ„ํ•ด์„œ๋Š” ํ™”์ผ ์‹œ์Šคํ…œ์„ 'largefiles' option์œผ๋กœ mountํ•ด์•ผ ํ•œ๋‹ค. 
----- 
ํ˜„์ƒ : ORA-1400 primary key or mandatory(NOT NULL) column is missing or NULL during insert 
์›์ธ : ์–ด๋–ค ํ•„์ˆ˜์ ์ธ ์—ด์„ ์œ„ํ•œ ๊ฐ’์„ ๊ณต๊ธ‰ํ•˜์ง€ ์•Š์€ ๊ฒฝ์šฐ 
----- 
ํ˜„์ƒ : ORA-1401 inserted value too large for column(์—ด์— ์ž…๋ ฅํ•œ ๊ฐ’์ด ๋„ˆ๋ฌด ํฝ๋‹ˆ๋‹ค.) 
์›์ธ : ๋ฌธ์ž์—ด์„ ํ• ๋‹นํ•˜๊ณ ์ž ํ• ๋•Œ ๊ธธ์ด๊ฐ€ ์ตœ๋Œ€์น˜๋ฅผ ์ดˆ๊ณผํ•œ ๊ฒฝ์šฐ 
----- 
ํ˜„์ƒ : ORA-1403 no dada found 
์›์ธ : ์‚ฌ์‹ค์ƒ ์ „ํ˜€ Error๊ฐ€ ์•„๋‹ˆ๋‹ค. 
----- 
ํ˜„์ƒ : ORA-1405 fetched column value is NULL 
์›์ธ : ERROR ๊ฐ€ ์•„๋‹ˆ๊ณ  WARNING MESSAGE ์ด๋‹ค. 
์กฐ์น˜ : dbms=v6 ๋ฅผ PRECOMPILER OPTION ์— ์ถ”๊ฐ€ํ•ด์ค€๋‹ค. dbms=v6 ๋กœ SETTING ํ• ๊ฒฝ์šฐ๋Š” HOST ๋ณ€์ˆ˜์— 
NULL ์ด RETURN ๋˜๋”๋ผ๋„ sqlca.sqlcode ๋Š” 0 ์ด ๋œ๋‹ค. 
----- 
ํ˜„์ƒ : ORA-1407 cannot update mandatory(NOT NULL) column to NULL 
์›์ธ : ํ•„์ˆ˜์ ์ธ ์—ด์˜ ๊ฐ’์„ NULL์— ์„ค์ •ํ•œ ๊ฒฝ์šฐ์— ๋ฐœ์ƒ 
----- 
ํ˜„์ƒ : ORA-1408 such column list already indexed 
์›์ธ : ์ด๋ฏธ ๋™์ผํ•œ ์—ด List์— ๊ธฐ์ดˆํ•œ Index๋ฅผ ๊ฐ–๊ณ  ์žˆ๋Š” Table์—์„œ Index๋ฅผ ์ž‘์„ฑํ•˜๊ณ ์ž ํ•˜๋Š” ๊ฒฝ์šฐ์— ๋ฐœ์ƒ 
----- 
ํ˜„์ƒ : ORA-1410 invalid ROWID 
์›์ธ : 1.์ ์ ˆํ•œ Format์œผ๋กœ ROWID๋ฅผ ์ƒ์ˆ ํ•˜์ง€ ์•Š์€ ๊ฒฝ์šฐ์— ๋ฐœ์ƒ 
2.์ง€์ •๋œ ROWID๊ฐ€ ์กด์žฌํ•˜์ง€ ์•Š์€ ๊ฒฝ์šฐ์— ๋ฐœ์ƒ 
----- 
ํ˜„์ƒ : ORA-01438: ์ง€์ •ํ•œ ์ •๋„๋ฅผ ์ดˆ๊ณผํ•œ ๊ฐ’์ด ์—ด์— ์ง€์ •๋˜์—ˆ์Šต๋‹ˆ๋‹ค. 
์›์ธ : ์ง€์ •ํ•œ ์ž๋ฆฟ์ˆ˜๋ฅผ ์ดˆ๊ณผํ•œ Column์ด ์กด์žฌํ•œ ๊ฒฝ์šฐ์— ๋ฐœ์ƒ 
----- 
ํ˜„์ƒ : ORA-01422: exact fetch returns more than requested number of rows 
ORA-06512: at "SYS.STANDARD", line 648 
ORA-06512: at "BETH.BETH", line 6 
ORA-06512: at line 1 
์›์ธ : SELECT ๋ฌธ์—์„œ ์กฐ๊ฑด์— ํ•ด๋‹นํ•˜๋Š” row๊ฐ€ 2๊ฑด ์ด์ƒ 
return๋˜์—ˆ์„ ๋•Œ ๋ฐœ์ƒํ•˜๋Š” TOO_MANY_ROWS ์—๋Ÿฌ์™€ ๋™์ผํ•œ ์—๋Ÿฌ์ด๋‹ค. 
์กฐ์น˜ : ํ™•์ธํ•œ ๊ฒฐ๊ณผ DUAL table์—์„œ๋Š” ๋น„๋ก 2๊ฐœ์˜ ROWID๋ฅผ ๋ณผ ์ˆ˜๋Š” ์—†์ง€๋งŒ, 
์‹ค์ œ 2๊ฐœ์˜ row๊ฐ€ DUAL table์— ์กด์žฌํ•˜๋Š” ์ƒํ™ฉ์ด๋‹ค. 
๋”ฐ๋ผ์„œ, ๋‹ค์Œ ๋ช…๋ น์„ ์ด์šฉํ•˜์—ฌ ์—ฌ๋ถ„์˜ ํ•„์š”์—†๋Š” row๋ฅผ deleteํ•ด์•ผ ํ•œ๋‹ค. 
----- 
ํ˜„์ƒ : ORA-1449 column contains NULL values; cannot alter to NOT NULL 
์›์ธ : ์–ด๋–ค ์—ด์„ ํ•„์ˆ˜์ ์ธ ๊ฒƒ์œผ๋กœ ๋ณ€๊ฒฝํ•˜๊ณ ์ž ํ•˜๋‚˜ ์ ์–ด๋„ ํ…Œ์ด๋ธ” ๋‚ด์˜ ํ•œ ํ–‰์ด ๊ทธ ์—ด์„ ์œ„ํ•œ NULL๊ฐ’์„ 
๊ฐ€์งˆ ๋•Œ ๋ฐœ์ƒ 
----- 
ํ˜„์ƒ : ORA-1452 cannot CREATE UNIQUE INDEX; duplicate keys found 
์›์ธ : ๊ฐ’์ด ๋…ํŠนํ•˜์ง€ ์•Š์€ ์ผ๋ จ์˜ ์—ด์—์„œ ๋…ํŠนํ•œ ์ธ๋ฑ์Šค๋ฅผ ์ž‘์„ฑํ•œ ๊ฒฝ์šฐ์— ๋ฐœ์ƒ 
----- 
ํ˜„์ƒ : ORA-1453 SET TRANSACTION must be first statement of transaction 
์›์ธ : ๋ชจ์ข…์˜ ๋‹ค๋ฅธ SQL๋ฌธ ์ดํ›„์— SET TRANSACTION๋ฌธ์„ ๊ธฐ๋™ํ•  ๋•Œ ๋ฐœ์ƒ 
----- 
ํ˜„์ƒ : ORA-01458 Invalid length inside variable character string 
์›์ธ : DB Table field์˜ ๊ธธ์ด์™€ Host Variable์˜ ๊ธธ์ด ์ฐจ์ด๊ฐ€ ์žˆ์„๋•Œ ๋ฐœ์ƒํ•œ๋‹ค. 
๊ทธ๋Ÿฌ๋ฏ€๋กœ Table field์˜ ๊ธธ์ด์™€ Host Variable์˜ ๊ธธ์ด๋ฅผ ๋น„๊ตํ•ด ๋ณธ๋‹ค. ํ˜น์€ Stored 
Procedure์˜ Input Parameter๊ฐ€ Null ๊ฐ’์œผ๋กœ ๋„˜๊ฒจ์งˆ ๋•Œ๋„ ๋ฐœ์ƒํ•œ๋‹ค. 
์กฐ์น˜ : DB Table field์™€ Host Variable์˜ ๊ธธ์ด๋ฅผ ์กฐ์ •ํ•œ๋‹ค. 
Stored Procedure์˜ Input Parameter์— Null๊ฐ’์„ 0์˜ ๊ฐ’์„ ์ฑ„์›Œ์„œ ๋„˜๊ธด๋‹ค. 
์ฃผ์˜ : Stored Procedure์—์„œ Cursor๋ฅผ ์‚ฌ์šฉํ•  ๋•Œ 
FOR ... LOOP๋ฅผ ์‚ฌ์šฉํ•  ๋•Œ ์ฃผ์˜๋ฅผ ํ•ด์•ผํ•œ๋‹ค. 
FOR i IN 1..batch_size LOOP 
FETCH get_emp 
INTO 
emp_name( i ) 
,job( i ) 
,sql( i ) 
; 

IF get_emp%NOTFOUND THEN -- if no row was found 
CLOSE get_emp; 
done_fetch := 100; -- indicate all none 
EXIT; 
ELSE 
done_fetch := 900; -- indicate all none 
found := found + 1; -- count row 
END IF; 
END LOOP; 
์—์„œ Fetch Array์˜ 0๋ฒˆ์งธ์— Data๋ฅผ ์ €์žฅํ•  ๋•Œ ๋ฌธ์ œ๊ฐ€ ์ƒ๊ธด๋‹ค. 
๊ทธ๋Ÿฌ๋ฏ€๋กœ, emp_name( 0 )์ด๋ผ๊ณ  ํ•˜๋ฉด Error๋ฅผ ๋ฐœ์ƒํ•œ๋‹ค. 
----- 
ํ˜„์ƒ : ORA-01476: divisor is equal to zero 
์›์ธ : Zero๊ฐ’์œผ๋กœ ์ž„์˜์˜ ์ˆ˜๋ฅผ ๋‚˜๋ˆ„์—ˆ์„๋•Œ ๋ฐœ์ƒ 
----- 
ํ˜„์ƒ : ORA-01480: trailing null missing from STR bind value 
์›์ธ : 1.ํ•ด๋‹น Column์˜ Size ๋ณด๋‹ค ๋” ํฐ ๊ฐ’์ด ๋“ค์–ด์˜จ ๊ฒฝ์šฐ์— ๋ฐœ์ƒ 
2.Character Type(CHAR, VARCHAR)์˜ Host variable์ธ ๊ฒฝ์šฐ ๋ณ€์ˆ˜ ์„ ์–ธ์‹œ Table์˜ Column size ๋งŒํผ์˜ ๋ณ€์ˆ˜๊ธธ์ด๋ฅผ ์„ ์–ธํ•œ ๊ฒฝ์šฐ ๋ฐœ์ƒ 
์กฐ์น˜ : 1.ํ•ด๋‹น Column์˜ Size์™€ ํ•ด๋‹น๊ฐ’์„ ํ™•์ธ 
2.Character Type(CHAR, VARCHAR)์˜ Host variable์ธ ๊ฒฝ์šฐ ๋ณ€์ˆ˜ ์„ ์–ธ์‹œ Table์˜ Column size์— 1๋ฅผ ๋”ํ•ด ์ฃผ์–ด์•ผ ํ•œ๋‹ค. 
(๋ฐ์ดํ„ฐ์˜ ๋งˆ์ง€๋ง‰์— NULL ๋ฌธ์ž๋ฅผ ํฌํ•จํ•ด์•ผ ํ•˜๊ธฐ ๋•Œ๋ฌธ์—) 
----- 
ํ˜„์ƒ : ORA-1481 invalid number format model 
์›์ธ : ์–ด๋–ค ์ˆซ์ž Format Model์ด ๋ฏธ์ •์˜ ๋ฌธ์ž๋ฅผ ํฌํ•จํ•œ ๊ฒฝ์šฐ์— ๋ฐœ์ƒ 
----- 
ํ˜„์ƒ : ORA-1547 : Failed to allocate extent of size 'num' in tablespace 'TOOLS 
์›์ธ : TABLESPACE๊ฐ€ ์—๋Ÿฌ์— ๋ช…์‹œ๋œ ORACLE block ์ˆ˜ ๋งŒํผ์˜ ์š”์ฒญ๋œ EXTENT๋ฅผ ํ• ๋‹นํ•  ์ถฉ๋ถ„ํ•œ FREE 
SPACE๋ฅผ ๊ฐ–๊ณ ์žˆ์ง€ ๋ชปํ•  ๊ฒฝ์šฐ์— ๋ฐœ์ƒ 
์กฐ์น˜ : 1.ํ•ด๋‹น TABLESPACE๋‚ด์—์„œ ์—ฐ์†๋œ ์˜์—ญ์˜ ORACLE block ํ• ๋‹นํ•  ์ˆ˜ ์žˆ๋„๋ก ๋ฐ์ดํƒ€ ํ™”์ผ์„ ์ถ”๊ฐ€ 
2.TABLE์˜ STORAGE PARAMETER์—์„œ INITIAL EXTENT, NEXT EXTENT์˜ ํฌ๊ธฐ๋ฅผ ์กฐ์ •ํ•˜์—ฌ TABLE์„ 
์žฌ๊ตฌ์ถ• 
3.๋‹ค์Œ์˜ ๋ฐฉ๋ฒ•์œผ๋กœ๋Š” ๊ด€๋ จ TABLESPACE๋ฅผ ์žฌ๊ตฌ์„ฑํ•˜๋Š” ๊ฒƒ 
----- 
ํ˜„์ƒ : ORA-1552 (CANNOT USE SYSTEM ROLLBACK SEGMENT FOR NON-SYSTEM TABLESPACE '%S') 
์›์ธ : SYSTEM TABLESPACE ์ด์™ธ์˜ TABLESPACE๋ฅผ ํฌํ•จํ•œ OPERATION์„ ์œ„ํ•˜์—ฌ SYSTEM TABLESPACE์˜ 
ROLLBACK SEGMENT๋ฅผ ์‚ฌ์šฉํ•  ๊ฒฝ์šฐ์— ๋ฐœ์ƒ 
์กฐ์น˜ : SYSTEM TABLESPACE์— ํ•˜๋‚˜ ์ด์ƒ์˜ ROLLBACK SEGMENT๋ฅผ ์ถ”๊ฐ€ํ•œ ๋‹ค์Œ, ๋ฐ์ดํƒ€๋ฒ ์ด์Šค ์˜ค๋ธŒ์ ํŠธ๋ฅผ 
์ƒ์„ฑ 
----- 
ํ˜„์ƒ : ORA-1555 Snapshot Too Old 
์›์ธ : 1.๋ฐ์ดํƒ€์˜ ๋ณ€๊ฒฝ์ด ์‹ฌํ•œ ๋ฐ์ดํƒ€๋ฒ ์ด์Šค์—์„œ ๋กค๋ฐฑ ์„ธ๊ทธ๋จผํŠธ์˜ ๊ฐฏ์ˆ˜์™€ ํฌ๊ธฐ๊ฐ€ ์ž‘์„ ๊ฒฝ์šฐ์— ๋ฐœ์ƒ 
2.๋กค๋ฐฑ ์„ธ๊ทธ๋จผํŠธ๊ฐ€ ์†์ƒ๋˜์–ด ์ฝ์„ ์ˆ˜ ์—†๊ฒŒ ๋œ ๊ฒฝ์šฐ 
3.Fetch Across Commit(ํ…Œ์ด๋ธ”์— ๋Œ€ํ•˜์—ฌ Query๊ฐ€ ์ปค์„œ๋ฅผ ์—ด๊ณ  ๋ฃจํ”„ ๋‚ด์—์„œ ๋ฐ์ดํƒ€๋ฅผ Fetch 
ํ•˜๊ณ  ๋ณ€๊ฒฝํ•˜๊ณ  ์ปค๋ฐ‹ํ•˜๋Š” ๊ณผ์ •์—์„œ ๋ฐœ์ƒ) 
4.Delayed Block Clean Out(๋ฐ์ดํƒ€ ๋ธ”๋Ÿญ์ด ๋ณ€๊ฒฝ๋˜๊ณ  ์ปค๋ฐ‹๋˜๋ฉด ์˜ค๋ผํด์€ ๋กค๋ฐฑ์„ธ๊ทธ๋จผํŠธ ํ—ค๋”์— 
๊ทธ ํŠธ๋žœ์žญ์…˜์ด ์ปค๋ฐ‹๋˜์—ˆ๋‹ค๊ณ  ๊ธฐ๋กํ•˜์ง€๋งŒ ๋ฐ์ดํƒ€ ๋ธ”๋Ÿญ์„ ๋ฐ”๋กœ ๋ณ€๊ฒฝํ•˜์ง€๋Š” ์•Š๋Š”๋‹ค (Fast 
Commit). ๊ทธ๋ฆฌ๊ณ  ๋‹ค์Œ ํŠธ๋žœ์žญ์…˜์ด ๋ณ€๊ฒฝ๋œ ๋ธ”๋Ÿญ์„ ์š”๊ตฌํ•  ๋•Œ์•ผ ๋น„๋กœ์†Œ ๋ณ€๊ฒฝ ์‹œํ‚ค๋Š”๊ฒƒ 
์กฐ์น˜ : 1.์ปค์„œ๊ฐ€ Open๋œ ์ƒํƒœ์—์„œ๋Š” ์ปค๋ฐ‹์„ ์ž์ฃผํ•˜์ง€ ์•Š๊ณ  ๋กค๋ฐฑ ์„ธ๊ทธ๋จผํŠธ ํฌ๊ธฐ๋ฅผ ํ‚ค์›Œ ๋‚˜๊ฐ€๋„๋ก 
2.์ปค์„œ๋ฅผ ์‚ฌ์šฉํ•˜๊ธฐ ์ „์— Full Table Scan์„ ํ•ด์ฃผ๋ฉด ์˜ˆ๋ฐฉ์ด ๊ฐ€๋Šฅ 
----- 
ํ˜„์ƒ : ORA-1562(Failed to extend rollback segment(id = %s)) 
์›์ธ : 1.์‚ฌ์šฉ์ค‘์ธ ACTIVE ์ƒํƒœ์˜ ROLLBACK SEGMENT๊ฐ€ ๋‹ค์Œ EXTENT๋ฅผ ํ• ๋‹นํ•˜๊ณ ์ž ํ•  ๊ฒฝ์šฐ 
2.ํ•ด๋‹น ROLLBACK SEGMENT์— ๋Œ€ํ•˜์—ฌ ๋ฐœ์ƒ ๊ฐ€๋Šฅํ•œ ์ตœ๋Œ€ EXTENT ์ˆ˜๋ฅผ ์ดˆ๊ณผํ• ๋•Œ ๋ฐœ์ƒ 
์กฐ์น˜ : ROLLBACK SEGMENT์˜ ์žฌ์ƒ์„ฑ 
----- 
ํ˜„์ƒ : ORA-01578: ORACLE data block corrupted (file # 6, block # 3) 
ORA-01110: data file 6: '/tmp/ts_corrupt.dbf' 
์›์ธ : 
์กฐ์น˜ : ํ•ด๋‹น objects๋ฅผ dropํ•˜๊ณ  recreateํ•˜์—ฌ ์ฒ˜๋ฆฌ 
----- 
ํ˜„์ƒ : ORA-01578 
์›์ธ : data block ์— corruption ์ด ์ƒ๊ธด ๊ฒฝ์šฐ์— ๋ฐœ์ƒ. 
์กฐ์น˜ : 1.์ตœ์„ ์˜ ํ•ด๊ฒฐ์ฑ…์€ backup ๋ฐ›์•„๋‘” file ์„ restore ํ•œ ํ›„ recover ์ž‘์—…์„ ํ•˜๋Š” ๊ฒƒ์ด๋‹ค. 
2.backup datafile ์„ restore ํ•˜๊ณ  recover ํ•˜์ง€ ์•Š์„ ๊ฒƒ์ด๋ผ๋ฉด ์šฐ์„ , ์–ด๋–ค object ์—์„œ corruption ์ด ๋ฐœ์ƒํ•˜์˜€๋Š”์ง€ ํ™•์ธํ•ด์•ผ ํ•œ๋‹ค. 
3.ํ•ด๋‹น segment ๊ฐ€ non-data dictionary index ๋ผ๋ฉด, ํ•ด๋‹น index ๋ฅผ drop ํ•œ ํ›„ ์žฌ์ƒ์„ฑํ•œ๋‹ค. 
4.ํ•ด๋‹น segment ๊ฐ€ table ์ด๋ผ๋ฉด, corruption ์ด ๋ฐœ์ƒํ•œ block ์˜ data ๋Š” ์†Œ์‹ค๋œ ๊ฒƒ์ด๋‹ค. 
5.๋งŒ์•ฝ ํ•ด๋‹น table ์— ๋Œ€ํ•œ ์ตœ๊ทผ์˜ export dump file ์ด ์กด์žฌํ•œ๋‹ค๋ฉด, ํ•ด๋‹น table ์„ drop ํ•œ ํ›„ import ํ•จ์œผ๋กœ์จ ๋ณต๊ตฌํ•  ์ˆ˜ ์žˆ๋‹ค. 
6.corruption ์ด ๋ฐœ์ƒํ•œ non-clustered table ์—์„œ corrupted block ์„ 
access ํ•˜์ง€ ์•Š๊ณ  ๋‚˜๋จธ์ง€ data ๋“ค์„ select ํ•  ์ˆ˜ ์žˆ๋„๋ก ROWID ๋ฅผ ์ด์šฉํ•  
์ˆ˜ ์žˆ๋‹ค. 
7.๋งŒ์•ฝ data dictionary ์— ์†ํ•˜๋Š” table, index ๋˜๋Š” rollback segment์— 
corrupted block ์ด ๋ฐœ์ƒํ•˜์˜€๋‹ค๋ฉด Oracle Support ์˜ ์ง€์›์„ ๋ฐ›๋Š”๋‹ค. 
8.์ผ๋ฐ˜์ ์œผ๋กœ, ORA-1578 ์€ hardware ์˜ ๋ฌธ์ œ๋•Œ๋ฌธ์— ์œ ๋ฐœ๋œ๋‹ค. ํ•˜์ง€๋งŒ ๋งŒ์•ฝ์— 
ORA-600[3374] ๊ฐ€ ๋ฐœ์ƒํ•œ๋‹ค๋ฉด memory ์ƒ์—์„œ corruption ์ด ๋ฐœ์ƒํ•œ 
๊ฒฝ์šฐ์ด๋‹ค. ์ด ๊ฒฝ์šฐ database ๋ฅผ restartup ํ•˜๋ฉด ๋ฌธ์ œ๊ฐ€ ํ•ด๊ฒฐ๋  ์ˆ˜ ์žˆ๋‹ค. 
----- 
ํ˜„์ƒ : ORA-1591(Pending Transaction์˜ ์ฒ˜๋ฆฌ) 
์›์ธ : ๋ถ„์‚ฐ ํŠธ๋žœ์žญ์…˜์˜ ๊ฒฝ์šฐ 2 phase commit์ˆ˜ํ–‰ ๋‹จ๊ณ„์ค‘์— fail์ด ๋ฐœ์ƒํ•˜๊ฒŒ ๋˜๋ฉด ๊ด€์—ฌ๋œ ์ผ๋ถ€ database์—์„œ๋Š” rollback ํ˜น์€ commit์ด ๋˜๊ณ , ์ผ๋ถ€๋Š” distributed lock์ด ๊ฑธ๋ฆฐ ์ƒํƒœ๋กœ ๊ณ„์† ์ง€์†๋  ์ˆ˜ ์žˆ๋‹ค. 
์ด๋ ‡๊ฒŒ pending๋œ transaction์— ๋Œ€ํ•ด์„œ๋Š” ๊ธฐ๋ณธ์ ์œผ๋กœ Oracle์˜ background process์ธ RECO process๊ฐ€ ์ž๋™์œผ๋กœ ์ •๋ฆฌํ•˜์—ฌ ์ฃผ๋‚˜, ๊ฒฝ์šฐ์— ๋”ฐ๋ผ ์ž๋™์œผ๋กœ ์ •๋ฆฌ๊ฐ€ ๋˜์ง€ ๋ชปํ•˜๋Š” ์ƒํ™ฉ์ด ๋ฐœ์ƒ 
์กฐ์น˜ : STEP 1: alert.log file์„ checkํ•œ๋‹ค. 
STEP 2: network ํ™˜๊ฒฝ์„ ํ™•์ธํ•œ๋‹ค. 
STEP 3: RECO process๊ฐ€ ๋–  ์žˆ๋Š”์ง€ ํ™•์ธํ•œ๋‹ค. 
STEP 4: DBA_2PC_PENDING์„ ์กฐํšŒํ•ด ๋ณธ๋‹ค. 
STEP 5: DBA_2PC_NEIGHBORS view๋ฅผ ์กฐํšŒํ•ด ๋ณธ๋‹ค. 
STEP 6: commit point site๋ฅผ ํ™•์ธํ•œ๋‹ค. 
STEP 7: DBA_2PC_PENDING์˜ MIXED column์„ ํ™•์ธํ•œ๋‹ค. 
STEP 8: DBA_2PC_PENDING์˜ STATE column์˜ ๊ฐ’์„ ํ™•์ธํ•œ๋‹ค. 
STEP 9: ๋ถˆ์ผ์น˜ ์‚ฌํ•ญ์„ ํŒŒ์•…ํ•˜๊ณ  DBA_2PC_PENDING์„ ์ •๋ฆฌํ•œ๋‹ค. 

2PC์—์„œ 1st phase commit(xa_prepare)์ด ์ •์ƒ์ ์œผ๋กœ ์ข…๋ฃŒ๋˜๋ฉด Oracle์˜ dba_pending_transaction์— ํ•ด๋‹น 
Transaction์— ๋Œ€ํ•œ ์ •๋ณด๊ฐ€ ๋‚˜ํƒ€๋‚œ๋‹ค. 

formatid 40 
globalid 636861656A750000000000000000000000000000000000 
5B5103A6BEC9900000DE8 
branchid 0000006600000065 

์ด ์ƒํƒœ์—์„œ ์ผ์ •ํ•œ ์‹œ๊ฐ„ ๋‚ด์— 2nd phase commit(xa_commit)์— ๋๋‚˜์ง€ ์•Š์œผ๋ฉด dba_2pc_pending์—๋„ ์ด 
Transaction์ด ๋‚˜ํƒ€๋‚œ๋‹ค. 

local_tran_id 4.24.3026 
global_tran_id 40.636861656A750000000000000000000000000000000000 
5B5103A6BEC9900000DE8 
state prepared 
mixed no 
advice 
tran_comment 
fail_time 
force_time 
retry_time 
os_user jun 
os_termina 
host chaeju 
db_user 
commit# 5332231 

์œ„์—์„œ "์ผ์ •ํ•œ ์‹œ๊ฐ„"์ด๋ž€ ์šฉ์–ด๋ฅผ ์‚ฌ์šฉํ–ˆ๋Š”๋ฐ Oracle์˜ ๋ฌธ์„œ์—๋Š” ์ด์— ๊ด€ํ•œ ์ •ํ™•ํ•œ ์–ธ๊ธ‰์€ ์—†๋‹ค. 
๋‹ค๋งŒ, ๋‹ค๋ฅธ Transaction์—์„œ ํ•ด๋‹น ๋ ˆ์ฝ”๋“œ๋ฅผ ์ฐธ์กฐํ•˜๋ ค๊ณ  ํ•  ๋•Œ ์ด๋ฏธ lock์ด ๊ฑธ๋ ค ์žˆ์œผ๋ฏ€๋กœ ๋Œ€๊ธฐํ•˜๋Š” 
์‹œ๊ฐ„์— ๋Œ€ํ•ด์„œ๋Š” init.ora์—์„œ ์ง€์ •ํ•˜๋Š” distributed_lock_timeout์— ๋Œ€ํ•ด์„œ๋งŒ ์–ธ๊ธ‰ํ•˜๊ณ  ์žˆ๋‹ค. ๊ทธ๋Ÿฐ๋ฐ 
oracle 8.1.7์—์„œ๋Š” distributed_lock_timeout์„ ์„ค์ •ํ•˜๋ฉด obsolete๋กœ ๋‚˜์˜จ๋‹ค. 

์ด ์‹œ๊ฐ„ ๋™์•ˆ์— ํ•ด๋‹น ๋ ˆ์ฝ”๋“œ์— ๋Œ€ํ•œ lock์ด ํ’€๋ฆฌ์ง€ ์•Š์œผ๋ฉด ์•„๋ž˜์™€ ๊ฐ™์€ ์—๋Ÿฌ๋ฅผ ๋งŒ๋‚œ๋‹ค. 

ORA-02049: time-out: distributed transaction waiting for lock 

์œ„์˜ ์—๋Ÿฌ๊ฐ€ ๋ฐœ์ƒํ•œ ์ดํ›„์— ์ด ๋ ˆ์ฝ”๋“œ๋ฅผ ์ฐธ์กฐํ•˜๋ ค๊ณ  ํ•˜๋ฉด 1591 ์—๋Ÿฌ๊ฐ€ ๋‚˜ํƒ€๋‚œ๋‹ค. 

ORA-01591: lock held by in-doubt distributed transaction '4.24.3026' 

๋ณด๋Š” ๊ฒƒ์ฒ˜๋Ÿผ ORA-01591 ์—๋Ÿฌ ๋ฉ”์‹œ์ง€์—๋Š” local_tran_id๊ฐ€ ์žˆ๋‹ค. ์ด๋ฅผ ์ด์šฉํ•˜์—ฌ dba_2pc_pending์—์„œ 
global_tran_id๋ฅผ ์กฐํšŒํ•˜๊ณ , ์ด ๋ฐ์ดํ„ฐ๋Š” dba_pending_transaction์˜ formatid์™€ globalid๋กœ ์ด๋ฃจ์–ด์ ธ 
์žˆ์œผ๋ฏ€๋กœ ์ด๋ฅผ ์ด์šฉํ•˜์—ฌ dba_pending_transaction์—์„œ branchid๋„ ์–ป์„ ์ˆ˜ ์žˆ๋‹ค. 

์ด๋“ค๋กœ ๋ถ€ํƒ€ ์•„๋ž˜์™€ ๊ฐ™์ด XID๋ฅผ ์–ป์„ ์ˆ˜ ์žˆ๋‹ค. 

xid.formatid = dba_pending_transactions.formatid 
xid.gtrid_length = len(dba_pending_transactions.globalid) 
xid.bqual_length = len(dba_pending_transactions.branchid) 
xid.data = dba_pending_transactions.globalid + dba_pending_transactions.branchid 

์—ฌ๊ธฐ๊นŒ์ง€๋Š” Oracle๋กœ ๋ถ€ํ„ฐ XID๋ฅผ ์–ป๋Š” ๊ณผ์ •์ด๋‹ค. 

tpconvert(str, (char *)&xid, TPTOSTRING | TPCONVXID)๋ฅผ ์ด์šฉํ•˜์—ฌ XID์˜ string ํ‘œํ˜„์„ ์–ป์„ ์ˆ˜ ์žˆ๊ณ  
์ด๊ฐ’์„ ์ด์šฉํ•˜์—ฌ .TMIB ์„œ๋น„์Šค๋ฅผ ํ˜ธ์ถœํ•˜๋ฉด ์•„๋ž˜์™€ ๊ฐ™์€ ์ •๋ณด๋ฅผ ์–ป์„ ์ˆ˜ ์žˆ๋‹ค. 

TA_ERROR 0 
TA_MORE 0 
TA_OCCURS 1 
TA_GRPCOUNT 2 
TA_GRPINDEX 0 
TA_GRPNO 102 
TA_GRPNO 101 
TA_TIMEOUT 9 
TA_COORDGRPNO 102 
TA_CLASS T_TRANSACTION 
TA_STATE READY 
TA_COORDLMID SITE1 
TA_GSTATE READY 
TA_GSTATE READY 
TA_TPTRANID 0x0 0x3a6bec99 0xde8 0x28 0x0 0x0 
TA_XID 0x0 0x3a6bec99 0xde8 0x28 0x66 
TA_COORDSRVGRP APPGRP2 
TA_LMID SITE1 
TA_SRVGRP APPGRP2 
TA_SRVGRP APPGRP1 

์œ„์˜ ๊ฒฝ์šฐ์—๋Š” ์•„์ง Tuxedo๊ฐ€ transaction์— ๋Œ€ํ•œ ์ •๋ณด๋ฅผ ๊ฐ€์ง€๊ณ  ์žˆ๊ธฐ ๋•Œ๋ฌธ์— ๋ณ„๋‹ค๋ฅธ ์กฐ์น˜๊ฐ€ ํ•„์š”์—†๋‹ค. 
ํ•˜์ง€๋งŒ, Oracle์˜ dba_2pc_pending์—๋Š” ์žˆ๋Š”๋ฐ Tuxedo์—์„œ ํ•ด๋‹น Transaction์— ๋Œ€ํ•œ ์ •๋ณด๋ฅผ ๊ฐ€์ง€๊ณ  
์žˆ์ง€ ์•Š์€ ๊ฒฝ์šฐ์—๋Š” Oracle์—์„œ rollback force๋‚˜ commit force๋ฅผ ์ด์šฉํ•˜์—ฌ pending transaction์„ 
์ •๋ฆฌํ•ด ์ฃผ์–ด์•ผ๋งŒ lock์ด ํ’€๋ฆฐ๋‹ค. 
----- 
ํ˜„์ƒ : ORA-1628, 00000, "max # extents (%s) reached for rollback segment %s" 
ORA-1630, 00000, "max # extents (%s) reached in temp segment in tablespace %s" 
ORA-1631, 00000, "max # extents (%s) reached in table %s.%s" 
ORA-1632, 00000, "max # extents (%s) reached in index %s.%s" 
์›์ธ : ์˜ค๋ธŒ์ ํŠธ์˜ ์ต์Šคํ…ํŠธ๊ฐ€ MAX # ์— ๋„๋‹ฌ ํ–ˆ๊ธฐ ๋•Œ๋ฌธ์— ๋ฐœ์ƒ๋˜๋ฉฐ ์˜ค๋ธŒ์ ํŠธ์˜ MAXEXTENTS๋Š” 
STORAGE ์˜ MAXEXTENTS ํŒŒ๋ผ๋ฏธํ„ฐ์— ์˜ํ•ด ๊ฒฐ์ • 
์กฐ์น˜ : ALTER TABLE .. STORAGE (MAXEXTENTS n)๋ฅผ ์‚ฌ์šฉํ•˜์—ฌ ์ตœ๋Œ€ MAXEXTENTS ๊ฐ’๋ณด๋‹ค ์ž‘์€ ์ˆ˜๋กœ 
MAXEXTENTS๋ฅผ ๋Š˜๋ ค์ค€๋‹ค. 
----- 
ํ˜„์ƒ : ORA-1652, 00000, "unable to extend temp segment by 6144 in tablespace "VESSEL" 
์›์ธ : ํ…Œ์ด๋ธ”์ด๋‚˜ ์ธ๋ฑ์Šค ๋“ฑ์„ ๋งŒ๋“ค ๋•Œ ์ž์‹ ์˜ TEMP TABLESPACE ๊ฐ€ ์•„๋‹Œ ๊ณณ์—์„œ ORA-1652(temp 
tablespace๊ฐ€ ๋ถ€์กฑํ•จ) ์—๋Ÿฌ๊ฐ€ ๋ฐœ์ƒ 
์กฐ์น˜ : ์—๋Ÿฌ๋ฉ”์‹œ์ง€์—์„œ ๋ณด์—ฌ์ฃผ๋Š” ๋Œ€๋กœ ํ•ด๋‹น ํ…Œ์ด๋ธ”์ŠคํŽ˜์ด์Šค์— Temporary Segment ๊ฐ€ ์ƒ์„ฑ๋  ๋งŒํ•œ 
์—ฐ์†๋œ ๊ณต๊ฐ„์„ ๋งˆ๋ จํ•˜์—ฌ ์ฃผ๋Š” ๊ฒƒ 
----- 
ํ˜„์ƒ : ORA-1653 
์›์ธ : ํŠน์ • tablespace ์— space ๊ฐ€ ๋ถ€์กฑํ•ด์„œ table์˜ extent๊ฐ€ ์ผ์–ด๋‚˜์ง€ ๋ชปํ•ด์„œ ๋ฐœ์ƒ 
์กฐ์น˜ : user์˜ default tablespace ๋ฅผ ๋ณ€ํ™˜ํ•œ ํ›„, ์ด default tablespace 
์•ˆ์— create table์„ ๋‹ค์‹œ ํ•œ ํ›„ sql*loader ๋ฅผ ์‹คํ–‰ํ•œ๋‹ค 
----- 
ํ˜„์ƒ : ORA-1654 ERROR ON INDEX SEGMENT 
์›์ธ : tablespace๊ฐ€ ์ ์–ด extent ์˜์—ญ์„ ํ• ๋‹นํ•  ์ˆ˜ ์—†์–ด์„œ ๋ฐœ์ƒ 
์กฐ์น˜ : datafile์„ ์ถ”๊ฐ€ ์‹œ ์ด์ „๊ฐ’ ์ด์ƒ์˜ ์‚ฌ์ด์ฆˆ๋ฅผ ์ถ”๊ฐ€ํ•ด์•ผ ํ•จ. 
----- 
ํ˜„์ƒ : ORA-1722 invalid number 
์›์ธ : ์ˆ˜์น˜๊ฐ’์ด ๋ถˆ๋ฒ•์ผ ๊ฒฝ์šฐ 
----- 
ํ˜„์ƒ : ORA-1747 ์—ด๋ช…์„ ์˜ฌ๋ฐ”๋ฅด๊ฒŒ ์ง€์ •ํ•ด ์ฃผ์‹ญ์‹œ์š”. 
์›์ธ : ์—ด๋ช…์ด ๋‹ค๋ฅธ ๊ฒฝ์šฐ(SQL๋ฌธ์žฅ ๊ธฐ์ˆ ์‹œ ์ฒซ๋ฒˆ์งธ ์—ด๋ช… ์•ž์— Comma๋ฅผ ์‚ฝ์ž…ํ•œ ๊ฒฝ์šฐ) 
----- 
ํ˜„์ƒ : tb_ra315 insert error ORA-02291: integrity constraint (SCRJAPPR.A315_E007_FK) 
violated - parent .... 
์›์ธ : Table๊ณผ ๊ด€๋ จ๋œ Reference ๊ด€๊ณ„๋กœ parent table์˜ data๊ฐ€ ์—†๋Š” ๊ด€๊ณ„๋กœ data ์ž…๋ ฅ๋ถˆ๊ฐ€ 
์กฐ์น˜ : Reference ๊ด€๊ณ„๋ฅผ ๋ˆ์–ด์ฃผ๋“ ์ง€ ์•„๋‹ˆ๋ฉด ๊ด€๊ณ„๋œ Table์— Data๋ฅผ ๋ชจ๋‘ ์ž…๋ ฅํ•˜๋Š” ๋ฐฉ๋ฒ•. 
----- 
ํ˜„์ƒ : ORA-02303: cannot drop or replace a type with type or table dependents 
์›์ธ : Type์ด๋‚˜ table์˜ dependency๊ฐ€ ์žˆ๋Š” type์„ dropํ•˜๊ฑฐ๋‚˜ replaceํ•˜๊ณ ์ž ํ•  ๋•Œ ๋ฐœ์ƒ. 
์กฐ์น˜ : SQL Reference guide์— ์˜ํ•˜๋ฉด DROP TYPE FORCE ์˜ต์…˜์€ recommendํ•˜์ง€ ์•Š๋Š”๋‹ค. 
์™œ๋ƒํ•˜๋ฉด ์ด ์˜ต์…˜์„ ์“ฐ๊ฒŒ ๋˜๋ฉด ๋ณต๊ตฌ๊ฐ€ ๋ถˆ๊ฐ€๋Šฅํ•˜๊ณ  dependency๊ฐ€ ์žˆ๋˜ table๋“ค์€ 
accessํ•˜์ง€ ๋ชปํ•˜๋Š” ๊ฒฐ๊ณผ๋ฅผ ์ดˆ๋ž˜ํ•œ๋‹ค. 
----- 
ํ˜„์ƒ : ORA-03113: end-of-file on communication channel 
์›์ธ : 1.์ด์ „์— ์ž‘๋™ํ–ˆ๋˜ ํ•ด๋‹น instance์˜ shared memory segment๋“ค์ด ์•„์ง system์— ๋‚จ์•„์žˆ์–ด์„œ ๋ฐœ์ƒ. 
2.์„œ๋ฒ„์˜ Oracle ์‰๋„ ํ”„๋กœ์„ธ์Šค๊ฐ€ ์˜ˆ๊ธฐ์น˜ ์•Š๊ฒŒ ์ข…๋ฃŒ๋œ ๊ฒฝ์šฐ ๋ฐœ์ƒ. 
3.SQL*NET ๋“œ๋ผ์ด๋ฒ„๊ฐ€ Unix์˜ ORACLE ์‹คํ–‰ ํŒŒ์ผ๊ณผ ์—ฐ๊ฒฐ๋˜์ง€ ์•Š์•„ ๋ฐœ์ƒํ•œ ๊ฒฝ์šฐ. 
4.์„œ๋ฒ„์ชฝ์˜ ๊ธฐ๊ณ„ ์†์ƒ์ด๋‚˜ ๋„คํŠธ์›Œํฌ ๊ณ ์žฅ์ธ ๊ฒฝ์šฐ. 
5.๋„คํŠธ์›Œํฌ์—์„œ ๋‘ ์„œ๋ฒ„๊ฐ€ ๊ฐ™์€ ๋…ธ๋“œ ์ด๋ฆ„์„ ๊ฐ€์งˆ ๋•Œ์—๋„ ์ด ์˜ค๋ฅ˜๊ฐ€ ๋ฐœ์ƒ. 
6.๋ชจ๋“  ์›์ธ์€ ๊ฒฐ๊ตญ ํด๋ผ์ด์–ธํŠธ๊ฐ€ ์„œ๋ฒ„๋กœ๋ถ€ํ„ฐ ์–ด๋–ค ์ •๋ณด๋ฅผ ์ฝ์œผ๋Ÿฌ ๊ฐ”๋‹ค๊ฐ€ ๊ฑฐ๊ธฐ์„œ ๋” ์ด์ƒ ์—ฐ๊ฒฐ์ด ์—†์Œ์„ ๋ฐœ๊ฒฌํ–ˆ๋‹ค๋Š” ๋œป์ž„. 
7.Oracle XA๋ฅผ ์‚ฌ์šฉํ•˜๋Š” AP ์„œ๋ฒ„ ํ˜น์€ TMS ์„œ๋ฒ„๊ฐ€ ๋–  ์žˆ๋Š” ์ƒํ™ฉ์—์„œ ์—ฐ๊ฒฐ๋œ DB๋ฅผ ์žฌ๊ธฐ๋™ ์‹œํ‚ค๊ฑฐ๋‚˜ ํ˜น์€ ๋‹ค๋ฅธ ๋ฌธ์ œ๋กœ ์ธํ•ด์„œ ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค์™€์˜ ์—ฐ๊ฒฐ์ด ๋Š์–ด์ง„ ๊ฒฝ์šฐ์— ๋ฐœ์ƒ 
์กฐ์น˜ : shared memory๋ฅผ checkํ•˜์—ฌ oracle์ด ์†Œ์œ ํ•˜๊ณ  ์žˆ๋Š” shared memory segment๋ฅผ ์‚ญ์ œํ•˜์—ฌ ๋ฌธ์ œ๋ฅผ ํ•ด๊ฒฐ. 
์ž๋™์œผ๋กœ ์žฌ์ ‘์†์„ ํ•˜๊ธฐ ์œ„ํ•ด์„œ๋Š” TUXWA4ORACLE(WorkAround For Oracle) ํ™˜๊ฒฝ๋ณ€์ˆ˜๋ฅผ 1๋กœ ์„ค์ •ํ•˜๋ฉด ํ•ด๋‹น ์„œ๋ฒ„๊ฐ€ ์˜ค๋ผํด์— ์ ‘๊ทผํ•˜์—ฌ 3113 ์—๋Ÿฌ๊ฐ€ ๋ฐœ์ƒํ•˜๋Š” ์ˆœ๊ฐ„์— ์žฌ์ ‘์†์ด ์ด๋ฃจ์–ด์ง„๋‹ค. 
(XA ์„œ๋ฒ„์—๋งŒ ํ•ด๋‹น๋˜๋ฉฐ Non-XA ์„œ๋ฒ„์˜ ๊ฒฝ์šฐ๋Š” ์‚ฌ์šฉ์ž coding์— ์˜ํ•ด์„œ ๋™์ผํ•œ ๊ธฐ๋Šฅ์„ ๊ตฌํ˜„ํ•  ์ˆ˜ ์žˆ๋‹ค.) 
----- 
ํ˜„์ƒ : ORA-3114 Error( not connected to ORACLE )๊ฐ€ ๋ฐœ์ƒ 
์›์ธ : ORACLE์ด Shutdown ๋˜์—ˆ๋‹ค. 
์กฐ์น˜ : ORACLE์ด ๋–  ์žˆ๋Š”์ง€ ํ™•์ธํ•˜๊ณ , Server๋ฅผ ์ƒˆ๋กœ ๊ธฐ๋™ํ•œ๋‹ค. 
----- 
ํ˜„์ƒ : ORA-3121 
์›์ธ : SQL*NET V2๋ฅผ ํ†ตํ•ด ์—ฐ๊ฒฐํ•˜๋ ค ํ•  ๋•Œ ์—ฐ๊ฒฐ ์ŠคํŠธ๋ง์— 'tns:'net์ ‘๋‘์–ด๋ฅผ ์‚ฌ์šฉํ•˜์ง€ ์•Š์€ ๊ฒฝ์šฐ 
์กฐ์น˜ : ๊ตฌ๋ฒ„์ „์ธ SQL*NET V1์˜ net ์ ‘๋‘์–ด (SQL*Net TCP/IP์— ๋Œ€ํ•œ "t:"๋“ฑ)๋ฅผ ์‚ฌ์šฉํ•˜์ง€ ์•Š๋„๋ก ์ฃผ์˜ 
ํ•˜์‹ญ์‹œ์š”. 
----- 
ํ˜„์ƒ : ORA-4068 existing state of packages%s%s%s has been discarded 
์›์ธ : ์‘์šฉํ”„๋กœ๊ทธ๋žจ ์‹คํ–‰ ์ค‘์— ์‚ฌ์šฉํ•˜๊ณ  ์žˆ๋Š” Stored Procedure๋ฅผ Compileํ•˜๋Š” ๊ฒฝ์šฐ์— ๋ฐœ์ƒ 
์กฐ์น˜ : ์‘์šฉํ”„๋กœ๊ทธ๋žจ์„ ์žฌ๊ธฐ๋™์‹œํ‚จ๋‹ค. 
----- 
ํ˜„์ƒ : ORA-4091 table name is mutating, trigger/function may not see it 
์›์ธ : DataBase Trigger๊ฐ€ Transaction ๋‚ด์—์„œ ๋ณ€๊ฒฝ๋œ ํ…Œ์ด๋ธ”์— ๋Œ€ํ•˜์—ฌ Query๋ฅผ ๊ธฐ๋™ํ•  ๋•Œ ๋ฐœ์ƒ 
์กฐ์น˜ : 1.PL/SQL table์„ ์ƒ์„ฑํ•œ๋‹ค. 
2.BEFORE STATEMENT trigger๋ฅผ ์ƒ์„ฑํ•œ๋‹ค. 
3.AFTER ROW trigger๋ฅผ ์ƒ์„ฑํ•œ๋‹ค. 
4.AFTER STATEMENT trigger๋ฅผ ์ƒ์„ฑํ•œ๋‹ค. 
5.data insert ๋ฐ ํ™•์ธ 
----- 
ํ˜„์ƒ : ORA-4092 cannot COMMIT or ROLLBACK in a trigger 
์›์ธ : 1.Trigger๊ฐ€ COMMIT or ROLLBACK์„ ์‹คํ–‰ํ•˜๊ณ ์ž ํ•  ๋•Œ ๋ฐœ์ƒ 
2.Trigger๊ฐ€ ๋‚ด์žฅ ํ”„๋กœ์‹œ์ €, COMMIT๋‚˜ ROLLBACK๋  ํ•จ์ˆ˜, ํŒจ์บ์ง€ ์„œ๋ธŒํ”„๋กœ๊ทธ๋žจ์„ ํ˜ธ์ถœํ•œ ๊ฒฝ์šฐ 
----- 
ํ˜„์ƒ : ORA-6106,ORA-6120 NETTCP : socket creation failure 
์›์ธ : WIN V1.X์šฉ SQL*NET TCP/IP๋Š” SQLTCP.DLL๊ณผ SQLTCP1.DLL๋“ค์€ ORACLE์šฉ ์—ฐ๊ฒฐ ์ŠคํŠธ๋ง์ด TCP/IP 
ํ”„๋กœํ† ์ฝœ ์ŠคํŠธ๋ง์œผ๋กœ ๋ณ€ํ™˜๋˜๋ฉด OCI DLL์— ์˜ํ•ด ์ž‘์—… ์ง„ํ–‰์ค‘์— ์˜ฌ๋ ค์ง‘๋‹ˆ๋‹ค. ORACLE INTERFACE 
DLL์€ SQLTCP.DLL์„ ๋จผ์ € ์˜ฌ๋ฆฌ๋ ค๊ณ  ํ•ฉ๋‹ˆ๋‹ค. ์ด๊ฒƒ์ด ์‹คํŒจํ•˜๋ฉด DOS TSR ๋ฒ„์ „์˜ ๋“œ๋ผ์ด๋ฒ„๋ฅผ 
์ฐพ์Šต๋‹ˆ๋‹ค. ๋‘ ๊ฐ€์ง€ ๋ชจ๋‘ ์‹คํŒจํ•˜๋ฉด ORA-3121 ๋ฉ”์„ธ์ง€๊ฐ€ ๋‚˜์˜ต๋‹ˆ๋‹ค. 
----- 
ํ˜„์ƒ : ORA-6108 
์›์ธ : 1.๋ถ€์ ์ ˆํ•œ machine, ๋˜๋Š” machine๋Š” ๋งž์ง€๋งŒ ํ‹€๋ฆฐ ํฌํŠธ๋ฅผ ์ง€์ •ํ•  ๋•Œ ๋ฐœ์ƒ 
2.TCP/IP ๋ ˆ์ด์–ด๋Š” ๋ชจ๋“  ์—ฐ๊ฒฐ ์š”๊ตฌ๋ฅผ Listener์˜ ์†Œ์ผ“ ํ์— ๋„ฃ์„ ์ˆ˜ ์—†์„ ๊ฒฝ์šฐ ๋ฐœ์ƒ 
3.๋„คํŠธ์›Œํฌ๊ฐ€ ์•„์ฃผ ํ˜ผ์žกํ•˜๊ณ  ํ˜ธ์ŠคํŠธ์— ๋„๋‹ฌํ•˜๋ ค๋Š” ์ค‘์— ์‹œ๊ฐ„์ด ์ข…๋ฃŒํ•  ๊ฒฝ์šฐ 
์กฐ์น˜ : 1.ํด๋ผ์ด์–ธํŠธ์—์„œ ํ˜ธ์ŠคํŠธ Machine์— ๋Œ€ํ•ด ping์„ ์‹คํ–‰ํ•˜์‹ญ์‹œ์š”. ๋Œ€๋ถ€๋ถ„์˜ PC TCP/IP์—…์ฒด๋Š” 
"ping" ์œ ํ‹ธ๋ฆฌํ‹ฐ๋ฅผ ์ œ๊ณตํ•ฉ๋‹ˆ๋‹ค. ํด๋ผ์ด์–ธํŠธ Machine์—์„œ ๋‹ค์Œ์„ ์ž…๋ ฅํ•˜์‹ญ์‹œ์š” 
ping <host IP address> 
์ด ๋ฐฉ๋ฒ•์œผ๋กœ ์ž˜ ๋˜์ง€ ์•Š์œผ๋ฉด ์•„๋งˆ๋„ ํ˜ธ์ŠคํŠธ machine์ด down๋œ ๊ฒƒ์ž…๋‹ˆ๋‹ค. IP ์ฃผ์†Œ๋ฅผ ์‚ฌ์šฉ 
ํ•˜์—ฌ ํ˜ธ์ŠคํŠธ์— ๋Œ€ํ•ด ping์„ ์„ฑ๊ณต์ ์œผ๋กœ ์‹คํ–‰ํ•  ์ˆ˜ ์—†์œผ๋ฉด, ์„œ๋ฒ„์˜ ํ˜ธ์ŠคํŠธ ์ด๋ฆ„์„ ์‚ฌ์šฉํ•˜์—ฌ 
ping์„ ์‹คํ–‰ํ•ด ๋ณด์‹ญ์‹œ์š”. 
ping <hostname> 
ํ˜ธ์ŠคํŠธ ์ด๋ฆ„์„ ์‚ฌ์šฉํ•˜์—ฌ ping์„ ์‹คํ•  ์ˆ˜ ์—†์œผ๋ฉด TCP/IP ๊ตฌ์„ฑ์„ ์ ๊ฒ€ํ•˜์‹ญ์‹œ์š”. ํ˜ธ์ŠคํŠธ ์ด๋ฆ„ 
์„ ๊ฐ€์ง€๊ณ  ping์„ ์‹คํ–‰ํ•  ์ˆ˜ ์—†์œผ๋ฉด, ์—ฐ๊ฒฐ ์ŠคํŠธ๋ง์— ํ˜ธ์ŠคํŠธ ์ด๋ฆ„์„ ์‚ฌ์šฉํ•˜์—ฌ SQL*NET์™€ 
์—ฐ๊ฒฐํ•  ์ˆ˜ ์—†์Šต๋‹ˆ๋‹ค. 
2.SQL*NET TCP/IP Listener๊ฐ€ ํ•ด๋‹น ์„œ๋ฒ„์—์„œ ์‹คํ–‰์ค‘์ธ์ง€ ์ ๊ฒ€ํ•˜์‹ญ์‹œ์š”. ์„œ๋ฒ„์˜ UNIXํ”„๋กฌํ”„ํŠธ 
์—์„œ ๋‹ค์Œ์„ ์ž…๋ ฅํ•˜๋ฉด ๋ฉ๋‹ˆ๋‹ค. 
ps -al|grep "orasrv" 
์ด ๋•Œ ์ตœ์†Œํ•œ ํ•œ ํ–‰์ด ํ‘œ์‹œ๋˜์–ด์•ผ ํ•ฉ๋‹ˆ๋‹ค. ๊ทธ๋ ‡์ง€ ์•Š์œผ๋ฉด UNIX ํ”„๋กฌํ”„ํŠธ์—์„œ "orasrv" 
๋˜๋Š” "tcpctl start"๋ฅผ ์ž…๋ ฅํ•˜์—ฌ ์ˆ˜ํ™”์ž๋ฅผ ๋„์šฐ์‹ญ์‹œ์š”. SYSADMIN ํŠน๊ถŒ์„ ๊ฐ€์ง€๊ณ  ํ•ด๋‹น ๊ธฐ๊ณ„ 
์— ๋กœ๊ทธ์ธํ•ด์•ผ ํ•ฉ๋‹ˆ๋‹ค. 
3.์„œ๋ฒ„์ชฝ์—์„œ ๋ฃจํ”„๋ฐฑ์„ ํ•  ์ˆ˜ ์žˆ๋Š” ์ง€, ๋‹ค์‹œ ๋งํ•ด์„œ PC ํด๋ผ์ด์–ธํŠธ์—์„œ ์ง€์ •ํ•œ ๊ฒƒ๊ณผ ๊ฐ™์€ 
์—ฐ๊ฒฐ ์ŠคํŠธ๋ง์„ ์‚ฌ์šฉํ•˜์—ฌ ์„œ๋ฒ„์˜ ํˆด์„ ์—ฐ๊ฒฐํ•  ์ˆ˜ ์žˆ๋Š”์ง€ ์ ๊ฒ€ํ•˜์‹ญ์‹œ์š”. ์˜ˆ๋ฅผ ๋“ค๋ฉด, ์„œ๋ฒ„์˜ 
SQLPLUS ๋˜๋Š” SQLDBA๋ฅผ ํ˜ธ์ถœํ•˜๊ณ  ์„œ๋ฒ„์˜ SQLPLUS ๋˜๋Š” SQLDBA ํ”„๋กฌํ”„ํŠธ์—์„œ ๋‹ค์Œ์„ ์ž…๋ ฅ 
ํ•˜์‹ญ์‹œ์š”. 
CONNECT USERNAME/PASSWORD@t:<servername>/<portnum>:<sid> 
4.๋ฃจํ”„๋ฐฑ ์„ฑ์‚ฌ๋˜๋ฉด ํ˜ธ์ŠคํŠธ ์„œ๋ฒ„์˜ ORASRV ํฌํŠธ ๋ฒˆํ˜ธ๋ฅผ ํ™•์ธํ•˜์‹ญ์‹œ์š”. (๋Œ€๋ถ€๋ถ„์˜ ๊ธฐ๊ณ„์—์„œ 
SERVICE ํŒŒ์ผ์€ /etc ๋””๋ ‰ํ† ๋ฆฌ์— ์žˆ์Šต๋‹ˆ๋‹ค.) ๋˜ํ•œ "tcpctl" ์œ ํ‹ธ๋ฆฌํ‹ฐ๋ฅผ ์‚ฌ์šฉํ•˜๋ฉด ๋Œ€๋ถ€๋ถ„์˜ 
UNIX ๊ธฐ๊ณ„์—์„œ ORACLE Listener๋ฅผ ์‹œ์ž‘ํ•˜๊ฑฐ๋‚˜ ๋ฉˆ์ถœ ์ˆ˜ ์žˆ์Šต๋‹ˆ๋‹ค. "tcpctl stop"๋กœ Listener 
๋ฅผ ์ข…๋ฃŒํ•˜์‹ญ์‹œ์š”. "tcpctl start"์œผ๋กœ ๋‹ค์‹œ ์‹œ์ž‘ํ•˜์‹ญ์‹œ์š”. ์ด๋•Œ ์‹œ์ž‘ ํฌํŠธ์— ๊ด€ํ•œ ์ •๋ณด๊ฐ€ 
ํ‘œ์‹œ๋ฉ๋‹ˆ๋‹ค. 
5.์ด๊ฒƒ์ด ์„ฑ๊ณตํ•˜๋ฉด ํฌํŠธ๋ฅผ ์ง€์ •ํ•˜์ง€ ๋ง๊ณ  ํฌํŠธ๋ฅผ ์—ฐ๊ฒฐํ•ด ๋ณด์‹ญ์‹œ์š”. 
t:<servername>:<sid> 
์—ฐ๊ฒฐ๋˜์ง€ ์•Š์œผ๋ฉด ํด๋ผ์ด์–ธํŠธ์—์„œ SERVICE ํŒŒ์ผ์„ ์ •ํ™•ํ•˜๊ฒŒ ์„ค์ •ํ•˜ ์•Š์•˜๊ธฐ ๋•Œ๋ฌธ์ž…๋‹ˆ๋‹ค. 
a)WINDOWS\WIN.INI๋ฅผ ์ ๊ฒ€ํ•˜์—ฌ [Oracle] ๋ถ€๋ถ„์˜ ORA_CONFIG ๋งค๊ฐœ ๋ณ€์ˆ˜๊ฐ€ ์–ด๋–ค ๊ตฌ์„ฑ ํŒŒ์ผ์„ 
์ง€์‹œํ•˜๊ณ  ๋Š”์ง€ ์•Œ์•„๋ณด์‹ญ์‹œ์š”. ์ดํดํŠธ๋Š” ๋‹ค์Œ๊ณผ ๊ฐ™์Šต๋‹ˆ๋‹ค. 
[Oracle] 
ORA_CONFIG=C:\WINDOWS\ORACLE.INI 
b)ORACLE.INI ํŒŒ์ผ์„ ๋ณด๊ณ  TCP_SERVICES_FILE ๋งค๊ฐœ๋ณ€์ˆ˜๊ฐ€ ์„ค์ •๋˜์—ˆ๊ณ  SERVICES ํŒŒ์ผ์„ ์ง€์‹œ 
ํ•˜๊ณ  ์žˆ๋Š” ์ง€ ํ™•์ธํ•˜์‹ญ์‹œ์š”. 
c)SERVICES ํŒŒ์ผ์„ ๋ณด๊ณ  ๋‹ค์Œ ํ•ญ๋ชฉ์ด ์žˆ๋Š” ์ง€ ํ™•์ธํ•˜์‹ญ์‹œ์š”. 
orasrv 1525/tcp oracle 
6.๋˜ํ•œ ์„œ๋ฒ„๊ฐ€ SQL*NET V2๊ฐ€ ์•„๋‹ˆ๋ผ SQL*NET V1์„ ์‹คํ–‰์ค‘์ธ์ง€ ํ™•์ธํ•˜์‹ญ์‹œ์š”. 
7.๊ฒฐ ์ŠคํŠธ๋ง์˜ ์žฌ์‹œ๋„ ๋งค๊ฐœ๋ณ€์ˆ˜๋ฅผ ์ฆ๊ฐ€์‹œ์ผœ ๋ณด์‹ญ์‹œ์š”. ์žฌ์‹œ๋„ ํšŸ์ˆ˜๋ฅผ ์ง€์ •ํ•˜๋Š” ๊ตฌ๋ฌธ์€ ๋‹ค์Œ๊ณผ 
๊ฐ™์Šต๋‹ˆ๋‹ค. 
t:host[/service]:SID[,buffer-size][:conn-retries] 
conn-retries์˜ ๋””ํดํŠธ๋Š” 1์ž…๋‹ˆ๋‹ค. 
8.VAX์— ์—ฐ๊ฒฐํ•  ๊ฒฝ์šฐ์—๋Š” VAX config.ora ํŒŒ์ผ์— ๋‹ค์Œํ–‰์ด ์žˆ๋Š”์ง€ ํ™•์ธํ•˜์‹ญ์‹œ์š”. 
SQLNET USERNAMEMAP*=* 
์ด๊ฒƒ์€ VAX account๊ฐ€ ์—†๋Š” PC๊ฐ€ ๋””ํดํŠธ ์‚ฌ์šฉ์ž account์„ ์‚ฌ์šฉํ•˜์—ฌ ์—ฐ๊ฒฐ ํ•  ์ˆ˜ ์žˆ๊ฒŒ ํ•ด 
์ค๋‹ˆ๋‹ค. 
----- 
ํ˜„์ƒ : ORA-6110 "NETTCP: message send failure" 
์›์ธ : Windows ํด๋ผ์ด์–ธํŠธ์˜ TCP/IP์‚ฌ์ด์— ๋ฒ„ํผ ์กฐ์ •๋ฌธ์ œ๊ฐ€ ์žˆ์„ ๋•Œ ๋ฐœ์ƒ 
์กฐ์น˜ : 1.๋ฒ„ํผ ํฌ๊ธฐ๋ฅผ ์—ฐ๊ฒฐ ์ŠคํŠธ๋ง์— ํฌํ•จ์‹œ์ผœ ์ผ์ •ํ•œ ํฌ๊ธฐ๋กœ ๊ณ ์ •ํ•˜๋Š” ๊ฒƒ 
t:<servername>:<sid>,<buffersize> 
์—ฐ๊ฒฐ ์ŠคํŠธ๋ง์— ๋ฒ„ํผ ํฌ๊ธฐ๋ฅผ ํฌํ•จ์‹œํ‚จ ํ›„์—๋„ ์—ฌ์ „ํžˆ ORA-6110์ด ๋ฐœ์ƒํ•˜๋ฉด ๋” ์ž‘์€ ๊ฐ’์„ 
์‚ฌ์šฉํ•ด ๋ณด์‹ญ์‹œ์š”. WINDOWS์šฉ SQL*NET TCP/IP์˜ ๊ธฐ๋ณธ ๋ฒ„ํผ ํฌ๊ธฐ๋Š” 4096์ž…๋‹ˆ๋‹ค. ์ด๊ฒƒ์„ 
1024๋กœ ์‚ฌ์šฉํ•˜๋ฉด ๋Œ€๊ฐœ ORA-6110์—๋Ÿฌ๊ฐ€ ์—†์–ด์ง‘๋‹ˆ๋‹ค. 
2.์„œ๋ฒ„์ชฝ 
1)์„œ๋ฒ„์—์„œ ๋ฃจํ”„๋ฐฑ์„ ์ˆ˜ํ–‰ํ•  ์ˆ˜ ์žˆ์Šต๋‹ˆ๊นŒ? ๋‹ค์‹œ ๋งํ•ด์„œ PC ํด๋ผ์ด์–ธํŠธ์—์„œ ์ง€์ •ํ•œ ๊ฒƒ๊ณผ 
๊ฐ™์€ ์—ฐ๊ฒฐ ์ŠคํŠธ๋ง์„ ์‚ฌ์šฉํ•˜์—ฌ ์„œ๋ฒ„์˜ ํˆด์„ ์—ฐ๊ฒฐํ•  ์ˆ˜ ์žˆ์Šต๋‹ˆ๊นŒ? ์˜ˆ๋ฅผ ๋“ค์–ด ์„œ๋ฒ„์—์„œ 
SQLPLUS ๋˜๋Š” SQLDBA๋ฅผ ํ˜ธ์ถœํ•˜๊ณ  ์—๋Ÿฌ๊ฐ€ ์—†์–ด์ง‘๋‹ˆ๋‹ค. 
CONNECT USERNAME/PASSWORD@t:<servername><portnum>:<sid> 
๋ฃจํ”„๋ฐฑ์„ ์‹คํ–‰ํ•˜๋ฉด ์‹ค์ œ ๋ฌธ์ œ๋ฅผ ๋” ์ž˜ ๋ณด์—ฌ์ฃผ๋Š” ๋‹ค๋ฅธ ์—๋Ÿฌ๊ฐ€ ๋‚˜ํƒ€๋‚˜๋Š” ์ˆ˜๋„ ์žˆ์Šต๋‹ˆ๋‹ค. 
2)ORA-6110์€ Oracle์‹คํ–‰ ํŒŒ์ผ์— ์‚ฌ์šฉ ๊ถŒํ•œ์ด ์ •ํ™•ํ•˜๊ฒŒ ์„ค์ • ๋˜์–ด ์žˆ์ง€ ์•Š์œผ๋ฉด Unix ์„œ๋ฒ„์— 
์—ฐ๊ฒฐํ•  ๋•Œ๋„ ๋ฐœ์ƒํ•  ์ˆ˜ ์žˆ์Šต๋‹ˆ๋‹ค. Oracle๊ณผ orasrv์˜ ์‚ฌ์šฉ๊ถŒํ•œ์€ ๋‹ค์Œ๊ณผ ๊ฐ™์ด ์„ค์ •๋˜์–ด์•ผ 
ํ•ฉ๋‹ˆ๋‹ค. 
>chmod 6755 oracle 
>chmod 6755 orasrv 
์ด ๋•Œ, Permission๋Š” ๋‹ค์Œ๊ณผ ๊ฐ™์ด ์„ค์ •๋ฉ๋‹ˆ๋‹ค. 
-rwsr-xr-x 1 oracle dba ...size ...date oracle 
-rwsr-xr-x 1 root dba ...size ...date oracle 

3)ORA-6110๊ณผ ํ‹€๋ฆฐ ๋„คํŠธ์›Œํฌ ์ฃผ์†Œ 
TCP/IP ๋„คํŠธ์›Œํฌ์—์„œ ์ค‘๋ณต IP์ฃผ์†Œ๊ฐ€ ์‚ด์•„ ์žˆ์œผ๋ฉด ORA6110์ด ๋ฐœ์ƒํ•  ์ˆ˜ ์žˆ์Šต๋‹ˆ๋‹ค. ๋„คํŠธ 
์›Œํฌ์˜ ๋ชจ๋“  IP์ฃผ์†Œ๊ฐ€ ๊ณ ์œ ์˜ ๊ฒƒ์ธ์ง€ ํ™•์ธํ•˜์‹ญ์‹œ์š”. 
----- 
ํ˜„์ƒ : ORA-6122 "NETTCP: setup failure 
์›์ธ : SQL*NET ๊ตฌ์„ฑ์ด ์ ์ ˆํ•˜๊ฒŒ ์„ค์ •๋˜์ง€ ์•Š์€ ์ƒํƒœ์—์„œ WINDOWS์šฉ SQL*NET TCP/IP๋ฅผ ๊ฐ€์ง€๊ณ  ์—ฐ๊ฒฐ 
ํ•˜๋ ค ํ•  ๋•Œ ๋ฐœ์ƒ 
์กฐ์น˜ : 1.WINDOWS\WIN.INI๋ฅผ ์กฐ์‚ฌํ•ด ๋ณด์‹ญ์‹œ์š”. ORA_CONFIG ๋งค๊ฐœ ๋ณ€์ˆ˜๋ฅผ ์ •์˜ํ•˜๋Š” ORACLE ๋ถ€๋ถ„์ด 
์žˆ์–ด์•ผ ํ•ฉ๋‹ˆ๋‹ค 
[Oracle] 
ORA_CONFIG=C:\WINDOWS\ORACLE.INI 
2.ORACLE.INI(๋˜๋Š” ORA_CONFIG ๋งค๊ฐœ๋ณ€์ˆ˜๊ฐ€ ์ง€์‹œํ•˜๋Š” ํŒŒ์ผ)์„ ๋ณด์‹ญ์‹œ์š”. ORACLE_HOME์ด 
WINDOWS์šฉ SQL*NET TCP/IP์™€ ๋‹ค๋ฅธ Oracle Windows ์‘์šฉ ํ”„๋กœ๊ทธ๋žจ์ด ์„ค ๋œ ๋””๋ ‰ํ† ๋ฆฌ๋ฅผ 
์ง€์‹œํ•˜๋Š” ์ง€ ํ™•์ธํ•˜์‹ญ์‹œ์š”. ๋””ํดํŠธ๋Š” ๋‹ค์Œ๊ณผ ๊ฐ™์Šต๋‹ˆ๋‹ค. 
ORACLE_HOME=\ORAWIN 
3.๋˜ํ•œ ORACLE.INI์— TCP_VENDOR๋ฅผ ์ •ํ™•ํ•˜๊ฒŒ ์„ค์ •ํ–ˆ๋Š”์ง€๋„ ํ™•์ธํ•˜์‹ญ์‹œ์š”. 
4.๊ฒฝ๋กœ์— C:\ORAWIN\BIN(๋˜ํ•œ ORACLE_HOME์„ ์„ค์ •ํ•œ BIN ๋””๋ ‰ํ† ๋ฆฌ)์ด ์žˆ๋Š”์ง€ ํ™•์ธํ•˜์‹ญ์‹œ์š”. 
DOSํ”„๋กฌํ”„ํŠธ์—์„œ SET์„ ์ž…๋ ฅํ•˜๊ณ  <return>์„ ๋ˆ„๋ฅด๋ฉด ๋ฉ๋‹ˆ๋‹ค. ์ด๋ช…๋ น์€ ๊ฒฝ๋กœ๋ฅผ ๋ณด์—ฌ์ค๋‹ˆ๋‹ค. 
5.ORAWIN\BIN ๋””๋ ‰ํ† ๋ฆฌ์— SQLTCP.DLL๊ณผ SQLTCP1.DLL์ด ๋ชจ๋‘ ์žˆ๋Š”์ง€ ํ™•์ธํ•˜์‹ญ์‹œ์š”. 
6.๊ฒฝ๋กœ์˜ ๋‹ค๋ฅธ ์–ด๋–ค ๋””๋ ‰ํ† ๋ฆฌ์—๋„ SQLTCP.DLL์ด ์—†๋Š” ๊ฒƒ์„ ํ™•์ธํ•˜์‹ญ์‹œ์š”. 
7.ORAWIN\BIN ๋””๋ ‰ํ† ๋ฆฌ์™€ ๊ฒฝ๋กœ์˜ ๋‹ค๋ฅธ ๋””๋ ‰ํ† ๋ฆฌ์— MSOCKLIB.DLL์ด ์žˆ๋Š” ์ง€ ํ™•์ธํ•˜์‹ญ์‹œ์š”. 
๋˜ํ•œ ํŒŒ์ผ์˜ ๋‘ ๋ณต์‚ฌ๋ณธ์„ ๊ฐ€์ง€๊ณ  ์žˆ์ง€ ์•Š๋„๋ก ํ•˜์‹ญ์‹œ์š”. ๋ณต์‚ฌ๋ณธ์ด ๋‘˜์ผ ๊ฒฝ์šฐ, ์ด์ „ ๋ณต์‚ฌ๋ณธ 
์˜ ์ด๋ฆ„์„ ๋ฐ” ๋ฉด ๋ฌธ์ œ๊ฐ€ ์ค„์–ด๋“ค ์ˆ˜ ์žˆ์Šต๋‹ˆ๋‹ค. 
8.WINDOWS ๋””๋ ‰ํ† ๋ฆฌ์— VSL.INI ํŒŒ์ผ์ด ์žˆ๋Š”์ง€ ํ™•์ธํ•˜์‹ญ์‹œ์š”. ๋งŒ์•ฝ ์—†์œผ๋ฉด ORACLE INSTALLER 
๋ฅผ ํ†ตํ•ด SQL*NET๋ฅผ ๋‹ค์‹œ ์ž…๋ ฅํ•˜์‹ญ์‹œ์š”. 
----- 
ํ˜„์ƒ : ORA-6136, 00000, "NETTCP: error during connection handshake" 
์›์ธ : 1.Client and Server ํ™˜๊ฒฝ์—์„œ ๊ฐ„ํ˜น SQL*NET์œผ๋กœ Server์— ์ ‘์†ํ•˜๋ ค๊ณ  ํ•  ๊ฒฝ์šฐ 
2.Unix Server์—์„œ $tcpctl stop ์œผ๋กœ orasrv์˜ Process๋ฅผ ์ •์ง€์‹œํ‚ค๋ ค๊ณ  ํ•ด๋„ ์•„๋ฌด๋Ÿฐ ๋ฐ˜์‘ 
์—†์ด Holding๋˜๋Š” ๊ฒฝ์šฐ๊ฐ€ ๋ฐœ์ƒ 
์กฐ์น˜ : 1.TCPCTL Utility๋ฅผ ์ด์šฉํ•˜์—ฌ ๋‹ค์Œ์˜ Option์„ ๋ถ€์—ฌํ•˜์—ฌ Startํ•˜๋Š” ๋ฐฉ๋ฒ•. 
$tcpctl start listen=30 timeout=30 forkon listen=<queue size>์ด๋ฉฐ, ์ฒญ์ทจ์ž ์—ด์˜ 
ํฌ๊ธฐ๋ฅผ ์ง€์ •. 
timeout=<seconds>์ด๋ฉฐ, ์ง€์ •๋œ ์‹œ๊ฐ„์— orasrv์™€์˜ ์‘๋‹ต ํ™•์ธ ์‹œ๊ฐ„์„ ๋‚˜ํƒ€๋ƒ„. 
forkon SQL*net์ด orasrv process์— ์ ‘๊ทผํ•˜๋Š” ๋ฐฉ๋ฒ•์„ ๋‚˜ํƒ€๋ƒ„. 
System์— ๋”ฐ๋ผ์„œ forkon option์ด ์ ์šฉ ์•Š๋˜๋Š” ๊ฒฝ์šฐ๋„ ์žˆ์Œ. 
2.Client์—์„œ ์ ‘์†์„ ํ•˜์—ฌ ์‚ฌ์šฉ ๋‹ค๊ฐ€ ๋น„์ •์ƒ ์ข…๋ฃŒ(Session์ด ๋งบ์–ด์ง„ ์ƒํƒœ์—์„œ Client์˜ 
Power Off)๋ฅผ ํ•˜์—ฌ Server์— Processor๊ฐ€ ๋‚จ์•„ ์žˆ๊ณ , orasrv๋ฅผ ํ†ตํ•ด ์ ‘์†ํ•  ์ˆ˜ ์žˆ๋Š” 
Session์˜ ์ˆ˜๊ฐ€ ์ ์  ์ค„์–ด๋“ค ๊ฒฝ์šฐ๊ฐ€ ์žˆ๋Š” ๋ฐ ์ด๋Ÿฌํ•œ ๊ฒฝ์šฐ์—๋Š” orasrv๋ฅผ(tcpctl stop or 
UNIX kill command๋ฅผ ์ด์šฉ)๊ฐ•์ œ๋กœ ์ข…๋ฃŒ ์‹œ๊ณ  ๋‹ค์Œ๊ณผ ๊ฐ™์ด Start ์‹œ์ผœ ์ฃผ์‹ญ์‹œ์˜ค. 

#nohup tcpctl start ( Client์˜ ๋น„์ •์ƒ ์ข…๋ฃŒ๊ฐ€ Orasrv์—๋Š” ์˜ํ–ฅ์„ ๋ฏธ์น˜์ง€ ์•Š์Œ) 
๋˜๋Š” 
#orasrv (ORACLE_HOME\bin directory์—์„œ ์ง์ ‘ orasrv processor๋ฅผ ๋„์šด๋‹ค) 
----- 
ํ˜„์ƒ : ORA-06502 : PL/SQL : ๊ฐ’(์ˆ˜์น˜) ์˜ค๋ฅ˜์ž…๋‹ˆ๋‹ค. 
์›์ธ : DB Column๊ณผ Host variableใ…‡์˜ ๊ธธ์ด๊ฐ€ ๋งž์ง€ ์•Š์€ ๊ฒฝ์šฐ. 
์กฐ์น˜ : DB Column๊ณผ Host variableใ…‡์˜ ๊ธธ์ด๋ฅผ ํ™•์ธํ•˜๊ณ  ๊ธธ์ด๋ฅผ ๋™์ผํ•˜๊ฒŒ ํ•œ๋‹ค. 
----- 
ํ˜„์ƒ : ORA-06533: Subscript beyond count 
์›์ธ : VARRAY๋Š” default ๋กœ 3๊ฐœ์˜ element ์ด์ƒ์„ ๊ฐ€์ ธ ์˜ฌ์ˆ˜ ์—†๊ธฐ ๋•Œ๋ฌธ. 
์กฐ์น˜ : EXTEND method๋ฅผ ์ด์šฉํ•˜์—ฌ ํ•ด๊ฒฐํ•  ์ˆ˜ ์žˆ๋‹ค. 
----- 
ํ˜„์ƒ : ORA-06571 
์›์ธ : SQL๋ฌธ ์•ˆ์—์„œ Stored function์„ callํ•˜์—ฌ ์‚ฌ์šฉํ•˜๋Š” ๊ฒฝ์šฐ ๋ฐœ์ƒ. 
์กฐ์น˜ : ๊ธฐ๋ณธ์ ์œผ๋กœ stored function์ด๋‚˜ procedure, package์—์„œ์˜ 
DML ๋ฌธ์žฅ์˜ ์‚ฌ์šฉ์€ ๋ณด์žฅ์ด ๋˜๋Š” ๊ธฐ๋Šฅ์ด๋‚˜, sql list์—์„œ์˜ stored function์˜ 
์‚ฌ์šฉ์€ ๋ช‡ ๊ฐ€์ง€ ์ œ์•ฝ ์กฐ๊ฑด์„ ๊ฐ€์ง€๊ณ  ์ˆ˜ํ–‰์ด ๊ฐ€๋Šฅํ•ฉ๋‹ˆ๋‹ค. 
----- 
ํ˜„์ƒ : ORA-1119: error in creating database file 
ORA-7515: sfccf UIC GROUP <= MAXSYSGROUP - file operations not allowed 
์›์ธ : VMS์—์„œ๋งŒ ๋ฐœ์ƒํ•˜๋Š” ์—๋Ÿฌ๋กœ DATAFILE์„ ์ƒ์„ฑํ•˜๋ ค๋Š” Directory์˜ Owner๊ฐ€ DBA user๊ฐ€ ์•„๋‹๋•Œ ๋ฐœ์ƒ. 
์กฐ์น˜ : Datafile์„ ์ƒ์„ฑํ•˜๋ ค๋Š” Directory์˜ Owner๋ฅผ Oracle DBA user๋กœ ๋ณ€๊ฒฝ์‹œ์ผœ ์ฃผ์–ด์•ผ ํ•œ๋‹ค. 
----- 
ํ˜„์ƒ : ORA-9241, ORA-9301 
์›์ธ : ๊ฐœ๋ฐœํˆด์ด ํ•ด๋‹น ํˆด ๋˜๋Š” SQL*NET์— ํ•„์š”ํ•œ ๋ฉ”์„ธ์ง€ ํ™”์ผ์„ ์ฐพ์„ ์ˆ˜ ์—†์„ ๋•Œ ๋ฐœ์ƒ 
์กฐ์น˜ : ORACLE.INI ํŒŒ์ผ์— LOCAL = <V2 service name>์„ ์ถ”๊ฐ€ํ•œ๋‹ค. ๋งŒ์ผ ORACLE.INI ํŒŒ์ผ์— LOCAL 
ํŒŒ๋ผ๋ฏธํ„ฐ๋ฅผ ์ถ”๊ฐ€ํ•œ ํ›„์—๋„ ๊ณ„์† ora-9301 ์—๋Ÿฌ๊ฐ€ ๊ณ„์† ๋ฐœ์ƒํ•œ๋‹ค๋ฉด autoexec.bat ํŒŒ์ผ์— SET 
CONFIG = <PATH> \ORACLE.INI๋ฅผ ์ถ”๊ฐ€ํ•œ๋‹ค. 
[์ฃผ์˜ 1]CONFIG๊ฐ€ ORACLE.INI๋ฅผ ์ง€์‹œํ•˜๋„๋ก ์„ค์ •ํ•˜๋ฉด ๋‚˜์ค‘์— ๋‹ค์‹œ ์„ค์น˜ํ•  ๋ฌธ์ œ๊ฐ€ ๋ฐœ์ƒํ•  ์ˆ˜ 
์žˆ๋‹ค. ๊ทธ๋Ÿด ๋•Œ๋Š” AUTOEXEC.BAT ์—์„œ SET CONFIG ํ–‰์„ ์‚ญ์ œํ•˜๊ณ  ๋‹ค์‹œ Booting ํ•œํ›„ 
์„ค์น˜๋ฅผ ์‹œ์ž‘ํ•œ๋‹ค. 
[์ฃผ์˜ 2]MS ACCESS๋ฅผ ์ด์šฉํ•˜์—ฌ ORACLE์˜ ๋ฐ์ดํƒ€๋ฅผ ์งˆ์˜ํ•  ๊ฒฝ์šฐ๋Š” ํ™˜๊ฒฝ๋ณ€์ˆ˜๋ฅผ ๋‹ค์Œ๊ณผ ๊ฐ™์ด 
์„ค์ •ํ•œ๋‹ค. 
SET CONFIG_FILES = <path> \ORACLE.INI 
[์ฃผ์˜ 3]SET ๋‹ค์Œ์˜ CONFIG ๋‚˜ CONFIG_FILES ์€ ๋ฐ˜๋“œ์‹œ ๋Œ€๋ฌธ์ž ์ด์–ด์•ผ ํ•œ๋‹ค. 
----- 
ํ˜„์ƒ : ORA-9352 
์›์ธ : nt ์—์„œ service ์˜ problem ๋ฐœ์ƒ. 
์กฐ์น˜ : 1.background services and processes ๋ฅผ ๋„์šฐ๊ธฐ 
dos>oradim80 -startup -sid SID -starttype srvc,inst -usrpwd password -pfile filename 
2.์—ฌ๋Ÿฌ ๊ฐœ์˜ instance ๋ฅผ ๋„์šฐ๊ณ ์ž ํ•˜๋Š” ๊ฒฝ์šฐ 
- ORACLE_SID ๋ฅผ setting ํ•œ๋‹ค. 
c:\> set oracle_sid =sid 
- server manager ์‹คํ–‰ 
c:\>svrmgr30 
svrmgr>connect internal/passwd 
----- 
ํ˜„์ƒ : ORA-12004/ORA-12034 
์›์ธ : master table์˜ snapshot log๊ฐ€ ์žˆ๋Š” table์— ๋Œ€ํ•ด์„œ, snapshot์ด ์ถ”๊ฐ€๋กœ 
์ƒ์„ฑ๋˜๊ณ  ๋‚˜๋ฉด snapshot์„ ์ƒ์„ฑํ•˜๊ธฐ ์‹œ์ž‘ํ•œ ์‹œ๊ฐ„๊ณผ, ๊ธฐ์กด์˜ snapshot์ด log๋ฅผ 
refreshํ•ด๊ฐ„ ์‹œ๊ฐ„์„ ๋น„๊ตํ•˜์—ฌ ์ƒˆ๋กœ์šด snapshot ์ƒ์„ฑ์‹œ์ž‘ ์‹œ๊ฐ„์ด ๋” ๋น ๋ฅด๋ฉด 
ora-12004๊ฐ€ ๋ฐœ์ƒ 
์กฐ์น˜ : ์ƒ์„ฑํ•˜๊ณ ์ž ํ•˜๋Š” snapshot์— ๋Œ€ํ•œ master table์˜ ๋‹ค๋ฅธ snapshot๋“ค์„ refreshํ•˜์ง€ ๋ชปํ•˜๋„๋ก ํ•˜๊ฑฐ๋‚˜, refreshํ•˜์ง€ ์•Š๋Š” ์‹œ๊ฐ„์— ์ƒˆ๋กœ์šด snapshot์„ ์ƒ์„ฑํ•˜์—ฌ์•ผ ํ•œ๋‹ค. 
refresh ๋ชปํ•˜๋„๋ก ๋ง‰๋Š” ๋ฐฉ๋ฒ•์œผ๋กœ๋Š” ์ผ์‹œ์ ์œผ๋กœ snapshot job์„ broken์‹œํ‚จ ํ›„ snapshot์ด ์ƒ์„ฑ๋œ ํ›„ ๋‹ค์‹œ broken์„ false๋กœ ํ•˜๋ฉด ๋œ๋‹ค. 
----- 
ํ˜„์ƒ : ORA-12154 
์›์ธ : tnsnames.ora ํŒŒ์ผ์˜ Alias์ฒ˜๋Ÿผ ์ •์˜๋œ Connect String์œผ๋กœ ์‚ฌ์šฉํ•˜๋Š” db_alias๋ฅผ ์ฐพ์ง€ ๋ชปํ•  ๊ฒฝ์šฐ ๋ฐœ์ƒ 
----- 
ํ˜„์ƒ : TNS-12203 "TNS:unable to connect to destination" 
์›์ธ : 1.WINDOWS์šฉ TCP/IP ์–ด๋Œ‘ํ„ฐ๋ฅผ ์„ค์น˜ํ•˜์ง€ ์•Š์€ ์ƒํƒœ์—์„œ ์—ฐ๊ฒฐํ•˜๋ ค ํ•  
2.TNS-12203 ์—๋Ÿฌ๋Š” WINDOWS์šฉ ORACLE SQL*NET์†Œํ”„ํŠธ์›จ์–ด๊ฐ€ ORACLE ํ™ˆ ๋”” ๋ ‰ํ† ๋ฆฌ๋ฅผ ์ฐพ์„ ์ˆ˜ 
์—†๋‹ค๋Š” ์˜๋ฏธ์ผ ์ˆ˜ ์žˆ์Šต๋‹ˆ๋‹ค. 
3.TNSNAMES.ORA๊ฐ€ ORACLE ํ™ˆ ๋””๋ ‰ํ† ๋ฆฌ ์•„๋ž˜์˜ NETWORK\ADMIN์— ์žˆ๋Š”์ง€ ํ™•์ธํ•˜์‹ญ์‹œ์š”. 
4.์„œ๋ฒ„์ชฝ์—์„œ ์‹คํ–‰์ค‘์ธ SQL*NET V2 TCP/IP Listener๊ฐ€ ์—†์–ด๋„ TNS-12203์ด ๋ฐœ์ƒ 
5.์—ฐ๊ฒฐํ•  SERVICES ์ด๋ฆ„์— ๋Œ€ํ•ด CONNECT DESCRIPTOR์— ์ •ํ™•ํ•œ ADDRESS ๋งค๊ฐœ๋ณ€์ˆ˜๋ฅผ ์ง€์ •ํ–ˆ๋Š”์ง€ 
ํ™•์ธํ•˜์‹ญ์‹œ์š”. 
6.JSB VSL ์†Œ์ผ“์ด ์ดˆ๊ธฐํ™”๋˜์ง€ ์•Š์œผ๋ฉด TNS-12203 ์ด ๋ฐœ์ƒํ•  ์ˆ˜ ์žˆ์Šต๋‹ˆ๋‹ค. 
7.TNS-12203์— ์ด์–ด ์‹ค์ œ ๋ฌธ์ œ๊ฐ€ ๋ฌด์—‡์ธ์ง€ ๋” ์ž์„ธํ•˜๊ฒŒ ๋‚˜ํƒ€๋‚ด ์ฃผ๋Š” ๋˜ ๋‹ค๋ฅธ ์—๋Ÿฌ๊ฐ€ ๋ฐœ์ƒํ•  ์ˆ˜ 
์žˆ์Šต๋‹ˆ๋‹ค. 
์กฐ์น˜ : 1.SQL*NET TCP/IP V2๋Š” SQL*NET V2์™€ V2 TCP/IP ์–ด๋Œ‘ํ„ฐ ๋“ฑ ๋‘๊ฐ€์ง€ ์ œํ’ˆ์œผ๋กœ ๊ตฌ์„ฑ๋ฉ๋‹ˆ๋‹ค. 
์ด๋“ค์€ ๋ณ„๋„์˜ ๋‘ ํ‚คํŠธ๋กœ ๋˜์–ด ์žˆ๋Š”๋ฐ, ๋ฐ˜๋“œ์‹œ ๋‘ ํ‚คํŠธ๋ฅผ ๋ชจ๋‘ ์„ค์น˜ํ•ด์•ผ ํ•ฉ๋‹ˆ๋‹ค. 
2.WIN.INIํŒŒ์ผ์˜ ORACLE ๋ถ€๋ถ„์— ๋‹ค์Œ ํ•ญ๋ชฉ์ด ์žˆ๋Š”์ง€ ํ™•์ธํ•˜์‹ญ์‹œ์š”. 
[ORACLE] 
ORA_CONFIG=C:\WINDOWS\ORACLE.INI 
WINDOWS๋””๋ ‰ํ† ๋ฆฌ๊ฐ€ C:\WINDOWS๊ฐ€ ์•„๋‹ˆ๋ฉด, ์œ„ ํ–‰์˜ C:\WINDOWS ๋ถ€๋ถ„์„ ๊ทธ ์ด๋ฆ„์œผ๋กœ ๋ฐ”๊พธ์‹ญ์‹œ์š” 
๊ทธ๋Ÿฐ ๋‹ค์Œ, ORACLE ์†Œํ”„ํŠธ์›จ์–ด๋ฅผ ๋‹ค์‹œ ์„ค์น˜ํ•˜์‹ญ์‹œ์š”. ORACLE.INI ํŒŒ์ผ์ด ์žˆ์œผ๋ฉด ORACLE.INI 
ํŒŒ์ผ์— ๋‹ค์Œ ํ–‰์ด ์žˆ๋Š”์ง€ ํ™•์ธํ•˜์‹ญ์‹œ์š”. 
ORACLE_HOME=C:\ORAWIN 
ORACLE ํ™ˆ ๋””๋ ‰ํ† ๋ฆฌ๊ฐ€ C:\ORAWIN์ด ์•„๋‹ˆ๋ฉด ์œ„ ํ–‰์˜ C:\ORAWIN ๋ถ€๋ถ„์„ ์ด๋ฆ„์œผ๋กœ ๋ฐ”๊พธ์‹ญ์‹œ์š”. 
3.ORACLE ํ™ˆ ๋””๋ ‰ํ† ๋ฆฌ๋Š” ORACLE.INI(๋˜๋Š” WIN.INI์˜ ORA_CONFIG๋งค๊ฐœ๋ณ€์ˆ˜๊ฐ€ ์ง€์‹œํ•˜๋Š” ํŒŒ์ผ)์˜ 
ORACLE_HOME ์— ์˜ํ•ด ์ •์˜๋ฉ๋‹ˆ๋‹ค. 
4.์„œ๋ฒ„์ชฝ์—์„œ ์‹คํ–‰์ค‘์ธ SQL*NET V2๊ฐ€ ์žˆ๋Š”์ง€ ํ™•์ธํ•˜์‹ญ์‹œ์š”. ์„œ๋ฒ„์ชฝ์—์„œ Listener Control ์œ ํ‹ธ 
๋ฆฌํ‹ฐ(LSNRCTL)๋ฅผ ์‚ฌ์šฉํ•˜๋ฉด ์„œ๋ฒ„์˜ V2 Listener๊ฐ€ ์‹คํ–‰์ค‘์ธ์ง€ ํ™•์ธํ•  ์ˆ˜ ์žˆ์Šต๋‹ˆ๋‹ค. ์„œ๋ฒ„์—์„œ 
"LSNRCTL STATUS"๋ช…๋ น์„ ์‹คํ–‰ํ•˜์‹ญ์‹œ์š”. Listener Control์ด ์œ ํ‹ธ๋ฆฌํ‹ฐ ๋Œ€ํ•ด์„œ๋Š” SQL*NET 
Administrator's Guide๋ฅผ ์ฐธ์กฐํ•˜์‹ญ์‹œ์š”. 
5.์ •ํ™•ํ•œ ADDRESS ๋งค๊ฐœ๋ณ€์ˆ˜๋ฅผ ์‚ฌ์šฉ์ค‘์ธ์ง€ ํ™•์ธํ•˜๋Š” ๋ฐฉ๋ฒ•์€, WINDOWS ํด๋ผ์ด์–ธํŠธ์—์„œ ์‚ฌ์šฉ ํ•  ๊ฒƒ 
๊ณผ ๊ฐ™์€ ADDRESS ๋งค๊ฐœ ๋ณ€์ˆ˜๋ฅผ ๊ฐ€์ง„ TNSNAMES.ORA๋ฅผ ์‚ฌ์šฉํ•˜์—ฌ ์„œ๋ฒ„์—์„œ ๋ฃจํ”„๋ฐฑ์„ ํ•ด ๋ณด๋Š” ๊ฒƒ 
์ž…๋‹ˆ๋‹ค. ๋ฃจํ”„๋ฐฑ์„ ์ˆ˜ํ–‰ํ•œ๋‹ค๋Š” ๊ฒƒ์€ ๋ฐ์ดํƒ€๋ฒ ์ด์Šค์™€ ๊ฐ™์€ ๊ธฐ๊ณ„์—์„œ SQL*DBA ๋“ฑ์„ ํ˜ธ์ถœํ•˜๊ณ  
์—ฐ๊ฒฐ ์ŠคํŠธ๋ง์„ ์ง€์ •ํ•จ์œผ๋กœ์จ SQL*NET V2๋ฅผ ํ†ตํ•ด ์—ฐ๊ฒฐํ•œ๋‹ค๋Š” ๋œป์ž…๋‹ˆ๋‹ค. 
6.๋ฌธ์ œ๋ฅผ ํ•ด๊ฒฐํ•˜๋ ค๋ฉด ๋‹ค์Œ ์‚ฌํ•ญ์„ ์ ๊ฒ€ํ•˜์—ฌ JSB VSL ๋ ˆ์ด์–ด๊ฐ€ ์ •ํ™•ํ•˜๊ฒŒ ์ดˆ๊ธฐํ™”๋˜์—ˆ๋Š”์ง€ ํ™•์ธ 
ํ•˜์‹ญ์‹œ์š”. 
1)ORACLE.INI ํŒŒ์ผ(๋˜๋Š” WIN.INI์˜ ORA_CONFIG ๋งค๊ฐœ๋ณ€์ˆ˜๊ฐ€ ์ง€์‹œํ•˜๋Š” ํŒŒ์ผ)์˜ ์—…์ฒดํ‚ค ๋งค๊ฐœ 
๋ณ€์ˆ˜ TCP_VENDOR๊ฐ€ ์ •ํ™•ํ•˜๊ฒŒ ์„ค์ •๋˜์—ˆ๋Š” ์ง€ ํ™•์ธํ•˜์‹ญ์‹œ์š” 
2)ORACLE_HOME\BIN ๋””๋ ‰ํ† ๋ฆฌ์— MSOCKLIB.DLL์ด ์žˆ๋Š”์ง€ ํ™•์ธํ•˜์‹ญ์‹œ์š”. 
3)ORACLE_HOME\BIN ๋””๋ ‰ํ† ๋ฆฌ์— ์„ ํƒ๋œ JSB ์—…์ฒด ํŠน์œ ์˜ DLL์ด ์žˆ๋Š”์ง€, ๋˜๋Š”๊ทธ JSB ์—…์ฒด ํŠน์œ  
์˜ TSR ํŒŒ์ผ์ด ์‹คํ–‰๋˜๋Š” ์ง€ ํ™•์ธํ•˜์‹ญ์‹œ์š”. 
4)WINDOWS ํ™ˆ ๋””๋ ‰ํ† ๋ฆฌ์— VSL.INI ํŒŒ์ผ์ด ์žˆ๋Š” ์ง€ ํ™•์ธํ•˜์‹ญ์‹œ์š”. 
7.ํ™”๋ฉด์—์„œ ๋‹ค๋ฅธ ์—๋Ÿฌ๊ฐ€ ๋ณด์ด์ง€ ์•Š์œผ๋ฉด ORACLE_HOME\NETWORK\LOG ๋””๋ ‰ํ† ๋ฆฌ์˜ SQLNET.LOG ํŒŒ์ผ์„ 
์ ๊ฒ€ํ•˜์‹ญ์‹œ์š”. 
----- 
ํ˜„์ƒ : TNS-12533 
์›์ธ : TNSNAMES.ORA์—์„œ ๊ธฐ์ˆ ์ž์˜ ADDRESS ๋ถ€๋ถ„์— ํ”„๋กœํ† ์ฝœ CONNECT DESCRIPTOR์˜ ๋งค๊ฐœ ๋ณ€์ˆ˜๊ฐ€ ํ‹€๋ฆด 
๋•Œ ๋ฐœ์ƒ 
์กฐ์น˜ : 
----- 
ํ˜„์ƒ : ORA-12541: TNS:no listener 
์›์ธ : listener๊ฐ€ ๋–  ์žˆ์ง€ ์•Š์€ ๊ฒฝ์šฐ์— ๋ฐœ์ƒ. 
์กฐ์น˜ : 
----- 
ํ˜„์ƒ : TNS-12545 "TNS:name lookup failure 
์›์ธ : TNSNAMES.ORA์—์„œ ๊ธฐ์ˆ ์ž์˜ ADDRESS ๋ถ€๋ถ„์— ํ”„๋กœํ† ์ฝœ CONNECT DESCRIPTOR์˜ ๋งค๊ฐœ ๋ณ€์ˆ˜๊ฐ€ ํ‹€๋ฆด 
๋•Œ ๋ฐœ์ƒTCP/IP ํ”„๋กœํ† ์ฝœ ์–ด๋Œ‘ํ„ฐ๋ฅผ ๊ฐ€์ง„ SQL*NET V2๋ฅผ ํ†ตํ•ด ํˆด์—์„œ ์—ฐ๊ฒฐํ•˜๋ ค๋Š” ๋ฐ TCP/IP 
ํ”„๋กœํ† ์ฝœ ์–ด๋Œ‘ํ„ฐ๊ฐ€ TNSNAMES.ORA ํŒŒ์ผ์˜ ADDRESS ๋ถ€๋ถ„์— ์ œ๊ณต๋œ ํ˜ธ์ŠคํŠธ ์ด๋ฆ„์„ ๋ถ„์„ํ•  ์ˆ˜ ์—†์„ 
๋•Œ ๋ฐœ์ƒ 
----- 
ํ˜„์ƒ : ORA-01034: ORACLE not available 
ORA-27101: shared memory realm does not exist 
์›์ธ : OPENINFO์˜ DB์— ์ ‘์†ํ•˜๋Š” ๊ณ„์ •์ด ์กด์žฌํ•˜์ง€ ์•Š์€ ๊ฒฝ์šฐ. 
์กฐ์น˜ : DB์— ์ ‘์†ํ•˜๋Š” ๊ณ„์ •์„ ํ™•์ธํ•˜์—ฌ OPENINFO์˜ DB ์ ‘์†๊ณ„์ •์„ ์žฌ์„ค์ • ํ•ด์•ผ๋จ. 
1.$ORACLE_HOME/bin directory์˜ "oracle"๊ณผ "orasrv" (orasrv๊ฐ€ ์—†๋Š” 
๊ฒฝ์šฐ์—๋Š” "tnslsnr"์„ ํ™•์ธํ•ด ๋ณด์•„์•ผ ํ•œ๋‹ค.)์˜ permission๊ณผ ownership 
์„ check. 
2.file system์ด no set uid๋กœ mount๋˜์–ด ์žˆ๋Š”์ง€ ํ™•์ธ. 
3.oracle user์˜ "umask"๋ฅผ ํ™•์ธ. 
4.$ORACLE_HOME/bin ์— ์กด์žฌํ•˜๋Š” ์‹คํ–‰๋ชจ๋“ˆ์˜ ownership ์„ ํ™•์ธ. 
5.๋ชจ๋“  oracle file์ด dba group์œผ๋กœ ๋˜์–ด ์žˆ๋Š”์ง€ ํ™•์ธ. 
6.ORACLE_HOME์˜ path์— ์กด์žฌํ•˜๋Š” ๋ชจ๋“  directory๊ฐ€ 755 mask๋กœ setting 
๋˜์–ด ์žˆ๋Š”์ง€ ํ™•์ธ. 
----- 
ํ˜„์ƒ : 0509-036,0509-022,0509-026,ORA-12547 
์›์ธ : 1.Oracle ๊ณ„์ •์ด ์•„๋‹Œ ์ผ๋ฐ˜ ๊ณ„์ •์œผ๋กœ unix์— ์ ‘์†ํ•˜์—ฌ svrmgrl์„ ์ˆ˜ํ–‰ ์‹œ ๋ฐœ์ƒ. 
2.$ORACLE_HOME/bin/oracle ์‹คํ–‰ ํ™”์ผ์— ๋Œ€ํ•œ permission์ด ์ ๋‹นํ•˜์ง€ ์•Š์„ ์ˆ˜ ์žˆ๊ณ , 
unix ๊ณ„์ •์˜ .profile ๋˜๋Š” .login ํ™”์ผ์— ORA_NLS33 ํŒŒ๋ผ๋ฏธํ„ฐ๋ฅผ ์…‹ํŒ…ํ•˜์ง€ 
์•Š์•˜๊ธฐ ๋•Œ๋ฌธ์— ๋ฐœ์ƒ 
์กฐ์น˜ : 1.$ORACLE_HOME/bin/oracle ํ™”์ผ์˜ sticky bit๊ฐ€ ์ œ๋Œ€๋กœ ์…‹ํŒ…๋˜์—ˆ๋Š”์ง€ ํ™•์ธ. 
2.ORA_NLS33 ํŒŒ๋ผ๋ฏธํ„ฐ๊ฐ€ ์ œ๋Œ€๋กœ ์…‹ํŒ…๋˜์–ด ์žˆ๋Š”์ง€ ํ™•์ธ. 
user๊ฐ€ ์˜ค๋ผํด database์— loginํ•  ๋•Œ, oracle ์‹คํ–‰ ํ”„๋กœ๊ทธ๋žจ์„ ์‚ฌ์šฉํ•˜์—ฌ 
์˜ค๋ผํด ๊ณ„์ •์œผ๋กœ shadow process๋ฅผ ์ƒ์„ฑํ•œ๋‹ค. 
----- 
ํ˜„์ƒ : ORA-24777: use of non-migratable database link not allowed. 
์›์ธ : Remote database๋ฅผ ์‚ฌ์šฉํ•˜๋Š”๋ฐ Oracle์ด dedicator server๋กœ ์„ค์น˜๋œ ๊ฒฝ์šฐ ๋ฐœ์ƒ(DB-Link์‚ฌ์šฉํ•  ๊ฒฝ์šฐ) 
์กฐ์น˜ : Remote database๋ฅผ ์‚ฌ์šฉํ•˜์—ฌ transaction๋ฅผ ๋ณด์žฅ ๋ฐ›์„๋ ค๋ฉด Oracle์„ MTS mode๋กœ ์„ค์น˜๋˜์–ด์•ผ ํ•œ๋‹ค. 
----- 
ํ˜„์ƒ : ORA-29701(OGMS๊ด€๋ จ ORACLE ERROR) 
์›์ธ : 1.์˜ค๋ผํด์—์„œ GMS์— ์ ‘์†ํ•  ์ˆ˜ ์—†์„ ๊ฒฝ์šฐ ๋ฐœ์ƒํ•œ๋‹ค. 
2.lmon( GMS client )์ด communication file์˜ ์œ„์น˜๋ฅผ ์ฐพ์ง€ ๋ชปํ•  ๊ฒฝ์šฐ ๋ฐœ์ƒํ•œ๋‹ค. 
3.๊ธฐํƒ€ ๋ฐœ์ƒ ์›์ธ์€ GMS์— ํ‹€๋ฆฐ internal function(skgxn)์ด ์‚ฌ์šฉ๋˜๊ฑฐ๋‚˜ 
GMS๊ฐ€ local request์— ๋Œ€ํ•œ ์„œ๋น„์Šค๋ฅผ ํ•  ์ˆ˜ ์—†๊ฑฐ๋‚˜ CM subsystem์— ๋ฌธ์ œ๊ฐ€ ์žˆ์„ 
๊ฒฝ์šฐ ๋“ฑ 
์กฐ์น˜ : 1.Oracle์ด startup ๋  ๋•Œ, GMS๊ฐ€ ์‹คํ–‰๋˜์ง€ ์•Š๊ณ  ์žˆ์„ ๋•Œ ๋ฐœ์ƒํ•œ๋‹ค. ์ด์™€ 
๊ฐ™์€ ๊ฒฝ์šฐ์—๋Š” 'ogmsctl status' ๋ช…๋ น์„ ์ƒ์šฉํ•˜์—ฌ GMS๊ฐ€ startup๋˜์—ˆ๋Š”์ง€ ํ™•์ธ 
ํ•˜์—ฌ์•ผ ํ•œ๋‹ค. 
2.๊ธฐ๋ณธ์ ์œผ๋กœ ์‚ฌ์šฉํ•˜๋Š” ๋””๋ ‰ํ† ๋ฆฌ์ธ /tmp/.ogms๋ฅผ ์‚ฌ์šฉํ•˜์ง€ ์•Š์„ ๊ฒฝ์šฐ GMS home์ด 
์ง€์ •๋˜์–ด์•ผ ํ•œ๋‹ค. OGMS home directory๋ฅผ ๋ณ„๋„๋กœ ์ง€์ •ํ•˜์—ฌ ์‚ฌ์šฉํ•  ๊ฒฝ์šฐ์—๋Š” 
init.ora ํŒŒ๋ผ๋ฏธํ„ฐ ํŒŒ์ผ์—์„œ ogms_home ํŒŒ๋ผ๋ฏธํ„ฐ ๊ฐ’์„ ์ง€์ •ํ•ด ์ฃผ์–ด์•ผ ํ•œ๋‹ค. 
----- 
ํ˜„์ƒ : ORA-29702 ERROR(OGMS๊ด€๋ จ ORACLE ERROR) 
์›์ธ : 1.์˜ค๋ผํด์—์„œ GMS์— ์ ‘์†ํ•  ์ˆ˜ ์—†์„ ๊ฒฝ์šฐ ๋ฐœ์ƒํ•œ๋‹ค. 
2.lmon( GMS client )์ด communication file์˜ ์œ„์น˜๋ฅผ ์ฐพ์ง€ ๋ชปํ•  ๊ฒฝ์šฐ ๋ฐœ์ƒํ•œ๋‹ค. 
3.๊ธฐํƒ€ ๋ฐœ์ƒ ์›์ธ์€ GMS์— ํ‹€๋ฆฐ internal function(skgxn)์ด ์‚ฌ์šฉ๋˜๊ฑฐ๋‚˜ 
GMS๊ฐ€ local request์— ๋Œ€ํ•œ ์„œ๋น„์Šค๋ฅผ ํ•  ์ˆ˜ ์—†๊ฑฐ๋‚˜ CM subsystem์— ๋ฌธ์ œ๊ฐ€ ์žˆ์„ 
๊ฒฝ์šฐ ๋“ฑ 
์กฐ์น˜ : GMS ์„œ๋น„์Šค์— ์˜ˆ์ƒ์น˜ ๋ชปํ•œ ์—๋Ÿฌ๊ฐ€ ๋ฐœ์ƒํ–ˆ์„ ๊ฒฝ์šฐ ๋กœ๊ทธ์— ๋‚จ๊ฒŒ ๋œ๋‹ค. GMS๊ฐ€ ์‹คํ–‰ 
์ค‘์ธ์ง€๋ฅผ ํ™•์ธํ•ด ๋ณด๊ณ , ๋‚ด๋ถ€ ์—๋Ÿฌ๋กœ ์ธํ•ด GMS๊ฐ€ ์Šค์Šค๋กœ shutdown ๋˜์—ˆ๋‹ค๋ฉด 
daemon file์— ๊ธฐ๋ก๋œ ํŠธ๋ ˆ์ด์Šค ์ •๋ณด๋ฅผ ์‚ดํŽด๋ณด์•„์•ผ ํ•œ๋‹ค. 
----- 
๏ปฟ
๋Œ“๊ธ€ ๋‚จ๊ธฐ๊ธฐ..
์ด๋ฆ„: : ์˜ค๋ฅธ์ชฝ์˜ ์ƒˆ๋กœ๊ณ ์นจ์„ ํด๋ฆญํ•ด ์ฃผ์„ธ์š”. ์ƒˆ๋กœ๊ณ ์นจ
EditText : Print : Mobile : FindPage : DeletePage : LikePages : Powered by MoniWiki : Last modified 2018-04-13 23:12:53

์‚ด์•„ ์žˆ๋Š” ๋™์•ˆ ๋” ๋งŽ์ด ๊ฐํƒ„ํ•˜์„ธ์š”. ๊ฐ€์Šด์„ ์—ด๊ณ  ๋ณด๋ฉด ์–ด๋”” ๊ฐํƒ„ํ•  ๊ฑฐ๋ฆฌ๊ฐ€ ํ•œ๋‘ ๊ฐ€์ง€์ž…๋‹ˆ๊นŒ. ๊ฐํƒ„ํ•  ๊ฑฐ๋ฆฌ๊ฐ€ ์žˆ์„๋•Œ๊ฐ€ ์ฐธ์„ ๊ฒƒ์ด ์•„๋‹ˆ๋ผ ์ฆ‰๊ฐ ๊ฐํƒ„ํ•ด์•ผ ํ•ฉ๋‹ˆ๋‹ค. ๊ฐ€์Šด ๋‘๊ทผ๊ฑฐ๋ฆฌ๊ณ  ๋†€๋ผ๊ณ  ํ™˜ํ˜ธํ• ๋•Œ ์šฐ๋ฆฌ์˜ ํ–‰๋ณต์€ ๊ณฑ์œผ๋กœ ๋Š๊ปด์ง‘๋‹ˆ๋‹ค. (์ •์ฑ„๋ด‰)