Oracle Database Appliance consists of two physical servers (Node 0 and Node 1), a storage shelf and optionally an additional storage shelf. The two independent physical servers are interconnected and direct attached to SAS and SSD storage.
ODA is basically a 2-node RAC cluster database system running Oracle Linux operating (OEL), Oracle Database Enterprise Edition, Oracle Grid Infrastructure (Clusterware and ASM). All these together provides the Oracle Database high availability running on ODA.
In 2016, Oracle added 3 new models to expand Oracle Database Appliance portfolio. These 3 new models are:
- Oracle Database Appliance X6-2S (single-instance database)
- Oracle Database Appliance X6-2M (single-instance database)
- Oracle Database Appliance X6-2L (single-instance database)
The High Available ODA x6-2 is now known as X6-2 HA which consists of 2 nodes and a storage shelf and optionally an additional storage shelf.
Courtesy Oracle
The Oracle Database Appliance X6-2 model family offers the lowest hardware price for an Oracle Engineered System. Combined with flexible Oracle Database software licensing, the Oracle Database Appliance X6-2 model family brings Oracle Engineered Systems to within reach of every organization.
In October 2017, Oracle announced Oracle Database Appliance X7-2 (Small, Medium and HA). ODA X7-2 comes with more computing resources compared with X6-2 Models.
- Oracle Database Appliance X7-2S (single-instance database)
- Oracle Database Appliance X7-2M (single-instance database)
- Oracle Database Appliance X7-2 HA
Courtesy Oracle
Note: With ODA x7-2, looks like the ODA Large configuration is discontinued.
In this article we will demonstrate several different odacli and odaadmcli commands along with output that can be used to manage and administer an Oracle Database Appliance Small, Medium and Large models.
ODACLI: It is used for Hardware and administrative tasks on the Oracle Database Appliance, Example: Hardware monitoring and Storage Configuration
ODAADMICLI: It is used for everyday task on the Oracle Database Appliance, Example: Database Creation, Patches and upgrades, Job creation and manage and so on
ODACLI Commands
- To display list of commands and options that can be used with odacli execute the following command
[root@odanode1 ~]# odacli -h
odacli <command> <options>
Commands list (use --help option for help on any command):
appliance:
create-appliance
describe-appliance
asr:
configure-asr
delete-asr
describe-asr
test-asr
update-asr
component:
describe-component
cpucore:
describe-cpucore
list-cpucores
update-cpucore
credential:
set-credential
database:
create-database
delete-database
describe-database
list-databases
register-database
dbhome:
create-dbhome
delete-dbhome
describe-dbhome
list-dbhomes
update-dbhome
dbstorage:
create-dbstorage
delete-dbstorage
describe-dbstorage
list-dbstorages
dcsagent:
update-dcsagent
job:
describe-job
list-jobs
latestpatch:
describe-latestpatch
network:
create-network
delete-network
describe-network
list-networks
update-network
networkinterface:
describe-networkinterface
list-networkinterfaces
repository:
update-repository
server:
update-server
- To describe ODA execute the following command
[root@odanode1 ~]# odacli describe-appliance
Appliance Information
----------------------------------------------------------------
ID: 9aef262c-xxxx-xxxx-xxxx-0d877c03d762
Platform: ODA
Data Disk Count: 2
CPU Core Count: 10
Created: May 23, 2017 3:08:03 AM CST
System Information
----------------------------------------------------------------
Name: odanode
Domain Name: netsoftmate.com
Time Zone: Asia/Pacific
DB Edition: EE
DNS Servers: 10.1.1.1
NTP Servers: ntp1.netsoftmate.com
Disk Group Information
----------------------------------------------------------------
DG Name Redundancy Percentage
------------------------- ------------------------- ------------
Data Normal 80
Reco Normal 20
--details, -d
Detail Info
- To describe ODA in details execute the following command
[root@odanode1 ~]# odacli describe-appliance -d
Appliance Information
----------------------------------------------------------------
ID: 9aef262c-xxxx-xxxx-xxxx-0d877c03d762
Platform: ODA
Data Disk Count: 2
CPU Core Count: 10
Created: May 23, 2017 3:08:03 AM CST
System Information
----------------------------------------------------------------
Name: odanode
Domain Name: netsoftmate.com
Time Zone: Asia/Pacific
DB Edition: EE
DNS Servers: 10.1.1.1
NTP Servers: ntp1.netsoftmate.com
Disk Group Information
----------------------------------------------------------------
DG Name Redundancy Percentage
------------------------- ------------------------- ------------
Data Normal 80
Reco Normal 20
DcsCli Details
----------------------------------------------------------------
Version: 12.1.2.10-SNAPSHOT
BuildNumber: jenkins-ol-dcs-cli-release-13
GitNumber: f91373b8574e383e033301d82b8424115350d065
BuildTime: null
DcsAgent Details
----------------------------------------------------------------
Version: 12.1.2.10-SNAPSHOT
BuildNumber: jenkins-ol-dcs-agent-release-31
GitNumber: fb8b1776013457d4d80d7acac3ad96fa5ca52327
BuildTime: null
- To list ASR details execute the following command
[root@odanode1 ~]# odacli describe-asr
ASR details
----------------------------------------------------------------
ID: b8606dd5-99b4-xxxx-aabd-be8cd422754c
Name: ASR
ASR Type: Internal
External ASR Manager IP :
UserName: john.smith@example.com
ProxyServerName: www-proxy.example.com
ProxyPort: 80
ProxyUserName:
SnmpVersion: V3
State: Configured
Created: May 23, 2017 3:08:03 AM CST
Updated: May 23, 2017 3:42:43 AM CST
Options :
--json, -j
json output
- To list CPU Cores execute the following command
[root@odanode1 ~]# odacli list-cpucores
Node Cores Modified Job Status
----- ------ ------------------------------ ---------------
0 10 May 23, 2017 10:58:52 AM CST Configured
Options:
--json, -j
json output
- To list all the job configured and to check their status execute the following command
[root@odanode1 ~]# odacli list-jobs
ID Description Created Status
---------------------------------------- --------------------------------------------------------------------------- ----------------------------------- ----------
65b60824-cb18-4fec-bdec-baf7e440efc9 Provisioning service creation May 23, 2017 3:08:03 AM CST Success
74d38c8e-98aa-4ff3-9b04-ef96bdfd35bd Database service deletion with db name: demodb1 with id : c0cdc82d-02e5-4980-9952-36b6d4adf28a May 23, 2017 4:01:02 PM CST Success
26de75bb-e525-4356-9828-6056d55b5f56 Database Home OraDB12102_home1 Deletion with id 8f5944b1-e953-4c78-89f4-ba4daa8110ca May 23, 2017 4:04:59 PM CST Success
--json, -j
json output
- To list the patches for all the ODA components execute the following command
[root@odanode1 ~]# odacli describe-latestpatch
componentType availableVersion
--------------- --------------------
gi 12.1.0.2.170117
db 11.2.0.4.161018
db 12.1.0.2.170117
oak 12.1.2.10.0
ilom 3.2.8.24.r114611
os 6.8
bios 38070000
Options :
--json, -j
json output
- To list all the network details execute the following command
[root@odanode1 ~]# odacli list-networks
ID Name NIC IP Address Subnet Mask Gateway
---------------------------------------- -------------------- ---------- ------------------ ------------------ ------------------
49976a55-4e1a-440a-94c3-289b69d9afcc Private-network priv0 192.168.16.24 255.255.255.240
219953e6-3473-46f9-b21b-53e89bc8cf49 Public-network btbond1.198 10.10.10.18 255.255.255.0 10.1.1.2
- To list all the network interfaces execute the following command
[root@odanode1 ~]# odacli list-networkinterfaces
ID Name NIC Type
---------------------------------------- -------------------- ------------- ----------
724e42a6-c9f7-xxxx-9e34-7b0952f8e3e1 btbond1 btbond1 Bond
543aba2a-0cb0-xxxx-b23a-3f035aa401c0 btbond1.198 btbond1.198 Bond
18933aa5-b02d-xxxx-a31b-5ad988d6396b em1 em1 Physical
ce059f61-7529-xxxx-9cd4-ef94fdd3ec54 em2 em2 Physical
2622ea10-508a-xxxx-86a8-351fe0a58e6f p3p1 p3p1 Physical
8ddd6b36-ff32-xxxx-9d1f-a90c14216bf7 p3p2 p3p2 Physical
f03a424e-8c7e-xxxx-901f-3b81f9642cfa sfpbond1 sfpbond1 Bond
ODAADMCLI Commands
- To display list of commands and options that can be used with odaadmcli execute the following command
[root@odanode1 ~]# odaadmcli -h
Usage: odaadmcli <command> <object> [<options>]
commands: show|manage|stordiag|power|expand
objects : disk|diskgroup|controller|server|processor|memory|iraid|power|cooling|network|storage|fs|raidsyncstatus|env_hw
Usage: odaadmcli show - Shows disk, diskgroup, controller, server, processor, memory, iraid, power, cooling, network, storage, fs, raidsyncstatus, env_hw
odaadmcli manage - Manages the OAK repository, diagcollect etc.,
odaadmcli stordiag - Run storage diagnostic tool on this Node
odaadmcli power - Power on|off|status disk
odaadmcli expand - Expand storage
- To display list of commands and options that can be used with odaadmcli show execute the following command
[root@odanode1 ~]# odaadmcli show -h
Usage:
odaadmcli show {disk|diskgroup|fs|raidsyncstatus|controller|storage|env_hw|server|processor|memory|iraid|power|cooling|network} [<options>]
where:
disk - About the disk
diskgroup - ASM disk group
fs - Filesystem
controller - Controller
storage - All storage components
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
raidsyncstatus - RAID sync status information
For detailed help on each command and object and its options use:
odaadmcli <command> <object> -h
- To list local disk on compute node execute the following command
[root@odanode1 ~]# odaadmcli show disk
NAME PATH TYPE STATE STATE_DETAILS
pd_00 /dev/nvme0n1 NVD ONLINE Good
pd_01 /dev/nvme1n1 NVD ONLINE Good
- To list all shared disk execute the following command
[root@odanode1 ~]# odaadmcli show disk -shared
NAME PATH TYPE STATE STATE_DETAILS
pd_00 /dev/nvme0n1 NVD ONLINE Good
pd_01 /dev/nvme1n1 NVD ONLINE Good
- To list ASM Disk Groups execute the following command
[root@odanode1 ~]# odaadmcli show diskgroup
DiskGroups
----------
DATA
RECO
- To list details of an ASM Disk Group execute the following command
[root@odanode1 ~]# odaadmcli show diskgroup DATA
ASM_DISK PATH DISK STATE STATE_DETAILS
data_00 /dev/NVD_S00_S2LHNA0HC05601p1 pd_00 ONLINE Good
data_01 /dev/NVD_S01_S2LHNA0HC05809p1 pd_01 ONLINE Good
ASM_DISK PATH DISK STATE STATE_DETAILS
reco_00 /dev/NVD_S00_S2LHNA0HC05601p2 pd_00 ONLINE Good
reco_01 /dev/NVD_S01_S2LHNA0HC05809p2 pd_01 ONLINE Good
- To list file system details execute the following command
[root@odanode1 ~]# odaadmcli show fs
Type Total Space Free Space Total DG Space Free DG Space Diskgroup Mount Point
ext3 30109M 13215M - - /
ext3 476M 405M - - /boot
ext3 60347M 43274M - - /opt
ext3 302252M 235296M - - /u01
acfs 5120M 5071M 4894016M 70220M DATA /opt/oracle/dcs/commonstore
acfs 2406400M 1699624M 4894016M 70220M DATA /u02/app/oracle/oradata/datastore
acfs 306176M 292685M 1231176M 14372M RECO /u01/app/oracle/fast_recovery_area/datastore
acfs 302080M 294707M 1231176M 14372M RECO /u01/app/oracle/oradata/datastore
- To list storage details execute the following command
[root@odanode1 ~]# odaadmcli show storage
==== BEGIN STORAGE DUMP ========
Host Description: Oracle Corporation:ORACLE SERVER X6-2
Total number of controllers: 2
Id = 0
Pci Slot = 10
Serial Num = xxxxxxxxxx
Vendor = Samsung
Model = MS1PC2DD3ORA3.2T
FwVers = KPYABR3Q
strId = nvme:19:00.00
Pci Address = 19:00.0
Id = 1
Pci Slot = 11
Serial Num = xxxxxxxxxxx
Vendor = Samsung
Model = MS1PC2DD3ORA3.2T
FwVers = KPYABR3Q
strId = nvme:1b:00.00
Pci Address = 1b:00.0
Total number of expanders: 0
Total number of PDs: 2
/dev/nvme0n1 Samsung NVD 3200gb slot: 0 pci : 19
/dev/nvme1n1 Samsung NVD 3200gb slot: 1 pci : 1b
==== END STORAGE DUMP =========
- To ODA hardware details execute the following command
[root@odanode1 ~]# odaadmcli show env_hw
BM ODA X6-2 Small
- To list ODA server details execute the following command
[root@odanode1 ~]# odaadmcli show server
Power State : On
Open Problems : 0
Model : ODA X6-2S
Type : Rack Mount
Part Number : ODA X6-2S
Serial Number : xxxxxxxxx
Primary OS : Not Available
ILOM Address : 10.10.10.11
ILOM MAC Address : 00:10:E0:BF:1C:38
Description : Oracle Database Appliance X6-2 Small xxxxxxx
Locator Light : Off
Actual Power Consumption : 135 watts
Ambient Temperature : 27.000 degree C
Open Problems Report : System is healthy
- To check processor status the following command
[root@odanode1 ~]# odaadmcli show processor
NAME HEALTH HEALTH_DETAILS PART_NO. LOCATION MODEL MAX_CLK_SPEED TOTAL_CORES ENABLED_CORES
- To check Memory status execute the following command
[root@odanode1 ~]# odaadmcli show memory
NAME HEALTH HEALTH_DETAILS PART_NO. SERIAL_NO. LOCATION MANUFACTURER MEMORY_SIZE CURR_CLK_SPEED ECC_Errors
DIMM_11 OK - 3A4K40BB1-CRC 00CE02164433E986FB P0/D1 Samsung 32 GB 2400 MHz 0
DIMM_3 OK - 3A4K40BB1-CRC 00CE02164433E9863B P0/D3 Samsung 32 GB 2400 MHz 0
DIMM_8 OK - 3A4K40BB1-CRC 00CE02164433E98689 P0/D8 Samsung 32 GB 2400 MHz 0
- To check raid status execute the following command
[root@odanode1 ~]# odaadmcli show iraid
NAME CTRL# PRODUCT SERIAL_NO BIOS_VER FW_VER VDISK_TYPE VDISK_STATE PDISK_MODEL EID:SLT PDISK_STATE SIZE
CV_MODEL CV_STATE CV_TEMP
IR_0_0_0 0 LSI MegaRAID 9361-8i SV62214495 6.17.04.2_4.16.08.00_0x06060A 4.230.40-3739 RAID1 Optl MS4SC2JH2ORA480G 252:0 Onln 446.102 GB
CVPM02 Optimal 27C
IR_0_0_1 0 LSI MegaRAID 9361-8i SV62214495 6.17.04.2_4.16.08.00_0x06060A 4.230.40-3739 RAID1 Optl MS4SC2JH2ORA480G 252:1 Onln 446.102 GB
CVPM02 Optimal 27C
- To check power status execute the following command
[root@odanode1 ~]# odaadmcli show power
NAME HEALTH HEALTH_DETAILS PART_NO. SERIAL_NO. LOCATION INPUT_POWER OUTPUT_POWER INLET_TEMP EXHAUST_TEMP
Power_Supply_1 OK - 7079395 476856Z+1644CE000A PS1 Present 56 watts 27.000 degree C 32.938 degree C
- To check network status execute the following command
[root@odanode1 ~]# odaadmcli show network
NAME HEALTH HEALTH_DETAILS LOCATION PART_NO MANUFACTURER MAC_ADDRESS LINK_DETECTED DIE_TEMP
Ethernet_NIC_1 OK - NET1 X540 INTEL 00:10:E0:BF:1C:35 yes (em2) 61.250 degree C
Ethernet_NIC_2 - - NET2 X540 INTEL 90:E2:BA:D9:7D:B9 no (p3p2) -
Ethernet_NIC_3 - - NET3 X540 INTEL 90:E2:BA:D9:7D:B8 no (p3p1) -
Conclusion
In this article we have learned about Oracle Database Appliance X6-2 and X7-2 model family. Also we have learned how to use the odacli and odaadmcli command line utilities to manage and administer an Oracle Database Appliance. odacli is used for Hardware and administrative tasks on the Oracle Database Appliance, Example: Hardware monitoring and Storage Configuration whereas odaadmcli is used for everyday task on the Oracle Database Appliance, Example: Database Creation, Patches and upgrades, Job creation and manage and so on.
Very useful docs Thanks
ReplyDeleteRafi
You are welcome! Please continue to follow our blog for more such articles.
Delete