O OAKCLI (Oracle Appliance Kit Command Line Interface) é uma interface de linha de comando para gerenciamento do Oracle Database Appliance (ODA) utilizada para execução de tarefas como, aplicação de patches, gerenciamento de maquinas virtuais, criação de databases, configuração de core keys, diagnostico de hardware, etc.
O "executável" fica localizado no diretório /opt/oracle/oak/bin/oakcli, sendo que o usuário root deve ter a variável de ambiente ORA_OAK_HOME definida com este diretório base (/opt/oracle/oak). Vale destacar que para ter permissão para executar todas as funcionalidades, é preciso que a execução seja realizada com o usuário root.
Dependendo da versão do Oracle Appliance Manager e do Hardware utilizado, alguns comandos do oakcli podem não estar disponíveis ou mesmo, podem apresentar mais opções. Para verificar as opções disponíveis para execução do oakcli podemos executar um oakcli -h e ou oakcli show -h.
[root@ODA_TST01 ~]# oakcli -h
Usage: oakcli show - show disk, diskgroup, expander, controller, storage, version, fs, raidsyncstatus, dbhomes, dbstorage, databases, db_config_params, core_config_key, env_hw, asr
oakcli configure - configures the network or asr or additionalnet
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 e.t.c
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 node
oakcli test - test asr
oakcli orachk - performs configuration settings check on ODA
oakcli create - creates database, dbstorage, snapshotdb, dbhome, db_config_params file
oakcli delete - deletes database, dbstorage, dbhome, db_config_params file
oakcli resize - resizes dbstorage
[root@ODA_TST01 ~]#
[root@ODA_TST01 ~]# oakcli show -h
Usage:
oakcli show {disk|diskgroup|expander|fs|raidsyncstatus|controller|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
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
Vale lembrar que, sempre que existir uma duvida quando a sintaxe utiliza, podemos e devems utilizar o comando help, que nos mostrara as "opções" disponíveis para cada comando. Por exemplo, precisamos realizar o diagnostico de um disco especifico e não lembramos a sintaxe do comando. Abaixo não será mostrado todo o resultado do comando devido ao seu temanho.
[root@ODA_TST01 ~]# oakcli stordiag -h
Usage:
oakcli stordiag -h | n
-h : Help Message
n : oakd disk resource name
resource name format : pd_[0..23]
[root@ODA_TST01 ~]#
[root@ODA_TST01 ~]# oakcli stordiag pd_01
Node Name : ODA_TST01
Test : Diagnostic Test Description
1 : OAK Check
NAME PATH TYPE STATE STATE_DETAILS
pd_01 /dev/sdm HDD ONLINE Good
2 : ASM Check
ASM Disk Status : group_number state mode_s mount_s header_s
/dev/mapper/HDD_E0_S01_1199124347p2 : 2 NORMAL ONLINE CACHED MEMBER
/dev/mapper/HDD_E0_S01_1199124347p1 : 1 NORMAL ONLINE CACHED MEMBER
3 : Multipathd Status
multipathd running on system
.
.
.
Também podemos listar todos os discos existentes através do comando show disk, podemos listar os discos de um diskgroup específico com o comando show diskgroup.
[root@ODA_TST01 ~]# oakcli show disk
NAME PATH TYPE STATE STATE_DETAILS
pd_00 /dev/sdc HDD ONLINE Good
pd_01 /dev/sdm HDD ONLINE Good
pd_02 /dev/sdo HDD ONLINE Good
pd_03 /dev/sdy HDD ONLINE Good
pd_04 /dev/sdd HDD ONLINE Good
pd_05 /dev/sdn HDD ONLINE Good
pd_06 /dev/sdp HDD ONLINE Good
pd_07 /dev/sdz HDD ONLINE Good
pd_08 /dev/sde HDD ONLINE Good
pd_09 /dev/sdk HDD ONLINE Good
pd_10 /dev/sdq HDD ONLINE Good
pd_11 /dev/sdw HDD ONLINE Good
pd_12 /dev/sdf HDD ONLINE Good
pd_13 /dev/sdl HDD ONLINE Good
pd_14 /dev/sdr HDD ONLINE Good
pd_15 /dev/sdx HDD ONLINE Good
pd_16 /dev/sdg HDD ONLINE Good
pd_17 /dev/sdi HDD ONLINE Good
pd_18 /dev/sds HDD ONLINE Good
pd_19 /dev/sdu HDD ONLINE Good
pd_20 /dev/sdh SSD ONLINE Good
pd_21 /dev/sdj SSD ONLINE Good
pd_22 /dev/sdt SSD ONLINE Good
pd_23 /dev/sdv SSD ONLINE Good
[root@ODA_TST01 ~]# oakcli show diskgroup
DiskGroups
----------
DATA
RECO
REDO
[root@ODA_TST01 ~]# oakcli show diskgroup RECO
ASM_DISK PATH DISK STATE STATE_DETAILS
reco_00 /dev/mapper/HDD_E0_S00_1199244847p2 pd_00 ONLINE Good
reco_01 /dev/mapper/HDD_E0_S01_1199124347p2 pd_01 ONLINE Good
reco_02 /dev/mapper/HDD_E1_S02_1095363320p2 pd_02 ONLINE Good
reco_03 /dev/mapper/HDD_E1_S03_682322803p2 pd_03 ONLINE Good
reco_04 /dev/mapper/HDD_E0_S04_1199114147p2 pd_04 ONLINE Good
reco_05 /dev/mapper/HDD_E0_S05_1199254039p2 pd_05 ONLINE Good
reco_06 /dev/mapper/HDD_E1_S06_1199134763p2 pd_06 ONLINE Good
reco_07 /dev/mapper/HDD_E1_S07_1199106347p2 pd_07 ONLINE Good
reco_08 /dev/mapper/HDD_E0_S08_1199225207p2 pd_08 ONLINE Good
reco_09 /dev/mapper/HDD_E0_S09_1199241551p2 pd_09 ONLINE Good
reco_10 /dev/mapper/HDD_E1_S10_1199105123p2 pd_10 ONLINE Good
reco_11 /dev/mapper/HDD_E1_S11_1199117223p2 pd_11 ONLINE Good
reco_12 /dev/mapper/HDD_E0_S12_497670107p2 pd_12 ONLINE Good
reco_13 /dev/mapper/HDD_E0_S13_1199226407p2 pd_13 ONLINE Good
reco_14 /dev/mapper/HDD_E1_S14_1199226287p2 pd_14 ONLINE Good
reco_15 /dev/mapper/HDD_E1_S15_1199248043p2 pd_15 ONLINE Good
reco_16 /dev/mapper/HDD_E0_S16_1199132243p2 pd_16 ONLINE Good
reco_17 /dev/mapper/HDD_E0_S17_1199118199p2 pd_17 ONLINE Good
reco_18 /dev/mapper/HDD_E1_S18_1199118299p2 pd_18 ONLINE Good
reco_19 /dev/mapper/HDD_E1_S19_1199108523p2 pd_19 ONLINE Good
[root@ODA_TST01 ~]#
Podemos também ativar ou desativar o LED de identificação de um disco (LED amarelo). Este comando pode ser bastante util quando existir a necessidade de substituição de um disco com problemas, caso o mesmo não tenha sido identificado automaticamente.[root@ODA_TST01 ~]# oakcli locate pd_01
Usage:
oakcli locate disk <diskname> <on | off>
where:
on - turns on the LED of the given disk
off - turns off the LED of the given disk
[root@ODA_TST01 ~]#
Utilizando o show version, podemos facilmente consultar a versão atual do software e firmware do ODA.[root@ODA_TST01 ~]# oakcli show version Version ------- 12.1.2.4.0 [root@ODA_TST01 ~]#
É possível validar se a core_config_key está aplicada e qual os valores definidos (serial, cores, hardware, etc)
root@ODA_TST01 ~]# oakcli show core_config_key Host's serialnumber = ---------- Enabled Cores (per server) = 4 Total Enabled Cores (on two servers) = 8 Server type = V1 -> SUN FIRE X4370 M2 Hyperthreading is enabled. Each core has 2 threads. Operating system displays 8 processors per server
O comando show databases nos mostra as informações dos database existentes.
[root@ODA_TST01 ~]# oakcli show databases Name Type Storage HomeName HomeLocation Version ----- ------ -------- -------------- ---------------- ---------- lamimtst1 RAC ACFS OraDb11204_home1 /u01/app/oracle/product/11.2.0.4/dbhome_1 11.2.0.4.7(20760982,20831122) [root@ODA_TST01 ~]#Para verificar as informações do storage, usamos o comando show storage.
[root@ODA_TST01 ~]# oakcli show storage
==== BEGIN STORAGE DUMP ========
Host Description: ORACLE CORPORATION:SUN FIRE X4370 M2 SERVER
Total number of controllers: 2
Id = 0
Serial Num = --------
Vendor = LSI Logic
Model = SGX-SAS6-INT-Z
FwVers = 11.05.03.00
strId = mpt2sas:0d:00.0
Id = 1
Serial Num = --------
Vendor = LSI Logic
Model = SGX-SAS6-INT-Z
FwVers = 11.05.03.00
strId = mpt2sas:1f:00.0
Total number of expanders: 2
Id = 0
Serial Num = --------
Vendor = SUN
Model = T4 Storage
FwVers = 0342
strId = Primary
WWN = 5080020000b25d3d
Id = 1
Serial Num = --------
Vendor = SUN
Model = T4 Storage
FwVers = 0342
strId = Secondary
WWN = 5080020000b25d7d
Total number of PDs: 24
/dev/sdc SEAGATE HDD 600gb slot: 0 exp: 0
/dev/sdm SEAGATE HDD 600gb slot: 1 exp: 0
/dev/sdo HITACHI HDD 600gb slot: 2 exp: 1
/dev/sdy SEAGATE HDD 600gb slot: 3 exp: 1
/dev/sdd SEAGATE HDD 600gb slot: 4 exp: 0
/dev/sdn SEAGATE HDD 600gb slot: 5 exp: 0
/dev/sdp SEAGATE HDD 600gb slot: 6 exp: 1
/dev/sdz SEAGATE HDD 600gb slot: 7 exp: 1
/dev/sde SEAGATE HDD 600gb slot: 8 exp: 0
/dev/sdk SEAGATE HDD 600gb slot: 9 exp: 0
/dev/sdq SEAGATE HDD 600gb slot: 10 exp: 1
/dev/sdw SEAGATE HDD 600gb slot: 11 exp: 1
/dev/sdf SEAGATE HDD 600gb slot: 12 exp: 0
/dev/sdl SEAGATE HDD 600gb slot: 13 exp: 0
/dev/sdr SEAGATE HDD 600gb slot: 14 exp: 1
/dev/sdx SEAGATE HDD 600gb slot: 15 exp: 1
/dev/sdg SEAGATE HDD 600gb slot: 16 exp: 0
/dev/sdi SEAGATE HDD 600gb slot: 17 exp: 0
/dev/sds SEAGATE HDD 600gb slot: 18 exp: 1
/dev/sdu SEAGATE HDD 600gb slot: 19 exp: 1
/dev/sdh STEC SSD 73gb slot: 20 exp: 0
/dev/sdj STEC SSD 73gb slot: 21 exp: 0
/dev/sdt STEC SSD 73gb slot: 22 exp: 1
/dev/sdv STEC SSD 73gb slot: 23 exp: 1
==== END STORAGE DUMP =========
Outro comando bastante usado é o validate, que pode ser consultado utilizando o -h, conforme usamos no comando show.
[root@ODA_TST01 ~]# oakcli validate -h
Usage:
oakcli validate [-V | -l | -h]
oakcli validate [-v] [-f absolute output_file_name] [-a | -d | -c check1[,check2] [-ver <patch version>]]
ARGUMENTS:
-v verbose output
-f output_file_name.The output is sent to the file instead of standard output
-a run all checks
-d run only default checks.
-c check1[,check2] run specific checks
-l list the checks and description
-V Print the Version
-h print help
EXAMPLES:
oakcli validate -l
oakcli validate -a
oakcli validate -c OSDiskStorage
oakcli validate -c SharedStorage
oakcli validate -c StorageTopology
oakcli validate -c DiskCalibration
oakcli validate -c SystemComponents,NetworkComponents,asr
oakcli validate -c ospatch -ver 12.1.2.0.0
[root@ODA_TST01 ~]# oakcli validate -l
Checkname -- Description
========= ===========
*SystemComponents -- Validate system components based on ilom sensor data readings
*OSDiskStorage -- Validate OS disks and filesystem information
*SharedStorage -- Validate Shared storage and multipathing information
DiskCalibration -- Check disk performance with orion
*NetworkComponents -- Validate public and private network components
asr -- Validate asr components based on asr config file and ilom sensor data readings
ospatch -- Verifies whether OS patching could be successful or not
* -- These checks are also performed as part of default checks
[root@ODA_TST01 ~]#
[root@ODA_TST01 ~]# oakcli validate -c SystemComponents
INFO: oak system information and Validations
RESULT: System Software inventory details
Reading the metadata. It takes a while...
System Version Component Name Installed Version Supported Version
-------------- --------------- ------------------ -----------------
12.1.2.4.0
Controller 11.05.03.00 Up-to-date
Expander 0342 Up-to-date
SSD_SHARED E12B Up-to-date
HDD_LOCAL SA03 Up-to-date
HDD_SHARED {
[ c2d2 ] A700 A820
[ c2d0,c2d1,c2d3,c2d 0B25 Up-to-date
4,c2d5,c2d6,c2d7,c2d
8,c2d9,c2d10,c2d11,c
2d12,c2d13,c2d14,c2d
15,c2d16,c2d17,c2d18
,c2d19 ]
}
ILOM 3.0.16.22.f r100119 Up-to-date
BIOS 12010311 Up-to-date
IPMI 1.8.12.0 Up-to-date
HMP 2.3.2.4.1 Up-to-date
OAK 12.1.2.4.0 Up-to-date
OL 5.11 Up-to-date
GI_HOME 12.1.0.2.4(20831110, Up-to-date
20831113)
DB_HOME {
[ OraDb12102_home1 ] 12.1.0.2.4(20831110, Up-to-date
20831113)
[ OraDb11204_home1 ] 11.2.0.4.7(20760982, Up-to-date
20831122)
}
RESULT: System Information:-
Manufacturer:ORACLE CORPORATION
Product Name:SUN FIRE X4370 M2 SERVER
Serial Number:--------
RESULT: BIOS Information:-
Vendor:American Megatrends Inc.
Version:12010311
Release Date:04/10/2013
BIOS Revision:1.3
Firmware Revision:1.3
SUCCESS: Controller p1 has the IR Bypass mode set correctly
SUCCESS: Controller p2 has the IR Bypass mode set correctly
INFO: Reading ilom data, may take short while..
INFO: Read the ilom data. Doing Validations
RESULT: System ILOM Version: 3.0.16.22.f r100119
RESULT: System BMC firmware version 3.00
RESULT: Powersupply PS0 V_IN=116 Volts I_IN=3.12 Amps V_OUT=12 Volts I_OUT=27.60 Amps IN_POWER=380 Watts OUT_POWER=340 Watts
RESULT: Powersupply PS1 V_IN=124 Volts I_IN=2.88 Amps V_OUT=12 Volts I_OUT=26.60 Amps IN_POWER=360 Watts OUT_POWER=320 Watts
SUCCESS: Both the powersupply are ok and functioning
RESULT: Cooling Unit FM0 fan speed F0=3800 RPM F1=3300 RPM
RESULT: Cooling Unit FM1 fan speed F0=3800 RPM F1=3100 RPM
SUCCESS: Both the cooling unit are present
RESULT: Processor P0 present Details:-
Version:Intel(R) Xeon(R) CPU X5675 @ 3.07GHz
Current Speed:3066 MHz Core Enabled:2 Thread Count:4
SUCCESS: All 6 memory modules of CPU P0 ok, each module is of Size:8192 MB Type:DDR3 Speed:1333 MHz manufacturer:Samsung
RESULT: Processor P1 present Details:-
Version:Intel(R) Xeon(R) CPU X5675 @ 3.07GHz
Current Speed:3066 MHz Core Enabled:2 Thread Count:4
SUCCESS: All 6 memory modules of CPU P1 ok, each module is of Size:8192 MB Type:DDR3 Speed:1333 MHz manufacturer:Samsung
RESULT: Total System Memory is 98934312 kB
SUCCESS: All OS Disks are present and in ok state
SUCCESS: All expander present and ok status
SUCCESS: All shared Disks are present and in ok state
RESULT: Temperature System Board=35 degrees C||Riser Board=27 degrees C||Power Supply=23 degrees C
Mostrei apenas alguns dos comandos que podemos utilizar através do OAKCLI. Além de utilizar o parâmetro -h podemos e devemos sempre verificar a documentação.
https://docs.oracle.com/cd/E22693_01/doc.12/e55580/oakcli.htm#BABDCHFA
https://docs.oracle.com/cd/E68623_01/doc.121/e68637/GUID-17880D1D-A34F-4A2B-96DC-C86791A6A8F6.htm#CMTAR152
https://docs.oracle.com/cd/E68623_01/doc.121/e68637/GUID-17880D1D-A34F-4A2B-96DC-C86791A6A8F6.htm#CMTAR152

Comentários
Postar um comentário