ORA-00600, ORA-07445 를 만드는 방법

OS환경 : Oracle Linux6.8(64bit)

DB 환경 : Oracle Database 10.2.0.4, 11.2.0.4

에러 : ORA-00600, ORA-07445 를 만드는 방법

에러 발생 방법 : 

10gR2

ORA-00600: internal error code, arguments: [16703], [1403], [20], [], [], [], [], []

1. delete sys.tab$;

commit;

2. shutdown abort

3. startup

4. alert log 확인 -> ORA-00600 발생 확인

Tue Apr 10 13:57:03 KST 2018

Errors in file /oracle/app/oracle/admin/orcl/udump/orcl_ora_31327.trc:

ORA-00704: bootstrap process failure

ORA-00704: bootstrap process failure

ORA-00600: internal error code, arguments: [16703], [1403], [20], [], [], [], [], []

10gR2

ORA-00600: internal error code, arguments: [16513], [1403], [20], [], [], [], [], []

1. delete sys.obj$;

commit;

2. shutdown abort

3. startup

4. alert log 확인 -> ORA-00600 발생 확인

Tue Apr 10 16:09:19 KST 2018

Errors in file /oracle/app/oracle/admin/orcl/udump/orcl_ora_31850.trc:

ORA-00704: bootstrap process failure

ORA-00704: bootstrap process failure

ORA-00600: internal error code, arguments: [16513], [1403], [20], [], [], [], [], []

10gR2

ORA-00600: internal error code, arguments: [kokasgi1], [], [], [], [], [], [], []

1. delete sys.user$;

commit;

2. shutdown abort

3. startup

4. alert log 확인 -> ORA-00600 발생 확인

Tue Apr 10 16:14:17 KST 2018

Errors in file /oracle/app/oracle/admin/orcl/udump/orcl_ora_31964.trc:

ORA-00600: internal error code, arguments: [kokasgi1], [], [], [], [], [], [], []

Error 600 happened during db open, shutting down database

USER: terminating instance due to error 600

Instance terminated by USER, pid = 31964

10gR2

ORA-07445: exception encountered: core dump [hshuid()+397] [SIGSEGV] [Address not mapped to object] [0x000000020] [] []

1. delete SYS.IDL_CHAR$;

commit;

2. shutdown abort

3. startup

ORA-03113: end-of-file on communication channel

4. alert log 확인 -> ORA-07445 발생 확인

Fri Apr 13 17:49:32 KST 2018

Errors in file /oracle/app/oracle/admin/orcl/udump/orcl_ora_8847.trc:

ORA-07445: exception encountered: core dump [hshget1()+199] [SIGSEGV] [Address not mapped to object] [0x000000020] [] []

10gR2

ORA-00600: internal error code, arguments: [kkmendsel-pin], [0x070A4B608], [0x06CC76DB0], [0x06CC53928], [SYS], [DBA_QUEUES], [], []

1. delete SYS.OBJAUTH$;

commit;

2. shutdown abort

3. startup

4. alert log 확인 -> ORA-00600 발생 확인

Fri Apr 13 17:57:13 KST 2018

Errors in file /oracle/app/oracle/admin/orcl/bdump/orcl_mmon_8970.trc:

ORA-00600: internal error code, arguments: [kkmendsel-pin], [0x070A4B608], [0x06CC76DB0], [0x06CC53928], [SYS], [DBA_QUEUES], [], []

Fri Apr 13 17:57:14 KST 2018

11gR2

ORA-00600: internal error code, arguments: [16513], [1403], [20], [], [], [], [], [], [], [], [],

1. delete sys.obj$;

commit;

2. shutdown abort

3. startup

ORA-01092: ORACLE instance terminated. Disconnection forced

ORA-00704: bootstrap process failure

ORA-00704: bootstrap process failure

ORA-00600: internal error code, arguments: [16513], [1403], [20], [], [], [], [], [], [], [], [],

[]

Process ID: 5059

Session ID: 1 Serial number: 5

4. alert log 확인 -> ORA-00600 발생 확인

Errors in file /app/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_5059.trc  (incident=7353):

ORA-00600: internal error code, arguments: [16513], [1403], [20], [], [], [], [], [], [], [], [], []

Incident details in: /app/oracle/diag/rdbms/orcl/orcl/incident/incdir_7353/orcl_ora_5059_i7353.trc

Use ADRCI or Support Workbench to package the incident.

See Note 411.1 at My Oracle Support for error and packaging details.

-> alert 에 있는 Note 411.1 은 [ADR 다른 방법으로 IPS 패키지 생성 (문서 ID 411.1)]임

11gR2

ORA-00600: internal error code, arguments: [kkmendsel-pin], [0x06F46C5C0], [0x000000000], [0x000000000], [SYS], [V$INSTANCE], [], [], [], [], [], []

1. delete SYS.OBJAUTH$;

commit;

2. shutdown abort

3. startup

4. alert log 확인 -> ORA-00600 발생 확인

Errors in file /app/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_9106.trc  (incident=27754):

ORA-00600: internal error code, arguments: [kkmendsel-pin], [0x06F46C5C0], [0x000000000], [0x000000000], [SYS], [V$INSTANCE], [], [], [], [], [], []

Incident details in: /app/oracle/diag/rdbms/orcl/orcl/incident/incdir_27754/orcl_ora_9106_i27754.trc

Use ADRCI or Support Workbench to package the incident.

See Note 411.1 at My Oracle Support for error and packaging details.

11gR2

ORA-00600: internal error code, arguments: [kkdlInvHdlAndDep0], [], [], [], [], [], [], [], [], [], [], []

1. delete SYS.SYSAUTH$;

commit;

2. shutdown abort

3. startup

ORA-01092: ORACLE instance terminated. Disconnection forced

ORA-00600: internal error code, arguments: [kglLock-bad-byd], [0], [0], [], [], [], [], [], [], [],[], []

Process ID: 10053

Session ID: 1 Serial number: 5

4. alert log 확인 -> ORA-00600 발생 확인

Errors in file /app/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_9419.trc  (incident=32556):

ORA-00600: internal error code, arguments: [kkdlInvHdlAndDep0], [], [], [], [], [], [], [], [], [], [], []

Incident details in: /app/oracle/diag/rdbms/orcl/orcl/incident/incdir_32556/orcl_ora_9419_i32556.trc

Use ADRCI or Support Workbench to package the incident.

See Note 411.1 at My Oracle Support for error and packaging details.

Dumping diagnostic data in directory=[cdmp_20180412125740], requested by (instance=1, osid=9419), summary=[incident=32555].

11gR2

startup 시 DB 행

1. delete SYS.IDL_CHAR$;

commit;

2. shutdown abort

3. startup

에러는 없으나 행걸림

4. alert log 확인 -> 특이사항 없음

5. top 확인 -> oracle cpu 100% 점유

11gR2

startup 시 DB 행

1. delete SYS.IDL_UB1$;

commit;

2. shutdown abort

3. startup

에러는 없으나 행걸림

4. alert log 확인 -> 특이사항 없음

5. top 확인 -> oracle cpu 100% 점유

11gR2

ORA-00600: internal error code, arguments: [opiodr: call 2], [], [], [], [], [], [], [], [], [],[], []

ORA-00600: internal error code, arguments: [kqlobjlod-no-result-from-proc$], [1403], [12296], [],[], [], [], [], [], [], [], []

1. delete SYS.PROCEDURE$;

commit;

2. shutdown abort

3. startup

ORA-00600: internal error code, arguments: [opiodr: call 2], [], [], [], [], [], [], [], [], [],[], []

ORA-00600: internal error code, arguments: [kqlobjlod-no-result-from-proc$], [1403], [12296], [],[], [], [], [], [], [], [], []

4. alert log 확인 -> ORA-00600 발생 확인

Dumping diagnostic data in directory=[cdmp_20180412152304], requested by (instance=1, osid=5408), summary=[incident=57755].

ORA-600 signalled during: ALTER DATABASE OPEN...

Errors in file /app/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_5408.trc  (incident=57757):

ORA-00600: internal error code, arguments: [opiodr: call 2], [], [], [], [], [], [], [], [], [], [], []

ORA-00600: internal error code, arguments: [kqlobjlod-no-result-from-proc$], [1403], [12296], [], [], [], [], [], [], [], [], []

Incident details in: /app/oracle/diag/rdbms/orcl/orcl/incident/incdir_57757/orcl_ora_5408_i57757.trc

Errors in file /app/oracle/diag/rdbms/orcl/orcl/trace/orcl_mmon_5396.trc  (incident=57724):

11gR2

ORA-00600: internal error code, arguments: [kzsviver:1], [], [], [], [], [], [], [], [], [], [], []

1. 유저 생성 구문에 ''를 넣음

2. create user test identified by values '';

3. 바로 에러 발생

create user test identified by values ''

*

ERROR at line 1:

ORA-00600: internal error code, arguments: [kzsviver:1], [], [], [], [], [], [], [], [], [], [], []

12cR1

ORA-00600: internal error code, arguments: [qernsRowP], [1], [], [], [], [], [], [], [], [], [], []

http://positivemh.tistory.com/261

1. 테스트 테이블 및 인덱스 생성

2. 통계정보 수집

3. 인덱스 숨김, 보임 숨김 처리

4. 테이블 조회

원인 : 오라클 내부 오류 -> support.oracle.com 참조

참조 : 

더 해볼 테이블

https://docs.oracle.com/cd/E18283_01/timesten.112/e17114/systemtables.htm