DBMCLI commands for Exadata
98 commands, grouped by what they do.
Check status and configuration
dbmcli -e "LIST DBSERVER DETAIL"Displays detailed attributes for the Exadata database server managed by DBMCLI. It is read-only and includes server status, services, Exascale client-side services where applicable, and DB-server configuration metadata.
dbmcli -e "LIST DBSERVER ATTRIBUTES status,upTime,releaseVersion,msStatus,rsStatus"Lists database server status, uptime, Exadata release, and the status of management and restart services. It is read-only and helps confirm whether the DB server management plane is online after maintenance.
dbmcli -e "LIST DIAGPACK ATTRIBUTES ALL"Lists diagnostic package records with all available attributes. It is read-only and helps identify package names, status, alert associations, host names, and collection timing before download or cleanup decisions.
dbmcli -e "LIST DBSERVER ATTRIBUTES httpsAccess"Displays the httpsAccess attribute for the Exadata database server. This shows which hosts or subnets are allowed to reach the Exadata RESTful service over HTTPS; it is read-only.
dbmcli -e "LIST ALERTHISTORY ORDER BY beginTime DESC LIMIT 20"Lists the 20 most recent database-server alert-history entries by begin time. It is a read-only triage command for quickly seeing recent hardware, ADR, BMC, or metric alerts.
dbmcli -e "LIST PHYSICALDISK"Lists the physical disks (hard, flash, PMEM) on an Exadata database server with their names and status. Read-only inventory/health check used to confirm disks are present and normal, or to find a disk flagged for replacement.
dbmcli -e "LIST DBSERVER ATTRIBUTES name,status,releaseVersion,kernelVersion"Lists the database server name, status, Exadata software release, and kernel version. It is a read-only inventory check for comparing node software state during patching or support triage.
dbmcli -e "LIST PHYSICALDISK WHERE status != 'normal' DETAIL"Lists detailed physical disk records whose status is not normal. It is a read-only DBMCLI health check for surfacing failed, predictive-failure, missing, or otherwise abnormal disk state on the database server.
dbmcli -e "LIST ALERTHISTORY WHERE endTime = null"Lists database server alert history entries whose endTime is null, which targets alerts that have not recorded an end time. It is a read-only filter for finding currently open or uncleared alert history entries.
dbmcli -e "LIST DBSERVER DETAIL" && imageinfoRuns a detailed DBMCLI database-server listing and then prints local Exadata image information if the first command succeeds. It is a read-only shell chain for tying management-layer DB server state to the installed server image.
dbmcli -e "LIST ALERTHISTORY DETAIL"Lists detailed alert history entries from the Exadata database server management layer. It is read-only evidence for recent warnings, critical alerts, and cleared conditions on the DB node.
dbmcli -e "LIST ALERTHISTORY WHERE severity = 'critical' DETAIL"Displays database server alert history entries with critical severity in detail format. It narrows alert review to the highest-severity entries and shows populated attributes for each matching alert.
dbmcli -e "LIST ALERTHISTORY"Lists alert history entries that occurred on the Exadata database server. The default output provides a quick read of alert history without changing alert state or configuration.
dbmcli -e "LIST ALERTHISTORY DETAIL LIMIT 20"Displays up to 20 database server alert history entries in detail format. DETAIL shows populated attributes on separate lines, making individual alert evidence easier to read than the default tabular output.
dbmcli -e "LIST DBSERVER ATTRIBUTES name,status,ipaddress,locatorLEDStatus"Lists selected attributes for the Exadata database server object, including server name, status, IP address, and locator LED state. It is a focused read-only inventory check for identifying the DB node and confirming its management state.
dbmcli -e "LIST ALERTHISTORY WHERE severity = 'warning' DETAIL"Lists detailed database-server alert-history entries whose severity is warning. It is a read-only way to focus alert review on non-critical warnings that may still need operational attention.
dbmcli -e "LIST DBSERVER DETAIL LIMIT 20"Lists detailed attributes for the database server object, limited to the first 20 rows of output where applicable. It is read-only and surfaces server identity, hardware status, notification settings, management-service state, and other DBSERVER attributes.
dbmcli -e "LIST METRICCURRENT"Lists the current metric observations for the local Exadata database server from DBMCLI, point-in-time values such as temperatures, fan speeds, memory, and power for the DB node's hardware and management objects. Read-only; it queries the management server and changes nothing.
dbmcli -e "LIST IBPORT"Lists InfiniBand Network Fabric ports known to DBMCLI on the database server. It is a concise read-only check for port presence and state before requesting detailed port attributes.
dbmcli -e "LIST LUN WHERE status != 'normal' DETAIL"Lists detailed LUN records whose status is not normal. It is a read-only health check for quickly surfacing LUN problems that may need disk, controller, or support investigation.
dbmcli -e "LIST PHYSICALDISK DETAIL LIMIT 20"Lists the physical disks attached to the Exadata database server in DETAIL form (status, slot, serial, size, firmware), capped at 20 rows. Read-only; the primary check for failed or predictive-failure disks in a DB node.
LIST PHYSICALDISK WHERE diskType=flashdisk AND status != 'normal' DETAILLists flash physical disks on an Exadata database server whose status is not normal, with detailed hardware attributes. This corrects a spelling error in the Maintenance Guide text, whose example command uses PHYSICALDISK.
dbmcli -e "LIST IBPORT DETAIL"Displays detailed attributes for InfiniBand Network Fabric ports on the Exadata database server. It is the detailed form of LIST IBPORT and is useful when the summary output is not enough for troubleshooting.
dbmcli -e "LIST DBSERVER ATTRIBUTES coreCount"Displays the active physical CPU core count configured for the local Exadata database server. It is read-only and is commonly used before or after capacity-on-demand core-count changes.
dbmcli -e "LIST METRICCURRENT DS_FSUT"Lists the current value of the DS_FSUT metric on the Exadata database server, file-system utilization for the DB-node management partitions. Read-only; a targeted query of one named metric rather than the full metric set.
dbmcli -e "LIST LUN"Lists LUN objects visible to the Exadata database server. The default output is a quick read-only summary of LUN identifiers and status.
dbmcli -e "LIST METRICCURRENT DS_CPUT"Displays the current DS_CPUT metric for the database server. The metric is a read-only current observation of DB server CPU utilization reported through DBMCLI.
dbmcli -e "LIST LUN DETAIL LIMIT 20"Lists detailed LUN attributes on an Exadata database server, limited to 20 entries. It is read-only and shows fields such as device name, disk type, size, RAID level, UID, and status.
dbmcli -e "LIST LUN DETAIL"Lists detailed LUN attributes on an Exadata database server. It is read-only and shows fields such as device name, disk type, size, RAID level, UID, and status for each LUN.
dbmcli -e "LIST METRICCURRENT DETAIL LIMIT 20"Lists current metric observations for the Exadata database server with full detail (metric name, object, value, collection time). Read-only; the live counterpart to METRICHISTORY for spot-checking DB-node metrics. LIMIT 20 caps output.
dbmcli -e "LIST METRICCURRENT WHERE objectType = 'DBSERVER' DETAIL"Lists current metric observations whose object type is DBSERVER, using DETAIL format. It is read-only and returns detailed current metric fields for database server objects.
dbmcli -e "LIST DBSERVER ATTRIBUTES ALL"Displays all attributes of the DBSERVER object on the Exadata database server, identity, software/image version, status, hardware identifiers, and management configuration. Read-only inspection of the DB-node management plane.
dbmcli -e "LIST METRICCURRENT WHERE objectType = 'IBPORT' DETAIL"Lists current metric observations for InfiniBand/RoCE port objects on an Exadata database server, with full detail. Read-only; surfaces live per-port counters (e.g. throughput, errors) used to spot fabric problems on the DB node.
dbmcli -e "LIST METRICCURRENT WHERE objectType = 'PHYSICALDISK' DETAIL"Lists current metrics for the Exadata database server filtered to the PHYSICALDISK object type, with full detail. Read-only; narrows the metric set to the DB node's physical disks. Distinct from the unfiltered METRICCURRENT form by its objectType filter.
dbmcli -e "LIST ALERTHISTORY ATTRIBUTES ALL"Lists database server alert history and requests all available attributes in column output. It is read-only and useful when the default alert history output omits fields needed for analysis.
dbmcli -e "LIST PHYSICALDISK ATTRIBUTES ALL"Lists all displayed attributes for physical disks known to DBMCLI on an Exadata database server. It is a read-only hardware inventory and health query for disk status, identity, firmware, and related metadata.
dbmcli -e "LIST METRICHISTORY WHERE name LIKE 'DB_%%' DETAIL LIMIT 100"Lists detailed DBMCLI metric history rows whose metric name matches the DB_ prefix, capped at 100 rows. It is a read-only way to review recent database-server metric observations without dumping the full history repository.
dbmcli -e "DESCRIBE ALERTHISTORY"Displays the attributes available for DBMCLI ALERTHISTORY objects on an Exadata database server. Read-only metadata command used before building LIST ALERTHISTORY filters or reports.
dbmcli -e "LIST METRICCURRENT ATTRIBUTES ALL"Lists current database-server metric observations with all available attributes. It is read-only and useful for seeing current metric names, values, object names, alert states, and collection times.
dbmcli -e "LIST IBPORT DETAIL LIMIT 20"Shows detailed attributes for up to 20 InfiniBand Network Fabric ports known to DBMCLI on the database server. The LIMIT clause keeps the result manageable while preserving detailed port state.
dbmcli -e "LIST METRICDEFINITION"Lists the metric definitions available on the Exadata database server from DBMCLI, the catalog of metric names, what each measures, and its unit. Read-only; use it to learn which metrics exist before querying METRICCURRENT or METRICHISTORY.
dbmcli -e "LIST METRICHISTORY DETAIL LIMIT 20"Shows detailed metric history rows from DBMCLI while limiting output to 20 entries. It is a read-only way to inspect recent metric-history shape and values without producing a large dump.
dbmcli -e "LIST DIAGPACK DETAIL LIMIT 20"Lists detailed diagnostic package records on the Exadata database server and limits the output to 20 objects. It is read-only and shows package names, status, alert context, and related metadata.
dbmcli -e "LIST ALERTDEFINITION"Lists alert definitions available on the Exadata database server. It shows the alert sources that can be produced by the server and is read-only.
dbmcli -e "DESCRIBE METRICCURRENT"Lists the attributes available for current DBMCLI metric observations on an Exadata database server. Use it to confirm fields such as metric value, object type, collection time, and alert state before querying LIST METRICCURRENT.
dbmcli -e "LIST THRESHOLD DETAIL LIMIT 20"Displays up to 20 DBMCLI threshold objects in detail format on an Exadata database server. Use it to inspect warning and critical threshold rules that drive database server alerts; it does not change the thresholds.
dbmcli -e "LIST LUN ATTRIBUTES ALL"Lists all available attributes for LUN objects visible through DBMCLI on the database server. It is a read-only storage inventory check for correlating LUN names, devices, status, and physical disk relationships.
dbmcli -e "LIST ALERTDEFINITION DETAIL"Lists database-server alert definitions in detailed format. It is read-only and shows alert metadata such as source, type, description, metric name, and identifier.
dbmcli -e "LIST IBPORT ATTRIBUTES ALL"Lists all available DBMCLI IBPORT attributes for database-server fabric ports. It is read-only and useful for checking link state, counters, firmware, and related RDMA fabric details.
dbmcli -e "LIST METRICDEFINITION DETAIL LIMIT 20"Lists DB-server metric definitions in DETAIL form (all attributes per metric, one attribute per line) and caps output at 20 rows with LIMIT. Read-only; the DETAIL modifier expands each metric's full attribute set while LIMIT keeps the result readable.
dbmcli -e "LIST ROLE DETAIL LIMIT 20"Lists detailed DBMCLI role records, limited to 20 rows. It is a read-only access-control inspection command for reviewing role names and privileges without changing users or grants.
dbmcli -e "DESCRIBE DBSERVER"Displays the attributes available for the DBMCLI DBSERVER object on an Exadata database server. Read-only metadata command used to see which server properties are visible or modifiable before LIST or ALTER DBSERVER work.
dbmcli -e "LIST METRICHISTORY ATTRIBUTES ALL"Lists metric history records with all attributes exposed by DBMCLI. It is read-only and useful when the default output omits fields needed for metric-history analysis or support evidence.
dbmcli -e "LIST USER DETAIL LIMIT 20"Displays detailed DBMCLI user information for Exadata database-server software users, capped at 20 rows. It is read-only and helps review roles and privileges before account or role changes.
dbmcli -e "LIST ALERTDEFINITION ATTRIBUTES ALL"Lists all attributes for alert definition objects known to DBMCLI. Use it to see the alert definitions available on the database server and the fields that describe how alerts are generated.
dbmcli -e "DESCRIBE PHYSICALDISK"Displays the attributes available for the DBMCLI PHYSICALDISK object on an Exadata database server. Use it to confirm valid field names before listing or filtering physical disk state.
dbmcli -e "LIST METRICDEFINITION ATTRIBUTES ALL"Lists all attributes for DBMCLI metric definition objects on the database server. Use it to review what each metric means, how it is configured, and which fields are available for monitoring queries.
dbmcli -e "LIST USER ATTRIBUTES ALL"Lists DBMCLI user records with all available attributes. It is used to review Exadata System Software users and their role assignments without changing access.
dbmcli -e "LIST THRESHOLD ATTRIBUTES ALL"Displays attributes for DBMCLI threshold objects. It is read-only and helps review warning or critical threshold configuration for metrics.
dbmcli -e "LIST ALERTDEFINITION DETAIL LIMIT 20"Displays up to 20 database server alert definitions in detail format. It is useful for seeing alert sources, descriptions, alert type, and related metric names without changing alert configuration.
dbmcli -e "DESCRIBE IBPORT"Displays the DBMCLI attribute list for InfiniBand Network Fabric port objects on a database server. Use it to see which IBPORT fields are available before building LIST filters or reports.
dbmcli -e "DESCRIBE THRESHOLD"Displays the DBMCLI attribute list for threshold objects on a database server. It shows fields such as comparison operator, warning and critical limits, observation count, and occurrences.
dbmcli -e "DESCRIBE METRICDEFINITION"Lists the attributes available for DBMCLI metric definitions on an Exadata database server. It shows the fields used to describe metric configuration, including type, unit, retention policy, and streaming state.
dbmcli -e "LIST ROLE ATTRIBUTES ALL"Displays all available attributes for DBMCLI roles. It is a read-only security inventory command for checking role definitions and privilege-related metadata.
dbmcli -e "DESCRIBE ALERTDEFINITION"Displays the DBMCLI attribute list for database-server alert definitions. It shows the fields available for alert sources, alert types, metric names, descriptions, and identifiers.
dbmcli -e list dbserver attributes rescuePlanPrints the rescuePlan attribute of the DB server, the saved set of DBMCLI commands needed to re-create the server's management configuration after a rescue/reimage. Read-only; usually redirected to a .cli file so the plan can be replayed during recovery.
dbmcli -e "DESCRIBE LUN"Lists the attributes available for the DBMCLI LUN object, such as device name, RAID level, size, and status. Run it before building LIST LUN filters or attribute lists for database server storage checks.
dbmcli -e "DESCRIBE ROLE"Lists the attributes available for DBMCLI role objects. It shows the role name and privileges fields so administrators can build role listing or privilege review commands accurately.
dbmcli -e "LIST METRICSTREAM DETAIL LIMIT 20"Lists the METRICSTREAM objects on the DB server in DETAIL form, capped at 20 rows, the metric-streaming configuration (collection endpoints, intervals, formats) used for automatic metric upload. Read-only; it shows how/where metrics are streamed, not the metric values themselves.
dbmcli -e "DESCRIBE DIAGPACK"Displays the DBMCLI attribute list for diagnostic package objects. Use it before LIST DIAGPACK queries to see which diagnostic package fields are available.
dbmcli -e "DESCRIBE METRICHISTORY"Displays the attribute list for the DBMCLI METRICHISTORY object. Use it before building LIST METRICHISTORY filters or attribute projections so the metric history query uses supported field names.
dbmcli -e "LIST METRICSTREAM ATTRIBUTES ALL"Lists all DBMCLI attributes for metric stream objects on the database server. Use it to review automatic metric streaming configuration, endpoints, and related metadata without changing the stream setup.
dbmcli -e "DESCRIBE USER"Lists the attributes available for DBMCLI user objects. It shows which fields, such as user name and roles, can be displayed for database server management accounts.
Start, stop and move
dbmcli -e alter dbserver startup services allStarts all DBMCLI-managed database server services through the DB server management plane. This changes service state and is used during recovery or maintenance workflows when Exadata database server services need to be brought back up.
dbmcli -e "ALTER DBSERVER SHUTDOWN SERVICES ALL"Stops all Exadata database server management services controlled through DBMCLI. This is a disruptive service-state change used in specific maintenance procedures, not a diagnostic query.
dbmcli -e "ALTER DBSERVER STARTUP SERVICES MS"Starts the Management Server service on the Exadata database server. It changes service state and is normally paired with a prior controlled MS shutdown or reconfiguration step.
dbmcli -e "ALTER DBSERVER SHUTDOWN SERVICES MS"Stops the Management Server service on the Exadata database server. This is a controlled maintenance action, commonly used before management-stack updates or reconfiguration.
dbmcli -e start /location/on/remote/server/rescue_db.cliRuns a DBMCLI script file (the previously saved rescuePlan, e.g. rescue_db.cli) to re-apply the database server's management configuration during a rescue/recovery. This executes every command in the file, so it writes configuration to the management server, only run it against the correct rescued node.
Create and change
dbmcli -e "CREATE DIAGPACK packStartTime=\"now\""Creates a diagnostic package from database-server logs and traces for the current time window. The archive is written under the DBMCLI diagnostic package area and can be listed or downloaded for support analysis.
dbmcli -e "ALTER ALERTHISTORY { ALL | alert_id [, alert_id ...] } examinedBy='name'"Updates attributes of one or all entries in a database server's alert history, primarily setting examinedBy to record that an operator has reviewed an alert. Read/modify of alert metadata only; does not clear alerts (that is DROP ALERTHISTORY). The equivalent command also exists in CellCLI for storage cells.
dbmcli -e "ALTER DBSERVER notificationMethod='mail,snmp'"Sets the database server alert notification method to use both email and SNMP. This changes how Exadata database-server alerts are delivered from the management server.
dbmcli -e "ALTER DBSERVER smtpFromAddr='<EMAIL_ADDRESS>'"Changes the database server email address used in the From header for Exadata alert notifications. The address is not authenticated with the email server, but it affects notification identity and routing expectations.
dbmcli -e "ALTER DBSERVER pendingCoreCount=<CORE_COUNT>"Sets the pending number of active CPU cores on an Exadata database server. The change may require a server restart to take effect and can affect capacity, power behavior, and licensing-sensitive operating posture.
dbmcli -e "ALTER DBSERVER mailServer='<MAIL_SERVER>'"Sets the email relay host used for database-server alert notifications. The original capture used smtpServer, but DBMCLI documents the modifiable DBSERVER attribute as mailServer.
dbmcli -e "ALTER DBSERVER notificationPolicy='critical,warning,clear'"Sets the notification policy on the Exadata database server so that alerts at the listed severities (critical, warning, clear) are sent through the configured notification channels. Writes a configuration change to the DB server's management/alerting plane.
dbmcli -e "ALTER DBSERVER pendingCoreCount=<new_core_count> FORCE"Sets the pending number of active CPU cores on an Exadata database server and forces the change when the runbook requires it. The setting affects capacity-on-demand or recovery workflows and usually takes effect with the required follow-up procedure.
dbmcli -e "ALTER DBSERVER smtpToAddr='<EMAIL_ADDRESS>'"Sets the email recipient address used by the Exadata database server management plane for alert notifications. This is a configuration change, not a database release feature, and should be verified on the target DB server before and after the change.
dbmcli -e "CREATE ROLE role_name" # then GRANT PRIVILEGE ... TO ROLE role_name (CellCLI or DBMCLI)Creates a named role in the cell or database-server security model that privileges can later be granted to (via GRANT PRIVILEGE ... TO ROLE) and which is then assigned to users with GRANT ROLE. Exists in both CellCLI (storage cell) and DBMCLI (database server); the role groups fine-grained LIST/action privileges on objects such as diagpack, dbserver, or metricstream. Writes new security metadata.
dbmcli -e "ALTER METRICDEFINITION { ALL | name [, name ...] } attribute_name=attribute_value [, ...] [ WHERE attribute_filters ]"Changes modifiable attributes of one or more database-server metric definitions in DBMCLI, most commonly enabling/disabling fine-grained collection (finegrained=enabled|disabled), metric streaming (streaming=enabled|disabled), or the retention policy (retentionPolicy). Writes the metric configuration on the database server (MS); does not delete collected data, but alters how/whether a metric is gathered and retained.
dbmcli -e "ALTER DBSERVER diagHistoryDays=<DAYS>"Changes how many days selected Exadata database server diagnostic files are retained. The setting participates in Management Server cleanup behavior, so lowering it can cause older eligible diagnostic files to be purged sooner.
dbmcli -e 'ALTER DBSERVER interconnect2 = "ib1"'Sets the database server interconnect2 attribute to ib1. This changes Exadata DB server interconnect metadata and should be used only when the target network mapping is known.
dbmcli -e "CREATE DBSERVER [name] [ interconnect1=value1 [, interconnect2=value2 ...] ] [ , ipaddress1=ip1 [, ipaddress2=ip2 ...] ]"Creates the DBSERVER object type on a database server in DBMCLI, defining its interconnect names and IP addresses (and optionally restricting HTTPS access to the RESTful MS server). Establishes the management-server representation of the database server. Writes server configuration.
dbmcli -e 'ALTER DBSERVER interconnect4 = "ib3"'Sets the database server interconnect4 attribute to ib3. This updates Exadata database server interconnect configuration metadata and should match the actual RDMA fabric layout.
dbmcli -e 'ALTER DBSERVER interconnect1 = "ib0"'Sets the database server interconnect1 attribute to ib0. This updates Exadata database server network configuration metadata used by the management stack, so the current values should be captured before any change.
dbmcli -e 'ALTER DBSERVER interconnect3 = "ib2"'Sets the database server interconnect3 attribute to ib2. This is a DBMCLI configuration change for the Exadata database server network fabric metadata.
Remove and drop
dbmcli -e "DROP THRESHOLD { ALL | threshold_name [, threshold_name ...] }" # also CellCLIRemoves all or the specified metric-alert thresholds from the database server (DBMCLI) or storage cell (CellCLI). Deletes the alerting configuration so the affected metrics no longer trigger threshold-based alerts. Available in both tools.
dbmcli -e "DROP ROLE role1 [, role2 ...]" # also CellCLIRemoves one or more roles from the database server or storage cell security model, even if the role has been granted to users. Available in both CellCLI and DBMCLI. Deletes the security object; users previously granted that role lose the privileges it conferred.
DROP DBSERVERResets the database-server Management Server configuration to its original state. Oracle documents that thresholds set for the database server are dropped and DBSERVER attributes return to default values.