tfactl diagcollect -srdc ora600收集错误信息-白红宇

tfactl diagcollect -srdc ora600收集错误信息

阅读量：2042 次

发布时间：2019-04-28

本文共 7481 字，大约阅读时间需要 24 分钟。

[grid@raci1 ~]$ tfactl diagcollect -srdc ora600

Enter the time of the ORA-00600 [YYYY-MM-DD HH24:MI:SS,<RETURN>=ALL] : 2020-12-29 00:00:00

Enter the Database Name [<RETURN>=ALL] :?

No events matching the timestamp Dec/28/2020 18:00:00-Dec/29/2020 06:00:00.

The timestamp must be between Jul/07/2020 15:11:23 and Dec/04/2020 15:33:11.

1. Dec/04/2020 15:33:11 : [db1] ORA-00600: internal error code, arguments: [kgantc_1], [0], [1], [], [], [], [], [], [], [], [], []

2. Dec/04/2020 15:33:08 : [db1] ORA-00600: 内部错误代码, 参数: [kgantc_1], [0], [1], [], [], [], [], [], [], [], [], []

3. Dec/04/2020 15:33:04 : [db1] ORA-00600: 内部错误代码, 参数: [kgantc_1], [0], [1], [], [], [], [], [], [], [], [], []

4. Sep/14/2020 17:47:45 : [db1] ORA-00600: 内部错误代码, 参数: [kglobpn-bad-pga], [], [], [], [], [], [], [], [], [], [], []

5. Sep/11/2020 16:09:38 : [db1] ORA-00600: internal error code, arguments: [kglobpn-bad-pga], [], [], [], [], [], [], [], [], [], [], []

6. Sep/11/2020 13:37:21 : [db1] ORA-00600: 内部错误代码, 参数: [kkqjpdGetContext:1], [], [], [], [], [], [], [], [], [], [], []

7. Sep/02/2020 10:38:59 : [db1] ORA-00600: 内部错误代码, 参数: [kglobpn-bad-pga], [], [], [], [], [], [], [], [], [], [], []

8. Sep/02/2020 10:09:34 : [db1] ORA-00600: 内部错误代码, 参数: [kglobpn-bad-pga], [], [], [], [], [], [], [], [], [], [], []

9. Jul/07/2020 15:11:26 : [db1] ORA-00600: internal error code, arguments: [kgantc_1], [0], [1], [], [], [], [], [], [], [], [], []

10. Jul/07/2020 15:11:23 : [db1] ORA-00600: internal error code, arguments: [kgantc_1], [0], [1], [], [], [], [], [], [], [], [], []

Please choose the event : 1-10 [1] 1 ? ? ? ? ? ? ? ? ? ? ? ? ??

Selected value is : ( 1. Dec/04/2020 15:33:11 : [db1] ORA-00600: internal error code, arguments: [kgantc_1], [0], [1], [], [], [], [], [], [], [], [], [] )

Scripts to be run by this srdc: ipspack rdahcve1210 rdahcve1120 rdahcve1110?

Components included in this srdc: OS DATABASE NOCHMOS

Collecting data for local node(s)

Scanning files from Dec/04/2020 09:33:11 to Dec/04/2020 21:33:11

Collection Id : 20201229132053raci1

Repository Location in raci1 : /oracle/app/grid/tfa/repository

Collection monitor will wait up to 60 seconds for collections to start?

2020/12/29 13:20:56 CST : NOTE : Any file or directory name containing the string .com will be renamed to replace .com with dotcom

2020/12/29 13:20:56 CST : Collection Name : tfa_srdc_ora600_Tue_Dec_29_13_20_53_CST_2020.zip

2020/12/29 13:20:57 CST : Scanning of files for Collection in progress...

2020/12/29 13:20:57 CST : Collecting extra files...

2020/12/29 13:23:30 CST : Completed collection of extra files...

date

Logs are being collected to: /oracle/app/grid/tfa/repository/srdc_ora600_collection_Tue_Dec_29_13_20_53_CST_2020_node_local

/oracle/app/grid/tfa/repository/srdc_ora600_collection_Tue_Dec_29_13_20_53_CST_2020_node_local/raci1.tfa_srdc_ora600_Tue_Dec_29_13_20_53_CST_2020.zip

[grid@raci1 ~]$ cd /oracle/app/grid/tfa/repository/srdc_ora600_collection_Tue_Dec_29_13_20_53_CST_2020_node_local

[grid@raci1 srdc_ora600_collection_Tue_Dec_29_13_20_53_CST_2020_node_local]$ ll

total 1328

-rwx------ 1 grid oinstall ? ? 793 Dec 29 13:26 diagcollect_20201229132053_raci1.log

-rw-r--r-- 1 root root ? ? 1348265 Dec 29 13:26 raci1.tfa_srdc_ora600_Tue_Dec_29_13_20_53_CST_2020.zip

-rw-r--r-- 1 root root ? ? ? ? 575 Dec 29 13:20 raci1.tfa_srdc_ora600_Tue_Dec_29_13_20_53_CST_2020.zip.txt

[grid@raci1 srdc_ora600_collection_Tue_Dec_29_13_20_53_CST_2020_node_local]$ date

Tue Dec 29 13:26:28 CST 2020

常见可忽略600错误：PL/SQL取消或编译错误等

[grid@racj1 ~]$ tfactl diagcollect -srdc ora600

Enter the time of the ORA-00600 [YYYY-MM-DD HH24:MI:SS,<RETURN>=ALL] : 2020-12-29 00:00:00

