startup 시 에러 0 0 3,503

by 박상현 [2010.11.24 16:45:10]


sbdc_ora_3976_i62582.trc (1,928,499Bytes)
sbdc_ora_3976.trc (2,570Bytes)

안녕하세요

오라클 (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)

댓글등록
SQL문을 포맷에 맞게(깔끔하게) 등록하려면 code() 버튼을 클릭하여 작성 하시면 됩니다.
로그인 사용자만 댓글을 작성 할 수 있습니다. 로그인, 회원가입