[root@x5odadb0 ~]# oakcli -h
Usage: oakcli show
- Shows disk, diskgroup, expander, controller, server, processor, memory, iraid, power, cooling, network, ib,
enclosure, vlan, storage, version, dbhomes, dbstorage, databases, db_config_params, VM, VMtemplate,
VMconsole, CPU pool, Repo, env_hw, ASR, VDisk
oakcli configure - Configures the Network or ASR or VM or VMtemplate or CPU pool or Repo or Additional Net
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 import - Imports a VMtemplate given image files and repository,
oakcli clone - Clones a VM given VMtemplate name and repository (or)
- Clones a VM given a VM (or)
- Clones a VM given a VMtemplate (or)
- Clones a VDisk given a VDisk
oakcli start - Starts the Repo, VM
oakcli stop - Stops the Repo, VM
oakcli modify - Manage VDisks and VLAN Networks for the User VMs or resize Database parameters
oakcli create - Creates CPU pool, Database, DB storage, snapshotdb, dbhome, db_config_params file, VLAN, Shared Repo, VDisk
oakcli delete - Deletes CPU pool, VM, VMtemplate, Database, DB Storage, dbhome, db_config_params file, VLAN, Shared Repo, VDisk
oakcli resize - Resizes DB Storage
oakcli migrate - Migrates a VM to other Node
在ODA_BASE上查看相关配置信息[root@x5odadb0 ~]# oakcli show -h
Usage:
oakcli show {disk|diskgroup|expander|fs|controller|server|processor|memory|iraid|power|cooling|network|ib|enclosure|vlan|storage|version|dbhomes|dbstorage|databases|db_config_params|vm|vmtemplate|vmconsole|cpupool|repo|asr|env_hw|vdisk} [<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
vm - VM
vmconsole - VMconsole
vmtemplate - VMtemplate
cpupool - CPU Pool details
repo - All repositories
vlan - User defined and default networks
vdisk - Shows all VDisks in all Repos
For detailed help on each command and object and its options use:
oakcli <command> <object> -h
[root@x5odadb0 ~]#
[root@x5odadb0 ~]# oakcli show diskNAME PATH TYPE STATE STATE_DETAILS e0_pd_00 /dev/sda HDD ONLINE Good e0_pd_01 /dev/sdb HDD ONLINE Good e0_pd_02 /dev/sdc HDD ONLINE Good e0_pd_03 /dev/sdd HDD ONLINE Good e0_pd_04 /dev/sde HDD ONLINE Good e0_pd_05 /dev/sdf HDD ONLINE Good e0_pd_06 /dev/sdg HDD ONLINE Good e0_pd_07 /dev/sdaa HDD ONLINE Good e0_pd_08 /dev/sdab HDD ONLINE Good e0_pd_09 /dev/sdac HDD ONLINE Good e0_pd_10 /dev/sdad HDD ONLINE Good e0_pd_11 /dev/sdae HDD ONLINE Good e0_pd_12 /dev/sdaf HDD ONLINE Good e0_pd_13 /dev/sdag HDD ONLINE Good e0_pd_14 /dev/sdah HDD ONLINE Good e0_pd_15 /dev/sdai HDD ONLINE Good e0_pd_16 /dev/sdaj SSD ONLINE Good e0_pd_17 /dev/sdam SSD ONLINE Good e0_pd_18 /dev/sdan SSD ONLINE Good e0_pd_19 /dev/sdak SSD ONLINE Good e0_pd_20 /dev/sdal SSD ONLINE Good e0_pd_21 /dev/sdao SSD ONLINE Good e0_pd_22 /dev/sdap SSD ONLINE Good e0_pd_23 /dev/sdaq SSD ONLINE Good [root@x5odadb0 ~]#[root@x5odadb0 ~]# oakcli show diskgroup
DiskGroups ---------- DATA FLASH RECO REDO [root@x5odadb0 ~]#[root@x5odadb0 ~]# oakcli show server
Power State : On Open Problems : 0 Model : ODA X5-2 Type : Rack Mount Part Number : 34459999+1+1 Serial Number : 169GHFJ999 Primary OS : Not Available ILOM Address : 172.16.10.209 ILOM MAC Address : 00:10:E0:BA:E7:8C Description : Oracle Database Appliance X5-2 169GHFJ999 Locator Light : Off Actual Power Consumption : 311 watts Ambient Temperature : 19.250 degree C Open Problems Report : System is healthy[root@x5odadb0 ~]# 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@x5odadb0 ~]#[root@x5odadb0 ~]# oakcli show memory
NAME HEALTH HEALTH_DETAILS PART_NO. SERIAL_NO. LOCATION MANUFACTURER MEMORY_SIZE CURR_CLK_SPEED ECC_Errors DIMM_0 OK - 6A4G99999-CPB 999999999999999999 P0/D0 Samsung 32 GB 2133 MHz 0 DIMM_11 OK - 6A4G99999-CPB 00CE02162532BA4812 P0/D1 Samsung 32 GB 2133 MHz 0 DIMM_12 OK - 6A4G99999-CPB 00CE02162532BA4815 P1/D0 Samsung 32 GB 2133 MHz 0 DIMM_15 OK - 6A4G99999-CPB 00CE02162532BA4811 P1/D3 Samsung 32 GB 2133 MHz 0 DIMM_20 OK - 6A4G99999-CPB 00CE02162532BA4810 P1/D8 Samsung 32 GB 2133 MHz 0 DIMM_23 OK - 6A4G99999-CPB 00CE02162532BA4DF1 P1/D1 Samsung 32 GB 2133 MHz 0 DIMM_3 OK - 6A4G99999-CPB 00CE02162532BA4127 P0/D3 Samsung 32 GB 2133 MHz 0 DIMM_8 OK - 6A4G99999-CPB 00CE02162532BA4126 P0/D8 Samsung 32 GB 2133 MHz 0 [root@x5odadb0 ~]#[root@x5odadb0 ~]# oakcli show network
NAME HEALTH HEALTH_DETAILS LOCATION PART_NO MANUFACTURER MAC_ADDRESS LINK_DETECTED DIE_TEMP Ethernet_NIC_0 OK - NET0 X540 INTEL 00:10:E0:BA:E7:88 yes (eth0) 60.500 degree C Ethernet_NIC_1 OK - NET1 X540 INTEL 00:10:E0:BA:E7:89 yes (eth1) 60.750 degree C Ethernet_NIC_2 OK - NET2 X540 INTEL 00:10:E0:BA:E7:8A yes (eth2) 55.250 degree C Ethernet_NIC_3 OK - NET3 X540 INTEL 00:10:E0:BA:E7:8B yes (eth3) 55.000 degree C [root@x5odadb0 ~]#[root@x5odadb0 ~]# oakcli show vlan
NAME ID INTERFACE NODENUM net1 1 bond0 0 net1 1 bond0 1 net2 1 bond1 0 net2 1 bond1 1 vbr1 1 virtual 0 vbr1 1 virtual 1[root@x5odadb0 ~]# oakcli show storage
==== BEGIN STORAGE DUMP ======== Host Description: Xen:ORACLE SERVER X5-2 Total number of controllers: 2 Id = 0 Serial Num = Vendor = LSI Logic Model = ORCL-EXT-SAS3 FwVers = 09.00.00.00 strId = mpt3sas:00:04.0 Id = 1 Serial Num = Vendor = LSI Logic Model = ORCL-EXT-SAS3 FwVers = 09.00.00.00 strId = mpt3sas:00:05.0 Total number of expanders: 2 Id = 0 Serial Num = Vendor = ORACLE Model = DE2-24C FwVers = 0018 strId = Primary WWN = Id = 1 Serial Num = Vendor = ORACLE Model = DE2-24C FwVers = 0018 strId = Secondary WWN = Total number of PDs: 24 /dev/sda LSI Logic HDD 7865gb slot: 0 exp: 0 /dev/sdb LSI Logic HDD 7865gb slot: 1 exp: 0 /dev/sdc LSI Logic HDD 7865gb slot: 2 exp: 0 /dev/sdd LSI Logic HDD 7865gb slot: 3 exp: 0 /dev/sde LSI Logic HDD 7865gb slot: 4 exp: 0 /dev/sdf LSI Logic HDD 7865gb slot: 5 exp: 0 /dev/sdg LSI Logic HDD 7865gb slot: 6 exp: 0 /dev/sdaa LSI Logic HDD 7865gb slot: 7 exp: 0 /dev/sdab LSI Logic HDD 7865gb slot: 8 exp: 0 /dev/sdac LSI Logic HDD 7865gb slot: 9 exp: 0 /dev/sdad LSI Logic HDD 7865gb slot: 10 exp: 0 /dev/sdae LSI Logic HDD 7865gb slot: 11 exp: 0 /dev/sdaf LSI Logic HDD 7865gb slot: 12 exp: 0 /dev/sdag LSI Logic HDD 7865gb slot: 13 exp: 0 /dev/sdah LSI Logic HDD 7865gb slot: 14 exp: 0 /dev/sdai LSI Logic HDD 7865gb slot: 15 exp: 0 /dev/sdaj LSI Logic SSD 400gb slot: 16 exp: 0 /dev/sdam LSI Logic SSD 400gb slot: 17 exp: 0 /dev/sdan LSI Logic SSD 400gb slot: 18 exp: 0 /dev/sdak LSI Logic SSD 400gb slot: 19 exp: 0 /dev/sdal LSI Logic SSD 200gb slot: 20 exp: 0 /dev/sdao LSI Logic SSD 200gb slot: 21 exp: 0 /dev/sdap LSI Logic SSD 200gb slot: 22 exp: 0 /dev/sdaq LSI Logic SSD 200gb slot: 23 exp: 0 ==== END STORAGE DUMP ========= [root@x5odadb0 ~]#系统校验
[root@x5odadb0 ~]# oakcli validate -a
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.9.0
Controller_INT 4.230.40-3739 Up-to-date
Controller_EXT 09.00.00.00 Up-to-date
Expander 0018 Up-to-date
SSD_SHARED {
[ c1d20,c1d21,c1d22, A29A Up-to-date
c1d23 ]
[ c1d16,c1d17,c1d18, A29A Up-to-date
c1d19 ]
}
HDD_LOCAL A720 A72A
HDD_SHARED P9E2 Up-to-date
ILOM 3.2.7.26.a r112579 Up-to-date
BIOS 30090200 Up-to-date
IPMI 1.8.12.4 Up-to-date
HMP 2.3.5.2.5 Up-to-date
OAK 12.1.2.9.0 Up-to-date
OL 6.8 Up-to-date
OVM 3.2.11 Up-to-date
GI_HOME 12.1.0.2.161018(2400 Up-to-date
6101,23854735)
DB_HOME 11.2.0.4.161018(2400 Up-to-date
6111,23054319)
RESULT: System Information:-
Manufacturer:Oracle Corporation
Product Name:ORACLE SERVER X5-2
Serial Number:
RESULT: BIOS Information:-
...
INFO: About to run random read IOPS throughput tests for SASDisk
RESULT: Random read throughput across all 16 SASDisk = 1763 IOPS
INFO: About to run random read IOPS throughput tests for SSDDisk
RESULT: Random read throughput across all 8 SSDDisk = 87611 IOPS
INFO: About to run random read MBPS throughput tests for SASDisk
RESULT: Random read throughput across all 16 SASDisk = 1346 MBPS
INFO: About to run random read MBPS throughput tests for SSDDisk
RESULT: Random read throughput across all 8 SSDDisk = 4178 MBPS
INFO: Completed IOPS tests for individual disks of type SASDisk
INFO: Completed MBPS tests for individual disks of type SASDisk
INFO: Completed IOPS tests for individual disks of type SSDDisk
INFO: Completed MBPS tests for individual disks of type SSDDisk
INFO: Completed all single disk tests
INFO: Calibration results for SASDisk
RESULT: Random read throughput of HDD_E0_S05_1612344404 is 164 IOPS 142 MBPS
RESULT: Random read throughput of HDD_E0_S13_1612136304 is 159 IOPS 143 MBPS
RESULT: Random read throughput of HDD_E0_S12_1612137048 is 165 IOPS 142 MBPS
RESULT: Random read throughput of HDD_E0_S04_1612321172 is 170 IOPS 143 MBPS
RESULT: Random read throughput of HDD_E0_S15_1612242988 is 165 IOPS 143 MBPS
RESULT: Random read throughput of HDD_E0_S06_1612316556 is 164 IOPS 143 MBPS
RESULT: Random read throughput of HDD_E0_S02_1612134916 is 159 IOPS 143 MBPS
RESULT: Random read throughput of HDD_E0_S11_1611067952 is 157 IOPS 142 MBPS
RESULT: Random read throughput of HDD_E0_S10_1612355220 is 168 IOPS 145 MBPS
RESULT: Random read throughput of HDD_E0_S08_1612271224 is 166 IOPS 142 MBPS
RESULT: Random read throughput of HDD_E0_S09_1612322144 is 165 IOPS 142 MBPS
RESULT: Random read throughput of HDD_E0_S00_1612291584 is 167 IOPS 144 MBPS
RESULT: Random read throughput of HDD_E0_S01_1612292572 is 162 IOPS 144 MBPS
RESULT: Random read throughput of HDD_E0_S03_1612244532 is 167 IOPS 142 MBPS
RESULT: Random read throughput of HDD_E0_S14_1612349508 is 166 IOPS 143 MBPS
RESULT: Random read throughput of HDD_E0_S07_1612344420 is 169 IOPS 145 MBPS
INFO: Calibration results for SSDDisk
RESULT: Random read throughput of SSD_E0_S17_1320347600 is 89384 IOPS 821 MBPS
RESULT: Random read throughput of SSD_E0_S18_1320344696 is 88693 IOPS 822 MBPS
RESULT: Random read throughput of SSD_E0_S20_1320464144 is 89456 IOPS 831 MBPS
RESULT: Random read throughput of SSD_E0_S21_1320467632 is 90334 IOPS 833 MBPS
RESULT: Random read throughput of SSD_E0_S23_1320469008 is 90578 IOPS 834 MBPS
RESULT: Random read throughput of SSD_E0_S16_1320344604 is 89801 IOPS 821 MBPS
RESULT: Random read throughput of SSD_E0_S19_1320344516 is 89582 IOPS 819 MBPS
RESULT: Random read throughput of SSD_E0_S22_1320467808 is 91220 IOPS 831 MBPS
INFO: Doing oak network checks
RESULT: Detected active link for interface eth0 with link speed 1000Mb/s and cable type as TwistedPair
RESULT: Detected active link for interface eth1 with link speed 1000Mb/s and cable type as TwistedPair
RESULT: Detected active link for interface eth2 with link speed 1000Mb/s and cable type as TwistedPair
RESULT: Detected active link for interface eth3 with link speed 1000Mb/s and cable type as TwistedPair
INFO: Checking bonding interface status
RESULT: No Bond Interface Found
SUCCESS: ibbond0 is running 192.168.16.27
It may take a while. Please wait...
INFO : ODA Topology Verification
INFO : Running on Node0
INFO : Check hardware type
SUCCESS : Type of hardware found : X5-2
INFO : Check for Environment(Bare Metal or Virtual Machine)
SUCCESS : Type of environment found : Virtual Machine(ODA BASE)
SUCCESS : Number of External SCSI controllers found : 2
INFO : Check for Controllers correct PCIe slot address
SUCCESS : External LSI SAS controller 0 : 00:04.0
SUCCESS : External LSI SAS controller 1 : 00:05.0
INFO : Check if JBOD powered on
SUCCESS : 1JBOD : Powered-on
INFO : Check for correct number of EBODS(2 or 4)
SUCCESS : EBOD found : 2
INFO : Check for External Controller 0
SUCCESS : Controller connected to correct EBOD number
SUCCESS : Controller port connected to correct EBOD port
SUCCESS : Overall Cable check for controller 0
INFO : Check for External Controller 1
SUCCESS : Controller connected to correct EBOD number
SUCCESS : Controller port connected to correct EBOD port
SUCCESS : Overall Cable check for Controller 1
INFO : Check for overall status of cable validation on Node0
SUCCESS : Overall Cable Validation on Node0
INFO : Check Node Identification status
SUCCESS : Node Identification
SUCCESS : Node name based on cable configuration found : NODE0
INFO : Check JBOD Nickname
SUCCESS : JBOD Nickname set correctly : Oracle Database Appliance - E0
INFO : The details for Storage Topology Validation can also be found in the log file=/opt/oracle/oak/log/x5odadb0/storagetopology/StorageTopology-2017-05-20-18:15:41_54767_20524.log
INFO: oak Asr information and Validations
INFO: ASR not configured. Exit...
DEBUG: oakInfiniBand: Doing Infiniband validations.....
INFO: Active IPOB Interfaces = ib0 ib1 ibbond0
RESULT: Module Status Validation successful
INFO: Max QP values = 982976
RESULT: Max Qp Validation Successful
DEBUG: checkStatus: Checking Port Status
RESULT: Both ports are in ACTIVE state
[root@x5odadb0 ~]# oakcli manage diagcollect --all
Collecting CRS data
Collecting information from core files
There are no corefiles
Collecting OCR data
ORACLE BASE is not specified or Invalid. Will try to get correct ORACLE BASE
Get valid ORACLE BASE /u01/app/grid
Collecting ORACLE BASE data
/bin/tar: diag/asm/+asm/+ASM1/trace: file changed as we read it
Collecting ORACLE HOME data
Collecting Oracle Diagnostic logs
/bin/tar: Removing leading `/' from member names
Collecting scan listener logs
/bin/tar: Removing leading `/' from member names
Collecting TFA logs
/bin/tar: Removing leading `/' from member names
Collecting OS logs
Collecting Oracle installation logs
Logs are at : /opt/oracle/oak/onecmd/tmp/invtData_x5odadb0_20170520_1818.tar.gz
Collecting sysconfig data
Collecting OSW logs..
Collecting oak data. It will take a while, please wait...
tar: /opt/oracle/oak/onecmd/tmp/OakCli.log: file changed as we read it
Logs are collected to: /opt/oracle/oak/onecmd/oakdiag/
######### Log Collection Finished.#######
[root@x5odadb0 ~]#
oakcli数据库常用操作[root@x5odadb0 ~]# oakcli delete database -db test
INFO: 2017-05-11 09:14:31: Look at the log file '/opt/oracle/oak/log/x5odadb0/tools/12.1.2.9.0/deletedatabase_ptest_91239.log' for more details Please enter the 'SYS' password : Please re-enter the 'SYS' password: INFO: 2017-05-11 09:14:57: Setting up SSH ......... SUCCESS: All nodes in /opt/oracle/oak/onecmd/tmp/db_nodes are pingable and alive. INFO: 2016-05-11 09:15:57: SSH has been successfully established INFO: 2016-05-11 09:17:15: Successfully deleted the database 'test' INFO: 2016-05-11 09:17:20: Attempting to cleanup the SNAP entries for the database: ptest INFO: 2016-05-11 09:17:20: Successfully deleted the SNAP entries [root@x5odadb0 ~]#[root@x5odadb0 ~]# oakcli show dbhomes
Oracle Home Name Oracle Home version Home Location ---------------- ------------------- ------------ OraDb12102_home1 12.1.0.2.161018(24006101,23854735) /u01/app/oracle/product/12.1.0.2/dbhome_1 OraDb12102_home2 12.1.0.2.161018(24006101,23854735) /u01/app/oracle/product/12.1.0.2/dbhome_2 [root@x5odadb0 ~]# oakcli delete dbhome -oh OraDb12102_home2 [root@x5odadb0 ~]# oakcli show dbhomes Oracle Home Name Oracle Home version Home Location ---------------- ------------------- ------------ OraDb12102_home1 12.1.0.2.161018(24006101,23854735) /u01/app/oracle/product/12.1.0.2/dbhome_1 [root@x5odadb0 ~]# oakcli delete dbhome -oh OraDb12102_home1 SUCCESS: All nodes in /opt/oracle/oak/onecmd/tmp/db_nodes are pingable and alive. SUCCESS: 2017-05-11 09:31:01: Successfully deinstalled the dbhome OraDb12102_home1 [root@x5odadb0 ~]#[root@x5odadb0 12.1.2.9.0]# oakcli show db_config_params -detail
The available DB configuration files are : db12c DATABASE_BLOCK_SIZE => 16384 DATABASE_LANGUAGE => AMERICAN DATABASE_CHARACTERSET => ZHS16GBK DATABASE_TERRITORY => CHINA COMPONENT_LANGUAGES => en NLS_NCHAR_CHARACTERSET => AL16UTF16 default DATABASE_BLOCK_SIZE => 8192 DATABASE_LANGUAGE => AMERICAN DATABASE_CHARACTERSET => AL32UTF8 DATABASE_TERRITORY => AMERICA COMPONENT_LANGUAGES => en NLS_NCHAR_CHARACTERSET => AL16UTF16 [root@x5odadb0 12.1.2.9.0]#oakcli创建数据库
如果不指定-oh，默认会创建一个新的ORACLE_HOME
[root@x5odadb0 ~]# oakcli show dbhomes
Oracle Home Name Oracle Home version Home Location
---------------- ------------------- ------------
OraDb11204_home1 11.2.0.4.161018(24006111,23054319) /u01/app/oracle/product/11.2.0.4/dbhome_1
[root@x5odadb0 ~]#
[root@x5odadb0 ~]#
[root@x5odadb0 ~]# oakcli create database -db pgold -oh /u01/app/oracle/product/11.2.0.4/dbhome_1 -version 11.2.0.4.161018 -params db12c
-oh && -version are exclusive
Usage:
oakcli create database -db <db_name> [[[-oh <home>] | [-version <version>]] [-params <params_file>] [-cdb]]
where:
db_name - Name of the database to be created.
home - Existing oracle home for creating the database. By default we create a new database home.
version - Database Version information for creating the database home. [ex. 11.2.0.2.7] If not provided create the database home from latest available bits.
params_file - Name of the db_config_parameter file [This file can be created using using 'oakcli create db_config_params'].
If not provided, create the database using default configuration file
cdb - Creates this database as a container database
[root@x5odadb0 ~]# oakcli create database -db pgold -oh /u01/app/oracle/product/11.2.0.4/dbhome_1 -params db12c
生成orachk报告[root@x5odadb0 ~]# oakcli orachk
http://docs.oracle.com/cd/E86648_01/index.htm
http://docs.oracle.com/cd/E22693_01/doc.12/e55580/vmadmin.htm