Enter the Database Name [<RETURN>=ALL] :?

No events matching the timestamp Dec/28/2020 18:00:00-Dec/29/2020 06:00:00.

The timestamp must be between Nov/24/2020 10:09:22 and Dec/10/2020 09:35:02.

1. Dec/10/2020 09:35:02 : [db2] ORA-00600: internal error code, arguments: [kglobpn-bad-pga], [], [], [], [], [], [], [], [], [], [], []

2. Nov/24/2020 11:42:34 : [db2] ORA-00600: internal error code, arguments: [kgantc_1], [0], [1], [], [], [], [], [], [], [], [], []

3. Nov/24/2020 11:42:32 : [db2] ORA-00600: internal error code, arguments: [kgantc_1], [0], [1], [], [], [], [], [], [], [], [], []

4. Nov/24/2020 11:42:31 : [db2] ORA-00600: internal error code, arguments: [kgantc_1], [0], [1], [], [], [], [], [], [], [], [], []

5. Nov/24/2020 10:26:34 : [db2] ORA-00600: internal error code, arguments: [kgantc_1], [0], [1], [], [], [], [], [], [], [], [], []

6. Nov/24/2020 10:26:32 : [db2] ORA-00600: internal error code, arguments: [kgantc_1], [0], [1], [], [], [], [], [], [], [], [], []

7. Nov/24/2020 10:26:30 : [db2] ORA-00600: internal error code, arguments: [kgantc_1], [0], [1], [], [], [], [], [], [], [], [], []

8. Nov/24/2020 10:09:25 : [db2] ORA-00600: internal error code, arguments: [kgantc_1], [0], [1], [], [], [], [], [], [], [], [], []

9. Nov/24/2020 10:09:23 : [db2] ORA-00600: internal error code, arguments: [kgantc_1], [0], [1], [], [], [], [], [], [], [], [], []

10. Nov/24/2020 10:09:22 : [db2] ORA-00600: internal error code, arguments: [kgantc_1], [0], [1], [], [], [], [], [], [], [], [], []

Please choose the event : 1-10 [1] ^CCancelling...

[grid@racj1 ~]$ tfactl diagcollect -srdc ora700

Enter the time of the ORA-00700 [YYYY-MM-DD HH24:MI:SS,<RETURN>=ALL] : 2020-12-29 00:00:00

Enter the Database Name [<RETURN>=ALL] :?

No events matching the timestamp Dec/28/2020 18:00:00-Dec/29/2020 06:00:00.

The timestamp must be between ?and .

Please choose the event : 1-0 [1] ^CCancelling...

[grid@racj1 ~]$ tfactl diagcollect -srdc ora7445

Enter the time of the ORA-07445 [YYYY-MM-DD HH24:MI:SS,<RETURN>=ALL] : 2020-12-29 00:00:00

Enter the Database Name [<RETURN>=ALL] :?

No events matching the timestamp Dec/28/2020 18:00:00-Dec/29/2020 06:00:00.

The timestamp must be between Jan/22/2019 13:58:48 and Jun/18/2020 14:21:26.

1. Jun/18/2020 14:21:26 : [db2] ORA-07445: exception encountered: core dump [psdghi()+1253] [SIGSEGV] [ADDR:0x28] [PC:0x39B37C1] [Address not mapped to object] []

2. Jun/18/2020 14:06:42 : [db2] ORA-07445: exception encountered: core dump [psdghi()+1253] [SIGSEGV] [ADDR:0x28] [PC:0x39B37C1] [Address not mapped to object] []

3. Aug/16/2019 00:37:28 : [db2] ORA-07445: exception encountered: core dump [kgherrordmp()+986] [SIGSEGV] [ADDR:0x0] [PC:0x828DFA0] [Address not mapped to object] []

4. Aug/16/2019 00:37:07 : [db2] ORA-07445: 出现异常错误: 核心转储 [kghalf()+55] [SIGSEGV] [ADDR:0x68] [PC:0x981CAFF] [Address not mapped to object] []

5. Aug/16/2019 00:12:48 : [db2] ORA-07445: 出现异常错误: 核心转储 [kghbshrt()+105] [SIGSEGV] [ADDR:0x7F1442903BE8] [PC:0x9826A05] [Address not mapped to object] []

6. Aug/16/2019 00:08:50 : [db2] ORA-07445: 出现异常错误: 核心转储 [kghbshrt()+105] [SIGSEGV] [ADDR:0x7FC53C9157F0] [PC:0x9826A05] [Address not mapped to object] []

7. Aug/16/2019 00:02:33 : [db2] ORA-07445: 出现异常错误: 核心转储 [kghbshrt()+105] [SIGSEGV] [ADDR:0x7FDD61369140] [PC:0x9826A05] [Address not mapped to object] []

8. Aug/15/2019 23:13:24 : [db2] ORA-07445: 出现异常错误: 核心转储 [kghbshrt()+105] [SIGSEGV] [ADDR:0x7FE60D355160] [PC:0x9826A05] [Address not mapped to object] []

9. Jan/22/2019 14:07:58 : [db2] ORA-07445: 出现异常错误: 核心转储 [pfri9_init_register_files()+28] [SIGSEGV] [ADDR:0x0] [PC:0x37C0DD2] [SI_KERNEL(general_protection)] []

10. Jan/22/2019 13:58:48 : [db2] ORA-07445: 出现异常错误: 核心转储 [pfri9_init_register_files()+28] [SIGSEGV] [ADDR:0x10] [PC:0x37C0DD2] [Address not mapped to object] []