2. コマンドライン・リファレンス
  3. TFACTLコマンド・リファレンス
  4. Oracle Trace File Analyzer管理コマンドの実行
  5. tfactl queryindex

9.3.1.22 tfactl queryindex

tfactl queryindexコマンドを使用して、保存されているイベントを表示します。

構文

tfactl queryindex -category result | metadata
[-checkid ID]
[-target target]
[-severity severity
[-name keywords
[-fields all | fields_list]
[-last nh|d | -from time -to time]

パラメータ

表9-62 tfactl queryindexコマンドのパラメータ

パラメータ 説明

-category

Oracle Trace File Analyzerの索引に格納されているすべてのメタデータを検索します。

コンプライアンス・チェックの実行結果は、チェックID、ステータスなどのデータで構成され、メタデータはユーザー、開始時間、終了時間などのコンプライアンスの実行情報で構成されます。

メタデータの例
{
  "data_type": "compliance_metadata",
  "user": "dbusr",
  "run arguments": "-hardwaretype X4-2 -showpass -localonly -silentforce -dball -check C1AF676F0FB70BE1E053D498EB0A1971",
  "nodename": "testhost",
  "result_location": "/opt/rjtest/oracle.ahf/data/testhost/exachk",
  "output zip name": "exachk_testhost_sing11g_052721_03424",
  "start_time": "2021-06-16 01:13:18 EDT",
  "end_time": "2021-06-16 04:13:18 EDT",
  "health_score": 0
}
結果の例
{
  "modelVersion": "21.1.0_20210415",
  "RackType": "N/A",
  "EngineeredSystems": "Exadata",
  "RackIdentifier": "Cluster-c1",
  "OSVersion": "7",
  "DBVersion": "",
  "ExadataVersion": "211000",
  "HardwareType": "X4-2",
  "CoverageWindow": {
  "StartTime": "",
  "EndTime": ""
},
  "exachkExecTimestamp": "2021-06-16 01:35:39 EDT",
  "exachkID": "BEEC289AF1841071E053D498EB0A498D",
  "exachkType": "OS",
  "exachkName": "Verify v$asm_disk_stat os_mb and total_mb values are the same",
  "exachkmessage": "v$asm_disk_stat os_mb and total_mb values are the same",
  "exachkAlertType": "FAIL",
  "exachkTargetType": "ASM_HOME",
  "exachkExpectedValue": "0",
  "exachkActualValue": "0",
  "exachkStatus": "PASS",
  "exachkStatusCode": "0",
  "exachkReturnCode": "0",
  "exachkMsgDetail": "'DATA FROM BUSM01CLIENT01 - VERIFY V$ASM_DISK_STAT OS_MB AND TOTAL_MB VALUES ARE THE SAME   \nSUCCESS:os_mb and total_mb values matched for all disks. Details:\nno rows selected'",
  "NodeName": "testhost.example.com",
  "exachkProfile": ""
}

-checkid

チェックID別に結果を検索します。

-target

ターゲット別に結果を検索します。ターゲットまたはカンマ区切りのターゲットのリストを指定します。

ノート:

ターゲットを指定しない場合、Oracle Trace File Analyzerではすべてのターゲットのデータが表示されます。
有効な値:
  • ASM
  • ASM_HOME
  • CLUSTER
  • CRS
  • CRS_HOME
  • HOST
  • RDBMS
  • RDBMS_HOME
  • STORAGE_CELL
  • SWITCH

-severity

重大度別に結果を検索します。

有効な値:
  • CRITICAL
  • FAIL
  • INFO
  • PASS
  • WARNING

-name

チェック名別に結果を検索します。複数のチェック名を問い合せるには、チェック名のスペース区切りリストを指定します。

-fields

属性のサブセットに制限するフィールド(-fields NodeNameなど)を指定します。

ノート:

フィールド名では、大/小文字が区別されます。

デフォルトでは、フィールドはallに設定されています。

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

過去n時間または日以降のデータを問い合せる時間数または日数を指定します。

特定の時間間隔のデータを問い合せるには、-fromパラメータと-toパラメータを指定します(これらの2つのパラメータは一緒に使用する必要があります)。

有効な日時形式:

Mon/dd/yyyy hh:mm:ss

yyyy-mm-dd hh:mm:ss

yyyy-mm-ddThh:mm:ss

yyyy-mm-dd

例9-69 tfactl queryindex

tfactl queryindex -category result -from "2021-06-29 09:00:00" -to "2021-06-29 15:00:00" | python -m json.tool
[
    {
        "Result": [
            {
                "ActualValue": "1",
                "AlertType": "CRITICAL",
                "DBVersion": "112040",
                "EngineeredSystems": "Exadata",
                "ExadataVersion": "NULL",
                "ExecTimestamp": "2021-06-29 09:42:51 EDT",
                "ExpectedValue": "1",
                "HardwareType": "X4-2",
                "ID": "002331F422E014CAE05312C0E50AA2F3",
                "MsgDetail": "DATA FROM testhost - EXADATA DATABASE SERVER ROLLING SWITCH PATCHING MINIMUM GI SOFTWARE REQUIREMENT //n32240590;TOMCAT RELEASE UPDATE 19.0.0.0.0 (32240590)//n32222571;OCW Interim patch for 32222571//n32218663;ACFS RELEASE UPDATE 19.10.0.0.0 (32218663)//n32218454;Database Release Update :19.10.0.0.210119 (32218454)//n29340594;DBWLM RELEASE UPDATE 19.0.0.0.0 (29340594)//nOPatch succeeded.",
                "Name": "Exadata Database Server rolling switch patching minimum GI software requirement",
                "NodeName": "testhost.example.com",
                "OSVersion": "7",
                "Profile": "dba",
                "RackIdentifier": "Cluster-c1",
                "RackType": "N/A",
                "ReturnCode": "1",
                "Status": "PASS",
                "StatusCode": "0",
                "TargetType": "CRS_HOME",
                "Type": "OS",
                "message": "Exadata Database Server GI software version meets requirement for rolling switch patching",
                "modelVersion": "21.2.0(dev)_20210622"
            },
            {
                "ActualValue": "0",
                "AlertType": "CRITICAL",
                "DBVersion": "112040",
                "EngineeredSystems": "Exadata",
                "ExadataVersion": "NULL",
                "ExecTimestamp": "2021-06-29 09:43:00 EDT",
                "ExpectedValue": "0",
                "HardwareType": "X4-2",
                "ID": "AA8C83A023362C5EE040E50A1EC0146A",
                "MsgDetail": "DATA FROM testhost - CDBM121 DATABASE - RECOVERY AND CREATE FILE DESTINATIONS//ndb_recovery_file_dest = +RECOC1//ndb_create_file_dest = +DATAC1//nDATA FROM testhost - CDBM122 DATABASE - RECOVERY AND CREATE FILE DESTINATIONS//ndb_recovery_file_dest = +RECOC1//ndb_create_file_dest = +DATAC1//nDATA FROM testhost - CDBM19C DATABASE - RECOVERY AND CREATE FILE DESTINATIONS//ndb_recovery_file_dest = +RECOC1//ndb_create_file_dest = +DATAC1//nDATA FROM testhost - RAC11G DATABASE - RECOVERY AND CREATE FILE DESTINATIONS//ndb_recovery_file_dest = +RECOC1//ndb_create_file_dest = +DATAC1//nDATA FROM testhost - RAC12C DATABASE - RECOVERY AND CREATE FILE DESTINATIONS//ndb_recovery_file_dest = +RECOC1//ndb_create_file_dest = +DATAC1//nDATA FROM testhost - RAC1 DATABASE - RECOVERY AND CREATE FILE DESTINATIONS//ndb_recovery_file_dest = +RECOC1//ndb_create_file_dest = +DATAC1//nDATA FROM testhost - SING11G DATABASE - RECOVERY AND CREATE FILE DESTINATIONS//ndb_recovery_file_dest = +RECOC1//ndb_create_file_dest = +DATAC1",
                "Name": "Recovery and Create File Destinations",
                "NodeName": "testhost.example.com",
                "OSVersion": "7",
                "Profile": "dba",
                "RackIdentifier": "Cluster-c1",
                "RackType": "N/A",
                "ReturnCode": "0",
                "Status": "PASS",
                "StatusCode": "0",
                "TargetType": "RDBMS",
                "Type": "OS",
                "message": "Database DB_CREATE_FILE_DEST and DB_RECOVERY_FILE_DEST are in different diskgroups",
                "modelVersion": "21.2.0(dev)_20210622"
            }
        ],
        "hostname": "testhost1"
    }
]

tfactl queryindex -category metadata -from "2021-06-29 09:00:00" -to "2021-06-29 15:00:00" | python -m json.tool
[
    {
        "Result": [
            {
                "end_time": "2021-06-29 09:33:27 UTC",
                "error": "somemsg",
                "health_score": "0",
                "nodename": "testhost",
                "output_zip_name": "exachk_testhost_rac19c_061421_093053",
                "result_location": "/opt/oracle.ahf/data/testhost/exachk/user_root/output",
                "run_arguments": "-showpass -check B407B045E9413B83E053D598EB0A8904 -excludeprofile storage,switch -dball  -silentforce ",
                "run_type": "STANDALONE",
                "size": "45363",
                "start_time": "2021-06-29 09:31:35 UTC",
                "user": "root"
            }
        ],
        "hostname": "testhost1"
    }
]

tfactl queryindex -category metadata -last 20d | python -m json.tool
[
    {
        "Result": [
            {
                "end_time": "2021-06-29 09:33:27 UTC",
                "error": "somemsg",
                "health_score": "0",
                "nodename": "testhost",
                "output_zip_name": "exachk_testhost_rac19c_061421_093053",
                "result_location": "/opt/oracle.ahf/data/testhost/exachk/user_root/output",
                "run_arguments": "-showpass -check B407B045E9413B83E053D598EB0A8904 -excludeprofile storage,switch -dball  -silentforce ",
                "run_type": "STANDALONE",
                "size": "45363",
                "start_time": "2021-06-29 09:31:35 UTC",
                "user": "root"
            }
        ],
        "hostname": "testhost1"
    }
]

tfactl queryindex -category result -from "2021-06-29 09:00:00" -to "2021-06-29 15:00:00" -checkid 002331F422E014CAE05312C0E50AA2F3 | python -m json.tool
[
    {
        "Result": [
            {
                "ActualValue": "1",
                "AlertType": "CRITICAL",
                "DBVersion": "112040",
                "EngineeredSystems": "Exadata",
                "ExadataVersion": "NULL",
                "ExecTimestamp": "2021-06-29 09:42:51 EDT",
                "ExpectedValue": "1",
                "HardwareType": "X4-2",
                "ID": "002331F422E014CAE05312C0E50AA2F3",
                "MsgDetail": "DATA FROM testhost - EXADATA DATABASE SERVER ROLLING SWITCH PATCHING MINIMUM GI SOFTWARE REQUIREMENT //n32240590;TOMCAT RELEASE UPDATE 19.0.0.0.0 (32240590)//n32222571;OCW Interim patch for 32222571//n32218663;ACFS RELEASE UPDATE 19.10.0.0.0 (32218663)//n32218454;Database Release Update :19.10.0.0.210119 (32218454)//n29340594;DBWLM RELEASE UPDATE 19.0.0.0.0 (29340594)//nOPatch succeeded.",
                "Name": "Exadata Database Server rolling switch patching minimum GI software requirement",
                "NodeName": "testhost.example.com",
                "OSVersion": "7",
                "Profile": "dba",
                "RackIdentifier": "Cluster-c1",
                "RackType": "N/A",
                "ReturnCode": "1",
                "Status": "PASS",
                "StatusCode": "0",
                "TargetType": "CRS_HOME",
                "Type": "OS",
                "message": "Exadata Database Server GI software version meets requirement for rolling switch patching",
                "modelVersion": "21.2.0(dev)_20210622"
            }
        ],
        "hostname": "testhost1"
    }
]

tfactl queryindex -category result -from "2021-06-29 09:00:00" -to "2021-06-29 15:00:00" -target rdbms | python -m json.tool
[
    {
        "Result": [
            {
                "ActualValue": "0",
                "AlertType": "CRITICAL",
                "DBVersion": "112040",
                "EngineeredSystems": "Exadata",
                "ExadataVersion": "NULL",
                "ExecTimestamp": "2021-06-29 09:43:00 EDT",
                "ExpectedValue": "0",
                "HardwareType": "X4-2",
                "ID": "AA8C83A023362C5EE040E50A1EC0146A",
                "MsgDetail": "DATA FROM testhost - CDBM121 DATABASE - RECOVERY AND CREATE FILE DESTINATIONS//ndb_recovery_file_dest = +RECOC1//ndb_create_file_dest = +DATAC1//nDATA FROM BUSM01CLIENT01 - CDBM122 DATABASE - RECOVERY AND CREATE FILE DESTINATIONS//ndb_recovery_file_dest = +RECOC1//ndb_create_file_dest = +DATAC1//nDATA FROM BUSM01CLIENT01 - CDBM19C DATABASE - RECOVERY AND CREATE FILE DESTINATIONS//ndb_recovery_file_dest = +RECOC1//ndb_create_file_dest = +DATAC1//nDATA FROM BUSM01CLIENT01 - RAC11G DATABASE - RECOVERY AND CREATE FILE DESTINATIONS//ndb_recovery_file_dest = +RECOC1//ndb_create_file_dest = +DATAC1//nDATA FROM BUSM01CLIENT01 - RAC12C DATABASE - RECOVERY AND CREATE FILE DESTINATIONS//ndb_recovery_file_dest = +RECOC1//ndb_create_file_dest = +DATAC1//nDATA FROM BUSM01CLIENT01 - RAC1 DATABASE - RECOVERY AND CREATE FILE DESTINATIONS//ndb_recovery_file_dest = +RECOC1//ndb_create_file_dest = +DATAC1//nDATA FROM BUSM01CLIENT01 - SING11G DATABASE - RECOVERY AND CREATE FILE DESTINATIONS//ndb_recovery_file_dest = +RECOC1//ndb_create_file_dest = +DATAC1",
                "Name": "Recovery and Create File Destinations",
                "NodeName": "testhost.example.com",
                "OSVersion": "7",
                "Profile": "dba",
                "RackIdentifier": "Cluster-c1",
                "RackType": "N/A",
                "ReturnCode": "0",
                "Status": "PASS",
                "StatusCode": "0",
                "TargetType": "RDBMS",
                "Type": "OS",
                "message": "Database DB_CREATE_FILE_DEST and DB_RECOVERY_FILE_DEST are in different diskgroups",
                "modelVersion": "21.2.0(dev)_20210622"
            }
        ],
        "hostname": "testhost1"
    }
]

tfactl queryindex -category result -from "2021-06-29 09:00:00" -to "2021-06-29 15:00:00" -severity critical | python -m json.tool
[
    {
        "Result": [
            {
                "ActualValue": "1",
                "AlertType": "CRITICAL",
                "DBVersion": "112040",
                "EngineeredSystems": "Exadata",
                "ExadataVersion": "NULL",
                "ExecTimestamp": "2021-06-29 09:42:51 EDT",
                "ExpectedValue": "1",
                "HardwareType": "X4-2",
                "ID": "002331F422E014CAE05312C0E50AA2F3",
                "MsgDetail": "DATA FROM testhost - EXADATA DATABASE SERVER ROLLING SWITCH PATCHING MINIMUM GI SOFTWARE REQUIREMENT //n32240590;TOMCAT RELEASE UPDATE 19.0.0.0.0 (32240590)//n32222571;OCW Interim patch for 32222571//n32218663;ACFS RELEASE UPDATE 19.10.0.0.0 (32218663)//n32218454;Database Release Update :19.10.0.0.210119 (32218454)//n29340594;DBWLM RELEASE UPDATE 19.0.0.0.0 (29340594)//nOPatch succeeded.",
                "Name": "Exadata Database Server rolling switch patching minimum GI software requirement",
                "NodeName": "testhost.example.com",
                "OSVersion": "7",
                "Profile": "dba",
                "RackIdentifier": "Cluster-c1",
                "RackType": "N/A",
                "ReturnCode": "1",
                "Status": "PASS",
                "StatusCode": "0",
                "TargetType": "CRS_HOME",
                "Type": "OS",
                "message": "Exadata Database Server GI software version meets requirement for rolling switch patching",
                "modelVersion": "21.2.0(dev)_20210622"
            },
            {
                "ActualValue": "0",
                "AlertType": "CRITICAL",
                "DBVersion": "112040",
                "EngineeredSystems": "Exadata",
                "ExadataVersion": "NULL",
                "ExecTimestamp": "2021-06-29 09:43:00 EDT",
                "ExpectedValue": "0",
                "HardwareType": "X4-2",
                "ID": "AA8C83A023362C5EE040E50A1EC0146A",
                "MsgDetail": "DATA FROM testhost - CDBM121 DATABASE - RECOVERY AND CREATE FILE DESTINATIONS//ndb_recovery_file_dest = +RECOC1//ndb_create_file_dest = +DATAC1//nDATA FROM testhost - CDBM122 DATABASE - RECOVERY AND CREATE FILE DESTINATIONS//ndb_recovery_file_dest = +RECOC1//ndb_create_file_dest = +DATAC1//nDATA FROM testhost - CDBM19C DATABASE - RECOVERY AND CREATE FILE DESTINATIONS//ndb_recovery_file_dest = +RECOC1//ndb_create_file_dest = +DATAC1//nDATA FROM testhost - RAC11G DATABASE - RECOVERY AND CREATE FILE DESTINATIONS//ndb_recovery_file_dest = +RECOC1//ndb_create_file_dest = +DATAC1//nDATA FROM testhost - RAC12C DATABASE - RECOVERY AND CREATE FILE DESTINATIONS//ndb_recovery_file_dest = +RECOC1//ndb_create_file_dest = +DATAC1//nDATA FROM testhost - RAC1 DATABASE - RECOVERY AND CREATE FILE DESTINATIONS//ndb_recovery_file_dest = +RECOC1//ndb_create_file_dest = +DATAC1//nDATA FROM testhost - SING11G DATABASE - RECOVERY AND CREATE FILE DESTINATIONS//ndb_recovery_file_dest = +RECOC1//ndb_create_file_dest = +DATAC1",
                "Name": "Recovery and Create File Destinations",
                "NodeName": "testhost.example.com",
                "OSVersion": "7",
                "Profile": "dba",
                "RackIdentifier": "Cluster-c1",
                "RackType": "N/A",
                "ReturnCode": "0",
                "Status": "PASS",
                "StatusCode": "0",
                "TargetType": "RDBMS",
                "Type": "OS",
                "message": "Database DB_CREATE_FILE_DEST and DB_RECOVERY_FILE_DEST are in different diskgroups",
                "modelVersion": "21.2.0(dev)_20210622"
            }
        ],
        "hostname": "testhost1"
    }
]

tfactl queryindex -category result -from "2021-06-29 09:00:00" -to "2021-06-29 15:00:00" -name "Exadata" | python -m json.tool
[
    {
        "Result": [
            {
                "ActualValue": "1",
                "AlertType": "CRITICAL",
                "DBVersion": "112040",
                "EngineeredSystems": "Exadata",
                "ExadataVersion": "NULL",
                "ExecTimestamp": "2021-06-29 09:42:51 EDT",
                "ExpectedValue": "1",
                "HardwareType": "X4-2",
                "ID": "002331F422E014CAE05312C0E50AA2F3",
                "MsgDetail": "DATA FROM testhost - EXADATA DATABASE SERVER ROLLING SWITCH PATCHING MINIMUM GI SOFTWARE REQUIREMENT //n32240590;TOMCAT RELEASE UPDATE 19.0.0.0.0 (32240590)//n32222571;OCW Interim patch for 32222571//n32218663;ACFS RELEASE UPDATE 19.10.0.0.0 (32218663)//n32218454;Database Release Update :19.10.0.0.210119 (32218454)//n29340594;DBWLM RELEASE UPDATE 19.0.0.0.0 (29340594)//nOPatch succeeded.",
                "Name": "Exadata Database Server rolling switch patching minimum GI software requirement",
                "NodeName": "testhost.example.com",
                "OSVersion": "7",
                "Profile": "dba",
                "RackIdentifier": "Cluster-c1",
                "RackType": "N/A",
                "ReturnCode": "1",
                "Status": "PASS",
                "StatusCode": "0",
                "TargetType": "CRS_HOME",
                "Type": "OS",
                "message": "Exadata Database Server GI software version meets requirement for rolling switch patching",
                "modelVersion": "21.2.0(dev)_20210622"
            }
        ],
        "hostname": "testhost1"
    }
]

tfactl queryindex -category result -from "2021-06-29 09:00:00" -to "2021-06-29 15:00:00" -name "Recovery Destinations" | python -m json.tool
[
    {
        "Result": [
            {
                "ActualValue": "0",
                "AlertType": "CRITICAL",
                "DBVersion": "112040",
                "EngineeredSystems": "Exadata",
                "ExadataVersion": "NULL",
                "ExecTimestamp": "2021-06-29 09:43:00 EDT",
                "ExpectedValue": "0",
                "HardwareType": "X4-2",
                "ID": "AA8C83A023362C5EE040E50A1EC0146A",
                "MsgDetail": "DATA FROM testhost - CDBM121 DATABASE - RECOVERY AND CREATE FILE DESTINATIONS//ndb_recovery_file_dest = +RECOC1//ndb_create_file_dest = +DATAC1//nDATA FROM testhost - CDBM122 DATABASE - RECOVERY AND CREATE FILE DESTINATIONS//ndb_recovery_file_dest = +RECOC1//ndb_create_file_dest = +DATAC1//nDATA FROM testhost - CDBM19C DATABASE - RECOVERY AND CREATE FILE DESTINATIONS//ndb_recovery_file_dest = +RECOC1//ndb_create_file_dest = +DATAC1//nDATA FROM testhost - RAC11G DATABASE - RECOVERY AND CREATE FILE DESTINATIONS//ndb_recovery_file_dest = +RECOC1//ndb_create_file_dest = +DATAC1//nDATA FROM testhost - RAC12C DATABASE - RECOVERY AND CREATE FILE DESTINATIONS//ndb_recovery_file_dest = +RECOC1//ndb_create_file_dest = +DATAC1//nDATA FROM testhost - RAC1 DATABASE - RECOVERY AND CREATE FILE DESTINATIONS//ndb_recovery_file_dest = +RECOC1//ndb_create_file_dest = +DATAC1//nDATA FROM testhost - SING11G DATABASE - RECOVERY AND CREATE FILE DESTINATIONS//ndb_recovery_file_dest = +RECOC1//ndb_create_file_dest = +DATAC1",
                "Name": "Recovery and Create File Destinations",
                "NodeName": "testhost.example.com",
                "OSVersion": "7",
                "Profile": "dba",
                "RackIdentifier": "Cluster-c1",
                "RackType": "N/A",
                "ReturnCode": "0",
                "Status": "PASS",
                "StatusCode": "0",
                "TargetType": "RDBMS",
                "Type": "OS",
                "message": "Database DB_CREATE_FILE_DEST and DB_RECOVERY_FILE_DEST are in different diskgroups",
                "modelVersion": "21.2.0(dev)_20210622"
            }
        ],
        "hostname": "testhost1"
    }
]

tfactl queryindex -category result -from "2021-06-29 09:00:00" -to "2021-06-29 15:00:00" -fields ID | python -m json.tool[
    {
        "Result": [
            {
                "ID": "002331F422E014CAE05312C0E50AA2F3"
            },
            {
                "ID": "AA8C83A023362C5EE040E50A1EC0146A"
            }
        ],
        "hostname": "testhost1"
    }
]

tfactl queryindex -category result -from "2021-06-29 09:00:00" -to "2021-06-29 15:00:00" -fields all | python -m json.tool
[
    {
        "Result": [
            {
                "ActualValue": "1",
                "AlertType": "CRITICAL",
                "CoverageWindow.EndTime": "NULL",
                "CoverageWindow.StartTime": "NULL",
                "DBVersion": "112040",
                "EngineeredSystems": "Exadata",
                "ExadataVersion": "NULL",
                "ExecTimestamp": "2021-06-29 09:42:51 EDT",
                "ExpectedValue": "1",
                "HardwareType": "X4-2",
                "ID": "002331F422E014CAE05312C0E50AA2F3",
                "MsgDetail": "DATA FROM testhost - EXADATA DATABASE SERVER ROLLING SWITCH PATCHING MINIMUM GI SOFTWARE REQUIREMENT //n32240590;TOMCAT RELEASE UPDATE 19.0.0.0.0 (32240590)//n32222571;OCW Interim patch for 32222571//n32218663;ACFS RELEASE UPDATE 19.10.0.0.0 (32218663)//n32218454;Database Release Update :19.10.0.0.210119 (32218454)//n29340594;DBWLM RELEASE UPDATE 19.0.0.0.0 (29340594)//nOPatch succeeded.",
                "Name": "Exadata Database Server rolling switch patching minimum GI software requirement",
                "NodeName": "testhost.example.com",
                "OSVersion": "7",
                "Profile": "dba",
                "RackIdentifier": "Cluster-c1",
                "RackType": "N/A",
                "ReturnCode": "1",
                "Status": "PASS",
                "StatusCode": "0",
                "TargetType": "CRS_HOME",
                "Type": "OS",
                "data_type": "compliance_result",
                "message": "Exadata Database Server GI software version meets requirement for rolling switch patching",
                "modelVersion": "21.2.0(dev)_20210622",
                "timestamp": "20210629134251000",
                "user": "root"
            },
            {
                "ActualValue": "0",
                "AlertType": "CRITICAL",
                "CoverageWindow.EndTime": "NULL",
                "CoverageWindow.StartTime": "NULL",
                "DBName": "cdbm121",
                "DBVersion": "112040",
                "EngineeredSystems": "Exadata",
                "ExadataVersion": "NULL",
                "ExecTimestamp": "2021-06-29 09:43:00 EDT",
                "ExpectedValue": "0",
                "HardwareType": "X4-2",
                "ID": "AA8C83A023362C5EE040E50A1EC0146A",
                "InstanceName": "cdbm1211",
                "InstanceType": "CDB",
                "MsgDetail": "DATA FROM testhost - CDBM121 DATABASE - RECOVERY AND CREATE FILE DESTINATIONS//ndb_recovery_file_dest = +RECOC1//ndb_create_file_dest = +DATAC1//nDATA FROM testhost - CDBM122 DATABASE - RECOVERY AND CREATE FILE DESTINATIONS//ndb_recovery_file_dest = +RECOC1//ndb_create_file_dest = +DATAC1//nDATA FROM testhost - CDBM19C DATABASE - RECOVERY AND CREATE FILE DESTINATIONS//ndb_recovery_file_dest = +RECOC1//ndb_create_file_dest = +DATAC1//nDATA FROM testhost - RAC11G DATABASE - RECOVERY AND CREATE FILE DESTINATIONS//ndb_recovery_file_dest = +RECOC1//ndb_create_file_dest = +DATAC1//nDATA FROM testhost - RAC12C DATABASE - RECOVERY AND CREATE FILE DESTINATIONS//ndb_recovery_file_dest = +RECOC1//ndb_create_file_dest = +DATAC1//nDATA FROM testhost - RAC1 DATABASE - RECOVERY AND CREATE FILE DESTINATIONS//ndb_recovery_file_dest = +RECOC1//ndb_create_file_dest = +DATAC1//nDATA FROM testhost - SING11G DATABASE - RECOVERY AND CREATE FILE DESTINATIONS//ndb_recovery_file_dest = +RECOC1//ndb_create_file_dest = +DATAC1",
                "Name": "Recovery and Create File Destinations",
                "NodeName": "testhost.example.com",
                "OSVersion": "7",
                "Profile": "dba",
                "RackIdentifier": "Cluster-c1",
                "RackType": "N/A",
                "ReturnCode": "0",
                "Status": "PASS",
                "StatusCode": "0",
                "TargetType": "RDBMS",
                "Type": "OS",
                "data_type": "compliance_result",
                "message": "Database DB_CREATE_FILE_DEST and DB_RECOVERY_FILE_DEST are in different diskgroups",
                "modelVersion": "21.2.0(dev)_20210622",
                "timestamp": "20210629134300000",
                "user": "root"
            }
        ],
        "hostname": "testhost1"
    }
]

親トピック: Oracle Trace File Analyzer管理コマンドの実行