[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 disk
NAME 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