Various odacli commands for ODA

[root@oda02 ~]# odaadmcli show env_hw

BM ODA X7-2 Medium

[root@hkoda02 ~]# fwupdate list disk

 ================================================== 

CONTROLLER 

================================================== 

ID    Type   Manufacturer   Model     Product Name              FW Version     BIOS Version   EFI Version    FCODE Version  Package Version  NVDATA Version    XML Support

 ————————————————————————————————————————————————————————–

c0    HDC    Intel          0xa182    0x4866                    –              –              –              –              –                –                 N/A

DISKS

 ===============

 ID        Manufacturer   Model               ATA Model                     Chassis Slot   Type   Media   Size(GiB) FW Version ATA FW Ver XML Support

—————————————————————————————————————————————————-

c0d0      INTEL          SSDSGFTG480G7       INTEL_SSDSCKJB874G7           –       1      sata   SSD     447       0121       N2010121   N/A

c0d1      INTEL          SSDSGFTG480G7       INTEL_SSDSCKJB874G7           –       –      sata   SSD     447       0121       N2010121   N/A

[root@oda02 ~]# odaadmcli show server

 Power State              : On

Open Problems            : 0

  Model                    : ODA X7-2M

Type                     : Rack Mount

  Part Number              : ODA X7-2M

  Serial Number            : 19355THJ026

Primary OS               : Not Available

ILOM Address             : 172.10.38.191

 ILOM MAC Address         : 00:B0:E0:F9:12:F6

Description              : Oracle Database Appliance X7-2 Medium 19355THJ026

 Locator Light            : Off

Actual Power Consumption : 256 watts

Ambient Temperature      : 23.250 degree C

Open Problems Report     : System is healthy

[root@hkoda02 ~]# odacli describe-component

 System Version 

—————

 19.15.0.0.0

System node Name

 —————

 oda02

Local System Version

————— 

19.15.0.0.0

Component                                Installed Version    Available Version

 —————————————- ——————– ——————-

 OAK

                                             19.15.0.0.0           up-to-date

 GI

                                             19.15.0.0.220419      up-to-date

 DB {

 [OraDB12102_home1]

                                             12.1.0.2.190716       12.1.0.2.220419

 [OraDB12102_home2]

                                           12.1.0.2.220419       up-to-date

 [OraDB19000_home1]

                                             19.15.0.0.220419      up-to-date

 }

 DCSCONTROLLER

                                             19.15.0.0.0           up-to-date

 DCSCLI

                                             19.15.0.0.0           up-to-date

 DCSAGENT

                                             19.15.0.0.0           up-to-date

 DCSADMIN

                                             19.15.0.0.0           up-to-date

 OS

                                             7.9                   up-to-date

 ILOM

                                             5.0.2.24.r141466      up-to-date

 BIOS

                                             41100500              up-to-date

 LOCAL CONTROLLER FIRMWARE {

 [c6]

                                             80000690              80000681

 [c7]

                                             214.2.271.9           up-to-date

 }

 SHARED CONTROLLER FIRMWARE {

 [c1,c2]

                                             QDV1RF32              up-to-date

 [c3,c4,c5]

                                             VDV1RL04              up-to-date

 }

 LOCAL DISK FIRMWARE

                                             0121                  up-to-date

 SHARED DISK FIRMWARE

                                             0121                  up-to-date

 HMP

                                             2.4.8.0.601           up-to-date

[root@oda02 ~]# odacli describe-dbsystem-image

DB System Image details

 ——————————————————————————–

 Component Name        Supported Versions    Available Versions

 ——————–  ——————–  ——————–

DBVM                  19.15.0.0.0           not-available

GI                    19.15.0.0.220419      19.15.0.0.220419

                      19.14.0.0.220118      not-available

                      19.13.0.0.211019      not-available

                      19.12.0.0.210720      not-available

                      19.11.0.0.210420      not-available

                      21.6.0.0.220419       not-available

                      21.5.0.0.220118       not-available

                      21.4.0.0.211019       not-available

                      21.3.0.0.210720       not-available

DB                    19.15.0.0.220419      19.15.0.0.220419

                      19.14.0.0.220118      not-available

                      19.13.0.0.211019      not-available

                      19.12.0.0.210720      not-available

                      19.11.0.0.210420      not-available

                      21.6.0.0.220419       not-available

                      21.5.0.0.220118       not-available

                      21.4.0.0.211019       not-available

                      21.3.0.0.210720       not-available

[root@oda02 ~]# odaadmcli show fs

      Type     Total Space      Free Space  Total DG Space   Free DG Space  Diskgroup Mount Point

      acfs           5120M           4801M       24419840M        9252364M       DATA /opt/oracle/dcs/commonstore

      acfs         153600M         118108M       24419840M        9252364M       DATA /opt/oracle/oak/pkgrepos/orapkgs/clones

      acfs          10240M           8409M       24419840M        9252364M       DATA /u01/app/odaorabase0

      acfs          81920M          30011M       24419840M        9252364M       DATA /u01/app/odaorahome

[root@oda02 ~]# odacli list-jobs

ID                                       Description                                                                 Created                             Status

—————————————- ————————————————————————— ———————————– ———-

7d552349-af92-4bb0-833e-f19168bef783     Repository Update                                                           July 27, 2022 5:59:25 AM HKT        Success

9e4d4405-805a-4449-973a-ded6983a060a     Repository Update                                                           July 27, 2022 6:58:53 AM HKT        Success

