Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
DBMCLI is the command-line management tool used for the Exadata storage server to configure Exadata database servers and manage objects in the server environment. With DBMCLI, it is possible to start and stop the server, start and stop the services on the server, manage server configuration information, and enable or disable servers. DBMCLI is available for Oracle Exadata database server version 12.1.2.1.0 and later.
Dmcli can be started with root as follows:
1 2 3 4 | [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. |
For detailed information about the server:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 | 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 |
List of all executable commands:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 | 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 |
To get help about the command :
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 | 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 } |
