Oracle Exadata Database Machine Command-Line Interface (DBMCLI)

DBMCLI , Exadata veritabanı sunucularını yapılandırmak ve sunucu ortamındaki nesneleri yönetmek için Exadata storage server için kullanılan cellcli benzeri , komut satırı yönetim aracıdır. DBMCLI, ile sunucuyu başlatmak ve durdurmak, sunucu üzerindeki servisleri başlatmak ve durdurmak, sunucu yapılandırma bilgilerini yönetmek ve sunucuları etkinleştirmek veya devre dışı bırakmak mümkündür. DBMCLI, Oracle Exadata veritabanı sunucusu için 12.1.2.1.0 versiyonlu imaj ve sonrasında bulunmaktadır.

dmcli , root ile aşağıdaki gibi başlatılabilir.

[root@exadb01 ~]# dbmcli
DBMCLI: Release - Production on Fri Aug 03 11:50:11 EET 2018

Copyright (c) 2007, 2016, Oracle and/or its affiliates. All rights reserved.

Sunucu hakkında detalı bilgi için :

DBMCLI> list dbserver detail
name: exadb01
bbuStatus: normal
coreCount: 44/44
cpuCount: 88/88
diagHistoryDays: 7
fanCount: 16/16
fanStatus: normal
id: 1234NM10BL
interconnectCount: 2
interconnect1: ib0
interconnect2: ib1
ipaddress1: 192.168.10.1/22
ipaddress2: 192.168.10.2/22
kernelVersion: 4.1.12-61.33.1.el6uek.x86_64
locatorLEDStatus: off
makeModel: Oracle Corporation ORACLE SERVER X6-2
metricHistoryDays: 7
msVersion: OSS_12.2.1.1.1_LINUX.X64_170419
notificationMethod: mail
notificationPolicy: critical,warning,clear
powerCount: 2/2
powerStatus: normal
releaseImageStatus: success
releaseVersion: 12.2.1.1.1.170419
releaseTrackingBug: 25512521
smtpFrom: "Exadata"
smtpFromAddr: exa@interiva.com 
smtpPort: 25
smtpServer: relay.interiva.com
smtpToAddr: exadata@interiva.com
smtpUseSSL: FALSE
status: online
temperatureReading: 20.0
temperatureStatus: normal
upTime: 206 days, 11:54
msStatus: running
rsStatus: running

Tüm çalıştırılabilecek komutların listesi :

DBMCLI> help

HELP [topic]
Available Topics:
ALTER
ALTER ALERTHISTORY
ALTER DBSERVER
ALTER IBPORT
ALTER THRESHOLD
ALTER USER
CREATE
CREATE DBSERVER
CREATE DIAGPACK
CREATE ROLE
CREATE THRESHOLD
CREATE USER
DESCRIBE
DOWNLOAD DIAGPACK
DROP
DROP ALERTHISTORY
DROP DBSERVER
DROP ROLE
DROP THRESHOLD
DROP USER
GRANT
GRANT PRIVILEGE
GRANT ROLE
LIST
LIST ALERTDEFINITION
LIST ALERTHISTORY
LIST DBSERVER
LIST DIAGPACK
LIST IBPORT
LIST LUN
LIST METRICCURRENT
LIST METRICDEFINITION
LIST METRICHISTORY
LIST PHYSICALDISK
LIST ROLE
LIST THRESHOLD
LIST USER
REVOKE
REVOKE PRIVILEGE
REVOKE ROLE
SET
SPOOL
START

Komut ile ilgili yardım almak için : 

DBMCLI> help LIST

  Usage: LIST <object_type> [<name> | <filters>] [<attribute_list>] [DETAIL] \
         [ORDER BY <order_by_attribute_list>] [LIMIT integer]
  Purpose: The LIST command displays attributes for Oracle Exadata Server Software objects.
           Objects displayed are identified by name or by filters.
           The attributes displayed for each object are determined by the specified attribute list.

  Arguments:
    <object_type>:  The type of existing object to be displayed.
    <name>:  The name of the active request to be displayed.
    <filters>:  an expression which determines which active requests should
                be displayed.
    <attribute_list>: The attributes that are to be displayed.
                      ATTRIBUTES {ALL | attr1 [, attr2]... }
    <order_by_attribute_list>: The attributes that are to be ordered by.
                               {attr1 [asc|desc] [, attr2 [asc|desc]]}

  Options:
    [DETAIL]: Formats the display as an attribute on each line, with
              an attribute descriptor preceding each value.
    [ORDER BY]: Orders the objects by attributes in ascending or descending order.
                The default is ascending.
    [LIMIT]: Sets the number of displayed objects.

  Enter HELP LIST <object_type> for specific help syntax.
    <object_type>:  {ALERTHISTORY | ALERTDEFINITION | DBSERVER 
                     | IBPORT | LUN 
                     | METRICCURRENT | METRICDEFINITION | METRICHISTORY 
                     | PHYSICALDISK | ROLE | THRESHOLD | USER }