@@@@Platform-“OnPrem”

@@@@Product-“Database”

@@@@ReleaseVersion-“26.11”

@@@@info-map-label-“tfactl print”

tfactl print

Use the tfactl print command to print information from the Berkeley DB (BDB).

Syntax

tfactl print command [options]
Commands: status|components|config|directories|hosts|actions|repository|runmode|suspendedips|protocols|smtp|collections
tfactl print status
tfactl print components [ [component_name1] [component_name2] ... [component_nameN] ]
tfactl print config [ -node all | local | n1,n2,...  -name param]
tfactl print directories [ -node all | local | n1,n2,... ] [ -comp component_name1,component_name2,... ] [ -policy exclusions | noexclusions ]
[ -permission public | private ]
tfactl print collections [ -status status ] [ -last <n><m|h|d> ] [-id] [ -json ]
tfactl print hosts
tfactl print actions [ -status status ] [ -since nh|d ]
tfactl print repository
tfactl print runmode
tfactl print suspendedips
tfactl print protocols
tfactl print smtp
tfactl print collections -status QUEUED
tfactl print collections -status COMPLETED

Parameters

tfactl print Command Parameters

Parameter Description
status Displays the status of Oracle Trace File Analyzer across all nodes in the cluster. Also, displays the Oracle Trace File Analyzer version and the port on which it is running.
components Displays the desired components in the configuration.
config Displays the current Oracle Trace File Analyzer configuration settings.
directories Lists all the directories that Oracle Trace File Analyzer scans for trace or log file data. Also, displays the location of the trace directories allocated for the database, Oracle ASM, and instance.
hosts Lists the hosts that are part of the Oracle Trace File Analyzer cluster, and that can receive cluster-wide commands.
actions Lists all the actions submitted to Oracle Trace File Analyzer, such as diagnostic collection. By default, tfactl print commands only display actions that are running or that have completed in the last hour.
repository Displays the current location and amount of used space of the repository directory. Initially, the maximum size of the repository directory is the smaller of either 10 GB or 50% of available file system space. If the maximum size is exceeded or the file system space gets to 1 GB or less, then Oracle Trace File Analyzer suspends operations and closes the repository. Use the tfactl purge command to clear collections from the repository.
suspendedips Lists all paused Oracle Trace File Analyzer IPS collections.
protocols Lists all available and restricted protocols.
smtp Displays the SMTP server configuration

Options

tfactl print collections [ -status  ] [ -last <m|h|d> ] [ -from  -to  | -for  ] [ -json [ -pretty ] ] [ -csv ]

Note: tfactl print collections supports listing collections for n days where n <=7.

Option Description
-status status

Collection status can be:

  • running
  • queued
  • completed

-last nh|d

-since

Specify to print collections since the past <i>n</i> days or <i>n</i> hours.

Same as -last. Kept for backward compatibility.

-from

-to

Specify the -from and -to parameters (you must use these two parameters together) to print collection details for a specific time interval.

Supported time formats:

  • "yyyy-mm-ddThh:mm:ssZ"
  • "yyyy-mm-ddThh:mm:ss[+-]hh:mm"
-for

Specify the -for parameter to print collection details for the date specified.

Supported time format: "yyyy-mm-dd"

-json Specify to generate the output in JSON format.
-pretty Specify to format the JSON output.
-csv Specify to generate the output in CSV format.

Example tfactl print runmode

tfactl print runmode
TFA Run Mode: COLLECTOR

Example tfactl print smtp

tfactl print smtp
.---------------------------.
| SMTP Server Configuration |
+---------------+-----------+
| Parameter     | Value     |
+---------------+-----------+
| smtp.auth     | false     |
| smtp.from     | tfa       |
| smtp.user     | -         |
| smtp.cc       | -         |
| smtp.port     |        25 |
| smtp.bcc      | -         |
| smtp.password | *******   |
| smtp.host     | localhost |
| smtp.to       | -         |
| smtp.debug    | true      |
| smtp.ssl      | false     |
'---------------+-----------'

Example tfactl print protocols

tfactl print protocols
.--------------------------------------------------.
|                    node1                         |
+--------------------------------------------------+
| Protocols                                        |
+--------------------------------------------------+
| Available : [TLSv1.2]                            |
| Restricted : [SSLv3, SSLv2Hello, TLSv1, TLSv1.1] |
'--------------------------------------------------'

Example tfactl print components ASM

$ tfactl print components ASM
.--------------------------------------------------.
|                  XML Components                  |
+---------------+----------------------------------+
| Field         | Value                            |
+---------------+----------------------------------+
| Name          | ASM                              |
| Description   | ASM logs                         |
| Comp. Types   | collection action                |
| Configuration | all                              |
| Subcomponents | name:instance required: default: |
| Also collect  | TNS                              |
|               | AFD                              |
|               | ASMPROXY                         |
|               | ASMIO                            |
'---------------+----------------------------------'

Example tfactl print components ODASTORAGE

