C.3 tfactl events

Use the tfactl events command to view the events detected by Oracle Trace File Analyzer.

Syntax

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]

Parameters

Option Description

component [ASM|CRS]

Searches all Oracle Automatic Storage Management (Oracle ASM) or Oracle Clusterware events.

database db_name

Specify the name of an Oracle Database to search all events from that Oracle Database.

instance db_instance_name

Specify the name of an Oracle Database instance to search all events from that Oracle Database instance.

source filename

Specify the source file name to search all events from that alert file.

json

Displays event information in JSON format.

-last nh|d | -from time -to time | -for time]

  • Specify the -last parameter to view events for the past specific number of hours (h) or days (d).

  • Specify the -from and -to parameters (you must use these two parameters together) to view events that occurred during a specific time interval.

    Supported time formats:

    "Mon/dd/yyyy hh:mm:ss"

    "yyyy-mm-dd hh:mm:ss"

    "yyyy-mm-ddThh:mm:ss"

    "yyyy-mm-dd"

  • Specify the -for parameter to view events for the time given.

    Supported time formats:

    "Mon/dd/yyyy"

    "yyyy-mm-dd"

Note:

If you specify both date and time, then you must enclose both the values in double quotation marks (""). If you specify only the date or the time, then you do not have to enclose the single value in quotation marks.

fields all|fields_list

When provided with the -json option, the command returns only the requested fields

Oracle Trace File Analyzer detects the following events:
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

Example

$ 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)