9.3.2.3 tfactl events
tfactl eventsコマンドを使用して、Oracle Trace File Analyzerで検出されたイベントを表示します。
構文
tfactl events
[-search keyword | -component ASM|CRS | -database db_name | -instance db_instance_name | -source filename | -from time -to time | -json | -fields all|fields_list]パラメータ
| オプション | 説明 |
|---|---|
|
|
すべてのOracle Automatic Storage Management (Oracle ASM)イベントまたはOracle Clusterwareイベントを検索します。 |
|
|
Oracle Databaseの名前を指定して、そのOracle Databaseからすべてのイベントを検索します。 |
|
|
Oracle Databaseインスタンスの名前を指定して、そのOracle Databaseインスタンスからすべてのイベントを検索します。 |
|
|
ソース・ファイル名を指定して、そのアラート・ファイルからすべてのイベントを検索します。 |
|
|
イベント情報をJSON形式で表示します。 |
|
|
ノート: 日付と時刻の両方を指定する場合、両方の値を二重引用符("")で囲む必要があります。日付のみまたは時刻のみを指定する場合は、単一の値を引用符で囲む必要はありません。 |
|
|
|
Oracle Trace File Analyzerは次のイベントを検出します。
ORA-03113
ORA-03137
ORA-00603
ORA-00700
ORA-00353
ORA-00355
ORA-00356
ORA-04020
ORA-04036
ORA-04030
ORA-04031
ORA-00227
ORA-00239
ORA-00240
ORA-00255
ORA-00257
ORA-01578
ORA-25319
ORA-24982
ORA-56729
ORA-00445
ORA-5014
ORA-27300
ORA-27301
ORA-27302
ORA-00060
ORA-16038
ORA-15338
ORA-15064
ORA-19815
ORA-19804
ORA-19809
ORA-15196
ORA-08101
ORA-08102
ORA-08103
ORA-04021
ORA-15311
ORA-00600
ORA-07445
ORA-00469
ORA-00470
ORA-00471
ORA-00472
ORA-00473
ORA-00474
ORA-00475
ORA-00476
ORA-00478
ORA-00479
ORA-00480
ORA-00481
ORA-00482
ORA-00483
ORA-00484
ORA-00485
ORA-00486
ORA-00487
ORA-00488
ORA-00489
ORA-00490
ORA-00491
ORA-00492
ORA-00493
ORA-00495
ORA-00496
ORA-00497
ORA-00498
ORA-00499
ORA-29701
ORA-29702
ORA-29703
ORA-29708
ORA-29709
ORA-29710
ORA-29740
ORA-29770
ORA-29771
ORA-32701
ORA-32703
ORA-32704
ORA-00494例
$ tfactl events
Output from host : node1
------------------------------
Event Summary:
INFO :15
ERROR :105
WARNING :2
Event Timeline:
[Aug/24/2020 20:03:01.000]: [db.db0422_iad33r.DB04221]: ORA-00600: internal error code, arguments: [kghfrf1], [], [], []
[Aug/24/2020 20:03:01.000]: [db.db0422_iad33r.DB04221]: ORA-07445: exception encountered: core dump [] [] [] [] [] []
[Aug/24/2020 20:03:01.000]: [db.db0422_iad33r.DB04221]: ORA-29708: error occurred in Cluster Synchronization Services
[Aug/24/2020 20:05:00.000]: [db.db0422_iad33r.DB04221]: ORA-00257: archiver error
[Aug/24/2020 20:05:00.000]: [db.db0422_iad33r.DB04221]: ORA-01578: ORACLE data block corrupted file 1, block 57371
[Aug/24/2020 20:05:00.000]: [db.db0422_iad33r.DB04221]: ORA-32701: Possible hangs up to hang ID= detected
[Aug/24/2020 20:07:01.000]: [db.db0422_iad33r.DB04221]: Instance terminated by USER, pid = 49334
[Aug/24/2020 20:10:09.000]: [db.db0422_iad33r.DB04221]: Starting ORACLE instance (normal) (OS id: 52489)
[Aug/24/2020 20:10:14.000]: [db.db0422_iad33r.DB04221]: Reconfiguration started (old inc 0, new inc 44)
[Aug/24/2020 23:22:00.000]: [db.db0422_iad33r.DB04221]: ORA-00600: internal error code, arguments: [kghfrf1], [], [], []
[Aug/24/2020 23:22:00.000]: [db.db0422_iad33r.DB04221]: ORA-07445: exception encountered: core dump [] [] [] [] [] []
[Aug/24/2020 23:22:00.000]: [db.db0422_iad33r.DB04221]: ORA-29708: error occurred in Cluster Synchronization Services
[Aug/24/2020 23:24:01.000]: [db.db0422_iad33r.DB04221]: ORA-00257: archiver error
[Aug/24/2020 23:24:01.000]: [db.db0422_iad33r.DB04221]: ORA-01578: ORACLE data block corrupted file 1, block 57371
[Aug/24/2020 23:24:01.000]: [db.db0422_iad33r.DB04221]: ORA-32701: Possible hangs up to hang ID= detected
[Aug/24/2020 23:26:02.000]: [asm.+ASM1]: Instance terminated by USER, pid = 83183
[Aug/24/2020 23:29:15.000]: [asm.+ASM1]: Starting ORACLE instance (normal) (OS id: 98769)
[Aug/24/2020 23:29:20.000]: [asm.+ASM1]: Reconfiguration started (old inc 0, new inc 188)
[Aug/24/2020 23:37:02.000]: [db.db0422_iad33r.DB04221]: Instance terminated by USER, pid = 7260
[Aug/24/2020 23:40:15.000]: [db.db0422_iad33r.DB04221]: Starting ORACLE instance (normal) (OS id: 19279)
[Aug/24/2020 23:40:21.000]: [db.db0422_iad33r.DB04221]: Reconfiguration started (old inc 0, new inc 48)
[Aug/24/2020 23:48:07.000]: [asm.+ASM1]: Starting ORACLE instance (normal) (OS id: 33507)
[Aug/24/2020 23:48:11.000]: [asm.+ASM1]: Reconfiguration started (old inc 0, new inc 192)
[Aug/24/2020 23:48:16.000]: [db.db0422_iad33r.DB04221]: ORA-15064: communication failure with ASM instance
[Aug/24/2020 23:52:02.000]: [db.db0422_iad33r.DB04221]: Instance terminated by USER, pid = 20510
[Aug/24/2020 23:52:35.088]: [crs]: 2020-08-24 23:52:35.088 [OCSSD(31306)]CRS-1603: CSSD on node racgi-kumar1 has been shut down.
[Aug/24/2020 23:55:57.333]: [crs]: 2020-08-24 23:55:57.333 [OCSSD(46179)]CRS-1601: CSSD Reconfiguration complete. Active nodes are racgi-kumar1 racgi-kumar2 .
[Aug/24/2020 23:56:19.000]: [asm.+ASM1]: Starting ORACLE instance (normal) (OS id: 47183)
[Aug/24/2020 23:56:24.000]: [asm.+ASM1]: Reconfiguration started (old inc 0, new inc 196)
[Aug/24/2020 23:56:32.000]: [apx.+APX1]: Starting ORACLE instance (normal) (OS id: 47673)
[Aug/24/2020 23:56:35.000]: [db.db0422_iad33r.DB04221]: Starting ORACLE instance (normal) (OS id: 47714)
[Aug/24/2020 23:56:41.000]: [db.db0422_iad33r.DB04221]: Reconfiguration started (old inc 0, new inc 52)
[Aug/25/2020 11:25:00.000]: [db.db0422_iad33r.DB04221]: ORA-00600: internal error code, arguments: [kghfrf1], [], [], []
[Aug/25/2020 11:25:00.000]: [db.db0422_iad33r.DB04221]: ORA-07445: exception encountered: core dump [] [] [] [] [] []
[Aug/25/2020 11:25:00.000]: [db.db0422_iad33r.DB04221]: ORA-29708: error occurred in Cluster Synchronization Services
[Aug/25/2020 11:27:01.000]: [db.db0422_iad33r.DB04221]: ORA-00257: archiver error
[Aug/25/2020 11:27:01.000]: [db.db0422_iad33r.DB04221]: ORA-01578: ORACLE data block corrupted file 1, block 57371
[Aug/25/2020 11:27:01.000]: [db.db0422_iad33r.DB04221]: ORA-32701: Possible hangs up to hang ID= detected
[Aug/25/2020 11:29:02.000]: [db.db0422_iad33r.DB04221]: Instance terminated by USER, pid = 59035
[Aug/25/2020 11:32:09.000]: [db.db0422_iad33r.DB04221]: Starting ORACLE instance (normal) (OS id: 62205)
[Aug/25/2020 11:32:14.000]: [db.db0422_iad33r.DB04221]: Reconfiguration started (old inc 0, new inc 56)