$ tfactl print components ODASTORAGE
.-------------------------------------------.
|               XML Components              |
+---------------+---------------------------+
| Field         | Value                     |
+---------------+---------------------------+
| Name          | ODASTORAGE                |
| Description   | ODA Storage logs and Data |
| Comp. Types   | action                    |
| Configuration | ODA                       |
| Also collect  | OS                        |
|               | ODA                       |
|               | ASM                       |
|               | DCS                       |
'---------------+---------------------------'

Example tfactl print collections -id -json

tfactl print collections -id 20240104010433stbm000004-vm18 -json
[
    {
        "CollectionId": "20240104010433stbm000004-vm18",
        "InitiatedNode": "stbm000004-vm18",
        "CollectionType": "Manual Collection",
        "RequestUser": "root",
        "NodeList": "[stbm000004-vm17, stbm000004-vm18]",
        "StartTime": "2024-01-04T00:04:30.000-0600",
        "EndTime": "2024-01-04T01:04:30.000-0600",
        "ComponentList": "[omsi, emagent, acfs, asmproxy, sosreport, crsclient,
emagenti, oms, qos, dbwlm, ocm, cha, cfgtools, afd, avs, dbclient, rdbms, cvu,
os, crs, syslens, hami, em, chmos, goldengate, asmio, dataguard, install,
compliance, tns, asm, rhp, emplugins, wls]",
        "UploadStatus": "FAILED",
        "CollectionStatus": "COMPLETED",
        "NodeCollection": [
            {
                "Host": "stbm000004-vm18",
                "Tag":
"/u01/app/giusr/oracle.ahf/data/repository/collection_Thu_Jan_04_01_04_37_CST_2024_node_all/",
                "ZipFileName":
"/u01/app/giusr/oracle.ahf/data/repository/collection_Thu_Jan_04_01_04_37_CST_2024_node_all/stbm000004-vm18.tfa_Thu_Jan_04_01_04_36_CST_2024.zip",
                "ZipFileSize": "38896",
                "CollectionTime": "183",
                "CheckSum":
"d882835fe5bcee4b8d5381b59572f2b75dc7499ddf3adf5771e3ea75fa39e975",
                "checksum_algo": "sha256"
            },
            {
                "Host": "stbm000004-vm17",
                "Tag":
"/u01/app/giusr/oracle.ahf/data/repository/collection_Thu_Jan_04_01_04_37_CST_2024_node_all/",
                "ZipFileName":
"/u01/app/giusr/oracle.ahf/data/repository/collection_Thu_Jan_04_01_04_37_CST_2024_node_all/stbm000004-vm17.tfa_Thu_Jan_04_01_04_36_CST_2024.zip",
                "ZipFileSize": "42759",
                "CollectionTime": "186",
                "CheckSum":
"b090611f11e94814782b12f798e60ef0e054fbad47e94d950a3a24c698a79986",
                "checksum_algo": "sha256"
            }
        ]
    }
]

Example tfactl print config

tfactl print config
.------------------------------------------------------------------------------------.
|                                      node1                                         |
+-----------------------------------------------------------------------+------------+
| Configuration Parameter                                               | Value      |
+-----------------------------------------------------------------------+------------+
| TFA Version                                                           | 19.1.0.0.0 |
| Java Version                                                          | 1.8        |
| Public IP Network                                                     | false      |
| Automatic Diagnostic Collection                                       | true       |
| Alert Log Scan                                                        | true       |
| Disk Usage Monitor                                                    | true       |
| Managelogs Auto Purge                                                 | false      |
| Trimming of files during diagcollection                               | true       |
| Inventory Trace level                                                 | 1          |
| Collection Trace level                                                | 1          |
| Scan Trace level                                                      | 1          |
| Other Trace level                                                     | 1          |
| Granular Tracing                                                      | false      |
| Debug Mask (Hex)                                                      | 0          |
| Repository current size (MB)                                          | 146        |
| Repository maximum size (MB)                                          | 10240      |
| Max Size of TFA Log (MB)                                              | 50         |
| Max Number of TFA Logs                                                | 10         |
| Max Size of Core File (MB)                                            | 50         |
| Max Collection Size of Core Files (MB)                                | 500        |
| Max File Collection Size (MB)                                         | 5120       |
| Minimum Free Space to enable Alert Log Scan (MB)                      | 500        |
| Time interval between consecutive Disk Usage Snapshot(minutes)        | 60         |
| Time interval between consecutive Managelogs Auto Purge(minutes)      | 60         |
| Logs older than the time period will be auto purged(days[d]|hours[h]) | 30d        |
| Automatic Purging                                                     | true       |
| Age of Purging Collections (Hours)                                    | 12         |
| TFA IPS Pool Size                                                     | 5          |
| TFA ISA Purge Age (seconds)                                           | 604800     |
| TFA ISA Purge Mode                                                    | profile    |
| TFA ISA Purge Thread Delay (minutes)                                  | 60         |
| Setting for ACR redaction (none|SANITIZE|MASK)                        | none       |
| Email Notification will be sent for CHA EVENTS if address is set      | false      |
| AUTO Collection will be generated for CHA EVENTS                      | false      |
'-----------------------------------------------------------------------+------------'

In the preceding sample output: