Introduction oakcli stands for Oracle Appliance Kit Command Line Interface. oakcli utility is used to manage Oracle Database Applaince. It used to carry out management tasks such as, Deploying, Patching, validating, monitoring, troubleshooting, Create Database, Create database homes, Configuring core key, manage Virtual machines and so on. oakcli utility is located under the direcoty /opt/oracle/oak/bin/oakcli oakcli logs oakcli commands output under the directory /opt/oracle/oak/log/<hostname>/client/oakcli.log Few things that you can do with oakcli but not limited to are:
Deploy Oracle Database Appliance
Configure network for Oracle Database Appliance deployment
Patching Oracle Database Appliance
Unpacking packages into oakcli repository
Troubleshoot Oracle Database Appliance
Monitor Oracle Database Appliance
Validate Oracle Database Appliance
Applying the Core Configuration key
Copying the deployment configuration file
Locate a disk on ODA
Manage ODA Repository
Manage ODA diagnostics collection
Execute the oakcli -h command to list the different options available with oakcli: [root@odanode1 ~]# oakcli -h Usage: oakcli show – Shows disk, diskgroup, expander, controller, server, processor, memory, power, cooling, network, enclosure, storage, version, fs, raidsyncstatus, dbhomes, dbstorage, databases, db_config_params, core_config_key, env_hw, ASR oakcli configure – Configures the Network or ASR or additional Net oakcli apply – Applies the core_config_key oakcli locate – Locates a disk oakcli deploy – Deploys the Database Appliance oakcli update – Updates the Database Appliance oakcli validate – Validates the Database Appliance oakcli manage – Manages the OAK repository, diagcollect etc., oakcli unpack – Unpack the given package to OAK repository oakcli copy – Copies the deployment config file oakcli upgrade – Upgrades database oakcli stordiag – Run storage diagnostic tool on both Nodes oakcli test – Test ASR oakcli orachk – Performs configuration settings check on ODA oakcli create – Creates Database, DB storage, snapshotdb, dbhome, db_config_params file oakcli delete – Deletes Database, DB storage, dbhome, db_config_params file oakcli modify – Performs modify opeartions on Database oakcli resize – Resizes DB storage Commonly used Oracle Database Appliance Commands used on daily basis and their Output
Execute the following command to list all the options that can be used with oakcli show
[root@odanode1 ~]# oakcli show -h Usage: oakcli show {disk|diskgroup|expander|fs|raidsyncstatus|controller|server|processor|memory|iraid|power|cooling|network|ib|enclosure|storage|core_config_key|version|dbhomes|dbstorage|databases|db_config_params|asr|env_hw} [<options>] where: disk – About the disk diskgroup – ASM disk group expander – Expander fs – Filesystem controller – Controller storage – All storage components version – Running software version dbhomes – Installed oracle database homes dbstorage – Details of ACFS storage setup for the databases databases – Database names db_config_params – db_config_params file asr – ASR configuration env_hw – Environment and Hardware information server – Details of server sub-system processor – Details of processor sub-system memory – Details of memory sub-system iraid – Details of internal RAIDs sub-system power – Details of power supply sub-system cooling – Details of cooling sub-system network – Details of network sub-system ib – Details of infiniband sub-system enclosure – Details of enclosure sub-system raidsyncstatus – RAID sync status information core_config_key – Core configuration For detailed help on each command and object and its options use: oakcli <command> <object> -h
To check if whether ODA deployment is Bare Metal or Virtualized
[root@odanode1 ~]# oakcli show env_hw BM ODA X5-2 Public interface : COPPER or [root@odanode1 ~]# lsmod |grep net ( If no reply, It means the ODA is Bare Metal)
To get the ODA software version
[root@odanode1 ~]# oakcli show version Version ——- 12.1.2.9.0
To get the ODA software and component version
[root@odanode1 ~]# /opt/oracle/oak/bin/oakcli show version -detail Reading the metadata. It takes a while… System Version Component Name Installed Version Supported Version ————– ————— —————— —————– 12.1.2.10.0 Controller_INT 11.05.03.00 Up-to-date Controller_EXT 11.05.03.00 Up-to-date Expander 0018 Up-to-date SSD_SHARED 944A Up-to-date HDD_LOCAL A72A Up-to-date HDD_SHARED A72A Up-to-date ILOM 3.2.8.25 r114493 Up-to-date BIOS 25040100 Up-to-date IPMI 1.8.12.4 Up-to-date HMP 2.3.5.2.8 Up-to-date OAK 12.1.2.10.0 Up-to-date OL 6.8 Up-to-date GI_HOME 12.1.0.2.170117(2473 Up-to-date 2082,24828633) DB_HOME 12.1.0.2.170117(2473 Up-to-date 2082,24828633)
To list the shared disks on ODA
[root@odanode1 ~]# oakcli show disk NAME PATH TYPE STATE STATE_DETAILS e0_pd_00 /dev/sda HDD ONLINE Good e0_pd_01 /dev/sdc HDD ONLINE Good e0_pd_02 /dev/sde HDD ONLINE Good e0_pd_03 /dev/sdg HDD ONLINE Good e0_pd_04 /dev/sdi HDD ONLINE Good e0_pd_05 /dev/sdk HDD ONLINE Good e0_pd_06 /dev/sdm HDD ONLINE Good e0_pd_07 /dev/sdo HDD ONLINE Good e0_pd_08 /dev/sdq HDD ONLINE Good e0_pd_09 /dev/sds HDD ONLINE Good e0_pd_10 /dev/sdu HDD ONLINE Good e0_pd_11 /dev/sdw HDD ONLINE Good e0_pd_12 /dev/sdy HDD ONLINE Good e0_pd_13 /dev/sdaa HDD ONLINE Good e0_pd_14 /dev/sdac HDD ONLINE Good e0_pd_15 /dev/sdae HDD ONLINE Good e0_pd_16 /dev/sdag SSD ONLINE Good e0_pd_17 /dev/sdah SSD ONLINE Good e0_pd_18 /dev/sdaj SSD ONLINE Good e0_pd_19 /dev/sdal SSD ONLINE Good e0_pd_20 /dev/sdan SSD ONLINE Good e0_pd_21 /dev/sdap SSD ONLINE Good e0_pd_22 /dev/sdas SSD ONLINE Good e0_pd_23 /dev/sdau SSD ONLINE Good
To list ASM disk groups on ODA
[root@odanode1 ~]# oakcli show diskgroup DiskGroups ———- DATA FLASH RECO REDO
To list the Local file system and ACFS file system on ODA
[root@odanode1 ~]# oakcli show dbhomes Oracle Home Name Oracle Home version Home Location —————- ——————- ———— OraDb12102_home1 2.1.0.2.170117(24732082,24828633) /u01/app/oracle/product/12.1.0.2/dbhome_1
To list database storage on ODA
[root@odanode1 ~]# oakcli show dbstorage All the DBs with DB TYPE as non-CDB share the same volumes DB_NAMES DB_TYPE Filesystem Size Used Available AutoExtend Size DiskGroup ——- ——- ———— —— —– ——— —————- ——– odatest CDB /u01/app/oracle/oradata/EC00001 1.5G 0.45G 1.05G 1G REDO /u02/app/oracle/oradata/EC00001 50G 12.24G 37.76G 1G DATA /u01/app/oracle/fast_recovery_area/EC00001 5G 1.63G 3.37G 1G RECO odaprod non-CDB /u01/app/oracle/oradata/datastore 25G 11.83G 13.17G N/A REDO /u02/app/oracle/oradata/datastore 600G 113.54G 486.46G N/A DATA /u02/app/oracle/oradata/flashdata 111.25G 1.22G 110.03G 55G FLASH /u01/app/oracle/fast_recovery_area/datastore 1925G 46.93G 1878.07G 194G RECO odadev CDB /u01/app/oracle/oradata/EC00002 1.5G 0.08G 1.42G 1G REDO /u02/app/oracle/oradata/EC00003 50G 0.17G 49.83G 1G DATA /u01/app/oracle/fast_recovery_area/EC00003 5G 0.08G 4.92G 1G RECO odaqa CDB /u01/app/oracle/oradata/EC00002 1.5G 0.08G 1.42G 1G REDO /u02/app/oracle/oradata/EC00002 50G 0.17G 49.83G 1G DATA /u01/app/oracle/fast_recovery_area/EC00002 5G 0.08G 4.92G 1G RECO
To list databases on ODA
[root@odanode1 ~]# oakcli show databases Name Type Storage HomeName HomeLocation Version —– —— ——– ————– —————- ———- odaprod RAC ACFS OraDb12102_home1 /u01/app/oracle/product/12.1.0.2/dbhome_1 12.1.0.2.170117(24732082,24828633)
To list the database configuration parameter files on ODA
[root@odanode1 ~]# oakcli show db_config_params The available DB configuration files are : acfsoemrepo default orcl
To list ASR status on ODA
[root@odanode1 ~]# oakcli show asr The ASR is not configured
To check the ODA servers details
[root@odanode1 ~]# oakcli show server Power State : On Open Problems : 0 Model : ODA X5-2 Type : Rack Mount Part Number : 33772477+1+1 Serial Number : 1942NMF001 Primary OS : Not Available ILOM Address : 14.68.20.101 ILOM MAC Address : 00:10:E0:8D:B3:FC Description : Oracle Database Appliance X5-2 1535NMF00K Locator Light : Off Actual Power Consumption : 363 watts Ambient Temperature : 27.750 degree C Open Problems Report : System is healthy
To list Processor on ODA
[root@odanode1 ~]# oakcli show processor NAME HEALTH HEALTH_DETAILS PART_NO. LOCATION MODEL MAX_CLK_SPEED TOTAL_CORES CPU_0 OK – 060F P0 (CPU 0) Intel(R) Xeon(R) CPU E5-2699 2.300 GHz 18 CPU_1 OK – 060F P1 (CPU 1) Intel(R) Xeon(R) CPU E5-2699 2.300 GHz 18
[root@odanode1 ~]# oakcli show power NAME HEALTH HEALTH_DETAILS PART_NO. SERIAL_NO. LOCATION INPUT_POWER OUTPUT_POWER INLET_TEMP EXHAUST_TEMP Power_Supply_0 OK – 7079395 476856Z+1524CE007B PS0 Present 167 watts 35.000 degree C 37.125 degree C Power_Supply_1 OK – 7079395 476856Z+1524CE007V PS1 Present 163 watts 35.000 degree C 40.125 degree C
To check FAN status on ODA
[root@odanode1 ~]# oakcli show cooling NAME HEALTH HEALTH_DETAILS LOCATION FAN % FAN SPEED Fan_0 OK – FM0 40 % 7800 RPM Fan_1 OK – FM0 38 % 6600 RPM Fan_10 OK – FM2 47 % 9200 RPM Fan_11 OK – FM2 48 % 8300 RPM Fan_12 OK – FM3 48 % 9300 RPM Fan_13 OK – FM3 46 % 8000 RPM Fan_14 OK – FM3 39 % 7600 RPM Fan_15 OK – FM3 39 % 6800 RPM Fan_2 OK – FM0 64 % 12300 RP Fan_3 OK – FM0 60 % 10400 RP Fan_4 OK – FM1 63 % 12200 RP Fan_5 OK – FM1 59 % 10200 RP Fan_6 OK – FM1 36 % 7000 RPM Fan_7 OK – FM1 34 % 6000 RPM Fan_8 OK – FM2 36 % 7000 RPM Fan_9 OK – FM2 35 % 6100 RPM
To check network status on ODA
[root@odanode1 ~]# oakcli show network Gathering Statistics…
To check IB interface on ODA
[root@odanode1 ~]# oakcli show ib Infiniband is not present in the system
To check ODA servers enclosure
[root@odanode1 ~]# oakcli show enclosure NAME SUBSYSTEM STATUS METRIC E0_FAN0 Cooling Not install 0 rpm E0_FAN1 Cooling Not install 0 rpm E0_FAN2 Cooling OK 3450 rpm E0_FAN3 Cooling OK 3070 rpm E0_FAN4 Cooling OK 3750 rpm E0_FAN5 Cooling OK 3070 rpm E0_FAN6 Cooling Not install 0 rpm E0_FAN7 Cooling Not install 0 rpm E0_IOM0 Encl_Electronics OK – E0_IOM1 Encl_Electronics OK – E0_PSU0 Power_Supply Not install – E0_PSU1 Power_Supply OK – E0_PSU2 Power_Supply OK – E0_PSU3 Power_Supply Not install – E0_TEMP0 Amb_Temp OK 30 C E0_TEMP1 Midplane_Temp OK 35 C E0_TEMP2 PCM0_Inlet_Temp OK 41 C E0_TEMP3 PCM0_Hotspot_Temp OK 50 C E0_TEMP4 PCM1_Inlet_Temp OK 35 C E0_TEMP5 PCM1_Hotspot_Temp OK 45 C E0_TEMP6 IOM0_Temp OK 52 C E0_TEMP7 IOM1_Temp OK 43 C
To check RAID sync status
[root@odanode1 ~]# oakcli show raidsyncstatus Raid Type Raid Device Raid Status maintainPdFailHistory Rebuildrate H/W Raid /dev/sdaw Optimal OFF 30%
To check CPU core configuration key file applied on ODA
[root@odanode1 ~]# oakcli show core_config_key Optional core config key is not applied on the machine yet!
[root@odanode1 ~]#oakcli unpack -package p25499210_1212100_Linux_x86-64_1of2.zip Unpacking will take some time , Please wait… Successfully unpacked the files to repository.
Conclusion In this article we have learned about oackcli utility and few ODA commands used on daily basis. oakcli stands for Oracle Appliance Kit Command Line Interface. oakcli utility is used to manage Oracle Database Applaince. It used to carry out management tasks such as, Deploying, Patching, validating, monitoring, troubleshooting, Create Database, Create database homes, Configuring core key, manage Virtual machines and so on.