안녕하세요
오라클 (Oracle Database 11g Enterprise Edition Release 11.2.0.1.0)
os windows 2003 서버를 사용하고 있습니다.
startup시 Mount 후 ORA-00600 에러가 발생하고 있습니다.
alert log 내용은 아래 기재해 드리겠습니다.
trc 파일은 첨부파일에 붙여 드리겠습니다.
많은 고수님들 확인좀 해주시고 답변 부탁드리겠습니다.
수고하세요.
Completed: ALTER DATABASE MOUNT
Wed Nov 24 15:59:50 2010
ALTER DATABASE OPEN
Beginning crash recovery of 1 threads
parallel recovery started with 3 processes
Started redo scan
Completed redo scan
read 25 KB redo, 7 data blocks need recovery
Errors in file d:\app\administrator\diag\rdbms\sbdc\sbdc\trace\sbdc_ora_3976.trc (incident=62582):
ORA-00600: 내부 오류 코드, 인수: [kcratr_nab_less_than_odr], [1], [180], [53], [65], [], [], [], [], [], [], []
Incident details in: d:\app\administrator\diag\rdbms\sbdc\sbdc\incident\incdir_62582\sbdc_ora_3976_i62582.trc
Wed Nov 24 15:59:53 2010
Trace dumping is performing id=[cdmp_20101124155953]
Aborting crash recovery due to error 600
Errors in file d:\app\administrator\diag\rdbms\sbdc\sbdc\trace\sbdc_ora_3976.trc:
ORA-00600: 내부 오류 코드, 인수: [kcratr_nab_less_than_odr], [1], [180], [53], [65], [], [], [], [], [], [], []
Errors in file d:\app\administrator\diag\rdbms\sbdc\sbdc\trace\sbdc_ora_3976.trc:
ORA-00600: 내부 오류 코드, 인수: [kcratr_nab_less_than_odr], [1], [180], [53], [65], [], [], [], [], [], [], []
ORA-600 signalled during: ALTER DATABASE OPEN...
Wed Nov 24 16:00:43 2010
Sweep [inc][62582]: completed
Sweep [inc2][62582]: completed
Wed Nov 24 16:14:43 2010
db_recovery_file_dest_size of 3852 MB is 0.00% used. This is a
user-specified limit on the amount of space that will be used by this
database for recovery-related files, and does not reflect the amount of
space available in the underlying filesystem or ASM diskgroup.
Wed Nov 24 16:32:40 2010
***********************************************************************
Fatal NI connect error 12170.
VERSION INFORMATION:
TNS for 32-bit Windows: Version 11.2.0.1.0 - Production
Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 11.2.0.1.0 - Production
Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 11.2.0.1.0 - Production
Time: 24-11월-2010 16:32:40
Tracing not turned on.
Tns error struct:
ns main err code: 12535
TNS-12535: TNS:작동이 중단중입니다
ns secondary err code: 12606
nt main err code: 0
nt secondary err code: 0
nt OS err code: 0
Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.38)(PORT=4567))
WARNING: inbound connection timed out (ORA-3136)