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

 

No comments:

Post a Comment