alert로그에 다음과 같은 error를 남기며 db가 갑자기 down되었습니다. 두개의 trc 파일을 남겼길래 확인해 보니 무슨 내용인지 모르겠네요. 분석 좀 부탁 드립니다. =========================================================== Wed Feb 26 14:45:38 2003 Current log# 1 seq# 5059 mem# 0: /Users/ora733/app/oracle/oradata/KFDA/redoKFDA01.log Wed Feb 26 14:45:39 2003 ARC0: Completed archiving log# 3 seq# 5058 Wed Feb 26 14:56:29 2003 Thread 1 advanced to log sequence 5060 Current log# 2 seq# 5060 mem# 0: /Users/ora733/app/oracle/oradata/KFDA/redoKFDA02.log Wed Feb 26 14:56:29 2003 ARC0: Beginning to archive log# 1 seq# 5059 ARC0: Completed archiving log# 1 seq# 5059 Wed Feb 26 15:06:23 2003 PMON failed to acquire latch, see PMON dump Wed Feb 26 15:10:10 2003 Errors in file /Data2/Backup/oracle/bdump/pmon_999.trc: ORA-00601: cleanup lock conflict ORA-00601: cleanup lock conflict PMON: terminating instance due to error 601 Wed Feb 26 15:10:10 2003 Errors in file /Data2/Backup/oracle/bdump/dbw0_1001.trc: ORA-00601: cleanup lock conflict ORA-00601: cleanup lock conflict Instance terminated by PMON, pid = 999 Wed Feb 26 15:19:57 2003 Starting ORACLE instance (normal) LICENSE_MAX_SESSION = 0 LICENSE_SESSIONS_WARNING = 0 LICENSE_MAX_USERS = 0 Starting up ORACLE RDBMS Version: 8.1.7.2.0. =========================================================== dbw0_1001.trc의 내용 ------------------- Dump file /Data2/Backup/oracle/bdump/dbw0_1001.trc Oracle8i Enterprise Edition Release 8.1.7.2.0 - Production With the Partitioning option JServer Release 8.1.7.2.0 - Production ORACLE_HOME = /Users/ora733/app/oracle/product/817 System name: IRIX64 Node name: ha1 Release: 6.5 Version: 01101245 Machine: IP27 Instance name: KFDA Redo thread mounted by this instance: 1 Oracle process number: 3 Unix process pid: 1001, image: oracle@ha1 (DBW0) *** 2003-02-26 15:10:10.487 *** SESSION ID:(2.1) 2003-02-26 15:10:10.484 ORA-00601: cleanup lock conflict ORA-00601: cleanup lock conflict ========================================================== pmon_999.trc의 내용 -------------------- Dump file /Data2/Backup/oracle/bdump/pmon_999.trc Oracle8i Enterprise Edition Release 8.1.7.2.0 - Production With the Partitioning option JServer Release 8.1.7.2.0 - Production ORACLE_HOME = /Users/ora733/app/oracle/product/817 System name: IRIX64 Node name: ha1 Release: 6.5 Version: 01101245 Machine: IP27 Instance name: KFDA Redo thread mounted by this instance: 0 Oracle process number: 2 Unix process pid: 999, image: oracle@ha1 (PMON) *** SESSION ID:(1.1) 2003-02-08 12:21:09.016 Load Indicator not supported by OS ! *** 2003-02-26 15:06:23.681 PMON unable to acquire latch 7c00166e8 shared pool possible holder pid = 34 ospid=2040052 *** 2003-02-26 15:06:23.707 *** 2003-02-26 15:10:10.278 ORA-00601: cleanup lock conflict ORA-00601: cleanup lock conflict ========================================================= 이상입니다.