Skip navigation

For an SR, I'm being asked by Oracle support to provide cluster data from 4H before the problem to 4 hours after the problem.

For reference, check SRDC - Data Collection for Grid Infrastructure, Storage Management, and RAC (Doc ID 2041228.1)

Here are the command lines I used and their output.

[myracuser@racnode1 bin]$ pwd

/app/grid/12.1.0/tfa/bin

[myracuser@racnode1 bin]$

[myracuser@racnode1 bin]$ /app/grid/12.1.0/tfa/bin/tfactl diagcollect -from "Jun/1/2018 13:00:00" -to "Jun/1/2018 21:00:00"

Collecting data for all nodes

Scanning files from Jun/1/2018 13:00:00 to Jun/1/2018 21:00:00

 

Collection Id : 20180604104236racnode1

 

Repository Location in racnode1 : /app/myracuser/tfa/repository

 

Collection monitor will wait up to 30 seconds for collections to start

2018/06/04 10:42:40 CEST : Collection Name : tfa_Mon_Jun_4_10_42_36_CEST_2018.zip

2018/06/04 10:42:40 CEST : Scanning of files for Collection in progress...

2018/06/04 10:42:40 CEST : Collecting extra files...

2018/06/04 10:43:10 CEST : Getting list of files satisfying time range [06/01/2018 13:00:00 CEST, 06/01/2018 21:00:00 CEST]

2018/06/04 10:43:10 CEST : Starting Thread to identify stored files to collect

2018/06/04 10:43:10 CEST : Getting List of Files to Collect

2018/06/04 10:43:10 CEST : Trimming file : racnode1/app/myracuser/crsdata/racnode1/cvu/cvutrc/cvuhelper.log.0 with original file size : 656kB

2018/06/04 10:43:11 CEST : racnode1: Zipped 100 Files so Far

2018/06/04 10:43:16 CEST : racnode1: Zipped 200 Files so Far

2018/06/04 10:43:19 CEST : racnode1: Zipped 300 Files so Far

2018/06/04 10:43:20 CEST : Trimming file : racnode1/crs/racnode1/crs/trace/crsd_1.trc with original file size : 10MB

2018/06/04 10:43:20 CEST : Trimming file : racnode1/crs/racnode1/crs/trace/crsd_oraagent_myracuser.trc with original file size : 7MB

2018/06/04 10:43:20 CEST : Trimming file : racnode1/crs/racnode1/crs/trace/crsd_orarootagent_root.trc with original file size : 882kB

2018/06/04 10:43:20 CEST : Trimming file : racnode1/crs/racnode1/crs/trace/crsd_scriptagent_myracuser.trc with original file size : 4.3MB

2018/06/04 10:43:20 CEST : Trimming file : racnode1/crs/racnode1/crs/trace/evmd.trc with original file size : 2.3MB

2018/06/04 10:43:20 CEST : Trimming file : racnode1/crs/racnode1/crs/trace/gipcd.trc with original file size : 7.6MB

2018/06/04 10:43:20 CEST : Trimming file : racnode1/crs/racnode1/crs/trace/ocssd_1.trc with original file size : 52MB

2018/06/04 10:43:20 CEST : Trimming file : racnode1/crs/racnode1/crs/trace/octssd.trc with original file size : 6MB

2018/06/04 10:43:20 CEST : Trimming file : racnode1/crs/racnode1/crs/trace/ohasd.trc with original file size : 6.3MB

2018/06/04 10:43:20 CEST : Trimming file : racnode1/crs/racnode1/crs/trace/ohasd_cssdagent_root.trc with original file size : 854kB

2018/06/04 10:43:20 CEST : Trimming file : racnode1/crs/racnode1/crs/trace/ohasd_cssdmonitor_root.trc with original file size : 847kB

2018/06/04 10:43:20 CEST : Trimming file : racnode1/crs/racnode1/crs/trace/ohasd_oraagent_myracuser.trc with original file size : 6.5MB

2018/06/04 10:43:20 CEST : Trimming file : racnode1/crs/racnode1/crs/trace/ohasd_orarootagent_root_1.trc with original file size : 10MB

2018/06/04 10:43:20 CEST : Trimming file : racnode1/var/log/messages-20180603 with original file size : 4.2MB

2018/06/04 10:43:21 CEST : Trimming file : racnode1/tnslsnr/racnode1/listener/trace/listener.log with original file size : 666kB

2018/06/04 10:43:21 CEST : racnode1: Zipped 400 Files so Far

2018/06/04 10:43:21 CEST : Trimming file : racnode1/tnslsnr/racnode1/listener_scan1/trace/listener_scan1.log with original file size : 669kB

2018/06/04 10:43:21 CEST : Trimming file : racnode1/tnslsnr/racnode1/listener_scan2/trace/listener_scan2.log with original file size : 669kB

2018/06/04 10:43:21 CEST : Trimming file : racnode1/tnslsnr/racnode1/listener_scan3/trace/listener_scan3.log with original file size : 669kB

2018/06/04 10:43:31 CEST : Finished Getting List of Files to Collect

2018/06/04 10:43:40 CEST : Collecting ADR incident files...

2018/06/04 10:43:40 CEST : Waiting for collection of extra files

2018/06/04 10:45:10 CEST : Completed collection of extra files...

2018/06/04 10:45:10 CEST : Completed Zipping of all files

2018/06/04 10:45:10 CEST : Cleaning up temporary files

