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 참조
참조 :