5441d731-b434-4158-bc04-e16ae988b134     Repository Update                                                           July 27, 2022 7:16:46 AM HKT        Success

fee90149-bd73-49a6-bb06-62a34534cb25     User creation(oda-admin)                                                    July 27, 2022 7:24:22 AM HKT        Success

4675f8d7-6a4e-48d7-9434-ba0701600499     Restore node service – GI                                                   July 27, 2022 7:24:24 AM HKT        Success

f6da68f6-cff2-4b67-b1f2-d835f304c35c     Configure database home storage                                             July 27, 2022 4:48:29 PM HKT        Success

f1e7229c-1286-418a-8657-66b049dfbb13     Restore node service – Database                                             July 27, 2022 4:52:40 PM HKT        Created

27ccad9f-df93-4ac3-8e2d-3430c132ee2e     Repository Update                                                           July 27, 2022 7:17:01 PM HKT        Success

6b5f2338-cf2d-40cb-8991-7accd3733aec     Restore node service – Database                                             July 27, 2022 7:21:53 PM HKT        Success

348df102-50c8-4e12-b8b0-c997a2af065f     Database Home OraDB12102_home2 creation with version :12.1.0.2.220419       August 2, 2022 3:03:33 PM HKT       Success

e9972ef8-86d1-4459-addc-2d46ff4352f3     Repository Update                                                           November 7, 2022 4:34:43 PM HKT     Created

abf6f3b0-3470-4490-95c6-66190ae32628     Repository Update                                                           November 7, 2022 5:15:10 PM HKT     Success

dd5beffe-388b-4d8c-bc3b-18370c9c8293     Database Home OraDB19000_home1 creation with version :19.15.0.0.220419      November 7, 2022 5:42:05 PM HKT     Success

[root@oda02 ~]# odacli list-availablepatches

——————– ————————- ————————- ——————————

ODA Release Version  Supported DB Versions     Available DB Versions     Supported Platforms

——————– ————————- ————————- ——————————

19.15.0.0.0          21.6.0.0.220419           Clone not available       DB System

                     19.15.0.0.220419          19.15.0.0.220419          Bare Metal, DB System

                     12.1.0.2.220419           12.1.0.2.220419           Bare Metal

 [root@oda02 ~]# odacli list-dbhome-storages

=============================================================================================================

ID                                     Node Description          Disk Group Volume      Size(GB)   Status

————————————– —- ——————– ———- ———– ———- ———-

040561b1-40c4-4fb1-8cb2-409e2898279e   0    ORACLE_HOME          DATA       orahome_sh  80         CONFIGURED

cb698aed-544e-407d-b5e2-a4e12a72ad71   0    ORACLE_BASE          DATA       odabase_n0  10         CONFIGURED

=============================================================================================================

[root@oda02 ~]# odacli list-dbhomes

ID                                       Name                 DB Version                               Home Location                                 Status

—————————————- ——————– —————————————- ——————————————— ———-

a051cc7b-e678-44bc-be26-b03bda48c413     OraDB12102_home1     12.1.0.2.190716                          /u01/app/odaorahome/oracle/product/12.1.0.2/dbhome_1 CONFIGURED

f12ae9fd-165d-4550-bb0f-ef8f89a828b9     OraDB12102_home2     12.1.0.2.220419                          /u01/app/odaorahome/oracle/product/12.1.0.2/dbhome_2 CONFIGURED

e91973c3-b7b2-41df-a2b5-a80e8fca408c     OraDB19000_home1     19.15.0.0.220419                         /u01/app/odaorahome/oracle/product/19.0.0.0/dbhome_1 CONFIGURED

[root@oda02 ~]# odaadmcli show disk

        NAME            PATH            TYPE            STATE           STATE_DETAILS 

        pd_00           /dev/nvme0n1    NVD             ONLINE          Good

        pd_01           /dev/nvme1n1    NVD             ONLINE          Good

        pd_02           /dev/nvme4n1    NVD             ONLINE          Good

        pd_03           /dev/nvme3n1    NVD             ONLINE          Good

        pd_04           /dev/nvme2n1    NVD             ONLINE          Good

[root@oda02 ~]# odacli list-dgstorages

DiskGroup  Redundancy Physical Total Space Physical Reserved Space Physical Free Space  Logical Free Space

———- ———- ——————– ———————– ——————– —————— 

DATA       NORMAL     23.28 TB             3.49 TB                 8.82 TB              4.41 TB

RECO       NORMAL     5.82 TB              894.0 GB                4.29 TB              2.14 TB

[root@oda02 ~]# odacli list-dbhome-storages

=============================================================================================================

ID                                     Node Description          Disk Group Volume      Size(GB)   Status

————————————– —- ——————– ———- ———– ———- ———-

040561b1-40c4-4fb1-8cb2-409e2898279e   0    ORACLE_HOME          DATA       orahome_sh  80         CONFIGURED

cb698aed-544e-407d-b5e2-a4e12a72ad71   0    ORACLE_BASE          DATA       odabase_n0  10         CONFIGURED

=============================================================================================================

[root@oda02 ~]# odacli describe-cpucore

Node  Cores  Modified                           Job Status

—– —— ———————————- —————

0     10     July 27, 2022 7:46:41 AM HKT       CONFIGURED

[root@hkoda02 ~]# odacli describe-system -b


Categories

Leave a Reply

Your email address will not be published. Required fields are marked *