2018/06/04 10:45:10 CEST : Finished Cleaning up temporary files

2018/06/04 10:45:10 CEST : Finalizing the Collection Zip File

2018/06/04 10:45:10 CEST : Finished Finalizing the Collection Zip File

2018/06/04 10:45:10 CEST : Total Number of Files checked : 3034

2018/06/04 10:45:10 CEST : Total Size of all Files Checked : 492MB

2018/06/04 10:45:10 CEST : Number of files containing required range : 489

2018/06/04 10:45:10 CEST : Total Size of Files containing required range : 135MB

2018/06/04 10:45:10 CEST : Number of files trimmed : 19

2018/06/04 10:45:10 CEST : Total Size of data prior to zip : 27MB

2018/06/04 10:45:10 CEST : Saved 109MB by trimming files

2018/06/04 10:45:10 CEST : Zip file size : 2.3MB

2018/06/04 10:45:10 CEST : Total time taken : 150s

2018/06/04 10:45:10 CEST : Completed collection of zip files.

 

Logs are being collected to: /app/myracuser/tfa/repository/collection_Mon_Jun_4_10_42_36_CEST_2018_node_all

/app/myracuser/tfa/repository/collection_Mon_Jun_4_10_42_36_CEST_2018_node_all/racnode1.tfa_Mon_Jun_4_10_42_36_CEST_2018.zip

 

180604outputofTFACollector.jpg

[myracuser@racnode1 collection_Mon_Jun_4_10_42_36_CEST_2018_node_all]$ ls -lrth

total 2.4M

-rwx------ 1 myracuser oracle 1.6K Jun  4 10:43 racnode1.tfa_Mon_Jun_4_10_42_36_CEST_2018.zip.txt

-rwx------ 1 myracuser oracle 2.4M Jun  4 10:45 racnode1.tfa_Mon_Jun_4_10_42_36_CEST_2018.zip

-rwx------ 1 myracuser oracle 4.3K Jun  4 10:45 diagcollect_20180604104236_racnode1.log

 

 

The .txt file is 40-line long and is the report of the collection :

TFA Version : 12.1.2.7.0

Build ID : 12127020160304140533

 

Collection ID : 20180604104236racnode1

Zip file name : tfa_Mon_Jun_4_10_42_36_CEST_2018.zip

Zip file location : /app/myracuser/tfa/repository/collection_Mon_Jun_4_10_42_36_CEST_2018_node_all/racnode1.tfa_Mon_Jun_4_10_42_36_CEST_2018.zip

Zip file creation date : Mon Jun 04 2018 10:42:40 CEST

Host name : racnode1

Duration of Diagnostics :

  Start date : Fri Jun 01 2018 13:00:00 CEST

  End date : Fri Jun 01 2018 21:00:00 CEST

Component(s) in zip file : INSTALL  CRS  OS  EMAGENT  DBWLM  OCM  ACFS  RDBMS  TNS  OMS  WLS  EMPLUGINS  EM  ASMPROXY  ASM  CFGTOOLS  CHMOS  SUNDIAG

User initiated

 

Directory Structure in zip file :

racnode1/

racnode1/etc/oracle

racnode1/app/oraInventory/ContentsXML

racnode1/app/myracuser/crsdata/racnode1/output

racnode1/var/log

racnode1/tnslsnr/racnode1/listener_scan2/trace

 

 

The log file is what appeared on standard output above, which finishes with

2018/06/04 10:45:10 CEST : Completed collection of zip files.

 

 

Here is a glance at the contents of the zip file:

[myracuser@racnode1 collection_Mon_Jun_4_10_42_36_CEST_2018_node_all]$ unzip -l racnode1.tfa_Mon_Jun_4_10_42_36_CEST_2018.zip

Archive:  racnode1.tfa_Mon_Jun_4_10_42_36_CEST_2018.zip

  Length      Date    Time    Name

---------  ---------- -----   ----

    13658  06-01-2018 17:24   racnode1/app/grid/12.1.0/cfgtoollogs/opatch/lsinv/lsinventory2018-06-01_17-24-19PM.txt

    22345  06-01-2018 17:24   racnode1/app/grid/12.1.0/cfgtoollogs/opatch/opatch2018-06-01_17-24-19PM_1.log

   383494  06-01-2018 17:13   racnode1/app/grid/12.1.0/install/make.log

     1063  06-01-2018 15:58   racnode1/app/grid/12.1.0/install/root_racnode1_2018-06-01_15-58-40.log

     7402  06-01-2018 17:23   racnode1/app/grid/12.1.0/install/root_racnode1_2018-06-01_17-13-23.log

      329  06-01-2018 17:40   racnode1/app/oraInventory/ContentsXML/comps.xml

      564  06-01-2018 17:40   racnode1/app/oraInventory/ContentsXML/inventory.xml

      292  06-01-2018 17:40   racnode1/app/oraInventory/ContentsXML/libs.xml

     8464  06-01-2018 17:08   racnode1/app/oraInventory/logs/UpdateNodeList2018-06-01_05-07-55-PM.log

     369  06-04-2018 10:42   racnode1/racnode1_QUERYVOTE

      127  06-04-2018 10:42   racnode1/racnode1_VERSIONS

---------                     -------

27114817                     550 files

 

I then uploaded their zip (only the zip file, as requested ) to the SR.  The SR status changed from “Customer Working” to “Review Update”: